Files
jc-hr-ai/sql/hrm_v1_onboarding_application.sql
2026-11-12 14:34:17 +08:00

57 lines
4.4 KiB
SQL

-- 入职申请表字段与明细表扩展(已执行 hrm_v1.sql 的数据库执行一次)
-- 固定字段保存在 hr_onboarding_profile;可增加行的三类经历保存在各自明细表。
ALTER TABLE hr_onboarding_profile
ADD COLUMN applying_unit varchar(100) DEFAULT NULL COMMENT '申请职位/单位' AFTER profile_data,
ADD COLUMN expected_salary_min decimal(12,2) DEFAULT NULL COMMENT '期望薪资下限' AFTER applying_unit,
ADD COLUMN expected_salary_max decimal(12,2) DEFAULT NULL COMMENT '期望薪资上限' AFTER expected_salary_min,
ADD COLUMN application_date date DEFAULT NULL COMMENT '填表日期' AFTER expected_salary_max,
ADD COLUMN gender varchar(8) DEFAULT NULL COMMENT '性别' AFTER application_date,
ADD COLUMN birth_date date DEFAULT NULL COMMENT '出生日期' AFTER gender,
ADD COLUMN ethnicity varchar(32) DEFAULT NULL COMMENT '民族' AFTER birth_date,
ADD COLUMN native_province varchar(32) DEFAULT NULL COMMENT '籍贯省/直辖市' AFTER ethnicity,
ADD COLUMN political_status varchar(32) DEFAULT NULL COMMENT '政治面貌' AFTER native_province,
ADD COLUMN health_status varchar(128) DEFAULT NULL COMMENT '健康状况' AFTER political_status,
ADD COLUMN marital_status varchar(16) DEFAULT NULL COMMENT '婚姻状况' AFTER health_status,
ADD COLUMN id_card_no varchar(32) DEFAULT NULL COMMENT '身份证号码' AFTER marital_status,
ADD COLUMN education varchar(32) DEFAULT NULL COMMENT '最高学历' AFTER id_card_no,
ADD COLUMN hobby varchar(255) DEFAULT NULL COMMENT '兴趣爱好' AFTER education,
ADD COLUMN household_address varchar(255) DEFAULT NULL COMMENT '户籍地址' AFTER hobby,
ADD COLUMN current_address varchar(255) DEFAULT NULL COMMENT '现住地址' AFTER household_address,
ADD COLUMN photo_path varchar(500) DEFAULT NULL COMMENT '一寸照片' AFTER current_address,
ADD COLUMN emergency_contact_name varchar(64) DEFAULT NULL COMMENT '紧急联系人' AFTER photo_path,
ADD COLUMN emergency_relation varchar(32) DEFAULT NULL COMMENT '紧急联系人关系' AFTER emergency_contact_name,
ADD COLUMN emergency_phone varchar(32) DEFAULT NULL COMMENT '紧急联系人电话' AFTER emergency_relation,
ADD COLUMN current_status varchar(128) DEFAULT NULL COMMENT '当前状态' AFTER emergency_phone,
ADD COLUMN computer_skills varchar(255) DEFAULT NULL COMMENT '计算机水平' AFTER current_status,
ADD COLUMN language_skills varchar(255) DEFAULT NULL COMMENT '语言水平' AFTER computer_skills,
ADD COLUMN commitment_accepted char(1) NOT NULL DEFAULT '0' COMMENT '承诺已确认 0否1是' AFTER language_skills,
ADD COLUMN commitment_name varchar(64) DEFAULT NULL COMMENT '承诺人姓名' AFTER commitment_accepted,
ADD COLUMN commitment_date date DEFAULT NULL COMMENT '承诺日期' AFTER commitment_name;
CREATE TABLE IF NOT EXISTS hr_onboarding_education (
education_id bigint NOT NULL AUTO_INCREMENT,
onboarding_id bigint NOT NULL COMMENT 'hr_onboarding_profile.onboarding_id',
start_date date DEFAULT NULL, end_date date DEFAULT NULL,
school_name varchar(200) DEFAULT NULL, major varchar(100) DEFAULT NULL,
schooling varchar(50) DEFAULT NULL, certificate varchar(200) DEFAULT NULL,
PRIMARY KEY (education_id), KEY idx_hr_onboarding_education (onboarding_id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='入职申请教育及培训经历';
CREATE TABLE IF NOT EXISTS hr_onboarding_work (
work_id bigint NOT NULL AUTO_INCREMENT,
onboarding_id bigint NOT NULL COMMENT 'hr_onboarding_profile.onboarding_id',
start_date date DEFAULT NULL, end_date date DEFAULT NULL,
company_name varchar(200) DEFAULT NULL, department varchar(100) DEFAULT NULL,
position varchar(100) DEFAULT NULL, salary varchar(64) DEFAULT NULL, leave_reason varchar(500) DEFAULT NULL,
PRIMARY KEY (work_id), KEY idx_hr_onboarding_work (onboarding_id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='入职申请工作经历';
CREATE TABLE IF NOT EXISTS hr_onboarding_family (
family_id bigint NOT NULL AUTO_INCREMENT,
onboarding_id bigint NOT NULL COMMENT 'hr_onboarding_profile.onboarding_id',
member_name varchar(64) DEFAULT NULL, relation varchar(32) DEFAULT NULL,
work_unit varchar(200) DEFAULT NULL, phone varchar(32) DEFAULT NULL, current_address varchar(255) DEFAULT NULL,
PRIMARY KEY (family_id), KEY idx_hr_onboarding_family (onboarding_id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='入职申请家庭成员';