View pvsadmin.public.v_office_candidate 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
office_candidate_id int4 10  √  null
candidate_id int4 10  √  null
office_id int2 5  √  null
office.office_id Implied Constraint R
officetype_id bpchar 1  √  null
officetype.officetype_id Implied Constraint R
state_id bpchar 2  √  null
state.state_id Implied Constraint R
districtname_id int2 5  √  null
districtname.districtname_id Implied Constraint R
officecandidatestatus_id int2 5  √  null
officecandidatestatus.officecandidatestatus_id Implied Constraint R
officelevel_id bpchar 1  √  null
officelevel.officelevel_id Implied Constraint R
party_id int4 10  √  null
state varchar 2147483647  √  null
office varchar 2147483647  √  null
officecode varchar 2147483647  √  null
officerank int2 5  √  null
officetype varchar 2147483647  √  null
districtname varchar 2147483647  √  null
districtrank int2 5  √  null
party varchar 2147483647  √  null
officetitle varchar 2147483647  √  null
officeshorttitle varchar 2147483647  √  null
status varchar 2147483647  √  null
firstelect varchar 2147483647  √  null
lastelect varchar 2147483647  √  null
nextelect varchar 2147483647  √  null
termstart flexdate 2147483647  √  null
termend flexdate 2147483647  √  null
lowername varchar 2147483647  √  null
ushousename varchar 2147483647  √  null
uscircuit varchar 2147483647  √  null

Analyzed at Tue Jan 03 04:46 MST 2017


Close relationships: