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

6 lines
402 B
SQL

ALTER TABLE `hr_resume` ADD COLUMN `gender` varchar(4) NULL AFTER `mobile`;
ALTER TABLE `hr_resume` ADD COLUMN `age` int NULL AFTER `gender`;
ALTER TABLE `hr_resume` ADD COLUMN `work_years` varchar(32) NULL AFTER `age`;
ALTER TABLE `hr_resume` ADD COLUMN `job_intention` varchar(255) NULL AFTER `work_years`;
ALTER TABLE `hr_resume` ADD COLUMN `expected_salary` varchar(64) NULL AFTER `job_intention`;