Table pvsadmin.public.party 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
party_id serial 10  √  nextval('party_id_seq'::regclass)
electionstage_candidate_party.party_id electionstage_candidate_party__party_id_fk R
endorser.party_id endorser__party_id_fk R
office_candidate_party.party_id office_candidate_party__party_id_fk R
party_category.party_id party_category__party_id_fk C
party_tag.party_id party_tag_party_id_fkey C
primarytype_state.party_id primarytype_state_party_id_fkey R
parent_id int4 10  √  null
name varchar 2147483647 ''::character varying
rank int2 5  √  null

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

Indexes:
Column(s) Type Sort Constraint Name
party_id Primary key Asc party_pk
name Must be unique Asc party__name

Close relationships  within of separation: