Table scop.scop_node
SCOP node

Generated by
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_domain.node_id astral_domain_ibfk_1
link_pdb.node_id link_pdb_ibfk_1
link_pfam.node_id link_pfam_ibfk_1
link_species.node_id link_species_ibfk_1
link_uniprot.node_id link_uniprot_ibfk_1
scop_comment.node_id scop_comment_ibfk_1
scop_history.new_node_id scop_history_ibfk_2
scop_history.old_node_id scop_history_ibfk_1
scop_node.parent_node_id scop_node_ibfk_3
scop_node_pdbstyle.node_id scop_node_pdbstyle_ibfk_1
scop_node_thumbnail.node_id scop_node_thumbnail_ibfk_1
scop_subset_level.level_node_id scop_subset_level_ibfk_2
scop_subset_level.rep_node_id scop_subset_level_ibfk_1
sunid int 10 SCOP unique identifier, e.g., 14982; unique within each release
sccs text 65535 SCOP concise classification string, e.g., a.1.1.1
sid text 65535  √  null SCOP domain identifier, e.g., d1dlwa_ (null if not domain)
description text 65535
level_id int unsigned 10 scop_node_ibfk_1
SCOP level
parent_node_id int unsigned 10  √  null scop_node_ibfk_3
null if no parent
release_id int unsigned 10  √  null scop_node_ibfk_2
release in which this node appears, or null for working copy

Table contained 1,107,925 rows at Sun Feb 26 23:56 EST 2012

Column(s) Type Sort Constraint Name
id Primary key Asc PRIMARY
level_id Performance Asc level_id
parent_node_id Performance Asc parent_node_id
release_id Performance Asc release_id
sccs Performance Asc sccs
sid Performance Asc sid
sunid Performance Asc sunid

Close relationships  within of separation: