ALTER TABLE `product_work_order`
|
ADD COLUMN `worker_id` bigint NULL COMMENT '指派工人ID',
|
ADD COLUMN `worker_name` varchar(100) NULL COMMENT '指派工人姓名',
|
ADD COLUMN `handover_user_id` bigint NULL COMMENT '交接人员ID',
|
ADD COLUMN `handover_user_name` varchar(100) NULL COMMENT '交接人员名称';
|
|
CREATE TABLE `sales_ledger_product_frozen`
|
(
|
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键id',
|
`sales_ledger_product_id` bigint(20) NOT NULL COMMENT '销售订单产品id',
|
`product_model_id` bigint(20) NOT NULL COMMENT '产品规格id',
|
`frozen_quantity` decimal(10, 2) NOT NULL DEFAULT '0.00' COMMENT '冻结数量',
|
`create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
|
PRIMARY KEY (`id`)
|
) ENGINE = InnoDB
|
DEFAULT CHARSET = utf8mb4 COMMENT ='销售产品冻结库存表';
|
