Sha256: 906b62dbda4c3b045209a18601d7f064422755f7cbdb415d92152102bc7d6c7f
Contents?: true
Size: 1.74 KB
Versions: 85
Compression:
Stored size: 1.74 KB
Contents
class AddYearToSalePlans < ActiveRecord::Migration[5.2]
def change
add_column :educode_sales_sale_plans, :year, :string
add_column :educode_sales_sale_plans, :clazz, :integer
create_table :educode_sales_business_infos do |t|
t.references :business
t.references :staff
t.references :sale_plan
t.string :year, comment: '年份'
t.integer :clazz, comment: '目标类型'
t.date :plan_bid_on, comment: '计划投标时间'
t.date :actual_bidded_on, comment: '实际投标时间'
t.float :bidded_amount, comment: '中标额'
t.date :plan_sign_on, comment: '计划签单时间'
t.date :actual_sign_on, comment: '实际签单时间'
t.float :sign_amount, comment: '签单额'
t.date :plan_deploy_on, comment: '计划部署时间'
t.date :actual_deploy_on, comment: '实际部署时间'
t.date :plan_check_on, comment: '计划验收时间'
t.date :actual_check_on, comment: '实际验收时间'
t.date :prepayment_plan_on, comment: '预收款计划回款时间'
t.date :prepayment_actual_on, comment: '预收款实际回款时间'
t.float :prepayment_amount, comment: '预收款'
t.date :check_fee_plan_on, comment: '验收款计划回款时间'
t.date :check_fee_actual_on, comment: '验收款实际回款时间'
t.float :check_fee, comment: '验收款'
t.date :qa_plan_on, comment: '质保金计划回款时间'
t.date :qa_actual_on, comment: '质保金实际回款时间'
t.float :qa_amount, comment: '质保金'
t.float :account_receivable, comment: '应收款'
t.integer :account_receivable_clazz, comment: '应收款类型'
t.float :invoice_amount, comment: '开票金额'
t.timestamps
end
end
end
Version data entries
85 entries across 85 versions & 1 rubygems