Table pacsdb.public.mpps 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
hl7psu_task.mpps_fk fk_pev4urgkk7id2h1ijhv8domjx R
ian_task.mpps_fk fk_1fuh251le2hid2byw90hd1mly R
accession_no varchar 255
created_time timestamp 29,6
pps_start_date varchar 255
pps_start_time varchar 255
sop_iuid varchar 255
pps_status int4 10
study_iuid varchar 255
updated_time timestamp 29,6
version int8 19  √  null
dicomattrs_fk int8 19
dicomattrs.pk fk_o49fec996jvdo31o7ysmsn9s2 R
discreason_code_fk int8 19  √  null
code.pk fk_nrigpgue611m33rao03nnfe5l R
accno_issuer_fk int8 19  √  null
issuer.pk fk_grl2idmms10qq4lhmh909jxtj R
patient_fk int8 19
patient.pk fk_ofg0lvfxad6r5oigw3y6da27u R

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

Indexes:
Column(s) Type Sort Constraint Name
pk Primary key Asc mpps_pkey
accno_issuer_fk Performance Asc fk_grl2idmms10qq4lhmh909jxtj
discreason_code_fk Performance Asc fk_nrigpgue611m33rao03nnfe5l
patient_fk Performance Asc fk_ofg0lvfxad6r5oigw3y6da27u
sop_iuid Must be unique Asc uk_cyqglxijg7kebbj6oj821yx4d
dicomattrs_fk Must be unique Asc uk_o49fec996jvdo31o7ysmsn9s2

Close relationships  within of separation: