Table thumbnail_request
Legend:
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
id int8 19
date_requested timestamp 29,6
filename text 2147483647
filename_hash varchar 100
global_task_id varchar 255  √  null
handle varchar 255
item_uuid varchar 255
item_version int4 10  √  null
recreate bool 1  √  null
task_id varchar 80  √  null
thumbnail_types int4 10
uuid varchar 40
institution_id int8 19
institution.id fkf33e3cbc711081 R
Indexes:
Column(s) Type Sort Constraint Name
id Primary key Asc thumbnail_request_pkey
institution_id + item_uuid + item_version + handle + filename_hash Must be unique Asc/Asc/Asc/Asc/Asc thumbnail_request_institution_id_item_uuid_item_version_han_key
institution_id + uuid Must be unique Asc/Asc thumbnail_request_institution_id_uuid_key
filename_hash Performance Asc trfilenamehash
handle Performance Asc trhandle
institution_id Performance Asc trinstindex
item_uuid Performance Asc tritemuuid
item_version Performance Asc tritemversion
uuid Performance Asc truuidindex

Close relationships  within of separation: