SchemaSpy Analysis of gff3_schema.% - Columns

 Generated by
SchemaSpy
Generated by SchemaSpy on Thu Jun 11 13:40 PDT 2009
Legend: SourceForge.net
Primary key columns
Columns with indexes
Please support this project 

Related columns Constraint names Legend
gff3_schema.% contains 58 columns:
Column Table Type Size Nulls Auto Default Children Parents
attribute_id attribute int 4,2
attributelist id gb_attribute_attributelist_fk
attribute_value attribute varchar 255  √  null
bin feature int 4,2  √  null
child parent2child int 4,2
feature id gb_parent2child_child_feature_fk
clust sysindexes float 8,15  √  null
clustered sysindexes char 1  √  null
display_name name smallint 2,2  √  0
end feature int 4,2  √  null
id attribute int 4,2
feature id gb_attribute_feature_fk
id attributelist serial 4,2  √ 
attribute attribute_id gb_attribute_attributelist_fk
id feature 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
id locationlist serial 4,2  √ 
feature seqid gb_feature_locationlist_fk
sequence id gb_sequence_locationlist_fk
id name int 4,2
feature id gb_name_feature_fk
id parent2child int 4,2
feature id gb_parent2child_id_feature_fk
id sequence int 4,2
locationlist id gb_sequence_locationlist_fk
id sysdomains serial 4,2
id typelist serial 4,2  √ 
feature typeid gb_feature_typelist_fk
idxname sysindexes varchar 128  √  null
idxtype sysindexes char 1  √  null
indexed feature smallint 2,2  √  1
leaves sysindexes float 8,15  √  null
levels sysindexes smallint 2,2  √  null
name meta varchar 128
name name varchar 128
name sysdomains varchar 128  √  null
nunique sysindexes float 8,15  √  null
object feature blob 2147483647
offset sequence int 4,2
owner sysdomains char 32  √  null
owner sysindexes char 32  √  null
part1 sysindexes smallint 2,2  √  null
part10 sysindexes smallint 2,2  √  null
part11 sysindexes smallint 2,2  √  null
part12 sysindexes smallint 2,2  √  null
part13 sysindexes smallint 2,2  √  null
part14 sysindexes smallint 2,2  √  null
part15 sysindexes smallint 2,2  √  null
part16 sysindexes smallint 2,2  √  null
part2 sysindexes smallint 2,2  √  null
part3 sysindexes smallint 2,2  √  null
part4 sysindexes smallint 2,2  √  null
part5 sysindexes smallint 2,2  √  null
part6 sysindexes smallint 2,2  √  null
part7 sysindexes smallint 2,2  √  null
part8 sysindexes smallint 2,2  √  null
part9 sysindexes smallint 2,2  √  null
seqid feature int 4,2
locationlist id gb_feature_locationlist_fk
seqname locationlist varchar 50
sequence sequence clob 2147483647  √  null
start feature int 4,2  √  null
strand feature smallint 2,2  √  0
tabid sysindexes int 4,2  √  null
tag attributelist varchar 50
tag typelist varchar 40
tier feature smallint 2,2  √  null
type sysdomains smallint 2,2  √  null
typeid feature int 4,2 0
typelist id gb_feature_typelist_fk
value meta varchar 128