| election_candidate_id |
int4 |
10 |
√ |
|
null |
|
|
| election_id |
int4 |
10 |
√ |
|
null |
|
|
| electionstage_id |
bpchar |
1 |
√ |
|
null |
|
|
| election_electionstage_id |
int4 |
10 |
√ |
|
null |
|
|
| candidate_id |
int4 |
10 |
√ |
|
null |
|
|
| electionstage_candidate_id |
int4 |
10 |
√ |
|
null |
|
|
| office_id |
int2 |
5 |
√ |
|
null |
|
| office.office_id
|
Implied Constraint R |
|
| officetype_id |
bpchar |
1 |
√ |
|
null |
|
|
| state_id |
bpchar |
2 |
√ |
|
null |
|
| state.state_id
|
Implied Constraint R |
|
| election_electionstage_state_id |
bpchar |
2 |
√ |
|
null |
|
|
| districtname_id |
int2 |
5 |
√ |
|
null |
|
|
| electioncandidatestatus_id |
int2 |
5 |
√ |
|
null |
|
|
| electionstage_release_id |
int2 |
5 |
√ |
|
null |
|
|
| candidaterelease_id |
int2 |
5 |
√ |
|
null |
|
|
| npatrelease_id |
int2 |
5 |
√ |
|
null |
|
|
| resultrelease_id |
int2 |
5 |
√ |
|
null |
|
|
| npatmailed |
bool |
1 |
√ |
|
null |
|
|
| state |
varchar |
2147483647 |
√ |
|
null |
|
|
| office |
varchar |
2147483647 |
√ |
|
null |
|
|
| officecode |
varchar |
2147483647 |
√ |
|
null |
|
|
| officerank |
int2 |
5 |
√ |
|
null |
|
|
| officetitle |
varchar |
2147483647 |
√ |
|
null |
|
|
| officeshorttitle |
varchar |
2147483647 |
√ |
|
null |
|
|
| districtname |
varchar |
2147483647 |
√ |
|
null |
|
|
| districtrank |
int2 |
5 |
√ |
|
null |
|
|
| party_id |
int4 |
10 |
√ |
|
null |
|
|
| party |
varchar |
2147483647 |
√ |
|
null |
|
|
| ballotname |
varchar |
2147483647 |
√ |
|
null |
|
|
| electionyear |
int2 |
5 |
√ |
|
null |
|
|
| electionstage |
varchar |
2147483647 |
√ |
|
null |
|
|
| officetype |
varchar |
2147483647 |
√ |
|
null |
|
|
| status |
varchar |
2147483647 |
√ |
|
null |
|
|
| lowername |
varchar |
2147483647 |
√ |
|
null |
|
|
| ushousename |
varchar |
2147483647 |
√ |
|
null |
|
|
| electiondate |
date |
13 |
√ |
|
null |
|
|
