Table pvsadmin.public.npatcandidate 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
npatcandidate_id serial 10  √  nextval('npatcandidate_id_seq'::regclass)
npatanswer.npatcandidate_id npatanswer__npatcandidate_id_fk C
npatcitation.npatcandidate_id npatcitation__npatcandidate_id C
npatproblem_npatcandidate.npatcandidate_id npatproblem_npatcandidate__npatcandidate_id_fk R
election_candidate_id int4 10
election_candidate.election_candidate_id npatcandidate__election_candidate_id_fk C
npatform_id int4 10
npatform.npatform_id npatcandidate__npatform_id_fk C
npatgroup_id varchar 2147483647  √  null
npatgroup.npatgroup_id npatcandidate__npatgroup_id_fk R
receiveddate timestamptz 35,6  √  null
lastupdate timestamp 29,6  √  null
lastimport timestamp 29,6  √  null
processed bool 1  √  null
npatstatus_id bpchar 1 'P'::bpchar
npatstatus.npatstatus_id npatcandidate__npatstatus_id_fk R
pct int2 5  √  null
created timestamp 29,6  √  null
modified timestamp 29,6  √  null

Table contained 186,195 rows at Tue Jan 03 04:46 MST 2017

Indexes:
Column(s) Type Sort Constraint Name
npatcandidate_id Primary key Asc npatcandidate_pk
election_candidate_id Must be unique Asc nc_ec_id
election_candidate_id + npatform_id Must be unique Asc/Asc npatcandidate__ec_id_nf_id
election_candidate_id Performance Asc npatcandidate__election_candidate_id
npatform_id Performance Asc npatcandidate__npatform_id
npatgroup_id Performance Asc npatcandidate__npatgroup_id
npatstatus_id Performance Asc npatcandidate__npatstatus_id

Close relationships  within of separation: