Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| identifier | BIGINT | 19 | 0 |
|
|
|||
| specimen_id | BIGINT | 19 | null |
|
|
|||
| container_id | BIGINT | 19 | null |
|
|
|||
| from_site_id | BIGINT | 19 | null |
|
|
|||
| from_container_id | BIGINT | 19 | √ | null |
|
|
||
| from_row | VARCHAR | 16 | √ | null |
|
|
||
| from_column | VARCHAR | 16 | √ | null |
|
|
||
| from_row_ordinal | SMALLINT | 5 | √ | null |
|
|
||
| from_column_ordinal | SMALLINT | 5 | √ | null |
|
|
||
| from_position | SMALLINT | 5 | √ | null |
|
|
||
| to_site_id | BIGINT | 19 | null |
|
|
|||
| to_container_id | BIGINT | 19 | √ | null |
|
|
||
| to_row | VARCHAR | 16 | √ | null |
|
|
||
| to_column | VARCHAR | 16 | √ | null |
|
|
||
| to_row_ordinal | SMALLINT | 5 | √ | null |
|
|
||
| to_column_ordinal | SMALLINT | 5 | √ | null |
|
|
||
| to_position | SMALLINT | 5 | √ | null |
|
|
||
| user_id | BIGINT | 19 | null |
|
|
|||
| transfer_time | TIMESTAMP | 19 | null |
|
|
|||
| reason | VARCHAR | 255 | √ | null |
|
|