<?php
use Illuminate\Support\Facades\Schema;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Database\Migrations\Migration;
 
class Migrations20190306091702 extends Migration
{
  /**
   * Run the migrations.
   *
   * @return void
  */
  public function up()
  {
    Schema::create('ecommerce_orders', function (Blueprint $table) {
      $table->integer('id')->autoIncrement()->nullable(true);
      $table->integer('ecommerce_order_state_id')->nullable(true);
      $table->integer('contact_id')->nullable(true);
      $table->integer('delivery_address_id')->nullable(true);
      $table->integer('billing_address_id')->nullable(true)->unique();
      $table->timestamp('ordered_at')->nullable(true);
      $table->string('customer_note')->nullable(true);
      $table->string('internal_note')->nullable(true);
    });
    Schema::create('ecommerce_order_simple_items', function (Blueprint $table) {
      $table->integer('id')->autoIncrement()->nullable(true);
      $table->integer('ecommerce_order_id');
      $table->string('name',255);
      $table->float('quantity')->nullable(true);
    });
    Schema::create('ecommerce_order_items', function (Blueprint $table) {
      $table->integer('id')->autoIncrement()->nullable(true);
      $table->integer('ecommerce_order_id');
      $table->integer('product_id');
      $table->float('quantity')->nullable(true);
    });
    Schema::table('ecommerce_order_items', function (Blueprint $table) {
      $table->foreign('ecommerce_order_id')->references('id')->on('ecommerce_orders');
    });
    Schema::table('ecommerce_order_simple_items', function (Blueprint $table) {
      $table->foreign('ecommerce_order_id')->references('id')->on('ecommerce_orders');
    });
  }
  /**
   * Reverse the migrations.
   *
   * @return void
  */
  public function down()
  {
    Schema::table('ecommerce_order_simple_items', function (Blueprint $table) {
      $table->dropForeign(['ecommerce_order_id']);
    });
    Schema::table('ecommerce_order_items', function (Blueprint $table) {
      $table->dropForeign(['ecommerce_order_id']);
    });
    Schema::dropIfExists('ecommerce_orders');
    Schema::dropIfExists('ecommerce_order_simple_items');
    Schema::dropIfExists('ecommerce_order_items');
  }
}

<?php
namespace App\Models\Base;
use Illuminate\Database\Eloquent\Model;
 
class EcommerceOrder extends Model
{
  /**  
  * Do not automatically manage timestamps by Eloquent
  * 
  * @var bool
  */
  protected $timestamps=false;
  /**  
  * The attributes that should be cast to native types.
  * 
  * @var array
  */
  protected $casts=[
    'id'=>'integer',
    'ecommerce_order_state_id'=>'integer',
    'contact_id'=>'integer',
    'delivery_address_id'=>'integer',
    'billing_address_id'=>'integer',
    'ordered_at'=>'datetime',
    'customer_note'=>'string',
    'internal_note'=>'string'
  ];
  /**  
  * The guarded property should contain an array of attributes that you do not want to be mass assignable.
  * 
  * @var array
  */
  protected $is_guarded=['internal_note'];
  /**  
  * The attributes that are mass assignable.
  * 
  * @var array
  */
  protected $is_fillable=[
    'id',
    'ecommerce_order_state_id',
    'contact_id',
    'delivery_address_id',
    'billing_address_id',
    'ordered_at',
    'customer_note'
  ];
  public function Contact()
  {
    return $this->belongsTo('\App\Models\Contact','contact_id','id');
  }
  public function DeliveryAddress()
  {
    return $this->belongsTo('\App\Models\Address','delivery_address_id','id');
  }
  public function BillingAddress()
  {
    return $this->belongsTo('\App\Models\Address','billing_address_id','id');
  }
  public function OrderItem()
  {
    return $this->hasMany('\App\Models\EcommerceOrderItem','ecommerce_order_id','id');
  }
  public function OrderSimpleItem()
  {
    return $this->hasMany('\App\Models\EcommerceOrderSimpleItem','ecommerce_order_id','id');
  }
}

<?php
namespace App\Models;
 
class EcommerceOrder extends \App\Models\Base\EcommerceOrder
{
}