Table pvsadmin.public.category 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
category_id int2 5  √  nextval(('category_id_seq'::text)::regclass)
additional_candidate_category.category_id additional_candidate_category_category_id_fkey C
additional_category.category_id additional_category_category_id_fkey C
biotext_category.category_id biotext_category_category_id_fkey R
catcode_category.category_id catcode_category_category_id_fkey1 C
category_section.category_id category_section__category_id_fk C
category_tag.category_id category_tag__category_fk C
committee_category.category_id committee_category__category_id_fk C
congcategory_category.category_id congcategory_category__category_id C
education_category.category_id education_category_category_id_fkey C
experience_category.category_id experience_category_category_id_fkey C
factcheck_category.category_id factcheck_category_category_id_fkey R
measure_category.category_id measure_category__category_id_fk R
npatanswer_category.category_id npatanswer_category_category_id_fkey C
npatmatrix_category.category_id npatmatrix_category_category_id_fkey C
npatrow_category.category_id npatrow_category__category_id_fkey R
npatrowtext_category.category_id npatrowtext_category__category_id_fk C
office_category.category_id office_category__category_id_fk C
party_category.category_id party_category__category_id_fk C
rating_category.category_id rating_category__category_id_fk R
religion_category.category_id religion_category_category_id_fkey C
sig_category.category_id sig_category__category_id_fk C
speech_category.category_id speech_category__category_id_fk R
v_candidate_timeline.category_id Implied Constraint R
v_category.category_id Implied Constraint R
v_category_new.category_id Implied Constraint R
v_category_released.category_id Implied Constraint R
v_category_resolve.category_id Implied Constraint R
name varchar 2147483647
release_id int2 5  √  null
release.release_id category__release_id_fk R
description text 2147483647  √  null
rank int2 5  √  null
key bool 1 false

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

Indexes:
Column(s) Type Sort Constraint Name
category_id Primary key Asc category__pk

Close relationships  within of separation: