zjrs-jeecgBoot/.docs/sql/新增模块测试数据.sql

-- ============================================================
-- 就业一湛通服务平台 - 新增模块测试数据
-- 包含：企业信息、岗位信息、见习岗位、见习人员、公益性岗位、岗位推荐
-- 注意：依赖重点关注人员测试数据中的 personal_info 数据（ID: 178060100000200~209）
--       personal_info 已在"重点关注人员测试数据.sql"中定义
-- 数据库：达梦数据库 (DM8) / MySQL 8.0 兼容
-- 创建日期：2026-06-03
-- ============================================================

-- ============================================================
-- 清空已有数据（按依赖倒序删除，支持重复执行）
-- ============================================================
DELETE FROM job_recommend;
DELETE FROM internship_personnel;
DELETE FROM welfare_post;
DELETE FROM internship_post;
DELETE FROM post_info;
DELETE FROM enterprise_info;

-- ============================================================
-- 一、企业基本信息（ENTERPRISE_INFO）
-- 供见习岗位、公益性岗位、岗位推荐引用
-- ============================================================
INSERT INTO enterprise_info (ID, COMPANY_NAME, UNIFIED_CREDIT_CODE, ORG_CODE, ESTABLISH_DATE, BUSINESS_STATUS, REGISTERED_CAPITAL, REG_ADDR_DISTRICT, COMPANY_TYPE, ECONOMY_TYPE, INDUSTRY, IS_LISTED_COMPANY, STAFF_SIZE, CONTACT_PERSON, CONTACT_PHONE, ACCEPT_SMS_PUSH, OPEN_TO_JOB_SEEKER, ALLOW_AGENT_SIGNUP, COMPANY_INTRO, OFFICE_ADDR_DISTRICT, OFFICE_ADDRESS, DATA_SOURCE, CREATE_TIME, UPDATE_TIME) VALUES (178060100000300, '湛江恒兴科技有限公司', '91440800MA5XXXX001', 'G2001', '2015-03-15', '登记在册', '1000', '440802', '企业', '私营企业', '信息传输、软件和信息技术服务业', '否', '100-299人', '陈经理', '0759-1111111', '是', '是', '是', '恒兴科技是一家专注于软件开发和高新技术服务的企业，致力于为客户提供优质的IT解决方案。', '440802', '广东省湛江市赤坎区人民大道北88号', '市系统', NOW(), NOW());
INSERT INTO enterprise_info (ID, COMPANY_NAME, UNIFIED_CREDIT_CODE, ORG_CODE, ESTABLISH_DATE, BUSINESS_STATUS, REGISTERED_CAPITAL, REG_ADDR_DISTRICT, COMPANY_TYPE, ECONOMY_TYPE, INDUSTRY, IS_LISTED_COMPANY, STAFF_SIZE, CONTACT_PERSON, CONTACT_PHONE, ACCEPT_SMS_PUSH, OPEN_TO_JOB_SEEKER, ALLOW_AGENT_SIGNUP, COMPANY_INTRO, OFFICE_ADDR_DISTRICT, OFFICE_ADDRESS, DATA_SOURCE, CREATE_TIME, UPDATE_TIME) VALUES (178060100000301, '湛江港湾实业有限公司', '91440800MA5XXXX002', 'G2002', '2010-08-20', '登记在册', '5000', '440803', '企业', '有限责任公司', '制造业', '否', '500-999人', '李主管', '0759-2222222', '是', '是', '是', '港湾实业是粤西地区知名的制造企业，主要生产环保设备和建筑材料。', '440803', '广东省湛江市霞山区建设路66号', '市系统', NOW(), NOW());
INSERT INTO enterprise_info (ID, COMPANY_NAME, UNIFIED_CREDIT_CODE, ORG_CODE, ESTABLISH_DATE, BUSINESS_STATUS, REGISTERED_CAPITAL, REG_ADDR_DISTRICT, COMPANY_TYPE, ECONOMY_TYPE, INDUSTRY, IS_LISTED_COMPANY, STAFF_SIZE, CONTACT_PERSON, CONTACT_PHONE, ACCEPT_SMS_PUSH, OPEN_TO_JOB_SEEKER, ALLOW_AGENT_SIGNUP, COMPANY_INTRO, OFFICE_ADDR_DISTRICT, OFFICE_ADDRESS, DATA_SOURCE, CREATE_TIME, UPDATE_TIME) VALUES (178060100000302, '湛江博文教育培训中心', '91440800MA5XXXX003', 'G2003', '2018-06-01', '登记在册', '200', '440802', '民办非企业', '其他', '教育', '否', '49人及以下', '王校长', '0759-3333333', '是', '是', '是', '博文教育是一家综合性教育培训机构，提供职业技能培训、学历提升等服务。', '440802', '广东省湛江市赤坎区海滨大道中99号', '市系统', NOW(), NOW());
INSERT INTO enterprise_info (ID, COMPANY_NAME, UNIFIED_CREDIT_CODE, ORG_CODE, ESTABLISH_DATE, BUSINESS_STATUS, REGISTERED_CAPITAL, REG_ADDR_DISTRICT, COMPANY_TYPE, ECONOMY_TYPE, INDUSTRY, IS_LISTED_COMPANY, STAFF_SIZE, CONTACT_PERSON, CONTACT_PHONE, ACCEPT_SMS_PUSH, OPEN_TO_JOB_SEEKER, ALLOW_AGENT_SIGNUP, COMPANY_INTRO, OFFICE_ADDR_DISTRICT, OFFICE_ADDRESS, DATA_SOURCE, CREATE_TIME, UPDATE_TIME) VALUES (178060100000303, '湛江绿源农业科技有限公司', '91440800MA5XXXX004', 'G2004', '2016-04-12', '登记在册', '800', '440804', '企业', '私营企业', '农、林、牧、渔业', '否', '100-299人', '赵经理', '0759-4444444', '是', '是', '是', '绿源农业致力于现代农业科技研发与推广，主营有机农产品种植和农业技术培训。', '440804', '广东省湛江市坡头区麻斜路123号', '市系统', NOW(), NOW());
INSERT INTO enterprise_info (ID, COMPANY_NAME, UNIFIED_CREDIT_CODE, ORG_CODE, ESTABLISH_DATE, BUSINESS_STATUS, REGISTERED_CAPITAL, REG_ADDR_DISTRICT, COMPANY_TYPE, ECONOMY_TYPE, INDUSTRY, IS_LISTED_COMPANY, STAFF_SIZE, CONTACT_PERSON, CONTACT_PHONE, ACCEPT_SMS_PUSH, OPEN_TO_JOB_SEEKER, ALLOW_AGENT_SIGNUP, COMPANY_INTRO, OFFICE_ADDR_DISTRICT, OFFICE_ADDRESS, DATA_SOURCE, CREATE_TIME, UPDATE_TIME) VALUES (178060100000304, '湛江阳光物业管理有限公司', '91440800MA5XXXX005', 'G2005', '2012-11-05', '登记在册', '300', '440802', '企业', '有限责任公司', '房地产业', '否', '50-99人', '刘主管', '0759-5555555', '是', '是', '是', '阳光物业专业从事物业管理服务，管理湛江多个大型住宅小区和商业综合体。', '440802', '广东省湛江市赤坎区海田路77号', '市系统', NOW(), NOW());

