Table pvsadmin.public.officetype 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
officetype_id bpchar 1
election.officetype_id Implied Constraint R
npatform_criteria.officetype_id Implied Constraint R
office.officetype_id office__officetype_id_fk R
v_election.officetype_id Implied Constraint R
v_election_candidate.officetype_id Implied Constraint R
v_election_current.officetype_id Implied Constraint R
v_office_candidate.officetype_id Implied Constraint R
officelevel_id bpchar 1
officelevel.officelevel_id officetype__officelevel_id_fk R
officebranch_id bpchar 1
officebranch.officebranch_id officetype__officebranch_id_fk R
name varchar 2147483647  √  null
fullname varchar 2147483647 ''::character varying
rank int2 5  √  null

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

Indexes:
Column(s) Type Sort Constraint Name
officetype_id Primary key Asc officetype__pk

Close relationships  within of separation: