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
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.pk fk_6qj8tkh6ib9w2pjqwvqe23ko R
inst_code_fk int8 19  √  null
code.pk fk_t4vpsywvy0axeutmdgc0ye3nk R
dept_code_fk int8 19  √  null
code.pk fk_hqecoo67sflk190dxyc0hnf0c R
accno_issuer_fk int8 19  √  null
issuer.pk fk_ot32lpvialton54xqh636c4it R
admid_issuer_fk int8 19  √  null
issuer.pk fk_9k8x73a91nd9q7ux7h5itkyh5 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 Aug 06 17:54 CEST 2021

Indexes:
Column(s) Type Sort Constraint Name
pk Primary key Asc mwl_item_pkey
perf_phys_name_fk Performance Asc fk_44qwwvs50lgpog2cqmicxgt1f
admid_issuer_fk Performance Asc fk_9k8x73a91nd9q7ux7h5itkyh5
dept_code_fk Performance Asc fk_hqecoo67sflk190dxyc0hnf0c
accno_issuer_fk Performance Asc fk_ot32lpvialton54xqh636c4it
inst_code_fk Performance Asc fk_t4vpsywvy0axeutmdgc0ye3nk
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
institution Performance Asc uk_8qkftk7n30hla3v1frep9vg2q
local_aet Performance Asc uk_9ockpkbetj7a97for0s1jhasi
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
department Performance Asc uk_ksy3uy0rvpis1sqqeojlet7lb
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
admission_id Performance Asc uk_tlkw80b7pbutfj19vh6et2vs7

Close relationships  within of separation: