pvsadmin.public contains 1737 columns - click on heading to sort:

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