CREATE TABLE `bonect`  (
  `UUID` char(32) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '唯一标识',
  `OriginName` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '光片名称',
  `Sex` bit(1) NULL DEFAULT NULL COMMENT '性别。0：男，1：女',
  `Seged` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否分割。0：未分割，1：已分割',
  `AiStatus` tinyint(4) NOT NULL DEFAULT 0 COMMENT 'AI分析结果。0：未分析，-1：无效光片，21：分析完成',
  `CreateTime` timestamp(0) NOT NULL DEFAULT current_timestamp(0) COMMENT '创建时间',
  `ReturnTime` timestamp(0)  NULL  COMMENT '结果返回时间',
  `Returned` bit(1) NOT NULL DEFAULT b'0' COMMENT '结果是否返回。0：未返回，1：已返回',
  `CompleteTime` timestamp(0)  NULL  COMMENT 'AI分析完成时间',
  `RGT1` varchar(4) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '-1',
  `RGT2` varchar(4) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '-1',
  `RGT3` varchar(4) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '-1',
  `RGPT1` float NOT NULL DEFAULT 0,
  `RGPT2` float NOT NULL DEFAULT 0,
  `RGPT3` float NOT NULL DEFAULT 0,
  `CGT1` varchar(4) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '-1',
  `CGT2` varchar(4) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '-1',
  `CGT3` varchar(4) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '-1',
  `CGPT1` float NOT NULL DEFAULT 0,
  `CGPT2` float NOT NULL DEFAULT 0,
  `CGPT3` float NOT NULL DEFAULT 0,
  `ZGIT1` varchar(4) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '-1',
  `ZGIT2` varchar(4) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '-1',
  `ZGIT3` varchar(4) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '-1',
  `ZGIPT1` float NOT NULL DEFAULT 0,
  `ZGIPT2` float NOT NULL DEFAULT 0,
  `ZGIPT3` float NOT NULL DEFAULT 0,
  `ZGIIIT1` varchar(4) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '-1',
  `ZGIIIT2` varchar(4) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '-1',
  `ZGIIIT3` varchar(4) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '-1',
  `ZGIIIPT1` float NOT NULL DEFAULT 0,
  `ZGIIIPT2` float NOT NULL DEFAULT 0,
  `ZGIIIPT3` float NOT NULL DEFAULT 0,
  `ZGVT1` varchar(4) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '-1',
  `ZGVT2` varchar(4) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '-1',
  `ZGVT3` varchar(4) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '-1',
  `ZGVPT1` float NOT NULL DEFAULT 0,
  `ZGVPT2` float NOT NULL DEFAULT 0,
  `ZGVPT3` float NOT NULL DEFAULT 0,
  `JJIT1` varchar(4) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '-1',
  `JJIT2` varchar(4) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '-1',
  `JJIT3` varchar(4) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '-1',
  `JJIPT1` float NOT NULL DEFAULT 0,
  `JJIPT2` float NOT NULL DEFAULT 0,
  `JJIPT3` float NOT NULL DEFAULT 0,
  `JJIIIT1` varchar(4) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '-1',
  `JJIIIT2` varchar(4) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '-1',
  `JJIIIT3` varchar(4) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '-1',
  `JJIIIPT1` float NOT NULL DEFAULT 0,
  `JJIIIPT2` float NOT NULL DEFAULT 0,
  `JJIIIPT3` float NOT NULL DEFAULT 0,
  `JJVT1` varchar(4) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '-1',
  `JJVT2` varchar(4) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '-1',
  `JJVT3` varchar(4) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '-1',
  `JJVPT1` float NOT NULL DEFAULT 0,
  `JJVPT2` float NOT NULL DEFAULT 0,
  `JJVPT3` float NOT NULL DEFAULT 0,
  `ZJIIIT1` varchar(4) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '-1',
  `ZJIIIT2` varchar(4) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '-1',
  `ZJIIIT3` varchar(4) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '-1',
  `ZJIIIPT1` float NOT NULL DEFAULT 0,
  `ZJIIIPT2` float NOT NULL DEFAULT 0,
  `ZJIIIPT3` float NOT NULL DEFAULT 0,
  `ZJIIIBY` float NOT NULL DEFAULT 0,
  `ZJVT1` varchar(4) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '-1',
  `ZJVT2` varchar(4) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '-1',
  `ZJVT3` varchar(4) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '-1',
  `ZJVPT1` float NOT NULL DEFAULT 0,
  `ZJVPT2` float NOT NULL DEFAULT 0,
  `ZJVPT3` float NOT NULL DEFAULT 0,
  `ZJVBY` float NOT NULL DEFAULT 0,
  `YJIT1` varchar(4) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '-1',
  `YJIT2` varchar(4) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '-1',
  `YJIT3` varchar(4) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '-1',
  `YJIPT1` float NOT NULL DEFAULT 0,
  `YJIPT2` float NOT NULL DEFAULT 0,
  `YJIPT3` float NOT NULL DEFAULT 0,
  `YJIBY` float NOT NULL DEFAULT 0,
  `YJIIIT1` varchar(4) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '-1',
  `YJIIIT2` varchar(4) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '-1',
  `YJIIIT3` varchar(4) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '-1',
  `YJIIIPT1` float NOT NULL DEFAULT 0,
  `YJIIIPT2` float NOT NULL DEFAULT 0,
  `YJIIIPT3` float NOT NULL DEFAULT 0,
  `YJIIIBY` float NOT NULL DEFAULT 0,
  `YJVT1` varchar(4) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '-1',
  `YJVT2` varchar(4) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '-1',
  `YJVT3` varchar(4) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '-1',
  `YJVPT1` float NOT NULL DEFAULT 0,
  `YJVPT2` float NOT NULL DEFAULT 0,
  `YJVPT3` float NOT NULL DEFAULT 0,
  `YJVBY` float NOT NULL DEFAULT 0,
  `TZGT1` varchar(4) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '-1',
  `TZGT2` varchar(4) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '-1',
  `TZGT3` varchar(4) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '-1',
  `TZGPT1` float NOT NULL DEFAULT 0,
  `TZGPT2` float NOT NULL DEFAULT 0,
  `TZGPT3` float NOT NULL DEFAULT 0,
  `GGT1` varchar(4) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '-1',
  `GGT2` varchar(4) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '-1',
  `GGT3` varchar(4) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '-1',
  `GGPT1` float NOT NULL DEFAULT 0,
  `GGPT2` float NOT NULL DEFAULT 0,
  `GGPT3` float NOT NULL DEFAULT 0,
  `SJGT1` varchar(4) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '-1',
  `SJGT2` varchar(4) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '-1',
  `SJGT3` varchar(4) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '-1',
  `SJGPT1` float NOT NULL DEFAULT 0,
  `SJGPT2` float NOT NULL DEFAULT 0,
  `SJGPT3` float NOT NULL DEFAULT 0,
  `YGT1` varchar(4) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '-1',
  `YGT2` varchar(4) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '-1',
  `YGT3` varchar(4) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '-1',
  `YGPT1` float NOT NULL DEFAULT 0,
  `YGPT2` float NOT NULL DEFAULT 0,
  `YGPT3` float NOT NULL DEFAULT 0,
  `ZGT1` varchar(4) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '-1',
  `ZGT2` varchar(4) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '-1',
  `ZGT3` varchar(4) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '-1',
  `ZGPT1` float NOT NULL DEFAULT 0,
  `ZGPT2` float NOT NULL DEFAULT 0,
  `ZGPT3` float NOT NULL DEFAULT 0,
  `DDJGT1` varchar(4) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '-1',
  `DDJGT2` varchar(4) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '-1',
  `DDJGT3` varchar(4) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '-1',
  `DDJGPT1` float NOT NULL DEFAULT 0,
  `DDJGPT2` float NOT NULL DEFAULT 0,
  `DDJGPT3` float NOT NULL DEFAULT 0,
  `XDJGT1` varchar(4) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '-1',
  `XDJGT2` varchar(4) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '-1',
  `XDJGT3` varchar(4) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '-1',
  `XDJGPT1` float NOT NULL DEFAULT 0,
  `XDJGPT2` float NOT NULL DEFAULT 0,
  `XDJGPT3` float NOT NULL DEFAULT 0,
  `ZIGT1` varchar(4) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '-1',
  `ZIGT2` varchar(4) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '-1',
  `ZIGT3` varchar(4) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '-1',
  `ZIGPT1` float NOT NULL DEFAULT 0,
  `ZIGPT2` float NOT NULL DEFAULT 0,
  `ZIGPT3` float NOT NULL DEFAULT 0,
  `gpBoneAge` float NOT NULL DEFAULT -1 COMMENT 'GP骨龄',
  `Message` tinyint(4) NOT NULL DEFAULT 0 COMMENT '失败原因',
  `Source` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '0' COMMENT '来源',
  PRIMARY KEY (`UUID`) USING BTREE
)  COMMENT = 'AI骨等级分析记录表' ;

CREATE TABLE `child_info`  (
  `id` varchar(36) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '孩子唯一标识',
  `hospital_id` bigint(20) NULL COMMENT '医院的唯一标识',
  `deparment_id` bigint(20) NULL COMMENT '医院科室的唯一标识',
  `doctor_id` bigint(20) NULL COMMENT '医生的唯一标识',
  `name` varchar(8) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '孩子姓名',
  `sex` tinyint(1) NOT NULL COMMENT '孩子性别，0表示男孩，1表示女孩',
  `birthday` date NOT NULL COMMENT '孩子出生日期',
  `identity_card_number` varchar(18) CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '孩子身份证号',
  `diagnose_count` int(6) NOT NULL COMMENT '孩子H端诊断次数(只加不减)',
  `address` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '家庭地址',
  `phone` varchar(11) CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '联系电话',
  `is_del` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否删除：0：正常 1：删除',
  `create_time` datetime NOT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '创建时间',
  `create_user_id` bigint(20) NULL COMMENT '创建账号的唯一标识',
  `create_user_name` varchar(50) NULL COMMENT '创建者名称',
  `update_time` datetime NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  `update_user_id` bigint(20) NULL COMMENT '更新数据的账号的唯一标识',
  `update_user_name` varchar(8) CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '更新数据的用户的姓名',
  PRIMARY KEY (`id`),
  UNIQUE INDEX `pk_id`(`id`) USING BTREE COMMENT '主键唯一索引'
) COMMENT = '孩子档案信息表';

CREATE TABLE `diagnose_record`  (
  `id` varchar(36) NOT NULL COMMENT '诊断记录唯一ID',
  `hospital_id` bigint(20) NULL COMMENT '医院唯一ID',
  `department_id` bigint(20) NULL COMMENT '科室唯一ID',
  `doctor_id` bigint(20) NULL COMMENT '医生唯一ID',
  `child_id` varchar(36) NULL COMMENT '儿童档案ID',
  `diagnose_time` date NULL COMMENT '诊断日期',
  `life_age` decimal(4, 2) NULL COMMENT '诊断时的生活年龄',
  `xray_name` varchar(255) NULL COMMENT '光片名称',
  `ai_id` varchar(36) NULL COMMENT 'AI业务处理ID',
  `evaluation_status` tinyint(2) NULL DEFAULT 0 COMMENT '评价状态（1：提交AI分析；2：AI分析失败；3：AI分析成功；4：提交高级分析；5：高级分析失败：6：高级分析成功；7：自主分析；8：报告采用）',
  `generate_report` tinyint(1) NULL DEFAULT 0 COMMENT '是否生成报告（0：未生成；1：已生成）',
  `is_del` bit(1) NOT NULL DEFAULT 0 COMMENT '是否删除（1：删除，0：未删除）',
  `enable` bit(1) NOT NULL DEFAULT 1 COMMENT '是否启用（0：停用；1：启用）',
  `create_user_id` bigint(20) NULL COMMENT '创建者ID',
  `create_user_name` varchar(50) NULL COMMENT '创建者账号',
  `create_time` datetime(0) NULL DEFAULT now() ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '创建时间',
  `update_user_id` bigint(20) NULL COMMENT '更新者ID',
  `update_user_name` varchar(50) NULL COMMENT '更新者账号',
  `update_time` datetime(0) NULL ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '更新时间',
  PRIMARY KEY (`id`)
) COMMENT = '诊断记录表';

CREATE TABLE `evaluation_detail`  (
  `id` bigint(20) NOT NULL COMMENT '骨龄评价序号',
  `record_id` bigint(20) NOT NULL COMMENT '评价记录ID',
  `diagnostic_id` varchar(36) NOT NULL COMMENT '诊断记录ID',
  `xray_name` varchar(255) NULL COMMENT '光片地址与名称',
  `evaluation_type` tinyint(1) NULL DEFAULT 1 COMMENT '评价方式（1：AI；2：自读；3：高级）',
  `rus_evaluation_method` tinyint(1) NULL COMMENT '评价方法（1：RUS_CHN；2：TW3-C RUS；3：TW3 RUS；4：G-P）',
  `rus_bone_age` decimal(4, 2) NULL DEFAULT 0 COMMENT 'RUS骨龄',
  `rus_bone_age_twelve` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '12进制骨龄',
  `rg_level` varchar(5) NULL COMMENT '桡骨等级',
  `rg_credible` bit(1) NULL DEFAULT 1 COMMENT '桡骨等级是否可信（1：可信；0：不可信）',
  `cg_level` varchar(5) NULL COMMENT '尺骨等级',
  `cg_credible` bit(1) NULL DEFAULT 1 COMMENT '尺骨等级是否可信（1：可信；0：不可信）',
  `zgi_level` varchar(5) NULL COMMENT '掌骨I等级',
  `zgi_credible` bit(1) NULL DEFAULT 1 COMMENT '掌骨I等级是否可信（1：可信；0：不可信）',
  `zgiii_level` varchar(5) NULL COMMENT '掌骨III等级',
  `zgiii_credible` bit(1) NULL DEFAULT 1 COMMENT '掌骨III等级是否可信（1：可信；0：不可信）',
  `zgv_level` varchar(5) NULL COMMENT '掌骨V等级',
  `zgv_credible` bit(1) NULL DEFAULT 1 COMMENT '掌骨V等级是否可信（1：可信；0：不可信）',
  `jji_level` varchar(5) NULL COMMENT '近节指骨I等级',
  `jji_credible` bit(1) NULL DEFAULT 1 COMMENT '近节指骨I等级是否可信（1：可信；0：不可信）',
  `jjiii_level` varchar(5) NULL COMMENT '近节指骨III等级',
  `jjiii_credible` bit(1) NULL DEFAULT 1 COMMENT '近节指骨III等级是否可信（1：可信；0：不可信）',
  `jjv_level` varchar(5) NULL COMMENT '近节指骨V等级',
  `jjv_credible` bit(1) NULL DEFAULT 1 COMMENT '近节指骨V等级是否可信（1：可信；0：不可信）',
  `zjiii_level` varchar(5) NULL COMMENT '中节指骨III等级',
  `zjiii_credible` bit(1) NULL DEFAULT 1 COMMENT '中节指骨III等级是否可信（1：可信；0：不可信）',
  `zjiii_mutation_rate` float NULL COMMENT '中节指骨III变异概率',
  `zjv_level` varchar(5) NULL COMMENT '中节指骨V等级',
  `zjv_credible` bit(1) NULL DEFAULT 1 COMMENT '中节指骨V等级是否可信（1：可信；0：不可信）',
  `zjv_mutation_rate` float NULL COMMENT '中节指骨V变异概率',
  `yji_level` varchar(5) NULL COMMENT '远节指骨I等级',
  `yji_credible` bit(1) NULL DEFAULT 1 COMMENT '远节指骨I等级是否可信（1：可信；0：不可信）',
  `yji_mutation_rate` float NULL COMMENT '远节指骨I变异概率',
  `yjiii_level` varchar(5) NULL COMMENT '远节指骨III等级',
  `yjiii_credible` bit(1) NULL DEFAULT 1 COMMENT '远节指骨III等级是否可信（1：可信；0：不可信）',
  `yjiii_mutation_rate` float NULL COMMENT '远节指骨III变异概率',
  `yjv_level` varchar(5) NULL COMMENT '远节指骨V等级',
  `yjv_credible` bit(1) NULL DEFAULT 1 COMMENT '远节指骨V等级是否可信（1：可信；0：不可信）',
  `yjv_mutation_rate` float NULL COMMENT '远节指骨V变异概率',
  `carpal_evaluation_method` tinyint(1) NULL COMMENT 'Carpal骨龄评价方法（1：TW3-C Carpal；2：TW3 Carpal）',
  `carpal_bone_age` decimal(4, 2) NULL DEFAULT 0 COMMENT '腕骨骨龄',
  `tzg_level` varchar(5) NULL COMMENT '头状骨等级',
  `tzg_credible` bit(1) NULL DEFAULT 1 COMMENT '头状骨等级可信度（1：可信；0：不可信）',
  `gg_level` varchar(5) NULL COMMENT '钩骨等级',
  `gg_credible` bit(1) NULL DEFAULT 1 COMMENT '钩骨等级可信度（1：可信；0：不可信）',
  `sjg_level` varchar(5) NULL COMMENT '三角骨等级',
  `sjg_credible` bit(1) NULL DEFAULT 1 COMMENT '三角骨等级可信度（1：可信；0：不可信）',
  `yg_level` varchar(5) NULL COMMENT '月骨等级',
  `yg_credible` bit(1) NULL DEFAULT 1 COMMENT '月骨等级可信度（1：可信；0：不可信）',
  `zg_level` varchar(5) NULL COMMENT '舟骨等级',
  `zg_credible` bit(1) NULL DEFAULT 1 COMMENT '舟骨等级可信度（1：可信；0：不可信）',
  `ddjg_level` varchar(5) NULL COMMENT '大多角骨等级',
  `ddjg_credible` bit(1) NULL DEFAULT 1 COMMENT '大多角骨等级可信度（1：可信；0：不可信）',
  `xdjg_level` varchar(5) NULL COMMENT '小多角骨等级',
  `xdjg_credible` bit(1) NULL DEFAULT 1 COMMENT '小多角骨骨等级可信度（1：可信；0：不可信）',
  `zig_level` varchar(5) NULL COMMENT '籽骨等级',
  `image_finding` varchar(1000) NULL COMMENT '影像表现',
  `image_impression` varchar(1000) NULL COMMENT '影像印象',
  `is_del` bit(1) NOT NULL DEFAULT 0 COMMENT '是否删除（0：未删除；1：已删除）',
  `enable` bit(1) NOT NULL DEFAULT 1 COMMENT '是否启用（0：停用；1：启用）',
  `create_user_id` bigint(20) NOT NULL COMMENT '创建者ID',
  `create_user_name` varchar(50) NOT NULL COMMENT '创建者账号',
  `create_time` datetime NOT NULL DEFAULT now() ON UPDATE CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_user_id` bigint(20) NULL COMMENT '更新者ID',
  `update_user_name` varchar(50) NULL COMMENT '更新者账号',
  `update_time` datetime NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`),
  INDEX(`record_id`, `diagnostic_id`)
) COMMENT = '骨龄评价记录明细表';

CREATE TABLE `evaluation_record`  (
  `id` bigint(20) NOT NULL COMMENT '骨龄评价序号',
  `hospital_id` bigint(20) NULL COMMENT '医院ID',
  `department_id` bigint(20) NULL COMMENT '科室ID',
  `doctor_id` bigint(20) NULL COMMENT '医生ID',
  `child_id` varchar(36) NOT NULL COMMENT '儿童档案ID',
  `diagnostic_id` varchar(36) NOT NULL COMMENT '诊断记录ID',
  `xray_name` varchar(255) NULL COMMENT '光片地址与名称',
  `xray_upload_type` tinyint(1) NULL DEFAULT 1 COMMENT 'X光片上传方式（1：web端；2：移动端；3：Pacs）',
  `evaluation_status` tinyint(2) NULL DEFAULT 0 COMMENT '评价状态（1：提交AI分析；2：AI分析失败；3：AI分析成功；4：提交高级分析；5：高级分析失败：6：高级分析成功；7：自主分析；8：报告采用）',
  `operation_time` datetime NULL COMMENT '高级读片时间',
  `operation_user_name` varchar(50) NULL COMMENT '高级读片员姓名',
  `is_del` bit(1) NOT NULL DEFAULT 0 COMMENT '是否删除（0：未删除；1：已删除）',
  `enable` bit(1) NOT NULL DEFAULT 1 COMMENT '是否启用（0：停用；1：启用）',
  `create_user_id` bigint(20) NULL COMMENT '创建者ID',
  `create_user_name` varchar(50) NULL COMMENT '创建者账号',
  `create_time` datetime(0) NULL DEFAULT now() ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '创建时间',
  `update_user_id` bigint(20) NULL COMMENT '更新者ID',
  `update_user_name` varchar(50) NULL COMMENT '更新者账号',
  `update_time` datetime(0) NULL ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '更新时间',
  PRIMARY KEY (`id`)
) COMMENT = '骨龄评价记录表';

CREATE TABLE `partner_info`  (
  `id` bigint(20) NOT NULL COMMENT 'ID',
  `partner_name` varchar(50) NULL COMMENT '合作商名称',
  `partner_type` tinyint(1) NULL COMMENT '合作商类型（1：区域经销商；2：设备供应商；3：系统集成商；4：行业代理商；5：个人）',
  `partner_address` varchar(100) NULL COMMENT '合作商地址',
  `partner_province` varchar(50) NULL COMMENT '合作商所在省',
  `partner_city` varchar(50) NULL COMMENT '合作商所在市',
  `partner_area` varchar(50) NULL COMMENT '合作商所在区县',
  `partner_link_man` varchar(50) NULL COMMENT '合作商联系人',
  `partner_link_telephone` varchar(50) NULL COMMENT '合作商联系电话',
  `partner_bussiness_area` varchar(300) NULL COMMENT '合作商合作区域',
  `partner_introduce` varchar(1000) NULL COMMENT '合作商简介',
  `partner_unique_code` varchar(100) NULL COMMENT '合作商唯一标识码',
  `is_del` bit(1) NULL DEFAULT b'0' COMMENT '是否删除，1删除，0未删除',
  `enabled` bit(1) NULL DEFAULT b'1' COMMENT '状态，1启用，0停用 ',
  `create_user_id` bigint(20) NOT NULL COMMENT '创建人ID',
  `create_user_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '创建人账号',
  `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
  `update_user_id` bigint(20) NULL DEFAULT NULL COMMENT '更新人ID',
  `update_user_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '更新人账号',
  `update_time` datetime(0) NULL DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`)
) COMMENT = '合作商信息表';

CREATE TABLE `order_detail`  (
  `id` bigint(20) NOT NULL COMMENT '订单明细ID',
  `order_id` bigint(20) NOT NULL COMMENT '订单id',
  `product_id` bigint(20) NOT NULL COMMENT '产品ID',
  `product_type` tinyint(1) NOT NULL COMMENT '产品类型（0：试用；1：正式）',
  `product_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '产品名称',
  `reading_count` int(6) NOT NULL DEFAULT 0 COMMENT '读片量',
  `report_count` int(6) NOT NULL COMMENT '报告量',
  `product_begintime` datetime(0) NULL DEFAULT NULL COMMENT '有效的开始时间',
  `product_endtime` datetime(0) NULL DEFAULT NULL COMMENT '有效的结束时间',
  `is_share` bit(1) NOT NULL COMMENT '是否共享 0否 1是',
  `used_reading_count` int(6) NOT NULL DEFAULT 0 COMMENT '已用读片量',
  `used_report_count` int(6) NULL DEFAULT 0 COMMENT '已生成报告量',
  `validate_key` varchar(500) NULL COMMENT '服务验证串',
  `is_del` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否删除，1删除，0未删除',
  `enabled` bit(1) NULL DEFAULT b'1' COMMENT '状态，1启用，0停用',
  `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
  `create_user_id` bigint(20) NOT NULL COMMENT '创建人ID',
  `create_user_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '创建人账号',
  `update_time` datetime(0) NULL DEFAULT NULL COMMENT '更新时间',
  `update_user_id` bigint(20) NULL DEFAULT NULL COMMENT '更新人ID',
  `update_user_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '更新人账号',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `idx_sumption_other`(`product_id`, `order_id`) USING BTREE
)  COMMENT = '订单（充值）明细表' ;

CREATE TABLE `doctor_daily_statistics`  (
  `id` bigint(20) NOT NULL COMMENT 'ID',
  `hospital_id` bigint(20) NOT NULL COMMENT '医院ID',
  `department_id` bigint(20) NOT NULL COMMENT '科室ID',
  `doctor_id` bigint(20) NOT NULL COMMENT '医生ID',
  `item_code` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '统计项目编码（1201：报告数量；1301：读片数量）',
  `item_name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '统计项目名称',
  `collect_date` date NOT NULL COMMENT '统计日期',
  `item_value` bigint(20) NULL DEFAULT NULL COMMENT '统计项目数值',
  `is_del` bit(1) NULL DEFAULT b'0' COMMENT '是否删除（0：未删除；1：已删除）',
  `enable` bit(1) NULL DEFAULT b'1' COMMENT '是否启用（0：未启用；1：已启用）',
  `create_user_id` bigint(20) NULL DEFAULT NULL COMMENT '创建者ID',
  `create_user_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '创建者账号',
  `create_time` datetime(0) NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '创建时间',
  `update_user_id` bigint(20) NULL DEFAULT NULL COMMENT '更新者ID',
  `update_user_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '更新者账号',
  `update_time` datetime(0) NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '更新时间',
  PRIMARY KEY (`id`)
) COMMENT = '医生日服务统计表';

CREATE TABLE `order_record`  (
  `id` bigint(20) NOT NULL COMMENT '订单记录ID',
  `hospital_id` bigint(20) NOT NULL COMMENT '医院标识id',
  `hospital_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '医院名称',
  `department_id` bigint(20) NOT NULL COMMENT '科室ID',
  `department_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '科室名称',
  `contract_no` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '订单编号',
  `contract_title` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '订单名称',
  `contract_begin_time` datetime(0) NULL DEFAULT NULL COMMENT '订单开始日期',
  `contract_end_time` datetime(0) NULL DEFAULT NULL COMMENT '订单结束日期',
  `contract_time` datetime(0) NULL DEFAULT NULL COMMENT '订单签订时间',
  `is_del` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否删除，1删除，0未删除',
  `enabled` bit(1) NULL DEFAULT b'1' COMMENT '状态，1启用，0停用',
  `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
  `create_user_id` bigint(20) NOT NULL COMMENT '创建人ID',
  `create_user_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '创建人账号',
  `update_time` datetime(0) NULL DEFAULT NULL COMMENT '更新时间',
  `update_user_id` bigint(20) NULL DEFAULT NULL COMMENT '更新人ID',
  `update_user_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '更新人账号',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `idx_sumption_other`(`hospital_id`, `department_id`) USING BTREE
)  COMMENT = '订单(充值)记录' ;

CREATE TABLE `report_content`  (
  `id` bigint(20) NOT NULL COMMENT '唯一ID',
  `hospital_id` bigint(20) NULL COMMENT '医院ID',
  `hospital_name` varchar(50) NULL COMMENT '医院名称',
  `department_id` bigint(20) NULL COMMENT '科室ID',
  `department_name` varchar(50) NULL COMMENT '科室名称',
  `doctor_id` bigint(20) NULL COMMENT '医生ID',
  `doctor_name` varchar(20) NULL COMMENT '医生姓名',
  `child_id` varchar(36) NULL COMMENT '儿童档案ID',
  `child_name` varchar(20) NULL COMMENT '儿童姓名',
  `child_sex` tinyint(1) NULL COMMENT '儿童性别（0：男；1：女）',
  `child_birthday` date NULL COMMENT '儿童出生日期',
  `image_name` varchar(255) NULL COMMENT '光片名称',
  `diagnose_id` varchar(32) NULL COMMENT '诊断记录ID',
  `report_type` tinyint(1) NULL COMMENT '1：影像检验报告\r\n2：生长发育报告',
  `report_name` varchar(20) NULL COMMENT '报告名称',
  `clinic_number` varchar(20) NULL COMMENT '门诊号',
  `bed_number` varchar(20) NULL COMMENT '床号',
  `study_number` varchar(20) NULL COMMENT '检查单号',
  `study_date` date NULL COMMENT '检查日期',
  `life_age` decimal(4, 2) NULL COMMENT '儿童生活年龄',
  `body_part_examined` varchar(50) NULL COMMENT '检查部位',
  `rus_evaluation_method` varchar(20) NULL COMMENT '掌指骨评价方法',
  `rus_bone_age` decimal(4, 2) NULL COMMENT '掌指骨骨龄',
  `rus_bone_age_twelve` varchar(50) NULL COMMENT '十二进制掌指骨骨龄',
  `rus_bone_age_percentile` varchar(8) NULL COMMENT '掌指骨骨龄百分位',
  `rus_bone_age_score` decimal(4, 0) NULL COMMENT '掌指骨骨龄成熟度得分',
  `rg_level` varchar(5) NULL COMMENT '桡骨等级',
  `cg_level` varchar(5) NULL COMMENT '尺骨等级',
  `zgi_level` varchar(5) NULL COMMENT '掌骨I等级',
  `zgiii_level` varchar(5) NULL COMMENT '掌骨III等级',
  `zgv_level` varchar(5) NULL COMMENT '掌骨V等级',
  `jji_level` varchar(5) NULL COMMENT '近节指骨I等级',
  `jjiii_level` varchar(5) NULL COMMENT '近节指骨III等级',
  `jjv_level` varchar(5) NULL COMMENT '近节指骨V等级',
  `zjiii_level` varchar(5) NULL COMMENT '中节指骨III等级',
  `zjv_level` varchar(5) NULL COMMENT '中节指骨V等级',
  `yji_level` varchar(5) NULL COMMENT '远节指骨I等级',
  `yjiii_level` varchar(5) NULL COMMENT '远节指骨III等级',
  `yjv_level` varchar(5) NULL COMMENT '远节指骨V等级',
  `carpal_evaluation_method` varchar(20) NULL COMMENT '腕骨评价方法',
  `carpal_bone_age` decimal(4, 2) NULL COMMENT '腕骨骨龄',
  `carpal_bone_age_percentile` varchar(8) NULL COMMENT '腕骨骨龄百分位',
  `carpal_bone_age_score` decimal(4, 0) NULL COMMENT '腕骨骨龄成熟度得分',
  `rus_age_resuce_capal_age_sds` varchar(8) NULL COMMENT '掌指骨骨龄减腕骨骨龄SDS',
  `tzg_level` varchar(5) NULL COMMENT '头状骨等级',
  `gg_level` varchar(5) NULL COMMENT '钩骨等级',
  `sjg_level` varchar(5) NULL COMMENT '三角骨等级',
  `yg_level` varchar(5) NULL COMMENT '月骨等级',
  `zg_level` varchar(5) NULL COMMENT '舟骨等级',
  `ddjg_level` varchar(5) NULL COMMENT '大多角骨等级',
  `xdjg_level` varchar(5) NULL COMMENT '小多角骨等级',
  `image_finding` varchar(1000) NULL COMMENT '影像表现',
  `image_impression` varchar(1000) NULL COMMENT '影像印象',
  `is_del` bit(1) NOT NULL DEFAULT 0 COMMENT '是否删除（0：未删除；1：已删除）',
  `enable` bit(1) NOT NULL DEFAULT 1 COMMENT '是否启用（0：停用；1：启用）',
  `create_user_id` bigint(20) NULL COMMENT '创建者ID',
  `create_user_name` varchar(50) NULL COMMENT '创建者账号',
  `create_time` datetime(0) NULL DEFAULT now() ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '创建时间',
  `update_user_id` bigint(20) NULL COMMENT '更新者ID',
  `update_user_name` varchar(50) NULL COMMENT '更新者账号',
  `update_time` datetime(0) NULL ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '更新时间',
  PRIMARY KEY (`id`)
) COMMENT = '报告内容表';

CREATE TABLE `server_info`  (
  `id` bigint(20) NOT NULL COMMENT 'ID',
  `partner_id` bigint(20) NULL COMMENT '合作商ID',
  `hospital_id` bigint(20) NULL COMMENT '医院ID',
  `department_id` bigint(20) NULL COMMENT '科室ID',
  `operation_system` varchar(50) NULL COMMENT '操作系统类型及版本',
  `main_board_uuid` varchar(100) NULL COMMENT '主板UUID',
  `cpu_id` varchar(100) NULL COMMENT 'CPU ID',
  `bios_serial_number` varchar(100) NULL COMMENT 'BIOS序列号',
  `machine_guid` varchar(100) NULL COMMENT '主机GUID',
  `network_card_mac` varchar(100) NULL COMMENT '网卡MAC地址',
  `hard_disk_sn` varchar(100) NULL COMMENT '硬盘序列号',
  `application_system_unique_code` varchar(500) NULL COMMENT '应用系统唯一标识符',
  `is_del` bit(1) NULL DEFAULT b'0' COMMENT '是否删除，1删除，0未删除',
  `enabled` bit(1) NULL DEFAULT b'1' COMMENT '状态，1启用，0停用 ',
  `create_user_id` bigint(20) NOT NULL COMMENT '创建人ID',
  `create_user_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '创建人账号',
  `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
  `update_user_id` bigint(20) NULL DEFAULT NULL COMMENT '更新人ID',
  `update_user_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '更新人账号',
  `update_time` datetime(0) NULL DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`)
) COMMENT = '服务器相关信息';

