Guest User

Untitled

a guest
Aug 15th, 2018
74
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.91 KB | None | 0 0
  1. Schema::create('visits', function (Blueprint $table) {
  2. $table->increments('id');
  3. $table->datetime('date_time');
  4. $table->timestamps();
  5. });
  6.  
  7. Schema::create('evaluation_details', function (Blueprint $table) {
  8. $table->increments('id');
  9. $table->decimal('evaluation_rating',5,2);
  10.  
  11. $table->integer('departaments_id')->unsigned();
  12. $table->integer('visits_id')->unsigned();
  13. $table->integer('type_answer_id')->unsigned();
  14. $table->timestamps();
  15. $table->foreign('departaments_id')->references('id')
  16. ->on('departaments')
  17. ->onDelete('cascade');
  18. $table->foreign('visits_id')->references('id')
  19. ->on('visits')
  20. ->onDelete('cascade');
  21. $table->foreign('type_answers_id')->references('id')
  22. ->on('type_answers')
  23. ->onDelete('cascade');
  24. });
Add Comment
Please, Sign In to add comment