/*
Navicat MySQL Data Transfer
Date: 2015-06-01 23:55:05
*/
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for job_position
-- ----------------------------
DROP TABLE IF EXISTS `job_position`;
CREATE TABLE `job_position` (
`id` smallint(11) unsigned NOT NULL AUTO_INCREMENT,
`position_no` smallint(9) unsigned DEFAULT NULL,
`position_name` varchar(30) DEFAULT NULL,
`parent_no` smallint(11) unsigned DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=800 DEFAULT CHARSET=utf8 COMMENT='职位分类表';
-- ----------------------------
-- Records of job_position
-- ----------------------------
INSERT INTO `job_position` VALUES ('1', '1001', '客服/售前/售后技术', '0');
INSERT INTO `job_position` VALUES ('2', '1002', '客户服务总监', '1001');
INSERT INTO `job_position` VALUES ('3', '1003', '客户服务经理', '1001');
INSERT INTO `job_position` VALUES ('4', '1004', '客户服务主管', '1001');
INSERT INTO `job_position` VALUES ('5', '1005', '客户服务专员/助理', '1001');
INSERT INTO `job_position` VALUES ('6', '1006', '客户关系/投诉协调人员', '1001');
INSERT INTO `job_position` VALUES ('7', '1007', '客户咨询热线/呼叫中心人员', '1001');
INSERT INTO `job_position` VALUES ('8', '1008', '网络/在线客服', '1001');
INSERT INTO `job_position` VALUES ('9', '1009', '售前/售后技术支持管理', '1001');
INSERT INTO `job_position` VALUES ('10', '1010', '售前/售后技术支持工程师', '1001');
INSERT INTO `job_position` VALUES ('11', '1011', '其他', '1001');
INSERT INTO `job_position` VALUES ('12', '1012', '市场', '0');
INSERT INTO `job_position` VALUES ('13', '1013', '市场总监', '1012');
INSERT INTO `job_position` VALUES ('14', '1014', '市场经理', '1012');
INSERT INTO `job_position` VALUES ('15', '1015', '市场主管', '1012');
INSERT INTO `job_position` VALUES ('16', '1016', '市场专员/助理', '1012');
INSERT INTO `job_position` VALUES ('17', '1017', '市场营销经理', '1012');
INSERT INTO `job_position` VALUES ('18', '1018', '市场营销主管', '1012');
INSERT INTO `job_position` VALUES ('19', '1019', '市场营销专员/助理', '1012');
INSERT INTO `job_position` VALUES ('20', '1020', '业务拓展经理/主管', '1012');
INSERT INTO `job_position` VALUES ('21', '1021', '业务拓展专员/助理', '1012');
INSERT INTO `job_position` VALUES ('22', '1022', '产品经理', '1012');
INSERT INTO `job_position` VALUES ('23', '1023', '产品主管', '1012');
INSERT INTO `job_position` VALUES ('24', '1024', '产品专员/助理', '1012');
INSERT INTO `job_position` VALUES ('25', '1025', '品牌经理', '1012');
INSERT INTO `job_position` VALUES ('26', '1026', '品牌主管', '1012');
INSERT INTO `job_position` VALUES ('27', '1027', '品牌专员/助理', '1012');
INSERT INTO `job_position` VALUES ('28', '1028', '市场策划/企划经理/主管', '1012');
INSERT INTO `job_position` VALUES ('29', '1029', '市场策划/企划专员/助理', '1012');
INSERT INTO `job_position` VALUES ('30', '1030', '市场文案策划', '1012');
INSERT INTO `job_position` VALUES ('31', '1031', '活动策划', '1012');
INSERT INTO `job_position` VALUES ('32', '1032', '活动执行', '1012');
INSERT INTO `job_position` VALUES ('33', '1033', '促销主管/督导', '1012');
INSERT INTO `job_position` VALUES ('34', '1034', '促销员', '1012');
INSERT INTO `job_position` VALUES ('35', '1035', '网站推广', '1012');
INSERT INTO `job_position` VALUES ('36', '1036', 'SEO/SEM', '1012');
INSERT INTO `job_position` VALUES ('37', '1037', '学术推广', '1012');
INSERT INTO `job_position` VALUES ('38', '1038', '选址拓展/新店开发', '1012');
INSERT INTO `job_position` VALUES ('39', '1039', '市场调研与分析', '1012');
INSERT INTO `job_position` VALUES ('40', '1040', '其他', '1012');
INSERT INTO `job_position` VALUES ('41', '1041', '公关/媒介', '0');
INSERT INTO `job_position` VALUES ('42', '1042', '公关总监', '1041');
INSERT INTO `job_position` VALUES ('43', '1043', '公关经理/主管', '1041');
INSERT INTO `job_position` VALUES ('44', '1044', '公关专员/助理', '1041');
INSERT INTO `job_position` VALUES ('45', '1045', '媒介经理/主管', '1041');
INSERT INTO `job_position` VALUES ('46', '1046', '媒介专员/助理', '1041');
INSERT INTO `job_position` VALUES ('47', '1047', '媒介策划/管理', '1041');
INSERT INTO `job_position` VALUES ('48', '1048', '政府事务管理', '1041');
INSERT INTO `job_position` VALUES ('49', '1049', '其他', '1041');
INSERT INTO `job_position` VALUES ('50', '1050', '广告/会展', '0');
INSERT INTO `job_position` VALUES ('51', '1051', '广告创意/设计总监', '1050');
INSERT INTO `job_position` VALUES ('52', '1052', '广告创意/设计经理/主管', '1050');
INSERT INTO `job_position` VALUES ('53', '1053', '广告创意/设计师', '1050');
INSERT INTO `job_position` VALUES ('54', '1054', '广告文案策划', '1050');
INSERT INTO `job_position` VALUES ('55', '1055', '广告美术指导', '1050');
INSERT INTO `job_position` VALUES ('56', '1056', '广告制作执行', '1050');
INSERT INTO `job_position` VALUES ('57', '1057', '广告客户总监', '1050');
INSERT INTO `job_position` VALUES ('58', '1058', '广告客户经理', '1050');
INSERT INTO `job_position` VALUES ('59', '1059', '广告客户主管', '1050');
INSERT INTO `job_position` VALUES ('60', '1060', '广告客户代表', '1050');
INSERT INTO `job_position` VALUES ('61', '1061', '广告/会展业务拓展', '1050');
INSERT INTO `job_position` VALUES ('62', '1062', '会展策划/设计', '1050');
INSERT INTO `job_position` VALUES ('63', '1063', '会务经理/主管', '1050');
INSERT INTO `job_position` VALUES ('64', '1064', '会务专员/助理', '1050');
INSERT INTO `job_position` VALUES ('65', '1065', '广告/会展项目管理', '1050');
INSERT INTO `job_position` VALUES ('66', '1066', '其他', '1050');
INSERT INTO `job_position` VALUES ('67', '1067', '财务/审计/税务', '0');
INSERT INTO `job_position` VALUES ('68', '1068', '首席财务官CFO', '1067');
INSERT INTO `job_position` VALUES ('69', '1069', '财务总监', '1067');
INSERT INTO `job_position` VALUES ('70', '1070', '财务经理', '1067');
INSERT INTO `job_position` VALUES ('71', '1071', '财务主管/总账主管', '1067');
INSERT INTO `job_position` VALUES ('72', '1072', '财务顾问', '1067');
INSERT INTO `job_position` VALUES ('73', '1073', '财务助理', '1067');
INSERT INTO `job_position` VALUES ('74', '1074', '财务分析经理/主管', '1067');
INSERT INTO `job_position` VALUES ('75', '1075', '财务分析员', '1067');
INSERT INTO `job_position` VALUES ('76', '1076', '会计经理/主管', '1067');
INSERT INTO `job_position` VALUES ('77', '1077', '会计/会计师', '1067');
INSERT INTO `job_position` VALUES ('78', '1078', '会计助理/文员', '1067');
INSERT INTO `job_position` VALUES ('79', '1079', '出纳员', '1067');
INSERT INTO `job_position` VALUES ('80', '1080', '审计经理/主管', '1067');
INSERT INTO `job_position` VALUES ('81', '1081', '审计专员/助理', '1067');
INSERT INTO `job_position` VALUES ('82', '1082', '税务经理/主管', '1067');
INSERT INTO `job_position` VALUES ('83', '1083', '税务专员/助理', '1067');
INSERT INTO `job_position` VALUES ('84', '1084', '成本经理/主管', '1067');
INSERT INTO `job_position` VALUES ('85', '1085', '成本会计', '1067');
INSERT INTO `job_position` VALUES ('86', '1086', '资产/资金管理', '1067');
INSERT INTO `job_position` VALUES ('87', '1087', '资金专员', '1067');
INSERT INTO `job_position` VALUES ('88', '1088', '统计员', '1067');
INSERT INTO `job_position` VALUES ('89', '1089', '其他', '1067');
INSERT INTO `job_position` VALUES ('90', '1090', '人力资源', '0');
INSERT INTO `job_position` VALUES ('91', '1091', '人力资源总监', '1090');
INSERT I
