2022-02-09_002(张新竹).sql 757 B

1234567
  1. ALTER TABLE `weighing_management`
  2. ADD COLUMN `service_management_type` varchar(20) NULL COMMENT '服务入库类型(1贸易入库3收购入库5业务入库7秋收入库)' AFTER `management_type`,
  3. ADD COLUMN `deduction_weight` float(11,4) DEFAULT NULL COMMENT '扣重(公斤)' AFTER `service_management_type`,
  4. ADD COLUMN `out_type` varchar(100) DEFAULT NULL COMMENT '运输方式(汽运,火运,集装箱船,散船)' AFTER `deduction_weight`,
  5. ADD COLUMN `in_out_task_no` varchar(100) DEFAULT NULL COMMENT '出入库任务编号' AFTER `out_type`,
  6. ADD COLUMN `deliver_unit` varchar(100) DEFAULT NULL COMMENT '发货单位' AFTER `in_out_task_no`,
  7. ADD COLUMN `move_task_no` varchar(200) DEFAULT NULL COMMENT '移库任务编号' AFTER `deliver_unit`;