Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| procedure_specimen_id | BIGINT | 19 | √ | null |
|
|
record id |
||||
| uuid | BINARY | 16 | √ | NULL |
|
|
FHIR Specimen id |
||||
| procedure_order_id | BIGINT | 19 | null |
|
|
links to procedure_order.procedure_order_id |
|||||
| procedure_order_seq | INT | 10 | null |
|
|
links to procedure_order_code.procedure_order_seq (per test line) |
|||||
| specimen_identifier | VARCHAR | 128 | √ | NULL |
|
|
tube/barcode/internal id |
||||
| accession_identifier | VARCHAR | 128 | √ | NULL |
|
|
lab accession number |
||||
| specimen_type_code | VARCHAR | 64 | √ | NULL |
|
|
Comes from the list_options.list_id=‘specimen_type’ and represents the type of specimen being collected for the procedure |
||||
| specimen_type | VARCHAR | 255 | √ | NULL |
|
|
display/text |
||||
| collection_method_code | VARCHAR | 64 | √ | NULL |
|
|
Comes from the list_options.list_id=‘specimen_collection_method’ and represents the type of specimen being collected for the procedure |
||||
| collection_method | VARCHAR | 255 | √ | NULL |
|
|
|||||
| specimen_location_code | VARCHAR | 64 | √ | NULL |
|
|
Comes from the list_options.list_id=‘specimen_location’ and represents the body location the specimen is collected from for the procedure |
||||
| specimen_location | VARCHAR | 255 | √ | NULL |
|
|
|||||
| collected_date | DATETIME | 19 | √ | NULL |
|
|
single instant |
||||
| collection_date_low | DATETIME | 19 | √ | NULL |
|
|
period start |
||||
| collection_date_high | DATETIME | 19 | √ | NULL |
|
|
period end |
||||
| volume_value | DECIMAL | 10,3 | √ | NULL |
|
|
|||||
| volume_unit | VARCHAR | 32 | √ | 'mL' |
|
|
|||||
| condition_code | VARCHAR | 32 | √ | NULL |
|
|
Comes from the list_options.list_id=‘specimen_condition’ and represents the condition / quality of the specimen being collected for the procedure |
||||
| specimen_condition | VARCHAR | 64 | √ | NULL |
|
|
|||||
| comments | TEXT | 65535 | √ | NULL |
|
|
|||||
| created_at | DATETIME | 19 | √ | current_timestamp() |
|
|
|||||
| updated_at | DATETIME | 19 | √ | current_timestamp() |
|
|
|||||
| created_by | BIGINT | 19 | √ | NULL |
|
|
|||||
| updated_by | BIGINT | 19 | √ | NULL |
|
|
|||||
| deleted | BOOLEAN | 3 | √ | 0 |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PRIMARY | Primary key | Asc | procedure_specimen_id |
| idx_accession | Performance | Asc | accession_identifier |
| idx_identifier | Performance | Asc | specimen_identifier |
| idx_order_line | Performance | Asc/Asc | procedure_order_id + procedure_order_seq |
| uuid_unique | Must be unique | Asc | uuid |