-------------2024-01-24 --表字段添加 alter table pc_site add Remark varchar(200); alter table pc_jobhunt add OtherDemand varchar(200); --功能表数据添加 INSERT INTO sys_function_code VALUES ('T0199010105', '新增用户', 'T01990101', 5); ------------------------------------------------------- -- 2024-4-28 ALTER TABLE pc_company modify IndustryID VARCHAR(50); --2024.4.30 选择标签 create table pc_label( LabelID varchar(50) primary key not null COMMENT '标签id', LabelName varchar(50) COMMENT '标签名', LabelType int COMMENT '标签类型 1-基础标签 2-自定义标签', BigType int COMMENT '大类型 1-企业 2-人员', SortNo int COMMENT '排序号', CreateUserID varchar(50) COMMENT '创建人', CreateTime datetime COMMENT '创建时间', ModifyUserID varchar(50) COMMENT '修改人', ModifyTime datetime COMMENT '修改时间' ) COMMENT '企业、人员标签表'; create table pc_label_jobuser( LabelID varchar(50) not null COMMENT '标签id', JobuserID varchar(50) not null COMMENT '人员id' ) COMMENT '人员标签表'; alter table pc_label_jobuser add index pc_label_jobuser_LabelID(LabelID); alter table pc_label_jobuser add index pc_label_jobuser_JobuserID(JobuserID); create table pc_label_company( LabelID varchar(50) not null COMMENT '标签id', CompanyID varchar(50) not null COMMENT '企业id' ) COMMENT '企业标签表'; alter table pc_label_company add index pc_label_company_LabelID(LabelID); alter table pc_label_company add index pc_label_company_CompanyID(CompanyID); INSERT INTO `sys_dictionary` (`DictionaryCode`, `Name`, `OrderNo`, `RecordStatus`) VALUES ('LabelType', '标签类型', 100, 1), ('BigType', '企业人员类型', 101, 1); INSERT INTO `sys_dictionary_item` (`DictionaryItemID`, `Code`, `DictionaryCode`, `Value`, `Name`, `OrderNo`, `RecordStatus`, `IsEditable`) VALUES ('f06c44b6-a77a-11ed-a6c5-7085c2a00000', '', 'LabelType', 1, '基础标签', 0, 1, 0), ('f06c44b6-a77a-11ed-a6c5-7085c2a00001', '', 'LabelType', 2, '自定义标签', 1, 1, 0), ('f06c44b6-a77a-11ed-a6c5-7085c2a00002', '', 'BigType', 1, '企业', 0, 1, 0), ('f06c44b6-a77a-11ed-a6c5-7085c2a00003', '', 'BigType', 2, '人员', 1, 1, 0); -- 2024-4-30 ALTER TABLE pc_company MODIFY RegisteredCapital DECIMAL(10, 2); -- 2024.5.6 alter table pc_dotask add taskLevel int comment '任务级别'; alter table pc_dotask_user add completeDesc text comment '完成情况描述'; insert into sys_dictionary values ('TaskLevel','任务级别','10','1'); INSERT INTO sys_dictionary_item (DictionaryItemID, Code, DictionaryCode, Value, Name, OrderNo, RecordStatus, IsEditable) VALUES ('0ca43465-0b4b-11ef-ad8e-7085c2a9999e', '', 'TaskLevel', 1, '特别重要任务', 10, 1, 0), ('1507732b-0b4b-11ef-ad8e-7085c2a9999e', '', 'TaskLevel', 2, '重要任务', 20, 1, 0), ('196e4f6d-0b4b-11ef-ad8e-7085c2a9999e', '', 'TaskLevel', 3, '一般任务', 30, 1, 0); -- 2024-5-6 ALTER TABLE `pc_jobuser` ADD COLUMN `Longitude` varchar(50) NULL COMMENT '经度' AFTER `OccupationalLevel`, ADD COLUMN `Latitude` varchar(50) NULL COMMENT '纬度' AFTER `Longitude`; -- 2024.5.6 create table pc_label_post( LabelID varchar(50) not null COMMENT '标签id', PostID varchar(50) not null COMMENT '岗位id' ) COMMENT '岗位标签表'; alter table pc_label_post add index pc_label_post_LabelID(LabelID); alter table pc_label_post add index pc_label_post_PostID(PostID); INSERT INTO `sys_dictionary_item` (`DictionaryItemID`, `Code`, `DictionaryCode`, `Value`, `Name`, `OrderNo`, `RecordStatus`, `IsEditable`) VALUES ('f06c44b6-a77a-11ed-a6c5-7085c2a00004', '', 'BigType', 3, '岗位', 1, 1, 0); -- 2024.5.7 alter table pc_jobhunt modify workYear decimal(18,2) -- 2024-5-7 update `pc_industry` set industryName = '住宿和餐饮业' where industryId = '684adfe0-426e-4cf1-9a09-7923f6fbef29'; --2024-5-8 企业表索引 ALTER TABLE pc_firm ADD INDEX `nameIndex` ( `FirmName` ); --2024-05-08 日志、任务路由调整 update sys_menu set IsVisible= 0 where MenuNo='T0104'; update sys_menu set ParentMenuNo = 'T01' where ParentMenuNo='T0104'; update sys_menu set OrderNo = '5',Icon='FlagOutlined',Url='/workTask',isLeaf=1 where MenuNo='T010401'; update sys_menu set ViewPath = 'views/workTask/index' where MenuNo='T01040101'; update sys_menu set ViewPath = 'views/workTask/add' where MenuNo='T01040102'; update sys_menu set ViewPath = 'views/workTask/edit' where MenuNo='T01040103'; update sys_menu set ViewPath = 'views/workTask/detail' where MenuNo='T01040105'; update sys_menu set OrderNo = '6',Icon='ScheduleOutlined',Url='/workLog',isLeaf=1 where MenuNo='T010402' ; update sys_menu set ViewPath = 'views/workLog/index' where MenuNo='T01040201'; update sys_menu set ViewPath = 'views/workLog/add' where MenuNo='T01040202'; update sys_menu set ViewPath = 'views/workLog/edit' where MenuNo='T01040203'; update sys_menu set ViewPath = 'views/workLog/detail' where MenuNo='T01040205'; update sys_menu set OrderNo = '7' where MenuNo='T0105'; update sys_menu set OrderNo = '8' where MenuNo='T0106'; --2024-5-8 工作日志表添加驿站ID ALTER TABLE pc_dowork ADD COLUMN `SiteID` VARCHAR ( 50 ) NULL AFTER `WorkTime`; -- 2024-5-9 日志、任务权限编码调整 UPDATE `sys_function_code` SET ParentFunctionCode = 'T01', OrderNo = 4 WHERE FunctionCode = 'T010401'; UPDATE `sys_function_code` SET ParentFunctionCode = 'T01', OrderNo = 4 WHERE FunctionCode = 'T010402'; --2024-5-9 新增工种表及数据插入 create table pc_workcategory ( WorkCategoryID varchar(50) not null, ParentWorkCategoryID varchar(50), WorkCategoryName varchar(50), OrderNo int, Status int, primary key (WorkCategoryID) ); INSERT INTO pc_workcategory VALUES ('20200100000', '', '政府/科研/教育/培训', 1, 1); INSERT INTO pc_workcategory VALUES ('20200200000', '', '人事/行政/管理', 2, 1); INSERT INTO pc_workcategory VALUES ('20200300000', '', 'IT/计算机/互联网通讯/电子', 3, 1); INSERT INTO pc_workcategory VALUES ('20200400000', '', '销售/客服/中介/咨询/法务', 4, 1); INSERT INTO pc_workcategory VALUES ('20200500000', '', '广告设计/影视/餐饮旅游/翻译', 5, 1); INSERT INTO pc_workcategory VALUES ('20200600000', '', '财税/证券期货/银行/保险', 6, 1); INSERT INTO pc_workcategory VALUES ('20200700000', '', '生产/采购/贸易/交通', 7, 1); INSERT INTO pc_workcategory VALUES ('20200800000', '', '生物/制药/医疗/护理', 8, 1); INSERT INTO pc_workcategory VALUES ('20200900000', '', '建筑/房地产/机械/汽车', 9, 1); INSERT INTO pc_workcategory VALUES ('20201000000', '', '出版印刷/轻工纺织/化工', 10, 1); INSERT INTO pc_workcategory VALUES ('20201100000', '', '勘探气象/能源/采掘/冶炼/水利', 11, 1); INSERT INTO pc_workcategory VALUES ('20201200000', '', '生活服务/技工普工/市政农林/其他', 12, 1); INSERT INTO pc_workcategory VALUES ('20200101000', '20200100000', '科学研究', 13, 1); INSERT INTO pc_workcategory VALUES ('20200102000', '20200100000', '政府雇员', 14, 1); INSERT INTO pc_workcategory VALUES ('20200103000', '20200100000', '教育', 15, 1); INSERT INTO pc_workcategory VALUES ('20200104000', '20200100000', '培训', 16, 1); INSERT INTO pc_workcategory VALUES ('20200201000', '20200200000', '中高层管理', 17, 1); INSERT INTO pc_workcategory VALUES ('20200202000', '20200200000', '行政后勤', 18, 1); INSERT INTO pc_workcategory VALUES ('20200203000', '20200200000', '人力资源', 19, 1); INSERT INTO pc_workcategory VALUES ('20200301000', '20200300000', 'IT运维', 20, 1); INSERT INTO pc_workcategory VALUES ('20200302000', '20200300000', '计算机硬件', 21, 1); INSERT INTO pc_workcategory VALUES ('20200303000', '20200300000', '计算机软件', 22, 1); INSERT INTO pc_workcategory VALUES ('20200304000', '20200300000', '游戏', 23, 1); INSERT INTO pc_workcategory VALUES ('20200305000', '20200300000', '系统集成', 24, 1); INSERT INTO pc_workcategory VALUES ('20200306000', '20200300000', '通信技术及开发', 25, 1); INSERT INTO pc_workcategory VALUES ('20200307000', '20200300000', '电子电器', 26, 1); INSERT INTO pc_workcategory VALUES ('20200308000', '20200300000', '互联网', 27, 1); INSERT INTO pc_workcategory VALUES ('20200401000', '20200400000', '销售', 28, 1); INSERT INTO pc_workcategory VALUES ('20200402000', '20200400000', '客户服务', 29, 1); INSERT INTO pc_workcategory VALUES ('20200403000', '20200400000', '技术支持', 30, 1); INSERT INTO pc_workcategory VALUES ('20200404000', '20200400000', '零售百货', 31, 1); INSERT INTO pc_workcategory VALUES ('20200405000', '20200400000', '中介咨询', 32, 1); INSERT INTO pc_workcategory VALUES ('20200501000', '20200500000', '市场营销', 33, 1); INSERT INTO pc_workcategory VALUES ('20200502000', '20200500000', '广告会展', 34, 1); INSERT INTO pc_workcategory VALUES ('20200503000', '20200500000', '设计创意', 35, 1); INSERT INTO pc_workcategory VALUES ('20200504000', '20200500000', '广播电视电影', 36, 1); INSERT INTO pc_workcategory VALUES ('20200505000', '20200500000', '餐饮娱乐', 37, 1); INSERT INTO pc_workcategory VALUES ('20200506000', '20200500000', '酒店', 38, 1); INSERT INTO pc_workcategory VALUES ('20200507000', '20200500000', '旅游', 39, 1); INSERT INTO pc_workcategory VALUES ('20200508000', '20200500000', '翻译', 40, 1); INSERT INTO pc_workcategory VALUES ('20200601000', '20200600000', '财务', 41, 1); INSERT INTO pc_workcategory VALUES ('20200602000', '20200600000', '审计', 42, 1); INSERT INTO pc_workcategory VALUES ('20200603000', '20200600000', '税务', 43, 1); INSERT INTO pc_workcategory VALUES ('20200604000', '20200600000', '银行', 44, 1); INSERT INTO pc_workcategory VALUES ('20200605000', '20200600000', '保险', 45, 1); INSERT INTO pc_workcategory VALUES ('20200606000', '20200600000', '证券期货投资', 46, 1); INSERT INTO pc_workcategory VALUES ('20200701000', '20200700000', '生产与管理', 47, 1); INSERT INTO pc_workcategory VALUES ('20200702000', '20200700000', '安全工程', 48, 1); INSERT INTO pc_workcategory VALUES ('20200703000', '20200700000', '计量质量', 49, 1); INSERT INTO pc_workcategory VALUES ('20200704000', '20200700000', '采购', 50, 1); INSERT INTO pc_workcategory VALUES ('20200705000', '20200700000', '物流', 51, 1); INSERT INTO pc_workcategory VALUES ('20200706000', '20200700000', '仓储', 52, 1); INSERT INTO pc_workcategory VALUES ('20200707000', '20200700000', '贸易', 53, 1); INSERT INTO pc_workcategory VALUES ('20200708000', '20200700000', '交通运输', 54, 1); INSERT INTO pc_workcategory VALUES ('20200801000', '20200800000', '生物医药及器械', 55, 1); INSERT INTO pc_workcategory VALUES ('20200802000', '20200800000', '西医', 56, 1); INSERT INTO pc_workcategory VALUES ('20200803000', '20200800000', '中医', 57, 1); INSERT INTO pc_workcategory VALUES ('20200804000', '20200800000', '公共卫生', 58, 1); INSERT INTO pc_workcategory VALUES ('20200805000', '20200800000', '药剂医技', 59, 1); INSERT INTO pc_workcategory VALUES ('20200806000', '20200800000', '护理', 60, 1); INSERT INTO pc_workcategory VALUES ('20200901000', '20200900000', '建筑', 61, 1); INSERT INTO pc_workcategory VALUES ('20200902000', '20200900000', '房地产与物业', 62, 1); INSERT INTO pc_workcategory VALUES ('20200903000', '20200900000', '机械工程', 63, 1); INSERT INTO pc_workcategory VALUES ('20200904000', '20200900000', '汽车', 64, 1); INSERT INTO pc_workcategory VALUES ('20201001000', '20201000000', '出版', 65, 1); INSERT INTO pc_workcategory VALUES ('20201002000', '20201000000', '印刷', 66, 1); INSERT INTO pc_workcategory VALUES ('20201003000', '20201000000', '烟酒茶糖', 67, 1); INSERT INTO pc_workcategory VALUES ('20201004000', '20201000000', '纺织服装', 68, 1); INSERT INTO pc_workcategory VALUES ('20201005000', '20201000000', '珠宝首饰', 69, 1); INSERT INTO pc_workcategory VALUES ('20201006000', '20201000000', '陶瓷', 70, 1); INSERT INTO pc_workcategory VALUES ('20201007000', '20201000000', '化工', 71, 1); INSERT INTO pc_workcategory VALUES ('20201008000', '20201000000', '工艺品制作', 72, 1); INSERT INTO pc_workcategory VALUES ('20201101000', '20201100000', '气象', 73, 1); INSERT INTO pc_workcategory VALUES ('20201102000', '20201100000', '环境保护', 74, 1); INSERT INTO pc_workcategory VALUES ('20201103000', '20201100000', '勘探测绘工程', 75, 1); INSERT INTO pc_workcategory VALUES ('20201104000', '20201100000', '矿山工程', 76, 1); INSERT INTO pc_workcategory VALUES ('20201105000', '20201100000', '石油', 77, 1); INSERT INTO pc_workcategory VALUES ('20201106000', '20201100000', '电力', 78, 1); INSERT INTO pc_workcategory VALUES ('20201107000', '20201100000', '冶金工程', 79, 1); INSERT INTO pc_workcategory VALUES ('20201108000', '20201100000', '水利工程', 80, 1); INSERT INTO pc_workcategory VALUES ('20201109000', '20201100000', '煤炭/煤化工', 81, 1); INSERT INTO pc_workcategory VALUES ('20201201000', '20201200000', '保健健身美容', 82, 1); INSERT INTO pc_workcategory VALUES ('20201202000', '20201200000', '家政', 83, 1); INSERT INTO pc_workcategory VALUES ('20201203000', '20201200000', '市政', 84, 1); INSERT INTO pc_workcategory VALUES ('20201204000', '20201200000', '农林牧副渔', 85, 1); INSERT INTO pc_workcategory VALUES ('20201205000', '20201200000', '常用技工', 86, 1); INSERT INTO pc_workcategory VALUES ('20201206000', '20201200000', '普工', 87, 1); INSERT INTO pc_workcategory VALUES ('20201207000', '20201200000', '其他', 88, 1); INSERT INTO pc_workcategory VALUES ('20200101001', '20200101000', '地球科学研究人员', 89, 1); INSERT INTO pc_workcategory VALUES ('20200101002', '20200101000', '法学研究人员', 90, 1); INSERT INTO pc_workcategory VALUES ('20200101003', '20200101000', '管理科学研究人员', 91, 1); INSERT INTO pc_workcategory VALUES ('20200101004', '20200101000', '化学研究人员', 92, 1); INSERT INTO pc_workcategory VALUES ('20200101005', '20200101000', '教育科学研究人员', 93, 1); INSERT INTO pc_workcategory VALUES ('20200101006', '20200101000', '经济学研究人员', 94, 1); INSERT INTO pc_workcategory VALUES ('20200101007', '20200101000', '历史学研究人员', 95, 1); INSERT INTO pc_workcategory VALUES ('20200101008', '20200101000', '农业科学研究人员', 96, 1); INSERT INTO pc_workcategory VALUES ('20200101009', '20200101000', '其他科学研究人员', 97, 1); INSERT INTO pc_workcategory VALUES ('20200101010', '20200101000', '社会学研究人员', 98, 1); INSERT INTO pc_workcategory VALUES ('20200101011', '20200101000', '生物科学研究人员', 99, 1); INSERT INTO pc_workcategory VALUES ('20200101012', '20200101000', '数学研究人员', 100, 1); INSERT INTO pc_workcategory VALUES ('20200101013', '20200101000', '天文学研究人员', 101, 1); INSERT INTO pc_workcategory VALUES ('20200101014', '20200101000', '图书馆学、情报研究人员', 102, 1); INSERT INTO pc_workcategory VALUES ('20200101015', '20200101000', '文学、艺术研究人员', 103, 1); INSERT INTO pc_workcategory VALUES ('20200101016', '20200101000', '物理学研究人员', 104, 1); INSERT INTO pc_workcategory VALUES ('20200101017', '20200101000', '医学研究人员', 105, 1); INSERT INTO pc_workcategory VALUES ('20200101018', '20200101000', '哲学研究人员', 106, 1); INSERT INTO pc_workcategory VALUES ('20200102001', '20200102000', '公务员', 107, 1); INSERT INTO pc_workcategory VALUES ('20200102002', '20200102000', '政府雇佣人员', 108, 1); INSERT INTO pc_workcategory VALUES ('20200103001', '20200103000', '大学教授', 109, 1); INSERT INTO pc_workcategory VALUES ('20200103002', '20200103000', '国学教师', 110, 1); INSERT INTO pc_workcategory VALUES ('20200103003', '20200103000', '计算机教师', 111, 1); INSERT INTO pc_workcategory VALUES ('20200103004', '20200103000', '家教教师', 112, 1); INSERT INTO pc_workcategory VALUES ('20200103005', '20200103000', '教学/教务管理人员', 113, 1); INSERT INTO pc_workcategory VALUES ('20200103006', '20200103000', '大学讲师/助教', 114, 1); INSERT INTO pc_workcategory VALUES ('20200103007', '20200103000', '实习指导/就业指导老师', 115, 1); INSERT INTO pc_workcategory VALUES ('20200103008', '20200103000', '书法教师', 116, 1); INSERT INTO pc_workcategory VALUES ('20200103009', '20200103000', '外语教师', 117, 1); INSERT INTO pc_workcategory VALUES ('20200103010', '20200103000', '学前教育教师', 118, 1); INSERT INTO pc_workcategory VALUES ('20200103011', '20200103000', '幼儿教育', 119, 1); INSERT INTO pc_workcategory VALUES ('20200103012', '20200103000', '院校校长/副校长', 120, 1); INSERT INTO pc_workcategory VALUES ('20200103013', '20200103000', '招生/就业服务人员', 121, 1); INSERT INTO pc_workcategory VALUES ('20200103014', '20200103000', '政治/体育/音乐/美术教师', 122, 1); INSERT INTO pc_workcategory VALUES ('20200103015', '20200103000', '职业教育/职业培训教师', 123, 1); INSERT INTO pc_workcategory VALUES ('20200103016', '20200103000', '中小学数学/物理/化学教师', 124, 1); INSERT INTO pc_workcategory VALUES ('20200103017', '20200103000', '中小学语文/历史/地理/生物教师', 125, 1); INSERT INTO pc_workcategory VALUES ('20200104001', '20200104000', '创业培训师', 126, 1); INSERT INTO pc_workcategory VALUES ('20200104002', '20200104000', '公务员考试培训师', 127, 1); INSERT INTO pc_workcategory VALUES ('20200104003', '20200104000', '会计培训师', 128, 1); INSERT INTO pc_workcategory VALUES ('20200104004', '20200104000', '培训策划', 129, 1); INSERT INTO pc_workcategory VALUES ('20200104005', '20200104000', '培训督导', 130, 1); INSERT INTO pc_workcategory VALUES ('20200104006', '20200104000', '培训讲师/顾可', 131, 1); INSERT INTO pc_workcategory VALUES ('20200104007', '20200104000', '培训经理/主管', 132, 1); INSERT INTO pc_workcategory VALUES ('20200104008', '20200104000', '培训助理', 133, 1); INSERT INTO pc_workcategory VALUES ('20200104009', '20200104000', '其他文教/体育/培训', 134, 1); INSERT INTO pc_workcategory VALUES ('20200104010', '20200104000', '其它讲师/培训师/专家', 135, 1); INSERT INTO pc_workcategory VALUES ('20200104011', '20200104000', '外语培训教师', 136, 1); INSERT INTO pc_workcategory VALUES ('20200104012', '20200104000', '中学生教育培训师', 137, 1); INSERT INTO pc_workcategory VALUES ('20200201001', '20200201000', '部门经理/副经理', 138, 1); INSERT INTO pc_workcategory VALUES ('20200201002', '20200201000', '董事会秘书/总裁助理/总经理助理', 139, 1); INSERT INTO pc_workcategory VALUES ('20200201003', '20200201000', '分公司/办事处/分支机构经理', 140, 1); INSERT INTO pc_workcategory VALUES ('20200201004', '20200201000', '副总经理/副总裁', 141, 1); INSERT INTO pc_workcategory VALUES ('20200201005', '20200201000', '管理顾问', 142, 1); INSERT INTO pc_workcategory VALUES ('20200201006', '20200201000', '经理助理/主管', 143, 1); INSERT INTO pc_workcategory VALUES ('20200201007', '20200201000', '首席财务官CFO/财务总监', 144, 1); INSERT INTO pc_workcategory VALUES ('20200201008', '20200201000', '首席技术官CTO/首席信息官CIO/技术总监', 145, 1); INSERT INTO pc_workcategory VALUES ('20200201009', '20200201000', '首席市场官CMO/市场总监', 146, 1); INSERT INTO pc_workcategory VALUES ('20200201010', '20200201000', '首席运营官COO/运营总监', 147, 1); INSERT INTO pc_workcategory VALUES ('20200201011', '20200201000', '首席执行官CEO/总裁/总经理', 148, 1); INSERT INTO pc_workcategory VALUES ('20200202001', '20200202000', '后勤/总务', 149, 1); INSERT INTO pc_workcategory VALUES ('20200202002', '20200202000', '经理助理/秘书/高级文员', 150, 1); INSERT INTO pc_workcategory VALUES ('20200202003', '20200202000', '前台/接待/总机/话务/礼仪', 151, 1); INSERT INTO pc_workcategory VALUES ('20200202004', '20200202000', '情报/合同管理员', 152, 1); INSERT INTO pc_workcategory VALUES ('20200202005', '20200202000', '图书管理员/资料管理员', 153, 1); INSERT INTO pc_workcategory VALUES ('20200202006', '20200202000', '文档管理专员', 154, 1); INSERT INTO pc_workcategory VALUES ('20200202007', '20200202000', '文员/文秘', 155, 1); INSERT INTO pc_workcategory VALUES ('20200202008', '20200202000', '行政经理/主管/办公室主任/副主任', 156, 1); INSERT INTO pc_workcategory VALUES ('20200202009', '20200202000', '行政司机', 157, 1); INSERT INTO pc_workcategory VALUES ('20200202010', '20200202000', '行政专员/助理', 158, 1); INSERT INTO pc_workcategory VALUES ('20200202011', '20200202000', '行政总监', 159, 1); INSERT INTO pc_workcategory VALUES ('20200203001', '20200203000', '绩效考核经理/主管', 160, 1); INSERT INTO pc_workcategory VALUES ('20200203002', '20200203000', '绩效考核专员/助理', 161, 1); INSERT INTO pc_workcategory VALUES ('20200203003', '20200203000', '培训经理/主管', 162, 1); INSERT INTO pc_workcategory VALUES ('20200203004', '20200203000', '培训师', 163, 1); INSERT INTO pc_workcategory VALUES ('20200203005', '20200203000', '培训专员/助理', 164, 1); INSERT INTO pc_workcategory VALUES ('20200203006', '20200203000', '企业文化经理/主管/专员', 165, 1); INSERT INTO pc_workcategory VALUES ('20200203007', '20200203000', '人力资源经理/人事经理', 166, 1); INSERT INTO pc_workcategory VALUES ('20200203008', '20200203000', '人力资源信息系统专员', 167, 1); INSERT INTO pc_workcategory VALUES ('20200203009', '20200203000', '人力资源主管/人事主管', 168, 1); INSERT INTO pc_workcategory VALUES ('20200203010', '20200203000', '人力资源专员/人事专员/助理', 169, 1); INSERT INTO pc_workcategory VALUES ('20200203011', '20200203000', '人力资源总监/人事总监', 170, 1); INSERT INTO pc_workcategory VALUES ('20200203012', '20200203000', '薪资福利经理/主管', 171, 1); INSERT INTO pc_workcategory VALUES ('20200203013', '20200203000', '薪资福利专员/助理', 172, 1); INSERT INTO pc_workcategory VALUES ('20200203014', '20200203000', '员工关系管理/工会管理', 173, 1); INSERT INTO pc_workcategory VALUES ('20200203015', '20200203000', '招聘经理/主管', 174, 1); INSERT INTO pc_workcategory VALUES ('20200203016', '20200203000', '招聘专员/助理', 175, 1); INSERT INTO pc_workcategory VALUES ('20200301001', '20200301000', '技术支持工程师', 176, 1); INSERT INTO pc_workcategory VALUES ('20200301002', '20200301000', '技术支持经理', 177, 1); INSERT INTO pc_workcategory VALUES ('20200301003', '20200301000', '品质经理', 178, 1); INSERT INTO pc_workcategory VALUES ('20200301004', '20200301000', '数据库管理员', 179, 1); INSERT INTO pc_workcategory VALUES ('20200301005', '20200301000', '网络工程师', 180, 1); INSERT INTO pc_workcategory VALUES ('20200301006', '20200301000', '系统管理员', 181, 1); INSERT INTO pc_workcategory VALUES ('20200301007', '20200301000', '信息安全工程师', 182, 1); INSERT INTO pc_workcategory VALUES ('20200302001', '20200302000', '硬件测试工程师', 183, 1); INSERT INTO pc_workcategory VALUES ('20200302002', '20200302000', '硬件工程师', 184, 1); INSERT INTO pc_workcategory VALUES ('20200302003', '20200302000', '硬件维护工程师', 185, 1); INSERT INTO pc_workcategory VALUES ('20200303001', '20200303000', 'ERP技术开发与实施', 186, 1); INSERT INTO pc_workcategory VALUES ('20200303002', '20200303000', '仿真应用工程师', 187, 1); INSERT INTO pc_workcategory VALUES ('20200303003', '20200303000', '高级软件工程师/高级程序员', 188, 1); INSERT INTO pc_workcategory VALUES ('20200303004', '20200303000', '计算机辅助设计工程师', 189, 1); INSERT INTO pc_workcategory VALUES ('20200303005', '20200303000', '交互设计师/可用性分析', 190, 1); INSERT INTO pc_workcategory VALUES ('20200303007', '20200303000', '软件UI设计师/工程师', 191, 1); INSERT INTO pc_workcategory VALUES ('20200303008', '20200303000', '软件测试工程师', 192, 1); INSERT INTO pc_workcategory VALUES ('20200303009', '20200303000', '软件工程师/程序员', 193, 1); INSERT INTO pc_workcategory VALUES ('20200303010', '20200303000', '软件架构设计师', 194, 1); INSERT INTO pc_workcategory VALUES ('20200303011', '20200303000', '软件需求工程师', 195, 1); INSERT INTO pc_workcategory VALUES ('20200303012', '20200303000', '数据库开发工程师', 196, 1); INSERT INTO pc_workcategory VALUES ('20200303013', '20200303000', '系统分析师/分析员', 197, 1); INSERT INTO pc_workcategory VALUES ('20200303014', '20200303000', '系统集成工程师', 198, 1); INSERT INTO pc_workcategory VALUES ('20200304001', '20200304000', '测试工程师', 199, 1); INSERT INTO pc_workcategory VALUES ('20200304002', '20200304000', '脚本开发工程师', 200, 1); INSERT INTO pc_workcategory VALUES ('20200304003', '20200304000', '视觉设计师', 201, 1); INSERT INTO pc_workcategory VALUES ('20200304004', '20200304000', '特效设计师', 202, 1); INSERT INTO pc_workcategory VALUES ('20200304005', '20200304000', '音效设计师', 203, 1); INSERT INTO pc_workcategory VALUES ('20200304006', '20200304000', '游戏策划师', 204, 1); INSERT INTO pc_workcategory VALUES ('20200304007', '20200304000', '游戏界面设计师', 205, 1); INSERT INTO pc_workcategory VALUES ('20200305001', '20200305000', 'MRP/ERP实施顾问', 206, 1); INSERT INTO pc_workcategory VALUES ('20200305002', '20200305000', '系统分析员', 207, 1); INSERT INTO pc_workcategory VALUES ('20200305003', '20200305000', '系统工程师', 208, 1); INSERT INTO pc_workcategory VALUES ('20200305004', '20200305000', '系统集成工程师', 209, 1); INSERT INTO pc_workcategory VALUES ('20200305005', '20200305000', '系统架构设计师', 210, 1); INSERT INTO pc_workcategory VALUES ('20200306001', '20200306000', '标准化工程师', 211, 1); INSERT INTO pc_workcategory VALUES ('20200306002', '20200306000', '电信交换工程师', 212, 1); INSERT INTO pc_workcategory VALUES ('20200306003', '20200306000', '电信网络工程师', 213, 1); INSERT INTO pc_workcategory VALUES ('20200306004', '20200306000', '射频工程师', 214, 1); INSERT INTO pc_workcategory VALUES ('20200306005', '20200306000', '手机结构工程师', 215, 1); INSERT INTO pc_workcategory VALUES ('20200306006', '20200306000', '手机驱动/测试工程师', 216, 1); INSERT INTO pc_workcategory VALUES ('20200306007', '20200306000', '手机软件项目经理', 217, 1); INSERT INTO pc_workcategory VALUES ('20200306008', '20200306000', '手机维修工程师', 218, 1); INSERT INTO pc_workcategory VALUES ('20200306009', '20200306000', '手机应用开发工程师', 219, 1); INSERT INTO pc_workcategory VALUES ('20200306010', '20200306000', '手机硬件项目经理', 220, 1); INSERT INTO pc_workcategory VALUES ('20200306011', '20200306000', '数据通信工程师', 221, 1); INSERT INTO pc_workcategory VALUES ('20200306012', '20200306000', '通信电源工程师', 222, 1); INSERT INTO pc_workcategory VALUES ('20200306013', '20200306000', '通信技术/电信工程师', 223, 1); INSERT INTO pc_workcategory VALUES ('20200306015', '20200306000', '无线通信工程师', 224, 1); INSERT INTO pc_workcategory VALUES ('20200306016', '20200306000', '项目经理/主管', 225, 1); INSERT INTO pc_workcategory VALUES ('20200306017', '20200306000', '研发工程师', 226, 1); INSERT INTO pc_workcategory VALUES ('20200306018', '20200306000', '移动通信工程师', 227, 1); INSERT INTO pc_workcategory VALUES ('20200306019', '20200306000', '有线传输工程师', 228, 1); INSERT INTO pc_workcategory VALUES ('20200306020', '20200306000', '增值产品开发工程师', 229, 1); INSERT INTO pc_workcategory VALUES ('20200307001', '20200307000', 'IC工程师', 230, 1); INSERT INTO pc_workcategory VALUES ('20200307002', '20200307000', '安防监控', 231, 1); INSERT INTO pc_workcategory VALUES ('20200307003', '20200307000', '单片机LARM/CNC/DLC/DSP/FAE工程师', 232, 1); INSERT INTO pc_workcategory VALUES ('20200307004', '20200307000', '电池/电源开发工程师', 233, 1); INSERT INTO pc_workcategory VALUES ('20200307005', '20200307000', '电路/版图/布线设计师', 234, 1); INSERT INTO pc_workcategory VALUES ('20200307006', '20200307000', '电器工程师/技术员', 235, 1); INSERT INTO pc_workcategory VALUES ('20200307007', '20200307000', '电声/音响工程师/技术员', 236, 1); INSERT INTO pc_workcategory VALUES ('20200307008', '20200307000', '电子/电器维修', 237, 1); INSERT INTO pc_workcategory VALUES ('20200307009', '20200307000', '电子测试工程师', 238, 1); INSERT INTO pc_workcategory VALUES ('20200307010', '20200307000', '电子工程师/技术员', 239, 1); INSERT INTO pc_workcategory VALUES ('20200307011', '20200307000', '电子元器件/半导工程师', 240, 1); INSERT INTO pc_workcategory VALUES ('20200307012', '20200307000', '光源照明工程师', 241, 1); INSERT INTO pc_workcategory VALUES ('20200307013', '20200307000', '激光/光电子技术', 242, 1); INSERT INTO pc_workcategory VALUES ('20200307014', '20200307000', '集成电路IC设计/应用工程师', 243, 1); INSERT INTO pc_workcategory VALUES ('20200307015', '20200307000', '家电数码产品开发工程师', 244, 1); INSERT INTO pc_workcategory VALUES ('20200307016', '20200307000', '嵌入式开发工程师', 245, 1); INSERT INTO pc_workcategory VALUES ('20200307017', '20200307000', '射频工程师/技术员', 246, 1); INSERT INTO pc_workcategory VALUES ('20200307018', '20200307000', '无线电技术工程师/技术员', 247, 1); INSERT INTO pc_workcategory VALUES ('20200307019', '20200307000', '智能人原/综合布线/弱线', 248, 1); INSERT INTO pc_workcategory VALUES ('20200307020', '20200307000', '自动控制工程师/技术员', 249, 1); INSERT INTO pc_workcategory VALUES ('20200308001', '20200308000', 'UI、UE设计师/顾问', 250, 1); INSERT INTO pc_workcategory VALUES ('20200308002', '20200308000', '测试工程师', 251, 1); INSERT INTO pc_workcategory VALUES ('20200308003', '20200308000', '产品经理/主管', 252, 1); INSERT INTO pc_workcategory VALUES ('20200308004', '20200308000', '产品专员', 253, 1); INSERT INTO pc_workcategory VALUES ('20200308005', '20200308000', '电子商务经理/主管', 254, 1); INSERT INTO pc_workcategory VALUES ('20200308006', '20200308000', '电子商务专员', 255, 1); INSERT INTO pc_workcategory VALUES ('20200308007', '20200308000', '互联网软件开发工程师', 256, 1); INSERT INTO pc_workcategory VALUES ('20200308008', '20200308000', '网店店长/客服', 257, 1); INSERT INTO pc_workcategory VALUES ('20200308009', '20200308000', '网页设计/制作/美工', 258, 1); INSERT INTO pc_workcategory VALUES ('20200308010', '20200308000', '网站编辑/论坛维护/内容监管', 259, 1); INSERT INTO pc_workcategory VALUES ('20200308011', '20200308000', '网站策划/管理', 260, 1); INSERT INTO pc_workcategory VALUES ('20200308012', '20200308000', '网站架构设计师', 261, 1); INSERT INTO pc_workcategory VALUES ('20200308013', '20200308000', '网站维护工程师', 262, 1); INSERT INTO pc_workcategory VALUES ('20200308014', '20200308000', '网站营运专员', 263, 1); INSERT INTO pc_workcategory VALUES ('20200308015', '20200308000', '网站运营经理/主管', 264, 1); INSERT INTO pc_workcategory VALUES ('20200308016', '20200308000', '网站运营总监', 265, 1); INSERT INTO pc_workcategory VALUES ('20200308017', '20200308000', '网站准广/优化/SEO', 266, 1); INSERT INTO pc_workcategory VALUES ('20200401001', '20200401000', '促销经理', 267, 1); INSERT INTO pc_workcategory VALUES ('20200401002', '20200401000', '促销员', 268, 1); INSERT INTO pc_workcategory VALUES ('20200401003', '20200401000', '促销主管/督导', 269, 1); INSERT INTO pc_workcategory VALUES ('20200401004', '20200401000', '大客户经理', 270, 1); INSERT INTO pc_workcategory VALUES ('20200401005', '20200401000', '电话销售员', 271, 1); INSERT INTO pc_workcategory VALUES ('20200401006', '20200401000', '零售/百货/连锁管理', 272, 1); INSERT INTO pc_workcategory VALUES ('20200401007', '20200401000', '商务代表/专员/助理', 273, 1); INSERT INTO pc_workcategory VALUES ('20200401008', '20200401000', '商务经理/主管', 274, 1); INSERT INTO pc_workcategory VALUES ('20200401009', '20200401000', '特许加盟/经销商', 275, 1); INSERT INTO pc_workcategory VALUES ('20200401010', '20200401000', '团购业务员', 276, 1); INSERT INTO pc_workcategory VALUES ('20200401011', '20200401000', '推销员/业务员', 277, 1); INSERT INTO pc_workcategory VALUES ('20200401012', '20200401000', '销售代表/销售助理/顾问', 278, 1); INSERT INTO pc_workcategory VALUES ('20200401013', '20200401000', '销售工程师', 279, 1); INSERT INTO pc_workcategory VALUES ('20200401014', '20200401000', '销售经理', 280, 1); INSERT INTO pc_workcategory VALUES ('20200401015', '20200401000', '销售行政经理/主管', 281, 1); INSERT INTO pc_workcategory VALUES ('20200401016', '20200401000', '销售行政专员/助理', 282, 1); INSERT INTO pc_workcategory VALUES ('20200401017', '20200401000', '销售主管/主任', 283, 1); INSERT INTO pc_workcategory VALUES ('20200401018', '20200401000', '销售总监', 284, 1); INSERT INTO pc_workcategory VALUES ('20200401019', '20200401000', '招商/渠道/分销/拓展经理', 285, 1); INSERT INTO pc_workcategory VALUES ('20200401020', '20200401000', '招商/渠道/分销/拓展专员', 286, 1); INSERT INTO pc_workcategory VALUES ('20200402001', '20200402000', '客户代表/专员', 287, 1); INSERT INTO pc_workcategory VALUES ('20200402002', '20200402000', '客户服务经理/主管（非技术）', 288, 1); INSERT INTO pc_workcategory VALUES ('20200402003', '20200402000', '客户服务专员/助理（非技术）', 289, 1); INSERT INTO pc_workcategory VALUES ('20200402004', '20200402000', '客户服务总监', 290, 1); INSERT INTO pc_workcategory VALUES ('20200402005', '20200402000', '客户关系管理/公共关系管理', 291, 1); INSERT INTO pc_workcategory VALUES ('20200402006', '20200402000', '客户经理/主管', 292, 1); INSERT INTO pc_workcategory VALUES ('20200402007', '20200402000', '客户培训', 293, 1); INSERT INTO pc_workcategory VALUES ('20200402008', '20200402000', '客户投诉受理/监控/协调', 294, 1); INSERT INTO pc_workcategory VALUES ('20200402009', '20200402000', '客户咨询/热线/呼叫中心人员', 295, 1); INSERT INTO pc_workcategory VALUES ('20200403001', '20200403000', '技术服务/支持专员', 296, 1); INSERT INTO pc_workcategory VALUES ('20200403002', '20200403000', '技术支持经理/主管', 297, 1); INSERT INTO pc_workcategory VALUES ('20200403003', '20200403000', '售后支持经理', 298, 1); INSERT INTO pc_workcategory VALUES ('20200403004', '20200403000', '售后支持主管', 299, 1); INSERT INTO pc_workcategory VALUES ('20200403005', '20200403000', '售后支持专员/售后支持工程师', 300, 1); INSERT INTO pc_workcategory VALUES ('20200403006', '20200403000', '售前支持经理', 301, 1); INSERT INTO pc_workcategory VALUES ('20200403007', '20200403000', '售前支持主管', 302, 1); INSERT INTO pc_workcategory VALUES ('20200403008', '20200403000', '售前支持专员/售前支持工程师', 303, 1); INSERT INTO pc_workcategory VALUES ('20200404001', '20200404000', '店长/店面管理员', 304, 1); INSERT INTO pc_workcategory VALUES ('20200404002', '20200404000', '店员/营业员/促销员/导购员', 305, 1); INSERT INTO pc_workcategory VALUES ('20200404003', '20200404000', '接待/咨询员', 306, 1); INSERT INTO pc_workcategory VALUES ('20200404004', '20200404000', '开票员/收银员', 307, 1); INSERT INTO pc_workcategory VALUES ('20200404005', '20200404000', '理货员/陈列员/防损员', 308, 1); INSERT INTO pc_workcategory VALUES ('20200404006', '20200404000', '牛鲜/食品加工', 309, 1); INSERT INTO pc_workcategory VALUES ('20200404007', '20200404000', '商场/卖场管理员', 310, 1); INSERT INTO pc_workcategory VALUES ('20200404008', '20200404000', '商场/卖场经理', 311, 1); INSERT INTO pc_workcategory VALUES ('20200405001', '20200405000', '法律顾问', 312, 1); INSERT INTO pc_workcategory VALUES ('20200405002', '20200405000', '法务经理/主管', 313, 1); INSERT INTO pc_workcategory VALUES ('20200405003', '20200405000', '法务专员/助理', 314, 1); INSERT INTO pc_workcategory VALUES ('20200405004', '20200405000', '公证员', 315, 1); INSERT INTO pc_workcategory VALUES ('20200405005', '20200405000', '合规部经理/主任', 316, 1); INSERT INTO pc_workcategory VALUES ('20200405006', '20200405000', '合规部助理/专员', 317, 1); INSERT INTO pc_workcategory VALUES ('20200405007', '20200405000', '婚烟服务', 318, 1); INSERT INTO pc_workcategory VALUES ('20200405008', '20200405000', '律师', 319, 1); INSERT INTO pc_workcategory VALUES ('20200405009', '20200405000', '律师助理', 320, 1); INSERT INTO pc_workcategory VALUES ('20200405010', '20200405000', '情报信息分析员', 321, 1); INSERT INTO pc_workcategory VALUES ('20200405011', '20200405000', '市场调查员', 322, 1); INSERT INTO pc_workcategory VALUES ('20200405012', '20200405000', '书记员', 323, 1); INSERT INTO pc_workcategory VALUES ('20200405013', '20200405000', '知识产权/专利顾问/专员', 324, 1); INSERT INTO pc_workcategory VALUES ('20200405014', '20200405000', '职业猎头/人才中介', 325, 1); INSERT INTO pc_workcategory VALUES ('20200405015', '20200405000', '专业顾问', 326, 1); INSERT INTO pc_workcategory VALUES ('20200405016', '20200405000', '专业顾问/咨询顾问', 327, 1); INSERT INTO pc_workcategory VALUES ('20200405017', '20200405000', '咨询经理', 328, 1); INSERT INTO pc_workcategory VALUES ('20200405018', '20200405000', '咨询师/咨询员', 329, 1); INSERT INTO pc_workcategory VALUES ('20200405019', '20200405000', '咨询总监', 330, 1); INSERT INTO pc_workcategory VALUES ('20200501001', '20200501000', '产品/品牌经理', 331, 1); INSERT INTO pc_workcategory VALUES ('20200501002', '20200501000', '产品/品牌主管', 332, 1); INSERT INTO pc_workcategory VALUES ('20200501003', '20200501000', '产品/品牌专员/助理', 333, 1); INSERT INTO pc_workcategory VALUES ('20200501004', '20200501000', '市场/营销经理', 334, 1); INSERT INTO pc_workcategory VALUES ('20200501005', '20200501000', '市场/营销主管', 335, 1); INSERT INTO pc_workcategory VALUES ('20200501006', '20200501000', '市场/营销专员/助理', 336, 1); INSERT INTO pc_workcategory VALUES ('20200501007', '20200501000', '市场/营销总监', 337, 1); INSERT INTO pc_workcategory VALUES ('20200501008', '20200501000', '市场策划/企划经理', 338, 1); INSERT INTO pc_workcategory VALUES ('20200501009', '20200501000', '市场策划/企划主管', 339, 1); INSERT INTO pc_workcategory VALUES ('20200501010', '20200501000', '市场策划/企划专员/助理', 340, 1); INSERT INTO pc_workcategory VALUES ('20200501011', '20200501000', '市场调研与分析', 341, 1); INSERT INTO pc_workcategory VALUES ('20200501012', '20200501000', '市场推广经理', 342, 1); INSERT INTO pc_workcategory VALUES ('20200501013', '20200501000', '市场推广主管', 343, 1); INSERT INTO pc_workcategory VALUES ('20200501014', '20200501000', '市场推广专员/助理', 344, 1); INSERT INTO pc_workcategory VALUES ('20200501015', '20200501000', '网络营销与推广/SEO', 345, 1); INSERT INTO pc_workcategory VALUES ('20200501016', '20200501000', '微营销师', 346, 1); INSERT INTO pc_workcategory VALUES ('20200501017', '20200501000', '选址拓展/新店开发', 347, 1); INSERT INTO pc_workcategory VALUES ('20200501018', '20200501000', '业务分析经理/主管', 348, 1); INSERT INTO pc_workcategory VALUES ('20200501019', '20200501000', '业务分析专员/助理', 349, 1); INSERT INTO pc_workcategory VALUES ('20200502001', '20200502000', '公关/活动经理', 350, 1); INSERT INTO pc_workcategory VALUES ('20200502002', '20200502000', '公关/活动主管/专员', 351, 1); INSERT INTO pc_workcategory VALUES ('20200502003', '20200502000', '广告创意/设计主管', 352, 1); INSERT INTO pc_workcategory VALUES ('20200502004', '20200502000', '广告创意经理/设计经理', 353, 1); INSERT INTO pc_workcategory VALUES ('20200502005', '20200502000', '广告创意总监', 354, 1); INSERT INTO pc_workcategory VALUES ('20200502006', '20200502000', '广告客户主管/专员', 355, 1); INSERT INTO pc_workcategory VALUES ('20200502007', '20200502000', '广告客户总监/经理', 356, 1); INSERT INTO pc_workcategory VALUES ('20200502008', '20200502000', '广告设计师', 357, 1); INSERT INTO pc_workcategory VALUES ('20200502009', '20200502000', '广告文案策划', 358, 1); INSERT INTO pc_workcategory VALUES ('20200502010', '20200502000', '广告制作', 359, 1); INSERT INTO pc_workcategory VALUES ('20200502011', '20200502000', '会展/会务经理', 360, 1); INSERT INTO pc_workcategory VALUES ('20200502012', '20200502000', '会展/会务主管/专员', 361, 1); INSERT INTO pc_workcategory VALUES ('20200502013', '20200502000', '会展策划设计', 362, 1); INSERT INTO pc_workcategory VALUES ('20200502014', '20200502000', '活动策划', 363, 1); INSERT INTO pc_workcategory VALUES ('20200502015', '20200502000', '活动执行', 364, 1); INSERT INTO pc_workcategory VALUES ('20200503001', '20200503000', 'CAD设计/制图', 365, 1); INSERT INTO pc_workcategory VALUES ('20200503002', '20200503000', '包装设计', 366, 1); INSERT INTO pc_workcategory VALUES ('20200503003', '20200503000', '插画师', 367, 1); INSERT INTO pc_workcategory VALUES ('20200503004', '20200503000', '创意指导/创意总监', 368, 1); INSERT INTO pc_workcategory VALUES ('20200503005', '20200503000', '店面设计/装潢设计', 369, 1); INSERT INTO pc_workcategory VALUES ('20200503006', '20200503000', '动漫/卡通设计', 370, 1); INSERT INTO pc_workcategory VALUES ('20200503007', '20200503000', '多媒体/动画/3D设计', 371, 1); INSERT INTO pc_workcategory VALUES ('20200503008', '20200503000', '服装设计/打样/制版', 372, 1); INSERT INTO pc_workcategory VALUES ('20200503009', '20200503000', '服装设计人员', 373, 1); INSERT INTO pc_workcategory VALUES ('20200503010', '20200503000', '工业设计产品外观设计', 374, 1); INSERT INTO pc_workcategory VALUES ('20200503011', '20200503000', '工艺品/珠宝/饰品设计', 375, 1); INSERT INTO pc_workcategory VALUES ('20200503012', '20200503000', '家具/家居用品设计', 376, 1); INSERT INTO pc_workcategory VALUES ('20200503013', '20200503000', '家具设计师', 377, 1); INSERT INTO pc_workcategory VALUES ('20200503014', '20200503000', '美术编辑/美术指导', 378, 1); INSERT INTO pc_workcategory VALUES ('20200503015', '20200503000', '美术设计', 379, 1); INSERT INTO pc_workcategory VALUES ('20200503016', '20200503000', '慕墙设计师/幕墙工程师', 380, 1); INSERT INTO pc_workcategory VALUES ('20200503017', '20200503000', '平面设计经理/主管', 381, 1); INSERT INTO pc_workcategory VALUES ('20200503018', '20200503000', '平面设计师', 382, 1); INSERT INTO pc_workcategory VALUES ('20200503019', '20200503000', '平面设计总监', 383, 1); INSERT INTO pc_workcategory VALUES ('20200503020', '20200503000', '室内设计', 384, 1); INSERT INTO pc_workcategory VALUES ('20200503021', '20200503000', '玩具设计', 385, 1); INSERT INTO pc_workcategory VALUES ('20200503022', '20200503000', '形象设计', 386, 1); INSERT INTO pc_workcategory VALUES ('20200503023', '20200503000', '游戏设计', 387, 1); INSERT INTO pc_workcategory VALUES ('20200503024', '20200503000', '原画师', 388, 1); INSERT INTO pc_workcategory VALUES ('20200503025', '20200503000', '造型/雕塑设计', 389, 1); INSERT INTO pc_workcategory VALUES ('20200503026', '20200503000', '展览设计师', 390, 1); INSERT INTO pc_workcategory VALUES ('20200503027', '20200503000', '展台/展览/展示/陈列设计', 391, 1); INSERT INTO pc_workcategory VALUES ('20200503028', '20200503000', '装饰设计师/室内设计师', 392, 1); INSERT INTO pc_workcategory VALUES ('20200504001', '20200504000', '播音/主持', 393, 1); INSERT INTO pc_workcategory VALUES ('20200504002', '20200504000', '导演/编导', 394, 1); INSERT INTO pc_workcategory VALUES ('20200504003', '20200504000', '灯光师', 395, 1); INSERT INTO pc_workcategory VALUES ('20200504004', '20200504000', '电影工程技术人员', 396, 1); INSERT INTO pc_workcategory VALUES ('20200504005', '20200504000', '放映经理/主管/放映员', 397, 1); INSERT INTO pc_workcategory VALUES ('20200504006', '20200504000', '服装/试衣模特', 398, 1); INSERT INTO pc_workcategory VALUES ('20200504007', '20200504000', '服装陈列师', 399, 1); INSERT INTO pc_workcategory VALUES ('20200504008', '20200504000', '广播电视编播工程技术人员', 400, 1); INSERT INTO pc_workcategory VALUES ('20200504009', '20200504000', '广播电视传输覆盖工程技术人员', 401, 1); INSERT INTO pc_workcategory VALUES ('20200504010', '20200504000', '广播影视编辑/策划/制作人', 402, 1); INSERT INTO pc_workcategory VALUES ('20200504011', '20200504000', '化妆师/造型师', 403, 1); INSERT INTO pc_workcategory VALUES ('20200504012', '20200504000', '节目/会议/活动/婚礼主持人', 404, 1); INSERT INTO pc_workcategory VALUES ('20200504013', '20200504000', '经纪人/星探', 405, 1); INSERT INTO pc_workcategory VALUES ('20200504014', '20200504000', '配音员', 406, 1); INSERT INTO pc_workcategory VALUES ('20200504015', '20200504000', '其他剧务', 407, 1); INSERT INTO pc_workcategory VALUES ('20200504016', '20200504000', '摄影师/摄像师', 408, 1); INSERT INTO pc_workcategory VALUES ('20200504017', '20200504000', '视频编辑/微电影制作', 409, 1); INSERT INTO pc_workcategory VALUES ('20200504018', '20200504000', '演员/模特', 410, 1); INSERT INTO pc_workcategory VALUES ('20200504019', '20200504000', '音效师', 411, 1); INSERT INTO pc_workcategory VALUES ('20200505001', '20200505000', '餐饮/娱乐管理', 412, 1); INSERT INTO pc_workcategory VALUES ('20200505002', '20200505000', '餐饮/娱乐领班', 413, 1); INSERT INTO pc_workcategory VALUES ('20200505003', '20200505000', '餐饮娱乐服务生', 414, 1); INSERT INTO pc_workcategory VALUES ('20200505004', '20200505000', '厨师', 415, 1); INSERT INTO pc_workcategory VALUES ('20200505005', '20200505000', '厨师助理/学徒', 416, 1); INSERT INTO pc_workcategory VALUES ('20200505006', '20200505000', '传菜主管/传菜员', 417, 1); INSERT INTO pc_workcategory VALUES ('20200505007', '20200505000', '调酒师/茶艺师', 418, 1); INSERT INTO pc_workcategory VALUES ('20200505008', '20200505000', '面点师', 419, 1); INSERT INTO pc_workcategory VALUES ('20200505009', '20200505000', '食雕', 420, 1); INSERT INTO pc_workcategory VALUES ('20200505010', '20200505000', '行政主厨/厨师长', 421, 1); INSERT INTO pc_workcategory VALUES ('20200506001', '20200506000', '宾客服务经理', 422, 1); INSERT INTO pc_workcategory VALUES ('20200506002', '20200506000', '大堂经理/楼面经理', 423, 1); INSERT INTO pc_workcategory VALUES ('20200506003', '20200506000', '大厅总台接待/大堂经理', 424, 1); INSERT INTO pc_workcategory VALUES ('20200506004', '20200506000', '管家部经理/主管', 425, 1); INSERT INTO pc_workcategory VALUES ('20200506005', '20200506000', '酒店/宾馆经理', 426, 1); INSERT INTO pc_workcategory VALUES ('20200506006', '20200506000', '酒店/宾馆营销', 427, 1); INSERT INTO pc_workcategory VALUES ('20200506007', '20200506000', '酒店/饭店/农家乐营销', 428, 1); INSERT INTO pc_workcategory VALUES ('20200506008', '20200506000', '酒店保安人员', 429, 1); INSERT INTO pc_workcategory VALUES ('20200506009', '20200506000', '酒店厨师/厨房工作人员', 430, 1); INSERT INTO pc_workcategory VALUES ('20200506010', '20200506000', '酒店水电工/空调工', 431, 1); INSERT INTO pc_workcategory VALUES ('20200506011', '20200506000', '客房服务/楼面服务/行李员', 432, 1); INSERT INTO pc_workcategory VALUES ('20200506012', '20200506000', '客房服务员', 433, 1); INSERT INTO pc_workcategory VALUES ('20200506013', '20200506000', '前台/礼仪/迎宾/司仪', 434, 1); INSERT INTO pc_workcategory VALUES ('20200506014', '20200506000', '前厅接待', 435, 1); INSERT INTO pc_workcategory VALUES ('20200506015', '20200506000', '清活服务人员', 436, 1); INSERT INTO pc_workcategory VALUES ('20200506016', '20200506000', '商务中心/订票/订房', 437, 1); INSERT INTO pc_workcategory VALUES ('20200506017', '20200506000', '宴会管理员', 438, 1); INSERT INTO pc_workcategory VALUES ('20200507001', '20200507000', '导游/旅行顾问', 439, 1); INSERT INTO pc_workcategory VALUES ('20200507003', '20200507000', '计划调度', 440, 1); INSERT INTO pc_workcategory VALUES ('20200507004', '20200507000', '旅游产品设计与开发', 441, 1); INSERT INTO pc_workcategory VALUES ('20200507005', '20200507000', '旅游产品销售', 442, 1); INSERT INTO pc_workcategory VALUES ('20200507006', '20200507000', '旅游管理人员', 443, 1); INSERT INTO pc_workcategory VALUES ('20200507007', '20200507000', '旅游计调', 444, 1); INSERT INTO pc_workcategory VALUES ('20200507008', '20200507000', '签证专员', 445, 1); INSERT INTO pc_workcategory VALUES ('20200507009', '20200507000', '行程管理/操作', 446, 1); INSERT INTO pc_workcategory VALUES ('20200507010', '20200507000', '预定/票务人员', 447, 1); INSERT INTO pc_workcategory VALUES ('20200507011', '20200507000', '展览讲解员', 448, 1); INSERT INTO pc_workcategory VALUES ('20200508001', '20200508000', '阿拉伯语翻译', 449, 1); INSERT INTO pc_workcategory VALUES ('20200508002', '20200508000', '德语翻译', 450, 1); INSERT INTO pc_workcategory VALUES ('20200508003', '20200508000', '俄语翻译', 451, 1); INSERT INTO pc_workcategory VALUES ('20200508004', '20200508000', '法语翻译', 452, 1); INSERT INTO pc_workcategory VALUES ('20200508005', '20200508000', '韩语/朝鲜语翻译', 453, 1); INSERT INTO pc_workcategory VALUES ('20200508006', '20200508000', '葡萄牙语翻译', 454, 1); INSERT INTO pc_workcategory VALUES ('20200508007', '20200508000', '其他语种翻译', 455, 1); INSERT INTO pc_workcategory VALUES ('20200508008', '20200508000', '日语翻译', 456, 1); INSERT INTO pc_workcategory VALUES ('20200508009', '20200508000', '泰语翻译', 457, 1); INSERT INTO pc_workcategory VALUES ('20200508010', '20200508000', '西班牙语翻译', 458, 1); INSERT INTO pc_workcategory VALUES ('20200508011', '20200508000', '意大利语翻译', 459, 1); INSERT INTO pc_workcategory VALUES ('20200508012', '20200508000', '英语翻译', 460, 1); INSERT INTO pc_workcategory VALUES ('20200508013', '20200508000', '中国方言翻译', 461, 1); INSERT INTO pc_workcategory VALUES ('20200601001', '20200601000', '财务分析经理/主管', 462, 1); INSERT INTO pc_workcategory VALUES ('20200601002', '20200601000', '财务分析员', 463, 1); INSERT INTO pc_workcategory VALUES ('20200601003', '20200601000', '财务顾问', 464, 1); INSERT INTO pc_workcategory VALUES ('20200601004', '20200601000', '财务主管/总账主管', 465, 1); INSERT INTO pc_workcategory VALUES ('20200601005', '20200601000', '成本会计', 466, 1); INSERT INTO pc_workcategory VALUES ('20200601006', '20200601000', '成本经理/主管', 467, 1); INSERT INTO pc_workcategory VALUES ('20200601007', '20200601000', '成本专员/成本助理', 468, 1); INSERT INTO pc_workcategory VALUES ('20200601008', '20200601000', '出纳', 469, 1); INSERT INTO pc_workcategory VALUES ('20200601009', '20200601000', '固定资产会计', 470, 1); INSERT INTO pc_workcategory VALUES ('20200601010', '20200601000', '会计经理/会计主管', 471, 1); INSERT INTO pc_workcategory VALUES ('20200601011', '20200601000', '会计师/会计', 472, 1); INSERT INTO pc_workcategory VALUES ('20200601012', '20200601000', '会计文员', 473, 1); INSERT INTO pc_workcategory VALUES ('20200601013', '20200601000', '收银/收费员', 474, 1); INSERT INTO pc_workcategory VALUES ('20200601014', '20200601000', '首席财务官CFO/财务总监', 475, 1); INSERT INTO pc_workcategory VALUES ('20200601015', '20200601000', '资金经理/资金主管', 476, 1); INSERT INTO pc_workcategory VALUES ('20200601016', '20200601000', '资金专员资金助理', 477, 1); INSERT INTO pc_workcategory VALUES ('20200602001', '20200602000', '审计经理/审计主管', 478, 1); INSERT INTO pc_workcategory VALUES ('20200602002', '20200602000', '审计师/审计专员/助理', 479, 1); INSERT INTO pc_workcategory VALUES ('20200602003', '20200602000', '统计师/统计专员', 480, 1); INSERT INTO pc_workcategory VALUES ('20200603001', '20200603000', '税务经理/税务主管', 481, 1); INSERT INTO pc_workcategory VALUES ('20200603002', '20200603000', '税务师/税务专员/税务助理', 482, 1); INSERT INTO pc_workcategory VALUES ('20200604001', '20200604000', '个人业务部门经理/主管', 483, 1); INSERT INTO pc_workcategory VALUES ('20200604002', '20200604000', '个人业务客户经理', 484, 1); INSERT INTO pc_workcategory VALUES ('20200604003', '20200604000', '公司业务部门经理/主管', 485, 1); INSERT INTO pc_workcategory VALUES ('20200604004', '20200604000', '公司业务客户经理', 486, 1); INSERT INTO pc_workcategory VALUES ('20200604005', '20200604000', '金融资产评估/风险控制', 487, 1); INSERT INTO pc_workcategory VALUES ('20200604006', '20200604000', '进出口/信用证结算', 488, 1); INSERT INTO pc_workcategory VALUES ('20200604007', '20200604000', '外汇交易', 489, 1); INSERT INTO pc_workcategory VALUES ('20200604008', '20200604000', '信贷管理/信用调查/稽核分析', 490, 1); INSERT INTO pc_workcategory VALUES ('20200604009', '20200604000', '银行柜员', 491, 1); INSERT INTO pc_workcategory VALUES ('20200604010', '20200604000', '银行会计', 492, 1); INSERT INTO pc_workcategory VALUES ('20200604011', '20200604000', '银行卡、电子银行业务推广人员', 493, 1); INSERT INTO pc_workcategory VALUES ('20200604012', '20200604000', '银行客户经理/主管', 494, 1); INSERT INTO pc_workcategory VALUES ('20200604013', '20200604000', '银行客户专员', 495, 1); INSERT INTO pc_workcategory VALUES ('20200604014', '20200604000', '银行行长/副行长', 496, 1); INSERT INTO pc_workcategory VALUES ('20200604015', '20200604000', '银行营业部主任/经理', 497, 1); INSERT INTO pc_workcategory VALUES ('20200604016', '20200604000', '营业部大堂经理', 498, 1); INSERT INTO pc_workcategory VALUES ('20200604017', '20200604000', '预结算清算人员', 499, 1); INSERT INTO pc_workcategory VALUES ('20200604018', '20200604000', '综合业务经理/主管', 500, 1); INSERT INTO pc_workcategory VALUES ('20200604019', '20200604000', '综合业务专员', 501, 1); INSERT INTO pc_workcategory VALUES ('20200605001', '20200605000', '保险产品分析/研究', 502, 1); INSERT INTO pc_workcategory VALUES ('20200605002', '20200605000', '保险产品开发/项目策划', 503, 1); INSERT INTO pc_workcategory VALUES ('20200605003', '20200605000', '保险代理/经纪人/客户经理', 504, 1); INSERT INTO pc_workcategory VALUES ('20200605004', '20200605000', '保险核保/理陪/续期服务', 505, 1); INSERT INTO pc_workcategory VALUES ('20200605005', '20200605000', '保险精算师', 506, 1); INSERT INTO pc_workcategory VALUES ('20200605006', '20200605000', '保险理财顾可/财务策划师', 507, 1); INSERT INTO pc_workcategory VALUES ('20200605007', '20200605000', '保险内勤', 508, 1); INSERT INTO pc_workcategory VALUES ('20200605008', '20200605000', '保险培训师', 509, 1); INSERT INTO pc_workcategory VALUES ('20200605009', '20200605000', '保险妥理岗', 510, 1); INSERT INTO pc_workcategory VALUES ('20200605010', '20200605000', '保险业务经理/主管', 511, 1); INSERT INTO pc_workcategory VALUES ('20200605011', '20200605000', '车险核保岗', 512, 1); INSERT INTO pc_workcategory VALUES ('20200605012', '20200605000', '契约管理', 513, 1); INSERT INTO pc_workcategory VALUES ('20200606001', '20200606000', '担保/拍卖师/典当师', 514, 1); INSERT INTO pc_workcategory VALUES ('20200606002', '20200606000', '风险管理/控制/稽查', 515, 1); INSERT INTO pc_workcategory VALUES ('20200606003', '20200606000', '股票/期货操盘手', 516, 1); INSERT INTO pc_workcategory VALUES ('20200606004', '20200606000', '黄金/外汇操盘手', 517, 1); INSERT INTO pc_workcategory VALUES ('20200606005', '20200606000', '基金管理', 518, 1); INSERT INTO pc_workcategory VALUES ('20200606006', '20200606000', '金融/经济研究员', 519, 1); INSERT INTO pc_workcategory VALUES ('20200606007', '20200606000', '融资经理/融资主管', 520, 1); INSERT INTO pc_workcategory VALUES ('20200606008', '20200606000', '融资专员/顾问', 521, 1); INSERT INTO pc_workcategory VALUES ('20200606009', '20200606000', '融资总监', 522, 1); INSERT INTO pc_workcategory VALUES ('20200606010', '20200606000', '投资/理财顾问', 523, 1); INSERT INTO pc_workcategory VALUES ('20200606011', '20200606000', '投资顾可/基金经理', 524, 1); INSERT INTO pc_workcategory VALUES ('20200606012', '20200606000', '投资银行业务', 525, 1); INSERT INTO pc_workcategory VALUES ('20200606013', '20200606000', '外汇交易/基金/国债经理人', 526, 1); INSERT INTO pc_workcategory VALUES ('20200606014', '20200606000', '证券/期货/黄金/外汇经纪人', 527, 1); INSERT INTO pc_workcategory VALUES ('20200606015', '20200606000', '证券分析师', 528, 1); INSERT INTO pc_workcategory VALUES ('20200606016', '20200606000', '注册投资/金融分析师', 529, 1); INSERT INTO pc_workcategory VALUES ('20200606017', '20200606000', '资产评估师/评估员', 530, 1); INSERT INTO pc_workcategory VALUES ('20200701001', '20200701000', '产经理/车间主任', 531, 1); INSERT INTO pc_workcategory VALUES ('20200701002', '20200701000', '产品工程师/生产工程师(PE)', 532, 1); INSERT INTO pc_workcategory VALUES ('20200701003', '20200701000', '产主管/督导/领班/组长', 533, 1); INSERT INTO pc_workcategory VALUES ('20200701004', '20200701000', '厂长/副厂长', 534, 1); INSERT INTO pc_workcategory VALUES ('20200701005', '20200701000', '工人/操作员', 535, 1); INSERT INTO pc_workcategory VALUES ('20200701006', '20200701000', '工业工程师(IE)', 536, 1); INSERT INTO pc_workcategory VALUES ('20200701007', '20200701000', '化验员', 537, 1); INSERT INTO pc_workcategory VALUES ('20200701008', '20200701000', '生产跟单/单证', 538, 1); INSERT INTO pc_workcategory VALUES ('20200701009', '20200701000', '生产计划/调度', 539, 1); INSERT INTO pc_workcategory VALUES ('20200701010', '20200701000', '生产文员', 540, 1); INSERT INTO pc_workcategory VALUES ('20200701011', '20200701000', '生产项目经理/主管', 541, 1); INSERT INTO pc_workcategory VALUES ('20200701012', '20200701000', '实验卒负责人/工程师', 542, 1); INSERT INTO pc_workcategory VALUES ('20200701013', '20200701000', '物料管理(PMC)/生成设备管理', 543, 1); INSERT INTO pc_workcategory VALUES ('20200701014', '20200701000', '研发经理/主管', 544, 1); INSERT INTO pc_workcategory VALUES ('20200701015', '20200701000', '制程工程师/制造工程师(ME)', 545, 1); INSERT INTO pc_workcategory VALUES ('20200701016', '20200701000', '总工程师/副总工程师', 546, 1); INSERT INTO pc_workcategory VALUES ('20200702001', '20200702000', '安全/健康/环境工程师(EHS)', 547, 1); INSERT INTO pc_workcategory VALUES ('20200702002', '20200702000', '安全工程师', 548, 1); INSERT INTO pc_workcategory VALUES ('20200702003', '20200702000', '安全管理', 549, 1); INSERT INTO pc_workcategory VALUES ('20200702004', '20200702000', '安全消防', 550, 1); INSERT INTO pc_workcategory VALUES ('20200702005', '20200702000', '安全主任', 551, 1); INSERT INTO pc_workcategory VALUES ('20200702006', '20200702000', '环境/健康/安全经理/主管(EHS)', 552, 1); INSERT INTO pc_workcategory VALUES ('20200702007', '20200702000', '建筑试验/检测/安全管理', 553, 1); INSERT INTO pc_workcategory VALUES ('20200703001', '20200703000', '标住化工程师(ISO等)', 554, 1); INSERT INTO pc_workcategory VALUES ('20200703002', '20200703000', '测试员', 555, 1); INSERT INTO pc_workcategory VALUES ('20200703003', '20200703000', '化验员', 556, 1); INSERT INTO pc_workcategory VALUES ('20200703004', '20200703000', '检测员', 557, 1); INSERT INTO pc_workcategory VALUES ('20200703005', '20200703000', '品质/管理工程师(QA/QC工程师)', 558, 1); INSERT INTO pc_workcategory VALUES ('20200703006', '20200703000', '品质/管理经理(QA/QC经理)', 559, 1); INSERT INTO pc_workcategory VALUES ('20200703007', '20200703000', '品质/管理主管(QA/QC主管)', 560, 1); INSERT INTO pc_workcategory VALUES ('20200703008', '20200703000', '体系/认证工程师/审核员(ISO等)', 561, 1); INSERT INTO pc_workcategory VALUES ('20200703009', '20200703000', '质检管理', 562, 1); INSERT INTO pc_workcategory VALUES ('20200703010', '20200703000', '质检员', 563, 1); INSERT INTO pc_workcategory VALUES ('20200704001', '20200704000', '材料/设备采购管理', 564, 1); INSERT INTO pc_workcategory VALUES ('20200704002', '20200704000', '采购经理/主管', 565, 1); INSERT INTO pc_workcategory VALUES ('20200704003', '20200704000', '采购专员/助理', 566, 1); INSERT INTO pc_workcategory VALUES ('20200704004', '20200704000', '采购总监', 567, 1); INSERT INTO pc_workcategory VALUES ('20200704005', '20200704000', '供应商管理', 568, 1); INSERT INTO pc_workcategory VALUES ('20200704006', '20200704000', '外贸采购', 569, 1); INSERT INTO pc_workcategory VALUES ('20200705001', '20200705000', '船务/空运/陆运操作', 570, 1); INSERT INTO pc_workcategory VALUES ('20200705002', '20200705000', '供应链经理/主管', 571, 1); INSERT INTO pc_workcategory VALUES ('20200705003', '20200705000', '供应链专员', 572, 1); INSERT INTO pc_workcategory VALUES ('20200705004', '20200705000', '供应链总监', 573, 1); INSERT INTO pc_workcategory VALUES ('20200705005', '20200705000', '货运代理', 574, 1); INSERT INTO pc_workcategory VALUES ('20200705006', '20200705000', '集装箱业务操作', 575, 1); INSERT INTO pc_workcategory VALUES ('20200705007', '20200705000', '物流经理/主管', 576, 1); INSERT INTO pc_workcategory VALUES ('20200705008', '20200705000', '物流专员/助理', 577, 1); INSERT INTO pc_workcategory VALUES ('20200705009', '20200705000', '物流总监', 578, 1); INSERT INTO pc_workcategory VALUES ('20200705010', '20200705000', '运输经理/主管/专员', 579, 1); INSERT INTO pc_workcategory VALUES ('20200706001', '20200706000', '仓库管理员', 580, 1); INSERT INTO pc_workcategory VALUES ('20200706002', '20200706000', '仓库经理/主管', 581, 1); INSERT INTO pc_workcategory VALUES ('20200706003', '20200706000', '调度员/理货员', 582, 1); INSERT INTO pc_workcategory VALUES ('20200706004', '20200706000', '物料管理', 583, 1); INSERT INTO pc_workcategory VALUES ('20200707001', '20200707000', '报关/报检', 584, 1); INSERT INTO pc_workcategory VALUES ('20200707002', '20200707000', '海关事务管理', 585, 1); INSERT INTO pc_workcategory VALUES ('20200707003', '20200707000', '贸易单证', 586, 1); INSERT INTO pc_workcategory VALUES ('20200707004', '20200707000', '贸易经理/外贸主管', 587, 1); INSERT INTO pc_workcategory VALUES ('20200707005', '20200707000', '贸易专员/外贸助理', 588, 1); INSERT INTO pc_workcategory VALUES ('20200707006', '20200707000', '内贸跟单', 589, 1); INSERT INTO pc_workcategory VALUES ('20200707007', '20200707000', '外贸跟单', 590, 1); INSERT INTO pc_workcategory VALUES ('20200708001', '20200708000', '船长/副船长', 591, 1); INSERT INTO pc_workcategory VALUES ('20200708002', '20200708000', '船员/水手', 592, 1); INSERT INTO pc_workcategory VALUES ('20200708003', '20200708000', '地铁人员', 593, 1); INSERT INTO pc_workcategory VALUES ('20200708004', '20200708000', '飞机机长/副机长', 594, 1); INSERT INTO pc_workcategory VALUES ('20200708005', '20200708000', '公路运输/司机', 595, 1); INSERT INTO pc_workcategory VALUES ('20200708006', '20200708000', '空乘人员', 596, 1); INSERT INTO pc_workcategory VALUES ('20200708007', '20200708000', '快递员/配送员', 597, 1); INSERT INTO pc_workcategory VALUES ('20200708008', '20200708000', '列车/地铁车长', 598, 1); INSERT INTO pc_workcategory VALUES ('20200708009', '20200708000', '列车/地铁司机', 599, 1); INSERT INTO pc_workcategory VALUES ('20200708010', '20200708000', '铁路/公路乘务员', 600, 1); INSERT INTO pc_workcategory VALUES ('20200708011', '20200708000', '押运员', 601, 1); INSERT INTO pc_workcategory VALUES ('20200801001', '20200801000', '公疗器械生产/质量管理', 602, 1); INSERT INTO pc_workcategory VALUES ('20200801002', '20200801000', '关疗器械销售经理/主管', 603, 1); INSERT INTO pc_workcategory VALUES ('20200801003', '20200801000', '化学分析测试员', 604, 1); INSERT INTO pc_workcategory VALUES ('20200801004', '20200801000', '临床数据分析员', 605, 1); INSERT INTO pc_workcategory VALUES ('20200801005', '20200801000', '临床协调员', 606, 1); INSERT INTO pc_workcategory VALUES ('20200801006', '20200801000', '临床研究员', 607, 1); INSERT INTO pc_workcategory VALUES ('20200801007', '20200801000', '药品生产/质量管理', 608, 1); INSERT INTO pc_workcategory VALUES ('20200801008', '20200801000', '药品市场淮广经理', 609, 1); INSERT INTO pc_workcategory VALUES ('20200801009', '20200801000', '药品市场推广主管/专员', 610, 1); INSERT INTO pc_workcategory VALUES ('20200801010', '20200801000', '药品注册', 611, 1); INSERT INTO pc_workcategory VALUES ('20200801011', '20200801000', '医疗器械市场推广', 612, 1); INSERT INTO pc_workcategory VALUES ('20200801012', '20200801000', '医疗器械维修人员', 613, 1); INSERT INTO pc_workcategory VALUES ('20200801013', '20200801000', '医疗器械销售代表', 614, 1); INSERT INTO pc_workcategory VALUES ('20200801014', '20200801000', '医疗器械研发', 615, 1); INSERT INTO pc_workcategory VALUES ('20200801015', '20200801000', '医疗器械注册', 616, 1); INSERT INTO pc_workcategory VALUES ('20200801016', '20200801000', '医药技术研发人员', 617, 1); INSERT INTO pc_workcategory VALUES ('20200801017', '20200801000', '医药销售代表', 618, 1); INSERT INTO pc_workcategory VALUES ('20200801018', '20200801000', '医药销售经理/主管', 619, 1); INSERT INTO pc_workcategory VALUES ('20200801019', '20200801000', '医药招商', 620, 1); INSERT INTO pc_workcategory VALUES ('20200801020', '20200801000', '招投标管理', 621, 1); INSERT INTO pc_workcategory VALUES ('20200801021', '20200801000', '政府事务管理', 622, 1); INSERT INTO pc_workcategory VALUES ('20200802001', '20200802000', '病理科医师', 623, 1); INSERT INTO pc_workcategory VALUES ('20200802002', '20200802000', '超声诊断科医师', 624, 1); INSERT INTO pc_workcategory VALUES ('20200802003', '20200802000', '传卖病科医师', 625, 1); INSERT INTO pc_workcategory VALUES ('20200802004', '20200802000', '儿科医师', 626, 1); INSERT INTO pc_workcategory VALUES ('20200802005', '20200802000', '耳鼻喉科医师', 627, 1); INSERT INTO pc_workcategory VALUES ('20200802006', '20200802000', '放射科医师', 628, 1); INSERT INTO pc_workcategory VALUES ('20200802007', '20200802000', '放射肿瘤科医师', 629, 1); INSERT INTO pc_workcategory VALUES ('20200802008', '20200802000', '妇产科医师', 630, 1); INSERT INTO pc_workcategory VALUES ('20200802009', '20200802000', '妇幼保健医师', 631, 1); INSERT INTO pc_workcategory VALUES ('20200802010', '20200802000', '核医学医师', 632, 1); INSERT INTO pc_workcategory VALUES ('20200802011', '20200802000', '急诊科医师', 633, 1); INSERT INTO pc_workcategory VALUES ('20200802012', '20200802000', '精神科医师', 634, 1); INSERT INTO pc_workcategory VALUES ('20200802013', '20200802000', '康复科医师', 635, 1); INSERT INTO pc_workcategory VALUES ('20200802014', '20200802000', '口腔科医师', 636, 1); INSERT INTO pc_workcategory VALUES ('20200802015', '20200802000', '麻醉科医师', 637, 1); INSERT INTO pc_workcategory VALUES ('20200802016', '20200802000', '内科医师', 638, 1); INSERT INTO pc_workcategory VALUES ('20200802017', '20200802000', '皮肤科医师', 639, 1); INSERT INTO pc_workcategory VALUES ('20200802018', '20200802000', '全科医师', 640, 1); INSERT INTO pc_workcategory VALUES ('20200802019', '20200802000', '输(采供）血医师', 641, 1); INSERT INTO pc_workcategory VALUES ('20200802020', '20200802000', '外科医师', 642, 1); INSERT INTO pc_workcategory VALUES ('20200802021', '20200802000', '乡村医师', 643, 1); INSERT INTO pc_workcategory VALUES ('20200802022', '20200802000', '心理科医师', 644, 1); INSERT INTO pc_workcategory VALUES ('20200802023', '20200802000', '眼科医师', 645, 1); INSERT INTO pc_workcategory VALUES ('20200803001', '20200803000', '民族医师(如藏医等)', 646, 1); INSERT INTO pc_workcategory VALUES ('20200803002', '20200803000', '推拿按摩科医师', 647, 1); INSERT INTO pc_workcategory VALUES ('20200803003', '20200803000', '针灸科医师', 648, 1); INSERT INTO pc_workcategory VALUES ('20200803004', '20200803000', '中西医结合医师', 649, 1); INSERT INTO pc_workcategory VALUES ('20200803005', '20200803000', '中医儿科医师', 650, 1); INSERT INTO pc_workcategory VALUES ('20200803006', '20200803000', '中医耳鼻候科医师', 651, 1); INSERT INTO pc_workcategory VALUES ('20200803007', '20200803000', '中医妇科医师', 652, 1); INSERT INTO pc_workcategory VALUES ('20200803008', '20200803000', '中医肛肠科医师', 653, 1); INSERT INTO pc_workcategory VALUES ('20200803009', '20200803000', '中医骨伤科医师', 654, 1); INSERT INTO pc_workcategory VALUES ('20200803010', '20200803000', '中医内科医师', 655, 1); INSERT INTO pc_workcategory VALUES ('20200803011', '20200803000', '中医皮肤科医师', 656, 1); INSERT INTO pc_workcategory VALUES ('20200803012', '20200803000', '中医外科医师', 657, 1); INSERT INTO pc_workcategory VALUES ('20200803013', '20200803000', '中医眼科医师', 658, 1); INSERT INTO pc_workcategory VALUES ('20200804001', '20200804000', '放射卫生医师', 659, 1); INSERT INTO pc_workcategory VALUES ('20200804002', '20200804000', '环境卫生医师', 660, 1); INSERT INTO pc_workcategory VALUES ('20200804003', '20200804000', '劳动(职业)卫生医生', 661, 1); INSERT INTO pc_workcategory VALUES ('20200804004', '20200804000', '流行病学医师', 662, 1); INSERT INTO pc_workcategory VALUES ('20200804005', '20200804000', '少和学校卫生医生', 663, 1); INSERT INTO pc_workcategory VALUES ('20200804006', '20200804000', '营养与食品卫生医生', 664, 1); INSERT INTO pc_workcategory VALUES ('20200804007', '20200804000', '职业病医师', 665, 1); INSERT INTO pc_workcategory VALUES ('20200805001', '20200805000', '病理技师', 666, 1); INSERT INTO pc_workcategory VALUES ('20200805002', '20200805000', '公卫检验技师', 667, 1); INSERT INTO pc_workcategory VALUES ('20200805003', '20200805000', '临床检验技师', 668, 1); INSERT INTO pc_workcategory VALUES ('20200805004', '20200805000', '麻醉技师', 669, 1); INSERT INTO pc_workcategory VALUES ('20200805005', '20200805000', '输（采供)血技师', 670, 1); INSERT INTO pc_workcategory VALUES ('20200805006', '20200805000', '卫生工程技师', 671, 1); INSERT INTO pc_workcategory VALUES ('20200805007', '20200805000', '西药剂师', 672, 1); INSERT INTO pc_workcategory VALUES ('20200805008', '20200805000', '影像技师', 673, 1); INSERT INTO pc_workcategory VALUES ('20200805009', '20200805000', '中药药师', 674, 1); INSERT INTO pc_workcategory VALUES ('20200806001', '20200806000', '病房护士', 675, 1); INSERT INTO pc_workcategory VALUES ('20200806002', '20200806000', '供应室护士', 676, 1); INSERT INTO pc_workcategory VALUES ('20200806003', '20200806000', '急诊护士', 677, 1); INSERT INTO pc_workcategory VALUES ('20200806004', '20200806000', '门诊护士', 678, 1); INSERT INTO pc_workcategory VALUES ('20200806005', '20200806000', '社区护士', 679, 1); INSERT INTO pc_workcategory VALUES ('20200806006', '20200806000', '手术至/重症监护室护士', 680, 1); INSERT INTO pc_workcategory VALUES ('20200806007', '20200806000', '助产士', 681, 1); INSERT INTO pc_workcategory VALUES ('20200901001', '20200901000', '安全员', 682, 1); INSERT INTO pc_workcategory VALUES ('20200901002', '20200901000', '电气/照明工程师', 683, 1); INSERT INTO pc_workcategory VALUES ('20200901003', '20200901000', '电气工程师', 684, 1); INSERT INTO pc_workcategory VALUES ('20200901004', '20200901000', '防雷/消防/安防', 685, 1); INSERT INTO pc_workcategory VALUES ('20200901005', '20200901000', '钢结构设计', 686, 1); INSERT INTO pc_workcategory VALUES ('20200901006', '20200901000', '给排水/水电工程师', 687, 1); INSERT INTO pc_workcategory VALUES ('20200901008', '20200901000', '工程测绘/测量', 688, 1); INSERT INTO pc_workcategory VALUES ('20200901009', '20200901000', '工程管理/项目经理/主管', 689, 1); INSERT INTO pc_workcategory VALUES ('20200901010', '20200901000', '工程监理/督导/验收', 690, 1); INSERT INTO pc_workcategory VALUES ('20200901011', '20200901000', '工程造价师/预结算/审计', 691, 1); INSERT INTO pc_workcategory VALUES ('20200901012', '20200901000', '工程招投标/报批报建', 692, 1); INSERT INTO pc_workcategory VALUES ('20200901013', '20200901000', '工程质量管理', 693, 1); INSERT INTO pc_workcategory VALUES ('20200901014', '20200901000', '基础/地下/岩土工程师', 694, 1); INSERT INTO pc_workcategory VALUES ('20200901015', '20200901000', '监理工程师', 695, 1); INSERT INTO pc_workcategory VALUES ('20200901016', '20200901000', '建造师', 696, 1); INSERT INTO pc_workcategory VALUES ('20200901017', '20200901000', '建筑材料与制品', 697, 1); INSERT INTO pc_workcategory VALUES ('20200901018', '20200901000', '建筑工程/结构设计', 698, 1); INSERT INTO pc_workcategory VALUES ('20200901019', '20200901000', '建筑工程师/注册建筑师', 699, 1); INSERT INTO pc_workcategory VALUES ('20200901020', '20200901000', '建筑绘图/制图', 700, 1); INSERT INTO pc_workcategory VALUES ('20200901021', '20200901000', '结构工程师', 701, 1); INSERT INTO pc_workcategory VALUES ('20200901022', '20200901000', '路桥/港口/航道/隧道工程师', 702, 1); INSERT INTO pc_workcategory VALUES ('20200901023', '20200901000', '慕墙工程师', 703, 1); INSERT INTO pc_workcategory VALUES ('20200901024', '20200901000', '暖通/管道/制冷工程', 704, 1); INSERT INTO pc_workcategory VALUES ('20200901025', '20200901000', '审图工程师', 705, 1); INSERT INTO pc_workcategory VALUES ('20200901026', '20200901000', '施工员', 706, 1); INSERT INTO pc_workcategory VALUES ('20200901027', '20200901000', '室内外装潢设计', 707, 1); INSERT INTO pc_workcategory VALUES ('20200901028', '20200901000', '土木/土建工程师', 708, 1); INSERT INTO pc_workcategory VALUES ('20200901029', '20200901000', '土木建筑工程', 709, 1); INSERT INTO pc_workcategory VALUES ('20200901030', '20200901000', '造价工程师', 710, 1); INSERT INTO pc_workcategory VALUES ('20200901031', '20200901000', '制冷/暖通/管道工程师', 711, 1); INSERT INTO pc_workcategory VALUES ('20200901032', '20200901000', '资料员/合同管理员', 712, 1); INSERT INTO pc_workcategory VALUES ('20200901033', '20200901000', '总建筑师/高级建筑师/建筑设计', 713, 1); INSERT INTO pc_workcategory VALUES ('20200902001', '20200902000', '保洁员', 714, 1); INSERT INTO pc_workcategory VALUES ('20200902002', '20200902000', '房地产按揭', 715, 1); INSERT INTO pc_workcategory VALUES ('20200902003', '20200902000', '房地产开发/策划经理/主管', 716, 1); INSERT INTO pc_workcategory VALUES ('20200902004', '20200902000', '房地产开发/策划专员', 717, 1); INSERT INTO pc_workcategory VALUES ('20200902005', '20200902000', '房地产评估', 718, 1); INSERT INTO pc_workcategory VALUES ('20200902006', '20200902000', '房地产中介/交易', 719, 1); INSERT INTO pc_workcategory VALUES ('20200902007', '20200902000', '高级物业顾问/物业顾问', 720, 1); INSERT INTO pc_workcategory VALUES ('20200902008', '20200902000', '工程部经理/主管', 721, 1); INSERT INTO pc_workcategory VALUES ('20200902009', '20200902000', '会所管理', 722, 1); INSERT INTO pc_workcategory VALUES ('20200902010', '20200902000', '土地评估', 723, 1); INSERT INTO pc_workcategory VALUES ('20200902011', '20200902000', '物业公司安保/保安人员', 724, 1); INSERT INTO pc_workcategory VALUES ('20200902012', '20200902000', '物业管理经理/主管', 725, 1); INSERT INTO pc_workcategory VALUES ('20200902013', '20200902000', '物业管理专员/助理', 726, 1); INSERT INTO pc_workcategory VALUES ('20200902014', '20200902000', '物业水电工', 727, 1); INSERT INTO pc_workcategory VALUES ('20200902015', '20200902000', '物业维修/设施管理', 728, 1); INSERT INTO pc_workcategory VALUES ('20200902016', '20200902000', '物业招商/租赁/租售', 729, 1); INSERT INTO pc_workcategory VALUES ('20200902017', '20200902000', '置业顾问', 730, 1); INSERT INTO pc_workcategory VALUES ('20200903001', '20200903000', 'CNC/数控工程师', 731, 1); INSERT INTO pc_workcategory VALUES ('20200903002', '20200903000', '冲压工程师/技师', 732, 1); INSERT INTO pc_workcategory VALUES ('20200903003', '20200903000', '焊接工程师/技术员', 733, 1); INSERT INTO pc_workcategory VALUES ('20200903004', '20200903000', '航空/航天/船舶/汽轮机工程师/技术员', 734, 1); INSERT INTO pc_workcategory VALUES ('20200903005', '20200903000', '机电工程师/技术员', 735, 1); INSERT INTO pc_workcategory VALUES ('20200903006', '20200903000', '机械/设备安装/维修工程师', 736, 1); INSERT INTO pc_workcategory VALUES ('20200903007', '20200903000', '机械/设备工程师', 737, 1); INSERT INTO pc_workcategory VALUES ('20200903008', '20200903000', '机械/设备加工', 738, 1); INSERT INTO pc_workcategory VALUES ('20200903009', '20200903000', '机械/设备经理/主管', 739, 1); INSERT INTO pc_workcategory VALUES ('20200903010', '20200903000', '机械绘图员', 740, 1); INSERT INTO pc_workcategory VALUES ('20200903011', '20200903000', '机械设计/制造工程师', 741, 1); INSERT INTO pc_workcategory VALUES ('20200903012', '20200903000', '结构工程师/技术员', 742, 1); INSERT INTO pc_workcategory VALUES ('20200903013', '20200903000', '精密机械/仪器/传感器工程师/技术员', 743, 1); INSERT INTO pc_workcategory VALUES ('20200903014', '20200903000', '模具工程师', 744, 1); INSERT INTO pc_workcategory VALUES ('20200903015', '20200903000', '铸造/锻造工程师/技术员', 745, 1); INSERT INTO pc_workcategory VALUES ('20200903016', '20200903000', '注塑/吹塑/电镀工程师', 746, 1); INSERT INTO pc_workcategory VALUES ('20200904001', '20200904000', '4S店展厅经理', 747, 1); INSERT INTO pc_workcategory VALUES ('20200904002', '20200904000', '车身/造型设计师', 748, 1); INSERT INTO pc_workcategory VALUES ('20200904003', '20200904000', '底盘及传动系统工程师', 749, 1); INSERT INTO pc_workcategory VALUES ('20200904004', '20200904000', '二手车评估师', 750, 1); INSERT INTO pc_workcategory VALUES ('20200904005', '20200904000', '发动机及附件设计师', 751, 1); INSERT INTO pc_workcategory VALUES ('20200904006', '20200904000', '汽车安全性能工程师', 752, 1); INSERT INTO pc_workcategory VALUES ('20200904007', '20200904000', '汽车电子工程师', 753, 1); INSERT INTO pc_workcategory VALUES ('20200904008', '20200904000', '汽车驾驶培训', 754, 1); INSERT INTO pc_workcategory VALUES ('20200904009', '20200904000', '汽车结构工程师', 755, 1); INSERT INTO pc_workcategory VALUES ('20200904010', '20200904000', '汽车零部件工程师', 756, 1); INSERT INTO pc_workcategory VALUES ('20200904011', '20200904000', '汽车美容/修理', 757, 1); INSERT INTO pc_workcategory VALUES ('20200904012', '20200904000', '汽车内外饰设计工程师', 758, 1); INSERT INTO pc_workcategory VALUES ('20200904013', '20200904000', '汽车设计工程师', 759, 1); INSERT INTO pc_workcategory VALUES ('20200904014', '20200904000', '汽车试验/测试/验车员', 760, 1); INSERT INTO pc_workcategory VALUES ('20200904015', '20200904000', '汽车维修/售后经理/主任', 761, 1); INSERT INTO pc_workcategory VALUES ('20200904016', '20200904000', '汽车维修高级技工', 762, 1); INSERT INTO pc_workcategory VALUES ('20200904017', '20200904000', '汽车维修顾问/接车员', 763, 1); INSERT INTO pc_workcategory VALUES ('20200904018', '20200904000', '汽车质量管理', 764, 1); INSERT INTO pc_workcategory VALUES ('20200904019', '20200904000', '汽车装配工艺工程师', 765, 1); INSERT INTO pc_workcategory VALUES ('20200904020', '20200904000', '汽车总装工程师', 766, 1); INSERT INTO pc_workcategory VALUES ('20200904021', '20200904000', '汽年焊接涂装工程师', 767, 1); INSERT INTO pc_workcategory VALUES ('20201001001', '20201001000', '编辑/作家/独立撰稿人', 768, 1); INSERT INTO pc_workcategory VALUES ('20201001002', '20201001000', '电子出版物编辑', 769, 1); INSERT INTO pc_workcategory VALUES ('20201001003', '20201001000', '记者/新闻采编', 770, 1); INSERT INTO pc_workcategory VALUES ('20201001004', '20201001000', '美术/技术编辑', 771, 1); INSERT INTO pc_workcategory VALUES ('20201001005', '20201001000', '排版设计', 772, 1); INSERT INTO pc_workcategory VALUES ('20201001006', '20201001000', '摄影记者', 773, 1); INSERT INTO pc_workcategory VALUES ('20201001007', '20201001000', '校对/录入', 774, 1); INSERT INTO pc_workcategory VALUES ('20201001008', '20201001000', '总编/副总编', 775, 1); INSERT INTO pc_workcategory VALUES ('20201002001', '20201002000', '调墨技师', 776, 1); INSERT INTO pc_workcategory VALUES ('20201002002', '20201002000', '晒板/拼版/装订/烫金', 777, 1); INSERT INTO pc_workcategory VALUES ('20201002003', '20201002000', '数码快印/菲林输出', 778, 1); INSERT INTO pc_workcategory VALUES ('20201002004', '20201002000', '印刷排版/制版', 779, 1); INSERT INTO pc_workcategory VALUES ('20201003001', '20201003000', '茶叶/茶制品工艺', 780, 1); INSERT INTO pc_workcategory VALUES ('20201003002', '20201003000', '食品工程技术人员', 781, 1); INSERT INTO pc_workcategory VALUES ('20201003003', '20201003000', '食品加工/酿酒/制糖工艺', 782, 1); INSERT INTO pc_workcategory VALUES ('20201003004', '20201003000', '烟草及其制造加工人员', 783, 1); INSERT INTO pc_workcategory VALUES ('20201004001', '20201004000', '板房/楦头/底格出格师', 784, 1); INSERT INTO pc_workcategory VALUES ('20201004002', '20201004000', '裁床/放码', 785, 1); INSERT INTO pc_workcategory VALUES ('20201004003', '20201004000', '纺织工程技术人员', 786, 1); INSERT INTO pc_workcategory VALUES ('20201004004', '20201004000', '服装/纺织/皮革跟单', 787, 1); INSERT INTO pc_workcategory VALUES ('20201004005', '20201004000', '服装/纺织设计', 788, 1); INSERT INTO pc_workcategory VALUES ('20201004006', '20201004000', '服装打样/制版', 789, 1); INSERT INTO pc_workcategory VALUES ('20201004007', '20201004000', '化学纤维生产人员', 790, 1); INSERT INTO pc_workcategory VALUES ('20201004008', '20201004000', '剪裁车缝熨烫', 791, 1); INSERT INTO pc_workcategory VALUES ('20201004009', '20201004000', '面料/辅料开发/采购', 792, 1); INSERT INTO pc_workcategory VALUES ('20201004010', '20201004000', '皮革生产人员', 793, 1); INSERT INTO pc_workcategory VALUES ('20201004011', '20201004000', '染整工程技术人员', 794, 1); INSERT INTO pc_workcategory VALUES ('20201004012', '20201004000', '鞋帽制作人员', 795, 1); INSERT INTO pc_workcategory VALUES ('20201004013', '20201004000', '织造/染色/定型/印发', 796, 1); INSERT INTO pc_workcategory VALUES ('20201004014', '20201004000', '织造工程技术人员', 797, 1); INSERT INTO pc_workcategory VALUES ('20201004015', '20201004000', '纸样师/车板工', 798, 1); INSERT INTO pc_workcategory VALUES ('20201005001', '20201005000', '配石/分石员', 799, 1); INSERT INTO pc_workcategory VALUES ('20201005002', '20201005000', '首饰倒模', 800, 1); INSERT INTO pc_workcategory VALUES ('20201005003', '20201005000', '首饰电金', 801, 1); INSERT INTO pc_workcategory VALUES ('20201005004', '20201005000', '首饰雕腊', 802, 1); INSERT INTO pc_workcategory VALUES ('20201005005', '20201005000', '首饰起板', 803, 1); INSERT INTO pc_workcategory VALUES ('20201005006', '20201005000', '首饰设计', 804, 1); INSERT INTO pc_workcategory VALUES ('20201005007', '20201005000', '首饰镶嵌', 805, 1); INSERT INTO pc_workcategory VALUES ('20201005008', '20201005000', '首饰学徒', 806, 1); INSERT INTO pc_workcategory VALUES ('20201005009', '20201005000', '首饰执边', 807, 1); INSERT INTO pc_workcategory VALUES ('20201005010', '20201005000', '首饰执模', 808, 1); INSERT INTO pc_workcategory VALUES ('20201005011', '20201005000', '珍珠加工', 809, 1); INSERT INTO pc_workcategory VALUES ('20201005012', '20201005000', '珍珠养殖', 810, 1); INSERT INTO pc_workcategory VALUES ('20201005013', '20201005000', '珠宝鉴定', 811, 1); INSERT INTO pc_workcategory VALUES ('20201005014', '20201005000', '珠宝设计', 812, 1); INSERT INTO pc_workcategory VALUES ('20201006001', '20201006000', '洁具设计师', 813, 1); INSERT INTO pc_workcategory VALUES ('20201006002', '20201006000', '陶瓷彩绘', 814, 1); INSERT INTO pc_workcategory VALUES ('20201006003', '20201006000', '陶瓷刮平工', 815, 1); INSERT INTO pc_workcategory VALUES ('20201006004', '20201006000', '陶瓷喷釉', 816, 1); INSERT INTO pc_workcategory VALUES ('20201006005', '20201006000', '陶瓷色料调色开发', 817, 1); INSERT INTO pc_workcategory VALUES ('20201006006', '20201006000', '陶瓷设计师', 818, 1); INSERT INTO pc_workcategory VALUES ('20201006007', '20201006000', '陶瓷手工成型', 819, 1); INSERT INTO pc_workcategory VALUES ('20201006008', '20201006000', '陶瓷选料', 820, 1); INSERT INTO pc_workcategory VALUES ('20201006009', '20201006000', '陶瓷印花/贴花', 821, 1); INSERT INTO pc_workcategory VALUES ('20201006010', '20201006000', '陶瓷装罐工', 822, 1); INSERT INTO pc_workcategory VALUES ('20201006011', '20201006000', '窑炉工程师/技术员', 823, 1); INSERT INTO pc_workcategory VALUES ('20201006012', '20201006000', '釉料技术', 824, 1); INSERT INTO pc_workcategory VALUES ('20201006013', '20201006000', '注塑/吹塑工程师', 825, 1); INSERT INTO pc_workcategory VALUES ('20201007001', '20201007000', '玻璃工艺/化工工艺', 826, 1); INSERT INTO pc_workcategory VALUES ('20201007002', '20201007000', '电镀化工', 827, 1); INSERT INTO pc_workcategory VALUES ('20201007003', '20201007000', '废品处理', 828, 1); INSERT INTO pc_workcategory VALUES ('20201007004', '20201007000', '化工产品生产管理人员', 829, 1); INSERT INTO pc_workcategory VALUES ('20201007005', '20201007000', '化工产品生产通用工艺', 830, 1); INSERT INTO pc_workcategory VALUES ('20201007006', '20201007000', '化工设计工程技术人员', 831, 1); INSERT INTO pc_workcategory VALUES ('20201007007', '20201007000', '化工生产工管理技术人员', 832, 1); INSERT INTO pc_workcategory VALUES ('20201007008', '20201007000', '化工实验工程技术人员', 833, 1); INSERT INTO pc_workcategory VALUES ('20201007009', '20201007000', '化工原料准备工', 834, 1); INSERT INTO pc_workcategory VALUES ('20201007010', '20201007000', '化学分析/化验/实验/检验', 835, 1); INSERT INTO pc_workcategory VALUES ('20201007011', '20201007000', '化学药剂/农药/化肥', 836, 1); INSERT INTO pc_workcategory VALUES ('20201007012', '20201007000', '化妆品研发', 837, 1); INSERT INTO pc_workcategory VALUES ('20201007013', '20201007000', '配色/涂料技术员', 838, 1); INSERT INTO pc_workcategory VALUES ('20201007014', '20201007000', '其他化工工程技术人员', 839, 1); INSERT INTO pc_workcategory VALUES ('20201007015', '20201007000', '水泥工艺', 840, 1); INSERT INTO pc_workcategory VALUES ('20201007016', '20201007000', '塑胶/塑料/注塑', 841, 1); INSERT INTO pc_workcategory VALUES ('20201007017', '20201007000', '涂料研发工程师', 842, 1); INSERT INTO pc_workcategory VALUES ('20201007018', '20201007000', '造纸研发', 843, 1); INSERT INTO pc_workcategory VALUES ('20201008001', '20201008000', '抽纱刺绣工艺品制作人员', 844, 1); INSERT INTO pc_workcategory VALUES ('20201008002', '20201008000', '地毯制作人员', 845, 1); INSERT INTO pc_workcategory VALUES ('20201008003', '20201008000', '金属工艺品制作人员', 846, 1); INSERT INTO pc_workcategory VALUES ('20201008004', '20201008000', '美术品制作人员', 847, 1); INSERT INTO pc_workcategory VALUES ('20201008005', '20201008000', '漆器工艺品制作人员', 848, 1); INSERT INTO pc_workcategory VALUES ('20201008006', '20201008000', '其他工艺、美术制作人员', 849, 1); INSERT INTO pc_workcategory VALUES ('20201008007', '20201008000', '玩具制作人员', 850, 1); INSERT INTO pc_workcategory VALUES ('20201008008', '20201008000', '周雕刻工艺品制作人员', 851, 1); INSERT INTO pc_workcategory VALUES ('20201008009', '20201008000', '珠宝首饰加工制作人员', 852, 1); INSERT INTO pc_workcategory VALUES ('20201101001', '20201101000', '其他气象工程技术人员', 853, 1); INSERT INTO pc_workcategory VALUES ('20201101002', '20201101000', '气候监测预测人员', 854, 1); INSERT INTO pc_workcategory VALUES ('20201101003', '20201101000', '气象服务人员', 855, 1); INSERT INTO pc_workcategory VALUES ('20201101004', '20201101000', '气象观测人员', 856, 1); INSERT INTO pc_workcategory VALUES ('20201101005', '20201101000', '天气预报人员', 857, 1); INSERT INTO pc_workcategory VALUES ('20201101006', '20201101000', '应用气象人员', 858, 1); INSERT INTO pc_workcategory VALUES ('20201102001', '20201102000', '电厂化学/水处理', 859, 1); INSERT INTO pc_workcategory VALUES ('20201102002', '20201102000', '防腐保温', 860, 1); INSERT INTO pc_workcategory VALUES ('20201102003', '20201102000', '废气治理', 861, 1); INSERT INTO pc_workcategory VALUES ('20201102004', '20201102000', '废水污水处理', 862, 1); INSERT INTO pc_workcategory VALUES ('20201102005', '20201102000', '给排水工程师', 863, 1); INSERT INTO pc_workcategory VALUES ('20201102006', '20201102000', '固废/垃圾处理', 864, 1); INSERT INTO pc_workcategory VALUES ('20201102007', '20201102000', '环境在线监测', 865, 1); INSERT INTO pc_workcategory VALUES ('20201102008', '20201102000', '环评工程师/技术人员', 866, 1); INSERT INTO pc_workcategory VALUES ('20201102009', '20201102000', '净水/纯水处理', 867, 1); INSERT INTO pc_workcategory VALUES ('20201102010', '20201102000', '水处理工程师', 868, 1); INSERT INTO pc_workcategory VALUES ('20201102011', '20201102000', '水质分析/化验', 869, 1); INSERT INTO pc_workcategory VALUES ('20201102012', '20201102000', '脱硫除尘工程师', 870, 1); INSERT INTO pc_workcategory VALUES ('20201102013', '20201102000', '循环冷却水处理', 871, 1); INSERT INTO pc_workcategory VALUES ('20201102014', '20201102000', '烟气脱硫工艺', 872, 1); INSERT INTO pc_workcategory VALUES ('20201103001', '20201103000', '大地测量工程师', 873, 1); INSERT INTO pc_workcategory VALUES ('20201103002', '20201103000', '地图制图与印刷工程师', 874, 1); INSERT INTO pc_workcategory VALUES ('20201103003', '20201103000', '地质勘探工程师', 875, 1); INSERT INTO pc_workcategory VALUES ('20201103004', '20201103000', '工程测量工程师', 876, 1); INSERT INTO pc_workcategory VALUES ('20201103005', '20201103000', '海洋测绘工程师', 877, 1); INSERT INTO pc_workcategory VALUES ('20201103006', '20201103000', '内业人员', 878, 1); INSERT INTO pc_workcategory VALUES ('20201103007', '20201103000', '其他勘探测绘工程师', 879, 1); INSERT INTO pc_workcategory VALUES ('20201103008', '20201103000', '摄影测星与遥感工程师', 880, 1); INSERT INTO pc_workcategory VALUES ('20201103009', '20201103000', '数据处理工程师', 881, 1); INSERT INTO pc_workcategory VALUES ('20201104001', '20201104000', '爆破技术', 882, 1); INSERT INTO pc_workcategory VALUES ('20201104002', '20201104000', '采矿工程师', 883, 1); INSERT INTO pc_workcategory VALUES ('20201104003', '20201104000', '矿山/采矿安全管理', 884, 1); INSERT INTO pc_workcategory VALUES ('20201104004', '20201104000', '矿山管理/采矿管理', 885, 1); INSERT INTO pc_workcategory VALUES ('20201104005', '20201104000', '矿物加工工程师', 886, 1); INSERT INTO pc_workcategory VALUES ('20201104006', '20201104000', '水文地质工程师', 887, 1); INSERT INTO pc_workcategory VALUES ('20201104007', '20201104000', '通风工程师/技术员', 888, 1); INSERT INTO pc_workcategory VALUES ('20201104008', '20201104000', '选矿工程师', 889, 1); INSERT INTO pc_workcategory VALUES ('20201105001', '20201105000', '采油工程师', 890, 1); INSERT INTO pc_workcategory VALUES ('20201105002', '20201105000', '测井/解释工程师', 891, 1); INSERT INTO pc_workcategory VALUES ('20201105003', '20201105000', '地球物理工程师', 892, 1); INSERT INTO pc_workcategory VALUES ('20201105004', '20201105000', '地震采集/解释工程师', 893, 1); INSERT INTO pc_workcategory VALUES ('20201105005', '20201105000', '地质工程师勘探工程师', 894, 1); INSERT INTO pc_workcategory VALUES ('20201105006', '20201105000', '调剖堵水工程师', 895, 1); INSERT INTO pc_workcategory VALUES ('20201105007', '20201105000', '录井工程师', 896, 1); INSERT INTO pc_workcategory VALUES ('20201105008', '20201105000', '泥浆工程师', 897, 1); INSERT INTO pc_workcategory VALUES ('20201105009', '20201105000', '数值模拟工程师', 898, 1); INSERT INTO pc_workcategory VALUES ('20201105010', '20201105000', '完井工程师', 899, 1); INSERT INTO pc_workcategory VALUES ('20201105011', '20201105000', '压裂工程师', 900, 1); INSERT INTO pc_workcategory VALUES ('20201105012', '20201105000', '油藏工程师', 901, 1); INSERT INTO pc_workcategory VALUES ('20201105013', '20201105000', '油田化学工程师', 902, 1); INSERT INTO pc_workcategory VALUES ('20201105014', '20201105000', '油田开发监督', 903, 1); INSERT INTO pc_workcategory VALUES ('20201105015', '20201105000', '钻井工程师', 904, 1); INSERT INTO pc_workcategory VALUES ('20201106001', '20201106000', '电力设备安装运行检修及供电人员', 905, 1); INSERT INTO pc_workcategory VALUES ('20201106002', '20201106000', '发电厂管理/电厂运行/安监', 906, 1); INSERT INTO pc_workcategory VALUES ('20201106003', '20201106000', '发电运行值班人员', 907, 1); INSERT INTO pc_workcategory VALUES ('20201106004', '20201106000', '风能发电工程技术人员', 908, 1); INSERT INTO pc_workcategory VALUES ('20201106005', '20201106000', '供用电工程技术人员', 909, 1); INSERT INTO pc_workcategory VALUES ('20201106006', '20201106000', '光伏光电太阳能工程师', 910, 1); INSERT INTO pc_workcategory VALUES ('20201106007', '20201106000', '光热工程师/技术人员', 911, 1); INSERT INTO pc_workcategory VALUES ('20201106008', '20201106000', '核能发电工程技术人员', 912, 1); INSERT INTO pc_workcategory VALUES ('20201106009', '20201106000', '火力发电工程技术人员', 913, 1); INSERT INTO pc_workcategory VALUES ('20201106010', '20201106000', '其他电力工程技术人员', 914, 1); INSERT INTO pc_workcategory VALUES ('20201106011', '20201106000', '输变电工程技术人员', 915, 1); INSERT INTO pc_workcategory VALUES ('20201107001', '20201107000', '半导体材料制备工', 916, 1); INSERT INTO pc_workcategory VALUES ('20201107002', '20201107000', '电解工程师/技术员', 917, 1); INSERT INTO pc_workcategory VALUES ('20201107003', '20201107000', '钢铁冶炼工', 918, 1); INSERT INTO pc_workcategory VALUES ('20201107004', '20201107000', '金屈轧制、铸管工', 919, 1); INSERT INTO pc_workcategory VALUES ('20201107005', '20201107000', '其他金属冶炼及加工', 920, 1); INSERT INTO pc_workcategory VALUES ('20201107006', '20201107000', '熔铸工程师', 921, 1); INSERT INTO pc_workcategory VALUES ('20201107007', '20201107000', '碳素制品生产工', 922, 1); INSERT INTO pc_workcategory VALUES ('20201107008', '20201107000', '稀贵金属冶炼工', 923, 1); INSERT INTO pc_workcategory VALUES ('20201107009', '20201107000', '氧化工程师/技术员', 924, 1); INSERT INTO pc_workcategory VALUES ('20201107010', '20201107000', '液压工程师/技术员', 925, 1); INSERT INTO pc_workcategory VALUES ('20201107011', '20201107000', '有色金属治炼工', 926, 1); INSERT INTO pc_workcategory VALUES ('20201108001', '20201108000', '堤坡防护', 927, 1); INSERT INTO pc_workcategory VALUES ('20201108002', '20201108000', '灌溉工程师', 928, 1); INSERT INTO pc_workcategory VALUES ('20201108003', '20201108000', '水保工程师', 929, 1); INSERT INTO pc_workcategory VALUES ('20201108004', '20201108000', '水电站运维', 930, 1); INSERT INTO pc_workcategory VALUES ('20201108005', '20201108000', '水工工程师', 931, 1); INSERT INTO pc_workcategory VALUES ('20201108006', '20201108000', '水工设计师', 932, 1); INSERT INTO pc_workcategory VALUES ('20201108007', '20201108000', '水利工程师', 933, 1); INSERT INTO pc_workcategory VALUES ('20201108008', '20201108000', '水利水电建筑工程', 934, 1); INSERT INTO pc_workcategory VALUES ('20201108009', '20201108000', '水利水电设计', 935, 1); INSERT INTO pc_workcategory VALUES ('20201108010', '20201108000', '水力设计', 936, 1); INSERT INTO pc_workcategory VALUES ('20201108011', '20201108000', '水轮发电', 937, 1); INSERT INTO pc_workcategory VALUES ('20201108012', '20201108000', '水土保持监测', 938, 1); INSERT INTO pc_workcategory VALUES ('20201108013', '20201108000', '水文水资源', 939, 1); INSERT INTO pc_workcategory VALUES ('20201109001', '20201109000', '采煤掘进井下支护', 940, 1); INSERT INTO pc_workcategory VALUES ('20201109002', '20201109000', '煤层气', 941, 1); INSERT INTO pc_workcategory VALUES ('20201109003', '20201109000', '煤化工', 942, 1); INSERT INTO pc_workcategory VALUES ('20201109004', '20201109000', '煤化工工程师', 943, 1); INSERT INTO pc_workcategory VALUES ('20201109005', '20201109000', '煤化油', 944, 1); INSERT INTO pc_workcategory VALUES ('20201109006', '20201109000', '煤技术', 945, 1); INSERT INTO pc_workcategory VALUES ('20201109007', '20201109000', '煤焦化/炼焦', 946, 1); INSERT INTO pc_workcategory VALUES ('20201109008', '20201109000', '煤气化', 947, 1); INSERT INTO pc_workcategory VALUES ('20201109009', '20201109000', '煤型加工', 948, 1); INSERT INTO pc_workcategory VALUES ('20201109010', '20201109000', '煤质分析/化验', 949, 1); INSERT INTO pc_workcategory VALUES ('20201109011', '20201109000', '水煤浆喷', 950, 1); INSERT INTO pc_workcategory VALUES ('20201109012', '20201109000', '瓦检员', 951, 1); INSERT INTO pc_workcategory VALUES ('20201109013', '20201109000', '选煤/洗煤', 952, 1); INSERT INTO pc_workcategory VALUES ('20201109014', '20201109000', '选煤设计', 953, 1); INSERT INTO pc_workcategory VALUES ('20201201001', '20201201000', '按摩/足疗师', 954, 1); INSERT INTO pc_workcategory VALUES ('20201201002', '20201201000', '保健按摩师', 955, 1); INSERT INTO pc_workcategory VALUES ('20201201003', '20201201000', '彩妆培训师', 956, 1); INSERT INTO pc_workcategory VALUES ('20201201004', '20201201000', '宠物护理/美容', 957, 1); INSERT INTO pc_workcategory VALUES ('20201201005', '20201201000', '发型师', 958, 1); INSERT INTO pc_workcategory VALUES ('20201201006', '20201201000', '发型助理/学徒', 959, 1); INSERT INTO pc_workcategory VALUES ('20201201007', '20201201000', '健身顾问/教练', 960, 1); INSERT INTO pc_workcategory VALUES ('20201201008', '20201201000', '康乐服务员', 961, 1); INSERT INTO pc_workcategory VALUES ('20201201009', '20201201000', '美甲师', 962, 1); INSERT INTO pc_workcategory VALUES ('20201201010', '20201201000', '美容顾问', 963, 1); INSERT INTO pc_workcategory VALUES ('20201201011', '20201201000', '美容师/化妆师', 964, 1); INSERT INTO pc_workcategory VALUES ('20201201012', '20201201000', '美容助理/见习美容师', 965, 1); INSERT INTO pc_workcategory VALUES ('20201201013', '20201201000', '社会体育指导员', 966, 1); INSERT INTO pc_workcategory VALUES ('20201201014', '20201201000', '体育场地工', 967, 1); INSERT INTO pc_workcategory VALUES ('20201201015', '20201201000', '专柜彩妆顾可(BA)', 968, 1); INSERT INTO pc_workcategory VALUES ('20201201016', '20201201000', '瑜伽/舞蹈老师', 969, 1); INSERT INTO pc_workcategory VALUES ('20201202001', '20201202000', '搬运工', 970, 1); INSERT INTO pc_workcategory VALUES ('20201202002', '20201202000', '家政服务/保姆', 971, 1); INSERT INTO pc_workcategory VALUES ('20201202003', '20201202000', '普工/杂工', 972, 1); INSERT INTO pc_workcategory VALUES ('20201202004', '20201202000', '清洁工', 973, 1); INSERT INTO pc_workcategory VALUES ('20201202005', '20201202000', '月嫂', 974, 1); INSERT INTO pc_workcategory VALUES ('20201203001', '20201203000', '插花员', 975, 1); INSERT INTO pc_workcategory VALUES ('20201203002', '20201203000', '城市规划与设计', 976, 1); INSERT INTO pc_workcategory VALUES ('20201203003', '20201203000', '城镇规划设计/土地整理及规划', 977, 1); INSERT INTO pc_workcategory VALUES ('20201203004', '20201203000', '观赏动物饲养工', 978, 1); INSERT INTO pc_workcategory VALUES ('20201203005', '20201203000', '花卉工程师', 979, 1); INSERT INTO pc_workcategory VALUES ('20201203006', '20201203000', '假山工', 980, 1); INSERT INTO pc_workcategory VALUES ('20201203007', '20201203000', '绿化工程', 981, 1); INSERT INTO pc_workcategory VALUES ('20201203008', '20201203000', '盆景工', 982, 1); INSERT INTO pc_workcategory VALUES ('20201203009', '20201203000', '园林/景观设计师', 983, 1); INSERT INTO pc_workcategory VALUES ('20201203010', '20201203000', '园林工程/园艺技术', 984, 1); INSERT INTO pc_workcategory VALUES ('20201203011', '20201203000', '园林绿化/养护', 985, 1); INSERT INTO pc_workcategory VALUES ('20201203012', '20201203000', '园林植物保护工', 986, 1); INSERT INTO pc_workcategory VALUES ('20201203013', '20201203000', '园艺/风景园林/景观工程', 987, 1); INSERT INTO pc_workcategory VALUES ('20201203014', '20201203000', '植物设计/配置', 988, 1); INSERT INTO pc_workcategory VALUES ('20201204001', '20201204000', '宠物医疗', 989, 1); INSERT INTO pc_workcategory VALUES ('20201204002', '20201204000', '笛木主管/技术员', 990, 1); INSERT INTO pc_workcategory VALUES ('20201204003', '20201204000', '动物营养/饲料研发', 991, 1); INSERT INTO pc_workcategory VALUES ('20201204004', '20201204000', '防虫防病害', 992, 1); INSERT INTO pc_workcategory VALUES ('20201204005', '20201204000', '林场管理', 993, 1); INSERT INTO pc_workcategory VALUES ('20201204006', '20201204000', '林业员', 994, 1); INSERT INTO pc_workcategory VALUES ('20201204007', '20201204000', '牧场管理', 995, 1); INSERT INTO pc_workcategory VALUES ('20201204008', '20201204000', '农场管理', 996, 1); INSERT INTO pc_workcategory VALUES ('20201204009', '20201204000', '农化服务', 997, 1); INSERT INTO pc_workcategory VALUES ('20201204010', '20201204000', '农艺师', 998, 1); INSERT INTO pc_workcategory VALUES ('20201204011', '20201204000', '配方工程师', 999, 1); INSERT INTO pc_workcategory VALUES ('20201204012', '20201204000', '兽医', 1000, 1); INSERT INTO pc_workcategory VALUES ('20201204013', '20201204000', '水产养殖', 1001, 1); INSERT INTO pc_workcategory VALUES ('20201204014', '20201204000', '饲养员', 1002, 1); INSERT INTO pc_workcategory VALUES ('20201204015', '20201204000', '畜牧师', 1003, 1); INSERT INTO pc_workcategory VALUES ('20201204016', '20201204000', '驯兽师/助理驯兽师', 1004, 1); INSERT INTO pc_workcategory VALUES ('20201204017', '20201204000', '养殖工程师/技术员', 1005, 1); INSERT INTO pc_workcategory VALUES ('20201204018', '20201204000', '渔场管理', 1006, 1); INSERT INTO pc_workcategory VALUES ('20201204019', '20201204000', '育种员', 1007, 1); INSERT INTO pc_workcategory VALUES ('20201204020', '20201204000', '植物保护专员', 1008, 1); INSERT INTO pc_workcategory VALUES ('20201204021', '20201204000', '种植技术', 1009, 1); INSERT INTO pc_workcategory VALUES ('20201205001', '20201205000', '裁缝', 1010, 1); INSERT INTO pc_workcategory VALUES ('20201205002', '20201205000', '采矿工', 1011, 1); INSERT INTO pc_workcategory VALUES ('20201205003', '20201205000', '抄表核算收费员', 1012, 1); INSERT INTO pc_workcategory VALUES ('20201205004', '20201205000', '车工', 1013, 1); INSERT INTO pc_workcategory VALUES ('20201205005', '20201205000', '电工', 1014, 1); INSERT INTO pc_workcategory VALUES ('20201205006', '20201205000', '电力设备安装工', 1015, 1); INSERT INTO pc_workcategory VALUES ('20201205007', '20201205000', '镀层工', 1016, 1); INSERT INTO pc_workcategory VALUES ('20201205008', '20201205000', '纺纱工', 1017, 1); INSERT INTO pc_workcategory VALUES ('20201205009', '20201205000', '钢筋工', 1018, 1); INSERT INTO pc_workcategory VALUES ('20201205010', '20201205000', '钢铁冶炼工', 1019, 1); INSERT INTO pc_workcategory VALUES ('20201205011', '20201205000', '管工', 1020, 1); INSERT INTO pc_workcategory VALUES ('20201205012', '20201205000', '锅炉工', 1021, 1); INSERT INTO pc_workcategory VALUES ('20201205013', '20201205000', '焊工', 1022, 1); INSERT INTO pc_workcategory VALUES ('20201205014', '20201205000', '架子工', 1023, 1); INSERT INTO pc_workcategory VALUES ('20201205015', '20201205000', '卷烟生产工', 1024, 1); INSERT INTO pc_workcategory VALUES ('20201205016', '20201205000', '铆工', 1025, 1); INSERT INTO pc_workcategory VALUES ('20201205017', '20201205000', '煤化工生产工', 1026, 1); INSERT INTO pc_workcategory VALUES ('20201205018', '20201205000', '磨工', 1027, 1); INSERT INTO pc_workcategory VALUES ('20201205019', '20201205000', '木工', 1028, 1); INSERT INTO pc_workcategory VALUES ('20201205020', '20201205000', '酿酒工', 1029, 1); INSERT INTO pc_workcategory VALUES ('20201205021', '20201205000', '刨插工', 1030, 1); INSERT INTO pc_workcategory VALUES ('20201205022', '20201205000', '砌筑工', 1031, 1); INSERT INTO pc_workcategory VALUES ('20201205023', '20201205000', '汽车修理工', 1032, 1); INSERT INTO pc_workcategory VALUES ('20201205024', '20201205000', '钳工', 1033, 1); INSERT INTO pc_workcategory VALUES ('20201205025', '20201205000', '石油炼制工', 1034, 1); INSERT INTO pc_workcategory VALUES ('20201205026', '20201205000', '涂装工', 1035, 1); INSERT INTO pc_workcategory VALUES ('20201205027', '20201205000', '托重工', 1036, 1); INSERT INTO pc_workcategory VALUES ('20201205028', '20201205000', '铣工', 1037, 1); INSERT INTO pc_workcategory VALUES ('20201205029', '20201205000', '印染工', 1038, 1); INSERT INTO pc_workcategory VALUES ('20201205030', '20201205000', '造纸工', 1039, 1); INSERT INTO pc_workcategory VALUES ('20201205031', '20201205000', '织造工', 1040, 1); INSERT INTO pc_workcategory VALUES ('20201205032', '20201205000', '铸造工', 1041, 1); INSERT INTO pc_workcategory VALUES ('20201205033', '20201205000', '装配工', 1042, 1); INSERT INTO pc_workcategory VALUES ('20201205034', '20201205000', '钻井工', 1043, 1); INSERT INTO pc_workcategory VALUES ('20201205035', '20201205000', '锽工', 1044, 1); INSERT INTO pc_workcategory VALUES ('20201205036', '20201205000', '钣金工', 1045, 1); INSERT INTO pc_workcategory VALUES ('20201206001', '20201206000', '普工', 1046, 1); INSERT INTO pc_workcategory VALUES ('20201207001', '20201207000', '社会工作者', 1047, 1); INSERT INTO pc_workcategory VALUES ('20201207002', '20201207000', '在校学生', 1048, 1); INSERT INTO pc_workcategory VALUES ('20201207003', '20201207000', '志愿者', 1049, 1); -- 2024.5.9标签关系表外键索引 delete from pc_label_company; alter table pc_label_company add constraint FK_Reference_30 foreign key (LabelID) references pc_label (LabelID) on delete restrict on update restrict; delete from pc_label_jobuser; alter table pc_label_jobuser add constraint FK_Reference_29 foreign key (LabelID) references pc_label (LabelID) on delete restrict on update restrict; delete from pc_label_post; alter table pc_label_post add constraint FK_Reference_31 foreign key (LabelID) references pc_label (LabelID) on delete restrict on update restrict; -- 2024-5-11招聘会新增字段 ALTER TABLE `pc_jobfairs` ADD COLUMN `CompanyCount` int NULL COMMENT '企业数量' AFTER `ModifyTime`, ADD COLUMN `Longitude` varchar(50) NULL COMMENT '经度' AFTER `CompanyCount`, ADD COLUMN `Latitude` varchar(50) NULL COMMENT '纬度' AFTER `Longitude`; ALTER TABLE `pc_jobfairs` ADD COLUMN `BoothCount` int NULL COMMENT '摊位数' AFTER `Latitude`; ALTER TABLE `pc_jobfairs` ADD COLUMN `RegionCode` varchar(50) NULL COMMENT '所属县区' AFTER `BoothCount`; ALTER TABLE `pc_jobfairs` ADD COLUMN `JobFariDesc` varchar(255) NULL COMMENT '招聘会描述' AFTER `RegionCode`; --2024.05.11 站点人员新增启用禁用功能 INSERT INTO sys_function_code (`FunctionCode`, `FunctionName`, `ParentFunctionCode`, `OrderNo`) VALUES ('T01010307', '启用禁用', 'T010103', 7); --角色为市管理、区（县管理员）、驿站机构的所有人员，添加站点人员启用禁用权限 insert into sys_role_sys_function_code (`RoleID`, `FunctionCode`) values('1ca3a0c1-167b-4f5e-a31b-ce0c3eee4d80','T01010307'); insert into sys_role_sys_function_code (`RoleID`, `FunctionCode`) values('02184e9a-1ed8-461f-bfee-ae0c1df11e9e','T01010307'); insert into sys_role_sys_function_code (`RoleID`, `FunctionCode`) values('d6f0d433-7a58-497e-b203-d8309edebaba','T01010307'); -- 2024-5-11 招聘会菜单与权限编码添加 INSERT INTO `sys_menu` VALUES ('T0109', 6, '招聘会管理', 'NotificationOutlined', NULL, '/jobFairs', 'T01', NULL, 0, 1, 1, 'T0109', 1, NULL); INSERT INTO `sys_menu` VALUES ('T010901', 1, '招聘会信息', NULL, 'views/jobFairs/index', '/index', 'T0109', NULL, 0, 0, 1, 'T010901', 1, NULL); INSERT INTO `sys_menu` VALUES ('T010902', 2, '招聘会新增', NULL, 'views/jobFairs/add', '/add', 'T0109', NULL, 0, 0, 1, 'T010902', 1, NULL); INSERT INTO `sys_menu` VALUES ('T010903', 3, '招聘会修改', NULL, 'views/jobFairs/edit', '/edit', 'T0109', NULL, 0, 0, 1, 'T010903', 1, NULL); INSERT INTO `sys_menu` VALUES ('T010905', 4, '招聘会详情', NULL, 'views/jobFairs/detail', '/detail', 'T0109', NULL, 0, 0, 1, 'T010901', 1, NULL); INSERT INTO sys_function_code VALUES ('T0109', '招聘会管理', 'T01', 4); INSERT INTO sys_function_code VALUES ('T010901', '查看', 'T0109', 1); INSERT INTO sys_function_code VALUES ('T010902', '新增', 'T0109', 2); INSERT INTO sys_function_code VALUES ('T010903', '编辑', 'T0109', 3); INSERT INTO sys_function_code VALUES ('T010904', '删除', 'T0109', 4); -- 2024-5-13 角色添加招聘会权限 insert into sys_role_sys_function_code (`RoleID`, `FunctionCode`) values('02184e9a-1ed8-461f-bfee-ae0c1df11e9e','T0109'); insert into sys_role_sys_function_code (`RoleID`, `FunctionCode`) values('02184e9a-1ed8-461f-bfee-ae0c1df11e9e','T010901'); insert into sys_role_sys_function_code (`RoleID`, `FunctionCode`) values('02184e9a-1ed8-461f-bfee-ae0c1df11e9e','T010902'); insert into sys_role_sys_function_code (`RoleID`, `FunctionCode`) values('02184e9a-1ed8-461f-bfee-ae0c1df11e9e','T010903'); insert into sys_role_sys_function_code (`RoleID`, `FunctionCode`) values('02184e9a-1ed8-461f-bfee-ae0c1df11e9e','T010904'); insert into sys_role_sys_function_code (`RoleID`, `FunctionCode`) values('d6f0d433-7a58-497e-b203-d8309edebaba','T0109'); insert into sys_role_sys_function_code (`RoleID`, `FunctionCode`) values('d6f0d433-7a58-497e-b203-d8309edebaba','T010901'); insert into sys_role_sys_function_code (`RoleID`, `FunctionCode`) values('d6f0d433-7a58-497e-b203-d8309edebaba','T010902'); insert into sys_role_sys_function_code (`RoleID`, `FunctionCode`) values('d6f0d433-7a58-497e-b203-d8309edebaba','T010903'); insert into sys_role_sys_function_code (`RoleID`, `FunctionCode`) values('d6f0d433-7a58-497e-b203-d8309edebaba','T010904'); insert into sys_role_sys_function_code (`RoleID`, `FunctionCode`) values('10a12f77-0958-4220-b9ce-07b9215046f2','T0109'); insert into sys_role_sys_function_code (`RoleID`, `FunctionCode`) values('10a12f77-0958-4220-b9ce-07b9215046f2','T010901'); -- 2024-5-14 部分字段提高字符长度 ALTER TABLE `pc_firm` MODIFY COLUMN `DbrName` VARCHAR ( 255 ) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '法定代表人姓名' AFTER `OperatingStatus`; ALTER TABLE `pc_firm` MODIFY COLUMN `LatestAddress` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '最新年报地址' AFTER `SignAddress`; ALTER TABLE `pc_occupational` MODIFY COLUMN `OccupationalName` VARCHAR ( 150 ) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL AFTER `ParentOccupationalID`; ALTER TABLE `pc_post` MODIFY COLUMN `Welfare` VARCHAR ( 255 ) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL AFTER `MinSalary`; --2024-5-20 字典数据名称修改 UPDATE `sys_dictionary_item` SET `Name` = '其他失业人员' WHERE DictionaryItemID = '6f90f708-0201-11ef-902c-7085c2a9999e'; --2024-5-20 -- 企业岗位对应工作年限 update sys_dictionary_item set `Code` = '0' where DictionaryCode='WorkYearType' and `Name`='无工作经验'; update sys_dictionary_item set `Code` = '0' where DictionaryCode='WorkYearType' and `Name`='在读生/应届毕业生'; update sys_dictionary_item set `Code` = '1' where DictionaryCode='WorkYearType' and `Name`='1年以上'; update sys_dictionary_item set `Code` = '2' where DictionaryCode='WorkYearType' and `Name`='2年以上'; update sys_dictionary_item set `Code` = '3' where DictionaryCode='WorkYearType' and `Name`='3年以上'; update sys_dictionary_item set `Code` = '5' where DictionaryCode='WorkYearType' and `Name`='5年以上'; update sys_dictionary_item set `Code` = '8' where DictionaryCode='WorkYearType' and `Name`='8年以上'; update sys_dictionary_item set `Code` = '10' where DictionaryCode='WorkYearType' and `Name`='10年以上'; update sys_dictionary_item set `Code` = '20' where DictionaryCode='WorkYearType' and `Name`='20年以上'; -- 2024-5-23 添加系统使用情况统计菜单与权限编码 INSERT INTO sys_function_code VALUES ('T010502', '系统使用情况统计', 'T0105', 2); INSERT INTO `sys_menu` VALUES ('T010502', 2, '系统使用情况统计', NULL, 'views/statistics/SystemApplyCount', '/systemApplyCount', 'T0105', NULL, 0, 1, 1, 'T010502', 1, NULL); -- 2024-5-23 为系统管理员和市级管理员添加统使用情况统计权限 insert into sys_role_sys_function_code (`RoleID`, `FunctionCode`) values('20afde90-a81a-11ed-a6c5-7085c2a9999e','T0105'); insert into sys_role_sys_function_code (`RoleID`, `FunctionCode`) values('20afde90-a81a-11ed-a6c5-7085c2a9999e','T010502'); insert into sys_role_sys_function_code (`RoleID`, `FunctionCode`) values('d6f0d433-7a58-497e-b203-d8309edebaba','T0105'); insert into sys_role_sys_function_code (`RoleID`, `FunctionCode`) values('d6f0d433-7a58-497e-b203-d8309edebaba','T010502'); -- 2024-5-24 添加企业数据可视化地图菜单与权限编码 INSERT INTO sys_function_code VALUES ('T010203', '企业数据地图', 'T0102', 3); INSERT INTO `sys_menu` VALUES ('T010203', 3, '企业可视化地图', NULL, 'companyService/dataMap/index', '/companyDataMap', 'T0102', NULL, 0, 1, 1, 'T010502', 1, NULL); -- 2024-5-24 为系统管理员和市级管理员添加企业数据可视化地图权限 insert into sys_role_sys_function_code (`RoleID`, `FunctionCode`) values('20afde90-a81a-11ed-a6c5-7085c2a9999e','T010203'); insert into sys_role_sys_function_code (`RoleID`, `FunctionCode`) values('d6f0d433-7a58-497e-b203-d8309edebaba','T010203'); --2024.05.27 为驿站工作者添加岗位禁用启用权限 insert into sys_function_code VALUES ('T01030208', '启用禁用', 'T010302', 8); insert into sys_role_sys_function_code values('10a12f77-0958-4220-b9ce-07b9215046f2','T01030208'); -- 2024-5-28 修改企业数据可视化地图菜单与权限数据 INSERT INTO sys_function_code VALUES ('T0110', '数据可视化地图', 'T01', 7); INSERT INTO sys_function_code VALUES ('T011001', '企业数据可视化地图', 'T0110', 1); DELETE FROM sys_function_code WHERE FunctionCode = 'T010203'; INSERT INTO `sys_menu` VALUES ('T0110', 9, '数据可视化地图', 'GlobalOutlined', NULL, '/dataMap', 'T01', NULL, 0, 1, 0, 'T0110', 1, NULL); INSERT INTO `sys_menu` VALUES ('T011001', 1, '企业数据可视化地图', NULL, 'views/dataMap/companyDataMap', '/companyDataMap', 'T0110', NULL, 0, 1, 1, 'T011001', 1, NULL); DELETE FROM sys_menu WHERE MenuNo = 'T010203'; insert into sys_role_sys_function_code (`RoleID`, `FunctionCode`) values('20afde90-a81a-11ed-a6c5-7085c2a9999e','T0110'); insert into sys_role_sys_function_code (`RoleID`, `FunctionCode`) values('20afde90-a81a-11ed-a6c5-7085c2a9999e','T011001'); DELETE FROM sys_role_sys_function_code WHERE FunctionCode = 'T010203' -- 2024-5-28 添加驿站站点数据可视化地图菜单与权限数据 INSERT INTO sys_function_code VALUES ('T011002', '驿站站点数据可视化地图', 'T0110', 2); INSERT INTO `sys_menu` VALUES ('T011002', 2, '驿站站点数据可视化地图', NULL, 'views/dataMap/siteDataMap', '/siteDataMap', 'T0110', NULL, 0, 1, 1, 'T011002', 1, NULL); insert into sys_role_sys_function_code (`RoleID`, `FunctionCode`) values('20afde90-a81a-11ed-a6c5-7085c2a9999e','T011002'); -- 2024-5-29 求职人员数据可视化地图菜单与权限 INSERT INTO sys_function_code VALUES ('T011003', '求职人员数据可视化地图', 'T0110', 3); INSERT INTO `sys_menu` VALUES ('T011003', 3, '求职人员数据可视化地图', NULL, 'views/dataMap/jobUserDataMap', '/jobUserDataMap', 'T0110', NULL, 0, 1, 1, 'T011003', 1, NULL); insert into sys_role_sys_function_code (`RoleID`, `FunctionCode`) values('20afde90-a81a-11ed-a6c5-7085c2a9999e','T011003'); -- 2024.5.31 alter table sys_menu add IsBlank tinyint(1); update sys_menu set IsBlank=1 where MenuNo='T011001'; update sys_menu set IsBlank=1 where MenuNo='T011002'; update sys_menu set IsBlank=1 where MenuNo='T011003'; -- 2024.6.3 alter table pc_recommend_mgt add remark varchar(500);