Entities of Header

The entities that belong to a specific mart
Entity Details: A=Number of attributes of the Entity
R=Number of relations of the Entity
T=Name of the database table
I=Approximation of the number of instances of the entity

Header    Diagram  Marts
Header information of the entry that includes authors, keywords, citations and many other
Author
A:9, R:1, T:AUTHOR, I:90000

The author of the entry
Keyword
A:6, R:1, T:KEYWORD, I:57900

Keyword, referred in the keyword list of an entry
Citation Author
A:57, R:2, T:CITATION_AUTHOR, I:188000

Information about citations and their authors
XRay Data
A:66, R:1, T:XRAY_DATA, I:20600

Information about XRay details of the experiment
XRay Refinement Data
A:101, R:1, T:XRAY_REFINEMENT, I:13300

Information about the refinement process
Country
A:4, R:1, T:COUNTRY, I:189

Reference information about the countries of the world


Attributes/Relations of Header Entities
The attributes and relations that belong to a specific entity
Attribute Details: Type of the attribute String:String, Integer:Integer, Number:Number, Date:Date, Unknown:Unknown
C=Name of the database column
S=Maximum size of the attribute
=Actual average size used for the attribute
Naming The attribute is a part of the name of an instance
Reference The attribute is a part of the reference key of an instance
Hidden The attribute is not supposed to be visible and used for queries
Summery The attribute is supposed to be used in summary reports (lists) for the entity

Relation Details: Cardinality of the relation Optional:Optional, Many:Many
Reverse Optional Reverse Many=Reverse relation of the entity that the relation refers to
Reverse Entity Reverse External Entity=Entity that this relation establishes an association (reverse entity)

Containment The relation is the containment relation of the entity
External The relation is associated with an external entity from a different mart
Hidden The relation is not supposed to be visible and used for queries
Author    Entities  Marts
The author of the entry
Reference attributes:Author Id - Naming attributes:Accession Code,Ordinal,Last Name
C:AUTHOR_ID, S:0, A:4.0
The database identifier of the Author
C:ACCESSION_CODE, S:8, A:4.0
The PDB accession code of the entry
C:ORDINAL, S:8, A:2.0
Serial number of author in the entry
C:NAME, S:255, A:1.0
C:ENTRY_ID, S:10, A:4.0
The database identifier of the Entry
C:LAST_NAME, S:255, A:7.0
Author's family name
C:NAME_INITIALS, S:10, A:4.0
Author's initials. Separated by periods. Hyphens also appear in the case of double names
C:NAME_SUFFIX, S:10, A:2.0
Suffixes such as 'III', 'Jr.', etc.
C:RELEASE_STATUS, S:1, A:1.0
related   Reverse Many Reverse Entity The country of the author
Reverse relation:has of Reverse entity:Entry - Relation attributes:Entry Id

Keyword    Entities  Marts
Keyword, referred in the keyword list of an entry
Reference attributes:Keyword Id - Naming attributes:Accession Code,Keyword
C:KEYWORD_ID, S:10, A:4.0
The database identifier of the Keyword
C:ACCESSION_CODE, S:8, A:4.0
The PDB accession code of the entry
C:KEYWORD, S:255, A:16.0
C:DETAILS_NDB, S:700, A:1.0
C:ENTRY_ID, S:10, A:4.0
The database identifier of the Entry
C:TEXT, S:700, A:4.0
related   Reverse Many Reverse Entity The entry where the keyword appears
Reverse relation:has of Reverse entity:Entry - Relation attributes:Entry Id

Citation Author    Entities  Marts
Information about citations and their authors
Reference attributes:Citation Author Id - Naming attributes:Accession Code,ISSN,Ordinal,Last Name
C:CITATION_AUTHOR_ID, S:0, A:4.0
The database identifier of the Citation Author
C:ACCESSION_CODE, S:8, A:4.0
The PDB accession code of the entry
C:BOOK_VOLUME, S:8, A:1.0
Volume number of the journal cited; relevant for journal articles.
C:ORDINAL, S:10, A:2.0
C:NAME, S:255, A:1.0
C:ABBREV_EBI, S:255, A:2.0
Abbreviated name of the journal cited as given in the Chemical Abstracts Service Source Index.
C:ABBREV_NLM, S:255, A:12.0
Abbreviated name of the journal cited as given in the Chemical Abstracts Service Source Index.
C:ABBREV_PDB, S:255, A:13.0
Abbreviated name of the journal cited as given in the Chemical Abstracts Service Source Index.
C:ABSTACT_ID_CAS, S:700, A:1.0
C:APPLICATION_DATE, S:0, A:1.0
C:APPLICATION_NUM, S:8, A:1.0
C:ASTM, S:6, A:6.0
The American Society for the Testing of Materials (ASTM) code assigned to the journal cited (also referred to as the CODEN designator of the Chemical Abstracts Service); relevant for journal articles.
C:AUTOINSERTED, S:1, A:1.0
'Y' where this was generated automatically, and needs checking by a curator
C:CIF_ID, S:255, A:2.0
An internal identifier of the citation for exchange purposes
C:CITY, S:255, A:3.0
C:COORDINATE_LINKAGE, S:255, A:1.0
States whether or not this citationis concerned with precisely the set of coordinates given in the data block. If, for instance, the publication described the same structure, but the coordinates had undergone further refinement prior to creation of the data block, the value of this data item would be 'no'.
C:COUNTRY_ID, S:10, A:3.0
The database identifier of the Country
C:CSD_ID, S:255, A:1.0
The database identifier of the Csd
C:DEGREE, S:40, A:1.0
This is relevant only for a thesis. The degree of the thesis
C:DEPARTMENT_NAME, S:100, A:1.0
This is relevant only for a thesis. The department where the thesis originated
C:DETAILS, S:700, A:1.0
A description of special aspects that describe the relationship of the contents of the data block to the literature item cited.
C:DOCUMENT_NUM, S:15, A:1.0
C:EDITION, S:8, A:1.0
C:EI_EI_ID, S:10, A:1.0
The database identifier of the Ei Ei
C:ENTRY_ID, S:10, A:4.0
The database identifier of the Entry
C:EV_EV_ID, S:10, A:1.0
The database identifier of the Ev Ev
C:FIRST_PAGE, S:255, A:4.0
The first page of the citation; relevant for journal articles and book chapters.
C:ISBN, S:15, A:1.0
The International Standard Book Number (ISBN) code assigned to the book cited; relevant for book chapters.
C:ISSN, S:9, A:9.0
The International Standard Serial Number (ISSN) code assigned to the journal cited; relevant for journal articles.
C:ISSUE, S:255, A:1.0
Issue number of the journal cited; relevant for journal articles.
C:ISSUE_SUPPLEMENT, S:255, A:1.0
C:JOURNAL_NAME, S:255, A:24.0
Full name of the journal cited; relevant for journal articles.
C:LANGUAGE, S:255, A:1.0
Language in which the citation appears.
C:LAST_NAME, S:255, A:7.0
C:LAST_PAGE, S:255, A:1.0
The last page of the citation; relevant for journal articles and book chapters.
C:MEDLINE_ID, S:10, A:1.0
The database identifier of the Medline
C:NAME_CIF, S:255, A:12.0
C:NAME_INITIALS, S:10, A:4.0
C:NAME_SUFFIX, S:10, A:1.0
C:NUM_PAGES, S:8, A:1.0
C:PATENT_ABSTRACT, S:80, A:1.0
C:PROVIDER_AUTOINSERTED, S:1, A:1.0
C:RBA_CHAPTER_ID, S:255, A:1.0
The database identifier of the Rba Chapter
C:RJ_RJ_ID, S:10, A:3.0
The database identifier of the Rj Rj
C:RP1_ID, S:10, A:4.0
The database identifier of the Rp1
C:RP1_TYPE, S:10, A:3.0
C:RRP_ID, S:10, A:4.0
The database identifier of the Rrp
C:RTA_CHAPTER_ID, S:240, A:1.0
The database identifier of the Rta Chapter
C:SERIES, S:255, A:1.0
C:SR_ID, S:10, A:4.0
The database identifier of the Sr
C:SR_SR_ID, S:10, A:4.0
The database identifier of the Sr Sr
C:SR_SR_ID_CONTAINS_ARTICLE, S:10, A:1.0
C:SR_TYPE, S:10, A:3.0
C:THESIS_ID, S:8, A:1.0
The database identifier of the Thesis
C:TITLE, S:700, A:116.0
The title of the citation; relevant for both journal articles and book chapters. String value for the name of the chapter of a bibliographic reference
C:VOLUME, S:255, A:3.0
Volume number of the journal cited; relevant for journal articles.
C:YEAR, S:10, A:3.0
The year of the citation; relevant for both journal articles and book chapters.
related   Reverse Many Reverse Entity The country of the author
Reverse relation:has of Reverse entity:Country - Relation attributes:Country Id
related   Reverse Many Reverse Entity The entry where the name of the author appears in citations
Reverse relation:has of Reverse entity:Entry - Relation attributes:Entry Id

XRay Data    Entities  Marts
Information about XRay details of the experiment
Reference attributes:Xray Data Id - Naming attributes:Accession Code
C:XRAY_DATA_ID, S:10, A:4.0
The database identifier of the Xray Data
C:ACCESSION_CODE, S:8, A:4.0
The PDB accession code of the entry
C:ANGLE_ALPHA, S:0, A:2.0
C:ANGLE_ALPHA_ESD, S:0, A:1.0
C:ANGLE_BETA, S:0, A:3.0
C:ANGLE_BETA_ESD, S:0, A:1.0
C:ANGLE_GAMMA, S:0, A:3.0
C:ANGLE_GAMMA_ESD, S:0, A:1.0
C:AXIAL_SYMMETRY, S:240, A:1.0
C:AXIS_SETTING, S:1, A:1.0
C:B_ISO_WILSON_ESTIMATE, S:0, A:1.0
C:CELL_DETAILS, S:2000, A:1.0
C:DATA_SET_DETAILS, S:4000, A:9.0
C:DATA_TEXT, S:18, A:1.0
C:DATA_TEXT_FORMAT, S:18, A:1.0
C:DATASET_ID, S:8, A:2.0
The database identifier of the Dataset
C:DATASET_VOLUME, S:0, A:1.0
C:DATASET_VOLUME_ESD, S:0, A:1.0
C:DATE_MEASUREMENT, S:240, A:1.0
C:DELTA_PHI, S:240, A:1.0
C:DELTA_Z, S:240, A:1.0
C:DETAILS, S:2000, A:3.0
C:ENTRY_ID, S:10, A:4.0
The database identifier of the Entry
C:FINAL_REFINEMENT, S:1, A:1.0
C:FORMULA_UNITS_Z, S:8, A:1.0
C:HAND, S:240, A:1.0
C:HARVEST_DATASET_NAME, S:80, A:1.0
C:LENGTH_A, S:0, A:4.0
C:LENGTH_A_ESD, S:0, A:1.0
C:LENGTH_B, S:0, A:4.0
C:LENGTH_B_ESD, S:0, A:1.0
C:LENGTH_C, S:0, A:4.0
C:LENGTH_C_ESD, S:0, A:1.0
C:MERGE_REJECT_CRITERIA, S:255, A:1.0
C:NON_STD, S:1, A:1.0
C:NUM_CRYSTALS, S:10, A:2.0
C:NUM_EQUIV_POS, S:3, A:2.0
C:NUM_NONP_EQUIV_POS, S:3, A:2.0
C:NUM_XTALS, S:10, A:1.0
C:OBSERVED_CRITERION, S:2000, A:1.0
C:POINT_GROUP, S:240, A:3.0
C:SG_NUMBER, S:8, A:3.0
C:APLHA, S:0, A:0.0
C:SHORT_NAME, S:10, A:5.0
C:B_LENGTH, S:0, A:0.0
C:SPACE_GROUP_DETAILS, S:80, A:3.0
C:A_LENGTH, S:0, A:0.0
C:SPACE_GROUP_SYSTEM, S:240, A:9.0
C:TILT_ANGLE_INCR, S:0, A:0.0
C:STANDARD_NAME, S:80, A:7.0
C:ET_DETAILS, S:4000, A:0.0
C:T_NUMBER, S:240, A:1.0
C:NUM_SECTIONS, S:0, A:0.0
C:C_LENGTH, S:0, A:0.0
C:UNIQUE_AXIS, S:240, A:1.0
C:Z_PDB, S:8, A:2.0
C:BETA, S:0, A:0.0
C:GAMMA, S:0, A:0.0
C:PLANE_GROUP, S:720, A:0.0
C:E2X_DETAILS, S:4000, A:0.0
C:EI1_DETAILS, S:4000, A:0.0
C:ESP1_DETAILS, S:4000, A:0.0
C:EULER_ANGLE_DISTRIBUTION, S:0, A:0.0
C:NUM_PROJECTIONS, S:38, A:0.0
C:NUM_CLASS_AVERAGES, S:0, A:0.0
C:EH1_DETAILS, S:4000, A:0.0
related   Reverse Many Reverse Entity The entry that the xray data are about
Reverse relation:has of Reverse entity:Entry - Relation attributes:Entry Id

