-- Create syntax for TABLE 'bbs' CREATE TABLE `bbs` ( `id` varchar(50) NOT NULL, `initiator` varchar(50) DEFAULT NULL COMMENT '发起人', `reply` varchar(50) DEFAULT NULL COMMENT '回复人', `remote_application_id` varchar(50) DEFAULT NULL COMMENT '申请单id', `content` varchar(3000) DEFAULT NULL COMMENT '内容', `attachment` varchar(255) DEFAULT NULL COMMENT '附件', `createdAt` datetime DEFAULT NULL COMMENT '创建时间', PRIMARY KEY (`id`), KEY `bbs_initiator` (`initiator`), KEY `bbs_reply` (`reply`), KEY `bbs_applicaition` (`remote_application_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- Create syntax for TABLE 'bodypart' CREATE TABLE `bodypart` ( `id` varchar(32) NOT NULL, `name` varchar(100) DEFAULT NULL COMMENT '检查部位名称', `exam_class_id` varchar(50) DEFAULT NULL COMMENT 'exam_class表id', PRIMARY KEY (`id`), KEY `bodypart-examclass` (`exam_class_id`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='检查部位'; -- Create syntax for TABLE 'constant' CREATE TABLE `constant` ( `id` varchar(32) NOT NULL, `constant_key` varchar(50) DEFAULT NULL COMMENT '常量名称', `constant_value` varchar(50) DEFAULT NULL COMMENT '中文翻译', `parent_id` varchar(20) DEFAULT NULL COMMENT '父集ID', `remark` text COMMENT '备注', `name` varchar(255) DEFAULT NULL COMMENT '常量名称', `sign` varchar(255) DEFAULT NULL COMMENT '标记', `ordernum` int(10) DEFAULT NULL COMMENT '排序', PRIMARY KEY (`id`), KEY `constant-parent` (`parent_id`) USING BTREE, KEY `constant_value` (`constant_value`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='网站常量'; -- Create syntax for TABLE 'department' CREATE TABLE `department` ( `id` varchar(32) NOT NULL, `department_name` varchar(100) DEFAULT NULL COMMENT '科室名称', `is_report` varchar(10) DEFAULT NULL COMMENT '是否能写报告', `institution_id` varchar(50) DEFAULT NULL COMMENT '所属医院', `parent_id` varchar(50) DEFAULT NULL COMMENT '上级ID', `order_num` int(11) DEFAULT NULL COMMENT '排序号', PRIMARY KEY (`id`), KEY `depart-report` (`is_report`) USING BTREE, KEY `depart-institution` (`institution_id`), KEY `depart-parent` (`parent_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='科室'; -- Create syntax for TABLE 'device' CREATE TABLE `device` ( `id` varchar(32) NOT NULL, `name` varchar(100) DEFAULT NULL COMMENT '检查设备名称', `exam_class_id` varchar(50) DEFAULT NULL COMMENT 'exam_class表id', `status` int(11) NOT NULL DEFAULT '1' COMMENT '状态 1:有效 0:无效', PRIMARY KEY (`id`), KEY `device-examclass` (`exam_class_id`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='检查设备'; -- Create syntax for TABLE 'doctor_class' CREATE TABLE `doctor_class` ( `id` varchar(32) NOT NULL, `doctor_id` varchar(50) DEFAULT NULL COMMENT '医生表ID', `department_id` varchar(50) DEFAULT NULL COMMENT '科室id', `doctor_class` varchar(20) DEFAULT NULL COMMENT '医生类别 1.临床医生2.报告医生3.审核医生4.确认医生5.登记医生6远程申请医生7.远程报告医生8.远程审核医生(可多选)', `status` varchar(10) DEFAULT '1', PRIMARY KEY (`id`), KEY `docclass-depart` (`department_id`) USING BTREE, KEY `docclass-docid` (`doctor_id`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='医生类表'; -- Create syntax for TABLE 'doctors' CREATE TABLE `doctors` ( `id` varchar(32) NOT NULL, `username` varchar(100) NOT NULL COMMENT '用户名', `password` varchar(200) NOT NULL COMMENT '密码', `realname` varchar(200) DEFAULT NULL COMMENT '真实姓名', `email` varchar(200) DEFAULT NULL COMMENT 'email', `login_time` datetime DEFAULT NULL COMMENT '登录时间', `createdAt` datetime DEFAULT NULL COMMENT '创建时间', `updatedAt` datetime DEFAULT NULL COMMENT '修改时间', `token` varchar(255) DEFAULT NULL COMMENT '每次登陆产生新的Session标识', `phone` varchar(20) DEFAULT NULL COMMENT '电话', `remark` varchar(1000) DEFAULT NULL COMMENT '备注', `doctor_title` varchar(255) DEFAULT NULL COMMENT '职称', `status` varchar(50) DEFAULT NULL, `attachment` varchar(2000) DEFAULT NULL COMMENT '附件', `institution_id` varchar(50) DEFAULT NULL COMMENT '医疗机构ID', `department_id` varchar(50) DEFAULT NULL COMMENT '主要科室ID', `doctor_role` varchar(20) DEFAULT NULL COMMENT '1.本地医生2.远程医生(可多选)', `login_failure` int(11) DEFAULT NULL COMMENT '登录失败次数', `is_report` varchar(10) DEFAULT NULL COMMENT '是否能写报告', `exam_class` varchar(255) DEFAULT '*', `send_sms` int(10) DEFAULT '0', `message_push` varchar(10) DEFAULT '0' COMMENT '是否推送消息', `is_admin` varchar(255) DEFAULT '0' COMMENT '是否为管理员', `is_send_message` varchar(255) DEFAULT '0' COMMENT '登录是否发送短信', `is_use_autograph` varchar(255) DEFAULT '0' COMMENT '是否使用电子签名', `autograph` varchar(255) DEFAULT NULL COMMENT '电子签名', PRIMARY KEY (`id`), KEY `doc-institu` (`institution_id`), KEY `doc-depart` (`department_id`), KEY `doc-report` (`is_report`), KEY `doc-username` (`username`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='医生表'; -- Create syntax for TABLE 'dr_cla_permission' CREATE TABLE `dr_cla_permission` ( `id` varchar(32) NOT NULL, `doctor_id` varchar(255) DEFAULT NULL COMMENT '医生ID', `pass` varchar(255) DEFAULT NULL COMMENT '菜单ID 其他控制类型', `type` varchar(50) DEFAULT NULL COMMENT '权限控制类型 1,菜单 2,其他', PRIMARY KEY (`id`), KEY `permiss-docid` (`doctor_id`), KEY `dr_pass` (`pass`) USING BTREE, KEY `dr_type` (`type`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- Create syntax for TABLE 'every_studies' CREATE TABLE `every_studies` ( `id` varchar(50) NOT NULL, `institution_id` varchar(50) DEFAULT NULL COMMENT '医院id', `institution_name` varchar(255) DEFAULT NULL COMMENT '医院名称', `date` varchar(50) DEFAULT NULL COMMENT '检查时间', `count` int(11) DEFAULT NULL COMMENT '检查数量', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- Create syntax for TABLE 'exam_class' CREATE TABLE `exam_class` ( `id` varchar(32) NOT NULL, `institution_id` varchar(32) DEFAULT NULL COMMENT '医院id', `name` varchar(200) DEFAULT NULL COMMENT '检查类别名称', PRIMARY KEY (`id`), KEY `eclass-institution` (`institution_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='检查类别表格'; -- Create syntax for TABLE 'exam_project' CREATE TABLE `exam_project` ( `id` varchar(32) NOT NULL DEFAULT '', `name` varchar(200) DEFAULT NULL COMMENT '检查项目名称', `exam_class_id` varchar(20) DEFAULT NULL, `status` varchar(255) DEFAULT '0' COMMENT '删除状态', PRIMARY KEY (`id`), KEY `eproject-examclass` (`exam_class_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='检查项目表'; -- Create syntax for TABLE 'exam_subclass' CREATE TABLE `exam_subclass` ( `id` varchar(32) NOT NULL, `name` varchar(255) DEFAULT NULL COMMENT '子类名称', `exam_class_id` varchar(50) DEFAULT NULL, PRIMARY KEY (`id`), KEY `esubclass-eclass` (`exam_class_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- Create syntax for TABLE 'exams' CREATE TABLE `exams` ( `id` varchar(32) NOT NULL, `dept_id` varchar(100) DEFAULT NULL COMMENT '检查科室(执行科室)', `patient_id` varchar(100) DEFAULT NULL COMMENT '患者id', `patient_num` varchar(200) DEFAULT NULL COMMENT '病历号', `accession_num` varchar(100) DEFAULT NULL COMMENT '科室检查号', `exam_datetime` varchar(20) DEFAULT NULL COMMENT '检查日期', `exam_class` varchar(200) DEFAULT NULL COMMENT '检查类型', `exam_sub_class` varchar(200) DEFAULT NULL COMMENT '检查子类', `exam_project` varchar(200) DEFAULT NULL COMMENT '检查项目', `device` varchar(200) DEFAULT NULL COMMENT '检查设备', `body_part` varchar(200) DEFAULT NULL COMMENT '检查部位', `exam_method` varchar(200) DEFAULT NULL COMMENT '检查方法', `hopitalized_no` varchar(200) DEFAULT NULL COMMENT '住院号', `bed_no` varchar(200) DEFAULT NULL COMMENT '床位号', `clin_dept_id` varchar(50) DEFAULT NULL COMMENT '送诊科室id', `technician` varchar(200) DEFAULT NULL COMMENT '技师', `charge` varchar(200) DEFAULT NULL COMMENT '检查费用', `cost` varchar(200) DEFAULT NULL COMMENT '实际费用', `clin_doctors` varchar(200) DEFAULT NULL COMMENT '送诊医生', `phone` varchar(20) DEFAULT NULL COMMENT '联系方式', `institution_id` varchar(200) DEFAULT NULL COMMENT '医院id', `study_id` varchar(50) DEFAULT NULL COMMENT 'studyuid(studykey)', `illness_desc` text COMMENT '主诉', `phys_sign` varchar(200) DEFAULT NULL COMMENT '体征', `clin_diag` varchar(1000) DEFAULT NULL COMMENT '临床诊断', `clin_symp` varchar(4000) DEFAULT NULL COMMENT '临床症状', `patient_source` varchar(20) DEFAULT NULL COMMENT '病人来源 1门诊 2住院 3外来', `req_datetime` datetime DEFAULT NULL COMMENT '申请时间', `req_doctor` varchar(50) DEFAULT NULL COMMENT '申请医生(医生id)', `remark` text COMMENT '其他说明', `register` varchar(50) DEFAULT NULL COMMENT '登记人员( 医生id)', `register_datetime` datetime DEFAULT NULL COMMENT '注册登记时间', `exam_status` tinyint(6) DEFAULT '1' COMMENT '1、登记 2、开始检查3、检查完毕 4、申请 5、驳回 6、接收、7、初步报告 8、审核报告 9、确认、', `status` varchar(20) DEFAULT '1' COMMENT '记录状态 0禁用 1正常', `pay_status` varchar(10) DEFAULT '0' COMMENT '支付状态', `is_remote` varchar(10) DEFAULT NULL COMMENT '远程诊断是被接受 0,未接受 1,已接受', `urgent` varchar(10) NOT NULL DEFAULT '0' COMMENT '是否急诊 0否 1是', `film_type` varchar(20) DEFAULT '2' COMMENT '0 未定义 1传统胶片 2电子胶片', `anamnesis` varchar(255) DEFAULT NULL, `family_ill` varchar(255) DEFAULT NULL, `createdAt` datetime DEFAULT NULL, `updatedAt` datetime DEFAULT NULL, `delivery_doctor` varchar(100) DEFAULT NULL COMMENT '送诊医生', `exam_report` varchar(10) DEFAULT NULL COMMENT '检查结果', `ext` json DEFAULT NULL, `id_card` varchar(50) DEFAULT NULL COMMENT '身份证号', `study_uid` varchar(100) DEFAULT NULL, `application_department` varchar(255) DEFAULT NULL COMMENT '申请科室', `application_doctor` varchar(255) DEFAULT NULL COMMENT '申请医生', `severe` varchar(255) DEFAULT '0' COMMENT '重症标识', PRIMARY KEY (`id`), UNIQUE KEY `exam-study_id` (`study_id`), KEY `exam-patient` (`patient_id`), KEY `exam-institution` (`institution_id`), KEY `exam-urgent` (`urgent`), KEY `exam-remote` (`is_remote`), KEY `exam-status` (`exam_status`), KEY `exam-report` (`exam_report`), KEY `exam-project` (`exam_project`) USING BTREE, KEY `exam-device` (`device`), KEY `exam-body` (`body_part`), KEY `exams_exam_datetime` (`exam_datetime`), KEY `exams_exam_class` (`exam_class`), KEY `exams_exam_status` (`exam_status`), KEY `exams_patient_num` (`patient_num`), KEY `exams_patient_id` (`patient_id`), KEY `exams_study_id` (`study_id`), KEY `exams_institution_id` (`institution_id`), KEY `exams_idcard` (`id_card`), KEY `studyuid_index` (`study_uid`), KEY `exams_study_uid` (`study_uid`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='检查表'; -- Create syntax for TABLE 'images' CREATE TABLE `images` ( `id` varchar(32) NOT NULL COMMENT 'id', `series_id` varchar(200) DEFAULT NULL COMMENT '对应的序列', `image_id` varchar(255) DEFAULT NULL COMMENT '影像ID', `sop_uid` varchar(255) DEFAULT NULL, `image_number` int(11) DEFAULT NULL COMMENT '影像号', `owner` varchar(255) DEFAULT NULL COMMENT '所属人', `window_width` varchar(200) DEFAULT NULL COMMENT '窗宽', `windo_center` varchar(200) DEFAULT NULL COMMENT '窗位', `rows` varchar(200) DEFAULT NULL COMMENT '行', `columns` varchar(200) DEFAULT NULL COMMENT '队', `pixe_spacing` varchar(255) DEFAULT NULL COMMENT '影像的展示参数', `image_position` varchar(255) DEFAULT NULL COMMENT '影像的展示参数', `image_orientation` varchar(255) DEFAULT NULL COMMENT '影像的展示参数', `ctime` datetime DEFAULT NULL COMMENT '创建时间', `utime` datetime DEFAULT NULL COMMENT '修改时间', `url` varchar(255) DEFAULT NULL COMMENT '加载地址', `metadata` varchar(255) DEFAULT NULL, `createdAt` datetime DEFAULT NULL, `updatedAt` datetime DEFAULT NULL, `size` varchar(255) DEFAULT NULL, `institution_id` varchar(100) DEFAULT NULL, `local_url` varchar(255) DEFAULT NULL, `remote_url` varchar(100) DEFAULT NULL, `status` int(11) DEFAULT '2', `frame` int(11) DEFAULT '0', `cineRate` int(11) DEFAULT '0', `ext` json DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `image-image_id` (`image_id`), KEY `image-sop` (`sop_uid`), KEY `series_id_index` (`series_id`), KEY `images_institution_id` (`institution_id`), KEY `images_series_id` (`series_id`), KEY `image_status` (`status`), KEY `images_image_id` (`image_id`), KEY `images_url` (`url`), KEY `images_owner` (`owner`), KEY `images_metadata` (`metadata`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='影像表(images)'; -- Create syntax for TABLE 'institution' CREATE TABLE `institution` ( `id` varchar(32) NOT NULL COMMENT '机构代码', `name` varchar(200) DEFAULT NULL COMMENT '医院名', `address` varchar(200) DEFAULT NULL COMMENT '医院地址', `remark` text COMMENT '备注', `status` varchar(20) DEFAULT NULL, `createdAt` datetime DEFAULT NULL, `updatedAt` datetime DEFAULT NULL, `institution_level` varchar(200) DEFAULT NULL COMMENT '医疗机构等级', `parent_institution` varchar(100) DEFAULT NULL COMMENT '上级机构(多对多关系)', `charge_mode` varchar(20) DEFAULT NULL COMMENT '收费模式 1.向患者结算 2.向医院结算', `local_domain` varchar(255) DEFAULT NULL COMMENT 'http://local.pacsonline.cn/img/189290/**.jpg', `report_subtitle` varchar(200) DEFAULT NULL COMMENT '报告副标题', `agent_id` varchar(50) DEFAULT NULL COMMENT '代理商 关联manage表', `msg_phone` varchar(50) DEFAULT NULL, `urgent_time` datetime DEFAULT NULL, `not_urgent_time` datetime DEFAULT NULL, `wx_source` varchar(64) NOT NULL DEFAULT '中世康恺电子胶片平台' COMMENT '医疗机构所属微信公众号', `is_test` varchar(10) DEFAULT '0', PRIMARY KEY (`id`), KEY `institution-parent` (`parent_institution`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='医疗机构表'; -- Create syntax for TABLE 'manager' CREATE TABLE `manager` ( `id` varchar(32) NOT NULL COMMENT 'ID', `role_id` varchar(50) DEFAULT '0' COMMENT '角色id(0:admin;1:医院;2:代理商)', `username` varchar(100) NOT NULL DEFAULT '' COMMENT '用户名', `password` varchar(100) NOT NULL DEFAULT '' COMMENT '密码', `email` varchar(100) DEFAULT '' COMMENT 'email', `phone` varchar(50) DEFAULT '' COMMENT '电话', `logintime` datetime DEFAULT NULL COMMENT '最后登录时间', `loginip` varchar(50) DEFAULT '' COMMENT '登录IP', `loginfailure` tinyint(1) DEFAULT NULL COMMENT '登陆失败次数', `createdAt` datetime DEFAULT NULL COMMENT '????', `updatedAt` datetime DEFAULT NULL COMMENT '????', `institution_id` varchar(200) DEFAULT NULL COMMENT '机构ID', `status` tinyint(1) DEFAULT '0' COMMENT '删除状态', PRIMARY KEY (`id`), KEY `username` (`username`), KEY `mobile` (`phone`), KEY `institution` (`institution_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='管理员表(代理商)'; -- Create syntax for TABLE 'menu' CREATE TABLE `menu` ( `id` varchar(32) NOT NULL, `name` varchar(255) DEFAULT NULL COMMENT '菜单名称', `status` varchar(255) DEFAULT NULL, `parent_id` varchar(36) DEFAULT NULL COMMENT '父集关系', `url` varchar(255) DEFAULT NULL COMMENT '网址', `ordernum` int(10) DEFAULT NULL COMMENT '排序', `icon_name` varchar(255) DEFAULT NULL COMMENT '图标', PRIMARY KEY (`id`), KEY `menu-parent` (`parent_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='菜单表'; -- Create syntax for TABLE 'messages' CREATE TABLE `messages` ( `id` varchar(32) NOT NULL DEFAULT '', `title` varchar(255) DEFAULT NULL COMMENT '标题', `content` text COMMENT '内容', `is_read` int(255) DEFAULT '0' COMMENT '0|未读,1|已读`', `ctime` datetime DEFAULT NULL, `doctor_id` varchar(50) DEFAULT NULL COMMENT '所属医生id', `status` varchar(255) DEFAULT '0' COMMENT '是否删除', `institution_id` varchar(50) DEFAULT NULL COMMENT '机构', `department_id` varchar(50) DEFAULT NULL COMMENT '科室', `count` int(10) DEFAULT '1', `url` varchar(255) DEFAULT NULL, `type` varchar(50) DEFAULT NULL COMMENT '1,新增远程申请2,远程申请驳回3,远程申请被撤回4,远程诊断接收5,报告已审核6,报告确认7,对话8,审核驳回', `htime` datetime DEFAULT NULL, `application_id` varchar(50) DEFAULT NULL, PRIMARY KEY (`id`), KEY `message-read` (`is_read`), KEY `message-doctor` (`doctor_id`), KEY `message-institution` (`institution_id`), KEY `message-department` (`department_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='消息表'; -- Create syntax for TABLE 'open_application' CREATE TABLE `open_application` ( `id` int(11) NOT NULL AUTO_INCREMENT, `institution_name` varchar(128) DEFAULT NULL COMMENT '医疗机构名称', `institution_level` varchar(45) DEFAULT NULL COMMENT '医疗机构等级', `name` varchar(45) NOT NULL COMMENT '联系人', `phone` varchar(45) NOT NULL COMMENT '联系电话', `email` varchar(128) DEFAULT NULL COMMENT '联系邮箱', `position` varchar(45) DEFAULT NULL COMMENT '联系人职务', `title` varchar(45) DEFAULT NULL COMMENT '医生职称', `department` varchar(64) DEFAULT NULL COMMENT '医生所在科室', `company` varchar(128) DEFAULT NULL COMMENT '城市合伙人公司名称', `type` int(11) DEFAULT NULL COMMENT '申请来源0:未定义1:医院申请2:医生申请3:城市合伙人申请', `status` int(11) DEFAULT '1' COMMENT '状态0:未定义1:已接收2:已通知负责人3:已对接4:申请成功5:申请失败', `ctime` int(11) NOT NULL COMMENT '创建时间', PRIMARY KEY (`id`), KEY `phone` (`phone`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- Create syntax for TABLE 'operating' CREATE TABLE `operating` ( `id` varchar(32) NOT NULL, `nums` varchar(255) DEFAULT NULL COMMENT '单子数量', `month` int(10) DEFAULT NULL COMMENT '月份', `exam_num` varchar(255) DEFAULT NULL COMMENT '影像数目', `remote_num` varchar(255) DEFAULT NULL COMMENT '远程诊断数量', `danger_num` varchar(255) DEFAULT NULL COMMENT '患者疾病阳性数量', `role_id` varchar(255) DEFAULT NULL COMMENT '用户id', `type` varchar(255) DEFAULT NULL COMMENT '1医生 2机构 3代理', PRIMARY KEY (`id`), KEY `operate-role` (`role_id`), KEY `month` (`month`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='运营报告'; -- Create syntax for TABLE 'oss_callbacks' CREATE TABLE `oss_callbacks` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `md5` varchar(255) NOT NULL, `url` varchar(255) NOT NULL, `region` varchar(255) NOT NULL, `bucket` varchar(255) NOT NULL, `size` int(11) NOT NULL, `hospital_id` varchar(255) NOT NULL, `status` int(11) NOT NULL DEFAULT '0', `remark` varchar(255) DEFAULT NULL, `x_real_ip` varchar(255) DEFAULT NULL, `x_forwarded_for_ip` varchar(255) DEFAULT NULL, `request_date` varchar(255) DEFAULT NULL, `x_oss_request_id` varchar(255) DEFAULT NULL, `x_oss_requester` varchar(255) DEFAULT NULL, `x_oss_pub_key_url` varchar(255) DEFAULT NULL, `authorization` varchar(255) DEFAULT NULL, `content_md5` varchar(255) DEFAULT NULL, `createdAt` datetime NOT NULL, `updatedAt` datetime NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `md5_index` (`md5`), UNIQUE KEY `url_index` (`url`), KEY `oss_callbacks_hospital_id` (`hospital_id`), KEY `oss_callbacks_bucket` (`bucket`), KEY `oss_callbacks_status` (`status`), KEY `oss_callbacks_x_real_ip` (`x_real_ip`), KEY `oss_callbacks_region` (`region`), KEY `oss_callbacks_x_forwarded_for_ip` (`x_forwarded_for_ip`), KEY `oss_callbacks_x_oss_requester` (`x_oss_requester`), KEY `oss_callbacks_x_oss_pub_key_url` (`x_oss_pub_key_url`), KEY `oss_callbacks_x_oss_request_id` (`x_oss_request_id`), KEY `oss_callbacks_authorization` (`authorization`) ) ENGINE=InnoDB AUTO_INCREMENT=11762709 DEFAULT CHARSET=utf8; -- Create syntax for TABLE 'patient_infos' CREATE TABLE `patient_infos` ( `id` varchar(32) NOT NULL, `name` varchar(100) DEFAULT NULL COMMENT '患者姓名', `sex` varchar(10) DEFAULT NULL COMMENT '性别', `card_num` varchar(100) DEFAULT NULL COMMENT '身份证号', `phone` varchar(20) DEFAULT NULL COMMENT '手机号', `ctime` datetime DEFAULT NULL COMMENT '创建时间', `birthday` varchar(20) DEFAULT NULL COMMENT '生日', `age` varchar(10) DEFAULT NULL COMMENT '年龄', `card_type` varchar(30) DEFAULT NULL COMMENT '证件类型', `nationality` varchar(50) DEFAULT NULL COMMENT '国籍', `nation` varchar(30) DEFAULT '' COMMENT '民族', `marry` varchar(10) DEFAULT NULL COMMENT '婚否', `professional` varchar(100) DEFAULT NULL COMMENT '职业', `address` varchar(255) DEFAULT NULL COMMENT '联系地址', `temp_patient_id` varchar(50) DEFAULT NULL COMMENT '检查临时患者id(从dicom影像中解析)', `status` int(10) NOT NULL DEFAULT '1', `institution_id` varchar(200) DEFAULT NULL COMMENT '所属医院', `anamnesis` varchar(255) DEFAULT NULL COMMENT '疾病史', `family_ill` varchar(255) DEFAULT NULL COMMENT '家族史', `createdAt` datetime DEFAULT NULL, `updatedAt` datetime DEFAULT NULL, `ext` json DEFAULT NULL, PRIMARY KEY (`id`), KEY `parentinfo-institution` (`institution_id`), KEY `card_num` (`card_num`), KEY `patient_infos_institution_id` (`institution_id`), KEY `patient_infos_temp_patient_id` (`temp_patient_id`), KEY `patient_infos_phone` (`phone`), KEY `patient_id_index` (`temp_patient_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='患者信息表'; -- Create syntax for TABLE 'remote_application' CREATE TABLE `remote_application` ( `id` varchar(32) NOT NULL, `remote_institution_id` varchar(100) DEFAULT NULL COMMENT '申请的目标医院', `remote_doctor_id` varchar(100) DEFAULT NULL COMMENT '申请的目标医生', `local_institution_id` varchar(100) DEFAULT NULL COMMENT '发起申请医院', `req_date_time` datetime DEFAULT NULL COMMENT '发起时间', `req_doctor_id` varchar(100) DEFAULT NULL COMMENT '申请医生', `illness_desc` varchar(2000) NOT NULL COMMENT '主诉', `clin_symp` varchar(2000) DEFAULT NULL COMMENT '临床症状', `phys_sign` varchar(2000) DEFAULT NULL COMMENT '体征', `clin_diag` varchar(2000) DEFAULT NULL COMMENT '临床诊断', `anamnesis` varchar(2000) DEFAULT NULL COMMENT '既往史', `family_ill` varchar(2000) DEFAULT NULL COMMENT '家族史', `marrital` varchar(2000) DEFAULT '' COMMENT '婚姻史', `remark` varchar(4000) DEFAULT NULL COMMENT '备注', `exam_id` varchar(32) DEFAULT NULL COMMENT '检查表id', `is_urgent` varchar(10) NOT NULL DEFAULT '0' COMMENT '是否急诊 0否 1是', `status` varchar(10) DEFAULT '0' COMMENT '删除状态', `createdAt` datetime DEFAULT NULL COMMENT '创建时间', `application_desc` varchar(2000) DEFAULT NULL COMMENT '申请描述', `attachment` varchar(255) DEFAULT NULL COMMENT '附件', `report_status` varchar(10) DEFAULT '' COMMENT '4、申请 5、驳回 6、接收、7、初步报告 8、审核报告 9、确认、', PRIMARY KEY (`id`), KEY `application-remote-institution` (`remote_institution_id`), KEY `local_institution_id` (`local_institution_id`), KEY `application-remote_doctor` (`remote_doctor_id`) USING BTREE, KEY `application-req_doctor` (`req_doctor_id`) USING BTREE, KEY `application-is_urgent` (`is_urgent`) USING BTREE, KEY `application--exam_id` (`exam_id`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='申请表'; -- Create syntax for TABLE 'report' CREATE TABLE `report` ( `id` varchar(32) NOT NULL COMMENT '报告id', `report_datetime` datetime DEFAULT NULL COMMENT '报告时间', `description` text COMMENT '检查所见', `impression` text COMMENT '意见建议', `img_url` varchar(1500) DEFAULT NULL COMMENT '缩略图地址', `exam_id` varchar(255) DEFAULT NULL COMMENT '检查表id', `createdAt` datetime DEFAULT NULL, `report_doctor_id` varchar(255) DEFAULT NULL COMMENT '报告医生id', `review_doctor_id` varchar(255) DEFAULT NULL COMMENT '审核医生id', `qr_code` varchar(255) DEFAULT NULL COMMENT '二维码', `report_result` varchar(255) DEFAULT NULL COMMENT '报告结果(阴阳性) 1阴性 2阳性', `review_datetime` datetime DEFAULT NULL COMMENT '审核时间', `confirm_doctor_id` varchar(50) DEFAULT NULL COMMENT '确认医生', `confirm_datetime` datetime DEFAULT NULL COMMENT '确认时间', `type` varchar(10) DEFAULT '1' COMMENT '报告类型', `remote_application_id` varchar(50) DEFAULT NULL COMMENT '申请id', PRIMARY KEY (`id`), KEY `唯一` (`exam_id`) USING BTREE, KEY `report-doctor` (`report_doctor_id`) USING BTREE, KEY `report-review_doctor` (`review_doctor_id`) USING BTREE, KEY `report-confirm_doctor` (`confirm_doctor_id`) USING BTREE ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='诊断报告'; -- Create syntax for TABLE 'report_record' CREATE TABLE `report_record` ( `id` varchar(32) NOT NULL, `impression` varchar(2000) DEFAULT NULL COMMENT '检查所见', `description` varchar(2000) DEFAULT NULL COMMENT '意见建议', `report_id` varchar(50) DEFAULT NULL COMMENT '检查表id', `createdAt` datetime DEFAULT NULL, `doctor_id` varchar(50) DEFAULT NULL COMMENT '医生id', `type` varchar(255) DEFAULT NULL COMMENT '操作类型 1报告 2审核 3确认 4驳回', PRIMARY KEY (`id`), KEY `record-report` (`report_id`) USING BTREE, KEY `record-doctor` (`doctor_id`) USING BTREE ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='报告操作历史记录'; -- Create syntax for TABLE 'send_message' CREATE TABLE `send_message` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `phone` varchar(100) DEFAULT NULL, `type` varchar(255) DEFAULT NULL, `doctor` varchar(255) DEFAULT NULL, `content` varchar(255) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=1668 DEFAULT CHARSET=utf8; -- Create syntax for TABLE 'series' CREATE TABLE `series` ( `id` varchar(32) NOT NULL, `study_id` varchar(255) DEFAULT NULL, `seriesuid` varchar(255) DEFAULT NULL, `series_num` int(11) unsigned zerofill DEFAULT NULL, `modality` varchar(255) DEFAULT NULL, `description` varchar(255) DEFAULT NULL, `ctime` datetime DEFAULT NULL, `utime` datetime DEFAULT NULL, `createdAt` datetime DEFAULT NULL, `updatedAt` datetime DEFAULT NULL, `ext` json DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY ` seriesuid` (`seriesuid`), KEY `series_modality` (`modality`), KEY `series_study_id` (`study_id`), KEY `series_seriesuid` (`seriesuid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- Create syntax for TABLE 'studies' CREATE TABLE `studies` ( `id` varchar(32) NOT NULL, `studyuid` varchar(200) NOT NULL DEFAULT '', `patient_id` varchar(50) DEFAULT NULL COMMENT '患者id', `studyid` varchar(50) DEFAULT NULL, `accession_num` varchar(255) DEFAULT NULL COMMENT '科室检查号', `studydate` varchar(255) DEFAULT NULL, `ctime` datetime DEFAULT NULL, `utime` datetime DEFAULT NULL, `modality` varchar(255) DEFAULT NULL, `status` int(11) DEFAULT NULL, `patient_age` varchar(20) DEFAULT NULL, `institution_name` varchar(50) DEFAULT NULL COMMENT '机构名称', `institution_id` varchar(200) DEFAULT NULL, `createdAt` datetime DEFAULT NULL, `updatedAt` datetime DEFAULT NULL, `ext` json DEFAULT NULL, PRIMARY KEY (`id`,`studyuid`), UNIQUE KEY `studyuid` (`studyuid`), KEY `studies_institution_name` (`institution_name`), KEY `studies_patient_id` (`patient_id`), KEY `studies_studydate` (`studydate`), KEY `studies_modality` (`modality`), KEY `studies_status` (`status`), KEY `studies_studyid` (`studyid`), KEY `studies_accession_num` (`accession_num`), KEY `studies_studyuid` (`studyuid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- Create syntax for TABLE 'sys_logs' CREATE TABLE `sys_logs` ( `id` varchar(35) DEFAULT NULL, `uid` varchar(50) DEFAULT NULL COMMENT '管理员id', `module` varchar(50) DEFAULT NULL COMMENT '功能模块', `type` varchar(5) DEFAULT NULL COMMENT 'CRUD[增查改删],L=login', `txt` text COMMENT '信息', `ip` varchar(50) DEFAULT NULL, `cdate` datetime DEFAULT NULL, KEY `slog-uid` (`uid`) USING BTREE, KEY `slog-module` (`module`) USING BTREE, KEY `slog-type` (`type`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- Create syntax for TABLE 'sys_menus' CREATE TABLE `sys_menus` ( `id` varchar(32) NOT NULL COMMENT '??', `pid` varchar(32) DEFAULT NULL COMMENT '父类id', `name` varchar(100) DEFAULT NULL COMMENT '菜单名', `url` varchar(255) DEFAULT NULL COMMENT '地址', `ordernum` int(11) DEFAULT NULL COMMENT '排序号', `target` varchar(100) DEFAULT NULL COMMENT '是否弹出', PRIMARY KEY (`id`), KEY `smenu-pid` (`pid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='系统菜单'; -- Create syntax for TABLE 'templates' CREATE TABLE `templates` ( `id` varchar(32) NOT NULL DEFAULT '' COMMENT '主键', `title` varchar(100) NOT NULL DEFAULT '' COMMENT '标题', `is_public` int(11) NOT NULL DEFAULT '0' COMMENT '公众模版 1:公众模版 2:私有模版', `create_user` varchar(32) NOT NULL DEFAULT '' COMMENT '创建人', `exam_class_id` varchar(32) NOT NULL COMMENT '检查id exam_class.id', `description` varchar(4096) NOT NULL DEFAULT '' COMMENT '影响所见', `impression` varchar(4096) NOT NULL DEFAULT '' COMMENT '印象', `createdAt` datetime NOT NULL COMMENT '创建时间', `parent_id` varchar(50) DEFAULT '0' COMMENT '父类', PRIMARY KEY (`id`), KEY `template-is_public` (`is_public`) USING HASH, KEY `template-exam_class` (`exam_class_id`) USING HASH, KEY `template-create_user` (`create_user`) USING HASH, KEY `template-parent_id` (`parent_id`) USING HASH ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='模板'; -- Create syntax for TABLE 'user' CREATE TABLE `user` ( `id` varchar(45) NOT NULL COMMENT '用户id', `wx_openid` varchar(45) DEFAULT NULL COMMENT '微信openid', `wx_icon` varchar(256) DEFAULT '' COMMENT '微信头像', `wx_nickname` varchar(45) CHARACTER SET utf8mb4 DEFAULT NULL COMMENT '微信昵称', `source` varchar(45) DEFAULT NULL COMMENT '来源公众号', `phone` varchar(45) DEFAULT NULL COMMENT '手机号', `idcard` varchar(45) DEFAULT NULL COMMENT '身份证号', `subscribe_status` int(1) NOT NULL DEFAULT '0' COMMENT '公众号关注状态0:未关注1:取消关注2:已关注', `createAt` datetime DEFAULT NULL COMMENT '创建时间', PRIMARY KEY (`id`), UNIQUE KEY `wx_openid_UNIQUE` (`wx_openid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- Create syntax for TABLE 'user_bind' CREATE TABLE `user_bind` ( `id` int(11) NOT NULL AUTO_INCREMENT, `user_id` varchar(45) DEFAULT NULL COMMENT '用户id', `exam_id` varchar(45) DEFAULT NULL COMMENT '检查id', `patient_id` varchar(45) DEFAULT NULL COMMENT '患者id', `storage_endtime` datetime DEFAULT NULL COMMENT '存储截止日期', `bind_way` tinyint(2) NOT NULL DEFAULT '0' COMMENT '绑定途径0:未定义1:扫描报告二维码2:手动添加3:系统自动关联', `status` tinyint(2) NOT NULL DEFAULT '1' COMMENT '状态0:解绑1:正常', `createAt` datetime DEFAULT NULL COMMENT '创建时间', PRIMARY KEY (`id`), KEY `userid_index` (`user_id`) ) ENGINE=InnoDB AUTO_INCREMENT=324 DEFAULT CHARSET=utf8; -- Create syntax for TABLE 'version' CREATE TABLE `version` ( `id` int(11) NOT NULL AUTO_INCREMENT, `version` varchar(255) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8; -- Create syntax for TABLE 'wechat_bind' CREATE TABLE `wechat_bind` ( `id` int(32) NOT NULL AUTO_INCREMENT, `uid` varchar(32) DEFAULT NULL COMMENT '用户id', `patientName` varchar(100) DEFAULT NULL COMMENT '患者姓名', `patientCode` varchar(100) DEFAULT NULL COMMENT '检查号/病历号/患者ID', `idcard` varchar(100) DEFAULT NULL COMMENT '检查类别名称', `phone` varchar(100) DEFAULT NULL COMMENT '手机号码', `ctime` int(32) NOT NULL COMMENT '创建时间', `status` int(200) DEFAULT '1' COMMENT '状态 1正常 2删除', PRIMARY KEY (`id`), KEY `user_id_index` (`uid`) ) ENGINE=InnoDB AUTO_INCREMENT=1894 DEFAULT CHARSET=utf8 COMMENT='检查类别表格';