
-- ----------------------------
-- Table structure for xy_job_fair_content
-- ----------------------------
DROP TABLE IF EXISTS `xy_job_fair_content`;
CREATE TABLE `xy_job_fair_content`  (
  `id` int(0) UNSIGNED NOT NULL AUTO_INCREMENT,
  `jid` int(0) NULL DEFAULT NULL,
  `job_fair_area1` int(0) NULL DEFAULT NULL,
  `job_fair_area2` int(0) NULL DEFAULT NULL,
  `job_fair_area3` int(0) NULL DEFAULT NULL,
  `address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `lng` decimal(12, 8) NULL DEFAULT NULL,
  `lat` decimal(12, 8) NULL DEFAULT NULL,
  `transit` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL,
  `about` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL,
  `update_time` int(0) NULL DEFAULT NULL,
  `create_time` int(0) NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `jid`(`jid`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = '招聘会-详情' ROW_FORMAT = Dynamic;
