Table pacsdb.public.issuer 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
mpps.accno_issuer_fk fk_grl2idmms10qq4lhmh909jxtj R
mwl_item.accno_issuer_fk fk_ot32lpvialton54xqh636c4it R
mwl_item.admid_issuer_fk fk_9k8x73a91nd9q7ux7h5itkyh5 R
patient_id.issuer_fk fk_oo232lt89k1b5h8mberi9v152 R
series_req.accno_issuer_fk fk_se4n39as61wwf92ggbfc9yglo R
study.accno_issuer_fk fk_lp0rdx659kewq8qrqg702yfyv R
study.admid_issuer_fk fk_9fqno60wc3gr4376ov1xlfme4 R
ups.admission_issuer_fk fk_61tpdp9aoy98jwiif5wq82ia3 R
ups_req.accno_issuer_fk fk_gegm1c1ymem7tj2wcm0o7e0pu R
entity_id varchar 255  √  null
entity_uid varchar 255  √  null
entity_uid_type varchar 255  √  null

Table contained 0 rows at Fri Aug 06 17:54 CEST 2021

Indexes:
Column(s) Type Sort Constraint Name Anomalies
pk Primary key Asc issuer_pkey  
entity_id Performance Asc uk_gknfxd1vh283cmbg8ymia9ms8  
entity_uid + entity_uid_type Must be unique Asc/Asc uk_t1p7jajas0mu12sx8jvtp2y0f These unique columns are also nullable

Close relationships  within of separation: