Table pacsdb.public.mpps 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
ian_task
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
discreason_code_fk int8 19  √  null
code
accno_issuer_fk int8 19  √  null
issuer
patient_fk int8 19
patient

Table contained 0 rows at Thu Dec 22 15:46 CET 2016

Indexes:
Column(s) Type Sort
pk Primary key Asc
accno_issuer_fk Performance Asc
discreason_code_fk Performance Asc
patient_fk Performance Asc
sop_iuid Must be unique Asc
dicomattrs_fk Must be unique Asc

Close relationships  within of separation: