class CreateBonuses < ActiveRecord::Migration[5.2]
  def up
    create_table :bonus do |t|
      t.references :trade, foreign_ky: true
      t.integer :sender_member_id, references: :members, foreign_key: { to_table: :members }
      t.integer :bonus_member_id, references: :members, foreign_key: { to_table: :members }
      t.decimal :amount, precision: 32, scale: 16
      t.integer :state, default: 0
      t.timestamps
      t.index [:trade_id, :sender_member_id], unique: true
    end
  end

  def down
    drop_table :bonus
  end
end