Table pvsadmin.public.endorser 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
endorser_id serial 10  √  nextval('endorser_endorser_id_seq'::regclass)
endorser_candidate.endorser_id endorser_candidate__endorser_id_fk C
party_id int4 10  √  null
party.party_id endorser__party_id_fk R
name varchar 2147483647  √  null
profession varchar 2147483647  √  null
state_id bpchar 2  √  null
state.state_id endorser__state_id_fk R
endorsertype_id bpchar 1  √  null
endorsertype.endorsertype_id endorser__endorsertype_id_fk R

Table contained 1,349 rows at Tue Jan 03 04:46 MST 2017

Indexes:
Column(s) Type Sort Constraint Name
endorser_id Primary key Asc endorser_pkey
endorsertype_id Performance Asc endorser__endorsetype_id
name Performance Asc endorser__name_id
party_id Performance Asc endorser__party_id
state_id Performance Asc endorser__state_id

Close relationships  within of separation: