Table pvsadmin.public.election_electionstage 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_electionstage_id serial 10  √  nextval('election_electionstage_id_seq'::regclass)
electionstage_candidate.election_electionstage_id electionstage_candidate__election_electionstage_id_fk C
election_id int4 10
election.election_id election_electionstage__election_id_fk C
electionstage_id bpchar 1
electionstage.electionstage_id Implied Constraint R
state_id bpchar 2
state.state_id election_electionstage__state_id_fk R
release_id int2 5  √  null
release.release_id election_electionstage__release_id R
candidaterelease_id int2 5  √  null
release.release_id election_electionstage__candidaterelease_id R
npatrelease_id int2 5  √  null
release.release_id election_electionstage__npatrelease_id R
resultrelease_id int2 5  √  null
release.release_id election_electionstage__resultrelease_id R
electiondate date 13  √  null
filingdeadline date 13  √  null
npatmailed bool 1 false
majorfiling date 13  √  null
independentfiling date 13  √  null
thirdfiling date 13  √  null
writeinfiling date 13  √  null
party_id int4 10  √  null
tentative bool 1  √  null
created timestamp 29,6  √  null
modified timestamp 29,6  √  null

Table contained 3,506 rows at Tue Jan 03 04:46 MST 2017

Indexes:
Column(s) Type Sort Constraint Name
election_electionstage_id Primary key Asc election_electionstage__pk
Performance election_electiondstage__electionyear
candidaterelease_id Performance Asc election_electionstage__candidaterelease_id
election_id Performance Asc election_electionstage__election_id
electiondate Performance Asc election_electionstage__electiondate
electionstage_id Performance Asc election_electionstage__electionstage_id
npatrelease_id Performance Asc election_electionstage__npatrelease_id
release_id Performance Asc election_electionstage__release_id
resultrelease_id Performance Asc election_electionstage__resultrelease_id
state_id Performance Asc election_electionstage__state_id

Close relationships  within of separation: