class CreatePayingDetails < ActiveRecord::Migration

  def self.up
    create_table "paying_details", :force => true do |t|
      t.integer  "paying_id",        :comment => '伝票番号'
      t.integer  "seq_number",       :comment => '枝番'
      t.column   "credit_type_code", :"SMALLINT(6)", :comment => '支払方法'
      t.integer  "amount",           :comment => '金額'
      t.integer  "bank_id",          :comment => '銀行'
      t.date     "bill_date",        :comment => '手形期日'
      t.string   "bill_number",      :limit => 12, :comment => '手形番号'
      t.string   "detail_note",      :limit => 200, :comment => '備考'
      t.datetime "created_at",       :comment => '作成日時'
      t.datetime "updated_at",       :comment => '更新日時'
    end
    execute "ALTER TABLE paying_details COMMENT = '支払明細'"
    add_index "paying_details", ["paying_id"], :name => "paying_id"
  end

  def self.down
    drop_table :paying_details
  end

end