XRay Refinement Data    Entities  Marts
Information about the refinement process
Reference attributes:Xray Refinement Id - Naming attributes:Accession Code
C:XRAY_REFINEMENT_ID, S:10, A:4.0
The database identifier of the Xray Refinement
C:ACCESSION_CODE, S:8, A:4.0
The PDB accession code of the entry
C:B_ISO_DETAILS, S:255, A:1.0
C:B_ISO_MAX, S:0, A:1.0
C:B_ISO_MEAN, S:0, A:2.0
C:B_ISO_MIN, S:0, A:1.0
C:B_ISO_VALUE, S:0, A:1.0
C:CROSS_VALID_METHOD, S:700, A:7.0
C:CUTOFF_HIGH_ABS_F, S:0, A:2.0
C:CUTOFF_HIGH_RMS_ABS_F, S:0, A:1.0
C:CUTOFF_LOW_ABS_F, S:0, A:2.0
C:DD1_DD1_ID, S:10, A:4.0
The database identifier of the Dd1Dd1
C:DETAILS, S:2000, A:54.0
C:DIFF_DENSITY_MAX, S:0, A:1.0
C:DIFF_DENSITY_MAX_ESD, S:0, A:1.0
C:DIFF_DENSITY_MIN, S:0, A:1.0
C:DIFF_DENSITY_MIN_ESD, S:0, A:1.0
C:DIFF_DENSITY_RMS, S:0, A:1.0
C:DIFF_DENSITY_RMS_ESD, S:0, A:1.0
C:DIFF_SHIFT_OVER_ESD_MAX, S:0, A:1.0
C:DIFF_SHIFT_OVER_ESD_MEAN, S:0, A:1.0
C:ENTRY_ID, S:10, A:4.0
The database identifier of the Entry
C:FN_MIN_NUMTERMS, S:10, A:1.0
C:FN_MIN_RESIDUAL, S:0, A:1.0
C:FN_MIN_TYPE, S:255, A:1.0
C:H_LS_TRMT, S:10, A:1.0
C:ISOTROPIC_THERMAL_MODEL, S:700, A:4.0
C:LS_CORREL_COEFF_FO_TO_FC, S:0, A:1.0
C:LS_CORREL_COEFF_FO_TO_FC_FREE, S:0, A:1.0
C:LS_CUTOFF_SIGMA_F, S:0, A:2.0
C:LS_CUTOFF_SIGMA_I, S:0, A:1.0
C:LS_D_RES_HIGH, S:0, A:3.0
C:LS_D_RES_LOW, S:0, A:3.0
C:LS_GOODNESS_FIT_ALL, S:0, A:1.0
C:LS_GOODNESS_FIT_ALL_ESD, S:0, A:1.0
C:LS_GOODNESS_FIT_OBS, S:0, A:1.0
C:LS_GOODNESS_FIT_OBS_ESD, S:0, A:1.0
C:LS_MATRIX_TYPE, S:12, A:1.0
C:LS_NUM_CONSTRAINTS, S:10, A:1.0
C:LS_NUM_PARAMETERS, S:10, A:2.0
C:LS_NUM_REFLNS_ALL, S:10, A:2.0
C:LS_NUM_REFLNS_OBS, S:10, A:4.0
C:LS_NUM_REFLNS_R_FREE, S:10, A:3.0
C:LS_NUM_REFLNS_R_WORK, S:10, A:1.0
C:LS_NUM_RESTRAINTS, S:10, A:2.0
C:LS_OVERALL_ESU_B, S:0, A:1.0
C:LS_OVERALL_ESU_ML, S:0, A:1.0
C:LS_OVERALL_ESU_R, S:0, A:1.0
C:LS_OVERALL_ESU_R_CRUICK_DPI, S:0, A:1.0
C:LS_OVERALL_ESU_RFREE, S:0, A:1.0
C:LS_OVERALL_FOM_FREE_RSET, S:0, A:1.0
C:LS_OVERALL_FOM_WORK_RSET, S:0, A:1.0
C:LS_PERCENT_REFLNS_OBS, S:0, A:3.0
C:LS_PERCENT_REFLNS_R_FREE, S:0, A:2.0
C:LS_REDUNDANCY_REFLNS_ALL, S:0, A:1.0
C:LS_REDUNDANCY_REFLNS_OBS, S:0, A:1.0
C:LS_RESTRAINED_S_ALL, S:0, A:1.0
C:LS_RESTRAINED_S_OBS, S:0, A:1.0
C:LS_WEIGHT_SCHEME, S:10, A:1.0
C:LS_WEIGHTING_DETAILS, S:2000, A:1.0
C:NUM_OBS_NO_CUTOFF, S:10, A:1.0
C:NUM_OBS_4SIG_CUTOFF, S:10, A:2.0
C:OCCUPANCY_MAX, S:0, A:1.0
C:OCCUPANCY_MIN, S:0, A:1.0
C:R_FACTOR_ALL, S:0, A:1.0
C:R_FACTOR_ALL_NO_CUTOFF, S:0, A:2.0
C:R_FACTOR_ALL_4SIG_CUTOFF, S:0, A:2.0
C:R_FACTOR_OBS, S:0, A:2.0
C:R_FACTOR_OBS_NO_CUTOFF, S:0, A:2.0
C:R_FACTOR_OBS_4SIG_CUTOFF, S:0, A:2.0
C:R_FREE, S:0, A:3.0
C:R_FREE_ERROR, S:0, A:2.0
C:R_FREE_ERROR_DETAILS, S:255, A:1.0
C:R_FREE_NO_CUTOFF, S:0, A:2.0
C:R_FREE_PERC_SET_NO_CUTOFF, S:0, A:2.0
C:R_FREE_PERC_SET_4SIG_CUTOFF, S:0, A:2.0
C:R_FREE_SELECTION_DETAILS, S:700, A:6.0
C:R_FREE_SET_NO_CUTOFF, S:0, A:2.0
C:R_FREE_SET_4SIG_CUTOFF, S:0, A:1.0
C:R_FREE_4SIG_CUTOFF, S:0, A:2.0
C:R_FSQD_FACTOR_OBS, S:0, A:1.0
C:R_I_FACTOR_OBS, S:0, A:1.0
C:R_WORK, S:0, A:3.0
C:RELEASE_STATUS, S:1, A:1.0
C:RG_ALL, S:0, A:1.0
C:RG_D_RES_HIGH, S:0, A:1.0
C:RG_D_RES_LOW, S:0, A:1.0
C:RG_FREE, S:0, A:1.0
C:RG_WORK, S:0, A:1.0
C:RG_WORK_FREE_RATIO, S:0, A:1.0
C:RSM1_RSM1_ID, S:10, A:1.0
The database identifier of the Rsm1Rsm1
C:SOLVENT_MODEL_DETAILS, S:1000, A:4.0
C:SOLVENT_MODEL_PARAM_BSOL, S:0, A:2.0
C:SOLVENT_MODEL_PARAM_KSOL, S:0, A:2.0
C:STARTING_MODEL, S:700, A:9.0
C:STEREOCHEM_TARGET_VAL, S:700, A:2.0
C:STEREOCHEM_TARGET_VAL_SPEC_CAS, S:700, A:2.0
C:WR_FACTOR_ALL, S:0, A:1.0
C:WR_FACTOR_OBS, S:0, A:1.0
C:WR_FACTOR_R_FREE, S:0, A:1.0
C:WR_FACTOR_R_WORK, S:0, A:1.0
related   Reverse Unknown Reverse Entity The entry that the xray refinement are about
Reverse relation:has of Reverse entity:Entry - Relation attributes:Entry Id

Country    Entities  Marts
Reference information about the countries of the world
Reference attributes:Country Id - Naming attributes:Name
C:COUNTRY_ID, S:10, A:3.0
The database identifier of the Country
C:ABBREV, S:255, A:1.0
A common abbreviation used to refer to the country
C:ABBREV_PDB, S:255, A:1.0
The two letter abbreviation used to refer to a country in the PDB format
C:NAME, S:255, A:9.0
The name, in mixed case, of the country.
related   Reverse Optional Reverse Entity The citation authors that come from this country
Reverse relation:from of Reverse entity:Citation Author - Relation attributes:Country Id