招聘 的职位分类表

DROP TABLE IF EXISTS `job_category`;
CREATE TABLE `job_category`  (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `cate_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '分类名称',
  `cate_icon` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '分类图标',
  `cate_rank` tinyint(4) UNSIGNED NULL DEFAULT 0 COMMENT '分类权重',
  `cate_level` tinyint(1) NULL DEFAULT 1 COMMENT '分类级别',
  `job_category_id` int(11) NULL DEFAULT 0 COMMENT '上级分类',
  `cate_status` tinyint(1) NULL DEFAULT 1 COMMENT '分类状态:0=禁用,1=正常 ',
  `cate_time` int(11) NULL DEFAULT 0 COMMENT '添加时间',
  `is_delete` tinyint(2) NULL DEFAULT 0 COMMENT '是否删除:0=否,1=是',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 127 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '职位分类表' ROW_FORMAT = Dynamic;

链接: https://download.csdn.net/download/xu1fan/75794872https://download.csdn.net/download/xu1fan/75794872