Home Explore Help
Register Sign In
gdc
/
DB-SQL
1
0
Fork 0
Files Issues 0 Pull Requests 0 Wiki
Branch: master
Branches Tags
DB-SQL
/
2022-02-09_003(张新竹).sql

2022-02-09_003(张新竹).sql 2.4 KB
Permalink History Raw

12345678910111213141516171819202122 
  1. ALTER TABLE `quality_inspection_management` 
    2. 

  2. ADD COLUMN `service_management_type` varchar(20) NULL COMMENT '服务入库类型(1贸易入库3收购入库)' AFTER `management_type`,
    3. 

  3. ADD COLUMN `default_box` varchar(50) DEFAULT '0' COMMENT '原箱直销（1直销）' AFTER `service_management_type` ,
    4. 

  4. ADD COLUMN `in_out_task_no` varchar(100) DEFAULT NULL COMMENT '出入库任务编号' AFTER `default_box` ,
    5. 

  5. ADD COLUMN `out_type` varchar(100) DEFAULT NULL COMMENT '运输方式(汽运，火运，集装箱船，散船)' AFTER `in_out_task_no`, 
    6. 

  6. ADD COLUMN `in_out_date` datetime DEFAULT NULL COMMENT '入库日期' AFTER `out_type` ,
    7. 

  7. ADD COLUMN `freight` float(11,4) DEFAULT '0.0000' COMMENT '运费' AFTER `in_out_date`,
    8. 

  8. ADD COLUMN `cost` float(11,4) DEFAULT NULL COMMENT '成本' AFTER `freight` ,
    9. 

  9. ADD COLUMN `deduction_amount` double(20,2) DEFAULT '0.00' COMMENT '扣款金额' AFTER `cost`,
    10. 

  10. ADD COLUMN `re_deduction_amount` double(20,2) DEFAULT '0.00' COMMENT '复检扣款' AFTER `deduction_amount`,
    11. 

  11. ADD COLUMN `fleet` varchar(100) DEFAULT NULL COMMENT '车队'AFTER `re_deduction_amount`,
    12. 

  12. ADD COLUMN `agent_key` varchar(32) DEFAULT NULL COMMENT '经办人key' AFTER `fleet`,
    13. 

  13. ADD COLUMN `agent` varchar(200) DEFAULT NULL COMMENT '经办人' AFTER `agent_key`,
    14. 

  14. ADD COLUMN `in_out_type_key` varchar(20) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '出入库类型key' AFTER `agent`,
    15. 

  15. ADD COLUMN `in_out_type` varchar(100) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '出入库类型' AFTER `in_out_type_key`,
    16. 

  16. ADD COLUMN `re_impurity` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '复检杂质' AFTER `in_out_type`,
    17. 

  17. ADD COLUMN `re_mildew_grain` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '复检霉变粒' AFTER `re_impurity`,
    18. 

  18. ADD COLUMN `re_imperfect_grain` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '复检不完善粒' AFTER `re_mildew_grain`,
    19. 

  19. ADD COLUMN `re_bulk_density` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '复检容重' AFTER `re_imperfect_grain`,
    20. 

  20. ADD COLUMN `re_jiaorenli` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '复检热损伤' AFTER `re_bulk_density`,
    21. 

  21. ADD COLUMN `re_grade_key` varchar(20) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '复检等级key' AFTER `re_jiaorenli`,
    22. 

  22. ADD COLUMN `re_grade` varchar(100) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '复检等级' AFTER `re_grade_key`;
    23.