-- ============================================================
-- 二、岗位信息（POST_INFO）
-- 供岗位推荐模块引用
-- ============================================================
INSERT INTO post_info (ID, ENTERPRISE_ID, OCCUPATION, POST_NAME, WORK_NATURE, SALARY_TYPE, SALARY_MIN, SALARY_MAX, RECRUIT_COUNT, POST_VALID_DATE, POST_TAG, OTHER_BENEFITS, POST_DESC, EDUCATION_REQUIRE, WORK_EXPERIENCE_REQUIRE, SKILL_LEVEL_REQUIRE, FOREIGN_LANGUAGE, LANGUAGE_LEVEL, CONTACT_PERSON, CONTACT_PHONE, WORK_LOCATION, DETAILED_ADDRESS, DATA_SOURCE, CREATE_TIME, UPDATE_TIME) VALUES (178060100000310, 178060100000300, '软件工程师', 'Java开发工程师', '全职', '月薪', 8000, 15000, 5, '2026-12-31', '五险一金,周末双休,年终奖金', '餐补,交通补贴,节日福利', '负责公司核心产品的后端开发工作，参与系统架构设计。', '大学本科', '3-5年', '中级', '英语', 'CET-4', '陈经理', '0759-1111111', '广东省湛江市赤坎区', '人民大道北88号恒兴科技大厦', '市系统', NOW(), NOW());
INSERT INTO post_info (ID, ENTERPRISE_ID, OCCUPATION, POST_NAME, WORK_NATURE, SALARY_TYPE, SALARY_MIN, SALARY_MAX, RECRUIT_COUNT, POST_VALID_DATE, POST_TAG, OTHER_BENEFITS, POST_DESC, EDUCATION_REQUIRE, WORK_EXPERIENCE_REQUIRE, SKILL_LEVEL_REQUIRE, FOREIGN_LANGUAGE, LANGUAGE_LEVEL, CONTACT_PERSON, CONTACT_PHONE, WORK_LOCATION, DETAILED_ADDRESS, DATA_SOURCE, CREATE_TIME, UPDATE_TIME) VALUES (178060100000311, 178060100000301, '质检员', '质量检验员', '全职', '月薪', 3500, 5000, 10, '2026-12-31', '五险,包食宿,加班补贴', '年终奖,带薪年假', '负责生产线产品质量检测和控制，填写质量检验报告。', '中专', '1-3年', '初级', NULL, NULL, '李主管', '0759-2222222', '广东省湛江市霞山区', '建设路66号港湾工业园', '市系统', NOW(), NOW());
INSERT INTO post_info (ID, ENTERPRISE_ID, OCCUPATION, POST_NAME, WORK_NATURE, SALARY_TYPE, SALARY_MIN, SALARY_MAX, RECRUIT_COUNT, POST_VALID_DATE, POST_TAG, OTHER_BENEFITS, POST_DESC, EDUCATION_REQUIRE, WORK_EXPERIENCE_REQUIRE, SKILL_LEVEL_REQUIRE, FOREIGN_LANGUAGE, LANGUAGE_LEVEL, CONTACT_PERSON, CONTACT_PHONE, WORK_LOCATION, DETAILED_ADDRESS, DATA_SOURCE, CREATE_TIME, UPDATE_TIME) VALUES (178060100000312, 178060100000302, '培训讲师', '计算机培训讲师', '全职', '月薪', 5000, 8000, 3, '2026-12-31', '五险一金,双休,带薪培训', '节日福利,年终奖金', '负责成人计算机技能培训课程的授课和课程设计。', '大学本科', '1-3年', '中级', NULL, NULL, '王校长', '0759-3333333', '广东省湛江市赤坎区', '海滨大道中99号博文大厦', '市系统', NOW(), NOW());
INSERT INTO post_info (ID, ENTERPRISE_ID, OCCUPATION, POST_NAME, WORK_NATURE, SALARY_TYPE, SALARY_MIN, SALARY_MAX, RECRUIT_COUNT, POST_VALID_DATE, POST_TAG, OTHER_BENEFITS, POST_DESC, EDUCATION_REQUIRE, WORK_EXPERIENCE_REQUIRE, SKILL_LEVEL_REQUIRE, FOREIGN_LANGUAGE, LANGUAGE_LEVEL, CONTACT_PERSON, CONTACT_PHONE, WORK_LOCATION, DETAILED_ADDRESS, DATA_SOURCE, CREATE_TIME, UPDATE_TIME) VALUES (178060100000313, 178060100000303, '农艺师', '农业技术员', '全职', '月薪', 4000, 6000, 8, '2026-12-31', '五险,包食宿,外出补贴', '年终奖,员工福利', '负责农业技术推广和指导，参与有机农产品种植基地管理。', '大学专科', '不限', '无', NULL, NULL, '赵经理', '0759-4444444', '广东省湛江市坡头区', '麻斜路123号', '市系统', NOW(), NOW());
INSERT INTO post_info (ID, ENTERPRISE_ID, OCCUPATION, POST_NAME, WORK_NATURE, SALARY_TYPE, SALARY_MIN, SALARY_MAX, RECRUIT_COUNT, POST_VALID_DATE, POST_TAG, OTHER_BENEFITS, POST_DESC, EDUCATION_REQUIRE, WORK_EXPERIENCE_REQUIRE, SKILL_LEVEL_REQUIRE, FOREIGN_LANGUAGE, LANGUAGE_LEVEL, CONTACT_PERSON, CONTACT_PHONE, WORK_LOCATION, DETAILED_ADDRESS, DATA_SOURCE, CREATE_TIME, UPDATE_TIME) VALUES (178060100000314, 178060100000304, '物业管理员', '物业管理员', '全职', '月薪', 3000, 4500, 15, '2026-12-31', '五险,月休4天,高温补贴', '节日福利,年终奖金', '负责小区物业日常管理、客户服务、投诉处理等工作。', '高中', '不限', '无', NULL, NULL, '刘主管', '0759-5555555', '广东省湛江市赤坎区', '海田路77号阳光物业服务中心', '市系统', NOW(), NOW());

-- ============================================================
-- 三、见习岗位（INTERNSHIP_POST）
-- 供见习人员模块引用
-- ============================================================
INSERT INTO internship_post (ID, ENTERPRISE_ID, COMPANY_NAME, COMPANY_NATURE, WORK_LOCATION, DETAILED_ADDRESS, CONTACT_PERSON, CONTACT_PHONE, WORK_EMAIL, POST_NAME, IDENTITY_REQUIREMENT, INTERNSHIP_PERIOD, INTERNSHIP_SUBSIDY, INTERNSHIP_COUNT, INTERNSHIP_REQUIREMENT, APPLY_METHOD, APPLY_DEADLINE, RETAIN_SALARY, RETAIN_BENEFITS, PUBLISH_STATUS, PUBLISHER, PUBLISH_TIME, APPLY_STATUS) VALUES (178060100000320, 178060100000300, '湛江恒兴科技有限公司', '私营企业', '广东省湛江市赤坎区', '人民大道北88号恒兴科技大厦', '陈经理', '0759-1111111', 'hr@hengxing.com', '软件测试见习生', '高校毕业生,失业青年', '6个月', '2500', 5, '计算机相关专业优先，熟悉基本办公软件，有责任心。', '网上报名', '2026-09-30', '4000-6000', '五险一金,餐补,提供住宿', '1', '系统管理员', NOW(), '01');
INSERT INTO internship_post (ID, ENTERPRISE_ID, COMPANY_NAME, COMPANY_NATURE, WORK_LOCATION, DETAILED_ADDRESS, CONTACT_PERSON, CONTACT_PHONE, WORK_EMAIL, POST_NAME, IDENTITY_REQUIREMENT, INTERNSHIP_PERIOD, INTERNSHIP_SUBSIDY, INTERNSHIP_COUNT, INTERNSHIP_REQUIREMENT, APPLY_METHOD, APPLY_DEADLINE, RETAIN_SALARY, RETAIN_BENEFITS, PUBLISH_STATUS, PUBLISHER, PUBLISH_TIME, APPLY_STATUS) VALUES (178060100000321, 178060100000301, '湛江港湾实业有限公司', '有限责任公司', '广东省湛江市霞山区', '建设路66号港湾工业园', '李主管', '0759-2222222', 'hr@gangwan.com', '机械维修见习生', '失业青年,脱贫家庭青年', '6个月', '2200', 8, '机械或电气相关专业，动手能力强，吃苦耐劳。', '网上报名', '2026-08-31', '3500-5000', '五险,包食宿,加班补贴', '1', '系统管理员', NOW(), '01');
INSERT INTO internship_post (ID, ENTERPRISE_ID, COMPANY_NAME, COMPANY_NATURE, WORK_LOCATION, DETAILED_ADDRESS, CONTACT_PERSON, CONTACT_PHONE, WORK_EMAIL, POST_NAME, IDENTITY_REQUIREMENT, INTERNSHIP_PERIOD, INTERNSHIP_SUBSIDY, INTERNSHIP_COUNT, INTERNSHIP_REQUIREMENT, APPLY_METHOD, APPLY_DEADLINE, RETAIN_SALARY, RETAIN_BENEFITS, PUBLISH_STATUS, PUBLISHER, PUBLISH_TIME, APPLY_STATUS) VALUES (178060100000322, 178060100000302, '湛江博文教育培训中心', '民办非企业', '广东省湛江市赤坎区', '海滨大道中99号博文大厦', '王校长', '0759-3333333', 'hr@bowen.com', '行政文员见习生', '高校毕业生,失业青年', '3个月', '2000', 3, '熟练使用Office办公软件，沟通能力强，形象良好。', '网上报名', '2026-07-31', '3000-4500', '五险一金,双休,节日福利', '1', '系统管理员', NOW(), '01');
INSERT INTO internship_post (ID, ENTERPRISE_ID, COMPANY_NAME, COMPANY_NATURE, WORK_LOCATION, DETAILED_ADDRESS, CONTACT_PERSON, CONTACT_PHONE, WORK_EMAIL, POST_NAME, IDENTITY_REQUIREMENT, INTERNSHIP_PERIOD, INTERNSHIP_SUBSIDY, INTERNSHIP_COUNT, INTERNSHIP_REQUIREMENT, APPLY_METHOD, APPLY_DEADLINE, RETAIN_SALARY, RETAIN_BENEFITS, PUBLISH_STATUS, PUBLISHER, PUBLISH_TIME, APPLY_STATUS) VALUES (178060100000323, 178060100000303, '湛江绿源农业科技有限公司', '私营企业', '广东省湛江市坡头区', '麻斜路123号', '赵经理', '0759-4444444', 'hr@lvyuan.com', '农业技术见习生', '高校毕业生,脱贫家庭青年', '6个月', '2000', 6, '农业相关专业，热爱农业技术工作，能适应田间工作环境。', '网上报名', '2026-09-30', '3500-5000', '五险,包食宿,外出补贴', '1', '系统管理员', NOW(), '02');
INSERT INTO internship_post (ID, ENTERPRISE_ID, COMPANY_NAME, COMPANY_NATURE, WORK_LOCATION, DETAILED_ADDRESS, CONTACT_PERSON, CONTACT_PHONE, WORK_EMAIL, POST_NAME, IDENTITY_REQUIREMENT, INTERNSHIP_PERIOD, INTERNSHIP_SUBSIDY, INTERNSHIP_COUNT, INTERNSHIP_REQUIREMENT, APPLY_METHOD, APPLY_DEADLINE, RETAIN_SALARY, RETAIN_BENEFITS, PUBLISH_STATUS, PUBLISHER, PUBLISH_TIME, APPLY_STATUS) VALUES (178060100000324, 178060100000304, '湛江阳光物业管理有限公司', '有限责任公司', '广东省湛江市赤坎区', '海田路77号阳光物业服务中心', '刘主管', '0759-5555555', 'hr@yangguang.com', '物业管理见习生', '失业青年,脱贫家庭青年', '3个月', '1800', 10, '专业不限，服务意识强，有良好的沟通协调能力。', '网上报名', '2026-06-30', '2800-4000', '五险,月休4天,高温补贴', '0', NULL, NULL, '01');

