NMR-STAR dictionary: database table: ChemShiftReference

Detailed description of the fields

_Chem_shift_reference.Sf_category (SfCategory)

(go to parent tag category listing)
NMR-STAR tag name_Chem_shift_reference.Sf_category 
DescriptionNMR-STAR name: _Chem_shift_reference.Sf_category
Category assigned to the information in the saveframe.  
Database field nameSfCategory 
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?yes 
PromptChem shift reference label  
Examples
Help text 

_Chem_shift_reference.Sf_framecode (SfFramecode)

(go to parent tag category listing)
NMR-STAR tag name_Chem_shift_reference.Sf_framecode 
DescriptionNMR-STAR name: _Chem_shift_reference.Sf_framecode
A descriptive label that uniquely identifies this list of chemical shift referencing parameters used in reporting assigned chemical shifts and other chemical shift data.  
Database field nameSfFramecode 
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?yes 
PromptChemical shift reference set label  
Examples
Help text 

_Chem_shift_reference.Entry_ID (EntryID)

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

_Chem_shift_reference.Sf_ID (SfID)

(go to parent tag category listing)
NMR-STAR tag name_Chem_shift_reference.Sf_ID 
DescriptionNMR-STAR name: _Chem_shift_reference.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 nameSfID 
SQL Database typeINTEGER 
Part of primary Keyno 
Foreign Key on table, column,  
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 

_Chem_shift_reference.ID (ChemShiftReferenceID)

(go to parent tag category listing)
NMR-STAR tag name_Chem_shift_reference.ID 
DescriptionNMR-STAR name: _Chem_shift_reference.ID
An integer value that uniquely identifies this saveframe of chemical shift reference values from other saveframes of this category in an entry.  
Database field nameChemShiftReferenceID 
SQL Database typeINTEGER 
Part of primary Keyyes 
Foreign Key on table, column,  
Saveframe ID no 
Row Indexno 
Secondary Indexno 
Internal Flagno 
Nulls allowed in database?yes 
PromptChem shift ref ID  
Examples
Help text 

_Chem_shift_reference.Proton_shifts_flag (ProtonShiftsFlag)

(go to parent tag category listing)
NMR-STAR tag name_Chem_shift_reference.Proton_shifts_flag 
DescriptionNMR-STAR name: _Chem_shift_reference.Proton_shifts_flag
Please indicate if you are depositing 1H chemical shifts by selecting one of the three options. If you have used the IUPAC recommend method for referencing 1H chemical shifts (DSS was used as the standard), then select the 'yes with IUPAC referencing' option. After clicking on the 'Save Changes' button, the fields for the 1H chemical shift referencing will be automatically filled in with the appropriate values.  
Database field nameProtonShiftsFlag 
SQL Database typeVARCHAR(31) 
Part of primary Keyno 
Foreign Key on table, column,  
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?no 
Enumerations[click for a list of enumerations]
This is a closed enumeration. The list of values are the only ones allowed. 
Prompt1H chemical shifts deposited  
Examples
Help text 

_Chem_shift_reference.Carbon_shifts_flag (CarbonShiftsFlag)

(go to parent tag category listing)
NMR-STAR tag name_Chem_shift_reference.Carbon_shifts_flag 
DescriptionNMR-STAR name: _Chem_shift_reference.Carbon_shifts_flag
Please indicate if you are depositing 13C chemical shifts. If you have used the IUPAC recommend method for referencing 13C chemical shifts (DSS was used as the standard and the correct 1H/13C ratio), then select the 'yes with IUPAC referencing' option. After clicking on the 'Save Changes' button, the fields for the 13C chemical shift referencing will be automatically filled in with the appropriate values.  
Database field nameCarbonShiftsFlag 
SQL Database typeVARCHAR(31) 
Part of primary Keyno 
Foreign Key on table, column,  
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?no 
Enumerations[click for a list of enumerations]
This is a closed enumeration. The list of values are the only ones allowed. 
Prompt13C chemcial shifts deposited  
Examples
Help text 

_Chem_shift_reference.Nitrogen_shifts_flag (NitrogenShiftsFlag)

(go to parent tag category listing)
NMR-STAR tag name_Chem_shift_reference.Nitrogen_shifts_flag 
DescriptionNMR-STAR name: _Chem_shift_reference.Nitrogen_shifts_flag
Please indicate if you are depositing 15N chemical shifts. If you have used the IUPAC recommend method for referencing 15N chemical shifts (DSS was used as the standard and the correct 1H/15N ratio), then select the 'yes with IUPAC referencing' option. After clicking on the 'Save Changes' button, the fields for the 15N chemical shift referencing will be automatically filled in with the appropriate values.  
Database field nameNitrogenShiftsFlag 
SQL Database typeVARCHAR(31) 
Part of primary Keyno 
Foreign Key on table, column,  
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?no 
Enumerations[click for a list of enumerations]
This is a closed enumeration. The list of values are the only ones allowed. 
Prompt15N chemical shifts deposited  
Examples
Help text 

_Chem_shift_reference.Phosphorus_shifts_flag (PhosphorusShiftsFlag)

(go to parent tag category listing)
NMR-STAR tag name_Chem_shift_reference.Phosphorus_shifts_flag 
DescriptionNMR-STAR name: _Chem_shift_reference.Phosphorus_shifts_flag
Please indicate if you are depositing 31P chemical shifts. If you have used the IUPAC recommend method for referencing 31P chemical shifts (DSS was used as the standard and the correct 1H/31P ratio), then select the 'yes with IUPAC referencing' option. After clicking on the 'Save Changes' button, the fields for the 31P chemical shift referencing will be automatically filled in with the appropriate values.  
Database field namePhosphorusShiftsFlag 
SQL Database typeVARCHAR(31) 
Part of primary Keyno 
Foreign Key on table, column,  
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?no 
Enumerations[click for a list of enumerations]
This is a closed enumeration. The list of values are the only ones allowed. 
Prompt31P chemical shifts deposited  
Examples
Help text 

_Chem_shift_reference.Other_shifts_flag (OtherShiftsFlag)

(go to parent tag category listing)
NMR-STAR tag name_Chem_shift_reference.Other_shifts_flag 
DescriptionNMR-STAR name: _Chem_shift_reference.Other_shifts_flag
If you are depositing chemical shifts for a nuclei other than 1H, 13C, 15N, or 31P, select the 'yes' option otherwise select the 'no' option.  
Database field nameOtherShiftsFlag 
SQL Database typeVARCHAR(31) 
Part of primary Keyno 
Foreign Key on table, column,  
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?no 
Enumerations[click for a list of enumerations]
This is a closed enumeration. The list of values are the only ones allowed. 
PromptOther nuclei chemical shifts deposited  
Examples
Help text 

_Chem_shift_reference.Details (Details)

(go to parent tag category listing)
NMR-STAR tag name_Chem_shift_reference.Details 
DescriptionNMR-STAR name: _Chem_shift_reference.Details
Text providing additional information regarding the reported chemical shift referencing values or methods.  
Database field nameDetails 
SQL Database typeTEXT 
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