-- ============================================================
-- 就业一湛通服务平台 - 重点关注人员管理 测试数据
-- 说明：包含个人基本信息和重点关注人员标签数据
-- 注意：personal_info 包含各种类型的求职人员（不限于就业困难/脱贫），
--       其中部分人员被标记为重点关注人员（focus_personnel）
-- 数据库：达梦数据库 (DM8) / MySQL 8.0 兼容
-- 创建日期：2026-06-03
-- ============================================================

DELETE FROM focus_personnel;
DELETE FROM personal_info;

-- ============================================================
-- 个人基本信息（PERSONAL_INFO）
-- 包含各种求职人员类别：新成长失业青年、城镇登记失业人员、
-- 农村转移就业劳动者、应届高校毕业生、退役军人、在业人员等
-- ============================================================

-- 张三 - 新成长失业青年（被标记为就业困难人员）
INSERT INTO personal_info (ID, ID_TYPE, ID_NUMBER, FULL_NAME, GENDER, BIRTH_DATE, NATION, NATIONALITY, MARITAL_STATUS, EDUCATION, GRADUATION_DATE, GRADUATE_SCHOOL, MAJOR, POLITICAL_STATUS, WORK_EXPERIENCE, HOUSEHOLD_TYPE, HOUSEHOLD_LOCATION, CURRENT_RESIDENCE, CURRENT_ADDRESS, JOB_SEEKER_CATEGORY, CONTACT_PHONE, EMAIL, QQ_NUMBER, WECHAT_ID, IS_OVERSEAS_TALENT, SKILL_LEVEL, JOB_SEARCH_STATUS, ACCEPT_RECOMMEND, DATA_SOURCE, CREATE_BY, CREATE_TIME, UPDATE_BY, UPDATE_TIME, SYS_ORG_CODE) VALUES (178060100000200, '居民身份证', '440101199001010011', '张三', '男性', '1990-01-01', '汉族', '中国', '已婚', '大学本科', '2012-06-30', '广东工业大学', '计算机科学与技术', '中共党员', '3-5年', '城镇', '广东省广州市天河区', '广东省广州市天河区', '天河路123号', '新成长失业青年', '13600001111', 'zhangsan@email.com', '123456789', 'zhangsan_wx', '否', '中级', '正在求职', '是', '省系统', 'admin', NOW(), NULL, NOW(), 'A01');

-- 李四 - 城镇登记失业人员（被标记为就业困难人员）
INSERT INTO personal_info (ID, ID_TYPE, ID_NUMBER, FULL_NAME, GENDER, BIRTH_DATE, NATION, NATIONALITY, MARITAL_STATUS, EDUCATION, GRADUATION_DATE, GRADUATE_SCHOOL, MAJOR, POLITICAL_STATUS, WORK_EXPERIENCE, HOUSEHOLD_TYPE, HOUSEHOLD_LOCATION, CURRENT_RESIDENCE, CURRENT_ADDRESS, JOB_SEEKER_CATEGORY, CONTACT_PHONE, EMAIL, QQ_NUMBER, WECHAT_ID, IS_OVERSEAS_TALENT, SKILL_LEVEL, JOB_SEARCH_STATUS, ACCEPT_RECOMMEND, DATA_SOURCE, CREATE_BY, CREATE_TIME, UPDATE_BY, UPDATE_TIME, SYS_ORG_CODE) VALUES (178060100000201, '居民身份证', '440102198507150022', '李四', '女性', '1985-07-15', '汉族', '中国', '未婚', '大学专科', '2007-06-30', '湛江师范学院', '汉语言文学', '群众', '5-10年', '城镇', '广东省湛江市赤坎区', '广东省湛江市赤坎区', '海北路456号', '城镇登记失业人员', '13700002222', 'lisi@email.com', '987654321', 'lisi_wx', '否', '无', '正在求职', '是', '省系统', 'admin', NOW(), NULL, NOW(), 'A01');

