Table pacsdb.public.ups 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
rel_ups_perf_code
subscription
ups_req
admission_id varchar 255
created_time timestamp 29,6
expected_end_date_time varchar 255
input_readiness_state int4 10
performer_aet varchar 255  √  null
ups_state int4 10
replaced_iuid varchar 255
expiration_date_time varchar 255
start_date_time varchar 255
transaction_iuid varchar 255  √  null
updated_time timestamp 29,6
ups_iuid varchar 255
ups_label varchar 255
ups_priority int4 10
version int8 19  √  null
worklist_label varchar 255
dicomattrs_fk int8 19
dicomattrs
admission_issuer_fk int8 19  √  null
issuer
patient_fk int8 19
patient
station_class_fk int8 19  √  null
code
station_location_fk int8 19  √  null
code
station_name_fk int8 19  √  null
code
ups_code_fk int8 19  √  null
code

Table contained 0 rows at Mo. Dez. 14 16:13 MEZ 2020

Indexes:
Column(s) Type Sort
pk Primary key Asc
ups_code_fk Performance Asc
admission_issuer_fk Performance Asc
patient_fk Performance Asc
station_class_fk Performance Asc
station_name_fk Performance Asc
station_location_fk Performance Asc
expected_end_date_time Performance Asc
updated_time Performance Asc
dicomattrs_fk Must be unique Asc
worklist_label Performance Asc
input_readiness_state Performance Asc
ups_state Performance Asc
replaced_iuid Performance Asc
ups_label Performance Asc
expiration_date_time Performance Asc
ups_priority Performance Asc
start_date_time Performance Asc
ups_iuid Must be unique Asc
admission_id Performance Asc

Close relationships  within of separation: