Table: Reports
----------------+----------------------+------+-----+---------+---------
 Field          | Type                 | Null | Key | Default | Remarks 
----------------+----------------------+------+-----+---------+---------
 reportId       | BIGINT(19)           | NO   | PRI |         | 报告id    
 title          | VARCHAR(255)         | YES  |     |         | 医院名称    
 subtitle       | VARCHAR(255)         | YES  |     |         | 报告名称    
 reportDoctor   | VARCHAR(255)         | YES  |     |         | 医生名称    
 reportDateTime | VARCHAR(255)         | YES  |     |         | 报告时间    
 parameter      | VARCHAR(255)         | YES  |     |         | 检查参数    
 impression     | TEXT(65535)          | YES  |     |         | 检查所见    
 description    | VARCHAR(2048)        | YES  |     |         | 意见建议    
 img            | LONGTEXT(2147483647) | YES  |     |         | 缩略图地址   
 hospitalNo     | VARCHAR(255)         | YES  |     |         | 医院id    
 patientid      | VARCHAR(255)         | YES  |     |         | 患者id    
 patientName    | VARCHAR(255)         | YES  |     |         | 患者姓名    
 patientSex     | VARCHAR(255)         | YES  |     |         | 患者性别    
 patientAge     | VARCHAR(255)         | YES  |     |         | 患者年龄    
 examClass      | VARCHAR(255)         | YES  |     |         | 检查类别    
 examItem       | VARCHAR(255)         | YES  |     |         |         
 examNo         | VARCHAR(255)         | YES  |     |         | 检查号     
 studyuid       | VARCHAR(255)         | YES  |     |         | 检查uid   
 examDateTime   | VARCHAR(255)         | YES  |     |         | 检查时间    
 phone          | VARCHAR(255)         | YES  |     |         | 患者手机号   
 status         | INT(10)              | NO   |     |         | 报告状态 1正常 2删除
 idCrad         | VARCHAR(255)         | YES  |     |         | 患者身份证号码 
 createdAt      | DATETIME(19)         | NO   |     |         |         
 updatedAt      | DATETIME(19)         | NO   |     |         |         
 studyid        | VARCHAR(255)         | YES  |     |         | 检查id    
 studyKey       | BIGINT(19)           | NO   |     |         | 检查key   
 did            | INT(10)              | NO   |     |         | 医生id    
 qrCode         | VARCHAR(255)         | YES  |     |         |         
 pay_status     | INT(10)              | NO   |     | 0       |         
----------------+----------------------+------+-----+---------+---------

Table: Studies
-----------------+--------------+------+-----+---------+---------
 Field           | Type         | Null | Key | Default | Remarks 
-----------------+--------------+------+-----+---------+---------
 studyKey        | BIGINT(19)   | NO   | PRI |         |         
 patientKey      | BIGINT(19)   | NO   |     | 1       |         
 studyUid        | VARCHAR(255) | NO   |     | 1       |         
 studyId         | VARCHAR(255) | YES  |     |         |         
 accessionNumber | VARCHAR(255) | YES  |     |         |         
 studyDate       | VARCHAR(255) | YES  |     |         |         
 description     | VARCHAR(255) | YES  |     |         |         
 createdAt       | DATETIME(19) | NO   |     |         |         
 updatedAt       | DATETIME(19) | NO   |     |         |         
 modality        | CHAR(255)    | YES  |     |         |         
 status          | INT(10)      | YES  |     | 1       |         
 patientAge      | VARCHAR(255) | YES  |     |         |         
 institutionName | VARCHAR(255) | YES  |     |         |         
 hospitalId      | VARCHAR(255) | YES  |     |         |         
-----------------+--------------+------+-----+---------+---------