EmploymentSite/doc/已更新脚本

-------------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);

-- 2024-6-11 修改求职人员表，补全未填写的所属区县与所属街道
UPDATE pc_jobuser ju JOIN pc_site s ON ju.SiteID = s.SiteID SET ju.RegionCode = s.RegionCode
WHERE ju.RegionCode IS NULL OR ju.RegionCode = '';
UPDATE pc_jobuser ju JOIN pc_site s ON ju.SiteID = s.SiteID SET ju.StreetCode = s.StreetCode
WHERE ju.StreetCode IS NULL OR ju.StreetCode = '';

-- 2024-06-12
INSERT INTO  area_code   VALUES ('441399990000000', '市本级', '441300000000000', '广东省惠州市本级技术开发区', '3');
update sys_menu set menuname ='就业服务活动管理' where menuno='T0109';
update sys_menu set menuname ='就业服务活动信息' where menuno='T010901';
update sys_menu set menuname ='就业服务活动新增' where menuno='T010902';
update sys_menu set menuname ='就业服务活动修改' where menuno='T010903';
update sys_menu set menuname ='就业服务活动详情' where menuno='T010905';

-- 2024-06-13
ALTER TABLE pc_jobuser ADD COLUMN FinishDate VARCHAR(20) COMMENT '毕业日期' AFTER FinishSchool;

-- 2024-6-17 系统月度使用情况统计菜单与权限数据
INSERT INTO sys_function_code VALUES ('T010503', '系统月度使用情况统计', 'T0105', 3);
INSERT INTO `sys_menu` VALUES ('T010503', 3, '系统月度使用情况统计', NULL, 'views/statistics/MonthSystemApplyCount', '/MonthSystemApplyCount', 'T0105', NULL, 0, 1, 1, 'T010503', 1, NULL,NULL);
insert into sys_role_sys_function_code (`RoleID`, `FunctionCode`) values('20afde90-a81a-11ed-a6c5-7085c2a9999e','T010503');

-- 2024-6-17 求职人员统计菜单与权限数据
insert into sys_function_code values ('T010504', '求职人员统计', 'T0105', 4);
insert into`sys_menu` values ('T010504', 4, '求职人员统计', NULL, 'views/statistics/JobUserCount', '/JobUserCount', 'T0105', NULL, 0, 1, 1, 'T010504', 1, NULL,NULL);
insert into sys_role_sys_function_code (`RoleID`, `FunctionCode`) values('20afde90-a81a-11ed-a6c5-7085c2a9999e','T010504');

-- 2024-6-18 求职人员服务记录表
CREATE TABLE pc_jobuser_service (
  `ServiceID` varchar(50) NOT NULL,
  `JobUserID` varchar(50) NULL,
  `ServiceContent` varchar(255) NULL,
  `ServiceTime` datetime NULL,
  `ServiceUserID` varchar(50) NULL,
  `CreateUserID` varchar(50) NULL,
  `CreateTime` datetime NULL,
  `ModifyUserID` varchar(50) NULL,
  `ModifyTime` datetime NULL,
  PRIMARY KEY (`ServiceID`)
);

-- 2024.06.18 企业表新增注册资本类型字段，字典表新增注册资本类型字典
insert into sys_dictionary values ('RegisteredCapitalType','注册资本类型','10','1');
insert into sys_dictionary_item  values
(uuid(), '', 'RegisteredCapitalType', 1, '万元(人民币)', 10, 1, 0),
(uuid(), '', 'RegisteredCapitalType', 2, '万元(港币)', 20, 1, 0),
(uuid(), '', 'RegisteredCapitalType', 3, '万元(美元)', 30, 1, 0),
(uuid(), '', 'RegisteredCapitalType', 4, '万元(欧元)', 40, 1, 0),
(uuid(), '', 'RegisteredCapitalType', 5, '万元(日元)', 50, 1, 0),
(uuid(), '', 'RegisteredCapitalType', 6, '万元(其他)', 60, 1, 0);

alter table pc_company add column RegisteredCapitalType int  comment '注册资本类型' after RegisteredCapital;
update pc_company set RegisteredCapitalType =1

-- 2024-6-19 求职人员服务跟进权限字典码与权限赋值
insert into sys_function_code values ('T01030108', '服务跟进', 'T010301', 8);
insert into sys_role_sys_function_code (`RoleID`, `FunctionCode`) values('20afde90-a81a-11ed-a6c5-7085c2a9999e','T01030108');
insert into sys_role_sys_function_code (`RoleID`, `FunctionCode`) values('10a12f77-0958-4220-b9ce-07b9215046f2','T01030108');

-- 2024-6-24 系统年度使用情况统计菜单与权限
INSERT INTO sys_function_code VALUES ('T010505', '系统年度使用情况统计', 'T0105', 5);
INSERT INTO `sys_menu` VALUES ('T010505', 5, '系统年度使用情况统计', NULL, 'views/statistics/YearSystemApplyCount', '/yearSystemApplyCount', 'T0105', NULL, 0, 1, 1, 'T010505', 1, NULL,NULL);
insert into sys_role_sys_function_code (`RoleID`, `FunctionCode`) values('20afde90-a81a-11ed-a6c5-7085c2a9999e','T010505');
-- 2024-6-25 日志表增加字段
ALTER TABLE `sys_log` ADD COLUMN `IPAddress` varchar(255) NULL COMMENT 'IP地址' AFTER `UserID`;
ALTER TABLE `sys_log` ADD COLUMN `OperationData` text NULL COMMENT '操作数据' AFTER `IPAddress`;
-- 2024-6-25 求职人员新增是否扫码录入字段
alter table pc_jobuser add column IsAppInsert int comment '是否扫码录入' after openId;

-- 2024-7-8 就业活动类型字典
INSERT INTO `sys_dictionary` VALUES ('JobFairActivityType', '就业活动类型', 109, 1);
INSERT INTO `sys_dictionary_item` VALUES ('1ecc5294-51f6-4a10-add2-e63f7ac78001', '', 'JobFairActivityType', 1, '招聘活动', 1, 1, 1);
INSERT INTO `sys_dictionary_item` VALUES ('1ecc5294-51f6-4a10-add2-e63f7ac78002', '', 'JobFairActivityType', 2, '职业指导活动', 2, 1, 1);
INSERT INTO `sys_dictionary_item` VALUES ('1ecc5294-51f6-4a10-add2-e63f7ac78003', '', 'JobFairActivityType', 3, '政策宣传活动', 3, 1, 1);
INSERT INTO `sys_dictionary_item` VALUES ('1ecc5294-51f6-4a10-add2-e63f7ac78004', '', 'JobFairActivityType', 4, '对接活动', 4, 1, 1);
INSERT INTO `sys_dictionary_item` VALUES ('1ecc5294-51f6-4a10-add2-e63f7ac78005', '', 'JobFairActivityType', 5, '求职者对接活动', 5, 1, 1);
INSERT INTO `sys_dictionary_item` VALUES ('1ecc5294-51f6-4a10-add2-e63f7ac78006', '', 'JobFairActivityType', 6, '其他活动', 6, 1, 1);

-- 2024-7-8 就业活动增加字段
ALTER TABLE `pc_jobfairs` ADD COLUMN `ActivityType` int NULL COMMENT '招聘活动类型' AFTER `JobFariDesc`;
ALTER TABLE `pc_jobfairs` ADD COLUMN `SiteID` varchar(50) NULL COMMENT '所属驿站' AFTER `RegionCode`;

-- 2024-7-9 求职人员认领按钮权限
INSERT INTO sys_function_code VALUES ('T01030109', '求职人员认领', 'T010301', 9);
insert into sys_role_sys_function_code (`RoleID`, `FunctionCode`) values('10a12f77-0958-4220-b9ce-07b9215046f2','T01030109');

-- 2024-7-10 求职人员个人荣誉表
CREATE TABLE `pc_honor`  (
  `HonorID` varchar(50) NOT NULL,
  `JobUserID` varchar(50) NULL,
  `HonorName` varchar(255) NULL,
  `GetTime` datetime NULL,
  `CreateUserID` varchar(50) NULL,
  `CreateTime` datetime NULL,
  `ModifyUserID` varchar(50) NULL,
  `ModifyTime` datetime NULL,
  PRIMARY KEY (`HonorID`)
);

-- 2024-7-16 企业信用记录表
CREATE TABLE `pc_credit_record`  (
  `CreditRecordID` varchar(50) NOT NULL,
  `CompanyID` varchar(50) NULL COMMENT '企业ID',
  `CreditRecordContent` text NULL COMMENT '信用记录内容',
  `EnterTime` datetime NULL COMMENT '录入时间',
  `DocumentNumber` varchar(50) NULL COMMENT '决定文书号',
  `IncludeTime` datetime NULL COMMENT '列入时间',
  `ExpirationTime` datetime NULL COMMENT '到期时间',
  `DecidingDepartment` varchar(100) NULL COMMENT '作出列入决定部门',
  `Source` varchar(100) NULL COMMENT '来源',
  `IsEffective` int NULL COMMENT '是否有效：0是1否',
  `DepartmentTypeID` int NULL COMMENT '部门类别',
  `CreateUserID` varchar(50) NULL,
  `CreateTime` datetime NULL,
  `ModifyUserID` varchar(50) NULL,
  `ModifyTime` datetime NULL,
  PRIMARY KEY (`CreditRecordID`)
);

-- 2024-7-16 企业信用记录来源部门字典
INSERT INTO `sys_dictionary` VALUES ('CreditRecordDepartment', '企业信用记录来源部门类型', 109, 1);
INSERT INTO `sys_dictionary_item` VALUES ('1ecc5294-51f6-1111-4455-e63f7ac78001', '', 'CreditRecordDepartment', 1, '人社', 1, 1, 1);
INSERT INTO `sys_dictionary_item` VALUES ('1ecc5294-51f6-1111-4455-e63f7ac78002', '', 'CreditRecordDepartment', 2, '环保', 2, 1, 1);
INSERT INTO `sys_dictionary_item` VALUES ('1ecc5294-51f6-1111-4455-e63f7ac78003', '', 'CreditRecordDepartment', 3, '工商', 3, 1, 1);
INSERT INTO `sys_dictionary_item` VALUES ('1ecc5294-51f6-1111-4455-e63f7ac78004', '', 'CreditRecordDepartment', 4, '安全', 4, 1, 1);
INSERT INTO `sys_dictionary_item` VALUES ('1ecc5294-51f6-1111-4455-e63f7ac78005', '', 'CreditRecordDepartment', 5, '其他', 5, 1, 1);

-- 2024-7-24 数据大屏路由与权限
INSERT INTO sys_function_code VALUES ('T011004', '数据大屏', 'T0110', 4);
INSERT INTO `sys_menu` VALUES ('T011004', 4, '数据大屏', NULL, 'views/dataMap/dataScreenIndex', '/dataScreenIndex', 'T0110', NULL, 0, 1, 1, 'T011004', 1, NULL, 1);
insert into sys_role_sys_function_code (`RoleID`, `FunctionCode`) values('20afde90-a81a-11ed-a6c5-7085c2a9999e','T011004');


-- 2024-8-1 数据大屏菜单调整
INSERT INTO sys_function_code VALUES ('T0111', '数据可视化大屏', 'T01', 11);
INSERT INTO sys_function_code VALUES ('T011101', '总体概括', 'T0111', 1);
INSERT INTO sys_function_code VALUES ('T011102', '企业情况', 'T0111', 2);
INSERT INTO sys_function_code VALUES ('T011103', '求职情况', 'T0111', 3);
INSERT INTO sys_function_code VALUES ('T011104', '服务情况', 'T0111', 4);
INSERT INTO `sys_menu` VALUES ('T0111', 11, '数据可视化大屏', 'FundFilled', NULL, '/dataScreen', 'T01', NULL, 0, 1, 0, 'T0111', 1, NULL, NULL);
INSERT INTO `sys_menu` VALUES ('T011101', 1, '总体概括', NULL, 'views/dataScreen/html/index', '/dataScreen/dataScreenIndex', 'T0111', NULL, 0, 1, 1, 'T011101', 1, NULL, 1);
INSERT INTO `sys_menu` VALUES ('T011102', 2, '企业情况', NULL, 'views/dataScreen/html/company', '/dataScreen/dataScreenCompany', 'T0111', NULL, 0, 1, 1, 'T011102', 1, NULL, 1);
INSERT INTO `sys_menu` VALUES ('T011103', 3, '求职情况', NULL, 'views/dataScreen/html/jobUser', '/dataScreen/dataScreenJobUser', 'T0111', NULL, 0, 1, 1, 'T011103', 1, NULL, 1);
INSERT INTO `sys_menu` VALUES ('T011104', 4, '服务情况', NULL, 'views/dataScreen/html/sysService', '/dataScreen/dataScreenSysService', 'T0111', NULL, 0, 1, 1, 'T011104', 1, NULL, 1);
insert into sys_role_sys_function_code (`RoleID`, `FunctionCode`) values('20afde90-a81a-11ed-a6c5-7085c2a9999e','T0111');
insert into sys_role_sys_function_code (`RoleID`, `FunctionCode`) values('20afde90-a81a-11ed-a6c5-7085c2a9999e','T011101');
insert into sys_role_sys_function_code (`RoleID`, `FunctionCode`) values('20afde90-a81a-11ed-a6c5-7085c2a9999e','T011102');
insert into sys_role_sys_function_code (`RoleID`, `FunctionCode`) values('20afde90-a81a-11ed-a6c5-7085c2a9999e','T011103');
insert into sys_role_sys_function_code (`RoleID`, `FunctionCode`) values('20afde90-a81a-11ed-a6c5-7085c2a9999e','T011104');
# 修改地图菜单
UPDATE sys_menu SET MenuName = '就业驿站数据地图' WHERE MenuNo = 'T0110';
UPDATE sys_function_code SET FunctionName = '就业驿站数据地图' WHERE FunctionCode = 'T0110';
# 删除数据大屏原菜单
DELETE FROM sys_menu WHERE MenuNo = 'T011004';
DELETE FROM sys_function_code WHERE FunctionCode = 'T011004';
DELETE FROM sys_role_sys_function_code WHERE FunctionCode = 'T011004';

-- 2024.8.6
create table pc_signin
(
   SigninId             varchar(50) not null comment '唯一标识',
   SiteID               varchar(50) comment '所属驿站',
   SigninType           int comment '打卡类型，字典：SigninType',
   CompanyID            varchar(50) comment '走访企业',
   JobuserID            varchar(50) comment '走访人员',
   SigninTime           datetime comment '打卡时间',
   Content              text comment '服务内容',
   Longitude            varchar(50) comment '经度',
   Latitude             varchar(50) comment '纬度',
   RecordStatus         int comment '状态',
   CreateUserID         varchar(50) comment '创建人',
   CreateTime           datetime comment '创建时间',
   ModifyUserID         varchar(50) comment '修改人',
   ModifyTime           datetime comment '修改时间',
   primary key (SigninId)
);

alter table pc_signin add constraint FK_Pc_Signin_Ref_Company foreign key (CompanyID)
      references pc_company (CompanyID) on delete restrict on update restrict;

alter table pc_signin add constraint FK_Pc_Signin_Ref_JobUser foreign key (JobuserID)
      references pc_jobuser (JobuserID) on delete restrict on update restrict;

alter table pc_signin add constraint FK_Pc_Signin_Ref_Site foreign key (SiteID)
      references pc_site (SiteID) on delete restrict on update restrict;


 INSERT INTO `sys_dictionary` (`DictionaryCode`, `Name`, `OrderNo`, `RecordStatus`) VALUES
 ('SigninType', '打卡类型', 200, 1);
 INSERT INTO `sys_dictionary_item` (`DictionaryItemID`, `Code`, `DictionaryCode`, `Value`, `Name`, `OrderNo`, `RecordStatus`, `IsEditable`) VALUES
 ('ac93ede5-538d-11ef-8d63-7085c2a9999e', '', 'SigninType', 1, '走访企业', 1, 1, 0),
 ('b100cbf2-538d-11ef-8d63-7085c2a9999e', '', 'SigninType', 2, '走访人员', 2, 1, 0),
 ('b4ec8c51-538d-11ef-8d63-7085c2a9999e', '', 'SigninType', 3, '其他外联事项', 3, 1, 0);

 -- 2024-08-06 驿站工作人员外出地图菜单
 INSERT INTO sys_function_code VALUES ('T011004', '驿站工作人员外出地图', 'T0110', 4);
 INSERT INTO `sys_menu` VALUES ('T011004', 4, '驿站工作人员外出地图', NULL, 'views/dataMap/siteUserWorkDataMap', '/siteUserWorkDataMap', 'T0110', NULL, 0, 1, 1, 'T011004', 1, NULL, 1);
 insert into sys_role_sys_function_code (`RoleID`, `FunctionCode`) values('20afde90-a81a-11ed-a6c5-7085c2a9999e','T011004');



INSERT INTO  `sys_function_code` (`FunctionCode`, `FunctionName`, `ParentFunctionCode`, `OrderNo`) VALUES ('T010305', '外出服务管理', 'T0103', 5); INSERT INTO  `sys_function_code` (`FunctionCode`, `FunctionName`, `ParentFunctionCode`, `OrderNo`) VALUES ('T01030501', '查看', 'T010305', 1);
INSERT INTO  `sys_function_code` (`FunctionCode`, `FunctionName`, `ParentFunctionCode`, `OrderNo`) VALUES ('T01030502', '编辑', 'T010305', 2);
INSERT INTO  `sys_function_code` (`FunctionCode`, `FunctionName`, `ParentFunctionCode`, `OrderNo`) VALUES ('T01030503', '删除', 'T010305', 3);
INSERT INTO  `sys_function_code` (`FunctionCode`, `FunctionName`, `ParentFunctionCode`, `OrderNo`) VALUES ('T01030504', '跟进', 'T010305', 4);


INSERT INTO  `sys_menu` (`MenuNo`, `OrderNo`, `MenuName`, `Icon`, `ViewPath`, `Url`, `ParentMenuNo`, `Description`, `IsTopMenu`, `IsVisible`, `IsLeaf`, `FunctionCode`, `RecordStatus`, `ShortcutIcon`, `IsBlank`) VALUES ('T010305', 5, '外出服务管理', NULL, '', '/signinMgt', 'T0103', '外出服务管理', 0, 1, 1, 'T010305', 1, NULL, NULL);
INSERT INTO  `sys_menu` (`MenuNo`, `OrderNo`, `MenuName`, `Icon`, `ViewPath`, `Url`, `ParentMenuNo`, `Description`, `IsTopMenu`, `IsVisible`, `IsLeaf`, `FunctionCode`, `RecordStatus`, `ShortcutIcon`, `IsBlank`) VALUES ('T01030501', 1, '外出服务信息', NULL, 'views/jobusermgr/signinMgt/index', '/index', 'T010305', '', 0, 0, 1, 'T010305', 1, NULL, NULL);
INSERT INTO  `sys_menu` (`MenuNo`, `OrderNo`, `MenuName`, `Icon`, `ViewPath`, `Url`, `ParentMenuNo`, `Description`, `IsTopMenu`, `IsVisible`, `IsLeaf`, `FunctionCode`, `RecordStatus`, `ShortcutIcon`, `IsBlank`) VALUES ('T01030502', 2, '编辑外出服务', NULL, 'views/jobusermgr/signinMgt/edit', '/edit', 'T010305', '', 0, 0, 1, 'T010305', 1, NULL, NULL);
insert into sys_role_sys_function_code (`RoleID`, `FunctionCode`) values('20afde90-a81a-11ed-a6c5-7085c2a9999e','T010305');

--求职意向表其他信息字段长度扩展
alter table pc_jobhunt modify  OtherDemand varchar(5000)

-- 2024.8.8
update sys_menu set MenuName ='工作备忘' where menuno='T010402' or menuno='T01040201';
update sys_menu set MenuName ='新增工作备忘' where menuno='T01040202';
update sys_menu set MenuName ='编辑工作备忘' where menuno='T01040202';
update sys_menu set MenuName ='工作备忘详情' where menuno='T01040203';

-- 2024-8-15 求职人员数据字典新增
INSERT INTO sys_dictionary_item value('36505ec8-966b-11ee-91fc-7085c2a99101', '', 'JobStatus', 5, '升学深造', 5, 1, 0);
INSERT INTO sys_dictionary_item value('36505ec8-966b-11ee-91fc-7085c2a99102', '', 'JobStatus', 6, '出国', 6, 1, 0);
INSERT INTO sys_dictionary_item value('36505ec8-966b-11ee-91fc-7085c2a99103', '', 'JobStatus', 7, '应征入伍', 7, 1, 0);
-- 求职人员表新增字段
ALTER TABLE `pc_jobuser` ADD COLUMN `EducationalSystem` INT NULL COMMENT '学制' AFTER `Latitude`,
ADD COLUMN `DifficultSituationID` INT NULL COMMENT '困难状况' AFTER `EducationalSystem`;
ALTER TABLE `pc_jobuser`
ADD COLUMN `OrdinaryPersonTypeID` int NULL COMMENT '人员类别' AFTER `DifficultSituationID`;
ALTER TABLE `pc_jobuser`
ADD COLUMN `EsHouseholdRegistration` varchar(255) NULL COMMENT '入学前户口所在地' AFTER `OrdinaryPersonTypeID`;
-- 求职人员困难状况数据字典
INSERT INTO sys_dictionary value('DifficultSituation', '求职人员困难状况', 201, 1);
INSERT INTO sys_dictionary_item value('36505ec8-966b-11ee-91fc-7085c2a10001', '', 'DifficultSituation', 0, '不属于困难情况', 1, 1, 0);
INSERT INTO sys_dictionary_item value('36505ec8-966b-11ee-91fc-7085c2a10002', '', 'DifficultSituation', 11, '零就业家庭', 2, 1, 0);
INSERT INTO sys_dictionary_item value('36505ec8-966b-11ee-91fc-7085c2a10003', '', 'DifficultSituation', 12, '低保家庭', 3, 1, 0);
INSERT INTO sys_dictionary_item value('36505ec8-966b-11ee-91fc-7085c2a10004', '', 'DifficultSituation', 20, '个人残疾', 4, 1, 0);
INSERT INTO sys_dictionary_item value('36505ec8-966b-11ee-91fc-7085c2a10005', '', 'DifficultSituation', 40, '农村贫困户', 5, 1, 0);
INSERT INTO sys_dictionary_item value('36505ec8-966b-11ee-91fc-7085c2a10006', '', 'DifficultSituation', 50, '优抚对象', 6, 1, 0);
INSERT INTO sys_dictionary_item value('36505ec8-966b-11ee-91fc-7085c2a10007', '', 'DifficultSituation', 60, '申请助学贷款', 7, 1, 0);
INSERT INTO sys_dictionary_item value('36505ec8-966b-11ee-91fc-7085c2a10008', '', 'DifficultSituation', 90, '其他困难状况', 8, 1, 0);
-- 修改重点人员类别中的普通类别到人员类别字典中
INSERT INTO sys_dictionary value('OrdinaryPersonType', '求职人员类别', 202, 1);
UPDATE sys_dictionary_item SET DictionaryCode = 'OrdinaryPersonType' WHERE DictionaryCode = 'KeyPersonType' AND `Value` IN (1, 2,3,4,5,6,7,8,9,10,11,12);
-- 重点人员类别与普通人员类别增加"其他"类型
INSERT INTO sys_dictionary_item value('36505ec8-966b-11ee-91fc-7085c3b10001', '', 'OrdinaryPersonType', 0, '其他', 1, 1, 0);
INSERT INTO sys_dictionary_item value('36505ec8-966b-11ee-91fc-7085c3b10002', '', 'KeyPersonType', 0, '其他', 1, 1, 0);
-- 修改求职人员的重点人员类别与普通人员类别内容
UPDATE pc_jobuser SET OrdinaryPersonTypeID = KeyPersonTypeID WHERE KeyPersonTypeID IN (1,2,3,4,5,6,7,8,9,10,11,12);
UPDATE pc_jobuser SET OrdinaryPersonTypeID = 0 WHERE KeyPersonTypeID IN (13,14,15,16,17,18,19,20,21,22,23,24);
UPDATE pc_jobuser SET KeyPersonTypeID = 0 WHERE KeyPersonTypeID IN (1,2,3,4,5,6,7,8,9,10,11,12);