i2-bill-erp/model/mkt_part_time_user.sql

CREATE TABLE `mkt_part_time_user` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `ipone_number` varchar(11) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `sex` int DEFAULT NULL,
  `create_by` varchar(36) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `create_time` datetime DEFAULT NULL,
  `last_update_by` varchar(36) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `last_update_time` datetime DEFAULT NULL,
  `del_flag` tinyint DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_mkt_part_time_user_ipone_number` (`ipone_number`),
  KEY `IDX_mkt_part_time_user_name` (`name`),
  KEY `IDX_mkt_part_time_user_sex` (`sex`)
) ENGINE=InnoDB AUTO_INCREMENT=4358 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;