Table scop.raf
RAF maps

 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.raf_id astral_chain_ibfk_1 R
raf_version_id int unsigned 10
raf_version.id raf_ibfk_1 R
pdb_chain_id int unsigned 10
pdb_chain.id raf_ibfk_2 R
first_release_id int unsigned 10  √  null
scop_release.id raf_ibfk_3 R
first SCOP release in which this raf was used, or null for working copy
last_release_id int unsigned 10  √  null
scop_release.id raf_ibfk_4 R
last SCOP release in which this raf was used, or null for working copy
line text 65535 full line of text, including header

Table contained 1,140,496 rows at Sat Feb 27 10:37 PST 2016

Indexes:
Column(s) Type Sort Constraint Name
id Primary key Asc PRIMARY
first_release_id Performance Asc first_release_id
last_release_id Performance Asc last_release_id
pdb_chain_id Performance Asc pdb_chain_id
raf_version_id Performance Asc raf_version_id

Close relationships  within of separation: