View pvsadmin.public.v_running_mate 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
election_candidate_id int4 10  √  null
rm_election_candidate_id int4 10  √  null
rm_office_id int2 5  √  null
office_id int2 5  √  null
office.office_id Implied Constraint R
parent_id int4 10  √  null
candidate_id int4 10  √  null
rm_candidate_id int4 10  √  null
firstname varchar 2147483647  √  null
nickname varchar 2147483647  √  null
middlename varchar 2147483647  √  null
lastname varchar 2147483647  √  null
suffix varchar 2147483647  √  null
candidatepreferredname_id bpchar 1  √  null
candidatepreferredname.candidatepreferredname_id Implied Constraint R
title varchar 2147483647  √  null
rank int2 5  √  null
rm_party varchar 2147483647  √  null

Analyzed at Tue Jan 03 04:46 MST 2017


Close relationships: