Table pvsadmin.public.endorsergroup 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
endorsergroup_id serial 10  √  nextval('endorsergroup_endorsergroup_id_seq'::regclass)
endorsergroup_candidate.endorsergroup_id endorsergroup_candidate__endorsergroup_id_fk R
state_id bpchar 2  √  null
state.state_id endorsergroup__state_id_fk R
endorsertype_id bpchar 1  √  null
endorsertype.endorsertype_id endorsergroup__endorsertype_id_fk R
name varchar 2147483647  √  null

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

Indexes:
Column(s) Type Sort Constraint Name
endorsergroup_id Primary key Asc endorsergroup_id_pk
endorsertype_id Performance Asc endorsergroup__endorsetype_id
name Performance Asc endorsergroup__name
state_id Performance Asc endorsergroup__state_id

Close relationships  within of separation: