ALTER TABLE appointment_order
|
ADD COLUMN visit_reason_other VARCHAR(255) NULL COMMENT '来访事由自定义内容' AFTER visit_reason_code,
|
ADD COLUMN visit_time_mode VARCHAR(16) NULL COMMENT '拜访时间模式（SINGLE/MULTI）' AFTER visitor_org,
|
ADD COLUMN visit_time_slot VARCHAR(16) NULL COMMENT '单日时段（ALL_DAY/AM/PM）' AFTER visit_time_mode,
|
ADD COLUMN person_entry_flag TINYINT(1) NOT NULL DEFAULT 1 COMMENT '是否有人员进场' AFTER key_area_flag,
|
ADD COLUMN vehicle_entry_flag TINYINT(1) NOT NULL DEFAULT 0 COMMENT '是否有车辆进场' AFTER person_entry_flag;
|
|
ALTER TABLE appointment_visitor
|
ADD COLUMN mp_visitor_id BIGINT NULL COMMENT '访客ID（mp_visitor.id）' AFTER order_id;
|
|
CREATE TABLE IF NOT EXISTS appointment_vehicle (
|
id BIGINT AUTO_INCREMENT PRIMARY KEY COMMENT '主键ID',
|
uuid VARCHAR(64) NOT NULL COMMENT '业务UUID',
|
version BIGINT NOT NULL DEFAULT 1 COMMENT '乐观锁版本',
|
create_id BIGINT NULL COMMENT '创建人ID',
|
create_time DATETIME NULL COMMENT '创建时间',
|
update_id BIGINT NULL COMMENT '更新人ID',
|
update_time DATETIME NULL COMMENT '更新时间',
|
del_flag INT NOT NULL DEFAULT 0 COMMENT '逻辑删除标记（0未删 1已删）',
|
order_id BIGINT NOT NULL COMMENT '预约单ID',
|
plate_no VARCHAR(32) NOT NULL COMMENT '车牌号',
|
driver_visitor_id BIGINT NOT NULL COMMENT '驾驶员访客ID（mp_visitor.id）',
|
driver_name VARCHAR(64) NULL COMMENT '驾驶员姓名快照',
|
UNIQUE KEY uk_appointment_vehicle_uuid (uuid),
|
KEY idx_appointment_vehicle_order (order_id)
|
) COMMENT='预约车辆明细';
|
