Table pacsdb.public.mwl_item 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
sps_station_aet
accession_no varchar 255
created_time timestamp 29,6
modality varchar 255
req_proc_id varchar 255
sps_id varchar 255
sps_start_date varchar 255
sps_start_time varchar 255
sps_status int4 10
study_iuid varchar 255
updated_time timestamp 29,6
version int8 19  √  null
dicomattrs_fk int8 19
dicomattrs
accno_issuer_fk int8 19  √  null
issuer
patient_fk int8 19
patient
perf_phys_name_fk int8 19  √  null
person_name

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

Indexes:
Column(s) Type Sort
pk Primary key Asc
perf_phys_name_fk Performance Asc
accno_issuer_fk Performance Asc
patient_fk Performance Asc
sps_id Performance Asc
sps_status Performance Asc
dicomattrs_fk Must be unique Asc
sps_start_date Performance Asc
updated_time Performance Asc
study_iuid Performance Asc
req_proc_id Performance Asc
study_iuid + sps_id Must be unique Asc/Asc
sps_start_time Performance Asc
accession_no Performance Asc
modality Performance Asc

Close relationships  within of separation: