ALTER TABLE appointment_order
|
ADD COLUMN pass_access_area_ids TEXT NULL COMMENT '经办人审批通行区域ID列表(JSON)' AFTER reject_reason,
|
ADD COLUMN pass_access_area_names TEXT NULL COMMENT '经办人审批通行区域名称列表(JSON)' AFTER pass_access_area_ids,
|
ADD COLUMN involve_other_local_unit TINYINT(1) NOT NULL DEFAULT 0 COMMENT '经办人审批是否涉及其他属地单位' AFTER pass_access_area_names,
|
ADD COLUMN pass_local_unit_ids TEXT NULL COMMENT '经办人审批其他属地单位ID列表(JSON)' AFTER involve_other_local_unit,
|
ADD COLUMN pass_local_unit_names TEXT NULL COMMENT '经办人审批其他属地单位名称列表(JSON)' AFTER pass_local_unit_ids;
|