Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| pk | int8 | 19 | null |
|
|
|||||
| created_time | timestamp | 29,6 | null |
|
|
|||||
| digest | varchar | 255 | √ | null |
|
|
||||
| multi_ref | int4 | 10 | √ | null |
|
|
||||
| object_type | int2 | 5 | null |
|
|
|||||
| object_size | int8 | 19 | null |
|
|
|||||
| status | int2 | 5 | null |
|
|
|||||
| storage_id | varchar | 255 | null |
|
|
|||||
| storage_path | varchar | 255 | null |
|
|
|||||
| tsuid | varchar | 255 | √ | null |
|
|
||||
| uidmap_fk | int8 | 19 | √ | null |
|
|
||||
| instance_fk | int8 | 19 | √ | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| location_pkey | Primary key | Asc | pk |
| fkendncyyv928u41dfo1x09s644 | Performance | Asc | uidmap_fk |
| fkpp9xjy946uspo3piayc6ofels | Performance | Asc | instance_fk |
| idxi1lnahmehau3r3j9pdyxg3p3y | Performance | Asc | multi_ref |
| idxr3oh859i9osv3aluoc8dcx9wk | Performance | Asc/Asc | storage_id + status |
Check Constraints
| Constraint Name | Constraint |
|---|---|
| location_status_check | (((status >= 0) AND (status <= 17))) |
| location_object_type_check | (((object_type >= 0) AND (object_type <= 1))) |
Relationships
Close relationships within degrees of separation
