NMR-STAR dictionary: detail of AssignedChemShiftList table

NMR-STAR dictionary: database table: AssignedChemShiftList

Detailed description of the fields

_Assigned_chem_shift_list.Sf_category (SfCategory)

(go to parent tag category listing)

NMR-STAR tag name	_Assigned_chem_shift_list.Sf_category
Description	NMR-STAR name: _Assigned_chem_shift_list.Sf_category Category assigned to the information in the saveframe.
Database field name	SfCategory
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	Sf category
Examples	?
Help text

_Assigned_chem_shift_list.Sf_framecode (SfFramecode)

(go to parent tag category listing)

NMR-STAR tag name	_Assigned_chem_shift_list.Sf_framecode
Description	NMR-STAR name: _Assigned_chem_shift_list.Sf_framecode A descriptive label that uniquely identifies this list of reported assigned chemical shifts.
Database field name	SfFramecode
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	Assigned chemical shift list label
Examples	?
Help text

_Assigned_chem_shift_list.Entry_ID (EntryID)

(go to parent tag category listing)

NMR-STAR tag name	_Assigned_chem_shift_list.Entry_ID
Description	NMR-STAR name: _Assigned_chem_shift_list.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	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_chem_shift_list.Sf_ID (SfID)

(go to parent tag category listing)

NMR-STAR tag name	_Assigned_chem_shift_list.Sf_ID
Description	NMR-STAR name: _Assigned_chem_shift_list.Sf_ID An integer value that is the unique identifier for the saveframe that applies across the archive. This value is not stable and may be reassigned each time the data are loaded into a database system.
Database field name	SfID
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	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_chem_shift_list.ID (AssignedChemShiftListID)

(go to parent tag category listing)

NMR-STAR tag name	_Assigned_chem_shift_list.ID
Description	NMR-STAR name: _Assigned_chem_shift_list.ID An integer value that uniquely identifies this saveframe of assigned chemical shifts from other saveframes of this category in an entry.
Database field name	AssignedChemShiftListID
SQL Database type	INTEGER
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	ID
Examples	?
Help text

_Assigned_chem_shift_list.Data_file_name (DataFileName)

(go to parent tag category listing)

NMR-STAR tag name	_Assigned_chem_shift_list.Data_file_name
Description	NMR-STAR name: _Assigned_chem_shift_list.Data_file_name The name of the file submitted with this depostion that contains the quantitative data for this saveframe.
Database field name	DataFileName
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	Deposited data file name
Examples	?
Help text

_Assigned_chem_shift_list.Sample_condition_list_ID (SampleConditionListID)

(go to parent tag category listing)

NMR-STAR tag name	_Assigned_chem_shift_list.Sample_condition_list_ID
Description	NMR-STAR name: _Assigned_chem_shift_list.Sample_condition_list_ID Pointer to '_Sample_condition_list.ID'
Database field name	SampleConditionListID
SQL Database type	INTEGER
Part of primary Key	no
Foreign Key on table, column	Sample_condition_list, ID
Saveframe ID	no
Row Index	no
Secondary Index	no
Internal Flag	no
Nulls allowed in database?	yes
Prompt	Sample condition list ID
Examples	?
Help text

_Assigned_chem_shift_list.Sample_condition_list_label (SampleConditionListLabel)

(go to parent tag category listing)

NMR-STAR tag name	_Assigned_chem_shift_list.Sample_condition_list_label
Description	NMR-STAR name: _Assigned_chem_shift_list.Sample_condition_list_label Pointer to a saveframe of category sample_conditions.
Database field name	SampleConditionListLabel
SQL Database type	VARCHAR(127)
Part of primary Key	no
Foreign Key on table, column	Sample_condition_list, Sf_framecode
Saveframe ID	no
Row Index	no
Secondary Index	no
Internal Flag	no
Nulls allowed in database?	no
Prompt	Sample conditions label
Examples	?
Help text

_Assigned_chem_shift_list.Chem_shift_reference_ID (ChemShiftReferenceID)

(go to parent tag category listing)

NMR-STAR tag name	_Assigned_chem_shift_list.Chem_shift_reference_ID
Description	NMR-STAR name: _Assigned_chem_shift_list.Chem_shift_reference_ID Pointer to '_Chem_shift_reference.ID'
Database field name	ChemShiftReferenceID
SQL Database type	INTEGER
Part of primary Key	no
Foreign Key on table, column	Chem_shift_reference, ID
Saveframe ID	no
Row Index	no
Secondary Index	no
Internal Flag	no
Nulls allowed in database?	yes
Prompt	Chem shift reference ID
Examples	?
Help text

_Assigned_chem_shift_list.Chem_shift_reference_label (ChemShiftReferenceLabel)

(go to parent tag category listing)

NMR-STAR tag name	_Assigned_chem_shift_list.Chem_shift_reference_label
Description	NMR-STAR name: _Assigned_chem_shift_list.Chem_shift_reference_label Pointer to a saveframe of category chem_shift_reference.
Database field name	ChemShiftReferenceLabel
SQL Database type	VARCHAR(127)
Part of primary Key	no
Foreign Key on table, column	Chem_shift_reference, Sf_framecode
Saveframe ID	no
Row Index	no
Secondary Index	no
Internal Flag	no
Nulls allowed in database?	no
Prompt	Chem shift reference label
Examples	?
Help text

_Assigned_chem_shift_list.Chem_shift_1H_err (ChemShift1HErr)

(go to parent tag category listing)

NMR-STAR tag name	_Assigned_chem_shift_list.Chem_shift_1H_err
Description	NMR-STAR name: _Assigned_chem_shift_list.Chem_shift_1H_err The value assigned as the error for all 1H chemical shifts reported in the saveframe. The value reported for this tag will be inserted during annotation into the assigned chemical shift error column in the table of assigned chemical shifts.
Database field name	ChemShift1HErr
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	1H chemical shift error
Examples	0.01
Help text

_Assigned_chem_shift_list.Chem_shift_13C_err (ChemShift13CErr)

(go to parent tag category listing)

NMR-STAR tag name	_Assigned_chem_shift_list.Chem_shift_13C_err
Description	NMR-STAR name: _Assigned_chem_shift_list.Chem_shift_13C_err The value assigned as the error for all 13C chemical shifts reported in the saveframe. The value reported for this tag will be inserted during annotation into the assigned chemical shift error column in the table of assigned chemical shifts.
Database field name	ChemShift13CErr
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	13C chemical shift error
Examples	0.1
Help text

_Assigned_chem_shift_list.Chem_shift_15N_err (ChemShift15NErr)

(go to parent tag category listing)

NMR-STAR tag name	_Assigned_chem_shift_list.Chem_shift_15N_err
Description	NMR-STAR name: _Assigned_chem_shift_list.Chem_shift_15N_err The value assigned as the error for all 15N chemical shifts reported in the saveframe. The value reported for this tag will be inserted during annotation into the assigned chemical shift error column in the table of assigned chemical shifts.
Database field name	ChemShift15NErr
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	15N chemical shift error
Examples	0.2
Help text

_Assigned_chem_shift_list.Chem_shift_31P_err (ChemShift31PErr)

(go to parent tag category listing)

NMR-STAR tag name	_Assigned_chem_shift_list.Chem_shift_31P_err
Description	NMR-STAR name: _Assigned_chem_shift_list.Chem_shift_31P_err The value assigned as the error for all 31P chemical shifts reported in the saveframe. The value reported for this tag will be inserted during annotation into the assigned chemical shift error column in the table of assigned chemical shifts.
Database field name	ChemShift31PErr
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	31P chemical shift error
Examples	0.1
Help text

_Assigned_chem_shift_list.Chem_shift_2H_err (ChemShift2HErr)

(go to parent tag category listing)

NMR-STAR tag name	_Assigned_chem_shift_list.Chem_shift_2H_err
Description	NMR-STAR name: _Assigned_chem_shift_list.Chem_shift_2H_err The value assigned as the error for all 2H chemical shifts reported in the saveframe. The value reported for this tag will be inserted during annotation into the assigned chemical shift error column in the table of assigned chemical shifts.
Database field name	ChemShift2HErr
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	2H chemical shift error
Examples	0.01
Help text

_Assigned_chem_shift_list.Chem_shift_19F_err (ChemShift19FErr)

(go to parent tag category listing)

NMR-STAR tag name	_Assigned_chem_shift_list.Chem_shift_19F_err
Description	NMR-STAR name: _Assigned_chem_shift_list.Chem_shift_19F_err The value assigned as the error for all 19F chemical shifts reported in the saveframe. The value reported for this tag will be inserted during annotation into the assigned chemical shift error column in the table of assigned chemical shifts.
Database field name	ChemShift19FErr
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	19F chemical shift error
Examples	0.01
Help text

_Assigned_chem_shift_list.Error_derivation_method (ErrorDerivationMethod)

(go to parent tag category listing)

NMR-STAR tag name	_Assigned_chem_shift_list.Error_derivation_method
Description	NMR-STAR name: _Assigned_chem_shift_list.Error_derivation_method Method used to derive the estimated error in the reported chemical shifts.
Database field name	ErrorDerivationMethod
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	Error derivation method
Examples	?
Help text

_Assigned_chem_shift_list.Details (Details)

(go to parent tag category listing)

NMR-STAR tag name	_Assigned_chem_shift_list.Details
Description	NMR-STAR name: _Assigned_chem_shift_list.Details Text describing the reported assigned chemical shifts.
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_chem_shift_list.Text_data_format (TextDataFormat)

(go to parent tag category listing)

NMR-STAR tag name	_Assigned_chem_shift_list.Text_data_format
Description	NMR-STAR name: _Assigned_chem_shift_list.Text_data_format The data format used to represent the assigned chemical shifts as ASCII text in the text block that is the value to the '_Assigned_chem_shift.Text_data' tag.
Database field name	TextDataFormat
SQL Database type	VARCHAR(31)
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	Text data format
Examples	?
Help text

_Assigned_chem_shift_list.Text_data (TextData)

(go to parent tag category listing)

NMR-STAR tag name	_Assigned_chem_shift_list.Text_data
Description	NMR-STAR name: _Assigned_chem_shift_list.Text_data A set of assigned chemical shift data formatted as ASCII text.
Database field name	TextData
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	Text data
Examples	?
Help text