CREATE TABLE `sys_department`  (
  `id` bigint(20) NOT NULL COMMENT '科室/部门id',
  `department_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '科室/部门名称 同组织名称',
  `hospital_id` bigint(20) NOT NULL COMMENT '医院Id',
  `is_del` bit(1) NULL DEFAULT b'0' COMMENT '是否删除，1删除，0未删除',
  `enabled` bit(1) NULL DEFAULT b'1' COMMENT '状态，1启用，0停用',
  `create_user_id` bigint(20) NULL DEFAULT NULL COMMENT '创建人ID',
  `create_user_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '创建人账号',
  `update_user_id` bigint(20) NULL DEFAULT NULL COMMENT '更新人ID',
  `update_user_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '更新人账号',
  `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime(0) NULL DEFAULT NULL COMMENT '更新时间',
  `accounts_count` smallint(2) NOT NULL COMMENT '帐号数量 默认6',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `idx_dep_other`(`department_name`) USING BTREE
) COMMENT = '科室表' ;

CREATE TABLE `sys_doctor`  (
  `id` bigint(20) NOT NULL COMMENT '医生ID',
  `hospital_id` bigint(20) NOT NULL COMMENT '所属医院ID',
  `hospital_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '医院名称',
  `department_id` bigint(20) NOT NULL COMMENT '科室ID',
  `department_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '科室名称',
  `doctor_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '医生姓名',
  `doctor_logo` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '医生的头像',
  `doctor_ccie` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '医生资质证书',
  `doctor_tel` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '医生联系方式',
  `doctor_password` varchar(50) NULL COMMENT '登录密码',
  `doctor_rank_id` bigint(20) NULL DEFAULT NULL COMMENT '职称ID',
  `doctor_rank` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '职称',
  `doctor_other_link` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '医生其它联系方式',
  `doctor_email` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '医生的email',
  `doctor_about` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '医生简介',
  `is_del` bit(1) NULL DEFAULT b'0' COMMENT '是否删除，1删除，0未删除',
  `doctor_state` bit(1) NOT NULL DEFAULT b'0' COMMENT '医生状态 1正常 0试用',
  `doctor_type` tinyint(1) NOT NULL DEFAULT 2 COMMENT '医生类型 0H+C端都可用   1H端   2C端 默认2',
  `enabled` bit(1) NULL DEFAULT b'1' COMMENT '启用禁用状态，1启用，0停用 ',
  `create_user_id` bigint(20) UNSIGNED ZEROFILL NOT NULL COMMENT '创建人ID',
  `create_user_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '创建人账号',
  `update_user_id` bigint(20) NULL DEFAULT NULL COMMENT '更新人ID',
  `update_user_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '更新人账号',
  `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime(0) NULL DEFAULT NULL COMMENT '更新时间',
  `is_admin_user` bit(1) NULL DEFAULT b'0' COMMENT '是否管理帐号 0否1是',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `idx_doctor_other`(`hospital_id`, `doctor_name`, `doctor_tel`) USING BTREE
) COMMENT = '医生信息表' ;

CREATE TABLE `sys_hospital`  (
  `id` bigint(20) NOT NULL COMMENT '医院ID',
  `hospital_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '医院名称',
  `hospital_short_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '医院简称',
  `hospital_code` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '医院编码',
  `hospital_type_id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '医院类型ID  从字典表关联 社区/儿保等等之类',
  `hospital_type_name` varchar(25) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '医院类型 社区/儿保等等之类',
  `hospital_tel` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '医院电话',
  `hospital_province` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '省名称',
  `hospital_city` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '城市名称',
  `hospital_area` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '医院所在地区名称',
  `area_code` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '区号',
  `hospital_link` varchar(25) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '医院联系人',
  `hospital_adress` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '医院地址',
  `latitude` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '所在位置纬度',
  `longitude` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '所在位置经度',
  `hospital_qualified_id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '资质ID',
  `hospital_qualified_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '资质（三甲医院）',
  `hospital_lit_logo` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '医院logo  缩略图',
  `hospital_logo` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '医院logo 原图',
  `hospital_adimage` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '医院简介图片',
  `hospital_about` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '医院简介',
  `hospital_state` tinyint(1) UNSIGNED ZEROFILL NOT NULL DEFAULT 0 COMMENT '服务状态 0试用 1正式',
  `enabled` bit(1) NULL DEFAULT b'1' COMMENT '状态，1启用，0停用 ',
  `is_del` bit(1) NULL DEFAULT b'0' COMMENT '是否删除，1删除，0未删除',
  `create_user_id` bigint(20) NOT NULL COMMENT '创建人ID',
  `create_user_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '创建人账号',
  `update_user_id` bigint(20) NULL DEFAULT NULL COMMENT '更新人ID',
  `update_user_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '更新人账号',
  `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime(0) NULL DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`)
)  COMMENT = '医院基础信息表' ;

