Table pvsadmin.public.npatgroup 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
npatgroup_id varchar 2147483647
npatcandidate.npatgroup_id npatcandidate__npatgroup_id_fk R
npatgroup_state.npatgroup_id npatgroup_state__npatgroup_id_fk R
electionstage_id bpchar 1  √  null
electionstage.electionstage_id npatgroup__electionstage_id_fk R
npatgrouptype_id bpchar 1  √  null
npatgrouptype.npatgrouptype_id npatgroup__npatgrouptype_id_fk R
code varchar 2147483647  √  null
rank int2 5  √  null

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

Indexes:
Column(s) Type Sort Constraint Name Anomalies
npatgroup_id Primary key Asc npatgroup__pk  
code Must be unique Asc npatgroup__code This unique column is also nullable

Close relationships  within of separation: