Table pacsdb.public.ups_req 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
accession_no varchar 255
req_proc_id varchar 255
req_service varchar 255
study_iuid varchar 255
accno_issuer_fk int8 19  √  null
issuer.pk fk_gegm1c1ymem7tj2wcm0o7e0pu R
req_phys_name_fk int8 19  √  null
person_name.pk fk_kocdb2pxx2fymu1modhneb4xm R
ups_fk int8 19  √  null
ups.pk fk_7vt6m05r0hertks2fcngd5wn1 R

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

Indexes:
Column(s) Type Sort Constraint Name
pk Primary key Asc ups_req_pkey
ups_fk Performance Asc fk_7vt6m05r0hertks2fcngd5wn1
accno_issuer_fk Performance Asc fk_gegm1c1ymem7tj2wcm0o7e0pu
req_phys_name_fk Performance Asc fk_kocdb2pxx2fymu1modhneb4xm
req_proc_id Performance Asc uk_524vr0q4c0kvyjwov74eru44x
req_service Performance Asc uk_emsk27nclko11ph2tcj5vk7hg
study_iuid Performance Asc uk_hf0tly8umknn77civcsi0tdih
accession_no Performance Asc uk_rfium2ybikqm1f4xmi24mnv4u

Close relationships  within of separation: