Table pacsdb.public.study 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
rel_study_pcode.study_fk fk_mnahh8fh77d365m6w2x4x3f4q R
series.study_fk fk_1og1krtgxfh207rtqjg0r7pbd R
study_query_attrs.study_fk fk_sxccj81423w8o6w2tsb7nshy9 R
access_control_id varchar 255
access_time timestamp 29,6
accession_no varchar 255
created_time timestamp 29,6
failed_retrieves int4 10
failed_iuids varchar 4000  √  null
study_custom1 varchar 255
study_custom2 varchar 255
study_custom3 varchar 255
study_date varchar 255
study_desc varchar 255
study_id varchar 255
study_iuid varchar 255
study_time varchar 255
updated_time timestamp 29,6
version int8 19  √  null
dicomattrs_fk int8 19
dicomattrs.pk fk_5w0oynbw061mwu1rr9mrb6kj4 R
accno_issuer_fk int8 19  √  null
issuer.pk fk_lp0rdx659kewq8qrqg702yfyv R
patient_fk int8 19
patient.pk fk_e3fdaqhw7u60trs5aspf4sna9 R
ref_phys_name_fk int8 19  √  null
person_name.pk fk_49eet5qgcsb32ktsqrf1mj3x2 R
storage_ids varchar 255
rejection_state int4 10
expiration_date varchar 255  √  null

Table contained 359 rows at Wed Jun 29 14:02 CEST 2016

Indexes:
Column(s) Type Sort Constraint Name
pk Primary key Asc study_pkey
dicomattrs_fk Must be unique Asc uk_5w0oynbw061mwu1rr9mrb6kj4
storage_ids Performance Asc uk_fypbtohf5skbd3bkyd792a6dt
rejection_state Performance Asc uk_hwu9omd369ju3nufufxd3vof2
study_iuid Must be unique Asc uk_pt5qn20x278wb1f7p2t3lcxv

Close relationships  within of separation: