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
admission_id varchar 255
created_time timestamp 29,6
institution varchar 255
department varchar 255
local_aet varchar 255
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
inst_code_fk int8 19  √  null
code
dept_code_fk int8 19  √  null
code
accno_issuer_fk int8 19  √  null
issuer
admid_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 Fri Aug 06 17:54 CEST 2021

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

Close relationships  within of separation: