Table cxgn.sgn_bt.cosii_ortholog

 Generated by
SchemaSpy
Related columns Constraint names Comments 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 Comments
cosii_unigene_id bigserial 19  √  nextval('cosii_ortholog_cosii_unigene_id_seq'::regclass)
marker_id int8 19  √  null
marker.marker_id marker_id_fk
unigene_id int4 10  √  null
copies varchar 1  √  null
database_name varchar 11  √  null
sequence_name varchar 255  √  null
edited_sequence_id int8 19  √  null
peptide_sequence_id int8 19  √  null
introns text 2147483647  √  null
cxgn_production_visible bool 1  √  false

Table contained 10,668 rows at Thu Jun 21 23:03 EDT 2007

Indexes:
Column(s) Type Sort Constraint Name
cosii_unigene_id Primary key Asc cosii_ortholog_pkey
marker_id + unigene_id Performance Asc/Asc marker_id_idx2

Close relationships  within one two degrees of separation :