Table pvsadmin.public.biotext 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
biotext_id serial 10  √  nextval('biotext_biotext_id_seq'::regclass)
biotext_category.biotext_id biotext_category_biotext_id_fkey C
biotext_tag.biotext_id biotext_tag_biotext_id_fkey C
biotext text 2147483647  √  null
officelevel_id bpchar 1  √  null
officelevel.officelevel_id Implied Constraint R
biotype_id int2 5  √  null
biotype.biotype_id Implied Constraint R

Table contained 455,607 rows at Tue Jan 03 04:46 MST 2017

Indexes:
Column(s) Type Sort Constraint Name
biotext_id Primary key Asc biotext_pkey
biotext Performance Asc biotext__biotext
biotype_id Performance Asc biotext__biotype_id

Close relationships  within of separation: