NMR-STAR dictionary: detail of ChemCompDbLink table

NMR-STAR dictionary: database table: ChemCompDbLink

Detailed description of the fields

_Chem_comp_db_link.Author_supplied (AuthorSupplied)

(go to parent tag category listing)

NMR-STAR tag name	_Chem_comp_db_link.Author_supplied
Description	NMR-STAR name: _Chem_comp_db_link.Author_supplied A code indicating if the database link was provided by the author of the deposition (yes) or by another source (no).
Database field name	AuthorSupplied
SQL Database type	VARCHAR(3)
Part of primary Key	no
Foreign Key on table, column	,
Saveframe ID	no
Row Index	no
Secondary Index	no
Internal Flag	no
Nulls allowed in database?	no
Enumerations	[click for a list of enumerations] This is a closed enumeration. The list of values are the only ones allowed.
Prompt	Author supplied
Examples	?
Help text

_Chem_comp_db_link.Database_code (DatabaseCode)

(go to parent tag category listing)

NMR-STAR tag name	_Chem_comp_db_link.Database_code
Description	NMR-STAR name: _Chem_comp_db_link.Database_code Enter the abbreviation or acronym for the database site for the entry for the chemical compound.
Database field name	DatabaseCode
SQL Database type	VARCHAR(127)
Part of primary Key	yes
Foreign Key on table, column	,
Saveframe ID	no
Row Index	no
Secondary Index	no
Internal Flag	no
Nulls allowed in database?	yes
Prompt	Database abbreviation or acronym
Examples	PDB
Help text

_Chem_comp_db_link.Accession_code (AccessionCode)

(go to parent tag category listing)

NMR-STAR tag name	_Chem_comp_db_link.Accession_code
Description	NMR-STAR name: _Chem_comp_db_link.Accession_code Enter the accession code for the chemical compound from the database listed.
Database field name	AccessionCode
SQL Database type	VARCHAR(31)
Part of primary Key	yes
Foreign Key on table, column	,
Saveframe ID	no
Row Index	no
Secondary Index	no
Internal Flag	no
Nulls allowed in database?	yes
Prompt	Database accession code
Examples	HEM
Help text

_Chem_comp_db_link.Accession_code_type (AccessionCodeType)

(go to parent tag category listing)

NMR-STAR tag name	_Chem_comp_db_link.Accession_code_type
Description	NMR-STAR name: _Chem_comp_db_link.Accession_code_type ?
Database field name	AccessionCodeType
SQL Database type	VARCHAR(127)
Part of primary Key	no
Foreign Key on table, column	,
Saveframe ID	no
Row Index	no
Secondary Index	no
Internal Flag	no
Nulls allowed in database?	no
Prompt	Accession code type
Examples	?
Help text

_Chem_comp_db_link.Entry_mol_code (EntryMolCode)

(go to parent tag category listing)

NMR-STAR tag name	_Chem_comp_db_link.Entry_mol_code
Description	NMR-STAR name: _Chem_comp_db_link.Entry_mol_code Code used by the database for the molecule.
Database field name	EntryMolCode
SQL Database type	VARCHAR(127)
Part of primary Key	no
Foreign Key on table, column	,
Saveframe ID	no
Row Index	no
Secondary Index	no
Internal Flag	no
Nulls allowed in database?	no
Prompt	Entry mol code
Examples	?
Help text

_Chem_comp_db_link.Entry_mol_name (EntryMolName)

(go to parent tag category listing)

NMR-STAR tag name	_Chem_comp_db_link.Entry_mol_name
Description	NMR-STAR name: _Chem_comp_db_link.Entry_mol_name Name given by the database to the molecule.
Database field name	EntryMolName
SQL Database type	VARCHAR(127)
Part of primary Key	no
Foreign Key on table, column	,
Saveframe ID	no
Row Index	no
Secondary Index	no
Internal Flag	no
Nulls allowed in database?	no
Prompt	Entry mol name
Examples	?
Help text

_Chem_comp_db_link.Entry_experimental_method (EntryExperimentalMethod)

(go to parent tag category listing)

NMR-STAR tag name	_Chem_comp_db_link.Entry_experimental_method
Description	NMR-STAR name: _Chem_comp_db_link.Entry_experimental_method If appropriate, list the experimental technique (NMR, mass spectrometry, X-ray crystallography) that was used to collect the data in the entry at the database listed.
Database field name	EntryExperimentalMethod
SQL Database type	VARCHAR(127)
Part of primary Key	no
Foreign Key on table, column	,
Saveframe ID	no
Row Index	no
Secondary Index	no
Internal Flag	no
Nulls allowed in database?	no
Prompt	Experimental method of data collection
Examples	NMR
Help text

_Chem_comp_db_link.Entry_relation_type (EntryRelationType)

(go to parent tag category listing)

NMR-STAR tag name	_Chem_comp_db_link.Entry_relation_type
Description	NMR-STAR name: _Chem_comp_db_link.Entry_relation_type Describe the relationship between the entry in the listed database and this BMRB entry. This might include the physical properties of the compound or the position of the compound in a metabolic pathway, for example.
Database field name	EntryRelationType
SQL Database type	VARCHAR(127)
Part of primary Key	no
Foreign Key on table, column	,
Saveframe ID	no
Row Index	no
Secondary Index	no
Internal Flag	no
Nulls allowed in database?	no
Prompt	Relationship to BMRB entry
Examples	Physical properties of the compound
Help text

_Chem_comp_db_link.Entry_details (EntryDetails)

(go to parent tag category listing)

NMR-STAR tag name	_Chem_comp_db_link.Entry_details
Description	NMR-STAR name: _Chem_comp_db_link.Entry_details If appropriate, additional text information regarding the entry in the listed database can be entered in this field.
Database field name	EntryDetails
SQL Database type	TEXT
Part of primary Key	no
Foreign Key on table, column	,
Saveframe ID	no
Row Index	no
Secondary Index	no
Internal Flag	no
Nulls allowed in database?	no
Prompt	Details for the database entry
Examples	A variety of physical parameters are available from this site, including pKa values and UV absorption data for protoporphyrin IX.
Help text

_Chem_comp_db_link.Sf_ID (SfID)

(go to parent tag category listing)

NMR-STAR tag name	_Chem_comp_db_link.Sf_ID
Description	NMR-STAR name: _Chem_comp_db_link.Sf_ID Pointer to '_Chem_comp.Sf_ID'
Database field name	SfID
SQL Database type	INTEGER
Part of primary Key	no
Foreign Key on table, column	Chem_comp, Sf_ID
Saveframe ID	no
Row Index	no
Secondary Index	no
Internal Flag	yes This field's data is for internal use only and should be hidden in public versiond of the data.
Nulls allowed in database?	yes
Prompt	Sf ID
Examples	?
Help text

_Chem_comp_db_link.Entry_ID (EntryID)

(go to parent tag category listing)

NMR-STAR tag name	_Chem_comp_db_link.Entry_ID
Description	NMR-STAR name: _Chem_comp_db_link.Entry_ID Pointer to '_Entry.ID'
Database field name	EntryID
SQL Database type	CHAR(12)
Part of primary Key	yes
Foreign Key on table, column	Chem_comp, Entry_ID
Saveframe ID	no
Row Index	no
Secondary Index	no
Internal Flag	no
Nulls allowed in database?	yes
Prompt	Entry ID
Examples	?
Help text

_Chem_comp_db_link.Comp_ID (CompID)

(go to parent tag category listing)

NMR-STAR tag name	_Chem_comp_db_link.Comp_ID
Description	NMR-STAR name: _Chem_comp_db_link.Comp_ID Pointer to '_Chem_comp.ID'
Database field name	CompID
SQL Database type	CHAR(12)
Part of primary Key	yes
Foreign Key on table, column	Chem_comp, ID
Saveframe ID	no
Row Index	no
Secondary Index	no
Internal Flag	no
Nulls allowed in database?	yes
Prompt	Comp ID
Examples	?
Help text