2017-03-09.sql 3.2 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849
  1. ALTER TABLE org_annual_report
  2. add `basic_research_cost` DECIMAL(8,2) NULL COMMENT '基础研究投入费用' AFTER `total_export_volume`;
  3. ALTER TABLE org_activity
  4. MODIFY COLUMN budget DECIMAL(8,2) COMMENT '预算(万元)',
  5. MODIFY COLUMN first_year_expenditure DECIMAL(8,2) COMMENT '第一年研发经费支出(万元)',
  6. MODIFY COLUMN second_year_expenditure DECIMAL(8,2) COMMENT '第二年研发经费支出(万元)',
  7. MODIFY COLUMN third_year_expenditure DECIMAL(8,2) COMMENT '第三年研发经费支出(万元)';
  8. ALTER TABLE org_activity_cost
  9. MODIFY COLUMN internal_labor_cost DECIMAL(8,2) COMMENT '内部人员人工费用(万元)',
  10. MODIFY COLUMN internal_direct_cost DECIMAL(8,2) COMMENT '内部直接投入费用(万元)',
  11. MODIFY COLUMN internal_depreciation_cost DECIMAL(8,2) COMMENT '内部折旧费用与长期待摊费用(万元)',
  12. MODIFY COLUMN internal_amortization_cost DECIMAL(8,2) COMMENT '内部无形资产摊销费用(万元)',
  13. MODIFY COLUMN internal_design_cost DECIMAL(8,2) COMMENT '内部设计费用(万元)',
  14. MODIFY COLUMN internal_equipment_cost DECIMAL(8,2) COMMENT '内部装备调试费用与实验费用(万元)',
  15. MODIFY COLUMN internal_other_cost DECIMAL(8,2) COMMENT '内部其他费用(万元)',
  16. MODIFY COLUMN external_total_cost DECIMAL(8,2) COMMENT '委托外部研究开发总费用(万元)',
  17. MODIFY COLUMN external_abroad_cost DECIMAL(8,2) COMMENT '委托外部境内的外部研发费用(万元)';
  18. ALTER TABLE org_cognizance
  19. MODIFY COLUMN basic_research_cost DECIMAL(8,2) COMMENT '基础研究投入费用总额(万元)';
  20. ALTER TABLE org_finance
  21. MODIFY COLUMN main_business_income DECIMAL(8,2) COMMENT '主营业务收入(万元)',
  22. MODIFY COLUMN management_cost DECIMAL(8,2) COMMENT '管理费用(万元)',
  23. MODIFY COLUMN operating_profit DECIMAL(8,2) COMMENT '营业利润(万元)',
  24. MODIFY COLUMN various_tax DECIMAL(8,2) COMMENT '支付的各项税费(万元)',
  25. MODIFY COLUMN current_asset DECIMAL(8,2) COMMENT '流动资产(万元)',
  26. MODIFY COLUMN net_fixed_asset DECIMAL(8,2) COMMENT '固定资产净额(万元)',
  27. MODIFY COLUMN total_asset DECIMAL(8,2) COMMENT '资产总额(万元)',
  28. MODIFY COLUMN net_asset DECIMAL(8,2) COMMENT '所有者权益合计(万元)',
  29. MODIFY COLUMN gross_profit DECIMAL(8,2) COMMENT '利润总额(万元)',
  30. MODIFY COLUMN net_profit DECIMAL(8,2) COMMENT '净利润(万元)',
  31. MODIFY COLUMN sales_revenue DECIMAL(8,2) COMMENT '销售收入(万元)';
  32. ALTER TABLE org_ratepay
  33. MODIFY COLUMN operating_income DECIMAL(8,2) COMMENT '营业收入(万元)',
  34. MODIFY COLUMN management_cost DECIMAL(8,2) COMMENT '管理费用(万元)',
  35. MODIFY COLUMN operating_profit DECIMAL(8,2) COMMENT '营业利润(万元)',
  36. MODIFY COLUMN non_operating_income DECIMAL(8,2) COMMENT '营业外收入(万元)',
  37. MODIFY COLUMN non_taxable_income DECIMAL(8,2) COMMENT '不征税收入(万元)',
  38. MODIFY COLUMN tax_exempt_income DECIMAL(8,2) COMMENT '免税收入(万元)',
  39. MODIFY COLUMN subsidy_income DECIMAL(8,2) COMMENT '政府补助收入(万元)',
  40. MODIFY COLUMN gross_profit DECIMAL(8,2) COMMENT '利润总额(万元)',
  41. MODIFY COLUMN research_cost DECIMAL(8,2) COMMENT '研发费用(万元)';
  42. ALTER TABLE org_tech_product
  43. MODIFY COLUMN last_year_revenue DECIMAL(8,2) COMMENT '上年度销售收入(万元)';