Table pvsadmin.public.state Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
state_id bpchar 2
addr2zip.state_id Implied Constraint R
advisor.state_id advisor__state_id_fkey R
candidate.state_id candidate__state_id_fk R
committee.state_id committee__state_id_fk R
committee_archive.state_id Implied Constraint R
committee_positions.state_id Implied Constraint R
congnote_state.state_id congnote_state__state_id_fk R
congprefix_state.state_id congprefix_state__state_id_fk R
congress.state_id congress__state_id_fk R
district.state_id district__state_id_fk R
election.state_id election__state_id_fk R
election_address.state election_address__state_fk R
election_candidate.state_id election_candidate__state_id_fk R
election_districtname.state_id election_districtname__state_id_fk R
election_electionstage.state_id election_electionstage__state_id_fk R
electionoffice.state_id Implied Constraint R
endorser.state_id endorser__state_id_fk R
endorsergroup.state_id endorsergroup__state_id_fk R
leadership_office.state_id leadership_office__state_id_fk C
leadership_state.state_id leadership_state__state_id_fk R
local.state_id local__state_id_fk R
measure.state_id Implied Constraint R
npatform_criteria.state_id Implied Constraint R
npatgroup_state.state_id npatgroup_state__state_id_fk R
office_address.state office_address__state_fk R
office_candidate.state_id office_candidate__state_id_fk R
office_state.state_id Implied Constraint R
officials_roster.state_id Implied Constraint R
primarytype_state.state_id primarytype_state_state_id_fkey R
resource.state_id resource__state_id_fk R
sig.state sig__state__fk R
sig.state_id sig__state_id_fk R
teachers.state_id teachers__state_id_fkey R
v_congstatus.state_id Implied Constraint R
v_congstatus_candidate.state_id Implied Constraint R
v_election.state_id Implied Constraint R
v_election_candidate.state_id Implied Constraint R
v_leadership.state_id Implied Constraint R
v_office_candidate.state_id Implied Constraint R
statetype_id bpchar 1  √  null
statetype.statetype_id state__statetype_id_fk R
statecode int2 5
name varchar 2147483647 ''::character varying
nickname varchar 2147483647 ''::character varying
capital varchar 2147483647 ''::character varying
area varchar 2147483647  √  null
population varchar 2147483647  √  null
statehood varchar 2147483647 ''::character varying
motto varchar 2147483647 ''::character varying
flower varchar 2147483647 ''::character varying
tree varchar 2147483647 ''::character varying
bird varchar 2147483647 ''::character varying
high varchar 2147483647 ''::character varying
low varchar 2147483647 ''::character varying
type varchar 2147483647 ''::character varying
legisname varchar 2147483647 ''::character varying
ltgov bool 1 false
bicameral bool 1 false
lowername varchar 2147483647 ''::character varying
senators int2 5 0
reps int2 5 0
termlimit int2 5 0
termlength int2 5 0
billurl varchar 2147483647 ''::character varying
voteurl varchar 2147483647 ''::character varying
registration text 2147483647 ''::text
primarydate date 13  √  null
generaldate date 13  √  null
absenteewho text 2147483647 ''::text
absenteehow text 2147483647 ''::text
absenteewhen text 2147483647 ''::text
largestcity varchar 2147483647 ''::character varying
atlarge bool 1 false
ushousename varchar 2147483647  √  null
rollupper varchar 2147483647  √  null
rolllower varchar 2147483647  √  null
uscircuit varchar 2147483647 ''::character varying
electoralvotes int2 5  √  null
caucus bool 1  √  null
created timestamp 29,6  √  null
modified timestamp 29,6  √  null
delegaterep int2 5  √  null
delegatedem int2 5  √  null

Table contained 57 rows at Tue Jan 03 04:46 MST 2017

Indexes:
Column(s) Type Sort Constraint Name
state_id Primary key Asc state__pk

Close relationships  within of separation: