NMR-STAR dictionary: detail of HeteronuclNOEList table

NMR-STAR dictionary: database table: HeteronuclNOEList

Detailed description of the fields

_Heteronucl_NOE_list.Sf_category (SfCategory)

(go to parent tag category listing)

NMR-STAR tag name	_Heteronucl_NOE_list.Sf_category
Description	NMR-STAR name: _Heteronucl_NOE_list.Sf_category Category definition for the information content of 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

_Heteronucl_NOE_list.Sf_framecode (SfFramecode)

(go to parent tag category listing)

NMR-STAR tag name	_Heteronucl_NOE_list.Sf_framecode
Description	NMR-STAR name: _Heteronucl_NOE_list.Sf_framecode A label for the saveframe that describes in very brief terms the information contained in the saveframe.
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	Heteronuclear NOE list label
Examples	?
Help text

_Heteronucl_NOE_list.Entry_ID (EntryID)

(go to parent tag category listing)

NMR-STAR tag name	_Heteronucl_NOE_list.Entry_ID
Description	NMR-STAR name: _Heteronucl_NOE_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	3456
Help text

_Heteronucl_NOE_list.Sf_ID (SfID)

(go to parent tag category listing)

NMR-STAR tag name	_Heteronucl_NOE_list.Sf_ID
Description	NMR-STAR name: _Heteronucl_NOE_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	1
Help text

_Heteronucl_NOE_list.ID (HeteronuclNOEListID)

(go to parent tag category listing)

NMR-STAR tag name	_Heteronucl_NOE_list.ID
Description	NMR-STAR name: _Heteronucl_NOE_list.ID An integer value that uniquely identifies this saveframe of heteronuclear NOE data from other saveframes of this category in an entry.
Database field name	HeteronuclNOEListID
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	1
Help text

_Heteronucl_NOE_list.Data_file_name (DataFileName)

(go to parent tag category listing)

NMR-STAR tag name	_Heteronucl_NOE_list.Data_file_name
Description	NMR-STAR name: _Heteronucl_NOE_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	HN_hetnoe.tbl
Help text

_Heteronucl_NOE_list.Sample_condition_list_ID (SampleConditionListID)

(go to parent tag category listing)

NMR-STAR tag name	_Heteronucl_NOE_list.Sample_condition_list_ID
Description	NMR-STAR name: _Heteronucl_NOE_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 conditions ID
Examples	1
Help text

_Heteronucl_NOE_list.Sample_condition_list_label (SampleConditionListLabel)

(go to parent tag category listing)

NMR-STAR tag name	_Heteronucl_NOE_list.Sample_condition_list_label
Description	NMR-STAR name: _Heteronucl_NOE_list.Sample_condition_list_label Pointer to a saveframe of the 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?	yes
Prompt	Sample conditions label
Examples	sample_conditions_1
Help text

_Heteronucl_NOE_list.Spectrometer_frequency_1H (SpectrometerFrequency1H)

(go to parent tag category listing)

NMR-STAR tag name	_Heteronucl_NOE_list.Spectrometer_frequency_1H
Description	NMR-STAR name: _Heteronucl_NOE_list.Spectrometer_frequency_1H Operating frequency of the spectrometer used to collect the heteronuclear NOE data reported as the 1H frequency in MHz.
Database field name	SpectrometerFrequency1H
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	Spectrometer frequency 1H
Examples	600 MHz
Help text

_Heteronucl_NOE_list.Heteronuclear_NOE_val_type (HeteronuclearNOEValType)

(go to parent tag category listing)

NMR-STAR tag name	_Heteronucl_NOE_list.Heteronuclear_NOE_val_type
Description	NMR-STAR name: _Heteronucl_NOE_list.Heteronuclear_NOE_val_type A keyword that defines the type of value reported as the heteronuclear NOE.
Database field name	HeteronuclearNOEValType
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?	yes
Enumerations	[click for a list of enumerations] This is an open enumeration. The list of values are only suggestions. They are not enforced.
Prompt	Heteronuclear NOE val type
Examples	peak height; peak integral; contour count; relative intensities
Help text

_Heteronucl_NOE_list.NOE_ref_val (NOERefVal)

(go to parent tag category listing)

NMR-STAR tag name	_Heteronucl_NOE_list.NOE_ref_val
Description	NMR-STAR name: _Heteronucl_NOE_list.NOE_ref_val Value used to calibrate other NOE measurements
Database field name	NOERefVal
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	NOE ref val
Examples	2.00E+07
Help text

_Heteronucl_NOE_list.NOE_ref_description (NOERefDescription)

(go to parent tag category listing)

NMR-STAR tag name	_Heteronucl_NOE_list.NOE_ref_description
Description	NMR-STAR name: _Heteronucl_NOE_list.NOE_ref_description Brief text describing the NOE ref value used and how it was derived.
Database field name	NOERefDescription
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	NOE ref description
Examples	?
Help text

_Heteronucl_NOE_list.Details (Details)

(go to parent tag category listing)

NMR-STAR tag name	_Heteronucl_NOE_list.Details
Description	NMR-STAR name: _Heteronucl_NOE_list.Details Text providing additional information about the data reported.
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

_Heteronucl_NOE_list.Text_data_format (TextDataFormat)

(go to parent tag category listing)

NMR-STAR tag name	_Heteronucl_NOE_list.Text_data_format
Description	NMR-STAR name: _Heteronucl_NOE_list.Text_data_format The data format used to represent the heteronuclear NOE data 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

_Heteronucl_NOE_list.Text_data (TextData)

(go to parent tag category listing)

NMR-STAR tag name	_Heteronucl_NOE_list.Text_data
Description	NMR-STAR name: _Heteronucl_NOE_list.Text_data A set of heteronuclear NOE 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