| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| procedure_result_id | BIGINT | 19 | √ | null |
|
|
Surrogate id of the record used as the primary incrementing key |
||||
| procedure_report_id | BIGINT | 19 | null |
|
|
references procedure_report.procedure_report_id |
|||||
| result_data_type | CHAR | 1 | 'S' |
|
|
N=Numeric, S=String, F=Formatted, E=External, L=Long text as the first line of comments |
|||||
| result_code | VARCHAR | 31 | '' |
|
|
LOINC code, might match a procedure_type.procedure_code |
|||||
| result_text | VARCHAR | 255 | '' |
|
|
Description of result_code |
|||||
| date | DATETIME | 19 | √ | NULL |
|
|
Lab-provided date specific to this result |
||||
| facility | VARCHAR | 255 | '' |
|
|
Lab-provided testing facility ID |
|||||
| units | VARCHAR | 31 | '' |
|
|
Units for the result |
|||||
| result | VARCHAR | 255 | '' |
|
|
Result data |
|||||
| range | VARCHAR | 255 | '' |
|
|
Result range |
|||||
| abnormal | VARCHAR | 31 | '' |
|
|
Abnormal values (no, yes, high, low) |
|||||
| comments | MEDIUMTEXT | 16777215 | √ | NULL |
|
|
Comments from the lab |
||||
| document_id | BIGINT | 19 | 0 |
|
|
References documents.id if this result is a document |
|||||
| result_status | VARCHAR | 31 | '' |
|
|
Result status (preliminary, cannot be done, final, corrected, incomplete, etc.) |
|||||
| uuid | BINARY | 16 | √ | NULL |
|
|
UUID of the record |
||||
| date_end | DATETIME | 19 | √ | NULL |
|
|
Lab-provided end date specific to this result |
Showing 1 to 16 of 16 entries