Table zfindb.informix.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 varchar 25  √  null
gff_source varchar 45  √  null
gff_feature varchar 45  √  null
gff_start int 10  √  null
gff_end int 10  √  null
gff_score varchar 5  √  null
gff_strand char 1  √  null
gff_frame char 1  √  null
gff_id varchar 45
gff_name varchar 45  √  null
gff_parent varchar 45  √  null
gff_biotype varchar 55  √  null

Table contained 1,626,301 rows at Thu Jun 22 08:42 PDT 2017

Indexes:
Column(s) Type Sort Constraint Name
gff_feature Performance Asc ngff3_gff_feature_idx
gff_id Must be unique Asc ngff3_gff_id_primary_key_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