| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439 |
- -- ----------------------------
- -- 达梦数据库 - 系统字典数据插入语句
- -- 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);
- -- ----------------------------
- -- 10. 工作性质 (WorkNature)
- -- ----------------------------
- INSERT INTO "DICTIONARY"
- VALUES ('WorkNature', '工作性质', 10, 1);
- INSERT INTO "DICTIONARY_ITEM"
- VALUES ('1174509082208395323', '', 'WorkNature', 1, '全职', 1, 1, 1);
- INSERT INTO "DICTIONARY_ITEM"
- VALUES ('1174509082208395324', '', 'WorkNature', 2, '实习', 2, 1, 1);
- -- ----------------------------
- -- 11. 单位类型 (CompanyType)
- -- ----------------------------
- INSERT INTO "DICTIONARY"
- VALUES ('CompanyType', '单位类型', 11, 1);
- INSERT INTO "DICTIONARY_ITEM"
- VALUES ('1174509082208395325', '', 'CompanyType', 1, '企业', 1, 1, 1);
- INSERT INTO "DICTIONARY_ITEM"
- VALUES ('1174509082208395326', '', 'CompanyType', 2, '机关', 2, 1, 1);
- INSERT INTO "DICTIONARY_ITEM"
- VALUES ('1174509082208395327', '', 'CompanyType', 3, '事业单位', 3, 1, 1);
- INSERT INTO "DICTIONARY_ITEM"
- VALUES ('1174509082208395328', '', 'CompanyType', 4, '全额拨款事业单位', 4, 1, 1);
- INSERT INTO "DICTIONARY_ITEM"
- VALUES ('1174509082208395329', '', 'CompanyType', 5, '差额拨款事业单位', 5, 1, 1);
- INSERT INTO "DICTIONARY_ITEM"
- VALUES ('1174509082208395330', '', 'CompanyType', 6, '自收自支事业单位', 6, 1, 1);
- INSERT INTO "DICTIONARY_ITEM"
- VALUES ('1174509082208395331', '', 'CompanyType', 7, '社会团体', 7, 1, 1);
- INSERT INTO "DICTIONARY_ITEM"
- VALUES ('1174509082208395332', '', 'CompanyType', 8, '个体工商户(有雇工的)', 8, 1, 1);
- INSERT INTO "DICTIONARY_ITEM"
- VALUES ('1174509082208395333', '', 'CompanyType', 9, '律师事务所', 9, 1, 1);
- INSERT INTO "DICTIONARY_ITEM"
- VALUES ('1174509082208395334', '', 'CompanyType', 10, '会计师事务所', 10, 1, 1);
- INSERT INTO "DICTIONARY_ITEM"
- VALUES ('1174509082208395335', '', 'CompanyType', 11, '驻华代表机构', 11, 1, 1);
- INSERT INTO "DICTIONARY_ITEM"
- VALUES ('1174509082208395336', '', 'CompanyType', 12, '外国常驻新闻机构', 12, 1, 1);
- INSERT INTO "DICTIONARY_ITEM"
- VALUES ('1174509082208395337', '', 'CompanyType', 13, '外国企业常驻代表机构', 13, 1, 1);
- INSERT INTO "DICTIONARY_ITEM"
- VALUES ('1174509082208395338', '', 'CompanyType', 14, '个体工商户(无雇工的)', 14, 1, 1);
- INSERT INTO "DICTIONARY_ITEM"
- VALUES ('1174509082208395339', '', 'CompanyType', 15, '其他组织机构', 15, 1, 1);
- INSERT INTO "DICTIONARY_ITEM"
- VALUES ('1174509082208395340', '', 'CompanyType', 16, '民办非企业单位', 16, 1, 1);
- INSERT INTO "DICTIONARY_ITEM"
- VALUES ('1174509082208395341', '', 'CompanyType', 17, '基金会', 17, 1, 1);
- INSERT INTO "DICTIONARY_ITEM"
- VALUES ('1174509082208395342', '', 'CompanyType', 18, '宗教活动场所', 18, 1, 1);
- INSERT INTO "DICTIONARY_ITEM"
- VALUES ('1174509082208395343', '', 'CompanyType', 19, '农村村民委员会', 19, 1, 1);
- INSERT INTO "DICTIONARY_ITEM"
- VALUES ('1174509082208395344', '', 'CompanyType', 20, '城市居民委员会', 20, 1, 1);
- INSERT INTO "DICTIONARY_ITEM"
- VALUES ('1174509082208395345', '', 'CompanyType', 21, '其他', 21, 1, 1);
- -- ----------------------------
- -- 12. 人员规模 (CompanySize)
- -- ----------------------------
- INSERT INTO "DICTIONARY"
- VALUES ('CompanySize', '人员规模', 12, 1);
- INSERT INTO "DICTIONARY_ITEM"
- VALUES ('1174509082208395346', '', 'CompanySize', 1, '49人及以下', 1, 1, 1);
- INSERT INTO "DICTIONARY_ITEM"
- VALUES ('1174509082208395347', '', 'CompanySize', 2, '50-99人', 2, 1, 1);
- INSERT INTO "DICTIONARY_ITEM"
- VALUES ('1174509082208395348', '', 'CompanySize', 3, '100-299人', 3, 1, 1);
- INSERT INTO "DICTIONARY_ITEM"
- VALUES ('1174509082208395349', '', 'CompanySize', 4, '300-499人', 4, 1, 1);
- INSERT INTO "DICTIONARY_ITEM"
- VALUES ('1174509082208395350', '', 'CompanySize', 5, '500-999人', 5, 1, 1);
- INSERT INTO "DICTIONARY_ITEM"
- VALUES ('1174509082208395351', '', 'CompanySize', 6, '1000-9999人', 6, 1, 1);
- INSERT INTO "DICTIONARY_ITEM"
- VALUES ('1174509082208395352', '', 'CompanySize', 7, '10000人及以上', 7, 1, 1);
- -- ----------------------------
- -- 13. 学历 (Education)
- -- ----------------------------
- INSERT INTO "DICTIONARY"
- VALUES ('Education', '学历', 13, 1);
- INSERT INTO "DICTIONARY_ITEM"
- VALUES ('1174509082208395353', '', 'Education', 1, '博士研究生', 1, 1, 1);
- INSERT INTO "DICTIONARY_ITEM"
- VALUES ('1174509082208395354', '', 'Education', 2, '硕士研究生', 2, 1, 1);
- INSERT INTO "DICTIONARY_ITEM"
- VALUES ('1174509082208395355', '', 'Education', 3, '大学本科', 3, 1, 1);
- INSERT INTO "DICTIONARY_ITEM"
- VALUES ('1174509082208395356', '', 'Education', 4, '大学专科', 4, 1, 1);
- INSERT INTO "DICTIONARY_ITEM"
- VALUES ('1174509082208395357', '', 'Education', 5, '中等专科', 5, 1, 1);
- INSERT INTO "DICTIONARY_ITEM"
- VALUES ('1174509082208395358', '', 'Education', 6, '职业高中', 6, 1, 1);
- INSERT INTO "DICTIONARY_ITEM"
- VALUES ('1174509082208395359', '', 'Education', 7, '技工学校', 7, 1, 1);
- INSERT INTO "DICTIONARY_ITEM"
- VALUES ('1174509082208395360', '', 'Education', 8, '普通高中', 8, 1, 1);
- INSERT INTO "DICTIONARY_ITEM"
- VALUES ('1174509082208395361', '', 'Education', 9, '初中', 9, 1, 1);
- INSERT INTO "DICTIONARY_ITEM"
- VALUES ('1174509082208395362', '', 'Education', 10, '小学', 10, 1, 1);
- INSERT INTO "DICTIONARY_ITEM"
- VALUES ('1174509082208395363', '', 'Education', 11, '其他', 11, 1, 1);
- -- ----------------------------
- -- 14. 学位 (Degree)
- -- ----------------------------
- INSERT INTO "DICTIONARY"
- VALUES ('Degree', '学位', 14, 1);
- INSERT INTO "DICTIONARY_ITEM"
- VALUES ('1174509082208395364', '', 'Degree', 1, '博士及以上学位', 1, 1, 1);
- INSERT INTO "DICTIONARY_ITEM"
- VALUES ('1174509082208395365', '', 'Degree', 2, '硕士学位', 2, 1, 1);
- INSERT INTO "DICTIONARY_ITEM"
- VALUES ('1174509082208395366', '', 'Degree', 3, '双学士学位', 3, 1, 1);
- INSERT INTO "DICTIONARY_ITEM"
- VALUES ('1174509082208395367', '', 'Degree', 4, '学士学位', 4, 1, 1);
- INSERT INTO "DICTIONARY_ITEM"
- VALUES ('1174509082208395368', '', 'Degree', 5, '其它或无', 5, 1, 1);
- -- ----------------------------
- -- 15. 学制 (EduSystem)
- -- ----------------------------
- INSERT INTO "DICTIONARY"
- VALUES ('EduSystem', '学制', 15, 1);
- INSERT INTO "DICTIONARY_ITEM"
- VALUES ('1174509082208395369', '', 'EduSystem', 1, '二年制', 1, 1, 1);
- INSERT INTO "DICTIONARY_ITEM"
- VALUES ('1174509082208395370', '', 'EduSystem', 2, '三年制', 2, 1, 1);
- INSERT INTO "DICTIONARY_ITEM"
- VALUES ('1174509082208395371', '', 'EduSystem', 3, '四年制', 3, 1, 1);
- INSERT INTO "DICTIONARY_ITEM"
- VALUES ('1174509082208395372', '', 'EduSystem', 4, '五年制', 4, 1, 1);
- -- ----------------------------
- -- 16. 技能等级 (SkillLevel)
- -- ----------------------------
- INSERT INTO "DICTIONARY"
- VALUES ('SkillLevel', '技能等级', 16, 1);
- INSERT INTO "DICTIONARY_ITEM"
- VALUES ('1174509082208395373', '', 'SkillLevel', 1, '职业资格一级(高级技师)', 1, 1, 1);
- INSERT INTO "DICTIONARY_ITEM"
- VALUES ('1174509082208395374', '', 'SkillLevel', 2, '职业资格二级(技师)', 2, 1, 1);
- INSERT INTO "DICTIONARY_ITEM"
- VALUES ('1174509082208395375', '', 'SkillLevel', 3, '职业资格三级(高级)', 3, 1, 1);
- INSERT INTO "DICTIONARY_ITEM"
- VALUES ('1174509082208395376', '', 'SkillLevel', 4, '职业资格四级(中级)', 4, 1, 1);
- INSERT INTO "DICTIONARY_ITEM"
- VALUES ('1174509082208395377', '', 'SkillLevel', 5, '职业资格五级(初级)', 5, 1, 1);
- INSERT INTO "DICTIONARY_ITEM"
- VALUES ('1174509082208395414', '', 'SkillLevel', 6, '初级职称', 6, 1, 1);
- INSERT INTO "DICTIONARY_ITEM"
- VALUES ('1174509082208395415', '', 'SkillLevel', 7, '中级职称', 7, 1, 1);
- INSERT INTO "DICTIONARY_ITEM"
- VALUES ('1174509082208395416', '', 'SkillLevel', 8, '高级职称', 8, 1, 1);
- INSERT INTO "DICTIONARY_ITEM"
- VALUES ('1174509082208395417', '', 'SkillLevel', 9, '无职业技能等级要求', 9, 1, 1);
- -- ----------------------------
- -- 17. 职称级别 (TitleLevel)
- -- ----------------------------
- INSERT INTO "DICTIONARY"
- VALUES ('TitleLevel', '职称级别', 17, 1);
- INSERT INTO "DICTIONARY_ITEM"
- VALUES ('1174509082208395378', '', 'TitleLevel', 1, '正高级', 1, 1, 1);
- INSERT INTO "DICTIONARY_ITEM"
- VALUES ('1174509082208395379', '', 'TitleLevel', 2, '副高级', 2, 1, 1);
- INSERT INTO "DICTIONARY_ITEM"
- VALUES ('1174509082208395380', '', 'TitleLevel', 3, '中级', 3, 1, 1);
- INSERT INTO "DICTIONARY_ITEM"
- VALUES ('1174509082208395381', '', 'TitleLevel', 4, '助理级', 4, 1, 1);
- INSERT INTO "DICTIONARY_ITEM"
- VALUES ('1174509082208395382', '', 'TitleLevel', 5, '员级', 5, 1, 1);
- -- ----------------------------
- -- 18. 经营状态 (BusinessStatus)
- -- ----------------------------
- INSERT INTO "DICTIONARY"
- VALUES ('BusinessStatus', '经营状态', 18, 1);
- INSERT INTO "DICTIONARY_ITEM"
- VALUES ('1174509082208395383', '', 'BusinessStatus', 1, '登记在册', 1, 1, 1);
- INSERT INTO "DICTIONARY_ITEM"
- VALUES ('1174509082208395384', '', 'BusinessStatus', 2, '破产', 2, 1, 1);
- INSERT INTO "DICTIONARY_ITEM"
- VALUES ('1174509082208395385', '', 'BusinessStatus', 3, '注销', 3, 1, 1);
- INSERT INTO "DICTIONARY_ITEM"
- VALUES ('1174509082208395386', '', 'BusinessStatus', 4, '被兼并', 4, 1, 1);
- INSERT INTO "DICTIONARY_ITEM"
- VALUES ('1174509082208395387', '', 'BusinessStatus', 5, '其他', 5, 1, 1);
- -- ----------------------------
- -- 19. 行业领域 (IndustryField)
- -- ----------------------------
- INSERT INTO "DICTIONARY"
- VALUES ('IndustryField', '行业领域', 19, 1);
- INSERT INTO "DICTIONARY_ITEM"
- VALUES ('1174509082208395388', '', 'IndustryField', 1, '人工智能与机器人', 1, 1, 1);
- INSERT INTO "DICTIONARY_ITEM"
- VALUES ('1174509082208395389', '', 'IndustryField', 2, '半导体与集成电路', 2, 1, 1);
- INSERT INTO "DICTIONARY_ITEM"
- VALUES ('1174509082208395390', '', 'IndustryField', 3, '新材料', 3, 1, 1);
- INSERT INTO "DICTIONARY_ITEM"
- VALUES ('1174509082208395391', '', 'IndustryField', 4, '新能源', 4, 1, 1);
- INSERT INTO "DICTIONARY_ITEM"
- VALUES ('1174509082208395392', '', 'IndustryField', 5, '低空经济', 5, 1, 1);
- INSERT INTO "DICTIONARY_ITEM"
- VALUES ('1174509082208395393', '', 'IndustryField', 6, '生物制造', 6, 1, 1);
- INSERT INTO "DICTIONARY_ITEM"
- VALUES ('1174509082208395394', '', 'IndustryField', 7, '商业航空航天', 7, 1, 1);
- INSERT INTO "DICTIONARY_ITEM"
- VALUES ('1174509082208395395', '', 'IndustryField', 8, '实验室', 8, 1, 1);
- INSERT INTO "DICTIONARY_ITEM"
- VALUES ('1174509082208395396', '', 'IndustryField', 9, '科研机构', 9, 1, 1);
- INSERT INTO "DICTIONARY_ITEM"
- VALUES ('1174509082208395397', '', 'IndustryField', 10, '金融机构', 10, 1, 1);
- INSERT INTO "DICTIONARY_ITEM"
- VALUES ('1174509082208395398', '', 'IndustryField', 11, '其他', 11, 1, 1);
- -- ----------------------------
- -- 20. 薪酬待遇 (SalaryType)
- -- ----------------------------
- INSERT INTO "DICTIONARY"
- VALUES ('SalaryType', '薪酬待遇', 20, 1);
- INSERT INTO "DICTIONARY_ITEM"
- VALUES ('1174509082208395399', '', 'SalaryType', 1, '月薪(元/月)', 1, 1, 1);
- INSERT INTO "DICTIONARY_ITEM"
- VALUES ('1174509082208395400', '', 'SalaryType', 2, '年薪(万元/年)', 2, 1, 1);
- INSERT INTO "DICTIONARY_ITEM"
- VALUES ('1174509082208395401', '', 'SalaryType', 3, '面议', 3, 1, 1);
- -- ----------------------------
- -- 21. 职位标签 (PostTag)
- -- ----------------------------
- INSERT INTO "DICTIONARY"
- VALUES ('PostTag', '职位标签', 21, 1);
- INSERT INTO "DICTIONARY_ITEM"
- VALUES ('1174509082208395402', '', 'PostTag', 1, '普通岗位', 1, 1, 1);
- INSERT INTO "DICTIONARY_ITEM"
- VALUES ('1174509082208395403', '', 'PostTag', 2, '妈妈岗', 2, 1, 1);
- INSERT INTO "DICTIONARY_ITEM"
- VALUES ('1174509082208395404', '', 'PostTag', 3, '应届毕业生', 3, 1, 1);
- INSERT INTO "DICTIONARY_ITEM"
- VALUES ('1174509082208395405', '', 'PostTag', 4, '港澳籍', 4, 1, 1);
- INSERT INTO "DICTIONARY_ITEM"
- VALUES ('1174509082208395406', '', 'PostTag', 5, '劳务协作', 5, 1, 1);
- INSERT INTO "DICTIONARY_ITEM"
- VALUES ('1174509082208395407', '', 'PostTag', 6, '残疾人', 6, 1, 1);
- INSERT INTO "DICTIONARY_ITEM"
- VALUES ('1174509082208395408', '', 'PostTag', 7, '动火作业岗位', 7, 1, 1);
- -- ----------------------------
- -- 22. 外语水平要求 (LanguageLevel)
- -- ----------------------------
- INSERT INTO "DICTIONARY"
- VALUES ('LanguageLevel', '外语水平要求', 22, 1);
- INSERT INTO "DICTIONARY_ITEM"
- VALUES ('1174509082208395409', '', 'LanguageLevel', 1, '精通', 1, 1, 1);
- INSERT INTO "DICTIONARY_ITEM"
- VALUES ('1174509082208395410', '', 'LanguageLevel', 2, '熟练', 2, 1, 1);
- INSERT INTO "DICTIONARY_ITEM"
- VALUES ('1174509082208395411', '', 'LanguageLevel', 3, '良好', 3, 1, 1);
- INSERT INTO "DICTIONARY_ITEM"
- VALUES ('1174509082208395412', '', 'LanguageLevel', 4, '一般', 4, 1, 1);
|