Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| container_identifier | BIGINT | 19 | 0 |
|
|
|||
| container_name | VARCHAR | 64 | null |
|
|
|||
| container_display_name | VARCHAR | 255 | √ | null |
|
|
||
| container_barcode | VARCHAR | 64 | √ | null |
|
|
||
| position_identifier | BIGINT | 19 | 0 |
|
|
|||
| pos_one_str | VARCHAR | 8 | √ | null |
|
|
||
| pos_two_str | VARCHAR | 8 | √ | null |
|
|
||
| pos_one | SMALLINT | 5 | √ | null |
|
|
||
| pos_two | SMALLINT | 5 | √ | null |
|
|
||
| formatted_position | VARCHAR | 27 | √ | null |
|
|
||
| specimen_id | BIGINT | 19 | √ | null |
|
|
||
| checkout_by | BIGINT | 19 | √ | null |
|
|
||
| checkout_time | TIMESTAMP | 19 | √ | null |
|
|
||
| checkout_comments | VARCHAR | 255 | √ | null |
|
|
||
| site_id | BIGINT | 19 | 0 |
|
|
|||
| site_name | VARCHAR | 255 | null |
|
|