| election_id |
int4 |
10 |
√ |
|
null |
|
|
| state_id |
bpchar |
2 |
√ |
|
null |
|
| state.state_id
|
Implied Constraint R |
|
| election_electionstage_id |
int4 |
10 |
√ |
|
null |
|
|
| election_electionstage_state_id |
bpchar |
2 |
√ |
|
null |
|
|
| officetype_id |
bpchar |
1 |
√ |
|
null |
|
|
| officelevel_id |
bpchar |
1 |
√ |
|
null |
|
|
| electionstage_id |
bpchar |
1 |
√ |
|
null |
|
|
| party_id |
int4 |
10 |
√ |
|
null |
|
|
| special |
bool |
1 |
√ |
|
null |
|
|
| election_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 |
|
|
| electionstage |
varchar |
2147483647 |
√ |
|
null |
|
|
| electionyear |
int2 |
5 |
√ |
|
null |
|
|
| electiondate |
date |
13 |
√ |
|
null |
|
|
| filingdeadline |
date |
13 |
√ |
|
null |
|
|
| majorfiling |
date |
13 |
√ |
|
null |
|
|
| independentfiling |
date |
13 |
√ |
|
null |
|
|
| thirdfiling |
date |
13 |
√ |
|
null |
|
|
| writeinfiling |
date |
13 |
√ |
|
null |
|
|
| electionname |
text |
2147483647 |
√ |
|
null |
|
|
| officetype_rank |
int2 |
5 |
√ |
|
null |
|
|
| officelevel_rank |
int2 |
5 |
√ |
|
null |
|
|
| electionstage_rank |
int2 |
5 |
√ |
|
null |
|
|
