Table pvsadmin.public.npatproblem_npatcandidate 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
npatproblem_npatcandidate_id serial 10  √  nextval('npatproblem_npatcandidate_npatproblem_npatcandidate_id_seq'::regclass)
npatproblem_id bpchar 1  √  null
npatproblem.npatproblem_id npatproblem_npatcandidate__npatproblem_id_fk R
npatcandidate_id int4 10  √  null
npatcandidate.npatcandidate_id npatproblem_npatcandidate__npatcandidate_id_fk R

Table contained 233 rows at Tue Jan 03 04:46 MST 2017

Indexes:
Column(s) Type Sort Constraint Name Anomalies
npatproblem_npatcandidate_id Primary key Asc npatproblem_npatcandidate__pk  
npatproblem_id + npatcandidate_id Must be unique Asc/Asc npatproblem_npatcandidate__npatproblem_id_npatcandidate_id These unique columns are also nullable

Close relationships  within of separation: