CreateOrdersTable::up()

Complexity

Conditions	1
Paths	1

Size

Total Lines	29
Code Lines	21

Duplication

Lines	0
Ratio	0 %

Importance

Changes	1
Bugs	0	Features	0

<?php
    public function up()
    {
        Schema::create('orders', function (Blueprint $table) {
            $table->id();
            $table->unsignedBigInteger('user_id');
            $table->date('shipped_date')->nullable();
            $table->decimal('total_price');
            $table->decimal('shipping_price')->default(0);
            $table->text('id_shipping')->nullable();
            $table->text('note_delivery')->nullable();
            $table->boolean('pick_up_in_shop')->default(false);
            $table->decimal('order_weight')->default(0);


            $table->unsignedBigInteger('status_id');
            $table->unsignedBigInteger('payment_type_id');

            $table->string('telephone')->nullable();
            $table->string('address')->nullable();
            $table->string('province')->nullable();
            $table->string('city')->nullable();
            $table->string('cap')->nullable();

            $table->timestamps();

            //fk
            $table->foreign('user_id')->references('id')->on('users');
            $table->foreign('status_id')->references('id')->on('statuses_order');
            $table->foreign('payment_type_id')->references('id')->on('payment_type');
        });