zjrs-jeecgBoot/.docs/sql/就业登记-测试数据.sql

-- ============================================================
-- 就业一湛通服务平台 - 就业登记模块 测试数据
-- 数据库：达梦数据库 (DM8) / MySQL 8.0 兼容
-- 创建日期：2026-06-12
-- 引用已有的 personal_info 记录
-- ============================================================

-- 先清理旧数据
DELETE FROM employment_registration_service_follow;
DELETE FROM employment_registration;

-- ============================================================
-- 就业登记（EMPLOYMENT_REGISTRATION）
-- ============================================================

-- 张三 - 已登记
INSERT INTO employment_registration (ID, PERSONAL_ID, PROVINCE_RECORD_ID, REGISTRATION_STATUS, LAST_NOTICE_TIME)
VALUES ('178061200000301', '178060100000200', 'PROV-EMP-2026-00001', '已登记', '2026-06-10 09:30:00');

-- 李四 - 应登记
INSERT INTO employment_registration (ID, PERSONAL_ID, PROVINCE_RECORD_ID, REGISTRATION_STATUS, LAST_NOTICE_TIME)
VALUES ('178061200000302', '178060100000201', 'PROV-EMP-2026-00002', '应登记', NULL);

-- 王五 - 未登记
INSERT INTO employment_registration (ID, PERSONAL_ID, PROVINCE_RECORD_ID, REGISTRATION_STATUS, LAST_NOTICE_TIME)
VALUES ('178061200000303', '178060100000202', 'PROV-EMP-2026-00003', '未登记', '2026-06-09 14:00:00');

-- 赵六 - 已登记
INSERT INTO employment_registration (ID, PERSONAL_ID, PROVINCE_RECORD_ID, REGISTRATION_STATUS, LAST_NOTICE_TIME)
VALUES ('178061200000304', '178060100000203', 'PROV-EMP-2026-00004', '已登记', '2026-06-11 10:00:00');

-- 钱七 - 应登记
INSERT INTO employment_registration (ID, PERSONAL_ID, PROVINCE_RECORD_ID, REGISTRATION_STATUS, LAST_NOTICE_TIME)
VALUES ('178061200000305', '178060100000204', 'PROV-EMP-2026-00005', '应登记', NULL);

-- 孙八 - 未登记
INSERT INTO employment_registration (ID, PERSONAL_ID, PROVINCE_RECORD_ID, REGISTRATION_STATUS, LAST_NOTICE_TIME)
VALUES ('178061200000306', '178060100000205', 'PROV-EMP-2026-00006', '未登记', NULL);

-- 陈十二 - 已登记
INSERT INTO employment_registration (ID, PERSONAL_ID, PROVINCE_RECORD_ID, REGISTRATION_STATUS, LAST_NOTICE_TIME)
VALUES ('178061200000307', '178060100000209', 'PROV-EMP-2026-00007', '已登记', '2026-06-10 16:00:00');

-- ============================================================
-- 服务跟进记录（EMPLOYMENT_REGISTRATION_SERVICE_FOLLOW）
-- ============================================================

-- 张三的服务跟进记录
INSERT INTO employment_registration_service_follow (ID, REGISTRATION_ID, SERVICE_CONTENT, SERVICE_TIME, SERVICE_PROVIDER)
VALUES ('178061200000401', '178061200000301', '电话通知已登记人员确认就业状态', '2026-06-10 10:00:00', '管理员');

INSERT INTO employment_registration_service_follow (ID, REGISTRATION_ID, SERVICE_CONTENT, SERVICE_TIME, SERVICE_PROVIDER)
VALUES ('178061200000402', '178061200000301', '发送就业政策解读短信', '2026-06-10 15:00:00', '管理员');

-- 王五的服务跟进记录
INSERT INTO employment_registration_service_follow (ID, REGISTRATION_ID, SERVICE_CONTENT, SERVICE_TIME, SERVICE_PROVIDER)
VALUES ('178061200000403', '178061200000303', '电话提醒未登记人员尽快办理就业登记', '2026-06-09 14:30:00', '管理员');