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 = '医院基础信息表' ;
|
