CREATE TABLE IF NOT EXISTS `project_management_phase_history` ( `id` bigint NOT NULL AUTO_INCREMENT, `project_id` bigint NOT NULL, `phase_code` varchar(30) NOT NULL, `phase_name` varchar(50) NOT NULL, `action_type` varchar(30) NOT NULL, `action_label` varchar(100) NOT NULL, `form_data` json DEFAULT NULL, `remark` varchar(2000) DEFAULT NULL, `attachments` json DEFAULT NULL, `operator_name` varchar(100) DEFAULT NULL, `action_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`id`), KEY `idx_phase_history_project` (`project_id`,`action_time`), KEY `idx_phase_history_phase` (`project_id`,`phase_code`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='项目阶段办理历史';