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

Table	Column	Type	Size	Nulls	Auto	Default	Comments
raster_columns	out_db	_bool	1	√		null
v_election_current	states	_bpchar	2	√		null
raster_columns	nodata_values	_float8	17,17	√		null
v_category_released	released	_int2	5	√		null
raster_columns	pixel_types	_text	2147483647	√		null
v_election_current	active_stages	_varchar	2147483647	√		null
additional	active	bool	1	√		null
committee	active	bool	1			true
committee_archive	active	bool	1			true
committee_positions	active	bool	1	√		null
addresstype	addcity	bool	1			false
office_candidate	appointed	bool	1	√		null
office_state	appointed	bool	1	√		null
state	atlarge	bool	1			false
state	bicameral	bool	1			false
state	caucus	bool	1	√		null
biotextlocking	committed	bool	1			false
npatanswerlocking	committed	bool	1			false
speechlocking	committed	bool	1			false
zipcode	daylightsavings	bool	1	√		null
tag	deleted	bool	1			false
electioncandidatestatus	display	bool	1	√		null
education	graduated	bool	1	√		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
category	key	bool	1			false
speech	key	bool	1	√		null
congstatus	keyvote	bool	1			false
v_congstatus	keyvote	bool	1	√		null
speechlock	lock	bool	1
state	ltgov	bool	1			false
election_candidate	major	bool	1	√		null
sig	major	bool	1	√		null
v_speech_category	manual	bool	1	√		null
zipcode	multicounty	bool	1	√		null
contact_candidate	notable	bool	1			false
election_address	npataddress	bool	1	√		null
mailmerge	npataddress	bool	1	√		null
office_address	npataddress	bool	1			false
election_electionstage	npatmailed	bool	1			false
v_election	npatmailed	bool	1	√		null
v_election_candidate	npatmailed	bool	1	√		null
office	npatoffice	bool	1			false
npatrowtype	open	bool	1			false
v_npat	open	bool	1	√		null
npatcandidate	processed	bool	1	√		null
npatform_def	profile	bool	1			false
npatrow	profile	bool	1	√		null
npatrow_p	profile	bool	1			false
v_npat	profile	bool	1	√		null
sig	ratinggroup	bool	1	√		null
raster_columns	regular_blocking	bool	1	√		null
raster_columns	same_alignment	bool	1	√		null
committee	special	bool	1	√		null
committee_archive	special	bool	1	√		null
election	special	bool	1			false
v_election	special	bool	1	√		null
v_election_current	special	bool	1	√		null
conglevel_office	stateleg	bool	1
election_electionstage	tentative	bool	1	√		null
rating	usesigrating	bool	1	√		null
sig	usesigrating	bool	1	√		null
v_sig_rating_candidate	usesigrating	bool	1	√		null
congstatus	voicevote	bool	1			false
v_congstatus	voicevote	bool	1	√		null
v_congstatus_candidate	voicevote	bool	1	√		null
congstage	voting	bool	1			false
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
npatoption	code	bpchar	1	√		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
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
congaction	congactiontype_id	bpchar	1	√		null
congactiontype	congactiontype_id	bpchar	1
v_congstatus_candidate	congactiontype_id	bpchar	1	√		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_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
districttype	districttype_id	bpchar	1
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
endorser	endorsertype_id	bpchar	1	√		null
endorsergroup	endorsertype_id	bpchar	1	√		null
endorsertype	endorsertype_id	bpchar	1
biotype	experiencetype_id	bpchar	1	√		null
experience	experiencetype_id	bpchar	1
experiencetype	experiencetype_id	bpchar	1
candidate	gender	bpchar	1			''::bpchar
local	localtype_id	bpchar	1
localtype	localtype_id	bpchar	1
measure	measuretype_id	bpchar	1	√		null
measuretype	measuretype_id	bpchar	1
npatgroup	npatgrouptype_id	bpchar	1	√		null
npatgrouptype	npatgrouptype_id	bpchar	1
npatmessage	npatmessagetype_id	bpchar	1
npatmessagetype	npatmessagetype_id	bpchar	1
npatproblem	npatproblem_id	bpchar	1
npatproblem_npatcandidate	npatproblem_id	bpchar	1	√		null
npatcandidate	npatstatus_id	bpchar	1			'P'::bpchar
npatstatus	npatstatus_id	bpchar	1
officebranch	officebranch_id	bpchar	1
officetype	officebranch_id	bpchar	1
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
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
primarytype	primarytype_id	bpchar	1
primarytype_state	primarytype_id	bpchar	1	√		null
addr2zip	record_type	bpchar	1	√		null
addr2zip	secondary_address_parity	bpchar	1	√		null
category_section	section_id	bpchar	1
section	section_id	bpchar	1
sigtype	sigtype	bpchar	1
state	statetype_id	bpchar	1	√		null
statetype	statetype_id	bpchar	1
v_election	election_electionstage_state_id	bpchar	2	√		null
v_election_candidate	election_electionstage_state_id	bpchar	2	√		null
committee	state	bpchar	2	√		null
committee_archive	state	bpchar	2	√		null
election_address	state	bpchar	2	√		null
electionoffice	state	bpchar	2
office_address	state	bpchar	2	√		null
resource	state	bpchar	2	√		null
sig	state	bpchar	2	√		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
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
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
mailmerge	deadline	date	13	√		null
npatform	deadline	date	13	√		null
npatgroup_state	deadline	date	13	√		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
election_electionstage	filingdeadline	date	13	√		null
v_election	filingdeadline	date	13	√		null
state	generaldate	date	13	√		null
election_electionstage	independentfiling	date	13	√		null
v_election	independentfiling	date	13	√		null
npatgroup_state	maildate	date	13	√		null
election_electionstage	majorfiling	date	13	√		null
v_election	majorfiling	date	13	√		null
state	primarydate	date	13	√		null
npatgroup_state	releasedate	date	13	√		null
speech	speechdate	date	13	√		now()
v_speech_category	speechdate	date	13	√		null
congstatus	statusdate	date	13
v_congstatus	statusdate	date	13	√		null
v_congstatus_candidate	statusdate	date	13	√		null
election_electionstage	thirdfiling	date	13	√		null
v_election	thirdfiling	date	13	√		null
election_electionstage	writeinfiling	date	13	√		null
v_election	writeinfiling	date	13	√		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
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
raster_columns	scale_x	float8	17,17	√		null
raster_columns	scale_y	float8	17,17	√		null
v_speech_category	year	float8	17,17	√		null
raster_columns	extent	geometry	2147483647	√		null
legislativedistricts_gis	geom	geometry	2147483647	√		null
django_admin_log	action_flag	int2	5
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
candidate	bioformyear	int2	5	√		null
biotext	biotype_id	int2	5	√		null
biotype	biotype_id	int2	5
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
candidatestatus	candidatestatus_id	int2	5		√	nextval(('candidatestatus_id_seq'::text)::regclass)
candidate	candidatetitle_id	int2	5			0
candidatetitle	candidatetitle_id	int2	5		√	nextval(('candidatestatus_id_seq'::text)::regclass)
additional_candidate_category	category_id	int2	5
additional_category	category_id	int2	5
biotext_category	category_id	int2	5
category	category_id	int2	5		√	nextval(('category_id_seq'::text)::regclass)
category_section	category_id	int2	5
committee_category	category_id	int2	5
congcategory_category	category_id	int2	5
experience_category	category_id	int2	5
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_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
category_section	category_section_id	int2	5		√	nextval('category_section_id_seq'::regclass)
zip2district	centroidtype	int2	5	√		null
zip2district_old	centroidtype	int2	5	√		null
zip2redistrict	centroidtype	int2	5	√		null
zip2redistrict_old	centroidtype	int2	5	√		null
conglevel_office	conglevel_office_id	int2	5		√	nextval(('conglevel_office_id_seq'::text)::regclass)
congnote	congnote_id	int2	5		√	nextval(('congnote_id_seq'::text)::regclass)
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
congnote_state	congnote_state_id	int2	5		√	nextval(('congnote_state_id_seq'::text)::regclass)
congoutcome	congoutcome_id	int2	5		√	nextval(('congoutcome_id_seq'::text)::regclass)
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
congoutcometext	congoutcometext_id	int2	5		√	nextval('congoutcometext_id_seq'::regclass)
congtools	congoutcometext_id	int2	5
congprefix	congprefix_id	int2	5		√	nextval(('congprefix_id_seq'::text)::regclass)
congprefix_state	congprefix_id	int2	5
congprefix_state	congprefix_state_id	int2	5		√	nextval(('congprefix_state_id_seq'::text)::regclass)
v_congstatus	congress_release_id	int2	5	√		null
v_congstatus_candidate	congress_release_id	int2	5	√		null
congnote_stage	congstage_id	int2	5
congstage	congstage_id	int2	5		√	nextval(('congstage_id_seq'::text)::regclass)
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
v_congstatus	congstatus_release_id	int2	5	√		null
v_congstatus_candidate	congstatus_release_id	int2	5	√		null
contact_candidate	contactmode_id	int2	5
contactmode	contactmode_id	int2	5		√	nextval(('contactmode_id_seq'::text)::regclass)
contact_candidate	contactoutcome_id	int2	5
contactoutcome	contactoutcome_id	int2	5		√	nextval(('contactoutcome_id_seq'::text)::regclass)
contact_candidate	contacttype_id	int2	5
contacttype	contacttype_id	int2	5		√	nextval(('contacttype_id_seq'::text)::regclass)
addr2zip	county_code	int2	5	√		null
county	county_id	int2	5
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
electionstage_candidate	delegate	int2	5	√		null
state	delegatedem	int2	5	√		null
state	delegaterep	int2	5	√		null
district	districtname_id	int2	5
districtname	districtname_id	int2	5		√	nextval('districtname_id_seq'::regclass)
election_candidate	districtname_id	int2	5	√		null
election_districtname	districtname_id	int2	5
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
v_election	election_electionstage_release_id	int2	5	√		null
electioncandidatestatus	electioncandidatestatus_id	int2	5		√	nextval(('electioncandidatestatus_id_seq'::text)::regclass)
electionstage_candidate	electioncandidatestatus_id	int2	5
v_election_candidate	electioncandidatestatus_id	int2	5	√		null
v_election	electionstage_rank	int2	5	√		null
v_election_candidate	electionstage_release_id	int2	5	√		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
pyadmin_tasks	end_id	int2	5	√		null
etl_job	etl_status_id	int2	5	√		null
finance_candidate	finance_catcode_id	int2	5
finance_candidate	finsource_id	int2	5
finance_catcode	finsource_id	int2	5	√		null
finance_catcode	imsp_industry_code	int2	5	√		null
leadership	leadership_id	int2	5		√	nextval(('leadership_id_seq'::text)::regclass)
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	leadership_state_id	int2	5		√	nextval('leadership_state_id_seq'::regclass)
leadership_state_office	leadership_state_id	int2	5
v_leadership	leadershiprank	int2	5	√		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
office_state	nextelect	int2	5	√		null
v_npat	nm_rank	int2	5	√		null
election_electionstage	npatrelease_id	int2	5	√		null
v_election	npatrelease_id	int2	5	√		null
v_election_candidate	npatrelease_id	int2	5	√		null
v_search_districtname	number	int2	5	√		null
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
office	office_id	int2	5		√	nextval(('public.office_id_seq'::text)::regclass)
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
office_candidate	officecandidatestatus_id	int2	5
officecandidatestatus	officecandidatestatus_id	int2	5		√	nextval(('officecandidatestatus_id_seq'::text)::regclass)
v_office_candidate	officecandidatestatus_id	int2	5	√		null
v_election	officelevel_rank	int2	5	√		null
v_election_candidate	officerank	int2	5	√		null
v_office_candidate	officerank	int2	5	√		null
v_election	officetype_rank	int2	5	√		null
resourcetype	parent_id	int2	5	√		null
office_candidate_party	party_id	int2	5
npatcandidate	pct	int2	5	√		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
npatgroup	rank	int2	5	√		null
npatmatrix	rank	int2	5			0
npatmatrix_p	rank	int2	5			0
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
v_sig_rating	rating_category_id	int2	5	√		null
v_sig_rating_candidate	rating_category_id	int2	5	√		null
v_sig_rating	rating_release_id	int2	5	√		null
v_sig_rating_candidate	rating_release_id	int2	5	√		null
rating	ratingformat_id	int2	5
ratingformat	ratingformat_id	int2	5		√	nextval(('ratingformat_id_seq'::text)::regclass)
rating	ratingsession_id	int2	5			(-1)
ratingsession	ratingsession_id	int2	5		√	nextval(('ratingsession_id_seq'::text)::regclass)
ratingtext	ratingtext_id	int2	5		√	nextval(('ratingtext_id_seq'::text)::regclass)
zip2district	recordtype	int2	5	√		null
zip2district_old	recordtype	int2	5	√		null
zip2redistrict	recordtype	int2	5	√		null
zip2redistrict_old	recordtype	int2	5	√		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
category_released	released_category_id	int2	5	√		null
category_released_new	released_category_id	int2	5	√		null
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_office_id	int2	5	√		null
v_running_mate_test	rm_office_id	int2	5	√		null
congstatus	rollnumber	int2	5	√		null
v_congstatus	rollnumber	int2	5	√		null
v_congstatus_candidate	rollnumber	int2	5	√		null
state	senators	int2	5			0
v_sig_rating	sig_category_id	int2	5	√		null
v_sig_rating_candidate	sig_category_id	int2	5	√		null
v_sig_rating	sig_release_id	int2	5	√		null
v_sig_rating_candidate	sig_release_id	int2	5	√		null
speech	speechtype_id	int2	5
speechtype	speechtype_id	int2	5		√	nextval(('speechtype_id_seq'::text)::regclass)
v_speech_category	speechtype_id	int2	5	√		null
pyadmin_tasks	start_id	int2	5	√		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
zip2district	statelower	int2	5	√		null
zip2district_old	statelower	int2	5	√		null
zip2redistrict	statelower	int2	5	√		null
zip2redistrict_old	statelower	int2	5	√		null
zip2district	stateupper	int2	5	√		null
zip2district_old	stateupper	int2	5	√		null
zip2redistrict	stateupper	int2	5	√		null
zip2redistrict_old	stateupper	int2	5	√		null
office_state	termlength	int2	5	√		null
state	termlength	int2	5			0
office_state	termlimit	int2	5	√		null
state	termlimit	int2	5			0
zipcode	timezone	int2	5	√		null
category_released	unreleased_category_id	int2	5	√		null
category_released_new	unreleased_category_id	int2	5	√		null
zip2district	ushouse	int2	5	√		null
zip2district_old	ushouse	int2	5	√		null
zip2redistrict	ushouse	int2	5	√		null
zip2redistrict_old	ushouse	int2	5	√		null
election_webaddress	webaddresstype_id	int2	5
office_webaddress	webaddresstype_id	int2	5
webaddresstype	webaddresstype_id	int2	5
npatform_def	wordlimit	int2	5			0
npatrow	wordlimit	int2	5	√		null
npatrow_p	wordlimit	int2	5	√		null
v_npat	wordlimit	int2	5	√		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
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
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
spatial_ref_sys	auth_srid	int4	10	√		null
mv_rating_party_average	average	int4	10	√		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
raster_columns	blocksize_x	int4	10	√		null
raster_columns	blocksize_y	int4	10	√		null
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
catcode_category	category_id	int4	10
category_category	category_id	int4	10
category_tag	category_id	int4	10	√		null
education_category	category_id	int4	10	√		null
factcheck_category	category_id	int4	10	√		null
v_blog_categories	category_id	int4	10	√		null
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_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
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
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
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
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
congstatus	congsynopsis_id	int4	10	√		null
v_congstatus	congsynopsis_id	int4	10	√		null
v_congstatus_candidate	congsynopsis_id	int4	10	√		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
congstatus_vetotext	congvetotext_id	int4	10
v_featured_items	content_id	int4	10	√		null
auth_permission	content_type_id	int4	10
django_admin_log	content_type_id	int4	10	√		null
geography_columns	coord_dimension	int4	10	√		null
geometry_columns	coord_dimension	int4	10	√		null
ctystate	county_no	int4	10	√		null
legislativedistricts_gis	districtname_id	int4	10	√		null
education_category	education_id	int4	10	√		null
education_tag	education_id	int4	10	√		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
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_party	electionstage_candidate_id	int4	10
v_election_candidate	electionstage_candidate_id	int4	10	√		null
endorse_candidate	endorse_id	int4	10
endorser_candidate	endorser_id	int4	10
endorsergroup_candidate	endorsergroup_id	int4	10
etl_file	etl_job_id	int4	10	√		null
etl_sigratings_files	etl_sigratings_harvest_jobs_id	int4	10	√		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
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
featured_tag	featured_id	int4	10
v_featured_items	featured_id	int4	10	√		null
catcode_category	finance_catcode_id	int4	10
finsource_candidate	finsource_id	int4	10
auth_group_permissions	group_id	int4	10
auth_user_groups	group_id	int4	10
v_candidate_timeline	id1	int4	10	√		null
v_candidate_timeline	id2	int4	10	√		null
v_category	level	int4	10	√		null
v_category_new	level	int4	10	√		null
v_category_released	level	int4	10	√		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
mailmerge	mailmerge_id	int4	10	√		null
measure_category	measure_id	int4	10
measure_tag	measure_id	int4	10	√		null
merge_candidate	new_id	int4	10	√		null
measure	no	int4	10	√		null
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
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
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
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
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
raster_columns	num_bands	int4	10	√		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
legislativedistricts_gis	office_id	int4	10	√		null
merge_candidate	old_id	int4	10	√		null
npatanswer	our_npatoption_id	int4	10	√		null
npatanswer_backup	our_npatoption_id	int4	10	√		null
raster_overviews	overview_factor	int4	10	√		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
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
election_electionstage	party_id	int4	10	√		null
electionstage_candidate_party	party_id	int4	10
endorser	party_id	int4	10	√		null
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
auth_group_permissions	permission_id	int4	10
auth_user_user_permissions	permission_id	int4	10
v_running_mate_check	probably_correct_parent_id	int4	10	√		null
npatanswerlocking	rank	int4	10	√		null
npatoption	rank	int4	10
website	rank	int4	10	√		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_featured_items	release_id	int4	10	√		null
religion_category	religion_id	int4	10	√		null
religion_tag	religion_id	int4	10
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
npatform_def	rowtype_id	int4	10
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
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
geography_columns	srid	int4	10	√		null
geometry_columns	srid	int4	10	√		null
raster_columns	srid	int4	10	√		null
spatial_ref_sys	srid	int4	10
pingpong	status	int4	10	√		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
auth_user_groups	user_id	int4	10
auth_user_user_permissions	user_id	int4	10
django_admin_log	user_id	int4	10
electionstage_candidate	votecount	int4	10	√		null
v_running_mate_check	wrong_parent_id	int4	10	√		null
measure	yes	int4	10	√		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
v_election_current	contests	int8	19	√		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
finance_candidate	dollars	int8	19	√		null
v_congstatusparty	tally	int8	19	√		null
v_election_current	total_candidates	int8	19	√		null
stat	value	int8	19	√		null
featured	photos	json	2147483647	√		null
v_category_new	lpath	ltree	2147483647	√		null
congress	path	ltree	2147483647			text2ltree((currval('congress_id_seq'::regclass))::text)
npatmatrix	path	ltree	2147483647
npatmatrix_p	path	ltree	2147483647
v_npat	path	ltree	2147483647	√		null
v_highest_stage	election	name	2147483647	√		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
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_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
education	gpa	numeric	2,1	√		null
electionstage_candidate	votepercent	numeric	16,4	√		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
zipcode	latitude	numeric	131089	√		null
zipcode	longitude	numeric	131089	√		null
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)
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_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)
congnote_congress	congnote_congress_id	serial	10		√	nextval('congnote_congress_id_seq'::regclass)
congnote_stage	congnote_stage_id	serial	10		√	nextval('congnote_stage_id_seq'::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)
congress	congress_id	serial	10		√	nextval('congress_id_seq'::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)
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)
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)
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_office	leadership_office_id	serial	10		√	nextval('leadership_office_leadership_office_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_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)
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)
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)
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
mailmerge	address	text	2147483647	√		null
tagalias	alias	text	2147483647
npatanswer	answertext	text	2147483647			''::text
npatanswer_backup	answertext	text	2147483647	√		null
biotext	biotext	text	2147483647	√		null
candidate	callnote	text	2147483647			''::text
v_speech_category	categories	text	2147483647	√		null
candidate	caucus	text	2147483647	√		''::text
django_admin_log	change_message	text	2147483647
npatcitation	citation	text	2147483647
mailmerge	city	text	2147483647	√		null
congtext	congtext	text	2147483647	√		null
mailmerge	contactname	text	2147483647	√		null
mailmerge	contacttitle	text	2147483647	√		null
v_featured_items	data_type	text	2147483647	√		null
education	degree	text	2147483647	√		null
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
experience	district	text	2147483647	√		null
mailmerge	districtname	text	2147483647	√		null
candidate	education	text	2147483647	√		''::text
v_election	electionname	text	2147483647	√		null
v_electionname	electionname	text	2147483647	√		null
mailmerge	email	text	2147483647	√		null
etl_file	errors	text	2147483647	√		null
etl_job	errors	text	2147483647	√		null
candidate	family	text	2147483647			''::text
education	field	text	2147483647	√		null
congdoc	filename	text	2147483647	√		null
mailmerge	firstname	text	2147483647	√		null
education	fulltext	text	2147483647	√		null
experience	fulltext	text	2147483647	√		null
conghighlight	highlight	text	2147483647
v_congstatus	highlight	text	2147483647	√		null
v_congstatus_candidate	highlight	text	2147483647	√		null
committee	jurisdiction	text	2147483647			''::text
committee_archive	jurisdiction	text	2147483647			''::text
mailmerge	lastname	text	2147483647	√		null
v_election_current	latest_stage	text	2147483647	√		null
v_pct_national_tally	level	text	2147483647	√		null
v_pct_tally_all	level	text	2147483647	√		null
measure	measuretext	text	2147483647	√		null
contact_candidate	message	text	2147483647			''::character varying
npatmessage	message	text	2147483647			''::text
vacancy	message	text	2147483647			''::text
mailmerge	middlename	text	2147483647	√		null
resource	mission	text	2147483647	√		null
biotype	name	text	2147483647	√		null
congdoc	name	text	2147483647			''::text
congtext	name	text	2147483647	√		null
degree	name	text	2147483647	√		null
experiencetype	name	text	2147483647
factchecker	name	text	2147483647
factcheckruling	name	text	2147483647	√		null
stat	name	text	2147483647	√		null
tag	name	text	2147483647
v_tag_usage	name	text	2147483647	√		null
website	name	text	2147483647	√		null
contact_candidate	note	text	2147483647			''::text
election_address	note	text	2147483647	√		null
office_address	note	text	2147483647	√		null
sig	note	text	2147483647	√		null
v_npat	npatrow_text	text	2147483647	√		null
django_admin_log	object_id	text	2147483647	√		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
experience	organization	text	2147483647	√		null
profession	organization	text	2147483647	√		null
candidate	orgmember	text	2147483647	√		''::text
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
v_congstatusparty	party_name	text	2147483647	√		null
mailmerge	password	text	2147483647	√		null
candidate	political	text	2147483647	√		''::text
npatproblem	problem	text	2147483647	√		null
candidate	profession	text	2147483647	√		''::text
v_request_vote	pvslink	text	2147483647	√		null
speech	quote	text	2147483647	√		null
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
state	registration	text	2147483647			''::text
candidate	religion	text	2147483647			''::text
npatform_def	rowtext	text	2147483647			''::text
npatrowtext	rowtext	text	2147483647			''::text
npatrowtext_p	rowtext	text	2147483647			''::text
factcheck	ruling	text	2147483647	√		null
education	school	text	2147483647	√		null
v_tag_usage	sect	text	2147483647	√		null
mailmerge	seekingtitle	text	2147483647	√		null
django_session	session_data	text	2147483647
npatrowshorttext	shortcategory	text	2147483647
experiencetype	shortname	text	2147483647	√		null
npatrowshorttext	shorttext	text	2147483647	√		null
v_name_slug	slug	text	2147483647	√		null
education	span	text	2147483647	√		null
experience	span	text	2147483647	√		null
profession	span	text	2147483647	√		null
experience	special	text	2147483647	√		null
candidate	specialmsg	text	2147483647			''::text
office_candidate	specialmsg	text	2147483647			''::text
speech	speechtext	text	2147483647
stat	stat_id	text	2147483647
mailmerge	state	text	2147483647	√		null
mailmerge	status	text	2147483647	√		null
npatrowshorttext	subcategory	text	2147483647	√		null
mailmerge	suffix	text	2147483647	√		null
measure	summary	text	2147483647	√		null
speech	summary	text	2147483647	√		null
congsynopsis	synopsis	text	2147483647
v_congstatus	synopsis	text	2147483647	√		null
v_congstatus_candidate	synopsis	text	2147483647	√		null
v_speech_category	tags	text	2147483647	√		null
experience	title	text	2147483647	√		null
mailmerge	title	text	2147483647	√		null
profession	title	text	2147483647	√		null
v_candidate_timeline	title	text	2147483647	√		null
v_featured_items	title	text	2147483647	√		null
pvs_encoding	translate	text	2147483647	√		null
geography_columns	type	text	2147483647	√		null
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
factcheck	url	text	2147483647	√		null
factchecker	url	text	2147483647
finsource	url	text	2147483647	√		null
npatcitation	url	text	2147483647	√		null
website	website	text	2147483647	√		null
mailmerge	zip	text	2147483647	√		null
biotextlocking	accessed	timestamp	29,6	√		null
npatanswerlocking	accessed	timestamp	29,6	√		null
speechlocking	accessed	timestamp	29,6	√		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
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_candidate	date	timestamp	29,6	√		null
v_featured_items	dated	timestamp	29,6	√		null
pingpong	datetime	timestamp	29,6	√		now()
speechlock	expire	timestamp	29,6
pingpong_harvest	last_modified	timestamp	29,6	√		now()
npatcandidate	lastimport	timestamp	29,6	√		null
user	lastlogin	timestamp	29,6	√		null
npatcandidate	lastupdate	timestamp	29,6	√		null
merge_candidate	merged	timestamp	29,6			now()
mailmerge	mergedate	timestamp	29,6			now()
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
etl_job	started	timestamp	29,6	√		null
etl_sigratings_harvest_jobs	started_datetime	timestamp	29,6	√		null
finsource_candidate	updated	timestamp	29,6	√		null
v_candidate_timeline	when	timestamp	29,6	√		null
django_admin_log	action_time	timestamptz	35,6
django_migrations	applied	timestamptz	35,6
contact_candidate	date	timestamptz	35,6			now()
auth_user	date_joined	timestamptz	35,6
django_session	expire_date	timestamptz	35,6
auth_user	last_login	timestamptz	35,6	√		null
npatcandidate	receiveddate	timestamptz	35,6	√		null
speech	speech_tsv	tsvector	2147483647	√		null
auth_user	first_name	varchar	30
auth_user	last_name	varchar	30
geometry_columns	type	varchar	30	√		null
auth_user	username	varchar	30
django_session	session_key	varchar	40
auth_group	name	varchar	80
django_content_type	app_label	varchar	100
auth_permission	codename	varchar	100
django_content_type	model	varchar	100
auth_user	password	varchar	128
django_admin_log	object_repr	varchar	200
auth_user	email	varchar	254
django_migrations	app	varchar	255
auth_permission	name	varchar	255
django_migrations	name	varchar	255
spatial_ref_sys	auth_name	varchar	256	√		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
spatial_ref_sys	proj4text	varchar	2048	√		null
spatial_ref_sys	srtext	varchar	2048	√		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
addr2zip	addr2zip_id	varchar	2147483647
election_address	address	varchar	2147483647	√		null
electionoffice	address	varchar	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
legislativedistricts_gis	affgeoid	varchar	2147483647	√		null
state	area	varchar	2147483647	√		null
zipcode	areacode	varchar	2147483647	√		null
election_candidate	ballotname	varchar	2147483647	√		null
v_election_candidate	ballotname	varchar	2147483647	√		null
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	bioid	varchar	2147483647	√		null
state	bird	varchar	2147483647			''::character varying
candidate	birthdate	varchar	2147483647			''::character varying
candidate	birthplace	varchar	2147483647			''::character varying
addr2zip	building_or_firm_name	varchar	2147483647	√		null
state	capital	varchar	2147483647			''::character varying
finance_catcode	catcode	varchar	2147483647	√		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
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
office	code	varchar	2147483647			''::character varying
committee_positions	committee_name	varchar	2147483647	√		null
committee_positions	committee_position	varchar	2147483647	√		null
local	committeeurl	varchar	2147483647	√		null
v_congstatus_candidate	congaction	varchar	2147483647	√		null
v_congstatus_candidate	congactioncode	varchar	2147483647	√		null
v_congstatus	congress_note	varchar	2147483647	√		null
v_congstatus_candidate	congress_note	varchar	2147483647	√		null
v_congstatus	congstatus_note	varchar	2147483647	√		null
v_congstatus_candidate	congstatus_note	varchar	2147483647	√		null
election_address	contactname	varchar	2147483647	√		null
office_address	contactname	varchar	2147483647	√		null
sig	contactname	varchar	2147483647			''::character varying
contact_candidate	contactstring	varchar	2147483647			''::character varying
election_address	contacttitle	varchar	2147483647	√		null
office_address	contacttitle	varchar	2147483647	√		null
measure	conurl	varchar	2147483647	√		null
zipcode	county	varchar	2147483647	√		null
ctystate	county_name	varchar	2147483647	√		null
finance_catcode	crp_indcode	varchar	2147483647	√		null
v_election_candidate	districtname	varchar	2147483647	√		null
v_office_candidate	districtname	varchar	2147483647	√		null
v_search_districtname	dn_name	varchar	2147483647	√		null
v_election	electionstage	varchar	2147483647	√		null
v_election_candidate	electionstage	varchar	2147483647	√		null
measure	electiontype	varchar	2147483647	√		null
committee	email	varchar	2147483647			''::character varying
committee_archive	email	varchar	2147483647			''::character varying
electionoffice	email	varchar	2147483647	√		null
resource	email	varchar	2147483647	√		null
sig	email	varchar	2147483647			''::character varying
etl_sigratings_harvest_jobs	errors	varchar	2147483647	√		null
v_candidate_timeline	extra	varchar	2147483647	√		null
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
candidate	fecid	varchar	2147483647			''::bpchar
etl_file	file_system_path	varchar	2147483647	√		null
etl_sigratings_files	file_system_path	varchar	2147483647	√		null
local	financeurl	varchar	2147483647	√		null
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
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
state	high	varchar	2147483647			''::character varying
v_highest_stage	higheststage	varchar	2147483647	√		null
candidate	homecity	varchar	2147483647			''::character varying
electionoffice	hours	varchar	2147483647	√		null
resource	hours	varchar	2147483647	√		null
office_candidate	importid	varchar	2147483647			''::character varying
finance_catcode	industry	varchar	2147483647	√		null
state	largestcity	varchar	2147483647			''::character varying
office_candidate	lastelect	varchar	2147483647	√		null
v_office_candidate	lastelect	varchar	2147483647	√		null
candidate	lastname	varchar	2147483647			''::character varying
committee_positions	lastname	varchar	2147483647	√		null
v_request_vote	lastname	varchar	2147483647	√		null
v_running_mate	lastname	varchar	2147483647	√		null
v_running_mate_test	lastname	varchar	2147483647	√		null
congress	law	varchar	2147483647			''::character varying
v_leadership	leadership	varchar	2147483647	√		null
state	legisname	varchar	2147483647			''::character varying
v_congstatus	level	varchar	2147483647	√		null
v_congstatus_candidate	level	varchar	2147483647	√		null
speech	location	varchar	2147483647			''::character varying
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
candidate	middlename	varchar	2147483647			''::character varying
v_running_mate	middlename	varchar	2147483647	√		null
v_running_mate_test	middlename	varchar	2147483647	√		null
state	motto	varchar	2147483647			''::character varying
addr2zip	municipality_key	varchar	2147483647	√		null
additional	name	varchar	2147483647			''::character varying
addresstype	name	varchar	2147483647			''::character varying
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
conglevel	name	varchar	2147483647
congnote	name	varchar	2147483647
congoutcome	name	varchar	2147483647
congprefix	name	varchar	2147483647
congstage	name	varchar	2147483647
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
districtname	name	varchar	2147483647
districttype	name	varchar	2147483647
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
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
state	name	varchar	2147483647			''::character varying
statetype	name	varchar	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
webaddresstype	name	varchar	2147483647			''::character varying
office_candidate	nextelect	varchar	2147483647	√		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
congnote	note	varchar	2147483647
user	notes	varchar	2147483647			''::character varying
npatcandidate	npatgroup_id	varchar	2147483647	√		null
npatgroup	npatgroup_id	varchar	2147483647
npatgroup_state	npatgroup_id	varchar	2147483647
v_election_candidate	office	varchar	2147483647	√		null
v_office_candidate	office	varchar	2147483647	√		null
v_election_candidate	officecode	varchar	2147483647	√		null
v_office_candidate	officecode	varchar	2147483647	√		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
npatoptiontext	optiontext	varchar	2147483647			''::character varying
etl_file	original_name	varchar	2147483647	√		null
etl_sigratings_files	original_name	varchar	2147483647	√		null
rating_candidate	our_rating	varchar	2147483647
v_sig_rating_candidate	our_rating	varchar	2147483647	√		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
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
v_election_candidate	party	varchar	2147483647	√		null
v_office_candidate	party	varchar	2147483647	√		null
candidate	password	varchar	2147483647	√		null
user	password	varchar	2147483647
congtext	path	varchar	2147483647	√		null
congvetotext	path	varchar	2147483647
npatform_def	path	varchar	2147483647			''::character varying
v_category	path	varchar	2147483647	√		null
v_category_new	path	varchar	2147483647	√		null
zip2district	peculiarity	varchar	2147483647	√		null
zip2district_old	peculiarity	varchar	2147483647	√		null
zip2redistrict	peculiarity	varchar	2147483647	√		null
zip2redistrict_old	peculiarity	varchar	2147483647	√		null
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
candidate	photourl	varchar	2147483647			''::character varying
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
endorser	profession	varchar	2147483647	√		null
candidate	pronunciation	varchar	2147483647			''::character varying
measure	prourl	varchar	2147483647	√		null
v_sig_rating	rating_category	varchar	2147483647	√		null
v_sig_rating_candidate	ratingcategory	varchar	2147483647	√		null
v_sig_rating	ratingname	varchar	2147483647	√		null
v_sig_rating_candidate	ratingname	varchar	2147483647	√		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
state	rollupper	varchar	2147483647	√		null
addr2zip	secondary_address	varchar	2147483647	√		null
addr2zip	secondary_address_high	varchar	2147483647	√		null
addr2zip	secondary_address_low	varchar	2147483647	√		null
finance_catcode	sector	varchar	2147483647	√		null
speechlock	session_id	varchar	2147483647
office	shorttitle	varchar	2147483647	√		null
v_sig_rating	sig_category	varchar	2147483647	√		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_candidate	sigcategory	varchar	2147483647	√		null
v_sig_rating	signame	varchar	2147483647	√		null
v_sig_rating_candidate	signame	varchar	2147483647	√		null
v_blog_categories	slug	varchar	2147483647	√		null
measure	source	varchar	2147483647	√		null
speech	source	varchar	2147483647			''::character varying
measure	sourceurl	varchar	2147483647	√		null
rating	span	varchar	2147483647			''::character varying
v_sig_rating	span	varchar	2147483647	√		null
v_sig_rating_candidate	span	varchar	2147483647	√		null
office_state	split	varchar	2147483647	√		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
v_election_candidate	state	varchar	2147483647	√		null
v_office_candidate	state	varchar	2147483647	√		null
ctystate	state_id	varchar	2147483647
legislativedistricts_gis	state_id	varchar	2147483647	√		null
state	statehood	varchar	2147483647			''::character varying
v_congstatus	statename	varchar	2147483647	√		null
v_congstatus_candidate	statename	varchar	2147483647	√		null
v_election_candidate	status	varchar	2147483647	√		null
v_highest_stage	status	varchar	2147483647	√		null
v_office_candidate	status	varchar	2147483647	√		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
candidate	suffix	varchar	2147483647			''::character varying
v_running_mate	suffix	varchar	2147483647	√		null
v_running_mate_test	suffix	varchar	2147483647	√		null
measure	summaryurl	varchar	2147483647	√		null
pyadmin_tasks	tablename	varchar	2147483647	√		null
electionoffice	tdd	varchar	2147483647	√		null
resource	tdd	varchar	2147483647	√		null
measure	texturl	varchar	2147483647	√		null
candidatetitle	title	varchar	2147483647	√		null
congtitle	title	varchar	2147483647
contact_candidate	title	varchar	2147483647			''::character varying
featured	title	varchar	2147483647	√		null
measure	title	varchar	2147483647	√		null
office	title	varchar	2147483647			''::character varying
speech	title	varchar	2147483647			''::character varying
v_blog_categories	title	varchar	2147483647	√		null
v_congstatus	title	varchar	2147483647	√		null
v_congstatus_candidate	title	varchar	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
state	tree	varchar	2147483647			''::character varying
election_address	ttyd	varchar	2147483647	√		null
office_address	ttyd	varchar	2147483647	√		null
state	type	varchar	2147483647			''::character varying
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
local	url	varchar	2147483647	√		null
measure	url	varchar	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
pyadmin_tasks	user_id	varchar	2147483647	√		null
user	user_id	varchar	2147483647
user_role	user_id	varchar	2147483647
contact_candidate	username	varchar	2147483647			(-1)
state	ushousename	varchar	2147483647	√		null
v_election_candidate	ushousename	varchar	2147483647	√		null
v_office_candidate	ushousename	varchar	2147483647	√		null
local	voteurl	varchar	2147483647	√		null
state	voteurl	varchar	2147483647			''::character varying
election_webaddress	webaddress	varchar	2147483647	√		null
office_webaddress	webaddress	varchar	2147483647	√		null
electionoffice	website	varchar	2147483647	√		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
office_address	zip	varchar	2147483647	√		null
resource	zip	varchar	2147483647	√		null
sig	zip	varchar	2147483647			''::character varying