DROP TABLE IF EXISTS `t_extract_by_hand`;
CREATE TABLE `t_extract_by_hand`  (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '序号',
  `sub_task_id` bigint NULL DEFAULT NULL COMMENT '子任务id',
  `page_no` bigint NULL DEFAULT NULL COMMENT '页码',
  `create_by` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '创建者',
  `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
  `update_by` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '更新者',
  `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '手动构建' ROW_FORMAT = Dynamic;

DROP TABLE IF EXISTS `t_extract_by_hand_detail`;
CREATE TABLE `t_extract_by_hand_detail`  (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '序号',
  `hand_id` bigint NULL DEFAULT NULL COMMENT '手动构建id',
  `entity_class_id` bigint NULL DEFAULT NULL COMMENT '实体类id',
  `entity` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '实体',
  `create_by` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '创建者',
  `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
  `update_by` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '更新者',
  `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '手动构建详情' ROW_FORMAT = Dynamic;