pacsdb
Database
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
mwl_item
0
rows
Columns
Related columns
Constraint
Comments
Search:
Column
Type
Size
Nulls
Auto
Default
Children
Parents
Comments
pk
int8
19
null
sps_station_aet
.mwl_item_fk
fk_js5xqyw5qa9rpttwmck14duow
R
accession_no
varchar
255
null
accno_entity_id
varchar
255
√
null
accno_entity_uid
varchar
255
√
null
accno_entity_uid_type
varchar
255
√
null
admission_id
varchar
255
null
admid_entity_id
varchar
255
√
null
admid_entity_uid
varchar
255
√
null
admid_entity_uid_type
varchar
255
√
null
created_time
timestamp
29,6
null
Showing 1 to 10 of 27 entries
Previous
1
2
3
Next
Indexes
Search:
Constraint Name
Type
Sort
Column(s)
mwl_item_pkey
Primary key
Asc
pk
fk_44qwwvs50lgpog2cqmicxgt1f
Performance
Asc
perf_phys_name_fk
fk_hqecoo67sflk190dxyc0hnf0c
Performance
Asc
dept_code_fk
fk_t4vpsywvy0axeutmdgc0ye3nk
Performance
Asc
inst_code_fk
fk_vkxtls2wr17wgxnxj7b2fe32
Performance
Asc
patient_fk
uk_2odo3oah39o400thy9bf0rgv0
Performance
Asc
sps_id
uk_3oigo76r1a7et491bkci96km8
Performance
Asc
sps_status
uk_6qj8tkh6ib9w2pjqwvqe23ko
Must be unique
Asc
dicomattrs_fk
uk_8qkftk7n30hla3v1frep9vg2q
Performance
Asc
institution
uk_9ockpkbetj7a97for0s1jhasi
Performance
Asc
local_aet
Showing 1 to 10 of 20 entries
Previous
1
2
Next
Relationships
Close relationships within degrees of separation
One
Two degrees
One implied
Two implied
