Table pacsdb.public.location Generated by
SchemaSpy
Legend: SourceForge.net
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
pk int8 19
created_time timestamp 29,6
digest varchar 255  √  null
multi_ref int4 10  √  null
object_type int4 10
object_size int8 19
status int4 10
storage_id varchar 255
storage_path varchar 255
tsuid varchar 255  √  null
instance_fk int8 19  √  null
instance.pk fk_hjtlcwsvwihs4khh961d423e7 R
uidmap_fk int8 19  √  null
uidmap.pk fk_bfk5vl6eoxaf0hhwiu3rbgmkn R

Table contained 0 rows at Wed Nov 21 11:44 CET 2018

Indexes:
Column(s) Type Sort Constraint Name
pk Primary key Asc location_pkey
uidmap_fk Performance Asc fk_bfk5vl6eoxaf0hhwiu3rbgmkn
instance_fk Performance Asc fk_hjtlcwsvwihs4khh961d423e7
multi_ref Performance Asc uk_i1lnahmehau3r3j9pdyxg3p3y
storage_id + status Performance Asc/Asc uk_r3oh859i9osv3aluoc8dcx9wk

Close relationships  within of separation: