Table pvsadmin.public.leadership_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
leadership_candidate_id serial 10  √  nextval('leadership_candidate_id_seq'::regclass)
leadership_id int2 5
leadership.leadership_id leadership_candidate__leadership_id_fk C
office_candidate_id int4 10
office_candidate.office_candidate_id leadership_candidate__office_candidate_id_fk C
termstart flexdate 2147483647  √  null
termend flexdate 2147483647  √  null
created timestamp 29,6  √  null
modified timestamp 29,6  √  null

Table contained 11,115 rows at Tue Jan 03 04:46 MST 2017

Indexes:
Column(s) Type Sort Constraint Name
leadership_candidate_id Primary key Asc leadership_candidate_pk
leadership_id Performance Asc leadership_candidate__leadership_id
leadership_id + office_candidate_id Must be unique Asc/Asc leadership_candidate__leadership_id_office_candidate_id
office_candidate_id Performance Asc leadership_candidate__office_candidate_id

Close relationships  within of separation: