| 12345678910111213141516171819 |
- USE DCP;
- ALTER TABLE `base_personnel_entity`
- ADD COLUMN `id_type` varchar(64) COMMENT '证件类型' AFTER `nationality_dict`,
- ADD COLUMN `id_number` varchar(64) COMMENT '证件号码' AFTER `id_type`,
- ADD COLUMN `work_unit` varchar(1000) COMMENT '所在单位' AFTER `id_number`,
- ADD COLUMN `original_duty` varchar(64) COMMENT '曾任职务' AFTER `work_unit`,
- ADD COLUMN `current_duty` varchar(64) COMMENT '现任职务' AFTER `original_duty`,
- ADD COLUMN `photo` varchar(64) COMMENT '照片' AFTER `current_duty`,
- ADD COLUMN `highest_education` varchar(64) COMMENT '最高学历' AFTER `photo`,
- ADD COLUMN `highest_education_dict` varchar(64) COMMENT '最高学历代码' AFTER `highest_education`,
- ADD COLUMN `realname_validated_status` char(1) COMMENT '实名认证状态' AFTER `highest_education_dict`
- /**
- 已执行161，159
- */
|
