NMR-STAR dictionary: detail of Characteristic table

NMR-STAR dictionary: database table: Characteristic

Detailed description of the fields

_Characteristic.ID (CharacteristicID)

(go to parent tag category listing)

NMR-STAR tag name	_Characteristic.ID
Description	NMR-STAR name: _Characteristic.ID A value that uniquely identifies each characteristic provided in the list.
Database field name	CharacteristicID
SQL Database type	INTEGER
Part of primary Key	yes
Foreign Key on table, column	,
Saveframe ID	yes: This tag contains the identifier for this saveframe in the entry.
Row Index	yes: This tag contains the index of this row in the loop, which is used when the data is loaded into a database which has a relational model in which ordering doesn't matter
Secondary Index	no
Internal Flag	no
Nulls allowed in database?	yes
Prompt	Characteristic ID
Examples	?
Help text

_Characteristic.Name (Name)

(go to parent tag category listing)

NMR-STAR tag name	_Characteristic.Name
Description	NMR-STAR name: _Characteristic.Name Name for the reported characteristic of the chemical component.
Database field name	Name
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?	yes
Prompt	Designation for the characteristic for the chemical compound
Examples	UV absorption maximum
Help text

_Characteristic.Atom_ID (AtomID)

(go to parent tag category listing)

NMR-STAR tag name	_Characteristic.Atom_ID
Description	NMR-STAR name: _Characteristic.Atom_ID Pointer to '_Chem_comp_atom.Atom_ID'
Database field name	AtomID
SQL Database type	CHAR(12)
Part of primary Key	no
Foreign Key on table, column	Chem_comp_atom, Atom_ID
Saveframe ID	no
Row Index	no
Secondary Index	no
Internal Flag	no
Nulls allowed in database?	yes
Prompt	Atom ID
Examples	?
Help text

_Characteristic.Chemical_group (ChemicalGroup)

(go to parent tag category listing)

NMR-STAR tag name	_Characteristic.Chemical_group
Description	NMR-STAR name: _Characteristic.Chemical_group Chemical group that is responsible for the observed characteristic of the chemical component.
Database field name	ChemicalGroup
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	Chemical group
Examples	?
Help text

_Characteristic.Val (Val)

(go to parent tag category listing)

NMR-STAR tag name	_Characteristic.Val
Description	NMR-STAR name: _Characteristic.Val Value for the defined characteristic of the chemical component.
Database field name	Val
SQL Database type	FLOAT
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?	yes
Prompt	Val
Examples	?
Help text

_Characteristic.Val_err (ValErr)

(go to parent tag category listing)

NMR-STAR tag name	_Characteristic.Val_err
Description	NMR-STAR name: _Characteristic.Val_err Estimated error in the reported characteristic of the chemical component.
Database field name	ValErr
SQL Database type	FLOAT
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?	yes
Prompt	Val err
Examples	?
Help text

_Characteristic.Source (Source)

(go to parent tag category listing)

NMR-STAR tag name	_Characteristic.Source
Description	NMR-STAR name: _Characteristic.Source Experimental source for the value reported for the chemical component.
Database field name	Source
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?	yes
Prompt	Source
Examples	?
Help text

_Characteristic.Citation_ID (CitationID)

(go to parent tag category listing)

NMR-STAR tag name	_Characteristic.Citation_ID
Description	NMR-STAR name: _Characteristic.Citation_ID Pointer to '_Citation.ID'
Database field name	CitationID
SQL Database type	INTEGER
Part of primary Key	no
Foreign Key on table, column	Citation, ID
Saveframe ID	no
Row Index	no
Secondary Index	no
Internal Flag	no
Nulls allowed in database?	yes
Prompt	Citation ID
Examples	?
Help text

_Characteristic.Citation_label (CitationLabel)

(go to parent tag category listing)

NMR-STAR tag name	_Characteristic.Citation_label
Description	NMR-STAR name: _Characteristic.Citation_label Pointer to a saveframe of the category citation.
Database field name	CitationLabel
SQL Database type	VARCHAR(127)
Part of primary Key	no
Foreign Key on table, column	Citation, Sf_framecode
Saveframe ID	no
Row Index	no
Secondary Index	no
Internal Flag	no
Nulls allowed in database?	yes
Prompt	Citation label
Examples	?
Help text

_Characteristic.Sf_ID (SfID)

(go to parent tag category listing)

NMR-STAR tag name	_Characteristic.Sf_ID
Description	NMR-STAR name: _Characteristic.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

_Characteristic.Entry_ID (EntryID)

(go to parent tag category listing)

NMR-STAR tag name	_Characteristic.Entry_ID
Description	NMR-STAR name: _Characteristic.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

_Characteristic.Comp_ID (CompID)

(go to parent tag category listing)

NMR-STAR tag name	_Characteristic.Comp_ID
Description	NMR-STAR name: _Characteristic.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