Table pvsadmin.public.election 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
election_id serial 10  √  nextval('election_id_seq'::regclass)
election_candidate.election_id election_candidate__election_id_fk C
election_districtname.election_id election_districtname__election_id_fk C
election_electionstage.election_id election_electionstage__election_id_fk C
endorse.election_id endorse__election_id_fk C
npatform_election.election_id npatform_election__election_id_fk C
vacancy.election_id vacancy__election_id_fk C
state_id bpchar 2
state.state_id election__state_id_fk R
officetype_id bpchar 1
officetype.officetype_id Implied Constraint R
special bool 1 false
electionyear int2 5
created timestamp 29,6  √  null
modified timestamp 29,6  √  null

Table contained 1,848 rows at Tue Jan 03 04:46 MST 2017

Indexes:
Column(s) Type Sort Constraint Name
election_id Primary key Asc election_pk
electionyear Performance Asc election__electionyear
officetype_id Performance Asc election__officetype_id
state_id Performance Asc election__state_id

Close relationships  within of separation: