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
 */