-- 王五 - 农村转移就业劳动者（被标记为脱贫人员）
INSERT INTO personal_info (ID, ID_TYPE, ID_NUMBER, FULL_NAME, GENDER, BIRTH_DATE, NATION, NATIONALITY, MARITAL_STATUS, EDUCATION, GRADUATION_DATE, GRADUATE_SCHOOL, MAJOR, POLITICAL_STATUS, WORK_EXPERIENCE, HOUSEHOLD_TYPE, HOUSEHOLD_LOCATION, CURRENT_RESIDENCE, CURRENT_ADDRESS, JOB_SEEKER_CATEGORY, CONTACT_PHONE, EMAIL, QQ_NUMBER, WECHAT_ID, IS_OVERSEAS_TALENT, SKILL_LEVEL, JOB_SEARCH_STATUS, ACCEPT_RECOMMEND, DATA_SOURCE, CREATE_BY, CREATE_TIME, UPDATE_BY, UPDATE_TIME, SYS_ORG_CODE) VALUES (178060100000202, '居民身份证', '440103197803250033', '王五', '男性', '1978-03-25', '汉族', '中国', '已婚', '初中', '1993-06-30', '湛江一中', NULL, '群众', '10年以上', '农村', '广东省湛江市麻章区', '广东省湛江市麻章区', '麻章镇前进路789号', '农村转移就业劳动者', '13800003333', 'wangwu@email.com', '555666777', 'wangwu_wx', '否', '无', '正在求职', '是', '市系统', 'admin', NOW(), NULL, NOW(), 'A01');

-- 赵六 - 应届高校毕业生（被标记为脱贫人员）
INSERT INTO personal_info (ID, ID_TYPE, ID_NUMBER, FULL_NAME, GENDER, BIRTH_DATE, NATION, NATIONALITY, MARITAL_STATUS, EDUCATION, GRADUATION_DATE, GRADUATE_SCHOOL, MAJOR, POLITICAL_STATUS, WORK_EXPERIENCE, HOUSEHOLD_TYPE, HOUSEHOLD_LOCATION, CURRENT_RESIDENCE, CURRENT_ADDRESS, JOB_SEEKER_CATEGORY, CONTACT_PHONE, EMAIL, QQ_NUMBER, WECHAT_ID, IS_OVERSEAS_TALENT, SKILL_LEVEL, JOB_SEARCH_STATUS, ACCEPT_RECOMMEND, DATA_SOURCE, CREATE_BY, CREATE_TIME, UPDATE_BY, UPDATE_TIME, SYS_ORG_CODE) VALUES (178060100000203, '居民身份证', '440104199506080044', '赵六', '女性', '1995-06-08', '壮族', '中国', '未婚', '硕士研究生', '2020-06-30', '广西大学', '农学', '共青团员', '1-3年', '农村', '广西壮族自治区南宁市', '广东省湛江市霞山区', '人民大道南567号', '应届高校毕业生', '13900004444', 'zhaoliu@email.com', '111222333', 'zhaoliu_wx', '否', '高级', '正在求职', '是', '省系统', 'admin', NOW(), NULL, NOW(), 'A01');

-- 钱七 - 退役军人（被标记为就业困难人员）
INSERT INTO personal_info (ID, ID_TYPE, ID_NUMBER, FULL_NAME, GENDER, BIRTH_DATE, NATION, NATIONALITY, MARITAL_STATUS, EDUCATION, GRADUATION_DATE, GRADUATE_SCHOOL, MAJOR, POLITICAL_STATUS, WORK_EXPERIENCE, HOUSEHOLD_TYPE, HOUSEHOLD_LOCATION, CURRENT_RESIDENCE, CURRENT_ADDRESS, JOB_SEEKER_CATEGORY, CONTACT_PHONE, EMAIL, QQ_NUMBER, WECHAT_ID, IS_OVERSEAS_TALENT, SKILL_LEVEL, JOB_SEARCH_STATUS, ACCEPT_RECOMMEND, DATA_SOURCE, CREATE_BY, CREATE_TIME, UPDATE_BY, UPDATE_TIME, SYS_ORG_CODE) VALUES (178060100000204, '居民身份证', '440105198812120055', '钱七', '男性', '1988-12-12', '汉族', '中国', '离异', '中专', '2008-06-30', '湛江卫生学校', NULL, '群众', '5-10年', '城镇', '广东省湛江市坡头区', '广东省湛江市坡头区', '南调路321号', '退役军人', '13600005555', 'qianqi@email.com', '444555666', 'qianqi_wx', '否', '中级', '正在求职', '是', '市系统', 'admin', NOW(), NULL, NOW(), 'A01');

