NMR-STAR dictionary: detail of AssignedPeakChemShift table

NMR-STAR dictionary: database table: AssignedPeakChemShift

Detailed description of the fields

_Assigned_peak_chem_shift.Peak_ID (PeakID)

(go to parent tag category listing)

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

_Assigned_peak_chem_shift.Spectral_dim_ID (SpectralDimID)

(go to parent tag category listing)

NMR-STAR tag name	_Assigned_peak_chem_shift.Spectral_dim_ID
Description	NMR-STAR name: _Assigned_peak_chem_shift.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_peak_chem_shift.Peak_contribution_ID (PeakContributionID)

(go to parent tag category listing)

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

_Assigned_peak_chem_shift.Set_ID (SetID)

(go to parent tag category listing)

NMR-STAR tag name	_Assigned_peak_chem_shift.Set_ID
Description	NMR-STAR name: _Assigned_peak_chem_shift.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_peak_chem_shift.Magnetization_linkage_ID (MagnetizationLinkageID)

(go to parent tag category listing)

NMR-STAR tag name	_Assigned_peak_chem_shift.Magnetization_linkage_ID
Description	NMR-STAR name: _Assigned_peak_chem_shift.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_peak_chem_shift.Assembly_atom_ID (AssemblyAtomID)

(go to parent tag category listing)

NMR-STAR tag name	_Assigned_peak_chem_shift.Assembly_atom_ID
Description	NMR-STAR name: _Assigned_peak_chem_shift.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_peak_chem_shift.Val (Val)

(go to parent tag category listing)

NMR-STAR tag name	_Assigned_peak_chem_shift.Val
Description	NMR-STAR name: _Assigned_peak_chem_shift.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_peak_chem_shift.Figure_of_merit (FigureOfMerit)

(go to parent tag category listing)

NMR-STAR tag name	_Assigned_peak_chem_shift.Figure_of_merit
Description	NMR-STAR name: _Assigned_peak_chem_shift.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_peak_chem_shift.Assigned_chem_shift_list_ID (AssignedChemShiftListID)

(go to parent tag category listing)

NMR-STAR tag name	_Assigned_peak_chem_shift.Assigned_chem_shift_list_ID
Description	NMR-STAR name: _Assigned_peak_chem_shift.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_peak_chem_shift.Atom_chem_shift_ID (AtomChemShiftID)

(go to parent tag category listing)

NMR-STAR tag name	_Assigned_peak_chem_shift.Atom_chem_shift_ID
Description	NMR-STAR name: _Assigned_peak_chem_shift.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_peak_chem_shift.Entity_assembly_ID (EntityAssemblyID)

(go to parent tag category listing)

NMR-STAR tag name	_Assigned_peak_chem_shift.Entity_assembly_ID
Description	NMR-STAR name: _Assigned_peak_chem_shift.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_peak_chem_shift.Entity_ID (EntityID)

(go to parent tag category listing)

NMR-STAR tag name	_Assigned_peak_chem_shift.Entity_ID
Description	NMR-STAR name: _Assigned_peak_chem_shift.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_peak_chem_shift.Comp_index_ID (CompIndexID)

(go to parent tag category listing)

NMR-STAR tag name	_Assigned_peak_chem_shift.Comp_index_ID
Description	NMR-STAR name: _Assigned_peak_chem_shift.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_peak_chem_shift.Comp_ID (CompID)

(go to parent tag category listing)

NMR-STAR tag name	_Assigned_peak_chem_shift.Comp_ID
Description	NMR-STAR name: _Assigned_peak_chem_shift.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_peak_chem_shift.Atom_ID (AtomID)

(go to parent tag category listing)

NMR-STAR tag name	_Assigned_peak_chem_shift.Atom_ID
Description	NMR-STAR name: _Assigned_peak_chem_shift.Atom_ID Pointer to '_Chem_comp_atom.Atom_ID'
Database field name	AtomID
SQL Database type	CHAR(12)
Part of primary Key	yes
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

_Assigned_peak_chem_shift.Resonance_ID (ResonanceID)

(go to parent tag category listing)

NMR-STAR tag name	_Assigned_peak_chem_shift.Resonance_ID
Description	NMR-STAR name: _Assigned_peak_chem_shift.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_peak_chem_shift.Details (Details)

(go to parent tag category listing)

NMR-STAR tag name	_Assigned_peak_chem_shift.Details
Description	NMR-STAR name: _Assigned_peak_chem_shift.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_peak_chem_shift.Sf_ID (SfID)

(go to parent tag category listing)

NMR-STAR tag name	_Assigned_peak_chem_shift.Sf_ID
Description	NMR-STAR name: _Assigned_peak_chem_shift.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_peak_chem_shift.Entry_ID (EntryID)

(go to parent tag category listing)

NMR-STAR tag name	_Assigned_peak_chem_shift.Entry_ID
Description	NMR-STAR name: _Assigned_peak_chem_shift.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_peak_chem_shift.Spectral_peak_list_ID (SpectralPeakListID)

(go to parent tag category listing)

NMR-STAR tag name	_Assigned_peak_chem_shift.Spectral_peak_list_ID
Description	NMR-STAR name: _Assigned_peak_chem_shift.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