11 lines
552 B
SQL
11 lines
552 B
SQL
CREATE TABLE `ufutx_guide_model_log` (
|
||
`id` INT NOT NULL AUTO_INCREMENT,
|
||
`user_id` INTEGER NOT NULL COMMENT '用户id',
|
||
`order_id` INTEGER NOT NULL COMMENT "订单id",
|
||
`model` INTEGER DEFAULT NULL COMMENT '模式 1：3+4，2：1+6',
|
||
`start_date` DATE NULL DEFAULT NULL COMMENT "开始时间",
|
||
`service_user_id` INTEGER DEFAULT NULL COMMENT '服务人员id',
|
||
`created_at` TIMESTAMP NULL DEFAULT NULL,
|
||
`updated_at` TIMESTAMP NULL DEFAULT NULL,
|
||
PRIMARY KEY (`id`)
|
||
) ENGINE = InnoDB COMMENT = '餐单模式变更记录'; |