Table pacsdb.public.instance 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
content_item.instance_fk fk_9kpe6whsov3ur9rph4ih2vi5a R
location.instance_fk fk_hjtlcwsvwihs4khh961d423e7 R
verify_observer.instance_fk fk_qjgrn9rfyyt6sv14utk9ijcfq R
availability int4 10
sr_complete varchar 255
content_date varchar 255
content_time varchar 255
created_time timestamp 29,6
inst_custom1 varchar 255
inst_custom2 varchar 255
inst_custom3 varchar 255
inst_no varchar 255
retrieve_aets varchar 255  √  null
sop_cuid varchar 255
sop_iuid varchar 255
updated_time timestamp 29,6
sr_verified varchar 255
version int8 19  √  null
dicomattrs_fk int8 19
dicomattrs.pk fk_jxfu47kwjk3kkkyrwewjw8a4n R
srcode_fk int8 19  √  null
code.pk fk_7w6f9bi2w91qr2abl6ddxnrwq R
reject_code_fk int8 19  √  null
code.pk fk_6pnwsvi69g5ypye6gjo26vn7e R
series_fk int8 19
series.pk fk_s4tgrew4sh4qxoupmk3gihtrk R

Table contained 18,290 rows at Wed Jun 29 14:02 CEST 2016

Indexes:
Column(s) Type Sort Constraint Name
pk Primary key Asc instance_pkey
series_fk + sop_iuid Must be unique Asc/Asc uk_247lgirehl8i2vuanyfjnuyjb
dicomattrs_fk Must be unique Asc uk_jxfu47kwjk3kkkyrwewjw8a4n

Close relationships  within of separation: