NMR-STAR dictionary: detail of IsotopeEffect table

NMR-STAR dictionary: database table: IsotopeEffect

Detailed description of the fields

_Isotope_effect.ID (IsotopeEffectID)

NMR-STAR tag name	_Isotope_effect.ID
Description	NMR-STAR name: _Isotope_effect.ID Unique identifier for the observed isotope effect.
Database field name	IsotopeEffectID
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	ID
Examples	?
Help text

_Isotope_effect.Assembly_atom_ID (AssemblyAtomID)

(go to parent tag category listing)

NMR-STAR tag name	_Isotope_effect.Assembly_atom_ID
Description	NMR-STAR name: _Isotope_effect.Assembly_atom_ID Pointer to '_Atom.Assembly_atom_ID'
Database field name	AssemblyAtomID
SQL Database type	INTEGER
Part of primary Key	no
Foreign Key on table, column	Atom, Assembly_atom_ID
Saveframe ID	no
Row Index	no
Secondary Index	no
Internal Flag	no
Nulls allowed in database?	no
Prompt	Entry atom ID
Examples	?
Help text

_Isotope_effect.Entity_assembly_ID (EntityAssemblyID)

(go to parent tag category listing)

NMR-STAR tag name	_Isotope_effect.Entity_assembly_ID
Description	NMR-STAR name: _Isotope_effect.Entity_assembly_ID Pointer to '_Entity_assembly.ID'
Database field name	EntityAssemblyID
SQL Database type	INTEGER
Part of primary Key	no
Foreign Key on table, column	Entity_assembly, ID
Saveframe ID	no
Row Index	no
Secondary Index	no
Internal Flag	no
Nulls allowed in database?	yes
Prompt	Mol sys comp ID
Examples	?
Help text

_Isotope_effect.Entity_ID (EntityID)

(go to parent tag category listing)

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

_Isotope_effect.Comp_index_ID (CompIndexID)

(go to parent tag category listing)

NMR-STAR tag name	_Isotope_effect.Comp_index_ID
Description	NMR-STAR name: _Isotope_effect.Comp_index_ID Pointer to '_Entity_comp_index.ID'
Database field name	CompIndexID
SQL Database type	INTEGER
Part of primary Key	no
Foreign Key on table, column	Entity_comp_index, ID
Saveframe ID	no
Row Index	no
Secondary Index	no
Internal Flag	no
Nulls allowed in database?	yes
Prompt	Chem comp index ID
Examples	?
Help text

_Isotope_effect.Seq_ID (SeqID)

(go to parent tag category listing)

NMR-STAR tag name	_Isotope_effect.Seq_ID
Description	NMR-STAR name: _Isotope_effect.Seq_ID Pointer to '_PDBX_poly_seq_scheme.Seq_ID'
Database field name	SeqID
SQL Database type	INTEGER
Part of primary Key	no
Foreign Key on table, column	Entity_poly_seq, Num
Saveframe ID	no
Row Index	no
Secondary Index	no
Internal Flag	no
Nulls allowed in database?	no
Prompt	Chem comp seq num
Examples	?
Help text

_Isotope_effect.Comp_ID (CompID)

(go to parent tag category listing)

NMR-STAR tag name	_Isotope_effect.Comp_ID
Description	NMR-STAR name: _Isotope_effect.Comp_ID Pointer to '_Chem_comp.ID'
Database field name	CompID
SQL Database type	CHAR(12)
Part of primary Key	no
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

_Isotope_effect.Atom_ID (AtomID)

(go to parent tag category listing)

NMR-STAR tag name	_Isotope_effect.Atom_ID
Description	NMR-STAR name: _Isotope_effect.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

_Isotope_effect.Atom_type (AtomType)

(go to parent tag category listing)

NMR-STAR tag name	_Isotope_effect.Atom_type
Description	NMR-STAR name: _Isotope_effect.Atom_type The value for this tag is a standard IUPAC abbreviation for an element (i.e., H, C, P, etc).
Database field name	AtomType
SQL Database type	VARCHAR(15)
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	Atom type
Examples	?
Help text

_Isotope_effect.Atom_isotope_number (AtomIsotopeNumber)

(go to parent tag category listing)

NMR-STAR tag name	_Isotope_effect.Atom_isotope_number
Description	NMR-STAR name: _Isotope_effect.Atom_isotope_number The isotope number for the chemical element defined by the tag '_Atom_type' or any of its related tags.
Database field name	AtomIsotopeNumber
SQL Database type	INTEGER
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	Atom isotope number
Examples	1 13 15
Help text

_Isotope_effect.Label_sample_ID_1 (LabelSampleID1)

(go to parent tag category listing)

NMR-STAR tag name	_Isotope_effect.Label_sample_ID_1
Description	NMR-STAR name: _Isotope_effect.Label_sample_ID_1 Pointer to '_Sample.ID'
Database field name	LabelSampleID1
SQL Database type	INTEGER
Part of primary Key	no
Foreign Key on table, column	Sample, ID
Saveframe ID	no
Row Index	no
Secondary Index	no
Internal Flag	no
Nulls allowed in database?	yes
Prompt	Isotope label 1 ID
Examples	?
Help text

_Isotope_effect.Label_pattern_ID_1 (LabelPatternID1)

(go to parent tag category listing)

NMR-STAR tag name	_Isotope_effect.Label_pattern_ID_1
Description	NMR-STAR name: _Isotope_effect.Label_pattern_ID_1 Pointer to '_Isotope_label_pattern.ID'
Database field name	LabelPatternID1
SQL Database type	INTEGER
Part of primary Key	no
Foreign Key on table, column	Isotope_label_pattern, ID
Saveframe ID	no
Row Index	no
Secondary Index	no
Internal Flag	no
Nulls allowed in database?	no
Prompt	Label pattern ID 1
Examples	?
Help text

_Isotope_effect.Label_1_ID_chem_shift_val (Label1IDChemShiftVal)

(go to parent tag category listing)

NMR-STAR tag name	_Isotope_effect.Label_1_ID_chem_shift_val
Description	NMR-STAR name: _Isotope_effect.Label_1_ID_chem_shift_val ?
Database field name	Label1IDChemShiftVal
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?	no
Prompt	Isotope label 1 ID chem shift val
Examples	?
Help text

_Isotope_effect.Label_1_ID_chem_shift_val_err (Label1IDChemShiftValErr)

(go to parent tag category listing)

NMR-STAR tag name	_Isotope_effect.Label_1_ID_chem_shift_val_err
Description	NMR-STAR name: _Isotope_effect.Label_1_ID_chem_shift_val_err ?
Database field name	Label1IDChemShiftValErr
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?	no
Prompt	Isotope label 1 ID chem shift val err
Examples	?
Help text

_Isotope_effect.Label_sample_ID_2 (LabelSampleID2)

(go to parent tag category listing)

NMR-STAR tag name	_Isotope_effect.Label_sample_ID_2
Description	NMR-STAR name: _Isotope_effect.Label_sample_ID_2 Pointer to '_Sample.ID'
Database field name	LabelSampleID2
SQL Database type	INTEGER
Part of primary Key	no
Foreign Key on table, column	Sample, ID
Saveframe ID	no
Row Index	no
Secondary Index	no
Internal Flag	no
Nulls allowed in database?	yes
Prompt	Isotope label 2 ID
Examples	?
Help text

_Isotope_effect.Label_pattern_ID_2 (LabelPatternID2)

(go to parent tag category listing)

NMR-STAR tag name	_Isotope_effect.Label_pattern_ID_2
Description	NMR-STAR name: _Isotope_effect.Label_pattern_ID_2 Pointer to '_Isotope_label_pattern.ID'
Database field name	LabelPatternID2
SQL Database type	INTEGER
Part of primary Key	no
Foreign Key on table, column	Isotope_label_pattern, ID
Saveframe ID	no
Row Index	no
Secondary Index	no
Internal Flag	no
Nulls allowed in database?	no
Prompt	Label pattern ID 2
Examples	?
Help text

_Isotope_effect.Label_2_ID_chem_shift_val (Label2IDChemShiftVal)

(go to parent tag category listing)

NMR-STAR tag name	_Isotope_effect.Label_2_ID_chem_shift_val
Description	NMR-STAR name: _Isotope_effect.Label_2_ID_chem_shift_val ?
Database field name	Label2IDChemShiftVal
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?	no
Prompt	Isotope label 2 ID chem shift val
Examples	?
Help text

_Isotope_effect.Label_2_ID_chem_shift_val_err (Label2IDChemShiftValErr)

(go to parent tag category listing)

NMR-STAR tag name	_Isotope_effect.Label_2_ID_chem_shift_val_err
Description	NMR-STAR name: _Isotope_effect.Label_2_ID_chem_shift_val_err ?
Database field name	Label2IDChemShiftValErr
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?	no
Prompt	Isotope label 2 ID chem shift val err
Examples	?
Help text

_Isotope_effect.Chem_shift_val (ChemShiftVal)

(go to parent tag category listing)

NMR-STAR tag name	_Isotope_effect.Chem_shift_val
Description	NMR-STAR name: _Isotope_effect.Chem_shift_val ?
Database field name	ChemShiftVal
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?	no
Prompt	Isotope chem shift effect val
Examples	?
Help text

_Isotope_effect.Chem_shift_val_err (ChemShiftValErr)

(go to parent tag category listing)

NMR-STAR tag name	_Isotope_effect.Chem_shift_val_err
Description	NMR-STAR name: _Isotope_effect.Chem_shift_val_err ?
Database field name	ChemShiftValErr
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?	no
Prompt	Isotope chem shift effect val err
Examples	?
Help text

_Isotope_effect.Resonance_ID_1 (ResonanceID1)

(go to parent tag category listing)

NMR-STAR tag name	_Isotope_effect.Resonance_ID_1
Description	NMR-STAR name: _Isotope_effect.Resonance_ID_1 Pointer to '_Resonance.ID'
Database field name	ResonanceID1
SQL Database type	INTEGER
Part of primary Key	no
Foreign Key on table, column	Resonance, ID
Saveframe ID	no
Row Index	no
Secondary Index	no
Internal Flag	no
Nulls allowed in database?	no
Prompt	Resonance ID 1
Examples	?
Help text

_Isotope_effect.Resonance_ID_2 (ResonanceID2)

(go to parent tag category listing)

NMR-STAR tag name	_Isotope_effect.Resonance_ID_2
Description	NMR-STAR name: _Isotope_effect.Resonance_ID_2 Pointer to '_Resonance.ID'
Database field name	ResonanceID2
SQL Database type	INTEGER
Part of primary Key	no
Foreign Key on table, column	Resonance, ID
Saveframe ID	no
Row Index	no
Secondary Index	no
Internal Flag	no
Nulls allowed in database?	no
Prompt	Resonance ID 2
Examples	?
Help text

_Isotope_effect.Auth_entity_assembly_ID (AuthEntityAssemblyID)

(go to parent tag category listing)

NMR-STAR tag name	_Isotope_effect.Auth_entity_assembly_ID
Description	NMR-STAR name: _Isotope_effect.Auth_entity_assembly_ID ?
Database field name	AuthEntityAssemblyID
SQL Database type	VARCHAR(15)
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	Auth entity assembly ID
Examples	?
Help text

_Isotope_effect.Auth_seq_ID (AuthSeqID)

(go to parent tag category listing)

NMR-STAR tag name	_Isotope_effect.Auth_seq_ID
Description	NMR-STAR name: _Isotope_effect.Auth_seq_ID An alternative identifier for Seq_id that may be provided by an author in order to match that used in the publication that describes the experimental data. Note that the value is not required to be a number and does not need to correspond to the value for Seq_ID or Comp_index_ID.
Database field name	AuthSeqID
SQL Database type	VARCHAR(15)
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	Auth seq ID
Examples	-3
Help text

_Isotope_effect.Auth_comp_ID (AuthCompID)

(go to parent tag category listing)

NMR-STAR tag name	_Isotope_effect.Auth_comp_ID
Description	NMR-STAR name: _Isotope_effect.Auth_comp_ID An alternative identifier for Comp_id that may be provided by an author in order to match that used in the publication that describes the experimental data.
Database field name	AuthCompID
SQL Database type	VARCHAR(15)
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	Auth comp ID
Examples	DPN
Help text

_Isotope_effect.Auth_atom_ID (AuthAtomID)

(go to parent tag category listing)

NMR-STAR tag name	_Isotope_effect.Auth_atom_ID
Description	NMR-STAR name: _Isotope_effect.Auth_atom_ID An alternative identifier for Atom_id that may be provided by an author in order to match that used in the publication that describes the experimental data.
Database field name	AuthAtomID
SQL Database type	VARCHAR(15)
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	Auth atom ID
Examples	HB1
Help text

_Isotope_effect.Sf_ID (SfID)

(go to parent tag category listing)

NMR-STAR tag name	_Isotope_effect.Sf_ID
Description	NMR-STAR name: _Isotope_effect.Sf_ID Pointer to '_Chem_shift_isotope_effect_list.Sf_ID'
Database field name	SfID
SQL Database type	INTEGER
Part of primary Key	no
Foreign Key on table, column	Chem_shift_isotope_effect_list, 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

_Isotope_effect.Entry_ID (EntryID)

(go to parent tag category listing)

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

_Isotope_effect.Chem_shift_isotope_effect_list_ID (ChemShiftIsotopeEffectListID)

(go to parent tag category listing)

NMR-STAR tag name	_Isotope_effect.Chem_shift_isotope_effect_list_ID
Description	NMR-STAR name: _Isotope_effect.Chem_shift_isotope_effect_list_ID Pointer to '_Chem_shift_isotope_effect_list.ID'
Database field name	ChemShiftIsotopeEffectListID
SQL Database type	INTEGER
Part of primary Key	yes
Foreign Key on table, column	Chem_shift_isotope_effect_list, ID
Saveframe ID	no
Row Index	no
Secondary Index	no
Internal Flag	no
Nulls allowed in database?	yes
Prompt	Chem shift isotope effect list ID
Examples	?
Help text