
-- ----------------------------
-- Table structure for xy_jobs
-- ----------------------------
DROP TABLE IF EXISTS `xy_jobs`;
CREATE TABLE `xy_jobs`  (
  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `app_id` int(10) NULL DEFAULT NULL,
  `company_id` int(10) NULL DEFAULT NULL,
  `jobs_cate1` int(10) NULL DEFAULT NULL,
  `jobs_cate2` int(10) NULL DEFAULT NULL,
  `jobs_cate3` int(10) NULL DEFAULT NULL,
  `title` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `status` tinyint(1) NULL DEFAULT 1,
  `examine` tinyint(1) NULL DEFAULT 0,
  `jobs_type` tinyint(1) NULL DEFAULT 1,
  `jobs_area1` int(10) NULL DEFAULT NULL,
  `jobs_area2` int(10) NULL DEFAULT NULL,
  `jobs_area3` int(10) NULL DEFAULT NULL,
  `salary_min` int(10) NULL DEFAULT 0,
  `salary_max` int(10) NULL DEFAULT 0,
  `salary_year` int(10) NULL DEFAULT 12,
  `education_level` int(5) NULL DEFAULT 0,
  `exp_level` int(5) NULL DEFAULT 0,
  `number_of_recruiters` int(5) NULL DEFAULT NULL,
  `jobs_welfare` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `recommend` tinyint(1) NULL DEFAULT 0,
  `recommend_time` int(11) NULL DEFAULT NULL,
  `top` tinyint(1) NULL DEFAULT 0,
  `top_time` int(11) NULL DEFAULT NULL,
  `urgent` tinyint(1) NULL DEFAULT 0,
  `urgent_time` int(11) NULL DEFAULT NULL,
  `view` int(6) NULL DEFAULT 0,
  `delivery_resume` int(6) NULL DEFAULT 0,
  `delete_time` int(10) NULL DEFAULT NULL,
  `refresh_time` int(10) NULL DEFAULT NULL,
  `update_time` int(10) NULL DEFAULT NULL,
  `create_time` int(10) NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '职位表' ROW_FORMAT = Dynamic;