-- 孙八 - 在业人员（被标记为就业困难人员）
INSERT INTO personal_info (ID, ID_TYPE, ID_NUMBER, FULL_NAME, GENDER, BIRTH_DATE, NATION, NATIONALITY, MARITAL_STATUS, EDUCATION, GRADUATION_DATE, GRADUATE_SCHOOL, MAJOR, POLITICAL_STATUS, WORK_EXPERIENCE, HOUSEHOLD_TYPE, HOUSEHOLD_LOCATION, CURRENT_RESIDENCE, CURRENT_ADDRESS, JOB_SEEKER_CATEGORY, CONTACT_PHONE, EMAIL, QQ_NUMBER, WECHAT_ID, IS_OVERSEAS_TALENT, SKILL_LEVEL, JOB_SEARCH_STATUS, ACCEPT_RECOMMEND, DATA_SOURCE, CREATE_BY, CREATE_TIME, UPDATE_BY, UPDATE_TIME, SYS_ORG_CODE) VALUES (178060100000205, '居民身份证', '440106199208200066', '孙八', '女性', '1992-08-20', '汉族', '中国', '已婚', '大学本科', '2015-06-30', '华南农业大学', '会计学', '中共党员', '3-5年', '农村', '广东省湛江市廉江市', '广东省湛江市霞山区', '绿塘路88号', '在业人员', '15000006666', 'sunba@email.com', '777888999', 'sunba_wx', '否', '中级', '正在求职', '是', '省系统', 'admin', NOW(), NULL, NOW(), 'A01');

-- 周九 - 应届高校毕业生（被标记为见习人员，在见习人员测试数据中）
INSERT INTO personal_info (ID, ID_TYPE, ID_NUMBER, FULL_NAME, GENDER, BIRTH_DATE, NATION, NATIONALITY, MARITAL_STATUS, EDUCATION, GRADUATION_DATE, GRADUATE_SCHOOL, MAJOR, POLITICAL_STATUS, WORK_EXPERIENCE, HOUSEHOLD_TYPE, HOUSEHOLD_LOCATION, CURRENT_RESIDENCE, CURRENT_ADDRESS, JOB_SEEKER_CATEGORY, CONTACT_PHONE, EMAIL, QQ_NUMBER, WECHAT_ID, IS_OVERSEAS_TALENT, SKILL_LEVEL, JOB_SEARCH_STATUS, ACCEPT_RECOMMEND, DATA_SOURCE, CREATE_BY, CREATE_TIME, UPDATE_BY, UPDATE_TIME, SYS_ORG_CODE) VALUES (178060100000206, '居民身份证', '440107200001010066', '周九', '男性', '2000-01-01', '汉族', '中国', '未婚', '大学本科', '2023-06-30', '岭南师范学院', '计算机科学与技术', '共青团员', '1年以下', '城镇', '广东省湛江市赤坎区', '广东省湛江市赤坎区', '寸金路29号', '应届高校毕业生', '13600007777', 'zhoujiu@email.com', '111223344', 'zhoujiu_wx', '否', '初级', '正在求职', '是', '省系统', 'admin', NOW(), NULL, NOW(), 'A01');

-- 吴十 - 新成长失业青年（被标记为见习人员，在见习人员测试数据中）
INSERT INTO personal_info (ID, ID_TYPE, ID_NUMBER, FULL_NAME, GENDER, BIRTH_DATE, NATION, NATIONALITY, MARITAL_STATUS, EDUCATION, GRADUATION_DATE, GRADUATE_SCHOOL, MAJOR, POLITICAL_STATUS, WORK_EXPERIENCE, HOUSEHOLD_TYPE, HOUSEHOLD_LOCATION, CURRENT_RESIDENCE, CURRENT_ADDRESS, JOB_SEEKER_CATEGORY, CONTACT_PHONE, EMAIL, QQ_NUMBER, WECHAT_ID, IS_OVERSEAS_TALENT, SKILL_LEVEL, JOB_SEARCH_STATUS, ACCEPT_RECOMMEND, DATA_SOURCE, CREATE_BY, CREATE_TIME, UPDATE_BY, UPDATE_TIME, SYS_ORG_CODE) VALUES (178060100000207, '居民身份证', '440108200103150088', '吴十', '女性', '2001-03-15', '汉族', '中国', '未婚', '大学专科', '2024-06-30', '广东文理职业学院', '文秘', '共青团员', '1年以下', '城镇', '广东省湛江市霞山区', '广东省湛江市霞山区', '解放西路22号', '新成长失业青年', '13700008888', 'wushi@email.com', '222334455', 'wushi_wx', '否', '无', '正在求职', '是', '省系统', 'admin', NOW(), NULL, NOW(), 'A01');

-- 郑十一 - 农村转移就业劳动者（被标记为见习人员，在见习人员测试数据中）
INSERT INTO personal_info (ID, ID_TYPE, ID_NUMBER, FULL_NAME, GENDER, BIRTH_DATE, NATION, NATIONALITY, MARITAL_STATUS, EDUCATION, GRADUATION_DATE, GRADUATE_SCHOOL, MAJOR, POLITICAL_STATUS, WORK_EXPERIENCE, HOUSEHOLD_TYPE, HOUSEHOLD_LOCATION, CURRENT_RESIDENCE, CURRENT_ADDRESS, JOB_SEEKER_CATEGORY, CONTACT_PHONE, EMAIL, QQ_NUMBER, WECHAT_ID, IS_OVERSEAS_TALENT, SKILL_LEVEL, JOB_SEARCH_STATUS, ACCEPT_RECOMMEND, DATA_SOURCE, CREATE_BY, CREATE_TIME, UPDATE_BY, UPDATE_TIME, SYS_ORG_CODE) VALUES (178060100000208, '居民身份证', '440109200205200099', '郑十一', '男性', '2002-05-20', '汉族', '中国', '未婚', '中专', '2020-06-30', '湛江机电学校', '机电一体化', '共青团员', '1-3年', '城镇', '广东省湛江市麻章区', '广东省湛江市麻章区', '金康路88号', '农村转移就业劳动者', '13800009999', 'zhengshiyi@email.com', '333445566', 'zhengshiyi_wx', '否', '初级', '正在求职', '是', '市系统', 'admin', NOW(), NULL, NOW(), 'A01');

-- 陈十二 - 应届高校毕业生（未被任何模块标记，仅作为求职信息库中的普通人员）
INSERT INTO personal_info (ID, ID_TYPE, ID_NUMBER, FULL_NAME, GENDER, BIRTH_DATE, NATION, NATIONALITY, MARITAL_STATUS, EDUCATION, GRADUATION_DATE, GRADUATE_SCHOOL, MAJOR, POLITICAL_STATUS, WORK_EXPERIENCE, HOUSEHOLD_TYPE, HOUSEHOLD_LOCATION, CURRENT_RESIDENCE, CURRENT_ADDRESS, JOB_SEEKER_CATEGORY, CONTACT_PHONE, EMAIL, QQ_NUMBER, WECHAT_ID, IS_OVERSEAS_TALENT, SKILL_LEVEL, JOB_SEARCH_STATUS, ACCEPT_RECOMMEND, DATA_SOURCE, CREATE_BY, CREATE_TIME, UPDATE_BY, UPDATE_TIME, SYS_ORG_CODE) VALUES (178060100000209, '居民身份证', '440110200306150077', '陈十二', '男性', '2003-06-15', '汉族', '中国', '未婚', '大学本科', '2025-06-30', '广东海洋大学', '水产养殖', '共青团员', '无经验', '农村', '广东省湛江市遂溪县', '广东省湛江市麻章区', '海大路1号', '应届高校毕业生', '13600001001', 'chen12@email.com', '998877665', 'chen12_wx', '否', '无', '正在求职', '是', '省系统', 'admin', NOW(), NULL, NOW(), 'A01');

-- ============================================================
-- 重点关注人员标签（FOCUS_PERSONNEL）
-- 注意：只有部分求职人员被标记为重点关注人员，
--       并非所有人员都属于就业困难或脱贫类型
-- ============================================================
INSERT INTO focus_personnel (ID, PERSONAL_ID, MAJOR_TAG, MINOR_TAG, CUSTOM_TAG) VALUES (178060100000210, 178060100000200, '就业困难人员', '长期失业人员', '计算机专业背景，适合IT岗位');
INSERT INTO focus_personnel (ID, PERSONAL_ID, MAJOR_TAG, MINOR_TAG, CUSTOM_TAG) VALUES (178060100000211, 178060100000201, '就业困难人员', '女性失业人员', '有文秘经验，优先推荐文职工作');
INSERT INTO focus_personnel (ID, PERSONAL_ID, MAJOR_TAG, MINOR_TAG, CUSTOM_TAG) VALUES (178060100000212, 178060100000202, '脱贫人员', '脱贫监测户', '体力劳动能力强，适合建筑/搬运岗位');
INSERT INTO focus_personnel (ID, PERSONAL_ID, MAJOR_TAG, MINOR_TAG, CUSTOM_TAG) VALUES (178060100000213, 178060100000203, '脱贫人员', '脱贫边缘户', '农学硕士，可推荐农业技术岗位');
INSERT INTO focus_personnel (ID, PERSONAL_ID, MAJOR_TAG, MINOR_TAG, CUSTOM_TAG) VALUES (178060100000214, 178060100000204, '就业困难人员', '4050人员', '退役军人，有驾驶证B照');
INSERT INTO focus_personnel (ID, PERSONAL_ID, MAJOR_TAG, MINOR_TAG, CUSTOM_TAG) VALUES (178060100000215, 178060100000205, '就业困难人员', '零就业家庭', '有会计证，可推荐财务岗位');
