| Column |
Type |
Size |
Nulls |
Auto |
Default |
Children |
Parents |
| measure_id |
serial |
10 |
|
√ |
nextval('measure_measure_id_seq'::regclass) |
|
|
| electiontype |
varchar |
2147483647 |
√ |
|
null |
|
|
| electiondate |
date |
13 |
√ |
|
null |
|
|
| state_id |
bpchar |
2 |
√ |
|
null |
|
| state.state_id
|
Implied Constraint R |
|
| code |
varchar |
2147483647 |
√ |
|
null |
|
|
| title |
varchar |
2147483647 |
√ |
|
null |
|
|
| url |
varchar |
2147483647 |
√ |
|
null |
|
|
| measuretext |
text |
2147483647 |
√ |
|
null |
|
|
| texturl |
varchar |
2147483647 |
√ |
|
null |
|
|
| summary |
text |
2147483647 |
√ |
|
null |
|
|
| summaryurl |
varchar |
2147483647 |
√ |
|
null |
|
|
| prourl |
varchar |
2147483647 |
√ |
|
null |
|
|
| conurl |
varchar |
2147483647 |
√ |
|
null |
|
|
| outcome |
varchar |
2147483647 |
√ |
|
null |
|
|
| source |
varchar |
2147483647 |
√ |
|
null |
|
|
| yes |
int4 |
10 |
√ |
|
null |
|
|
| no |
int4 |
10 |
√ |
|
null |
|
|
| measuretype_id |
bpchar |
1 |
√ |
|
null |
|
|
| congoutcome_id |
int2 |
5 |
√ |
|
null |
|
| congoutcome.congoutcome_id
|
measure__congoutcome_id_fk C |
|
| sourceurl |
varchar |
2147483647 |
√ |
|
null |
|
|
Table contained 1,039 rows at Tue Jan 03 04:46 MST 2017
|
