Table gff3_schema.%.feature

 Generated by
SchemaSpy
Related columns Constraint names Legend
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
Dashed lines show
implied relationships
< n > number of related tables
Please support this project 
Column Type Size Nulls Auto Default Children Parents
id serial 4,2  √ 
attribute id gb_attribute_feature_fk
name id gb_name_feature_fk
parent2child child gb_parent2child_child_feature_fk
parent2child id gb_parent2child_id_feature_fk
typeid int 4,2 0
typelist id gb_feature_typelist_fk
seqid int 4,2
locationlist id gb_feature_locationlist_fk
start int 4,2  √  null
end int 4,2  √  null
strand smallint 2,2  √  0
tier smallint 2,2  √  null
bin int 4,2  √  null
indexed smallint 2,2  √  1
object blob 2147483647

Table contained 1,360 rows at Thu Jun 11 13:40 PDT 2009

Indexes:
Column(s) Type Sort Constraint Name
id Must be unique Asc 851_2926
seqid Performance Asc 851_2927
typeid Performance Asc 851_2928
seqid + tier + bin + typeid Performance Asc/Asc/Asc/Asc gb_feature_seq_tier_bin_type_idx

Close relationships  within one two degrees of separation :