CreateUserQuestionAnswerTable::up()

Complexity

Conditions	2
Paths	2

Size

Total Lines	30
Code Lines	24

Duplication

Lines	0
Ratio	0 %

Importance

Changes	1
Bugs	0	Features	0

<?php
    public function up()
    {
        if (Schema::hasTable('user_question_answer')) return;
        
        Schema::create('user_question_answer', function (Blueprint $table) {
            $table->increments('id');
            $table->integer('user_id')->unsigned()->index();
            $table->integer('question_id')->unsigned()->index();
            $table->integer('question_choice_id')->unsigned()->index();
            $table->enum('is_right', [0, 1]);
            $table->dateTime('answer_time');
            $table->timestamps();

            $table->foreign('user_id')
                  ->references('id')
                  ->on('users')
                  ->onDelete('cascade')
                  ->onUpdate('cascade');

            $table->foreign('question_id')
                  ->references('id')
                  ->on('quiz_questions')
                  ->onDelete('cascade')
                  ->onUpdate('cascade');

            $table->foreign('question_choice_id')
                  ->references('id')
                  ->on('question_choices')
                  ->onDelete('cascade')
                  ->onUpdate('cascade');
        });