| 12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455 |
- 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 | | |
- -----------------+--------------+------+-----+---------+---------
|