-- ============================================================
-- 四、见习人员（INTERNSHIP_PERSONNEL）
-- 关联 personal_info 见习人员（178060100000206~208）和 internship_post（178060100000320~324）
-- ============================================================
INSERT INTO internship_personnel (ID, PERSONAL_ID, INTERNSHIP_POST_ID, INTERNSHIP_STATUS, START_DATE, END_DATE, AUDIT_STATUS, AUDIT_OPINION) VALUES (178060100000330, 178060100000206, 178060100000320, '见习中', '2026-04-01', '2026-09-30', '已通过', '符合见习条件，审核通过');
INSERT INTO internship_personnel (ID, PERSONAL_ID, INTERNSHIP_POST_ID, INTERNSHIP_STATUS, START_DATE, END_DATE, AUDIT_STATUS, AUDIT_OPINION) VALUES (178060100000331, 178060100000207, 178060100000322, '见习中', '2026-05-01', '2026-07-31', '已通过', '符合见习条件，审核通过');
INSERT INTO internship_personnel (ID, PERSONAL_ID, INTERNSHIP_POST_ID, INTERNSHIP_STATUS, START_DATE, END_DATE, AUDIT_STATUS, AUDIT_OPINION) VALUES (178060100000332, 178060100000208, 178060100000321, '已期满', '2025-12-01', '2026-05-31', '已通过', '符合见习条件，审核通过');
INSERT INTO internship_personnel (ID, PERSONAL_ID, INTERNSHIP_POST_ID, INTERNSHIP_STATUS, START_DATE, END_DATE, AUDIT_STATUS, AUDIT_OPINION) VALUES (178060100000333, 178060100000206, 178060100000323, '见习中', '2026-03-15', '2026-09-14', '已通过', '计算机专业背景，推荐到软件测试岗位见习');
INSERT INTO internship_personnel (ID, PERSONAL_ID, INTERNSHIP_POST_ID, INTERNSHIP_STATUS, START_DATE, END_DATE, AUDIT_STATUS, AUDIT_OPINION) VALUES (178060100000334, 178060100000207, 178060100000324, '待审核', NULL, NULL, '待审核', NULL);

-- ============================================================
-- 五、公益性岗位（WELFARE_POST）
-- ============================================================
INSERT INTO welfare_post (ID, ENTERPRISE_ID, COMPANY_NAME, POST_NAME, POST_TYPE, WORK_LOCATION, DETAILED_ADDRESS, RECRUIT_COUNT, PLACED_COUNT, SUBSIDY_STANDARD, SUBSIDY_PERIOD, SOCIAL_SECURITY_SUBSIDY, POST_DESC, POST_REQUIREMENT, APPLY_METHOD, APPLY_DEADLINE, PUBLISH_STATUS, POST_STATUS, PUBLISHER, PUBLISH_TIME) VALUES (178060100000340, 178060100000304, '湛江阳光物业管理有限公司', '社区保洁员', '社区服务', '广东省湛江市赤坎区', '海田路阳光花园小区', 5, 2, '每月1620元', '最长3年', '按规定缴纳社会保险', '负责阳光花园小区的公共区域清洁保洁工作。', '就业困难人员，身体健康，能胜任保洁工作。', '现场报名', '2026-09-30', '1', '招聘中', '系统管理员', NOW());
INSERT INTO welfare_post (ID, ENTERPRISE_ID, COMPANY_NAME, POST_NAME, POST_TYPE, WORK_LOCATION, DETAILED_ADDRESS, RECRUIT_COUNT, PLACED_COUNT, SUBSIDY_STANDARD, SUBSIDY_PERIOD, SOCIAL_SECURITY_SUBSIDY, POST_DESC, POST_REQUIREMENT, APPLY_METHOD, APPLY_DEADLINE, PUBLISH_STATUS, POST_STATUS, PUBLISHER, PUBLISH_TIME) VALUES (178060100000341, 178060100000300, '湛江恒兴科技有限公司', '门卫值班员', '公共管理', '广东省湛江市赤坎区', '人民大道北88号恒兴科技大厦', 3, 1, '每月1620元', '最长3年', '按规定缴纳社会保险', '负责科技大厦的门卫值班、来访登记和安全巡查工作。', '就业困难人员，责任心强，能适应轮班制。', '现场报名', '2026-08-31', '1', '招聘中', '系统管理员', NOW());
INSERT INTO welfare_post (ID, ENTERPRISE_ID, COMPANY_NAME, POST_NAME, POST_TYPE, WORK_LOCATION, DETAILED_ADDRESS, RECRUIT_COUNT, PLACED_COUNT, SUBSIDY_STANDARD, SUBSIDY_PERIOD, SOCIAL_SECURITY_SUBSIDY, POST_DESC, POST_REQUIREMENT, APPLY_METHOD, APPLY_DEADLINE, PUBLISH_STATUS, POST_STATUS, PUBLISHER, PUBLISH_TIME) VALUES (178060100000342, 178060100000300, '湛江恒兴科技有限公司', '食堂帮厨', '后勤服务', '广东省湛江市赤坎区', '人民大道北88号恒兴科技大厦', 2, 2, '每月1620元', '最长3年', '按规定缴纳社会保险', '负责员工食堂的食材清洗、餐具消毒和厨房卫生工作。', '就业困难人员，持有效健康证，有食堂工作经验优先。', '现场报名', '2026-07-31', '1', '已满', '系统管理员', NOW());
INSERT INTO welfare_post (ID, ENTERPRISE_ID, COMPANY_NAME, POST_NAME, POST_TYPE, WORK_LOCATION, DETAILED_ADDRESS, RECRUIT_COUNT, PLACED_COUNT, SUBSIDY_STANDARD, SUBSIDY_PERIOD, SOCIAL_SECURITY_SUBSIDY, POST_DESC, POST_REQUIREMENT, APPLY_METHOD, APPLY_DEADLINE, PUBLISH_STATUS, POST_STATUS, PUBLISHER, PUBLISH_TIME) VALUES (178060100000343, 178060100000304, '湛江阳光物业管理有限公司', '绿化养护员', '城市管理', '广东省湛江市赤坎区', '海田路阳光花园小区', 4, 0, '每月1620元', '最长3年', '按规定缴纳社会保险', '负责阳光花园小区的绿化带修剪、浇水、养护工作。', '就业困难人员，热爱园艺工作，有绿化养护经验优先。', '现场报名', '2026-10-31', '0', '招聘中', NULL, NULL);
INSERT INTO welfare_post (ID, ENTERPRISE_ID, COMPANY_NAME, POST_NAME, POST_TYPE, WORK_LOCATION, DETAILED_ADDRESS, RECRUIT_COUNT, PLACED_COUNT, SUBSIDY_STANDARD, SUBSIDY_PERIOD, SOCIAL_SECURITY_SUBSIDY, POST_DESC, POST_REQUIREMENT, APPLY_METHOD, APPLY_DEADLINE, PUBLISH_STATUS, POST_STATUS, PUBLISHER, PUBLISH_TIME) VALUES (178060100000344, 178060100000304, '湛江阳光物业管理有限公司', '治安巡逻员', '公共管理', '广东省湛江市赤坎区', '海田路阳光花园小区', 6, 3, '每月1620元', '最长3年', '按规定缴纳社会保险', '负责阳光花园小区的治安巡逻、车辆管理和安全隐患排查。', '就业困难人员，身体健康，责任心强。', '现场报名', '2026-09-30', '1', '招聘中', '系统管理员', NOW());

-- ============================================================
-- 六、岗位推荐（JOB_RECOMMEND）
-- 关联 personal_info（178060100000200~205）和 post_info（178060100000310~314）
-- ============================================================
INSERT INTO job_recommend (ID, PERSONAL_ID, POST_ID, RECOMMEND_TYPE, RECOMMEND_OPINION, RECOMMEND_STATUS) VALUES (178060100000350, 178060100000200, 178060100000310, '岗位推荐到人', '该人员有计算机专业背景，5年以上开发经验，推荐Java开发工程师岗位。', '已查看');
INSERT INTO job_recommend (ID, PERSONAL_ID, POST_ID, RECOMMEND_TYPE, RECOMMEND_OPINION, RECOMMEND_STATUS) VALUES (178060100000351, 178060100000201, 178060100000312, '岗位推荐到人', '该人员有文秘经验，沟通能力强，推荐计算机培训讲师岗位。', '待查看');
INSERT INTO job_recommend (ID, PERSONAL_ID, POST_ID, RECOMMEND_TYPE, RECOMMEND_OPINION, RECOMMEND_STATUS) VALUES (178060100000352, 178060100000203, 178060100000313, '岗位推荐到人', '该人员为农学硕士，专业对口，推荐农业技术员岗位。', '已接受');
INSERT INTO job_recommend (ID, PERSONAL_ID, POST_ID, RECOMMEND_TYPE, RECOMMEND_OPINION, RECOMMEND_STATUS) VALUES (178060100000353, 178060100000202, 178060100000311, '人推荐到岗位', '质检岗位需要责任心强的人员，该人员工作认真负责，推荐此岗位。', '待查看');
INSERT INTO job_recommend (ID, PERSONAL_ID, POST_ID, RECOMMEND_TYPE, RECOMMEND_OPINION, RECOMMEND_STATUS) VALUES (178060100000354, 178060100000205, 178060100000314, '岗位推荐到人', '该人员有会计证，工作细致，适合物业管理员岗位。', '已拒绝');