SchemaSpy Analysis of pvsadmin.public - Columns Generated by
SchemaSpy
Generated by SchemaSpy on Tue Jan 03 04:46 MST 2017
Legend: SourceForge.net
Primary key columns
Columns with indexes
 

pvsadmin.public contains 1737 columns - click on heading to sort:
Table Column Type Size Nulls Auto Default Comments
additional active bool 1  √  null
additional additional_id serial 10  √  nextval('additional_id_seq'::regclass)
additional name varchar 2147483647 ''::character varying
additional_candidate actext varchar 2147483647 ''::character varying
additional_candidate additional_candidate_id serial 10  √  nextval('additional_candidate_id_seq'::regclass)
additional_candidate additional_id int4 10
additional_candidate candidate_id int4 10
additional_candidate_category additional_candidate_category_id serial 10  √  nextval('additional_candidate_category_additional_candidate_category_seq'::regclass)
additional_candidate_category additional_candidate_id int4 10
additional_candidate_category category_id int2 5
additional_candidate_tag additional_candidate_id int4 10
additional_candidate_tag additional_candidate_tag_id serial 10  √  nextval('additional_candidate_tag_additional_candidate_tag_id_seq'::regclass)
additional_candidate_tag tag_id int4 10
additional_category additional_category_id serial 10  √  nextval('additional_category_additional_category_id_seq'::regclass)
additional_category additional_id int4 10
additional_category category_id int2 5
additional_tag additional_id int4 10  √  null
additional_tag additional_tag_id serial 10  √  nextval('additional_tag_additional_tag_id_seq'::regclass)
additional_tag tag_id int4 10  √  null
addr2zip addr2zip_id varchar 2147483647
addr2zip building_or_firm_name varchar 2147483647  √  null
addr2zip county_code int2 5  √  null
addr2zip municipality_key varchar 2147483647  √  null
addr2zip primary_address_high varchar 2147483647  √  null
addr2zip primary_address_low varchar 2147483647  √  null
addr2zip primary_address_parity varchar 2147483647  √  null
addr2zip record_type bpchar 1  √  null
addr2zip secondary_address varchar 2147483647  √  null
addr2zip secondary_address_high varchar 2147483647  √  null
addr2zip secondary_address_low varchar 2147483647  √  null
addr2zip secondary_address_parity bpchar 1  √  null
addr2zip state_id bpchar 2  √  null
addr2zip street_direction varchar 2147483647  √  null
addr2zip street_name varchar 2147483647  √  null
addr2zip street_post_direction varchar 2147483647  √  null
addr2zip street_suffix varchar 2147483647  √  null
addr2zip urbanization_key varchar 2147483647  √  null
addr2zip zip4_high int2 5  √  null
addr2zip zip4_low int2 5  √  null
addr2zip zip5 int4 10  √  null
addresstype addcity bool 1 false
addresstype addresstype_id int2 5
addresstype name varchar 2147483647 ''::character varying
addresstype rank int2 5  √  null
auth_group id serial 10  √  nextval('auth_group_id_seq'::regclass)
auth_group name varchar 80
auth_group_permissions group_id int4 10
auth_group_permissions id serial 10  √  nextval('auth_group_permissions_id_seq'::regclass)
auth_group_permissions permission_id int4 10
auth_permission codename varchar 100
auth_permission content_type_id int4 10
auth_permission id serial 10  √  nextval('auth_permission_id_seq'::regclass)
auth_permission name varchar 255
auth_user date_joined timestamptz 35,6
auth_user email varchar 254
auth_user first_name varchar 30
auth_user id serial 10  √  nextval('auth_user_id_seq'::regclass)
auth_user is_active bool 1
auth_user is_staff bool 1
auth_user is_superuser bool 1
auth_user last_login timestamptz 35,6  √  null
auth_user last_name varchar 30
auth_user password varchar 128
auth_user username varchar 30
auth_user_groups group_id int4 10
auth_user_groups id serial 10  √  nextval('auth_user_groups_id_seq'::regclass)
auth_user_groups user_id int4 10
auth_user_user_permissions id serial 10  √  nextval('auth_user_user_permissions_id_seq'::regclass)
auth_user_user_permissions permission_id int4 10
auth_user_user_permissions user_id int4 10
biotext biotext text 2147483647  √  null
biotext biotext_id serial 10  √  nextval('biotext_biotext_id_seq'::regclass)
biotext biotype_id int2 5  √  null
biotext officelevel_id bpchar 1  √  null
biotext_candidate biotext_id int4 10  √  null
biotext_candidate candidate_id int4 10  √  null
biotext_candidate officelevel_id bpchar 1  √  null
biotext_category biotext_category_id serial 10  √  nextval('biotext_category_biotext_category_id_seq'::regclass)
biotext_category biotext_id int4 10
biotext_category category_id int2 5
biotext_tag biotext_id int4 10
biotext_tag biotext_tag_id serial 10  √  nextval('biotext_tag_biotext_tag_id_seq'::regclass)
biotext_tag tag_id int4 10
biotextlocking accessed timestamp 29,6  √  null
biotextlocking accessedby varchar 2147483647  √  null
biotextlocking biotext_id int4 10  √  null
biotextlocking committed bool 1 false
biotype biotype_id int2 5
biotype experiencetype_id bpchar 1  √  null
biotype name text 2147483647  √  null
candidate bioformyear int2 5  √  null
candidate bioid varchar 2147483647  √  null
candidate birthdate varchar 2147483647 ''::character varying
candidate birthplace varchar 2147483647 ''::character varying
candidate callnote text 2147483647 ''::text
candidate candidate_id serial 10  √  nextval('candidate_id_seq'::regclass)
candidate candidatepreferredname_id bpchar 1 'F'::bpchar
candidate candidatestatus_id int2 5 1
candidate candidatetitle_id int2 5 0
candidate caucus text 2147483647  √  ''::text
candidate created timestamp 29,6  √  null
candidate education text 2147483647  √  ''::text
candidate family text 2147483647 ''::text
candidate fecid varchar 2147483647 ''::bpchar
candidate firstname varchar 2147483647 ''::character varying
candidate gender bpchar 1 ''::bpchar
candidate homecity varchar 2147483647 ''::character varying
candidate lastname varchar 2147483647 ''::character varying
candidate middlename varchar 2147483647 ''::character varying
candidate modified timestamp 29,6  √  null
candidate nickname varchar 2147483647 ''::character varying
candidate orgmember text 2147483647  √  ''::text
candidate password varchar 2147483647  √  null
candidate photourl varchar 2147483647 ''::character varying
candidate political text 2147483647  √  ''::text
candidate profession text 2147483647  √  ''::text
candidate pronunciation varchar 2147483647 ''::character varying
candidate release_id int2 5 2
candidate religion text 2147483647 ''::text
candidate specialmsg text 2147483647 ''::text
candidate state_id bpchar 2 'NA'::bpchar
candidate suffix varchar 2147483647 ''::character varying
candidate_election_candidate candidate_election_candidate_id serial 10  √  nextval('candidate_election_candidate_candidate_election_candidate_i_seq'::regclass)
candidate_election_candidate candidate_id int4 10
candidate_election_candidate election_candidate_id int4 10
candidatepreferredname candidatepreferredname_id bpchar 1
candidatepreferredname name varchar 2147483647  √  null
candidatestatus candidatestatus_id int2 5  √  nextval(('candidatestatus_id_seq'::text)::regclass)
candidatestatus name varchar 2147483647  √  null
candidatetitle candidatetitle_id int2 5  √  nextval(('candidatestatus_id_seq'::text)::regclass)
candidatetitle title varchar 2147483647  √  null
catcode_category catcode_category_id serial 10  √  nextval('catcode_category_catcode_category_id_seq1'::regclass)
catcode_category category_id int4 10
catcode_category finance_catcode_id int4 10
category category_id int2 5  √  nextval(('category_id_seq'::text)::regclass)
category description text 2147483647  √  null
category key bool 1 false
category name varchar 2147483647
category rank int2 5  √  null
category release_id int2 5  √  null
category_category category_category_id serial 10  √  nextval('category_category_category_category_id_seq'::regclass)
category_category category_id int4 10
category_category parent_id int4 10
category_released released_category_id int2 5  √  null
category_released unreleased_category_id int2 5  √  null
category_released_new released_category_id int2 5  √  null
category_released_new unreleased_category_id int2 5  √  null
category_section category_id int2 5
category_section category_section_id int2 5  √  nextval('category_section_id_seq'::regclass)
category_section section_id bpchar 1
category_tag category_id int4 10  √  null
category_tag category_tag_id serial 10  √  nextval('category_tag_category_tag_id_seq'::regclass)
category_tag tag_id int4 10  √  null
committee active bool 1 true
committee address1 varchar 2147483647 ''::character varying
committee address2 varchar 2147483647 ''::character varying
committee city varchar 2147483647 ''::character varying
committee committee_id serial 10  √  nextval('committee_id_seq'::regclass)
committee committeetype_id bpchar 1
committee email varchar 2147483647 ''::character varying
committee fax varchar 2147483647 ''::character varying
committee jurisdiction text 2147483647 ''::text
committee name varchar 2147483647 ''::character varying
committee parent_id int4 10
committee phone varchar 2147483647 ''::character varying
committee special bool 1  √  null
committee staffcontact varchar 2147483647 ''::character varying
committee state bpchar 2  √  null
committee state_id bpchar 2
committee url varchar 2147483647 ''::character varying
committee zip varchar 2147483647 ''::character varying
committee_archive active bool 1 true
committee_archive address1 varchar 2147483647 ''::character varying
committee_archive address2 varchar 2147483647 ''::character varying
committee_archive city varchar 2147483647 ''::character varying
committee_archive committee_id int4 10
committee_archive committeetype_id bpchar 1
committee_archive email varchar 2147483647 ''::character varying
committee_archive fax varchar 2147483647 ''::character varying
committee_archive jurisdiction text 2147483647 ''::text
committee_archive name varchar 2147483647 ''::character varying
committee_archive parent_id int4 10
committee_archive phone varchar 2147483647 ''::character varying
committee_archive special bool 1  √  null
committee_archive staffcontact varchar 2147483647 ''::character varying
committee_archive state bpchar 2  √  null
committee_archive state_id bpchar 2
committee_archive url varchar 2147483647 ''::character varying
committee_archive zip varchar 2147483647 ''::character varying
committee_candidate committee_candidate_id serial 10  √  nextval('committee_candidate_id_seq'::regclass)
committee_candidate committee_id int4 10
committee_candidate committeeposition_id bpchar 1  √  null
committee_candidate created timestamp 29,6  √  null
committee_candidate modified timestamp 29,6  √  null
committee_candidate office_candidate_id int4 10
committee_candidate termend flexdate 2147483647  √  null
committee_candidate termstart flexdate 2147483647  √  null
committee_candidate_archive committee_candidate_id int4 10
committee_candidate_archive committee_id int4 10
committee_candidate_archive committeeposition_id bpchar 1  √  null
committee_candidate_archive office_candidate_id int4 10
committee_category category_id int2 5
committee_category committee_category_id serial 10  √  nextval('committee_category_committee_category_id_seq'::regclass)
committee_category committee_id int4 10
committee_positions active bool 1  √  null
committee_positions candidate_id int4 10  √  null
committee_positions committee_id int4 10  √  null
committee_positions committee_name varchar 2147483647  √  null
committee_positions committee_position varchar 2147483647  √  null
committee_positions firstname varchar 2147483647  √  null
committee_positions lastname varchar 2147483647  √  null
committee_positions office_candidate_id int4 10  √  null
committee_positions state_id bpchar 2  √  null
committee_tag committee_id int4 10
committee_tag committee_tag_id serial 10  √  nextval('committee_tag_committee_tag_id_seq'::regclass)
committee_tag tag_id int4 10
committeeposition committeeposition_id bpchar 1
committeeposition name varchar 2147483647 ''::character varying
committeeposition rank int2 5  √  null
committeetype committeetype_id bpchar 1
committeetype name varchar 2147483647
congaction code varchar 2147483647  √  null
congaction congaction_id bpchar 1
congaction congactiontype_id bpchar 1  √  null
congaction name varchar 2147483647
congaction rank int2 5
congactiontype congactiontype_id bpchar 1
congactiontype name varchar 2147483647
congcategory congcategory_id serial 10  √  nextval('congcategory_id_seq'::regclass)
congcategory_category category_id int2 5
congcategory_category congcategory_category_id serial 10  √  nextval('congcategory_category_id_seq'::regclass)
congcategory_category congcategory_id int4 10
congcategory_tag congcategory_id int4 10
congcategory_tag congcategory_tag_id serial 10  √  nextval('congcategory_tag_congcategory_tag_id_seq'::regclass)
congcategory_tag tag_id int4 10
congdoc congdoc_id serial 10  √  nextval('congdoc_congdoc_id_seq'::regclass)
congdoc congdocgroup_id int4 10
congdoc description text 2147483647 ''::text
congdoc filename text 2147483647  √  null
congdoc name text 2147483647 ''::text
congdoc rank int2 5  √  null
congdocgroup congdocgroup_id serial 10  √  nextval('congdocgroup_congdocgroup_id_seq'::regclass)
conghighlight conghighlight_id serial 10  √  nextval('conghighlight_id_seq'::regclass)
conghighlight highlight text 2147483647
conglevel conglevel_id bpchar 1
conglevel name varchar 2147483647
conglevel rank int2 5
conglevel_office conglevel_id bpchar 1
conglevel_office conglevel_office_id int2 5  √  nextval(('conglevel_office_id_seq'::text)::regclass)
conglevel_office office_id int2 5
conglevel_office stateleg bool 1
congnote congnote_id int2 5  √  nextval(('congnote_id_seq'::text)::regclass)
congnote name varchar 2147483647
congnote note varchar 2147483647
congnote_congress congnote_congress_id serial 10  √  nextval('congnote_congress_id_seq'::regclass)
congnote_congress congnote_id int2 5
congnote_congress congress_id int4 10
congnote_stage congnote_id int2 5
congnote_stage congnote_stage_id serial 10  √  nextval('congnote_stage_id_seq'::regclass)
congnote_stage congstage_id int2 5
congnote_state congnote_id int2 5
congnote_state congnote_state_id int2 5  √  nextval(('congnote_state_id_seq'::text)::regclass)
congnote_state state_id bpchar 2
congnote_status congnote_id int2 5
congnote_status congnote_status_id serial 10  √  nextval('congnote_status_id_seq'::regclass)
congnote_status congstatus_id int4 10
congnote_type congnote_id int2 5
congnote_type congnote_type_id serial 10  √  nextval('congnote_type_id_seq'::regclass)
congnote_type congtype_id bpchar 1
congofficialsynopsis congofficialsynopsis_id serial 10  √  nextval('congofficialsynopsis_id_seq'::regclass)
congofficialsynopsis officialsynopsis text 2147483647
congofficialtitle congofficialtitle_id serial 10  √  nextval('congofficialtitle_id_seq'::regclass)
congofficialtitle officialtitle text 2147483647
congoutcome congoutcome_id int2 5  √  nextval(('congoutcome_id_seq'::text)::regclass)
congoutcome name varchar 2147483647
congoutcome rank int2 5
congoutcometext congoutcometext_id int2 5  √  nextval('congoutcometext_id_seq'::regclass)
congoutcometext outcometext varchar 2147483647  √  null
congprefix congprefix_id int2 5  √  nextval(('congprefix_id_seq'::text)::regclass)
congprefix name varchar 2147483647
congprefix prefix varchar 2147483647
congprefix_state congprefix_id int2 5
congprefix_state congprefix_state_id int2 5  √  nextval(('congprefix_state_id_seq'::text)::regclass)
congprefix_state state_id bpchar 2
congress billnumber varchar 2147483647
congress congress_id serial 10  √  nextval('congress_id_seq'::regclass)
congress congtype_id bpchar 1
congress law varchar 2147483647 ''::character varying
congress parent_id int4 10  √  null
congress path ltree 2147483647 text2ltree((currval('congress_id_seq'::regclass))::text)
congress release_id int2 5 0
congress state_id bpchar 2
congress url varchar 2147483647 ''::character varying
congstage congstage_id int2 5  √  nextval(('congstage_id_seq'::text)::regclass)
congstage name varchar 2147483647
congstage rank int2 5
congstage voting bool 1 false
congstatus congcategory_id int4 10  √  null
congstatus congdocgroup_id int4 10  √  null
congstatus conghighlight_id int4 10  √  null
congstatus conglevel_id bpchar 1
congstatus congofficialsynopsis_id int4 10  √  null
congstatus congofficialtitle_id int4 10  √  null
congstatus congoutcome_id int2 5  √  null
congstatus congress_id int4 10
congstatus congstage_id int2 5
congstatus congstatus_id serial 10  √  nextval('congstatus_id_seq'::regclass)
congstatus congsynopsis_id int4 10  √  null
congstatus congtext_id int4 10  √  null
congstatus congtitle_id int4 10  √  null
congstatus created timestamp 29,6  √  null
congstatus keyvote bool 1 false
congstatus modified timestamp 29,6  √  null
congstatus nay int2 5  √  null
congstatus rank int2 5  √  null
congstatus release_id int2 5 0
congstatus rollnumber int2 5  √  null
congstatus statusdate date 13
congstatus voicevote bool 1 false
congstatus yea int2 5  √  null
congstatus_candidate congaction_id bpchar 1
congstatus_candidate congstatus_candidate_id serial 10  √  nextval('congstatus_candidate_id_seq'::regclass)
congstatus_candidate congstatus_id int4 10
congstatus_candidate office_candidate_id int4 10
congstatus_committee committee_id int4 10
congstatus_committee congaction_id bpchar 1  √  null
congstatus_committee congstatus_committee_id serial 10  √  nextval('congstatus_committee_id_seq'::regclass)
congstatus_committee congstatus_id int4 10
congstatus_tag congstatus_id int4 10  √  null
congstatus_tag congstatus_tag_id serial 10  √  nextval('congstatus_tag_congstatus_tag_id_seq'::regclass)
congstatus_tag tag_id int4 10  √  null
congstatus_vetotext congstatus_id int4 10
congstatus_vetotext congstatus_vetotext_id serial 10  √  nextval('congstatus_vetotext_id_seq'::regclass)
congstatus_vetotext congvetotext_id int4 10
congsynopsis congsynopsis_id serial 10  √  nextval('congsynopsis_id_seq'::regclass)
congsynopsis synopsis text 2147483647
congtext congtext text 2147483647  √  null
congtext congtext_id serial 10  √  nextval('congtext_id_seq'::regclass)
congtext name text 2147483647  √  null
congtext path varchar 2147483647  √  null
congtitle congtitle_id serial 10  √  nextval('congtitle_id_seq'::regclass)
congtitle title varchar 2147483647
congtools conglevel_id bpchar 1
congtools congoutcome_id int2 5
congtools congoutcometext_id int2 5
congtools congstage_id int2 5
congtools congtools_id serial 10  √  nextval('congtools_id_seq'::regclass)
congtools congtype_id bpchar 1
congtools rank int2 5  √  null
congtype congtype_id bpchar 1
congtype name varchar 2147483647
congvetotext congvetotext_id serial 10  √  nextval('congvetotext_id_seq'::regclass)
congvetotext path varchar 2147483647
contact_candidate candidate_id int4 10
contact_candidate contact_candidate_id serial 10  √  nextval('contact_candidate_id_seq'::regclass)
contact_candidate contactmode_id int2 5
contact_candidate contactoutcome_id int2 5
contact_candidate contactstring varchar 2147483647 ''::character varying
contact_candidate contacttype_id int2 5
contact_candidate date timestamptz 35,6 now()
contact_candidate election_candidate_id int4 10  √  null
contact_candidate initiated bool 1 true
contact_candidate message text 2147483647 ''::character varying
contact_candidate name varchar 2147483647 ''::character varying
contact_candidate notable bool 1 false
contact_candidate note text 2147483647 ''::text
contact_candidate title varchar 2147483647 ''::character varying
contact_candidate username varchar 2147483647 (-1)
contactmode contactmode_id int2 5  √  nextval(('contactmode_id_seq'::text)::regclass)
contactmode name varchar 2147483647
contactoutcome contactoutcome_id int2 5  √  nextval(('contactoutcome_id_seq'::text)::regclass)
contactoutcome name varchar 2147483647
contacttype contacttype_id int2 5  √  nextval(('contacttype_id_seq'::text)::regclass)
contacttype name varchar 2147483647
contacttype rank int2 5  √  null
county county_id int2 5
county local_id int4 10  √  null
county name varchar 2147483647
county statecode int2 5
ctystate city_abbr varchar 2147483647  √  null
ctystate city_name varchar 2147483647
ctystate city_state_key varchar 2147483647
ctystate county_name varchar 2147483647  √  null
ctystate county_no int4 10  √  null
ctystate ctystate_id serial 10  √  nextval('ctystate_ctystate_id_seq'::regclass)
ctystate preferred_key varchar 2147483647  √  null
ctystate preferred_name varchar 2147483647  √  null
ctystate state_id varchar 2147483647
ctystate zip5 int4 10
degree degree_id serial 10  √  nextval('degree_degree_id_seq'::regclass)
degree name text 2147483647  √  null
degree rank int2 5  √  null
district district_id serial 10  √  nextval('district_id_seq'::regclass)
district districtname_id int2 5
district office_id int2 5
district state_id bpchar 2
district zip2districtcode int2 5  √  null
district zip2redistrictcode int2 5  √  null
districtname districtname_id int2 5  √  nextval('districtname_id_seq'::regclass)
districtname name varchar 2147483647
districtname rank int2 5  √  null
districttype districttype_id bpchar 1
districttype name varchar 2147483647
django_admin_log action_flag int2 5
django_admin_log action_time timestamptz 35,6
django_admin_log change_message text 2147483647
django_admin_log content_type_id int4 10  √  null
django_admin_log id serial 10  √  nextval('django_admin_log_id_seq'::regclass)
django_admin_log object_id text 2147483647  √  null
django_admin_log object_repr varchar 200
django_admin_log user_id int4 10
django_content_type app_label varchar 100
django_content_type id serial 10  √  nextval('django_content_type_id_seq'::regclass)
django_content_type model varchar 100
django_migrations app varchar 255
django_migrations applied timestamptz 35,6
django_migrations id serial 10  √  nextval('django_migrations_id_seq'::regclass)
django_migrations name varchar 255
django_session expire_date timestamptz 35,6
django_session session_data text 2147483647
django_session session_key varchar 40
education candidate_id int4 10
education degree text 2147483647  √  null
education education_id serial 10  √  nextval('education_education_id_seq'::regclass)
education field text 2147483647  √  null
education fulltext text 2147483647  √  null
education gpa numeric 2,1  √  null
education graduated bool 1  √  null
education school text 2147483647  √  null
education span text 2147483647  √  null
education_category category_id int4 10  √  null
education_category education_category_id serial 10  √  nextval('education_category_education_category_id_seq'::regclass)
education_category education_id int4 10  √  null
education_tag education_id int4 10  √  null
education_tag education_tag_id serial 10  √  nextval('education_tag_education_tag_id_seq'::regclass)
education_tag tag_id int4 10  √  null
election created timestamp 29,6  √  null
election election_id serial 10  √  nextval('election_id_seq'::regclass)
election electionyear int2 5
election modified timestamp 29,6  √  null
election officetype_id bpchar 1
election special bool 1 false
election state_id bpchar 2
election_address address varchar 2147483647  √  null
election_address addresstype_id int2 5
election_address city varchar 2147483647  √  null
election_address contactname varchar 2147483647  √  null
election_address contacttitle varchar 2147483647  √  null
election_address election_address_id serial 10  √  nextval('election_address_id_seq'::regclass)
election_address election_candidate_id int4 10
election_address fax1 varchar 2147483647  √  null
election_address fax2 varchar 2147483647  √  null
election_address note text 2147483647  √  null
election_address npataddress bool 1  √  null
election_address phone1 varchar 2147483647  √  null
election_address phone2 varchar 2147483647  √  null
election_address rank int2 5  √  null
election_address state bpchar 2  √  null
election_address tollfree varchar 2147483647  √  null
election_address ttyd varchar 2147483647  √  null
election_address zip varchar 2147483647  √  null
election_candidate ballotname varchar 2147483647  √  null
election_candidate candidate_id int4 10
election_candidate created timestamp 29,6  √  null
election_candidate districtname_id int2 5  √  null
election_candidate election_candidate_id serial 10  √  nextval('election_candidate_id_seq'::regclass)
election_candidate election_id int4 10
election_candidate major bool 1  √  null
election_candidate modified timestamp 29,6  √  null
election_candidate office_id int2 5
election_candidate parent_id int4 10  √  null
election_candidate state_id bpchar 2
election_districtname districtname_id int2 5
election_districtname election_districtname_id serial 10  √  nextval('election_district_id_seq'::regclass)
election_districtname election_id int4 10
election_districtname state_id bpchar 2
election_electionstage candidaterelease_id int2 5  √  null
election_electionstage created timestamp 29,6  √  null
election_electionstage election_electionstage_id serial 10  √  nextval('election_electionstage_id_seq'::regclass)
election_electionstage election_id int4 10
election_electionstage electiondate date 13  √  null
election_electionstage electionstage_id bpchar 1
election_electionstage filingdeadline date 13  √  null
election_electionstage independentfiling date 13  √  null
election_electionstage majorfiling date 13  √  null
election_electionstage modified timestamp 29,6  √  null
election_electionstage npatmailed bool 1 false
election_electionstage npatrelease_id int2 5  √  null
election_electionstage party_id int4 10  √  null
election_electionstage release_id int2 5  √  null
election_electionstage resultrelease_id int2 5  √  null
election_electionstage state_id bpchar 2
election_electionstage tentative bool 1  √  null
election_electionstage thirdfiling date 13  √  null
election_electionstage writeinfiling date 13  √  null
election_webaddress addresstype_id int2 5
election_webaddress election_candidate_id int4 10  √  null
election_webaddress election_webaddress_id serial 10  √  nextval('election_webaddress_id_seq'::regclass)
election_webaddress webaddress varchar 2147483647  √  null
election_webaddress webaddresstype_id int2 5
electioncandidatestatus display bool 1  √  null
electioncandidatestatus electioncandidatestatus_id int2 5  √  nextval(('electioncandidatestatus_id_seq'::text)::regclass)
electioncandidatestatus name varchar 2147483647 ''::text
electionoffice address varchar 2147483647  √  null
electionoffice city varchar 2147483647  √  null
electionoffice electionoffice_id serial 10  √  nextval('electionoffice_electionoffice_id_seq'::regclass)
electionoffice email varchar 2147483647  √  null
electionoffice fax varchar 2147483647  √  null
electionoffice hours varchar 2147483647  √  null
electionoffice name varchar 2147483647  √  null
electionoffice phone1 varchar 2147483647  √  null
electionoffice phone2 varchar 2147483647  √  null
electionoffice state bpchar 2
electionoffice state_id bpchar 2
electionoffice tdd varchar 2147483647  √  null
electionoffice website varchar 2147483647  √  null
electionoffice zip varchar 2147483647  √  null
electionstage electionstage_id bpchar 1
electionstage name varchar 2147483647  √  null
electionstage rank int2 5  √  null
electionstage_candidate created timestamp 29,6  √  null
electionstage_candidate delegate int2 5  √  null
electionstage_candidate election_candidate_id int4 10
electionstage_candidate election_electionstage_id int4 10
electionstage_candidate electioncandidatestatus_id int2 5
electionstage_candidate electionstage_candidate_id serial 10  √  nextval('electionstage_candidate_id_seq'::regclass)
electionstage_candidate modified timestamp 29,6  √  null
electionstage_candidate votecount int4 10  √  null
electionstage_candidate votepercent numeric 16,4  √  null
electionstage_candidate_party electionstage_candidate_id int4 10
electionstage_candidate_party electionstage_candidate_party_id serial 10  √  nextval('electionstage_candidate_party_id_seq'::regclass)
electionstage_candidate_party party_id int4 10
endorse created timestamp 29,6  √  null
endorse election_id int4 10
endorse endorse_id serial 10  √  nextval(('endorse_id_seq'::text)::regclass)
endorse modified timestamp 29,6  √  null
endorse release_id int2 5 0
endorse sig_id int4 10
endorse_candidate election_candidate_id int4 10  √  null
endorse_candidate endorse_candidate_id serial 10  √  nextval(('endorse_candidate_id_seq'::text)::regclass)
endorse_candidate endorse_id int4 10
endorser endorser_id serial 10  √  nextval('endorser_endorser_id_seq'::regclass)
endorser endorsertype_id bpchar 1  √  null
endorser name varchar 2147483647  √  null
endorser party_id int4 10  √  null
endorser profession varchar 2147483647  √  null
endorser state_id bpchar 2  √  null
endorser_candidate election_candidate_id int4 10
endorser_candidate endorser_candidate_id serial 10  √  nextval('endorser_candidate_endorser_candidate_id_seq'::regclass)
endorser_candidate endorser_id int4 10
endorsergroup endorsergroup_id serial 10  √  nextval('endorsergroup_endorsergroup_id_seq'::regclass)
endorsergroup endorsertype_id bpchar 1  √  null
endorsergroup name varchar 2147483647  √  null
endorsergroup state_id bpchar 2  √  null
endorsergroup_candidate election_candidate_id int4 10
endorsergroup_candidate endorsergroup_candidate_id serial 10  √  nextval('endorsergroup_candidate_endorsergroup_candidate_id_seq'::regclass)
endorsergroup_candidate endorsergroup_id int4 10
endorsertype endorsertype_id bpchar 1
endorsertype name varchar 2147483647  √  null
etl_file created timestamp 29,6  √  now()
etl_file errors text 2147483647  √  null
etl_file etl_file_id serial 10  √  nextval('etl_file_etl_file_id_seq'::regclass)
etl_file etl_job_id int4 10  √  null
etl_file file_system_path varchar 2147483647  √  null
etl_file name varchar 2147483647  √  null
etl_file original_name varchar 2147483647  √  null
etl_job completed timestamp 29,6  √  null
etl_job created timestamp 29,6  √  now()
etl_job errors text 2147483647  √  null
etl_job etl_job_id serial 10  √  nextval('etl_job_etl_job_id_seq'::regclass)
etl_job etl_status_id int2 5  √  null
etl_job etl_type_id int4 10  √  null
etl_job started timestamp 29,6  √  null
etl_sigratings_files created_datetime timestamp 29,6  √  now()
etl_sigratings_files etl_sigratings_files_id serial 10  √  nextval('etl_sigratings_files_etl_sigratings_files_id_seq'::regclass)
etl_sigratings_files etl_sigratings_harvest_jobs_id int4 10  √  null
etl_sigratings_files file_system_path varchar 2147483647  √  null
etl_sigratings_files name varchar 2147483647  √  null
etl_sigratings_files original_name varchar 2147483647  √  null
etl_sigratings_harvest_jobs completed_datetime timestamp 29,6  √  null
etl_sigratings_harvest_jobs created_datetime timestamp 29,6  √  now()
etl_sigratings_harvest_jobs errors varchar 2147483647  √  null
etl_sigratings_harvest_jobs etl_sigratings_harvest_jobs_id serial 10  √  nextval('etl_sigratings_harvest_jobs_etl_sigratings_harvest_jobs_id_seq'::regclass)
etl_sigratings_harvest_jobs etl_status_id int4 10  √  null
etl_sigratings_harvest_jobs started_datetime timestamp 29,6  √  null
etl_status etl_status_id serial 10  √  nextval('etl_status_etl_status_id_seq'::regclass)
etl_status name varchar 2147483647  √  null
etl_type etl_type_id serial 10  √  nextval('etl_type_etl_type_id_seq'::regclass)
etl_type name varchar 2147483647  √  null
experience candidate_id int4 10
experience district text 2147483647  √  null
experience experience_id serial 10  √  nextval('experience_experience_id_seq'::regclass)
experience experiencetype_id bpchar 1
experience fulltext text 2147483647  √  null
experience organization text 2147483647  √  null
experience span text 2147483647  √  null
experience special text 2147483647  √  null
experience title text 2147483647  √  null
experience_category category_id int2 5
experience_category experience_category_id serial 10  √  nextval('experience_category_experience_category_id_seq'::regclass)
experience_category experience_id int4 10
experience_tag experience_id int4 10  √  null
experience_tag experience_tag_id serial 10  √  nextval('experience_tag_experience_tag_id_seq'::regclass)
experience_tag tag_id int4 10  √  null
experiencetype experiencetype_id bpchar 1
experiencetype name text 2147483647
experiencetype rank int2 5  √  null
experiencetype shortname text 2147483647  √  null
factcheck factcheck_id serial 10  √  nextval('factcheck_factcheck_id_seq'::regclass)
factcheck factchecker_id int4 10
factcheck ruling text 2147483647  √  null
factcheck url text 2147483647  √  null
factcheck_candidate candidate_id int4 10  √  null
factcheck_candidate factcheck_candidate_id serial 10  √  nextval('factcheck_candidate_factcheck_candidate_id_seq'::regclass)
factcheck_candidate factcheck_id int4 10  √  null
factcheck_category category_id int4 10  √  null
factcheck_category factcheck_category_id serial 10  √  nextval('factcheck_category_factcheck_category_id_seq'::regclass)
factcheck_category factcheck_id int4 10  √  null
factcheck_speech factcheck_id int4 10  √  null
factcheck_speech factcheck_speech_id serial 10  √  nextval('factcheck_speech_factcheck_speech_id_seq'::regclass)
factcheck_speech factcheckruling_id int4 10  √  null
factcheck_speech speech_id int4 10  √  null
factcheck_speech_candidate factcheck_id int4 10  √  null
factcheck_speech_candidate factcheck_speech_candidate_id serial 10  √  nextval('factcheck_speech_candidate_factcheck_speech_candidate_id_seq'::regclass)
factcheck_speech_candidate factcheckruling_id int4 10  √  null
factcheck_speech_candidate speech_candidate_id int4 10  √  null
factcheck_tag factcheck_id int4 10  √  null
factcheck_tag factcheck_tag_id serial 10  √  nextval('factcheck_tag_factcheck_tag_id_seq'::regclass)
factcheck_tag tag_id int4 10  √  null
factchecker factchecker_id serial 10  √  nextval('factchecker_factchecker_id_seq'::regclass)
factchecker name text 2147483647
factchecker url text 2147483647
factcheckruling factcheckruling_id serial 10  √  nextval('factcheckruling_factcheckruling_id_seq'::regclass)
factcheckruling name text 2147483647  √  null
featured description text 2147483647  √  null
featured featured_id serial 10  √  nextval('featured_featured_id_seq'::regclass)
featured photos json 2147483647  √  null
featured release_id int2 5 0
featured title varchar 2147483647  √  null
featured_tag featured_id int4 10
featured_tag featured_tag_id serial 10  √  nextval('featured_tag_featured_tag_id_seq'::regclass)
featured_tag tag_id int4 10
finance_candidate date timestamp 29,6  √  null
finance_candidate dollars int8 19  √  null
finance_candidate election_candidate_id int4 10
finance_candidate finance_candidate_id serial 10  √  nextval('finance_candidate_finance_candidate_id_seq'::regclass)
finance_candidate finance_catcode_id int2 5
finance_candidate finsource_id int2 5
finance_catcode catcode varchar 2147483647  √  null
finance_catcode crp_indcode varchar 2147483647  √  null
finance_catcode finance_catcode_id serial 10  √  nextval('finance_catcode_finance_catcode_id_seq'::regclass)
finance_catcode finsource_id int2 5  √  null
finance_catcode imsp_industry_code int2 5  √  null
finance_catcode industry varchar 2147483647  √  null
finance_catcode name varchar 2147483647  √  null
finance_catcode sector varchar 2147483647  √  null
finsource finsource_id serial 10  √  nextval('finsource_id_seq'::regclass)
finsource name varchar 2147483647
finsource url text 2147483647  √  null
finsource_candidate candidate_id int4 10
finsource_candidate code varchar 2147483647
finsource_candidate created timestamp 29,6  √  null
finsource_candidate finsource_candidate_id serial 10  √  nextval('finsource_candidate_id_seq'::regclass)
finsource_candidate finsource_id int4 10
finsource_candidate modified timestamp 29,6  √  null
finsource_candidate updated timestamp 29,6  √  null
geography_columns coord_dimension int4 10  √  null
geography_columns f_geography_column name 2147483647  √  null
geography_columns f_table_catalog name 2147483647  √  null
geography_columns f_table_name name 2147483647  √  null
geography_columns f_table_schema name 2147483647  √  null
geography_columns srid int4 10  √  null
geography_columns type text 2147483647  √  null
geometry_columns coord_dimension int4 10  √  null
geometry_columns f_geometry_column varchar 256  √  null
geometry_columns f_table_catalog varchar 256  √  null
geometry_columns f_table_name varchar 256  √  null
geometry_columns f_table_schema varchar 256  √  null
geometry_columns srid int4 10  √  null
geometry_columns type varchar 30  √  null
leadership leadership_id int2 5  √  nextval(('leadership_id_seq'::text)::regclass)
leadership name varchar 2147483647 ''::character varying
leadership rank int2 5  √  null
leadership_candidate created timestamp 29,6  √  null
leadership_candidate leadership_candidate_id serial 10  √  nextval('leadership_candidate_id_seq'::regclass)
leadership_candidate leadership_id int2 5
leadership_candidate modified timestamp 29,6  √  null
leadership_candidate office_candidate_id int4 10
leadership_candidate termend flexdate 2147483647  √  null
leadership_candidate termstart flexdate 2147483647  √  null
leadership_office leadership_id int2 5
leadership_office leadership_office_id serial 10  √  nextval('leadership_office_leadership_office_id_seq'::regclass)
leadership_office office_id int2 5  √  null
leadership_office state_id bpchar 2
leadership_state leadership_id int2 5
leadership_state leadership_state_id int2 5  √  nextval('leadership_state_id_seq'::regclass)
leadership_state state_id bpchar 2
leadership_state_office leadership_state_id int2 5
leadership_state_office leadership_state_office_id serial 10  √  nextval('leadership_state_office_id_seq'::regclass)
leadership_state_office office_id int2 5
legislativedistricts_gis affgeoid varchar 2147483647  √  null
legislativedistricts_gis districtname_id int4 10  √  null
legislativedistricts_gis geom geometry 2147483647  √  null
legislativedistricts_gis name varchar 2147483647  √  null
legislativedistricts_gis office_id int4 10  √  null
legislativedistricts_gis state_id varchar 2147483647  √  null
local committeeurl varchar 2147483647  √  null
local financeurl varchar 2147483647  √  null
local local_id serial 10  √  nextval('local_id_seq'::regclass)
local localtype_id bpchar 1
local name varchar 2147483647
local parent_id int4 10  √  null
local state_id bpchar 2
local url varchar 2147483647  √  null
local voteurl varchar 2147483647  √  null
local_districtname districtname_id int2 5  √  null
local_districtname local_districtname_id serial 10  √  nextval('local_districtname_local_districtname_id_seq'::regclass)
local_districtname local_id int4 10  √  null
local_leadership leadership_id int2 5  √  null
local_leadership local_id int4 10  √  null
local_leadership local_leadership_id serial 10  √  nextval('local_leadership_local_leadership_id_seq'::regclass)
localtype localtype_id bpchar 1
localtype name varchar 2147483647  √  null
localtype rank int2 5  √  null
mailmerge address text 2147483647  √  null
mailmerge candidate_id int4 10  √  null
mailmerge city text 2147483647  √  null
mailmerge contactname text 2147483647  √  null
mailmerge contacttitle text 2147483647  √  null
mailmerge deadline date 13  √  null
mailmerge districtname text 2147483647  √  null
mailmerge election_candidate_id int4 10  √  null
mailmerge email text 2147483647  √  null
mailmerge firstname text 2147483647  √  null
mailmerge lastname text 2147483647  √  null
mailmerge mailmerge_id int4 10  √  null
mailmerge mergedate timestamp 29,6 now()
mailmerge middlename text 2147483647  √  null
mailmerge npataddress bool 1  √  null
mailmerge password text 2147483647  √  null
mailmerge seekingtitle text 2147483647  √  null
mailmerge state text 2147483647  √  null
mailmerge status text 2147483647  √  null
mailmerge suffix text 2147483647  √  null
mailmerge title text 2147483647  √  null
mailmerge zip text 2147483647  √  null
measure code varchar 2147483647  √  null
measure congoutcome_id int2 5  √  null
measure conurl varchar 2147483647  √  null
measure electiondate date 13  √  null
measure electiontype varchar 2147483647  √  null
measure measure_id serial 10  √  nextval('measure_measure_id_seq'::regclass)
measure measuretext text 2147483647  √  null
measure measuretype_id bpchar 1  √  null
measure no int4 10  √  null
measure outcome varchar 2147483647  √  null
measure prourl varchar 2147483647  √  null
measure source varchar 2147483647  √  null
measure sourceurl varchar 2147483647  √  null
measure state_id bpchar 2  √  null
measure summary text 2147483647  √  null
measure summaryurl varchar 2147483647  √  null
measure texturl varchar 2147483647  √  null
measure title varchar 2147483647  √  null
measure url varchar 2147483647  √  null
measure yes int4 10  √  null
measure_category category_id int2 5
measure_category measure_category_id serial 10  √  nextval('measure_category_measure_category_id_seq'::regclass)
measure_category measure_id int4 10
measure_tag measure_id int4 10  √  null
measure_tag measure_tag_id serial 10  √  nextval('measure_tag_measure_tag_id_seq'::regclass)
measure_tag tag_id int4 10  √  null
measuretype measuretype_id bpchar 1
measuretype name varchar 2147483647  √  null
merge_candidate merged timestamp 29,6 now()
merge_candidate new_id int4 10  √  null
merge_candidate old_id int4 10  √  null
mv_rating_party_average average int4 10  √  null
mv_rating_party_average party_group text 2147483647  √  null
mv_rating_party_average sig_id int4 10  √  null
mv_rating_party_average sig_name varchar 2147483647  √  null
npatanswer answertext text 2147483647 ''::text
npatanswer created timestamp 29,6  √  null
npatanswer modified timestamp 29,6  √  null
npatanswer npatanswer_id serial 10  √  nextval('npatanswer_id_seq'::regclass)
npatanswer npatcandidate_id int4 10
npatanswer npatmatrix_id int4 10
npatanswer npatoption_id int4 10  √  null
npatanswer our_npatoption_id int4 10  √  null
npatanswer_backup answertext text 2147483647  √  null
npatanswer_backup npatanswer_id int4 10  √  null
npatanswer_backup npatcandidate_id int4 10  √  null
npatanswer_backup npatmatrix_id int4 10  √  null
npatanswer_backup npatoption_id int4 10  √  null
npatanswer_backup our_npatoption_id int4 10  √  null
npatanswer_category category_id int2 5
npatanswer_category npatanswer_category_id serial 10  √  nextval('npatanswer_category_npatanswer_category_id_seq'::regclass)
npatanswer_category npatanswer_id int4 10
npatanswer_citation_congstatus citation_id int4 10  √  null
npatanswer_citation_congstatus congstatus_id int4 10  √  null
npatanswer_citation_rating citation_id int4 10  √  null
npatanswer_citation_rating rating_id int4 10  √  null
npatanswer_citation_speech_candidate citation_id int4 10  √  null
npatanswer_citation_speech_candidate speech_candidate_id int4 10  √  null
npatanswer_pct_old npatcandidate_id int4 10  √  null
npatanswer_pct_old npatmatrix_id int4 10  √  null
npatanswer_pct_old npatoption_id int4 10  √  null
npatanswer_tag npatanswer_id int4 10
npatanswer_tag npatanswer_tag_id serial 10  √  nextval('npatanswer_tag_npatanswer_tag_id_seq'::regclass)
npatanswer_tag tag_id int4 10
npatanswerlocking accessed timestamp 29,6  √  null
npatanswerlocking accessedby varchar 2147483647  √  null
npatanswerlocking committed bool 1 false
npatanswerlocking npatanswer_id int4 10
npatanswerlocking rank int4 10  √  null
npatcandidate created timestamp 29,6  √  null
npatcandidate election_candidate_id int4 10
npatcandidate lastimport timestamp 29,6  √  null
npatcandidate lastupdate timestamp 29,6  √  null
npatcandidate modified timestamp 29,6  √  null
npatcandidate npatcandidate_id serial 10  √  nextval('npatcandidate_id_seq'::regclass)
npatcandidate npatform_id int4 10
npatcandidate npatgroup_id varchar 2147483647  √  null
npatcandidate npatstatus_id bpchar 1 'P'::bpchar
npatcandidate pct int2 5  √  null
npatcandidate processed bool 1  √  null
npatcandidate receiveddate timestamptz 35,6  √  null
npatcitation citation text 2147483647
npatcitation npatcandidate_id int4 10
npatcitation npatcitation_id serial 10  √  nextval('npatcitation_npatcitation_id_seq'::regclass)
npatcitation npatrow_id int4 10
npatcitation url text 2147483647  √  null
npatcitation_congstatus congstatus_id int4 10
npatcitation_congstatus npatcitation_congstatus_id serial 10  √  nextval('npatcitation_congstatus_npatcitation_congstatus_id_seq'::regclass)
npatcitation_congstatus npatcitation_id int4 10
npatcitation_rating npatcitation_id int4 10
npatcitation_rating npatcitation_rating_id serial 10  √  nextval('npatcitation_rating_npatcitation_rating_id_seq'::regclass)
npatcitation_rating rating_id int4 10
npatcitation_speech_candidate npatcitation_id int4 10
npatcitation_speech_candidate npatcitation_speech_candidate_id serial 10  √  nextval('npatcitation_speech_candidate_npatcitation_speech_candidate_seq'::regclass)
npatcitation_speech_candidate speech_candidate_id int4 10
npatform deadline date 13  √  null
npatform npatform_id serial 10  √  nextval('npatform_id_seq'::regclass)
npatform_criteria electionstage_id bpchar 1  √  null
npatform_criteria electionyear int2 5
npatform_criteria npatform_criteria_id serial 10  √  nextval('npatform_criteria_id_seq'::regclass)
npatform_criteria npatform_id int4 10
npatform_criteria officetype_id bpchar 1
npatform_criteria state_id bpchar 2
npatform_def npatform_def_id int4 10
npatform_def path varchar 2147483647 ''::character varying
npatform_def profile bool 1 false
npatform_def rowtext text 2147483647 ''::text
npatform_def rowtype_id int4 10
npatform_def wordlimit int2 5 0
npatform_election election_id int4 10
npatform_election npatform_election_id serial 10  √  nextval('npatform_election_id_seq'::regclass)
npatform_election npatform_id int4 10
npatgroup code varchar 2147483647  √  null
npatgroup electionstage_id bpchar 1  √  null
npatgroup npatgroup_id varchar 2147483647
npatgroup npatgrouptype_id bpchar 1  √  null
npatgroup rank int2 5  √  null
npatgroup_state deadline date 13  √  null
npatgroup_state maildate date 13  √  null
npatgroup_state npatgroup_id varchar 2147483647
npatgroup_state npatgroup_state_id serial 10  √  nextval('npatgroup_state_id_seq'::regclass)
npatgroup_state releasedate date 13  √  null
npatgroup_state state_id bpchar 2
npatgrouptype name varchar 2147483647  √  null
npatgrouptype npatgrouptype_id bpchar 1
npatmatrix npatform_id int4 10
npatmatrix npatmatrix_id serial 10  √  nextval('npatmatrix_id_seq'::regclass)
npatmatrix npatrow_id int4 10
npatmatrix path ltree 2147483647
npatmatrix rank int2 5 0
npatmatrix_category category_id int2 5
npatmatrix_category npatmatrix_category_id serial 10  √  nextval('npatmatrix_category_npatmatrix_category_id_seq'::regclass)
npatmatrix_category npatmatrix_id int4 10
npatmatrix_p npatform_id int4 10
npatmatrix_p npatmatrix_id serial 10  √  nextval('npatmatrix_p_id_seq'::regclass)
npatmatrix_p npatrow_id int4 10
npatmatrix_p path ltree 2147483647
npatmatrix_p rank int2 5 0
npatmessage electionyear int2 5  √  null
npatmessage message text 2147483647 ''::text
npatmessage npatmessage_id serial 10  √  nextval('npatmessage_id_seq'::regclass)
npatmessage npatmessagetype_id bpchar 1
npatmessagetype name varchar 2147483647
npatmessagetype npatmessagetype_id bpchar 1
npatoption code bpchar 1  √  null
npatoption npatoption_id serial 10  √  nextval('npatoption_id_seq'::regclass)
npatoption npatoptiongroup_id int4 10
npatoption npatoptiontext_id int4 10
npatoption rank int4 10
npatoptiongroup npatoptiongroup_id int4 10
npatoptiontext npatoptiontext_id serial 10  √  nextval('npatoptiontext_id_seq'::regclass)
npatoptiontext optiontext varchar 2147483647 ''::character varying
npatproblem npatproblem_id bpchar 1
npatproblem problem text 2147483647  √  null
npatproblem_npatcandidate npatcandidate_id int4 10  √  null
npatproblem_npatcandidate npatproblem_id bpchar 1  √  null
npatproblem_npatcandidate npatproblem_npatcandidate_id serial 10  √  nextval('npatproblem_npatcandidate_npatproblem_npatcandidate_id_seq'::regclass)
npatrow npatrow_id serial 10  √  nextval('npatrow_id_seq'::regclass)
npatrow npatrowtext_id int4 10
npatrow npatrowtype_id int4 10
npatrow profile bool 1  √  null
npatrow wordlimit int2 5  √  null
npatrow_category category_id int2 5
npatrow_category npatrow_category_id serial 10  √  nextval('npatrow_category_npatrow_category_id_seq'::regclass)
npatrow_category npatrow_id int4 10
npatrow_category rank int2 5 0
npatrow_congstatus congstatus_id int4 10  √  null
npatrow_congstatus npatrow_congstatus_id serial 10  √  nextval('npatrow_congstatus_npatrow_congstatus_id_seq'::regclass)
npatrow_congstatus npatrow_id int4 10  √  null
npatrow_p npatrow_id serial 10  √  nextval('npatrow_p_id_seq'::regclass)
npatrow_p npatrowtext_id int4 10
npatrow_p npatrowtype_id int4 10
npatrow_p profile bool 1 false
npatrow_p wordlimit int2 5  √  null
npatrow_sig npatoption_id int4 10  √  null
npatrow_sig npatrow_id int4 10
npatrow_sig npatrow_sig_id serial 10  √  nextval('npatrow_sig_npatrow_sig_id_seq'::regclass)
npatrow_sig rank int2 5 0
npatrow_sig sig_id int4 10
npatrowshorttext detail text 2147483647  √  null
npatrowshorttext npatrow_id int4 10
npatrowshorttext shortcategory text 2147483647
npatrowshorttext shorttext text 2147483647  √  null
npatrowshorttext subcategory text 2147483647  √  null
npatrowtext npatrowtext_id serial 10  √  nextval('npatrowtext_id_seq'::regclass)
npatrowtext rowtext text 2147483647 ''::text
npatrowtext_category category_id int2 5
npatrowtext_category npatrowtext_category_id serial 10  √  nextval('npatrowtext_category_npatrowtext_category_id_seq'::regclass)
npatrowtext_category npatrowtext_id int4 10
npatrowtext_p npatrowtext_id serial 10  √  nextval('npatrowtext_p_id_seq'::regclass)
npatrowtext_p rowtext text 2147483647 ''::text
npatrowtext_tag npatrowtext_id int4 10  √  null
npatrowtext_tag npatrowtext_tag_id serial 10  √  nextval('npatrowtext_tag_npatrowtext_tag_id_seq'::regclass)
npatrowtext_tag tag_id int4 10  √  null
npatrowtype npatoptiongroup_id int4 10  √  null
npatrowtype npatrowtype_id serial 10  √  nextval('npatrowtype_id_seq'::regclass)
npatrowtype open bool 1 false
npatstatus name varchar 2147483647
npatstatus npatstatus_id bpchar 1
npatstatus rank int2 5  √  null
npatstatus statustext varchar 2147483647  √  null
office code varchar 2147483647 ''::character varying
office name varchar 2147483647 ''::character varying
office npatoffice bool 1 false
office office_id int2 5  √  nextval(('public.office_id_seq'::text)::regclass)
office officetype_id bpchar 1 ''::bpchar
office rank int2 5  √  null
office release_id int2 5 0
office shorttitle varchar 2147483647  √  null
office title varchar 2147483647 ''::character varying
office_address address varchar 2147483647  √  null
office_address addresstype_id int2 5
office_address city varchar 2147483647  √  null
office_address contactname varchar 2147483647  √  null
office_address contacttitle varchar 2147483647  √  null
office_address fax1 varchar 2147483647  √  null
office_address fax2 varchar 2147483647  √  null
office_address note text 2147483647  √  null
office_address npataddress bool 1 false
office_address office_address_id serial 10  √  nextval('office_address_id_seq'::regclass)
office_address office_candidate_id int4 10
office_address phone1 varchar 2147483647  √  null
office_address phone2 varchar 2147483647  √  null
office_address rank int2 5  √  null
office_address state bpchar 2  √  null
office_address tollfree varchar 2147483647  √  null
office_address ttyd varchar 2147483647  √  null
office_address zip varchar 2147483647  √  null
office_candidate appointed bool 1  √  null
office_candidate candidate_id int4 10
office_candidate created timestamp 29,6  √  null
office_candidate districtname_id int2 5  √  null
office_candidate firstelect varchar 2147483647  √  null
office_candidate importid varchar 2147483647 ''::character varying
office_candidate lastelect varchar 2147483647  √  null
office_candidate local_id int4 10  √  null
office_candidate modified timestamp 29,6  √  null
office_candidate nextelect varchar 2147483647  √  null
office_candidate office_candidate_id serial 10  √  nextval('office_candidate_id_seq'::regclass)
office_candidate office_id int2 5
office_candidate officecandidatestatus_id int2 5
office_candidate parent_id int4 10  √  null
office_candidate specialmsg text 2147483647 ''::text
office_candidate state_id bpchar 2
office_candidate termend flexdate 2147483647  √  null
office_candidate termstart flexdate 2147483647  √  null
office_candidate_party office_candidate_id int4 10
office_candidate_party office_candidate_party_id serial 10  √  nextval('office_candidate_party_id_seq'::regclass)
office_candidate_party party_id int2 5
office_category category_id int2 5  √  null
office_category office_category_id serial 10  √  nextval('office_category_office_category_id_seq'::regclass)
office_category office_id int2 5  √  null
office_state appointed bool 1  √  null
office_state nextelect int2 5  √  null
office_state office_id int2 5
office_state office_state_id serial 10  √  nextval('office_state_office_state_id_seq'::regclass)
office_state split varchar 2147483647  √  null
office_state state_id bpchar 2
office_state termlength int2 5  √  null
office_state termlimit int2 5  √  null
office_webaddress addresstype_id int2 5
office_webaddress office_candidate_id int4 10
office_webaddress office_webaddress_id serial 10  √  nextval('office_webaddress_id_seq'::regclass)
office_webaddress webaddress varchar 2147483647  √  null
office_webaddress webaddresstype_id int2 5
officebranch name varchar 2147483647  √  null
officebranch officebranch_id bpchar 1
officecandidatestatus name varchar 2147483647 ''::character varying
officecandidatestatus officecandidatestatus_id int2 5  √  nextval(('officecandidatestatus_id_seq'::text)::regclass)
officelevel name varchar 2147483647 ''::character varying
officelevel officelevel_id bpchar 1
officelevel rank int2 5  √  null
officetype fullname varchar 2147483647 ''::character varying
officetype name varchar 2147483647  √  null
officetype officebranch_id bpchar 1
officetype officelevel_id bpchar 1
officetype officetype_id bpchar 1
officetype rank int2 5  √  null
officials_roster candidate_id int4 10  √  null
officials_roster state_id bpchar 2  √  null
officials_roster zip4end int2 5  √  null
officials_roster zip4start int2 5  √  null
officials_roster zip5 int4 10  √  null
party name varchar 2147483647 ''::character varying
party parent_id int4 10  √  null
party party_id serial 10  √  nextval('party_id_seq'::regclass)
party rank int2 5  √  null
party_category category_id int2 5  √  null
party_category party_category_id serial 10  √  nextval('party_category_party_category_id_seq'::regclass)
party_category party_id int4 10  √  null
party_tag party_id int4 10
party_tag party_tag_id serial 10  √  nextval('party_tag_party_tag_id_seq'::regclass)
party_tag tag_id int4 10
pingpong datetime timestamp 29,6  √  now()
pingpong parent_column varchar 2147483647  √  null
pingpong parent_id varchar 2147483647  √  null
pingpong parent_id_column varchar 2147483647  √  null
pingpong parent_table varchar 2147483647  √  null
pingpong pingpong_id serial 10  √  nextval('pingpong_pingpong_id_seq'::regclass)
pingpong status int4 10  √  null
pingpong url varchar 2147483647  √  null
pingpong_harvest last_modified timestamp 29,6  √  now()
pingpong_harvest pingpong_harvest_id serial 10  √  nextval('pingpong_harvest_pingpong_harvest_id_seq'::regclass)
primarytype description text 2147483647  √  null
primarytype name varchar 2147483647  √  null
primarytype primarytype_id bpchar 1
primarytype_state party_id int4 10  √  null
primarytype_state primarytype_id bpchar 1  √  null
primarytype_state primarytype_state_id serial 10  √  nextval('primarytype_state_primarytype_party_id_seq'::regclass)
primarytype_state state_id bpchar 2  √  null
profession candidate_id int4 10
profession organization text 2147483647  √  null
profession profession_id serial 10  √  nextval('profession_profession_id_seq'::regclass)
profession span text 2147483647  √  null
profession title text 2147483647  √  null
pvs_encoding translate text 2147483647  √  null
pyadmin_tasks completed timestamp 29,6  √  null
pyadmin_tasks created timestamp 29,6  √  now()
pyadmin_tasks end_id int2 5  √  null
pyadmin_tasks pyadmin_tasks_id serial 10  √  nextval('pyadmin_tasks_pyadmin_tasks_id_seq'::regclass)
pyadmin_tasks start_id int2 5  √  null
pyadmin_tasks tablename varchar 2147483647  √  null
pyadmin_tasks user_id varchar 2147483647  √  null
raster_columns blocksize_x int4 10  √  null
raster_columns blocksize_y int4 10  √  null
raster_columns extent geometry 2147483647  √  null
raster_columns nodata_values _float8 17,17  √  null
raster_columns num_bands int4 10  √  null
raster_columns out_db _bool 1  √  null
raster_columns pixel_types _text 2147483647  √  null
raster_columns r_raster_column name 2147483647  √  null
raster_columns r_table_catalog name 2147483647  √  null
raster_columns r_table_name name 2147483647  √  null
raster_columns r_table_schema name 2147483647  √  null
raster_columns regular_blocking bool 1  √  null
raster_columns same_alignment bool 1  √  null
raster_columns scale_x float8 17,17  √  null
raster_columns scale_y float8 17,17  √  null
raster_columns srid int4 10  √  null
raster_overviews o_raster_column name 2147483647  √  null
raster_overviews o_table_catalog name 2147483647  √  null
raster_overviews o_table_name name 2147483647  √  null
raster_overviews o_table_schema name 2147483647  √  null
raster_overviews overview_factor int4 10  √  null
raster_overviews r_raster_column name 2147483647  √  null
raster_overviews r_table_catalog name 2147483647  √  null
raster_overviews r_table_name name 2147483647  √  null
raster_overviews r_table_schema name 2147483647  √  null
rating created timestamp 29,6  √  null
rating description text 2147483647 ''::text
rating modified timestamp 29,6  √  null
rating name varchar 2147483647 ''::character varying
rating rating_id serial 10  √  nextval(('rating_id_seq'::text)::regclass)
rating ratingformat_id int2 5
rating ratingsession_id int2 5 (-1)
rating ratingtext text 2147483647 ''::text
rating release_id int2 5 0
rating sig_id int4 10
rating span varchar 2147483647 ''::character varying
rating usesigrating bool 1  √  null
rating_candidate candidate_id int4 10
rating_candidate our_rating varchar 2147483647
rating_candidate rating_candidate_id serial 10  √  nextval(('rating_candidate_id_seq'::text)::regclass)
rating_candidate rating_id int4 10
rating_candidate sig_rating varchar 2147483647
rating_category category_id int2 5
rating_category rating_category_id serial 10  √  nextval('rating_category_id_seq'::regclass)
rating_category rating_id int4 10
rating_tag rating_id int4 10  √  null
rating_tag rating_tag_id serial 10  √  nextval('rating_tag_rating_tag_id_seq'::regclass)
rating_tag tag_id int4 10  √  null
ratingformat name varchar 2147483647 ''::character varying
ratingformat ratingformat_id int2 5  √  nextval(('ratingformat_id_seq'::text)::regclass)
ratingsession name varchar 2147483647 ''::character varying
ratingsession ratingsession_id int2 5  √  nextval(('ratingsession_id_seq'::text)::regclass)
ratingtext description text 2147483647 ''::text
ratingtext name varchar 2147483647 ''::character varying
ratingtext rank int2 5  √  null
ratingtext ratingtext text 2147483647 ''::text
ratingtext ratingtext_id int2 5  √  nextval(('ratingtext_id_seq'::text)::regclass)
release name varchar 2147483647
release release_id int2 5
religion name varchar 2147483647 ''::text
religion rank int2 5  √  null
religion religion_id serial 10  √  nextval('religion_id_seq'::regclass)
religion_category category_id int2 5  √  null
religion_category religion_category_id serial 10  √  nextval('religion_category_religion_category_id_seq'::regclass)
religion_category religion_id int4 10  √  null
religion_tag religion_id int4 10
religion_tag religion_tag_id serial 10  √  nextval('religion_tag_religion_tag_id_seq'::regclass)
religion_tag tag_id int4 10
resource address varchar 2147483647  √  null
resource city varchar 2147483647  √  null
resource email varchar 2147483647  √  null
resource fax varchar 2147483647  √  null
resource foiaurl varchar 2147483647  √  null
resource hours varchar 2147483647  √  null
resource mission text 2147483647  √  null
resource name varchar 2147483647
resource phone1 varchar 2147483647  √  null
resource phone2 varchar 2147483647  √  null
resource resource_id serial 10  √  nextval('resource_id_seq'::regclass)
resource resourcetype_id int2 5
resource state bpchar 2  √  null
resource state_id bpchar 2  √  null
resource tdd varchar 2147483647  √  null
resource url varchar 2147483647  √  null
resource zip varchar 2147483647  √  null
resourcetype name varchar 2147483647
resourcetype parent_id int2 5  √  null
resourcetype resourcetype_id serial 10  √  nextval('resourcetype_id_seq'::regclass)
role description text 2147483647  √  null
role role_id varchar 2147483647
section name varchar 2147483647
section section_id bpchar 1
sig address varchar 2147483647 ''::character varying
sig city varchar 2147483647 ''::character varying
sig contactname varchar 2147483647 ''::character varying
sig description text 2147483647 ''::text
sig email varchar 2147483647 ''::character varying
sig fax varchar 2147483647 ''::character varying
sig major bool 1  √  null
sig name varchar 2147483647 ''::character varying
sig note text 2147483647  √  null
sig parent_id int4 10 (-1)
sig phone1 varchar 2147483647 ''::character varying
sig phone2 varchar 2147483647 ''::character varying
sig ratinggroup bool 1  √  null
sig release_id int2 5 0
sig sig_id serial 10  √  nextval(('sig_id_seq'::text)::regclass)
sig state bpchar 2  √  null
sig state_id bpchar 2
sig url varchar 2147483647 ''::character varying
sig usesigrating bool 1  √  null
sig zip varchar 2147483647 ''::character varying
sig_category category_id int2 5
sig_category sig_category_id serial 10  √  nextval('sig_category_id_seq'::regclass)
sig_category sig_id int4 10
sig_tag sig_id int4 10  √  null
sig_tag sig_tag_id serial 10  √  nextval('sig_tag_sig_tag_id_seq'::regclass)
sig_tag tag_id int4 10  √  null
sigtype name varchar 2147483647  √  null
sigtype sigtype bpchar 1
spatial_ref_sys auth_name varchar 256  √  null
spatial_ref_sys auth_srid int4 10  √  null
spatial_ref_sys proj4text varchar 2048  √  null
spatial_ref_sys srid int4 10
spatial_ref_sys srtext varchar 2048  √  null
speech created timestamp 29,6  √  null
speech key bool 1  √  null
speech location varchar 2147483647 ''::character varying
speech modified timestamp 29,6  √  null
speech quote text 2147483647  √  null
speech release_id int2 5  √  null
speech source varchar 2147483647 ''::character varying
speech speech_id serial 10  √  nextval('speech_id_seq'::regclass)
speech speech_tsv tsvector 2147483647  √  null
speech speechdate date 13  √  now()
speech speechtext text 2147483647
speech speechtype_id int2 5
speech summary text 2147483647  √  null
speech title varchar 2147483647 ''::character varying
speech url varchar 2147483647 ''::character varying
speech_candidate candidate_id int4 10
speech_candidate created timestamp 29,6  √  null
speech_candidate modified timestamp 29,6  √  null
speech_candidate speech_candidate_id serial 10  √  nextval('speech_candidate_id_seq'::regclass)
speech_candidate speech_id int4 10
speech_category category_id int2 5
speech_category speech_category_id serial 10  √  nextval('speech_category_speech_category_id_seq'::regclass)
speech_category speech_id int4 10
speech_tag speech_id int4 10  √  null
speech_tag speech_tag_id serial 10  √  nextval('speech_tag_speech_tag_id_seq'::regclass)
speech_tag tag_id int4 10  √  null
speechlock expire timestamp 29,6
speechlock lock bool 1
speechlock session_id varchar 2147483647
speechlock speech_id int4 10
speechlocking accessed timestamp 29,6  √  null
speechlocking accessedby varchar 2147483647  √  null
speechlocking committed bool 1 false
speechlocking rank serial 10  √  nextval('speechlocking_rank_seq'::regclass)
speechlocking speech_id int4 10
speechtype name varchar 2147483647 ''::character varying
speechtype speechtype_id int2 5  √  nextval(('speechtype_id_seq'::text)::regclass)
stat name text 2147483647  √  null
stat rank int2 5  √  null
stat stat_id text 2147483647
stat value int8 19  √  null
state absenteehow text 2147483647 ''::text
state absenteewhen text 2147483647 ''::text
state absenteewho text 2147483647 ''::text
state area varchar 2147483647  √  null
state atlarge bool 1 false
state bicameral bool 1 false
state billurl varchar 2147483647 ''::character varying
state bird varchar 2147483647 ''::character varying
state capital varchar 2147483647 ''::character varying
state caucus bool 1  √  null
state created timestamp 29,6  √  null
state delegatedem int2 5  √  null
state delegaterep int2 5  √  null
state electoralvotes int2 5  √  null
state flower varchar 2147483647 ''::character varying
state generaldate date 13  √  null
state high varchar 2147483647 ''::character varying
state largestcity varchar 2147483647 ''::character varying
state legisname varchar 2147483647 ''::character varying
state low varchar 2147483647 ''::character varying
state lowername varchar 2147483647 ''::character varying
state ltgov bool 1 false
state modified timestamp 29,6  √  null
state motto varchar 2147483647 ''::character varying
state name varchar 2147483647 ''::character varying
state nickname varchar 2147483647 ''::character varying
state population varchar 2147483647  √  null
state primarydate date 13  √  null
state registration text 2147483647 ''::text
state reps int2 5 0
state rolllower varchar 2147483647  √  null
state rollupper varchar 2147483647  √  null
state senators int2 5 0
state state_id bpchar 2
state statecode int2 5
state statehood varchar 2147483647 ''::character varying
state statetype_id bpchar 1  √  null
state termlength int2 5 0
state termlimit int2 5 0
state tree varchar 2147483647 ''::character varying
state type varchar 2147483647 ''::character varying
state uscircuit varchar 2147483647 ''::character varying
state ushousename varchar 2147483647  √  null
state voteurl varchar 2147483647 ''::character varying
statetype name varchar 2147483647
statetype statetype_id bpchar 1
tag deleted bool 1 false
tag modified timestamp 29,6  √  null
tag name text 2147483647
tag tag_id serial 10  √  nextval('tag_tag_id_seq'::regclass)
tagalias alias text 2147483647
tagalias tag_id int4 10  √  null
tagalias tagalias_id serial 10  √  nextval('tagalias_tagalias_id_seq'::regclass)
user lastlogin timestamp 29,6  √  null
user name varchar 2147483647 ''::character varying
user notes varchar 2147483647 ''::character varying
user password varchar 2147483647
user user_id varchar 2147483647
user_role role_id varchar 2147483647
user_role user_id varchar 2147483647
v_biotext_count count int8 19  √  null
v_biotext_count type text 2147483647  √  null
v_blog_categories category_id int4 10  √  null
v_blog_categories slug varchar 2147483647  √  null
v_blog_categories title varchar 2147483647  √  null
v_candidate_timeline candidate_id int4 10  √  null
v_candidate_timeline category_id int2 5  √  null
v_candidate_timeline extra varchar 2147483647  √  null
v_candidate_timeline id1 int4 10  √  null
v_candidate_timeline id2 int4 10  √  null
v_candidate_timeline title text 2147483647  √  null
v_candidate_timeline type text 2147483647  √  null
v_candidate_timeline when timestamp 29,6  √  null
v_category category_id int2 5  √  null
v_category description text 2147483647  √  null
v_category level int4 10  √  null
v_category name varchar 2147483647  √  null
v_category parent_id int4 10  √  null
v_category path varchar 2147483647  √  null
v_category rank int2 5  √  null
v_category release_id int2 5  √  null
v_category_new category_id int2 5  √  null
v_category_new description text 2147483647  √  null
v_category_new level int4 10  √  null
v_category_new lpath ltree 2147483647  √  null
v_category_new name varchar 2147483647  √  null
v_category_new parent_id int4 10  √  null
v_category_new path varchar 2147483647  √  null
v_category_new rank int2 5  √  null
v_category_new release_id int2 5  √  null
v_category_released category_id int2 5  √  null
v_category_released description text 2147483647  √  null
v_category_released level int4 10  √  null
v_category_released name varchar 2147483647  √  null
v_category_released parent_id int4 10  √  null
v_category_released rank int2 5  √  null
v_category_released release_id int2 5  √  null
v_category_released released _int2 5  √  null
v_category_resolve category_id int2 5  √  null
v_category_resolve description text 2147483647  √  null
v_category_resolve name varchar 2147483647  √  null
v_category_resolve new_category_id int2 5  √  null
v_congstatus billnumber varchar 2147483647  √  null
v_congstatus congcategory_id int4 10  √  null
v_congstatus conghighlight_id int4 10  √  null
v_congstatus conglevel_id bpchar 1  √  null
v_congstatus congofficialsynopsis_id int4 10  √  null
v_congstatus congofficialtitle_id int4 10  √  null
v_congstatus congoutcome_id int2 5  √  null
v_congstatus congress_id int4 10  √  null
v_congstatus congress_note varchar 2147483647  √  null
v_congstatus congress_release_id int2 5  √  null
v_congstatus congstage_id int2 5  √  null
v_congstatus congstatus_id int4 10  √  null
v_congstatus congstatus_note varchar 2147483647  √  null
v_congstatus congstatus_release_id int2 5  √  null
v_congstatus congsynopsis_id int4 10  √  null
v_congstatus congtext_id int4 10  √  null
v_congstatus congtitle_id int4 10  √  null
v_congstatus congtype_id bpchar 1  √  null
v_congstatus highlight text 2147483647  √  null
v_congstatus keyvote bool 1  √  null
v_congstatus level varchar 2147483647  √  null
v_congstatus nay int2 5  √  null
v_congstatus officialsynopsis text 2147483647  √  null
v_congstatus officialtitle text 2147483647  √  null
v_congstatus outcome varchar 2147483647  √  null
v_congstatus rank int2 5  √  null
v_congstatus rollnumber int2 5  √  null
v_congstatus stage varchar 2147483647  √  null
v_congstatus state_id bpchar 2  √  null
v_congstatus statename varchar 2147483647  √  null
v_congstatus statusdate date 13  √  null
v_congstatus synopsis text 2147483647  √  null
v_congstatus title varchar 2147483647  √  null
v_congstatus url varchar 2147483647  √  null
v_congstatus voicevote bool 1  √  null
v_congstatus yea int2 5  √  null
v_congstatus_candidate billnumber varchar 2147483647  √  null
v_congstatus_candidate candidate_id int4 10  √  null
v_congstatus_candidate congaction varchar 2147483647  √  null
v_congstatus_candidate congaction_id bpchar 1  √  null
v_congstatus_candidate congactioncode varchar 2147483647  √  null
v_congstatus_candidate congactiontype_id bpchar 1  √  null
v_congstatus_candidate congcategory_id int4 10  √  null
v_congstatus_candidate conghighlight_id int4 10  √  null
v_congstatus_candidate conglevel_id bpchar 1  √  null
v_congstatus_candidate congofficialsynopsis_id int4 10  √  null
v_congstatus_candidate congofficialtitle_id int4 10  √  null
v_congstatus_candidate congoutcome_id int2 5  √  null
v_congstatus_candidate congress_id int4 10  √  null
v_congstatus_candidate congress_note varchar 2147483647  √  null
v_congstatus_candidate congress_release_id int2 5  √  null
v_congstatus_candidate congstage_id int2 5  √  null
v_congstatus_candidate congstatus_id int4 10  √  null
v_congstatus_candidate congstatus_note varchar 2147483647  √  null
v_congstatus_candidate congstatus_release_id int2 5  √  null
v_congstatus_candidate congsynopsis_id int4 10  √  null
v_congstatus_candidate congtitle_id int4 10  √  null
v_congstatus_candidate congtype_id bpchar 1  √  null
v_congstatus_candidate highlight text 2147483647  √  null
v_congstatus_candidate level varchar 2147483647  √  null
v_congstatus_candidate nay int2 5  √  null
v_congstatus_candidate office_candidate_id int4 10  √  null
v_congstatus_candidate officialsynopsis text 2147483647  √  null
v_congstatus_candidate officialtitle text 2147483647  √  null
v_congstatus_candidate outcome varchar 2147483647  √  null
v_congstatus_candidate rank int2 5  √  null
v_congstatus_candidate rollnumber int2 5  √  null
v_congstatus_candidate stage varchar 2147483647  √  null
v_congstatus_candidate state_id bpchar 2  √  null
v_congstatus_candidate statename varchar 2147483647  √  null
v_congstatus_candidate statusdate date 13  √  null
v_congstatus_candidate synopsis text 2147483647  √  null
v_congstatus_candidate title varchar 2147483647  √  null
v_congstatus_candidate url varchar 2147483647  √  null
v_congstatus_candidate voicevote bool 1  √  null
v_congstatus_candidate yea int2 5  √  null
v_congstatusparty action varchar 2147483647  √  null
v_congstatusparty conglevel_id bpchar 1  √  null
v_congstatusparty congress_id int4 10  √  null
v_congstatusparty congstatus_id int4 10  √  null
v_congstatusparty nay int2 5  √  null
v_congstatusparty npatrow_id int4 10  √  null
v_congstatusparty party_name text 2147483647  √  null
v_congstatusparty release_id int2 5  √  null
v_congstatusparty tally int8 19  √  null
v_congstatusparty yea int2 5  √  null
v_election candidaterelease_id int2 5  √  null
v_election election_electionstage_id int4 10  √  null
v_election election_electionstage_release_id int2 5  √  null
v_election election_electionstage_state_id bpchar 2  √  null
v_election election_id int4 10  √  null
v_election electiondate date 13  √  null
v_election electionname text 2147483647  √  null
v_election electionstage varchar 2147483647  √  null
v_election electionstage_id bpchar 1  √  null
v_election electionstage_rank int2 5  √  null
v_election electionyear int2 5  √  null
v_election filingdeadline date 13  √  null
v_election independentfiling date 13  √  null
v_election majorfiling date 13  √  null
v_election npatmailed bool 1  √  null
v_election npatrelease_id int2 5  √  null
v_election officelevel_id bpchar 1  √  null
v_election officelevel_rank int2 5  √  null
v_election officetype_id bpchar 1  √  null
v_election officetype_rank int2 5  √  null
v_election party_id int4 10  √  null
v_election resultrelease_id int2 5  √  null
v_election special bool 1  √  null
v_election state_id bpchar 2  √  null
v_election thirdfiling date 13  √  null
v_election writeinfiling date 13  √  null
v_election_candidate ballotname varchar 2147483647  √  null
v_election_candidate candidate_id int4 10  √  null
v_election_candidate candidaterelease_id int2 5  √  null
v_election_candidate districtname varchar 2147483647  √  null
v_election_candidate districtname_id int2 5  √  null
v_election_candidate districtrank int2 5  √  null
v_election_candidate election_candidate_id int4 10  √  null
v_election_candidate election_electionstage_id int4 10  √  null
v_election_candidate election_electionstage_state_id bpchar 2  √  null
v_election_candidate election_id int4 10  √  null
v_election_candidate electioncandidatestatus_id int2 5  √  null
v_election_candidate electiondate date 13  √  null
v_election_candidate electionstage varchar 2147483647  √  null
v_election_candidate electionstage_candidate_id int4 10  √  null
v_election_candidate electionstage_id bpchar 1  √  null
v_election_candidate electionstage_release_id int2 5  √  null
v_election_candidate electionyear int2 5  √  null
v_election_candidate lowername varchar 2147483647  √  null
v_election_candidate npatmailed bool 1  √  null
v_election_candidate npatrelease_id int2 5  √  null
v_election_candidate office varchar 2147483647  √  null
v_election_candidate office_id int2 5  √  null
v_election_candidate officecode varchar 2147483647  √  null
v_election_candidate officerank int2 5  √  null
v_election_candidate officeshorttitle varchar 2147483647  √  null
v_election_candidate officetitle varchar 2147483647  √  null
v_election_candidate officetype varchar 2147483647  √  null
v_election_candidate officetype_id bpchar 1  √  null
v_election_candidate party varchar 2147483647  √  null
v_election_candidate party_id int4 10  √  null
v_election_candidate resultrelease_id int2 5  √  null
v_election_candidate state varchar 2147483647  √  null
v_election_candidate state_id bpchar 2  √  null
v_election_candidate status varchar 2147483647  √  null
v_election_candidate ushousename varchar 2147483647  √  null
v_election_current active_stages _varchar 2147483647  √  null
v_election_current contests int8 19  √  null
v_election_current electionyear int2 5  √  null
v_election_current latest_stage text 2147483647  √  null
v_election_current officetype varchar 2147483647  √  null
v_election_current officetype_id bpchar 1  √  null
v_election_current rank int2 5  √  null
v_election_current special bool 1  √  null
v_election_current states _bpchar 2  √  null
v_election_current total_candidates int8 19  √  null
v_electionname election_id int4 10  √  null
v_electionname electionname text 2147483647  √  null
v_featured_items content_id int4 10  √  null
v_featured_items data_type text 2147483647  √  null
v_featured_items dated timestamp 29,6  √  null
v_featured_items description text 2147483647  √  null
v_featured_items featured_id int4 10  √  null
v_featured_items release_id int4 10  √  null
v_featured_items title text 2147483647  √  null
v_highest_electionstage_id election_candidate_id int4 10  √  null
v_highest_electionstage_id electionstage_id bpchar 1  √  null
v_highest_electionstage_id_all election_candidate_id int4 10  √  null
v_highest_electionstage_id_all election_id int4 10  √  null
v_highest_electionstage_id_all electionstage_id bpchar 1  √  null
v_highest_stage candidate_id int4 10  √  null
v_highest_stage election name 2147483647  √  null
v_highest_stage higheststage varchar 2147483647  √  null
v_highest_stage status varchar 2147483647  √  null
v_leadership leadership varchar 2147483647  √  null
v_leadership leadership_id int2 5  √  null
v_leadership leadershiprank int2 5  √  null
v_leadership office_id int2 5  √  null
v_leadership state_id bpchar 2  √  null
v_name_slug candidate_id int4 10  √  null
v_name_slug slug text 2147483647  √  null
v_npat nm_rank int2 5  √  null
v_npat npatform_id int4 10  √  null
v_npat npatmatrix_id int4 10  √  null
v_npat npatoptiongroup_id int4 10  √  null
v_npat npatrow_id int4 10  √  null
v_npat npatrow_text text 2147483647  √  null
v_npat npatrowtype_id int4 10  √  null
v_npat open bool 1  √  null
v_npat path ltree 2147483647  √  null
v_npat profile bool 1  √  null
v_npat wordlimit int2 5  √  null
v_npatanswer_count count int8 19  √  null
v_npatanswer_count type text 2147483647  √  null
v_office_candidate candidate_id int4 10  √  null
v_office_candidate districtname varchar 2147483647  √  null
v_office_candidate districtname_id int2 5  √  null
v_office_candidate districtrank int2 5  √  null
v_office_candidate firstelect varchar 2147483647  √  null
v_office_candidate lastelect varchar 2147483647  √  null
v_office_candidate lowername varchar 2147483647  √  null
v_office_candidate nextelect varchar 2147483647  √  null
v_office_candidate office varchar 2147483647  √  null
v_office_candidate office_candidate_id int4 10  √  null
v_office_candidate office_id int2 5  √  null
v_office_candidate officecandidatestatus_id int2 5  √  null
v_office_candidate officecode varchar 2147483647  √  null
v_office_candidate officelevel_id bpchar 1  √  null
v_office_candidate officerank int2 5  √  null
v_office_candidate officeshorttitle varchar 2147483647  √  null
v_office_candidate officetitle varchar 2147483647  √  null
v_office_candidate officetype varchar 2147483647  √  null
v_office_candidate officetype_id bpchar 1  √  null
v_office_candidate party varchar 2147483647  √  null
v_office_candidate party_id int4 10  √  null
v_office_candidate state varchar 2147483647  √  null
v_office_candidate state_id bpchar 2  √  null
v_office_candidate status varchar 2147483647  √  null
v_office_candidate termend flexdate 2147483647  √  null
v_office_candidate termstart flexdate 2147483647  √  null
v_office_candidate uscircuit varchar 2147483647  √  null
v_office_candidate ushousename varchar 2147483647  √  null
v_party_average avg numeric 131089  √  null
v_party_average party_group text 2147483647  √  null
v_party_rating avg numeric 131089  √  null
v_party_rating party_group text 2147483647  √  null
v_pct_national_tally count int8 19  √  null
v_pct_national_tally level text 2147483647  √  null
v_pct_national_tally typename text 2147483647  √  null
v_pct_tally_all count int8 19  √  null
v_pct_tally_all electionyear int2 5  √  null
v_pct_tally_all level text 2147483647  √  null
v_pct_tally_all state bpchar 2  √  null
v_pct_tally_all typename text 2147483647  √  null
v_rating avg numeric 131089  √  null
v_rating party_group text 2147483647  √  null
v_request_vote action varchar 2147483647  √  null
v_request_vote billnumber varchar 2147483647  √  null
v_request_vote candidate_id int4 10  √  null
v_request_vote lastname varchar 2147483647  √  null
v_request_vote outcometext varchar 2147483647  √  null
v_request_vote pvslink text 2147483647  √  null
v_request_vote stage varchar 2147483647  √  null
v_running_mate candidate_id int4 10  √  null
v_running_mate candidatepreferredname_id bpchar 1  √  null
v_running_mate election_candidate_id int4 10  √  null
v_running_mate firstname varchar 2147483647  √  null
v_running_mate lastname varchar 2147483647  √  null
v_running_mate middlename varchar 2147483647  √  null
v_running_mate nickname varchar 2147483647  √  null
v_running_mate office_id int2 5  √  null
v_running_mate parent_id int4 10  √  null
v_running_mate rank int2 5  √  null
v_running_mate rm_candidate_id int4 10  √  null
v_running_mate rm_election_candidate_id int4 10  √  null
v_running_mate rm_office_id int2 5  √  null
v_running_mate rm_party varchar 2147483647  √  null
v_running_mate suffix varchar 2147483647  √  null
v_running_mate title varchar 2147483647  √  null
v_running_mate_check candidate_id int4 10  √  null
v_running_mate_check election_candidate_id int4 10  √  null
v_running_mate_check election_id int4 10  √  null
v_running_mate_check probably_correct_parent_id int4 10  √  null
v_running_mate_check wrong_parent_id int4 10  √  null
v_running_mate_test candidate_id int4 10  √  null
v_running_mate_test candidatepreferredname_id bpchar 1  √  null
v_running_mate_test election_candidate_id int4 10  √  null
v_running_mate_test firstname varchar 2147483647  √  null
v_running_mate_test lastname varchar 2147483647  √  null
v_running_mate_test middlename varchar 2147483647  √  null
v_running_mate_test nickname varchar 2147483647  √  null
v_running_mate_test office_id int2 5  √  null
v_running_mate_test parent_id int4 10  √  null
v_running_mate_test rank int2 5  √  null
v_running_mate_test rm_candidate_id int4 10  √  null
v_running_mate_test rm_office_id int2 5  √  null
v_running_mate_test rm_party varchar 2147483647  √  null
v_running_mate_test suffix varchar 2147483647  √  null
v_running_mate_test title varchar 2147483647  √  null
v_search_districtname districtname_id int2 5  √  null
v_search_districtname dn_name varchar 2147483647  √  null
v_search_districtname number int2 5  √  null
v_sig_rating rating_category varchar 2147483647  √  null
v_sig_rating rating_category_id int2 5  √  null
v_sig_rating rating_id int4 10  √  null
v_sig_rating rating_release_id int2 5  √  null
v_sig_rating ratingname varchar 2147483647  √  null
v_sig_rating ratingtext text 2147483647  √  null
v_sig_rating sig_category varchar 2147483647  √  null
v_sig_rating sig_category_id int2 5  √  null
v_sig_rating sig_id int4 10  √  null
v_sig_rating sig_release_id int2 5  √  null
v_sig_rating signame varchar 2147483647  √  null
v_sig_rating span varchar 2147483647  √  null
v_sig_rating_candidate candidate_id int4 10  √  null
v_sig_rating_candidate our_rating varchar 2147483647  √  null
v_sig_rating_candidate rating_category_id int2 5  √  null
v_sig_rating_candidate rating_id int4 10  √  null
v_sig_rating_candidate rating_release_id int2 5  √  null
v_sig_rating_candidate ratingcategory varchar 2147483647  √  null
v_sig_rating_candidate ratingname varchar 2147483647  √  null
v_sig_rating_candidate ratingtext text 2147483647  √  null
v_sig_rating_candidate sig_category_id int2 5  √  null
v_sig_rating_candidate sig_id int4 10  √  null
v_sig_rating_candidate sig_rating varchar 2147483647  √  null
v_sig_rating_candidate sig_release_id int2 5  √  null
v_sig_rating_candidate sigcategory varchar 2147483647  √  null
v_sig_rating_candidate signame varchar 2147483647  √  null
v_sig_rating_candidate span varchar 2147483647  √  null
v_sig_rating_candidate usesigrating bool 1  √  null
v_speech_category categories text 2147483647  √  null
v_speech_category manual bool 1  √  null
v_speech_category speech_id int4 10  √  null
v_speech_category speechdate date 13  √  null
v_speech_category speechtype_id int2 5  √  null
v_speech_category tags text 2147483647  √  null
v_speech_category title varchar 2147483647  √  null
v_speech_category year float8 17,17  √  null
v_speech_count count int8 19  √  null
v_speech_count type text 2147483647  √  null
v_tag_usage count int8 19  √  null
v_tag_usage name text 2147483647  √  null
v_tag_usage sect text 2147483647  √  null
v_tag_usage tag_id int4 10  √  null
v_with_rc avg numeric 131089  √  null
v_with_rc party_group text 2147483647  √  null
vacancy election_id int4 10  √  null
vacancy message text 2147483647 ''::text
vacancy office_candidate_id int4 10
vacancy vacancy_id serial 10  √  nextval('vacancy_id_seq'::regclass)
webaddresstype name varchar 2147483647 ''::character varying
webaddresstype rank int2 5  √  null
webaddresstype webaddresstype_id int2 5
website name text 2147483647  √  null
website rank int4 10  √  null
website website text 2147483647  √  null
website website_id serial 10  √  nextval('website_website_id_seq'::regclass)
zip2district centroidtype int2 5  √  null
zip2district countycode int2 5  √  null
zip2district peculiarity varchar 2147483647  √  null
zip2district recordtype int2 5  √  null
zip2district statecode int2 5  √  null
zip2district statelower int2 5  √  null
zip2district stateupper int2 5  √  null
zip2district ushouse int2 5  √  null
zip2district zip4end int2 5  √  null
zip2district zip4start int2 5  √  null
zip2district zip5 int4 10  √  null
zip2district_old centroidtype int2 5  √  null
zip2district_old countycode int2 5  √  null
zip2district_old peculiarity varchar 2147483647  √  null
zip2district_old recordtype int2 5  √  null
zip2district_old statecode int2 5  √  null
zip2district_old statelower int2 5  √  null
zip2district_old stateupper int2 5  √  null
zip2district_old ushouse int2 5  √  null
zip2district_old zip4end int2 5  √  null
zip2district_old zip4start int2 5  √  null
zip2district_old zip5 int4 10  √  null
zip2redistrict centroidtype int2 5  √  null
zip2redistrict countycode int2 5  √  null
zip2redistrict peculiarity varchar 2147483647  √  null
zip2redistrict recordtype int2 5  √  null
zip2redistrict statecode int2 5  √  null
zip2redistrict statelower int2 5  √  null
zip2redistrict stateupper int2 5  √  null
zip2redistrict ushouse int2 5  √  null
zip2redistrict zip4end int2 5  √  null
zip2redistrict zip4start int2 5  √  null
zip2redistrict zip5 int4 10  √  null
zip2redistrict_old centroidtype int2 5  √  null
zip2redistrict_old countycode int2 5  √  null
zip2redistrict_old peculiarity varchar 2147483647  √  null
zip2redistrict_old recordtype int2 5  √  null
zip2redistrict_old statecode int2 5  √  null
zip2redistrict_old statelower int2 5  √  null
zip2redistrict_old stateupper int2 5  √  null
zip2redistrict_old ushouse int2 5  √  null
zip2redistrict_old zip4end int2 5  √  null
zip2redistrict_old zip4start int2 5  √  null
zip2redistrict_old zip5 int4 10  √  null
zipcode areacode varchar 2147483647  √  null
zipcode city varchar 2147483647  √  null
zipcode classcode varchar 2147483647  √  null
zipcode county varchar 2147483647  √  null
zipcode countycode int2 5  √  null
zipcode daylightsavings bool 1  √  null
zipcode elevation int2 5  √  null
zipcode latitude numeric 131089  √  null
zipcode longitude numeric 131089  √  null
zipcode multicounty bool 1  √  null
zipcode state bpchar 2  √  null
zipcode statecode int2 5  √  null
zipcode timezone int2 5  √  null
zipcode zipcode_id int4 10  √  null
zipcode zipcode_pk serial 10  √  nextval('zipcode_zipcode_pk_seq'::regclass)
zipcode_local local_id int4 10  √  null
zipcode_local zip5 int4 10  √  null
zipcode_local zipcode_local_id serial 10  √  nextval('zipcode_local_zipcode_local_id_seq'::regclass)