NMR-STAR dictionary: database table: SpectralTransitionGeneralChar

Detailed description of the fields

_Spectral_transition_general_char.Spectral_transition_ID (SpectralTransitionID)

(go to parent tag category listing)
NMR-STAR tag name_Spectral_transition_general_char.Spectral_transition_ID 
DescriptionNMR-STAR name: _Spectral_transition_general_char.Spectral_transition_ID
Pointer to '_Peak.ID'  
Database field nameSpectralTransitionID 
SQL Database typeINTEGER 
Part of primary Keyyes 
Foreign Key on table, columnPeak, ID 
Saveframe ID no 
Row Indexno 
Secondary Indexno 
Internal Flagno 
Nulls allowed in database?yes 
PromptPeak ID  
Examples
Help text 

_Spectral_transition_general_char.Intensity_val (IntensityVal)

(go to parent tag category listing)
NMR-STAR tag name_Spectral_transition_general_char.Intensity_val 
DescriptionNMR-STAR name: _Spectral_transition_general_char.Intensity_val
Value for the intensity of the peak.  
Database field nameIntensityVal 
SQL Database typeFLOAT 
Part of primary Keyyes 
Foreign Key on table, column,  
Saveframe ID no 
Row Indexno 
Secondary Indexno 
Internal Flagno 
Nulls allowed in database?yes 
PromptIntensity val  
Examples
Help text 

_Spectral_transition_general_char.Intensity_val_err (IntensityValErr)

(go to parent tag category listing)
NMR-STAR tag name_Spectral_transition_general_char.Intensity_val_err 
DescriptionNMR-STAR name: _Spectral_transition_general_char.Intensity_val_err
Error in the value for the intensity of the peak.  
Database field nameIntensityValErr 
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 
PromptIntensity err  
Examples
Help text 

_Spectral_transition_general_char.Measurement_method (MeasurementMethod)

(go to parent tag category listing)
NMR-STAR tag name_Spectral_transition_general_char.Measurement_method 
DescriptionNMR-STAR name: _Spectral_transition_general_char.Measurement_method
Enter the method used to measure the intensities of the reported peaks.  
Database field nameMeasurementMethod 
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 
Enumerations[click for a list of enumerations]
This is an open enumeration. The list of values are only suggestions. They are not enforced. 
PromptIntensity measure method  
Examplesheight  
Help text 

_Spectral_transition_general_char.Sf_ID (SfID)

(go to parent tag category listing)
NMR-STAR tag name_Spectral_transition_general_char.Sf_ID 
DescriptionNMR-STAR name: _Spectral_transition_general_char.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 

_Spectral_transition_general_char.Entry_ID (EntryID)

(go to parent tag category listing)
NMR-STAR tag name_Spectral_transition_general_char.Entry_ID 
DescriptionNMR-STAR name: _Spectral_transition_general_char.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 

_Spectral_transition_general_char.Spectral_peak_list_ID (SpectralPeakListID)

(go to parent tag category listing)
NMR-STAR tag name_Spectral_transition_general_char.Spectral_peak_list_ID 
DescriptionNMR-STAR name: _Spectral_transition_general_char.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