# This file is auto-generated from the current state of the database. Instead of editing this file, 
# please use the migrations feature of Active Record to incrementally modify your database, and
# then regenerate this schema definition.
#
# Note that this schema.rb definition is the authoritative source for your database schema. If you need
# to create the application database on another system, you should be using db:schema:load, not running
# all the migrations from scratch. The latter is a flawed and unsustainable approach (the more migrations
# you'll amass, the slower it'll run and the greater likelihood for issues).
#
# It's strongly recommended to check this file into your version control system.

ActiveRecord::Schema.define(:version => 20110106000002) do

  create_table "accept_order_details", :force => true do |t|
    t.integer  "accept_order_id"
    t.integer  "seq_number"
    t.integer  "product_category_id"
    t.integer  "product_set_id"
    t.integer  "product_id"
    t.string   "lot_number",          :limit => 20
    t.string   "serial_number",       :limit => 40
    t.date     "ubd"
    t.integer  "validity_period"
    t.integer  "unit_code",           :limit => 2
    t.integer  "quantity"
    t.integer  "stock_type_code",     :limit => 2
    t.string   "note",                :limit => 200
    t.datetime "created_at"
    t.datetime "updated_at"
  end

  add_index "accept_order_details", ["accept_order_id"], :name => "accept_order_id"
  add_index "accept_order_details", ["stock_type_code"], :name => "stock_type_code"

  create_table "accept_orders", :force => true do |t|
    t.integer  "rev_number"
    t.date     "input_date"
    t.date     "target_date"
    t.integer  "user_id"
    t.integer  "section_id"
    t.integer  "accept_order_trigger_code", :limit => 2
    t.integer  "order_type_code",           :limit => 2
    t.integer  "warehouse_id"
    t.integer  "user_position_id"
    t.integer  "sales_user_id"
    t.integer  "sales_area_id"
    t.integer  "sales_section_id"
    t.integer  "customer_id"
    t.integer  "supplier_id"
    t.integer  "shipment_customer_id"
    t.integer  "delivery_id"
    t.integer  "trucking_id"
    t.string   "receiver_name",             :limit => 20
    t.string   "request_time",              :limit => 20
    t.string   "customer_order_number",     :limit => 40
    t.date     "operate_date"
    t.string   "accept_order_note",         :limit => 200
    t.integer  "state_code",                :limit => 2
    t.string   "note",                      :limit => 200
    t.integer  "invalid_flag_code",         :limit => 2
    t.datetime "deleted_at"
    t.datetime "created_at"
    t.datetime "updated_at"
  end

  add_index "accept_orders", ["customer_id"], :name => "customer_id"
  add_index "accept_orders", ["invalid_flag_code"], :name => "invalid_flag_code"
  add_index "accept_orders", ["order_type_code"], :name => "order_type_code"
  add_index "accept_orders", ["sales_area_id"], :name => "sales_area_id"
  add_index "accept_orders", ["sales_section_id"], :name => "sales_section_id"
  add_index "accept_orders", ["sales_user_id"], :name => "sales_user_id"
  add_index "accept_orders", ["supplier_id"], :name => "supplier_id"
  add_index "accept_orders", ["target_date"], :name => "target_date"
  add_index "accept_orders", ["user_position_id"], :name => "user_position_id"
  add_index "accept_orders", ["warehouse_id"], :name => "warehouse_id"

  create_table "adjustment_details", :force => true do |t|
    t.integer  "adjustment_id"
    t.integer  "seq_number"
    t.integer  "stock_type_code",     :limit => 2
    t.integer  "product_category_id"
    t.integer  "product_set_id"
    t.integer  "product_id"
    t.string   "lot_number",          :limit => 20
    t.string   "serial_number",       :limit => 40
    t.date     "ubd"
    t.integer  "validity_period"
    t.integer  "unit_code",           :limit => 2
    t.integer  "quantity"
    t.string   "note",                :limit => 200
    t.datetime "created_at"
    t.datetime "updated_at"
  end

  add_index "adjustment_details", ["adjustment_id"], :name => "adjustment_id"
  add_index "adjustment_details", ["product_id"], :name => "product_id"
  add_index "adjustment_details", ["product_set_id"], :name => "product_set_id"

  create_table "adjustments", :force => true do |t|
    t.integer  "rev_number"
    t.date     "input_date"
    t.date     "target_date"
    t.integer  "user_id"
    t.integer  "section_id"
    t.integer  "warehouse_id"
    t.integer  "user_position_id"
    t.integer  "sales_user_id"
    t.integer  "sales_area_id"
    t.integer  "sales_section_id"
    t.integer  "customer_id"
    t.integer  "supplier_id"
    t.integer  "state_code",        :limit => 2
    t.string   "note",              :limit => 200
    t.integer  "invalid_flag_code", :limit => 2
    t.datetime "deleted_at"
    t.datetime "created_at"
    t.datetime "updated_at"
  end

  add_index "adjustments", ["customer_id"], :name => "customer_id"
  add_index "adjustments", ["invalid_flag_code"], :name => "invalid_flag_code"
  add_index "adjustments", ["sales_area_id"], :name => "sales_area_id"
  add_index "adjustments", ["sales_section_id"], :name => "sales_section_id"
  add_index "adjustments", ["sales_user_id"], :name => "sales_user_id"
  add_index "adjustments", ["supplier_id"], :name => "supplier_id"
  add_index "adjustments", ["target_date"], :name => "target_date"
  add_index "adjustments", ["user_position_id"], :name => "user_position_id"
  add_index "adjustments", ["warehouse_id"], :name => "warehouse_id"

  create_table "arriving_details", :force => true do |t|
    t.integer  "arriving_id"
    t.integer  "seq_number"
    t.integer  "product_category_id"
    t.integer  "product_set_id"
    t.integer  "product_id"
    t.string   "lot_number",          :limit => 20
    t.string   "serial_number",       :limit => 40
    t.date     "ubd"
    t.integer  "validity_period"
    t.integer  "unit_code",           :limit => 2
    t.integer  "quantity"
    t.integer  "shipping_type_code",  :limit => 2
    t.string   "note",                :limit => 200
    t.datetime "created_at"
    t.datetime "updated_at"
  end

  add_index "arriving_details", ["arriving_id"], :name => "arriving_id"
  add_index "arriving_details", ["product_id"], :name => "product_id"
  add_index "arriving_details", ["product_set_id"], :name => "product_set_id"
  add_index "arriving_details", ["shipping_type_code"], :name => "shipping_type_code"

  create_table "arrivings", :force => true do |t|
    t.integer  "order_id"
    t.integer  "rev_number"
    t.date     "input_date"
    t.date     "target_date"
    t.integer  "user_id"
    t.integer  "section_id"
    t.integer  "supplier_id"
    t.string   "invoice_number",    :limit => 20
    t.integer  "warehouse_id"
    t.integer  "state_code",        :limit => 2
    t.string   "note",              :limit => 200
    t.integer  "invalid_flag_code", :limit => 2
    t.datetime "print_check_date"
    t.datetime "deleted_at"
    t.datetime "created_at"
    t.datetime "updated_at"
  end

  add_index "arrivings", ["invalid_flag_code"], :name => "invalid_flag_code"
  add_index "arrivings", ["order_id"], :name => "order_id"
  add_index "arrivings", ["supplier_id"], :name => "supplier_id"
  add_index "arrivings", ["target_date"], :name => "target_date"
  add_index "arrivings", ["warehouse_id"], :name => "warehouse_id"

  create_table "customer_ledger_details", :force => true do |t|
    t.integer  "customer_ledger_id"
    t.integer  "deal_type_code",     :limit => 2
    t.integer  "trade_id"
    t.integer  "payment_id"
    t.integer  "carry_id"
    t.datetime "created_at"
    t.datetime "updated_at"
  end

  add_index "customer_ledger_details", ["carry_id"], :name => "carry_id"
  add_index "customer_ledger_details", ["customer_ledger_id"], :name => "customer_ledger_id"
  add_index "customer_ledger_details", ["deal_type_code"], :name => "deal_type_code"
  add_index "customer_ledger_details", ["payment_id"], :name => "payment_id"
  add_index "customer_ledger_details", ["trade_id"], :name => "trade_id"

  create_table "customer_ledgers", :force => true do |t|
    t.integer  "customer_id"
    t.integer  "customer_group_id"
    t.date     "target_date"
    t.integer  "black_price"
    t.integer  "red_price"
    t.integer  "adjust_price"
    t.integer  "total_price"
    t.integer  "total_duty"
    t.integer  "cash"
    t.integer  "bill"
    t.integer  "offset"
    t.integer  "fee"
    t.integer  "total_credit"
    t.integer  "total_carry"
    t.integer  "pre_total"
    t.integer  "total"
    t.datetime "print_sheet_date"
    t.datetime "created_at"
    t.datetime "updated_at"
  end

  add_index "customer_ledgers", ["customer_group_id"], :name => "customer_group_id"
  add_index "customer_ledgers", ["customer_id"], :name => "customer_id"
  add_index "customer_ledgers", ["target_date"], :name => "target_date"

  create_table "disposal_details", :force => true do |t|
    t.integer  "disposal_id"
    t.integer  "seq_number"
    t.integer  "product_category_id"
    t.integer  "product_set_id"
    t.integer  "product_id"
    t.string   "lot_number",          :limit => 20
    t.string   "serial_number",       :limit => 40
    t.date     "ubd"
    t.integer  "validity_period"
    t.integer  "unit_code",           :limit => 2
    t.integer  "quantity"
    t.string   "note",                :limit => 200
    t.datetime "created_at"
    t.datetime "updated_at"
  end

  add_index "disposal_details", ["disposal_id"], :name => "disposal_id"
  add_index "disposal_details", ["product_id"], :name => "product_id"
  add_index "disposal_details", ["product_set_id"], :name => "product_set_id"

  create_table "disposals", :force => true do |t|
    t.integer  "rev_number"
    t.integer  "disposal_id"
    t.date     "input_date"
    t.date     "target_date"
    t.integer  "user_id"
    t.integer  "section_id"
    t.integer  "warehouse_id"
    t.integer  "supplier_id"
    t.integer  "sign_type_code",    :limit => 2
    t.integer  "state_code",        :limit => 2
    t.string   "note",              :limit => 200
    t.integer  "invalid_flag_code", :limit => 2
    t.datetime "deleted_at"
    t.datetime "created_at"
    t.datetime "updated_at"
  end

  add_index "disposals", ["invalid_flag_code"], :name => "invalid_flag_code"
  add_index "disposals", ["supplier_id"], :name => "supplier_id"
  add_index "disposals", ["target_date"], :name => "target_date"
  add_index "disposals", ["warehouse_id"], :name => "warehouse_id"

  create_table "log_details", :force => true do |t|
    t.integer  "log_id"
    t.string   "table_name",    :limit => 80
    t.integer  "record_id"
    t.integer  "dml_type_code", :limit => 2
    t.string   "column_name",   :limit => 80
    t.string   "old_value",     :limit => 200
    t.string   "new_value",     :limit => 200
    t.datetime "created_at"
  end

  add_index "log_details", ["log_id"], :name => "log_id"

  create_table "logs", :force => true do |t|
    t.integer  "user_id"
    t.string   "table_name",    :limit => 80
    t.integer  "record_id"
    t.integer  "dml_type_code", :limit => 2
    t.datetime "created_at"
  end

  add_index "logs", ["table_name"], :name => "table_name"

  create_table "menu_categories", :force => true do |t|
    t.string   "name",       :limit => 200
    t.string   "disp_name",  :limit => 200
    t.integer  "disp_sort"
    t.datetime "created_at"
    t.datetime "updated_at"
  end

  create_table "menus", :force => true do |t|
    t.integer  "menu_category_id"
    t.string   "name",             :limit => 200
    t.string   "disp_name",        :limit => 200
    t.integer  "disp_sort"
    t.datetime "created_at"
    t.datetime "updated_at"
  end

  add_index "menus", ["menu_category_id"], :name => "menu_category_id"

  create_table "order_details", :force => true do |t|
    t.integer  "order_id"
    t.integer  "seq_number"
    t.integer  "product_category_id"
    t.integer  "product_set_id"
    t.integer  "product_id"
    t.string   "lot_number",          :limit => 20
    t.string   "serial_number",       :limit => 40
    t.date     "ubd"
    t.integer  "validity_period"
    t.integer  "unit_code",           :limit => 2
    t.integer  "quantity"
    t.integer  "stock_type_code",     :limit => 2
    t.string   "note",                :limit => 200
    t.datetime "created_at"
    t.datetime "updated_at"
  end

  add_index "order_details", ["order_id"], :name => "order_id"
  add_index "order_details", ["product_id"], :name => "product_id"
  add_index "order_details", ["product_set_id"], :name => "product_set_id"
  add_index "order_details", ["stock_type_code"], :name => "stock_type_code"

  create_table "orders", :force => true do |t|
    t.integer  "accept_order_id"
    t.integer  "rev_number"
    t.date     "input_date"
    t.date     "target_date"
    t.integer  "user_id"
    t.integer  "section_id"
    t.integer  "order_trigger_code",    :limit => 2
    t.integer  "order_type_code",       :limit => 2
    t.integer  "order_sheet_type_code", :limit => 2
    t.integer  "supplier_id"
    t.integer  "customer_id"
    t.integer  "shipment_customer_id"
    t.integer  "delivery_id"
    t.integer  "trucking_id"
    t.string   "receiver_name",         :limit => 20
    t.string   "request_time",          :limit => 20
    t.integer  "warehouse_id"
    t.integer  "own_warehouse_id"
    t.integer  "user_position_id"
    t.integer  "sales_user_id"
    t.integer  "sales_area_id"
    t.integer  "sales_section_id"
    t.date     "operate_date"
    t.integer  "state_code",            :limit => 2
    t.string   "order_note",            :limit => 200
    t.string   "note",                  :limit => 200
    t.integer  "invalid_flag_code",     :limit => 2
    t.datetime "print_sheet_date"
    t.datetime "deleted_at"
    t.datetime "created_at"
    t.datetime "updated_at"
  end

  add_index "orders", ["accept_order_id"], :name => "accept_order_id"
  add_index "orders", ["customer_id"], :name => "customer_id"
  add_index "orders", ["invalid_flag_code"], :name => "invalid_flag_code"
  add_index "orders", ["order_type_code"], :name => "order_type_code"
  add_index "orders", ["sales_area_id"], :name => "sales_area_id"
  add_index "orders", ["sales_section_id"], :name => "sales_section_id"
  add_index "orders", ["sales_user_id"], :name => "sales_user_id"
  add_index "orders", ["supplier_id"], :name => "supplier_id"
  add_index "orders", ["target_date"], :name => "target_date"
  add_index "orders", ["user_position_id"], :name => "user_position_id"
  add_index "orders", ["warehouse_id"], :name => "warehouse_id"

  create_table "payable_carry_remains", :force => true do |t|
    t.integer  "rev_number"
    t.date     "input_date"
    t.date     "target_date"
    t.integer  "user_id"
    t.integer  "section_id"
    t.integer  "supplier_id"
    t.integer  "supplier_group_id"
    t.integer  "credit_timing_code", :limit => 2
    t.integer  "cutoff_date_code",   :limit => 2
    t.integer  "currency_type_code", :limit => 2
    t.integer  "total_carry"
    t.integer  "state_code",         :limit => 2
    t.string   "note",               :limit => 200
    t.integer  "invalid_flag_code",  :limit => 2
    t.datetime "deleted_at"
    t.datetime "created_at"
    t.datetime "updated_at"
  end

  add_index "payable_carry_remains", ["invalid_flag_code"], :name => "invalid_flag_code"
  add_index "payable_carry_remains", ["supplier_group_id"], :name => "supplier_group_id"
  add_index "payable_carry_remains", ["supplier_id"], :name => "supplier_id"
  add_index "payable_carry_remains", ["target_date"], :name => "target_date"

  create_table "payable_details", :force => true do |t|
    t.integer  "payable_id"
    t.integer  "deal_type_code", :limit => 2
    t.integer  "trade_id"
    t.integer  "payment_id"
    t.integer  "carry_id"
    t.datetime "created_at"
    t.datetime "updated_at"
  end

  add_index "payable_details", ["carry_id"], :name => "carry_id"
  add_index "payable_details", ["deal_type_code"], :name => "deal_type_code"
  add_index "payable_details", ["payable_id"], :name => "payable_id"
  add_index "payable_details", ["payment_id"], :name => "payment_id"
  add_index "payable_details", ["trade_id"], :name => "trade_id"

  create_table "payables", :force => true do |t|
    t.integer  "supplier_id"
    t.integer  "supplier_group_id"
    t.date     "cutoff_date"
    t.date     "payment_date"
    t.integer  "payment_type_code",  :limit => 2
    t.integer  "currency_type_code", :limit => 2
    t.integer  "total_price"
    t.integer  "total_duty"
    t.integer  "total_payment"
    t.integer  "total_carry"
    t.integer  "pre_total"
    t.integer  "total"
    t.integer  "trade_sheet_cnt"
    t.datetime "print_ledger_date"
    t.datetime "created_at"
    t.datetime "updated_at"
  end

  add_index "payables", ["cutoff_date"], :name => "cutoff_date"
  add_index "payables", ["payment_date"], :name => "payment_date"
  add_index "payables", ["supplier_group_id"], :name => "supplier_group_id"
  add_index "payables", ["supplier_id"], :name => "supplier_id"

  create_table "paying_details", :force => true do |t|
    t.integer  "paying_id"
    t.integer  "seq_number"
    t.integer  "credit_type_code", :limit => 2
    t.integer  "amount"
    t.integer  "bank_id"
    t.date     "bill_date"
    t.string   "bill_number",      :limit => 12
    t.string   "note",             :limit => 200
    t.datetime "created_at"
    t.datetime "updated_at"
  end

  add_index "paying_details", ["paying_id"], :name => "paying_id"

  create_table "payings", :force => true do |t|
    t.integer  "rev_number"
    t.date     "input_date"
    t.date     "target_date"
    t.integer  "user_id"
    t.integer  "section_id"
    t.integer  "supplier_id"
    t.integer  "supplier_group_id"
    t.date     "cutoff_date"
    t.integer  "credit_timing_code", :limit => 2
    t.integer  "cutoff_date_code",   :limit => 2
    t.integer  "currency_type_code", :limit => 2
    t.integer  "total_amount"
    t.integer  "state_code",         :limit => 2
    t.string   "note",               :limit => 200
    t.integer  "invalid_flag_code",  :limit => 2
    t.datetime "deleted_at"
    t.datetime "created_at"
    t.datetime "updated_at"
  end

  add_index "payings", ["cutoff_date"], :name => "cutoff_date"
  add_index "payings", ["invalid_flag_code"], :name => "invalid_flag_code"
  add_index "payings", ["supplier_id"], :name => "supplier_id"
  add_index "payings", ["target_date"], :name => "target_date"

  create_table "purchase_details", :force => true do |t|
    t.integer  "purchase_id"
    t.integer  "seq_number"
    t.string   "product_barcode",     :limit => 40
    t.integer  "product_category_id"
    t.integer  "product_set_id"
    t.integer  "product_id"
    t.string   "lot_number",          :limit => 20
    t.string   "serial_number",       :limit => 40
    t.date     "ubd"
    t.integer  "validity_period"
    t.integer  "unit_code",           :limit => 2
    t.integer  "quantity"
    t.integer  "scheduled_quantity"
    t.decimal  "price",                              :precision => 16, :scale => 3
    t.integer  "stock_type_code",     :limit => 2
    t.integer  "inspect_status_code", :limit => 2
    t.string   "note",                :limit => 200
    t.datetime "created_at"
    t.datetime "updated_at"
  end

  add_index "purchase_details", ["product_id"], :name => "product_id"
  add_index "purchase_details", ["product_set_id"], :name => "product_set_id"
  add_index "purchase_details", ["purchase_id"], :name => "purchase_id"
  add_index "purchase_details", ["stock_type_code"], :name => "stock_type_code"

  create_table "purchases", :force => true do |t|
    t.integer  "accept_order_id"
    t.integer  "order_id"
    t.integer  "purchase_id"
    t.integer  "arriving_id"
    t.integer  "rev_number"
    t.date     "input_date"
    t.date     "target_date"
    t.integer  "user_id"
    t.integer  "section_id"
    t.integer  "purchase_trigger_code",   :limit => 2
    t.integer  "purchase_type_code",      :limit => 2
    t.integer  "supplier_id"
    t.integer  "payto_supplier_id"
    t.integer  "payto_supplier_group_id"
    t.string   "invoice_number",          :limit => 20
    t.integer  "warehouse_id"
    t.integer  "own_warehouse_id"
    t.integer  "user_position_id"
    t.integer  "sales_user_id"
    t.integer  "sales_area_id"
    t.integer  "sales_section_id"
    t.integer  "customer_id"
    t.integer  "currency_type_code",      :limit => 2
    t.decimal  "exchange_rate",                          :precision => 16, :scale => 2
    t.integer  "total_price"
    t.integer  "total_duty"
    t.integer  "duty_type_code",          :limit => 2
    t.integer  "duty_rate"
    t.integer  "price_duty_type_code",    :limit => 2
    t.integer  "duty_calc_type_code",     :limit => 2
    t.integer  "frac_digit_code",         :limit => 2
    t.integer  "fraction_method_code",    :limit => 2
    t.integer  "sign_type_code",          :limit => 2
    t.integer  "cutoff_date_code",        :limit => 2
    t.integer  "charge_timing_code",      :limit => 2
    t.integer  "state_code",              :limit => 2
    t.string   "note",                    :limit => 200
    t.integer  "invalid_flag_code",       :limit => 2
    t.datetime "print_check_date"
    t.datetime "deleted_at"
    t.datetime "created_at"
    t.datetime "updated_at"
  end

  add_index "purchases", ["accept_order_id"], :name => "accept_order_id"
  add_index "purchases", ["customer_id"], :name => "customer_id"
  add_index "purchases", ["invalid_flag_code"], :name => "invalid_flag_code"
  add_index "purchases", ["order_id"], :name => "order_id"
  add_index "purchases", ["payto_supplier_id"], :name => "payto_supplier_id"
  add_index "purchases", ["purchase_type_code"], :name => "purchase_type_code"
  add_index "purchases", ["sales_area_id"], :name => "sales_area_id"
  add_index "purchases", ["sales_section_id"], :name => "sales_section_id"
  add_index "purchases", ["sales_user_id"], :name => "sales_user_id"
  add_index "purchases", ["supplier_id"], :name => "supplier_id"
  add_index "purchases", ["target_date"], :name => "target_date"
  add_index "purchases", ["user_position_id"], :name => "user_position_id"
  add_index "purchases", ["warehouse_id"], :name => "warehouse_id"

  create_table "receivable_carry_remains", :force => true do |t|
    t.integer  "rev_number"
    t.date     "input_date"
    t.date     "target_date"
    t.integer  "user_id"
    t.integer  "section_id"
    t.integer  "customer_id"
    t.integer  "customer_group_id"
    t.integer  "credit_timing_code", :limit => 2
    t.integer  "cutoff_date_code",   :limit => 2
    t.integer  "currency_type_code", :limit => 2
    t.integer  "total_carry"
    t.integer  "state_code",         :limit => 2
    t.string   "note",               :limit => 200
    t.integer  "invalid_flag_code",  :limit => 2
    t.datetime "deleted_at"
    t.datetime "created_at"
    t.datetime "updated_at"
  end

  add_index "receivable_carry_remains", ["customer_group_id"], :name => "customer_group_id"
  add_index "receivable_carry_remains", ["customer_id"], :name => "customer_id"
  add_index "receivable_carry_remains", ["invalid_flag_code"], :name => "invalid_flag_code"
  add_index "receivable_carry_remains", ["target_date"], :name => "target_date"

  create_table "receivable_details", :force => true do |t|
    t.integer  "receivable_id"
    t.integer  "deal_type_code", :limit => 2
    t.integer  "trade_id"
    t.integer  "payment_id"
    t.integer  "carry_id"
    t.datetime "created_at"
    t.datetime "updated_at"
  end

  add_index "receivable_details", ["carry_id"], :name => "carry_id"
  add_index "receivable_details", ["deal_type_code"], :name => "deal_type_code"
  add_index "receivable_details", ["payment_id"], :name => "payment_id"
  add_index "receivable_details", ["receivable_id"], :name => "payable_id"
  add_index "receivable_details", ["trade_id"], :name => "trade_id"

  create_table "receivables", :force => true do |t|
    t.integer  "customer_id"
    t.integer  "customer_group_id"
    t.date     "cutoff_date"
    t.date     "payment_date"
    t.integer  "payment_type_code", :limit => 2
    t.date     "encachement_date"
    t.integer  "total_price"
    t.integer  "total_duty"
    t.integer  "total_payment"
    t.integer  "total_carry"
    t.integer  "pre_total"
    t.integer  "total"
    t.integer  "trade_sheet_cnt"
    t.datetime "print_sheet_date"
    t.datetime "print_ledger_date"
    t.datetime "created_at"
    t.datetime "updated_at"
  end

  add_index "receivables", ["customer_group_id"], :name => "customer_group_id"
  add_index "receivables", ["customer_id"], :name => "customer_id"
  add_index "receivables", ["cutoff_date"], :name => "cutoff_date"
  add_index "receivables", ["payment_date"], :name => "payment_date"

  create_table "receiving_details", :force => true do |t|
    t.integer  "receiving_id"
    t.integer  "seq_number"
    t.integer  "credit_type_code", :limit => 2
    t.integer  "amount"
    t.integer  "bank_id"
    t.date     "bill_date"
    t.string   "bill_number",      :limit => 12
    t.string   "note",             :limit => 200
    t.datetime "created_at"
    t.datetime "updated_at"
  end

  add_index "receiving_details", ["receiving_id"], :name => "receiving_id"

  create_table "receivings", :force => true do |t|
    t.integer  "rev_number"
    t.date     "input_date"
    t.date     "target_date"
    t.integer  "user_id"
    t.integer  "section_id"
    t.integer  "customer_id"
    t.integer  "customer_group_id"
    t.date     "cutoff_date"
    t.integer  "credit_timing_code", :limit => 2
    t.integer  "cutoff_date_code",   :limit => 2
    t.integer  "total_amount"
    t.integer  "state_code",         :limit => 2
    t.string   "note",               :limit => 200
    t.integer  "invalid_flag_code",  :limit => 2
    t.datetime "deleted_at"
    t.datetime "created_at"
    t.datetime "updated_at"
  end

  add_index "receivings", ["customer_id"], :name => "customer_id"
  add_index "receivings", ["cutoff_date"], :name => "cutoff_date"
  add_index "receivings", ["invalid_flag_code"], :name => "invalid_flag_code"
  add_index "receivings", ["target_date"], :name => "target_date"

  create_table "rels", :force => true do |t|
    t.string   "parent_table_name", :limit => 80
    t.integer  "parent_record_id"
    t.string   "table_name",        :limit => 80
    t.integer  "record_id"
    t.integer  "lock_status_code",  :limit => 2
    t.datetime "created_at"
  end

  add_index "rels", ["lock_status_code"], :name => "lock_status_code"
  add_index "rels", ["parent_table_name"], :name => "parent_table_name"
  add_index "rels", ["table_name"], :name => "table_name"

  create_table "restoration_details", :force => true do |t|
    t.integer  "restoration_id"
    t.integer  "seq_number"
    t.integer  "product_category_id"
    t.integer  "product_set_id"
    t.integer  "product_id"
    t.string   "lot_number",          :limit => 20
    t.string   "serial_number",       :limit => 40
    t.date     "ubd"
    t.integer  "validity_period"
    t.integer  "unit_code",           :limit => 2
    t.integer  "quantity"
    t.integer  "stock_type_code",     :limit => 2
    t.string   "note",                :limit => 200
    t.datetime "created_at"
    t.datetime "updated_at"
  end

  add_index "restoration_details", ["product_id"], :name => "product_id"
  add_index "restoration_details", ["product_set_id"], :name => "product_set_id"
  add_index "restoration_details", ["restoration_id"], :name => "restoration_id"
  add_index "restoration_details", ["stock_type_code"], :name => "stock_type_code"

  create_table "restorations", :force => true do |t|
    t.integer  "accept_order_id"
    t.integer  "rev_number"
    t.date     "input_date"
    t.date     "target_date"
    t.integer  "user_id"
    t.integer  "section_id"
    t.integer  "restoration_trigger_code", :limit => 2
    t.integer  "restoration_type_code",    :limit => 2
    t.integer  "own_warehouse_id"
    t.integer  "warehouse_id"
    t.integer  "user_position_id"
    t.integer  "sales_user_id"
    t.integer  "sales_area_id"
    t.integer  "sales_section_id"
    t.integer  "customer_id"
    t.integer  "supplier_id"
    t.integer  "state_code",               :limit => 2
    t.string   "note",                     :limit => 200
    t.integer  "invalid_flag_code",        :limit => 2
    t.datetime "print_sheet_date"
    t.datetime "deleted_at"
    t.datetime "created_at"
    t.datetime "updated_at"
  end

  add_index "restorations", ["accept_order_id"], :name => "accept_order_id"
  add_index "restorations", ["customer_id"], :name => "customer_id"
  add_index "restorations", ["invalid_flag_code"], :name => "invalid_flag_code"
  add_index "restorations", ["restoration_type_code"], :name => "restoration_type_code"
  add_index "restorations", ["sales_area_id"], :name => "sales_area_id"
  add_index "restorations", ["sales_section_id"], :name => "sales_section_id"
  add_index "restorations", ["sales_user_id"], :name => "sales_user_id"
  add_index "restorations", ["supplier_id"], :name => "supplier_id"
  add_index "restorations", ["target_date"], :name => "target_date"
  add_index "restorations", ["user_position_id"], :name => "user_position_id"

  create_table "roles_menus", :force => true do |t|
    t.integer  "role_id"
    t.integer  "menu_id"
    t.integer  "auth_code",  :limit => 2
    t.datetime "created_at"
    t.datetime "updated_at"
  end

  add_index "roles_menus", ["menu_id"], :name => "menu_id"
  add_index "roles_menus", ["role_id"], :name => "role_id"

  create_table "sale_details", :force => true do |t|
    t.integer  "sale_id"
    t.integer  "seq_number"
    t.integer  "product_category_id"
    t.integer  "product_set_id"
    t.integer  "product_id"
    t.string   "lot_number",          :limit => 20
    t.string   "serial_number",       :limit => 40
    t.date     "ubd"
    t.integer  "validity_period"
    t.integer  "unit_code",           :limit => 2
    t.integer  "quantity"
    t.decimal  "price",                              :precision => 16, :scale => 3
    t.integer  "stock_type_code",     :limit => 2
    t.string   "note",                :limit => 200
    t.datetime "created_at"
    t.datetime "updated_at"
  end

  add_index "sale_details", ["product_id"], :name => "product_id"
  add_index "sale_details", ["product_set_id"], :name => "product_set_id"
  add_index "sale_details", ["sale_id"], :name => "sale_id"
  add_index "sale_details", ["stock_type_code"], :name => "stock_type_code"

  create_table "sales", :force => true do |t|
    t.integer  "rev_number"
    t.integer  "accept_order_id"
    t.integer  "purchase_id"
    t.integer  "sale_id"
    t.date     "input_date"
    t.date     "target_date"
    t.date     "operate_date"
    t.integer  "user_id"
    t.integer  "section_id"
    t.integer  "sale_trigger_code",        :limit => 2
    t.integer  "sale_type_code",           :limit => 2
    t.integer  "warehouse_id"
    t.integer  "user_position_id"
    t.integer  "sales_user_id"
    t.integer  "sales_area_id"
    t.integer  "sales_section_id"
    t.integer  "customer_id"
    t.integer  "supplier_id"
    t.string   "customer_order_number",    :limit => 40
    t.integer  "charge_customer_id"
    t.integer  "charge_customer_group_id"
    t.integer  "sale_sheet_type_code",     :limit => 2
    t.integer  "total_price"
    t.integer  "total_duty"
    t.integer  "duty_type_code",           :limit => 2
    t.integer  "duty_rate"
    t.integer  "price_duty_type_code",     :limit => 2
    t.integer  "duty_calc_type_code",      :limit => 2
    t.integer  "frac_digit_code",          :limit => 2
    t.integer  "fraction_method_code",     :limit => 2
    t.integer  "sign_type_code",           :limit => 2
    t.integer  "cutoff_date_code",         :limit => 2
    t.integer  "charge_timing_code",       :limit => 2
    t.integer  "state_code",               :limit => 2
    t.string   "note",                     :limit => 200
    t.string   "sale_note",                :limit => 200
    t.integer  "invalid_flag_code",        :limit => 2
    t.datetime "print_sheet_date"
    t.datetime "deleted_at"
    t.datetime "created_at"
    t.datetime "updated_at"
  end

  add_index "sales", ["accept_order_id"], :name => "accept_order_id"
  add_index "sales", ["charge_customer_id"], :name => "charge_customer_id"
  add_index "sales", ["customer_id"], :name => "customer_id"
  add_index "sales", ["purchase_id"], :name => "purchase_id"
  add_index "sales", ["sale_type_code"], :name => "sale_type_code"
  add_index "sales", ["sales_area_id"], :name => "sales_area_id"
  add_index "sales", ["sales_section_id"], :name => "sales_section_id"
  add_index "sales", ["sales_user_id"], :name => "sales_user_id"
  add_index "sales", ["supplier_id"], :name => "supplier_id"
  add_index "sales", ["target_date"], :name => "target_date"
  add_index "sales", ["user_position_id"], :name => "user_position_id"
  add_index "sales", ["warehouse_id"], :name => "warehouse_id"

  create_table "sample_details", :force => true do |t|
    t.integer  "sample_id"
    t.integer  "seq_number"
    t.integer  "product_category_id"
    t.integer  "product_set_id"
    t.integer  "product_id"
    t.string   "lot_number",          :limit => 20
    t.string   "serial_number",       :limit => 40
    t.date     "ubd"
    t.integer  "validity_period"
    t.integer  "unit_code",           :limit => 2
    t.integer  "quantity"
    t.integer  "stock_type_code",     :limit => 2
    t.string   "note",                :limit => 200
    t.datetime "created_at"
    t.datetime "updated_at"
  end

  add_index "sample_details", ["product_id"], :name => "product_id"
  add_index "sample_details", ["product_set_id"], :name => "product_set_id"
  add_index "sample_details", ["sample_id"], :name => "sample_id"
  add_index "sample_details", ["stock_type_code"], :name => "stock_type_code"

  create_table "samples", :force => true do |t|
    t.integer  "accept_order_id"
    t.integer  "sample_id"
    t.integer  "rev_number"
    t.date     "input_date"
    t.date     "target_date"
    t.date     "operate_date"
    t.integer  "user_id"
    t.integer  "section_id"
    t.integer  "sample_trigger_code", :limit => 2
    t.integer  "warehouse_id"
    t.integer  "user_position_id"
    t.integer  "sales_user_id"
    t.integer  "sales_area_id"
    t.integer  "sales_section_id"
    t.integer  "customer_id"
    t.integer  "supplier_id"
    t.integer  "sign_type_code",      :limit => 2
    t.integer  "state_code",          :limit => 2
    t.string   "note",                :limit => 200
    t.integer  "invalid_flag_code",   :limit => 2
    t.datetime "deleted_at"
    t.datetime "created_at"
    t.datetime "updated_at"
  end

  add_index "samples", ["accept_order_id"], :name => "accept_order_id"
  add_index "samples", ["customer_id"], :name => "customer_id"
  add_index "samples", ["sales_area_id"], :name => "sales_area_id"
  add_index "samples", ["sales_section_id"], :name => "sales_section_id"
  add_index "samples", ["sales_user_id"], :name => "sales_user_id"
  add_index "samples", ["supplier_id"], :name => "supplier_id"
  add_index "samples", ["target_date"], :name => "target_date"
  add_index "samples", ["user_position_id"], :name => "user_position_id"
  add_index "samples", ["warehouse_id"], :name => "warehouse_id"

  create_table "shipping_details", :force => true do |t|
    t.integer  "shipping_id"
    t.integer  "seq_number"
    t.integer  "product_category_id"
    t.integer  "product_set_id"
    t.integer  "product_id"
    t.string   "lot_number",          :limit => 20
    t.string   "serial_number",       :limit => 40
    t.date     "ubd"
    t.integer  "validity_period"
    t.integer  "unit_code",           :limit => 2
    t.integer  "quantity"
    t.integer  "scheduled_quantity"
    t.string   "note",                :limit => 200
    t.datetime "created_at"
    t.datetime "updated_at"
  end

  add_index "shipping_details", ["product_id"], :name => "product_id"
  add_index "shipping_details", ["product_set_id"], :name => "product_set_id"
  add_index "shipping_details", ["shipping_id"], :name => "shipping_id"

  create_table "shipping_order_details", :force => true do |t|
    t.integer  "shipping_order_id"
    t.integer  "seq_number"
    t.integer  "product_category_id"
    t.integer  "product_set_id"
    t.integer  "product_id"
    t.string   "lot_number",          :limit => 20
    t.string   "serial_number",       :limit => 40
    t.date     "ubd"
    t.integer  "validity_period"
    t.integer  "unit_code",           :limit => 2
    t.integer  "quantity"
    t.integer  "scheduled_quantity"
    t.string   "note",                :limit => 200
    t.datetime "created_at"
    t.datetime "updated_at"
  end

  add_index "shipping_order_details", ["product_id"], :name => "product_id"
  add_index "shipping_order_details", ["product_set_id"], :name => "product_set_id"
  add_index "shipping_order_details", ["shipping_order_id"], :name => "shipping_order_id"

  create_table "shipping_orders", :force => true do |t|
    t.integer  "accept_order_id"
    t.integer  "rev_number"
    t.date     "input_date"
    t.date     "target_date"
    t.integer  "user_id"
    t.integer  "section_id"
    t.integer  "shipping_trigger_code",    :limit => 2
    t.integer  "shipping_type_code",       :limit => 2
    t.integer  "supplier_id"
    t.integer  "own_warehouse_id"
    t.integer  "warehouse_id"
    t.integer  "user_position_id"
    t.integer  "sales_user_id"
    t.integer  "sales_area_id"
    t.integer  "sales_section_id"
    t.integer  "customer_id"
    t.integer  "shipment_customer_id"
    t.integer  "delivery_customer_id"
    t.integer  "trucking_id"
    t.string   "receiver_name",            :limit => 20
    t.string   "request_time",             :limit => 20
    t.integer  "shipping_sheet_type_code", :limit => 2
    t.string   "note",                     :limit => 200
    t.string   "shipping_note",            :limit => 200
    t.integer  "invalid_flag_code",        :limit => 2
    t.datetime "deleted_at"
    t.datetime "created_at"
    t.datetime "updated_at"
  end

  add_index "shipping_orders", ["accept_order_id"], :name => "accept_order_id"
  add_index "shipping_orders", ["customer_id"], :name => "customer_id"
  add_index "shipping_orders", ["sales_area_id"], :name => "sales_area_id"
  add_index "shipping_orders", ["sales_section_id"], :name => "sales_section_id"
  add_index "shipping_orders", ["sales_user_id"], :name => "sales_user_id"
  add_index "shipping_orders", ["shipping_type_code"], :name => "shipping_type_code"
  add_index "shipping_orders", ["supplier_id"], :name => "supplier_id"
  add_index "shipping_orders", ["target_date"], :name => "target_date"
  add_index "shipping_orders", ["user_position_id"], :name => "user_position_id"
  add_index "shipping_orders", ["warehouse_id"], :name => "warehouse_id"

  create_table "shippings", :force => true do |t|
    t.integer  "accept_order_id"
    t.integer  "shipping_order_id"
    t.integer  "rev_number"
    t.date     "input_date"
    t.date     "target_date"
    t.integer  "user_id"
    t.integer  "section_id"
    t.integer  "shipping_trigger_code",    :limit => 2
    t.integer  "supplier_id"
    t.integer  "own_warehouse_id"
    t.integer  "warehouse_id"
    t.integer  "user_position_id"
    t.integer  "sales_user_id"
    t.integer  "sales_area_id"
    t.integer  "sales_section_id"
    t.integer  "customer_id"
    t.integer  "shipment_customer_id"
    t.integer  "delivery_id"
    t.integer  "trucking_id"
    t.string   "receiver_name",            :limit => 20
    t.string   "request_time",             :limit => 20
    t.integer  "shipping_sheet_type_code", :limit => 2
    t.integer  "shipping_state_code",      :limit => 2
    t.integer  "shipping_type_code",       :limit => 2
    t.string   "note",                     :limit => 200
    t.string   "shipping_note",            :limit => 200
    t.datetime "print_picking_date"
    t.datetime "print_sheet_date"
    t.integer  "invalid_flag_code",        :limit => 2
    t.datetime "deleted_at"
    t.datetime "created_at"
    t.datetime "updated_at"
  end

  add_index "shippings", ["accept_order_id"], :name => "accept_order_id"
  add_index "shippings", ["customer_id"], :name => "customer_id"
  add_index "shippings", ["sales_area_id"], :name => "sales_area_id"
  add_index "shippings", ["sales_section_id"], :name => "sales_section_id"
  add_index "shippings", ["sales_user_id"], :name => "sales_user_id"
  add_index "shippings", ["shipping_type_code"], :name => "shipping_type_code"
  add_index "shippings", ["supplier_id"], :name => "supplier_id"
  add_index "shippings", ["target_date"], :name => "target_date"
  add_index "shippings", ["user_position_id"], :name => "user_position_id"
  add_index "shippings", ["warehouse_id"], :name => "warehouse_id"

  create_table "stocks", :force => true do |t|
    t.integer  "customer_id"
    t.integer  "warehouse_id"
    t.integer  "supplier_id"
    t.integer  "product_category_id"
    t.integer  "product_set_id"
    t.integer  "product_id"
    t.string   "lot_number",             :limit => 20
    t.string   "serial_number",          :limit => 40
    t.date     "ubd"
    t.integer  "validity_period"
    t.integer  "unit_code",              :limit => 2
    t.integer  "existing_quantity"
    t.integer  "available_quantity"
    t.integer  "short_shipped_quantity"
    t.integer  "price"
    t.integer  "total_price"
    t.datetime "created_at"
    t.datetime "updated_at"
  end

  add_index "stocks", ["customer_id"], :name => "customer_id"
  add_index "stocks", ["product_id"], :name => "product_id"
  add_index "stocks", ["product_set_id"], :name => "product_set_id"
  add_index "stocks", ["supplier_id"], :name => "supplier_id"
  add_index "stocks", ["warehouse_id"], :name => "warehouse_id"

  create_table "supplier_ledger_details", :force => true do |t|
    t.integer  "supplier_ledger_id"
    t.integer  "deal_type_code",     :limit => 2
    t.integer  "trade_id"
    t.integer  "payment_id"
    t.integer  "carry_id"
    t.datetime "created_at"
    t.datetime "updated_at"
  end

  add_index "supplier_ledger_details", ["carry_id"], :name => "carry_id"
  add_index "supplier_ledger_details", ["deal_type_code"], :name => "deal_type_code"
  add_index "supplier_ledger_details", ["payment_id"], :name => "payment_id"
  add_index "supplier_ledger_details", ["supplier_ledger_id"], :name => "supplier_ledger_id"
  add_index "supplier_ledger_details", ["trade_id"], :name => "trade_id"

  create_table "supplier_ledgers", :force => true do |t|
    t.integer  "supplier_id"
    t.integer  "supplier_group_id"
    t.date     "target_date"
    t.integer  "currency_type_code", :limit => 2
    t.integer  "black_price"
    t.integer  "red_price"
    t.integer  "adjust_price"
    t.integer  "total_price"
    t.integer  "total_duty"
    t.integer  "cash"
    t.integer  "bill"
    t.integer  "offset"
    t.integer  "fee"
    t.integer  "total_credit"
    t.integer  "total_carry"
    t.integer  "pre_total"
    t.integer  "total"
    t.datetime "print_sheet_date"
    t.datetime "created_at"
    t.datetime "updated_at"
  end

  add_index "supplier_ledgers", ["supplier_group_id"], :name => "customer_group_id"
  add_index "supplier_ledgers", ["supplier_id"], :name => "customer_id"
  add_index "supplier_ledgers", ["target_date"], :name => "target_date"

  create_table "users_menus", :force => true do |t|
    t.integer  "user_id"
    t.integer  "menu_id"
    t.integer  "auth_code",  :limit => 2
    t.datetime "created_at"
    t.datetime "updated_at"
  end

  add_index "users_menus", ["menu_id"], :name => "menu_id"
  add_index "users_menus", ["user_id"], :name => "user_id"

end