all-project/backend/script/sql/zsjy_graduate_dict_data.sql

-- 毕业生信息管理字典数据插入脚本

-- 1. 创建学历层次字典类型
INSERT INTO sys_dict_type (dict_id, tenant_id, dict_name, dict_type, create_by, create_time, remark)
VALUES (2000001, '000000', '学历层次', 'zsjy_education_level', 1, NOW(), '学历层次列表');

-- 2. 创建就业状态字典类型
INSERT INTO sys_dict_type (dict_id, tenant_id, dict_name, dict_type, create_by, create_time, remark)
VALUES (2000002, '000000', '毕业生就业状态', 'zsjy_graduate_employment_status', 1, NOW(), '毕业生就业状态');

-- 3. 创建单位性质字典类型
INSERT INTO sys_dict_type (dict_id, tenant_id, dict_name, dict_type, create_by, create_time, remark)
VALUES (2000003, '000000', '就业单位性质', 'zsjy_graduate_company_type', 1, NOW(), '就业单位性质');

-- 4. 创建月薪范围字典类型
INSERT INTO sys_dict_type (dict_id, tenant_id, dict_name, dict_type, create_by, create_time, remark)
VALUES (2000004, '000000', '月薪范围', 'zsjy_graduate_salary_range', 1, NOW(), '月薪范围');

-- 5. 创建审核状态字典类型
INSERT INTO sys_dict_type (dict_id, tenant_id, dict_name, dict_type, create_by, create_time, remark)
VALUES (2000005, '000000', '毕业生信息审核状态', 'zsjy_graduate_audit_status', 1, NOW(), '审核状态');

-- 插入学历层次字典数据
INSERT INTO sys_dict_data (dict_code, tenant_id, dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, create_by, create_time, remark) VALUES
(2000001, '000000', 1, '专科', '1', 'zsjy_education_level', '', '', 'N', 1, NOW(), '专科'),
(2000002, '000000', 2, '本科', '2', 'zsjy_education_level', '', '', 'Y', 1, NOW(), '本科'),
(2000003, '000000', 3, '硕士', '3', 'zsjy_education_level', '', '', 'N', 1, NOW(), '硕士'),
(2000004, '000000', 4, '博士', '4', 'zsjy_education_level', '', '', 'N', 1, NOW(), '博士');

-- 插入就业状态字典数据
INSERT INTO sys_dict_data (dict_code, tenant_id, dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, create_by, create_time, remark) VALUES
(2000011, '000000', 1, '已就业(劳动合同)', '1', 'zsjy_graduate_employment_status', '', 'success', 'N', 1, NOW(), '签订劳动合同'),
(2000012, '000000', 2, '已就业(就业协议)', '2', 'zsjy_graduate_employment_status', '', 'success', 'N', 1, NOW(), '签订就业协议'),
(2000013, '000000', 3, '自主创业', '3', 'zsjy_graduate_employment_status', '', 'warning', 'N', 1, NOW(), '自主创业'),
(2000014, '000000', 4, '升学(国内)', '4', 'zsjy_graduate_employment_status', '', 'info', 'N', 1, NOW(), '国内升学'),
(2000015, '000000', 5, '升学(国外)', '5', 'zsjy_graduate_employment_status', '', 'info', 'N', 1, NOW(), '国外升学'),
(2000016, '000000', 6, '应征入伍', '6', 'zsjy_graduate_employment_status', '', 'primary', 'N', 1, NOW(), '应征入伍'),
(2000017, '000000', 7, '待就业', '7', 'zsjy_graduate_employment_status', '', 'danger', 'Y', 1, NOW(), '待就业'),
(2000018, '000000', 8, '暂不就业', '8', 'zsjy_graduate_employment_status', '', 'default', 'N', 1, NOW(), '暂不就业');

-- 插入单位性质字典数据
INSERT INTO sys_dict_data (dict_code, tenant_id, dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, create_by, create_time, remark) VALUES
(2000021, '000000', 1, '国有企业', '1', 'zsjy_graduate_company_type', '', '', 'N', 1, NOW(), '国有企业'),
(2000022, '000000', 2, '私营企业', '2', 'zsjy_graduate_company_type', '', '', 'Y', 1, NOW(), '私营企业'),
(2000023, '000000', 3, '外资企业', '3', 'zsjy_graduate_company_type', '', '', 'N', 1, NOW(), '外资企业'),
(2000024, '000000', 4, '机关事业单位', '4', 'zsjy_graduate_company_type', '', '', 'N', 1, NOW(), '机关事业单位'),
(2000025, '000000', 5, '其他', '5', 'zsjy_graduate_company_type', '', '', 'N', 1, NOW(), '其他');

-- 插入月薪范围字典数据
INSERT INTO sys_dict_data (dict_code, tenant_id, dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, create_by, create_time, remark) VALUES
(2000031, '000000', 1, '3000以下', '1', 'zsjy_graduate_salary_range', '', '', 'N', 1, NOW(), '3000以下'),
(2000032, '000000', 2, '3000-5000', '2', 'zsjy_graduate_salary_range', '', '', 'Y', 1, NOW(), '3000-5000'),
(2000033, '000000', 3, '5000-8000', '3', 'zsjy_graduate_salary_range', '', '', 'N', 1, NOW(), '5000-8000'),
(2000034, '000000', 4, '8000-12000', '4', 'zsjy_graduate_salary_range', '', '', 'N', 1, NOW(), '8000-12000'),
(2000035, '000000', 5, '12000以上', '5', 'zsjy_graduate_salary_range', '', '', 'N', 1, NOW(), '12000以上');

-- 插入审核状态字典数据
INSERT INTO sys_dict_data (dict_code, tenant_id, dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, create_by, create_time, remark) VALUES
(2000041, '000000', 1, '待审核', '0', 'zsjy_graduate_audit_status', '', 'warning', 'Y', 1, NOW(), '待审核'),
(2000042, '000000', 2, '已审核', '1', 'zsjy_graduate_audit_status', '', 'success', 'N', 1, NOW(), '已审核'),
(2000043, '000000', 3, '审核拒绝', '2', 'zsjy_graduate_audit_status', '', 'danger', 'N', 1, NOW(), '审核拒绝');