Table pvsadmin.public.finance_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
finance_candidate_id serial 10  √  nextval('finance_candidate_finance_candidate_id_seq'::regclass)
election_candidate_id int4 10
election_candidate.election_candidate_id finance_candidate__election_candidate_id_fk R
finance_catcode_id int2 5
finance_catcode.finance_catcode_id finance_candidate__finance_catcode_id_fk R
date timestamp 29,6  √  null
dollars int8 19  √  null
finsource_id int2 5

Table contained 9,179,813 rows at Tue Jan 03 04:46 MST 2017

Indexes:
Column(s) Type Sort Constraint Name
finance_candidate_id Primary key Asc finance_candidate_pkey
election_candidate_id Performance Asc finance_candidate__election_candidate_id
finance_catcode_id Performance Asc finance_candidate__finance_catcode_id

Close relationships  within of separation: