HomeAccounting

1
<?php
2

3
use Illuminate\Support\Facades\Schema;
4
use Illuminate\Database\Schema\Blueprint;
5
use Illuminate\Database\Migrations\Migration;
6

7
class Check extends Migration
8
{
9
    private $tableName = 'check';
10

11
    /**
12
     * Run the migrations.
13
     *
14
     * @return void
15
     */
16
    public function up()
17
    {
18
        Schema::create($this->tableName, function (Blueprint $table) {
19
            $table->increments('id');
20
            $table->unsignedInteger('user_id');
21
            $table->json('json');
22
            $table->timestamps();
23

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

27
        });
28
    }
29

30
    /**
31
     * Reverse the migrations.
32
     *
33
     * @return void
34
     */
35
    public function down()
36
    {
37
        Schema::dropIfExists($this->tableName);
38
    }
39
}
40