Table cxgn.sgn.domain_match

 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
domain_match_id bigserial 19  √  nextval('domain_match_domain_match_id_seq'::regclass)
cds_id int8 19  √  null
cds.cds_id domain_match_cds_id_fkey
unigene_id int8 19  √  null
domain_id int8 19  √  null
domain.domain_id domain_match_domain_id_fkey
match_begin int4 10  √  null
match_end int4 10  √  null
e_value varchar 10  √  null
hit_status bpchar 1  √  null
run_id int8 19  √  null
metadata_id int8 19  √  null
metadata.metadata_id domain_match_metadata_id_fkey

Table contained 223,057 rows at Wed May 20 01:50 EDT 2009

Indexes:
Column(s) Type Sort Constraint Name
domain_match_id Primary key Asc domain_match_pkey
cds_id Performance Asc cds_id_idx
domain_id Performance Asc domain_id_idx
run_id Performance Asc run_id_idx2
unigene_id Performance Asc unigene_id_idx2

Close relationships  within one two degrees of separation :