-- ============================================================
-- 湛江市智慧人社运营运维项目 - 就业状态自动感知 真实测试数据脚本
-- 说明：
-- 1. enterprise_status_local 关联 ENTERPRISE_INFO 测试数据 (ID: 178060100000300~304)
-- 2. personal_status_local 关联 PERSONAL_INFO 测试数据 (ID: 178060100000200~205)
-- 3. 达梦数据库兼容格式
-- ============================================================

-- 清理旧数据 (确保幂等性)
DELETE FROM enterprise_status_local;
DELETE FROM personal_status_local;

-- ============================================================
-- 一、企业就业状态本地信息（ENTERPRISE_STATUS_LOCAL）
-- 关联企业：湛江恒兴科技、港湾实业、博文教育、绿源农业、阳光物业
-- ============================================================

-- 湛江恒兴科技有限公司 - 标签：高新技术企业、招聘活跃
INSERT INTO enterprise_status_local (ID, ENTERPRISE_ID, CUSTOM_TAGS, LAST_NOTICE_TIME, CREATE_BY, CREATE_TIME, SYS_ORG_CODE)
VALUES ('178060400000100', '178060100000300', '高新技术企业,招聘活跃', '2026-06-09 10:00:00', 'admin', CURRENT_TIMESTAMP, 'A01');

-- 湛江港湾实业有限公司 - 标签：制造业龙头、用工大户
INSERT INTO enterprise_status_local (ID, ENTERPRISE_ID, CUSTOM_TAGS, LAST_NOTICE_TIME, CREATE_BY, CREATE_TIME, SYS_ORG_CODE)
VALUES ('178060400000101', '178060100000301', '制造业龙头,用工大户', '2026-06-08 15:30:00', 'admin', CURRENT_TIMESTAMP, 'A01');

-- 湛江博文教育培训中心 - 标签：中小企业、应届生友好
INSERT INTO enterprise_status_local (ID, ENTERPRISE_ID, CUSTOM_TAGS, LAST_NOTICE_TIME, CREATE_BY, CREATE_TIME, SYS_ORG_CODE)
VALUES ('178060400000102', '178060100000302', '中小企业,应届生友好', NULL, 'admin', CURRENT_TIMESTAMP, 'A01');

-- 湛江绿源农业科技有限公司 - 标签：农业科技、政策补贴对象
INSERT INTO enterprise_status_local (ID, ENTERPRISE_ID, CUSTOM_TAGS, LAST_NOTICE_TIME, CREATE_BY, CREATE_TIME, SYS_ORG_CODE)
VALUES ('178060400000103', '178060100000303', '农业科技,政策补贴对象', '2026-06-07 09:00:00', 'admin', CURRENT_TIMESTAMP, 'A01');

-- 湛江阳光物业管理有限公司 - 标签：服务业、灵活用工
INSERT INTO enterprise_status_local (ID, ENTERPRISE_ID, CUSTOM_TAGS, LAST_NOTICE_TIME, CREATE_BY, CREATE_TIME, SYS_ORG_CODE)
VALUES ('178060400000104', '178060100000304', '服务业,灵活用工', '2026-06-06 14:00:00', 'admin', CURRENT_TIMESTAMP, 'A01');

-- ============================================================
-- 二、个人就业状态本地信息（PERSONAL_STATUS_LOCAL）
-- 关联个人：张三、李四、王五、赵六、钱七、孙八
-- ============================================================

-- 张三 - 标签：应届毕业生、计算机专业、实习中
INSERT INTO personal_status_local (ID, PERSONAL_ID, CUSTOM_TAGS, LAST_NOTICE_TIME, CREATE_BY, CREATE_TIME, SYS_ORG_CODE)
VALUES ('178060400000200', '178060100000200', '应届毕业生,计算机专业,实习中', '2026-06-09 10:30:00', 'admin', CURRENT_TIMESTAMP, 'A01');

-- 李四 - 标签：城镇失业人员、需转岗培训
INSERT INTO personal_status_local (ID, PERSONAL_ID, CUSTOM_TAGS, LAST_NOTICE_TIME, CREATE_BY, CREATE_TIME, SYS_ORG_CODE)
VALUES ('178060400000201', '178060100000201', '城镇失业人员,需转岗培训', '2026-06-09 09:00:00', 'admin', CURRENT_TIMESTAMP, 'A01');

-- 王五 - 标签：农村转移劳动力、脱贫人口
INSERT INTO personal_status_local (ID, PERSONAL_ID, CUSTOM_TAGS, LAST_NOTICE_TIME, CREATE_BY, CREATE_TIME, SYS_ORG_CODE)
VALUES ('178060400000202', '178060100000202', '农村转移劳动力,脱贫人口', NULL, 'admin', CURRENT_TIMESTAMP, 'A01');

-- 赵六 - 标签：高校毕业生、农学专业
INSERT INTO personal_status_local (ID, PERSONAL_ID, CUSTOM_TAGS, LAST_NOTICE_TIME, CREATE_BY, CREATE_TIME, SYS_ORG_CODE)
VALUES ('178060400000203', '178060100000203', '高校毕业生,农学专业', '2026-06-08 16:00:00', 'admin', CURRENT_TIMESTAMP, 'A01');

-- 钱七 - 标签：退役军人、优先安置
INSERT INTO personal_status_local (ID, PERSONAL_ID, CUSTOM_TAGS, LAST_NOTICE_TIME, CREATE_BY, CREATE_TIME, SYS_ORG_CODE)
VALUES ('178060400000204', '178060100000204', '退役军人,优先安置', '2026-06-07 11:00:00', 'admin', CURRENT_TIMESTAMP, 'A01');

-- 孙八 - 标签：在业人员、零就业家庭
INSERT INTO personal_status_local (ID, PERSONAL_ID, CUSTOM_TAGS, LAST_NOTICE_TIME, CREATE_BY, CREATE_TIME, SYS_ORG_CODE)
VALUES ('178060400000205', '178060100000205', '在业人员,零就业家庭', NULL, 'admin', CURRENT_TIMESTAMP, 'A01');
