Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| storage_id | serial | 10 | √ | nextval('storage_storage_id_seq'::regclass) |
|
|
PK. Unique identifier for each storage location. Generated by database. |
|||
| institution_id | int4 | 10 | √ | null |
|
|
FK. ID for the institution where the sample is stored. Links to the institution table. |
|||
| building | varchar | 100 | √ | null |
|
|
Building where the sample is stored. |
|||
| room | varchar | 50 | √ | null |
|
|
Room where the sample is stored. |
|||
| cabinet | varchar | 50 | √ | null |
|
|
Cabinet where the sample is stored. |
|||
| shelf_drawer | varchar | 50 | √ | null |
|
|
Shelf or drawer where sample is stored. |
|||
| timestamp_created | timestamptz | 35,6 | now() |
|
|
|||||
| timestamp_modified | timestamptz | 35,6 | √ | now() |
|
|
||||
| contact_person | int4 | 10 | √ | null |
|
|
||||
| storage_notes | varchar | 1000 | √ | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| storage_id | Primary key | Asc | storage_id |
Relationships
Close relationships within degrees of separation
