NMR-STAR dictionary: database table: Peak

Detailed description of the fields

_Peak.ID (PeakID)

(go to parent tag category listing)
NMR-STAR tag name_Peak.ID 
DescriptionNMR-STAR name: _Peak.ID
Unique identifier for the spectral peak.  
Database field namePeakID 
SQL Database typeINTEGER 
Part of primary Keyyes 
Foreign Key on table, column,  
Saveframe ID yes: This tag contains the identifier for this saveframe in the entry. 
Row Indexyes: 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 Indexno 
Internal Flagno 
Nulls allowed in database?yes 
PromptPeak ID  
Examples
Help text 

_Peak.Figure_of_merit (FigureOfMerit)

(go to parent tag category listing)
NMR-STAR tag name_Peak.Figure_of_merit 
DescriptionNMR-STAR name: _Peak.Figure_of_merit
A quantitative or qualitative value that provides a measure of certainty that the peak listed represents a real piece of data.  
Database field nameFigureOfMerit 
SQL Database typeFLOAT 
Part of primary Keyno 
Foreign Key on table, column,  
Saveframe ID no 
Row Indexno 
Secondary Indexno 
Internal Flagno 
Nulls allowed in database?no 
PromptFigure of merit  
Examples
Help text 

_Peak.Details (Details)

(go to parent tag category listing)
NMR-STAR tag name_Peak.Details 
DescriptionNMR-STAR name: _Peak.Details
Text providing additional information regarding the spectral peak.  
Database field nameDetails 
SQL Database typeVARCHAR(127) 
Part of primary Keyno 
Foreign Key on table, column,  
Saveframe ID no 
Row Indexno 
Secondary Indexno 
Internal Flagno 
Nulls allowed in database?no 
PromptDetails  
Examples
Help text 

_Peak.Sf_ID (SfID)

(go to parent tag category listing)
NMR-STAR tag name_Peak.Sf_ID 
DescriptionNMR-STAR name: _Peak.Sf_ID
Pointer to '_Spectral_peak_list.Sf_ID'  
Database field nameSfID 
SQL Database typeINTEGER 
Part of primary Keyno 
Foreign Key on table, columnSpectral_peak_list, Sf_ID 
Saveframe ID no 
Row Indexno 
Secondary Indexno 
Internal Flagyes
This field's data is for internal use only and should be hidden in public versiond of the data. 
Nulls allowed in database?yes 
PromptSf ID  
Examples
Help text 

_Peak.Entry_ID (EntryID)

(go to parent tag category listing)
NMR-STAR tag name_Peak.Entry_ID 
DescriptionNMR-STAR name: _Peak.Entry_ID
Pointer to '_Entry.ID'  
Database field nameEntryID 
SQL Database typeCHAR(12) 
Part of primary Keyyes 
Foreign Key on table, columnSpectral_peak_list, Entry_ID 
Saveframe ID no 
Row Indexno 
Secondary Indexno 
Internal Flagno 
Nulls allowed in database?yes 
PromptEntry ID  
Examples
Help text 

_Peak.Spectral_peak_list_ID (SpectralPeakListID)

(go to parent tag category listing)
NMR-STAR tag name_Peak.Spectral_peak_list_ID 
DescriptionNMR-STAR name: _Peak.Spectral_peak_list_ID
Pointer to '_Spectral_peak_list.ID'  
Database field nameSpectralPeakListID 
SQL Database typeINTEGER 
Part of primary Keyyes 
Foreign Key on table, columnSpectral_peak_list, ID 
Saveframe ID no 
Row Indexno 
Secondary Indexno 
Internal Flagno 
Nulls allowed in database?yes 
PromptSpectral peak list ID  
Examples
Help text