Table scop.astral_chain
ASTRAL chain 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.chain_id astral_chain_link_domain_ibfk_1
astral_chain_subset_id.astral_chain_id astral_chain_subset_id_ibfk_2
raf_id int unsigned 10
raf.id astral_chain_ibfk_1
source_id int unsigned 10
astral_seq_source.id astral_chain_ibfk_2
sid varchar 5 e.g., 1jmcA
seq text 65535 lower case
is_reject tinyint unsigned 3 due to length or number of Xs

Table contained 1,480,959 rows at Sun Feb 26 23:56 EST 2012

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

Close relationships  within of separation: