Table zfindb.public.gff3 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
gff_seqname text 2147483647  √  null
gff_source text 2147483647  √  null
gff_feature text 2147483647  √  null
gff_start int4 10  √  null
gff_end int4 10  √  null
gff_score text 2147483647  √  null
gff_strand bpchar 1  √  null
gff_frame bpchar 1  √  null
gff_id text 2147483647
gff_name text 2147483647  √  null
gff_parent text 2147483647  √  null
gff_biotype text 2147483647  √  null

Table contained 1,571,606 rows at Wed Sep 15 00:41 PDT 2021

Indexes:
Column(s) Type Sort Constraint Name
gff_feature Performance Asc ngff3_gff_feature_idx
gff_name Performance Asc ngff3_gff_name_gff_idx
gff_parent Performance Asc ngff3_gff_parent_idx
gff_source Performance Asc ngff3_gff_source_idx