all-project/docs/设计文档/database/rs-dictionary.sql

-- 人事管理模块数据字典

-- 部门字典
INSERT INTO sys_dict_type(dict_id, dict_name, dict_type, status, create_by, create_time, update_by, update_time, remark)
VALUES (next value for SYSTEM_SEQUENCE_00B09B61_830A_4524_A3F0_86D6EFBB1A72, '部门', 'rs_department', '0', 1, sysdate(), null, null, '人事管理部门字典');

INSERT INTO sys_dict_data(dict_code, dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, update_by, update_time, remark)
VALUES (next value for SYSTEM_SEQUENCE_05F0DC17_58A6_4EFB_B88C_5C877D7B1E93, 1, '技术部', 'tech', 'rs_department', '', 'default', 'Y', '0', 1, sysdate(), null, null, '技术部');
INSERT INTO sys_dict_data(dict_code, dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, update_by, update_time, remark)
VALUES (next value for SYSTEM_SEQUENCE_05F0DC17_58A6_4EFB_B88C_5C877D7B1E93, 2, '人事部', 'hr', 'rs_department', '', 'default', 'N', '0', 1, sysdate(), null, null, '人事部');
INSERT INTO sys_dict_data(dict_code, dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, update_by, update_time, remark)
VALUES (next value for SYSTEM_SEQUENCE_05F0DC17_58A6_4EFB_B88C_5C877D7B1E93, 3, '市场部', 'market', 'rs_department', '', 'default', 'N', '0', 1, sysdate(), null, null, '市场部');
INSERT INTO sys_dict_data(dict_code, dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, update_by, update_time, remark)
VALUES (next value for SYSTEM_SEQUENCE_05F0DC17_58A6_4EFB_B88C_5C877D7B1E93, 4, '销售部', 'sales', 'rs_department', '', 'default', 'N', '0', 1, sysdate(), null, null, '销售部');
INSERT INTO sys_dict_data(dict_code, dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, update_by, update_time, remark)
VALUES (next value for SYSTEM_SEQUENCE_05F0DC17_58A6_4EFB_B88C_5C877D7B1E93, 5, '财务部', 'finance', 'rs_department', '', 'default', 'N', '0', 1, sysdate(), null, null, '财务部');
INSERT INTO sys_dict_data(dict_code, dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, update_by, update_time, remark)
VALUES (next value for SYSTEM_SEQUENCE_05F0DC17_58A6_4EFB_B88C_5C877D7B1E93, 6, '行政部', 'admin', 'rs_department', '', 'default', 'N', '0', 1, sysdate(), null, null, '行政部');
INSERT INTO sys_dict_data(dict_code, dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, update_by, update_time, remark)
VALUES (next value for SYSTEM_SEQUENCE_05F0DC17_58A6_4EFB_B88C_5C877D7B1E93, 7, '后勤部', 'logistics', 'rs_department', '', 'default', 'N', '0', 1, sysdate(), null, null, '后勤部');

-- 应聘状态字典
INSERT INTO sys_dict_type(dict_id, dict_name, dict_type, status, create_by, create_time, update_by, update_time, remark)
VALUES (next value for SYSTEM_SEQUENCE_00B09B61_830A_4524_A3F0_86D6EFBB1A72, '应聘状态', 'rs_application_status', '0', 1, sysdate(), null, null, '应聘状态字典');

INSERT INTO sys_dict_data(dict_code, dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, update_by, update_time, remark)
VALUES (next value for SYSTEM_SEQUENCE_05F0DC17_58A6_4EFB_B88C_5C877D7B1E93, 1, '待处理', 'pending', 'rs_application_status', '', 'info', 'Y', '0', 1, sysdate(), null, null, '待处理');
INSERT INTO sys_dict_data(dict_code, dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, update_by, update_time, remark)
VALUES (next value for SYSTEM_SEQUENCE_05F0DC17_58A6_4EFB_B88C_5C877D7B1E93, 2, '已面试', 'interviewed', 'rs_application_status', '', 'primary', 'N', '0', 1, sysdate(), null, null, '已面试');
INSERT INTO sys_dict_data(dict_code, dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, update_by, update_time, remark)
VALUES (next value for SYSTEM_SEQUENCE_05F0DC17_58A6_4EFB_B88C_5C877D7B1E93, 3, '已录用', 'offered', 'rs_application_status', '', 'success', 'N', '0', 1, sysdate(), null, null, '已录用');
INSERT INTO sys_dict_data(dict_code, dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, update_by, update_time, remark)
VALUES (next value for SYSTEM_SEQUENCE_05F0DC17_58A6_4EFB_B88C_5C877D7B1E93, 4, '已拒绝', 'rejected', 'rs_application_status', '', 'danger', 'N', '0', 1, sysdate(), null, null, '已拒绝');