Table scop.astral_domain
ASTRAL domain sequence

 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
id int unsigned 10  √ 
astral_chain_link_domain.domain_id astral_chain_link_domain_ibfk_2
astral_domain_subset_blast_e.astral_domain_id astral_domain_subset_blast_e_ibfk_3
astral_domain_subset_id.astral_domain_id astral_domain_subset_id_ibfk_3
node_id int unsigned 10
scop_node.id astral_domain_ibfk_1
source_id int unsigned 10
astral_seq_source.id astral_domain_ibfk_2
style_id int unsigned 10
astral_seq_style.id astral_domain_ibfk_3
sid varchar 8 e.g., d1dlwa_ or e1o7d.1B
header text 65535 FASTA header excluding sid
seq text 65535 lower case, except for X separating genetic domain
is_reject tinyint unsigned 3 due to length or number of Xs

Table contained 2,222,200 rows at Sun Feb 26 23:56 EST 2012

Indexes:
Column(s) Type Sort Constraint Name
id Primary key Asc PRIMARY
node_id + source_id + style_id + sid Must be unique Asc/Asc/Asc/Asc node_id
sid Performance Asc sid
source_id Performance Asc source_id
style_id Performance Asc style_id

Close relationships  within of separation: