-- =============================================================================
|
-- 随访周期统一字段 followup_period
|
-- 涉及:
|
-- 1. pat_child_archive_detail(儿保档案详情)
|
-- 2. pat_specific_archive_generate_config(专科档案生成配置)
|
-- 说明:妇保档案详情 pat_maternity_archive_detail 已有 followup_period,无需重复添加。
|
-- date:2026-11-09
|
-- =============================================================================
|
|
ALTER TABLE pat_child_archive_detail
|
ADD COLUMN followup_period varchar(100) NULL COMMENT '随访周期' AFTER planned_follow_time;
|
|
ALTER TABLE pat_specific_archive_generate_config
|
ADD COLUMN followup_period varchar(100) NULL COMMENT '随访周期' AFTER archive_type;
|