Table pvsadmin.public.election_candidate 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_candidate_id serial 10  √  nextval('election_candidate_id_seq'::regclass)
candidate_election_candidate.election_candidate_id candidate_election_candidate__election_candidate_id_fk C
contact_candidate.election_candidate_id contact_candidate__election_candidate_id_fk C
election_address.election_candidate_id election_address__election_candidate_id_fk C
election_webaddress.election_candidate_id election_webaddress__election_candidate_id_fk C
electionstage_candidate.election_candidate_id electionstage_candidate__election_candidate_id_fk C
endorse_candidate.election_candidate_id endorse_candidate__election_candidate_id_fk C
endorser_candidate.election_candidate_id endorser_candidate__election_candidate_id_fk C
endorsergroup_candidate.election_candidate_id endorsergroup_candidate__election_candidate_id_fk C
finance_candidate.election_candidate_id finance_candidate__election_candidate_id_fk R
misc_user_ballot.election_candidate_id misc_user_ballot_election_candidate_id_fkey R
npatcandidate.election_candidate_id npatcandidate__election_candidate_id_fk C
election_id int4 10
election.election_id election_candidate__election_id_fk C
candidate_id int4 10
candidate.candidate_id election_candidate__candidate_id_fk C
office_id int2 5
office.office_id election_candidate__office_id_fk R
state_id bpchar 2
state.state_id election_candidate__state_id_fk R
districtname_id int2 5  √  null
districtname.districtname_id election_candidate__districtname_id_fk R
parent_id int4 10  √  null
major bool 1  √  null
ballotname varchar 2147483647  √  null
created timestamp 29,6  √  null
modified timestamp 29,6  √  null

Table contained 196,095 rows at Tue Jan 03 04:46 MST 2017

Indexes:
Column(s) Type Sort Constraint Name
election_candidate_id Primary key Asc election_candidate_pk
candidate_id Performance Asc election_candidate__candidate_id
districtname_id Performance Asc election_candidate__districtname_id
election_id Performance Asc election_candidate__election_id
major Performance Asc election_candidate__major
office_id Performance Asc election_candidate__office_id
parent_id Performance Asc election_candidate__parent_id
state_id Performance Asc election_candidate__state_id

Close relationships  within of separation: