i2-bill-api/model/i2bill_part_time_user.sql

--兼职人员表--
DROP TABLE IF EXISTS `i2bill_mkt_part_time_user`;
CREATE TABLE `i2bill_mkt_part_time_user`  (
  `id` int(0) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `ipone_number` varchar(11) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `sex` int(0) NULL DEFAULT NULL,
  `target` int(0) NULL DEFAULT NULL COMMENT '目标人数',
  `user_id` int(0) NULL DEFAULT NULL COMMENT 'user_id',
  `mk_id` varchar(36)  NULL DEFAULT NULL COMMENT '所属erp mk id',
  `city_id` int(0) NULL DEFAULT NULL  COMMENT '城市',
  `check_state` int(0) NULL DEFAULT NULL COMMENT '审核状态',
  `check_desc` varchar(300) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '审核失败描述',
  `create_by` varchar(36) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `create_time` datetime(0) NULL DEFAULT NULL,
  `last_update_by` varchar(36) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `last_update_time` datetime(0) NULL DEFAULT NULL,
  `del_flag` int(0) NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `IDX_mkt_part_time_user_ipone_number`(`ipone_number`) USING BTREE,
  INDEX `IDX_mkt_part_time_user_name`(`name`) USING BTREE,
  INDEX `IDX_mkt_part_time_user_sex`(`sex`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;