NMR-STAR dictionary: detail of AssignedSpectralTransition table

NMR-STAR dictionary: database table: AssignedSpectralTransition

Detailed description of the fields

_Assigned_spectral_transition.Spectral_transition_ID (SpectralTransitionID)

NMR-STAR tag name	_Assigned_spectral_transition.Spectral_transition_ID
Description	NMR-STAR name: _Assigned_spectral_transition.Spectral_transition_ID Pointer to '_Spectral_transition.ID'
Database field name	SpectralTransitionID
SQL Database type	INTEGER
Part of primary Key	yes
Foreign Key on table, column	Spectral_transition, ID
Saveframe ID	no
Row Index	no
Secondary Index	no
Internal Flag	no
Nulls allowed in database?	yes
Prompt	Spectral transition ID
Examples	?
Help text

_Assigned_spectral_transition.Spectral_dim_ID (SpectralDimID)

(go to parent tag category listing)

NMR-STAR tag name	_Assigned_spectral_transition.Spectral_dim_ID
Description	NMR-STAR name: _Assigned_spectral_transition.Spectral_dim_ID Pointer to '_Spectral_dim.ID'
Database field name	SpectralDimID
SQL Database type	INTEGER
Part of primary Key	yes
Foreign Key on table, column	Spectral_dim, ID
Saveframe ID	no
Row Index	no
Secondary Index	no
Internal Flag	no
Nulls allowed in database?	yes
Prompt	Spectral dim ID
Examples	?
Help text

_Assigned_spectral_transition.Spectral_transition_contrib_ID (SpectralTransitionContribID)

(go to parent tag category listing)

NMR-STAR tag name	_Assigned_spectral_transition.Spectral_transition_contrib_ID
Description	NMR-STAR name: _Assigned_spectral_transition.Spectral_transition_contrib_ID Pointer to '_Spectral_transition_contrib.ID'
Database field name	SpectralTransitionContribID
SQL Database type	INTEGER
Part of primary Key	no
Foreign Key on table, column	Spectral_transition_contrib, ID
Saveframe ID	no
Row Index	no
Secondary Index	no
Internal Flag	no
Nulls allowed in database?	no
Prompt	Spectral transition contrib ID
Examples	?
Help text

_Assigned_spectral_transition.Peak_ID (PeakID)

(go to parent tag category listing)

NMR-STAR tag name	_Assigned_spectral_transition.Peak_ID
Description	NMR-STAR name: _Assigned_spectral_transition.Peak_ID Pointer to '_Peak.ID'
Database field name	PeakID
SQL Database type	INTEGER
Part of primary Key	no
Foreign Key on table, column	Peak, ID
Saveframe ID	no
Row Index	no
Secondary Index	no
Internal Flag	no
Nulls allowed in database?	no
Prompt	Peak ID
Examples	?
Help text

_Assigned_spectral_transition.Set_ID (SetID)

(go to parent tag category listing)

NMR-STAR tag name	_Assigned_spectral_transition.Set_ID
Description	NMR-STAR name: _Assigned_spectral_transition.Set_ID ?
Database field name	SetID
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	Set ID
Examples	?
Help text

_Assigned_spectral_transition.Magnetization_linkage_ID (MagnetizationLinkageID)

(go to parent tag category listing)

NMR-STAR tag name	_Assigned_spectral_transition.Magnetization_linkage_ID
Description	NMR-STAR name: _Assigned_spectral_transition.Magnetization_linkage_ID Magnetization linkage ID
Database field name	MagnetizationLinkageID
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	Magnetization linkage ID
Examples	?
Help text

_Assigned_spectral_transition.Assembly_atom_ID (AssemblyAtomID)

(go to parent tag category listing)

NMR-STAR tag name	_Assigned_spectral_transition.Assembly_atom_ID
Description	NMR-STAR name: _Assigned_spectral_transition.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	Assembly atom ID
Examples	?
Help text

_Assigned_spectral_transition.Val (Val)

(go to parent tag category listing)

NMR-STAR tag name	_Assigned_spectral_transition.Val
Description	NMR-STAR name: _Assigned_spectral_transition.Val The quantitative chemical shift value assigned to the peak.
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?	no
Prompt	Val
Examples	?
Help text

_Assigned_spectral_transition.Assigned_chem_shift_list_ID (AssignedChemShiftListID)

(go to parent tag category listing)

NMR-STAR tag name	_Assigned_spectral_transition.Assigned_chem_shift_list_ID
Description	NMR-STAR name: _Assigned_spectral_transition.Assigned_chem_shift_list_ID Pointer to '_Assigned_chem_shift_list.ID'
Database field name	AssignedChemShiftListID
SQL Database type	INTEGER
Part of primary Key	no
Foreign Key on table, column	Assigned_chem_shift_list, ID
Saveframe ID	no
Row Index	no
Secondary Index	no
Internal Flag	no
Nulls allowed in database?	no
Prompt	Assigned chem shift list ID
Examples	?
Help text

_Assigned_spectral_transition.Atom_chem_shift_ID (AtomChemShiftID)

(go to parent tag category listing)

NMR-STAR tag name	_Assigned_spectral_transition.Atom_chem_shift_ID
Description	NMR-STAR name: _Assigned_spectral_transition.Atom_chem_shift_ID Pointer to '_Atom_chem_shift.ID'
Database field name	AtomChemShiftID
SQL Database type	INTEGER
Part of primary Key	no
Foreign Key on table, column	Atom_chem_shift, ID
Saveframe ID	no
Row Index	no
Secondary Index	no
Internal Flag	no
Nulls allowed in database?	no
Prompt	Atom chem shift ID
Examples	?
Help text

_Assigned_spectral_transition.Entity_assembly_ID (EntityAssemblyID)

(go to parent tag category listing)

NMR-STAR tag name	_Assigned_spectral_transition.Entity_assembly_ID
Description	NMR-STAR name: _Assigned_spectral_transition.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?	no
Prompt	Entity assembly ID
Examples	?
Help text

_Assigned_spectral_transition.Entity_ID (EntityID)

(go to parent tag category listing)

NMR-STAR tag name	_Assigned_spectral_transition.Entity_ID
Description	NMR-STAR name: _Assigned_spectral_transition.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?	no
Prompt	Entity ID
Examples	?
Help text

_Assigned_spectral_transition.Comp_index_ID (CompIndexID)

(go to parent tag category listing)

NMR-STAR tag name	_Assigned_spectral_transition.Comp_index_ID
Description	NMR-STAR name: _Assigned_spectral_transition.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?	no
Prompt	Comp index ID
Examples	?
Help text

_Assigned_spectral_transition.Comp_ID (CompID)

(go to parent tag category listing)

NMR-STAR tag name	_Assigned_spectral_transition.Comp_ID
Description	NMR-STAR name: _Assigned_spectral_transition.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?	no
Prompt	Comp ID
Examples	?
Help text

_Assigned_spectral_transition.Atom_ID (AtomID)

(go to parent tag category listing)

NMR-STAR tag name	_Assigned_spectral_transition.Atom_ID
Description	NMR-STAR name: _Assigned_spectral_transition.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?	no
Prompt	Atom ID
Examples	?
Help text

_Assigned_spectral_transition.Figure_of_merit (FigureOfMerit)

(go to parent tag category listing)

NMR-STAR tag name	_Assigned_spectral_transition.Figure_of_merit
Description	NMR-STAR name: _Assigned_spectral_transition.Figure_of_merit A value that indicates the certainty of the assignment of the peak to the specified atom.
Database field name	FigureOfMerit
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	Figure of merit
Examples	?
Help text

_Assigned_spectral_transition.Resonance_ID (ResonanceID)

(go to parent tag category listing)

NMR-STAR tag name	_Assigned_spectral_transition.Resonance_ID
Description	NMR-STAR name: _Assigned_spectral_transition.Resonance_ID Pointer to '_Resonance.ID'
Database field name	ResonanceID
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
Examples	?
Help text

_Assigned_spectral_transition.Details (Details)

(go to parent tag category listing)

NMR-STAR tag name	_Assigned_spectral_transition.Details
Description	NMR-STAR name: _Assigned_spectral_transition.Details Text describing the reported spectral peak assignment.
Database field name	Details
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
Examples	?
Help text

_Assigned_spectral_transition.Sf_ID (SfID)

(go to parent tag category listing)

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

_Assigned_spectral_transition.Entry_ID (EntryID)

(go to parent tag category listing)

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

_Assigned_spectral_transition.Spectral_peak_list_ID (SpectralPeakListID)

(go to parent tag category listing)

NMR-STAR tag name	_Assigned_spectral_transition.Spectral_peak_list_ID
Description	NMR-STAR name: _Assigned_spectral_transition.Spectral_peak_list_ID Pointer to '_Spectral_peak_list.ID'
Database field name	SpectralPeakListID
SQL Database type	INTEGER
Part of primary Key	yes
Foreign Key on table, column	Spectral_peak_list, ID
Saveframe ID	no
Row Index	no
Secondary Index	no
Internal Flag	no
Nulls allowed in database?	yes
Prompt	Spectral peak list ID
Examples	?
Help text