-- 员工信息导入功能 - 新增字段
|
-- 用于 hrm_employee 表：民族、婚姻状态、年龄、学历、政治面貌
|
|
ALTER TABLE hrm_employee ADD COLUMN nation VARCHAR(32) COMMENT '民族' AFTER id_card;
|
ALTER TABLE hrm_employee ADD COLUMN marriage_status VARCHAR(16) COMMENT '婚姻状态' AFTER nation;
|
ALTER TABLE hrm_employee ADD COLUMN age INT COMMENT '年龄' AFTER marriage_status;
|
ALTER TABLE hrm_employee ADD COLUMN education VARCHAR(32) COMMENT '学历' AFTER age;
|
ALTER TABLE hrm_employee ADD COLUMN political_status VARCHAR(32) COMMENT '政治面貌' AFTER education;
|
