Table pvsadmin.public.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 serial 10  √  nextval('office_candidate_id_seq'::regclass)
committee_candidate.office_candidate_id committee_candidate__office_candidate_id_fk C
congstatus_candidate.office_candidate_id congstatus_candidate__office_candidate_id_fk C
leadership_candidate.office_candidate_id leadership_candidate__office_candidate_id_fk C
office_address.office_candidate_id office_address__office_candidate_id_fk C
office_candidate_party.office_candidate_id office_candidate_party__office_candidate_id_fk C
office_webaddress.office_candidate_id office_webaddress__office_candidate_id_fk C
vacancy.office_candidate_id vacancy__o_c_id_fk C
office_id int2 5
office.office_id office_candidate__office_id_fk R
candidate_id int4 10
candidate.candidate_id office_candidate__candidate_id_fk C
state_id bpchar 2
state.state_id office_candidate__state_id_fk R
districtname_id int2 5  √  null
districtname.districtname_id office_candidate__districtname_id_fk R
officecandidatestatus_id int2 5
officecandidatestatus.officecandidatestatus_id office_candidate__officecandidatestatus_id_fk R
local_id int4 10  √  null
local.local_id office_candidate__local_id_fk C
termstart flexdate 2147483647  √  null
termend flexdate 2147483647  √  null
specialmsg text 2147483647 ''::text
importid varchar 2147483647 ''::character varying
lastelect varchar 2147483647  √  null
nextelect varchar 2147483647  √  null
firstelect varchar 2147483647  √  null
appointed bool 1  √  null
parent_id int4 10  √  null
created timestamp 29,6  √  null
modified timestamp 29,6  √  null

Table contained 89,838 rows at Tue Jan 03 04:46 MST 2017

Indexes:
Column(s) Type Sort Constraint Name
office_candidate_id Primary key Asc office_candidate_pk
candidate_id Performance Asc office_candidate__candidate_id
districtname_id Performance Asc office_candidate__districtname_id
local_id Performance Asc office_candidate__local_id
office_id Performance Asc office_candidate__office_id
officecandidatestatus_id Performance Asc office_candidate__officecandidatestatus_id
state_id Performance Asc office_candidate__state_id

Close relationships  within of separation: