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
patient_id.issuer_fk fk_oo232lt89k1b5h8mberi9v152 R
series_req.accno_issuer_fk fk_se4n39as61wwf92ggbfc9yglo R
study.accno_issuer_fk fk_lp0rdx659kewq8qrqg702yfyv R
entity_id varchar 255  √  null
entity_uid varchar 255  √  null
entity_uid_type varchar 255  √  null

Table contained 0 rows at Thu Dec 21 12:28 CET 2017

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

Close relationships  within of separation: