zjrs-jeecgBoot/.docs/sql/数据字典数据插入.sql

-- ----------------------------
-- 达梦数据库 - 系统字典数据插入语句
-- Source: 数据字典设置.txt
-- Date: 2026-06-04
-- ----------------------------

-- ----------------------------
-- 1. 证件类型 (IDType)
-- ----------------------------
INSERT INTO "DICTIONARY"
VALUES ('IDType', '证件类型', 1, 1);
INSERT INTO "DICTIONARY_ITEM"
VALUES ('1174509082208395266', '', 'IDType', 1, '居民身份证(户口簿)', 1, 1, 1);

-- ----------------------------
-- 2. 性别 (Gender)
-- ----------------------------
INSERT INTO "DICTIONARY"
VALUES ('Gender', '性别', 2, 1);
INSERT INTO "DICTIONARY_ITEM"
VALUES ('1174509082208395267', '', 'Gender', 1, '男', 1, 1, 1);
INSERT INTO "DICTIONARY_ITEM"
VALUES ('1174509082208395268', '', 'Gender', 2, '女', 2, 1, 1);

-- ----------------------------
-- 3. 婚姻状况 (MaritalStatus)
-- ----------------------------
INSERT INTO "DICTIONARY"
VALUES ('MaritalStatus', '婚姻状况', 3, 1);
INSERT INTO "DICTIONARY_ITEM"
VALUES ('1174509082208395269', '', 'MaritalStatus', 1, '未婚', 1, 1, 1);
INSERT INTO "DICTIONARY_ITEM"
VALUES ('1174509082208395270', '', 'MaritalStatus', 2, '已婚', 2, 1, 1);
INSERT INTO "DICTIONARY_ITEM"
VALUES ('1174509082208395271', '', 'MaritalStatus', 3, '丧偶', 3, 1, 1);
INSERT INTO "DICTIONARY_ITEM"
VALUES ('1174509082208395272', '', 'MaritalStatus', 4, '离婚', 4, 1, 1);
INSERT INTO "DICTIONARY_ITEM"
VALUES ('1174509082208395273', '', 'MaritalStatus', 5, '未说明的婚姻状况', 5, 1, 1);

-- ----------------------------
-- 4. 政治面貌 (PoliticalStatus)
-- ----------------------------
INSERT INTO "DICTIONARY"
VALUES ('PoliticalStatus', '政治面貌', 4, 1);
INSERT INTO "DICTIONARY_ITEM"
VALUES ('1174509082208395274', '', 'PoliticalStatus', 1, '中共党员', 1, 1, 1);
INSERT INTO "DICTIONARY_ITEM"
VALUES ('1174509082208395275', '', 'PoliticalStatus', 2, '中共预备党员', 2, 1, 1);
INSERT INTO "DICTIONARY_ITEM"
VALUES ('1174509082208395276', '', 'PoliticalStatus', 3, '共青团员', 3, 1, 1);
INSERT INTO "DICTIONARY_ITEM"
VALUES ('1174509082208395277', '', 'PoliticalStatus', 4, '民革会员', 4, 1, 1);
INSERT INTO "DICTIONARY_ITEM"
VALUES ('1174509082208395278', '', 'PoliticalStatus', 5, '民盟盟员', 5, 1, 1);
INSERT INTO "DICTIONARY_ITEM"
VALUES ('1174509082208395279', '', 'PoliticalStatus', 6, '民建会员', 6, 1, 1);
INSERT INTO "DICTIONARY_ITEM"
VALUES ('1174509082208395280', '', 'PoliticalStatus', 7, '民进会员', 7, 1, 1);
INSERT INTO "DICTIONARY_ITEM"
VALUES ('1174509082208395281', '', 'PoliticalStatus', 8, '农工党党员', 8, 1, 1);
INSERT INTO "DICTIONARY_ITEM"
VALUES ('1174509082208395282', '', 'PoliticalStatus', 9, '致公党党员', 9, 1, 1);
INSERT INTO "DICTIONARY_ITEM"
VALUES ('1174509082208395283', '', 'PoliticalStatus', 10, '九三学社社员', 10, 1, 1);
INSERT INTO "DICTIONARY_ITEM"
VALUES ('1174509082208395284', '', 'PoliticalStatus', 11, '台盟盟员', 11, 1, 1);
INSERT INTO "DICTIONARY_ITEM"
VALUES ('1174509082208395285', '', 'PoliticalStatus', 12, '无党派民主人士', 12, 1, 1);
INSERT INTO "DICTIONARY_ITEM"
VALUES ('1174509082208395286', '', 'PoliticalStatus', 13, '群众', 13, 1, 1);

-- ----------------------------
-- 5. 工作经验 (WorkExperience)
-- ----------------------------
INSERT INTO "DICTIONARY"
VALUES ('WorkExperience', '工作经验', 5, 1);
INSERT INTO "DICTIONARY_ITEM"
VALUES ('1174509082208395287', '', 'WorkExperience', 1, '无经验', 1, 1, 1);
INSERT INTO "DICTIONARY_ITEM"
VALUES ('1174509082208395288', '', 'WorkExperience', 2, '1年以下', 2, 1, 1);
INSERT INTO "DICTIONARY_ITEM"
VALUES ('1174509082208395289', '', 'WorkExperience', 3, '1-3年', 3, 1, 1);
INSERT INTO "DICTIONARY_ITEM"
VALUES ('1174509082208395290', '', 'WorkExperience', 4, '3-5年', 4, 1, 1);
INSERT INTO "DICTIONARY_ITEM"
VALUES ('1174509082208395291', '', 'WorkExperience', 5, '5-10年', 5, 1, 1);
INSERT INTO "DICTIONARY_ITEM"
VALUES ('1174509082208395292', '', 'WorkExperience', 6, '10年以上', 6, 1, 1);

-- ----------------------------
-- 6. 户口性质 (HouseholdType)
-- ----------------------------
INSERT INTO "DICTIONARY"
VALUES ('HouseholdType', '户口性质', 6, 1);
INSERT INTO "DICTIONARY_ITEM"
VALUES ('1174509082208395293', '', 'HouseholdType', 1, '非农业户口(城镇)', 1, 1, 1);
INSERT INTO "DICTIONARY_ITEM"
VALUES ('1174509082208395294', '', 'HouseholdType', 2, '农业户口(农村)', 2, 1, 1);
INSERT INTO "DICTIONARY_ITEM"
VALUES ('1174509082208395295', '', 'HouseholdType', 3, '台港澳人员', 3, 1, 1);
INSERT INTO "DICTIONARY_ITEM"
VALUES ('1174509082208395296', '', 'HouseholdType', 4, '香港特别行政区居民', 4, 1, 1);
INSERT INTO "DICTIONARY_ITEM"
VALUES ('1174509082208395297', '', 'HouseholdType', 5, '澳门特别行政区居民', 5, 1, 1);
INSERT INTO "DICTIONARY_ITEM"
VALUES ('1174509082208395298', '', 'HouseholdType', 6, '台湾地区居民', 6, 1, 1);
INSERT INTO "DICTIONARY_ITEM"
VALUES ('1174509082208395299', '', 'HouseholdType', 7, '华侨', 7, 1, 1);
INSERT INTO "DICTIONARY_ITEM"
VALUES ('1174509082208395300', '', 'HouseholdType', 8, '外籍人士', 8, 1, 1);
INSERT INTO "DICTIONARY_ITEM"
VALUES ('1174509082208395301', '', 'HouseholdType', 9, '未取得永久居留权的外国人', 9, 1, 1);
INSERT INTO "DICTIONARY_ITEM"
VALUES ('1174509082208395302', '', 'HouseholdType', 10, '取得永久居留权的外国人', 10, 1, 1);
INSERT INTO "DICTIONARY_ITEM"
VALUES ('1174509082208395303', '', 'HouseholdType', 11, '居民户口', 11, 1, 1);

-- ----------------------------
-- 7. 求职人员类别 (JobSeekerCategory)
-- ----------------------------
INSERT INTO "DICTIONARY"
VALUES ('JobSeekerCategory', '求职人员类别', 7, 1);
INSERT INTO "DICTIONARY_ITEM"
VALUES ('1174509082208395304', '', 'JobSeekerCategory', 1, '新成长失业青年', 1, 1, 1);
INSERT INTO "DICTIONARY_ITEM"
VALUES ('1174509082208395305', '', 'JobSeekerCategory', 2, '应届高校毕业生', 2, 1, 1);
INSERT INTO "DICTIONARY_ITEM"
VALUES ('1174509082208395306', '', 'JobSeekerCategory', 3, '就业转失业人员', 3, 1, 1);
INSERT INTO "DICTIONARY_ITEM"
VALUES ('1174509082208395307', '', 'JobSeekerCategory', 4, '其他失业人员', 4, 1, 1);
INSERT INTO "DICTIONARY_ITEM"
VALUES ('1174509082208395308', '', 'JobSeekerCategory', 5, '本市农村人员', 5, 1, 1);
INSERT INTO "DICTIONARY_ITEM"
VALUES ('1174509082208395309', '', 'JobSeekerCategory', 6, '外埠人员', 6, 1, 1);
INSERT INTO "DICTIONARY_ITEM"
VALUES ('1174509082208395310', '', 'JobSeekerCategory', 7, '在业人员', 7, 1, 1);
INSERT INTO "DICTIONARY_ITEM"
VALUES ('1174509082208395311', '', 'JobSeekerCategory', 8, '下岗职工', 8, 1, 1);
INSERT INTO "DICTIONARY_ITEM"
VALUES ('1174509082208395312', '', 'JobSeekerCategory', 9, '退休人员', 9, 1, 1);
INSERT INTO "DICTIONARY_ITEM"
VALUES ('1174509082208395313', '', 'JobSeekerCategory', 10, '在学人员', 10, 1, 1);

-- ----------------------------
-- 8. 求职状态 (JobSeekerStatus)
-- ----------------------------
INSERT INTO "DICTIONARY"
VALUES ('JobSeekerStatus', '求职状态', 8, 1);
INSERT INTO "DICTIONARY_ITEM"
VALUES ('1174509082208395314', '', 'JobSeekerStatus', 1, '离职-随时到岗', 1, 1, 1);
INSERT INTO "DICTIONARY_ITEM"
VALUES ('1174509082208395315', '', 'JobSeekerStatus', 2, '在职-月内到岗', 2, 1, 1);
INSERT INTO "DICTIONARY_ITEM"
VALUES ('1174509082208395316', '', 'JobSeekerStatus', 3, '在职-考虑机会', 3, 1, 1);
INSERT INTO "DICTIONARY_ITEM"
VALUES ('1174509082208395317', '', 'JobSeekerStatus', 4, '在职-暂不考虑', 4, 1, 1);
INSERT INTO "DICTIONARY_ITEM"
VALUES ('1174509082208395318', '', 'JobSeekerStatus', 5, '应届毕业生', 5, 1, 1);
INSERT INTO "DICTIONARY_ITEM"
VALUES ('1174509082208395319', '', 'JobSeekerStatus', 6, '在校生', 6, 1, 1);

-- ----------------------------
-- 9. 数据来源 (DataSource)
-- ----------------------------
INSERT INTO "DICTIONARY"
VALUES ('DataSource', '数据来源', 9, 1);
INSERT INTO "DICTIONARY_ITEM"
VALUES ('1174509082208395320', '', 'DataSource', 1, '省系统', 1, 1, 1);
INSERT INTO "DICTIONARY_ITEM"
VALUES ('1174509082208395321', '', 'DataSource', 2, '市系统', 2, 1, 1);
INSERT INTO "DICTIONARY_ITEM"
VALUES ('1174509082208395322', '', 'DataSource', 3, '其他', 3, 1, 1);