Table pacsdb.public.mwl_item 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
sps_station_aet.mwl_item_fk fk_js5xqyw5qa9rpttwmck14duow R
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.pk fk_6qj8tkh6ib9w2pjqwvqe23ko R
accno_issuer_fk int8 19  √  null
issuer.pk fk_ot32lpvialton54xqh636c4it R
patient_fk int8 19
patient.pk fk_vkxtls2wr17wgxnxj7b2fe32 R
perf_phys_name_fk int8 19  √  null
person_name.pk fk_44qwwvs50lgpog2cqmicxgt1f R

Table contained 0 rows at Fri Dec 13 14:14 CET 2019

Indexes:
Column(s) Type Sort Constraint Name
pk Primary key Asc mwl_item_pkey
perf_phys_name_fk Performance Asc fk_44qwwvs50lgpog2cqmicxgt1f
accno_issuer_fk Performance Asc fk_ot32lpvialton54xqh636c4it
patient_fk Performance Asc fk_vkxtls2wr17wgxnxj7b2fe32
sps_id Performance Asc uk_2odo3oah39o400thy9bf0rgv0
sps_status Performance Asc uk_3oigo76r1a7et491bkci96km8
dicomattrs_fk Must be unique Asc uk_6qj8tkh6ib9w2pjqwvqe23ko
sps_start_date Performance Asc uk_9oh3yd4prp9sfys4n0p2kd69y
updated_time Performance Asc uk_d0v5hjn1crha2nqbws4wj0yoj
study_iuid Performance Asc uk_fpfq8q514gsime2dl8oo773d4
req_proc_id Performance Asc uk_kedi0qimmvs83af3jxk471uxn
study_iuid + sps_id Must be unique Asc/Asc uk_lerlqlaghhcs0oaj5irux4qig
sps_start_time Performance Asc uk_m20xnkg1iqetifvuegehbhekm
accession_no Performance Asc uk_pw8h1b4sac2sr9estyqr82pcf
modality Performance Asc uk_q28149iaxebyt3de2h5sm2bgl

Close relationships  within of separation: