Table pvsadmin.public.tag 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
tag_id serial 10  √  nextval('tag_tag_id_seq'::regclass)
additional_candidate_tag.tag_id additional_candidate_tag_tag_id_fkey C
additional_tag.tag_id additional_tag_tag_id_fkey C
biotext_tag.tag_id biotext_tag_tag_id_fkey C
category_tag.tag_id category_tag__tag_fk C
committee_tag.tag_id committee_tag_tag_id_fkey C
congcategory_tag.tag_id congcategory_tag_tag_id_fkey C
congstatus_tag.tag_id congstatus_tag__tag_fk C
education_tag.tag_id education_tag_tag_id_fkey C
experience_tag.tag_id experience_tag_tag_id_fkey C
factcheck_tag.tag_id factcheck_tag_tag_id_fkey R
featured_tag.tag_id featured_tag_tag_id_fkey R
measure_tag.tag_id measure_tag__tag_fk C
npatanswer_tag.tag_id npatanswer_tag_tag_id_fkey C
npatrowtext_tag.tag_id npatrowtext_tag__tag_fk C
party_tag.tag_id party_tag_tag_id_fkey C
rating_tag.tag_id rating_tag__tag_fk C
religion_tag.tag_id religion_tag_tag_id_fkey C
sig_tag.tag_id sig_tag__tag_fk C
speech_tag.tag_id speech_tag__tag_fk C
tagalias.tag_id tagalias_tag_id_fkey C
name text 2147483647
deleted bool 1 false
modified timestamp 29,6  √  null

Table contained 89,670 rows at Tue Jan 03 04:46 MST 2017

Indexes:
Column(s) Type Sort Constraint Name
tag_id Primary key Asc tag_pkey
name Performance Asc tag__name_trgm_idx
name Must be unique Asc tag__name_uniq

Close relationships  within of separation: