class CreateOrders < ActiveRecord::Migration[6.0]
  def change
    create_table :orders do |t|
      t.string :sn, null: false
      t.integer :client_id, null: false
      t.datetime :due_date
      t.datetime :confirmed_at
      t.datetime :finished_at
      t.string :created_by
      t.integer :status, null: false
      t.text :remark

      t.timestamps
    end

    add_index :orders, :sn, :unique => true
  end
end