Table scop.pdb_entry
PDB entries and literature references

 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.pdb_entry_id aerospaci_ibfk_1
pdb_entry.obsoleted_by pdb_entry_ibfk_1
pdb_release.pdb_entry_id pdb_release_ibfk_1
code varchar 4 4-letter code e.g., 1jmc
description text 65535 from TITLE
deposition_date date 10 date structure was deposited, from HEADER line
release_date date 10 date structure was first released by PDB, from REVDAT 1 line
obsolete_date date 10  √  null date obsoleted or withdrawn by PDB; null if still active
obsoleted_by int unsigned 10  √  null
pdb_entry.id pdb_entry_ibfk_1
non-null if obsoleted by another structure
is_literature_reference tinyint unsigned 3 0=real PDB, 1=SCOP-only

Table contained 81,962 rows at Sun Feb 26 23:56 EST 2012

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

Close relationships  within of separation: