Table scop.scop_release
SCOP versions

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  √ 
aerospaci.release_id aerospaci_ibfk_2 R
astral_chain_subset_id.release_id astral_chain_subset_id_ibfk_1 C
astral_domain_subset_blast_e.release_id astral_domain_subset_blast_e_ibfk_1 C
astral_domain_subset_id.release_id astral_domain_subset_id_ibfk_1 C
astral_seq_blast.release_id astral_seq_blast_ibfk_6 R
raf.first_release_id raf_ibfk_3 R
raf.last_release_id raf_ibfk_4 R
scop_history.release_id scop_history_ibfk_3 R
scop_node.release_id scop_node_ibfk_2 R
scop_node_pdbstyle.last_update_id scop_node_pdbstyle_ibfk_2 C
must be in release order
version text 65535 e.g., 1.73
is_public tinyint unsigned 3 0=no, 1=yes
is_comprehensive tinyint unsigned 3 does this include ~all PDB entries prior to freeze date?
freeze_date date 10 date PDB was frozen for classification
release_date date 10 date this version was released
series tinyint unsigned 3 1=SCOP+ASTRAL, 2=SCOPe
old_version text 65535  √  null e.g., 1.75A

Table contained 17 rows at Sat Feb 27 10:37 PST 2016

Indexes:
Column(s) Type Sort Constraint Name
id Primary key Asc PRIMARY

Close relationships  within of separation: