9 lines
706 B
SQL
Executable File
9 lines
706 B
SQL
Executable File
-- 为处方业务订单表添加完单申请字段
|
|
-- 用于记录补齐支付单时是否申请完成订单
|
|
|
|
ALTER TABLE `zyt_tcm_prescription_order`
|
|
ADD COLUMN `completion_request` tinyint(1) unsigned NOT NULL DEFAULT 0 COMMENT '完单申请：0=未申请，1=已申请' AFTER `payment_slip_audit_remark`,
|
|
ADD COLUMN `completion_request_time` int(11) unsigned NOT NULL DEFAULT 0 COMMENT '完单申请时间' AFTER `completion_request`,
|
|
ADD COLUMN `completion_request_by` int(11) unsigned NOT NULL DEFAULT 0 COMMENT '完单申请人ID' AFTER `completion_request_time`,
|
|
ADD COLUMN `completion_request_by_name` varchar(64) NOT NULL DEFAULT '' COMMENT '完单申请人姓名' AFTER `completion_request_by`;
|