Table pvsadmin.public.office 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_id int2 5  √  nextval(('public.office_id_seq'::text)::regclass)
conglevel_office.office_id Implied Constraint R
district.office_id district__office_id_fk R
election_candidate.office_id election_candidate__office_id_fk R
leadership_office.office_id leadership_office__office_id_fk C
leadership_state_office.office_id leadership_state_office__office_id_fk R
office_candidate.office_id office_candidate__office_id_fk R
office_category.office_id office_category__office_id_fk C
office_state.office_id Implied Constraint R
v_election_candidate.office_id Implied Constraint R
v_leadership.office_id Implied Constraint R
v_office_candidate.office_id Implied Constraint R
v_running_mate.office_id Implied Constraint R
v_running_mate_test.office_id Implied Constraint R
officetype_id bpchar 1 ''::bpchar
officetype.officetype_id office__officetype_id_fk R
release_id int2 5 0
release.release_id office__release_id_fk R
code varchar 2147483647 ''::character varying
name varchar 2147483647 ''::character varying
title varchar 2147483647 ''::character varying
npatoffice bool 1 false
shorttitle varchar 2147483647  √  null
rank int2 5  √  null

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

Indexes:
Column(s) Type Sort Constraint Name
office_id Primary key Asc office__pk
officetype_id Performance Asc office__officetype_id
officetype_id + name Must be unique Asc/Asc office__officetype_id_name

Close relationships  within of separation: