Table scop.pdb_release
PDB entry releases

 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  √ 
pdb_chain.pdb_release_id pdb_chain_ibfk_1 R
pdb_headers.pdb_release_id pdb_headers_ibfk_1 R
pdb_local.pdb_release_id pdb_local_ibfk_1 R
pdb_release.replaced_by pdb_release_ibfk_2 R
pdb_release_heterogen.pdb_release_id pdb_release_heterogen_ibfk_1 C
pdb_entry_id int unsigned 10
pdb_entry.id pdb_release_ibfk_1 R
revision_date date 10 date this version was released, from REVDAT line
file_date date 10  √  null PDB datestamp on file (if known), to track silent updates by PDB
replaced_by int unsigned 10  √  null
pdb_release.id pdb_release_ibfk_2 R
non-null if replaced by a later version
method_id int unsigned 10  √  null
pdb_method.id pdb_release_ibfk_3 R
experimental method listed in EXPDTA record, or null if not available
spaci double 22  √  null ASTRAL SPACI score, or null if not calculated
resolution double 22  √  null resolution in angstroms, or null if not known or not applicable
r_factor double 22  √  null R factor, or null if not known or not applicable
has_valid_procheck tinyint unsigned 3 0=no, 1=yes
has_valid_whatcheck tinyint unsigned 3 0=no, 1=yes
procheck1 tinyint unsigned 3  √  null Morris Ramachandran class from PROCHECK
procheck2 tinyint unsigned 3  √  null Morris Chi-1 class from PROCHECK
procheck3 tinyint unsigned 3  √  null Morris H-bond class from PROCHECK
whatcheck1 double 22  √  null Packing score from WHAT_CHECK
whatcheck2 double 22  √  null Ramachandran score from WHAT_CHECK
whatcheck3 double 22  √  null Chi angles score from WHAT_CHECK
whatcheck4 double 22  √  null Backbone score from WHAT_CHECK

Table contained 223,245 rows at Wed Oct 09 10:41 PDT 2013

Indexes:
Column(s) Type Sort Constraint Name
id Primary key Asc PRIMARY
method_id Performance Asc method_id
pdb_entry_id Performance Asc pdb_entry_id
replaced_by Performance Asc replaced_by

Close relationships  within of separation: