Table pvsadmin.public.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
candidate_id serial 10  √  nextval('candidate_id_seq'::regclass)
additional_candidate.candidate_id additional_candidate__candidate_id_fk C
candidate_election_candidate.candidate_id candidate_election_candidate__candidate_id_fk C
contact_candidate.candidate_id contact_candidate__candidate_id_fk C
education.candidate_id education_candidate_id_fkey C
election_candidate.candidate_id election_candidate__candidate_id_fk C
experience.candidate_id experience_candidate_id_fkey C
factcheck_candidate.candidate_id factcheck_candidate_candidate_id_fkey R
finsource_candidate.candidate_id finsource_candidate__candidate_id_fk C
office_candidate.candidate_id office_candidate__candidate_id_fk C
profession.candidate_id profession_candidate_id_fkey C
rating_candidate.candidate_id rating_candidate__candidate_id_fk C
speech_candidate.candidate_id speech_candidate__candidate_id_fk C
track_candidate.candidate_id track_candidate_candidate_id_fkey C
candidatestatus_id int2 5 1
candidatestatus.candidatestatus_id candidate__candidatestatus_id_fk R
candidatetitle_id int2 5 0
candidatetitle.candidatetitle_id candidate__candidatetitle_id_fk R
state_id bpchar 2 'NA'::bpchar
state.state_id candidate__state_id_fk R
release_id int2 5 2
release.release_id candidate__release_id_fk R
firstname varchar 2147483647 ''::character varying
middlename varchar 2147483647 ''::character varying
lastname varchar 2147483647 ''::character varying
nickname varchar 2147483647 ''::character varying
pronunciation varchar 2147483647 ''::character varying
gender bpchar 1 ''::bpchar
suffix varchar 2147483647 ''::character varying
birthdate varchar 2147483647 ''::character varying
birthplace varchar 2147483647 ''::character varying
homecity varchar 2147483647 ''::character varying
education text 2147483647  √  ''::text
family text 2147483647 ''::text
profession text 2147483647  √  ''::text
political text 2147483647  √  ''::text
religion text 2147483647 ''::text
orgmember text 2147483647  √  ''::text
specialmsg text 2147483647 ''::text
caucus text 2147483647  √  ''::text
bioformyear int2 5  √  null
fecid varchar 2147483647 ''::bpchar
photourl varchar 2147483647 ''::character varying
bioid varchar 2147483647  √  null
callnote text 2147483647 ''::text
password varchar 2147483647  √  null
candidatepreferredname_id bpchar 1 'F'::bpchar
candidatepreferredname.candidatepreferredname_id candidate__candidatepreferredname_id_fk R
created timestamp 29,6  √  null
modified timestamp 29,6  √  null

Table contained 164,879 rows at Tue Jan 03 04:46 MST 2017

Indexes:
Column(s) Type Sort Constraint Name
candidate_id Primary key Asc candidate_pkey
bioid Performance Asc candidate__bioid
candidatetitle_id Performance Asc candidate__candidatetitle_id
lastname Performance Asc candidate__lastname
Performance candidate__lastname_upper
release_id Performance Asc candidate__release_id
state_id Performance Asc candidate__state_id
Performance candidate__unaccent_lastname

Close relationships  within of separation: