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 | int4 | 10 | null |
|
|
|||||
| object_size | int8 | 19 | null |
|
|
|||||
| status | int4 | 10 | 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 |
| fk_bfk5vl6eoxaf0hhwiu3rbgmkn | Performance | Asc | uidmap_fk |
| fk_hjtlcwsvwihs4khh961d423e7 | Performance | Asc | instance_fk |
| uk_i1lnahmehau3r3j9pdyxg3p3y | Performance | Asc | multi_ref |
| uk_r3oh859i9osv3aluoc8dcx9wk | Performance | Asc/Asc | storage_id + status |
Relationships
Close relationships within degrees of separation
