Table pacsdb.public.instance Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents
pk int8 19
content_item
location
verify_observer
availability int4 10
sr_complete varchar 255
content_date varchar 255
content_time varchar 255
created_time timestamp 29,6
ext_retrieve_aet varchar 255  √  null
inst_custom1 varchar 255
inst_custom2 varchar 255
inst_custom3 varchar 255
inst_no int4 10  √  null
num_frames int4 10  √  null
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
srcode_fk int8 19  √  null
code
series_fk int8 19
series

Table contained 0 rows at Tue Jan 28 14:54 CET 2020

Indexes:
Column(s) Type Sort
pk Primary key Asc
srcode_fk Performance Asc
series_fk Performance Asc
series_fk + sop_iuid Must be unique Asc/Asc
content_date Performance Asc
sop_cuid Performance Asc
sop_iuid Performance Asc
inst_custom1 Performance Asc
sr_complete Performance Asc
dicomattrs_fk Must be unique Asc
inst_no Performance Asc
content_time Performance Asc
inst_custom3 Performance Asc
sr_verified Performance Asc
inst_custom2 Performance Asc

Close relationships  within of separation: