Table pvsadmin.public.experience 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
experience_id serial 10  √  nextval('experience_experience_id_seq'::regclass)
experience_category.experience_id experience_category_experience_id_fkey C
experience_tag.experience_id experience_tag_experience_id_fkey C
candidate_id int4 10
candidate.candidate_id experience_candidate_id_fkey C
experiencetype_id bpchar 1
experiencetype.experiencetype_id experience__experiencetype_id_fk R
title text 2147483647  √  null
organization text 2147483647  √  null
span text 2147483647  √  null
district text 2147483647  √  null
special text 2147483647  √  null
fulltext text 2147483647  √  null

Table contained 698,645 rows at Tue Jan 03 04:46 MST 2017

Indexes:
Column(s) Type Sort Constraint Name
experience_id Primary key Asc experience_pkey
candidate_id Performance Asc experience__candidate_id
experiencetype_id Performance Asc experience__experiencetype_id

Close relationships  within of separation: