NMR-STAR dictionary: database table: AmbiguousAtomChemShift

Detailed description of the fields

_Ambiguous_atom_chem_shift.Ambiguous_shift_set_ID (AmbiguousShiftSetID)

(go to parent tag category listing)
NMR-STAR tag name_Ambiguous_atom_chem_shift.Ambiguous_shift_set_ID 
DescriptionNMR-STAR name: _Ambiguous_atom_chem_shift.Ambiguous_shift_set_ID
An integer value that defines a set of chemical shifts that form a mutually ambiguous group. For ambiguity codes of 4 or 5, various combinations of assigned chemical shifts may form sets where the chemical shift assignments are not specifically known, but it is known that the chemical shifts belong to one atom in the set.  
Database field nameAmbiguousShiftSetID 
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 
PromptShift set ID  
Examples
Help text 

_Ambiguous_atom_chem_shift.Atom_chem_shift_ID (AtomChemShiftID)

(go to parent tag category listing)
NMR-STAR tag name_Ambiguous_atom_chem_shift.Atom_chem_shift_ID 
DescriptionNMR-STAR name: _Ambiguous_atom_chem_shift.Atom_chem_shift_ID
Pointer to '_Atom_chem_shift.ID'  
Database field nameAtomChemShiftID 
SQL Database typeINTEGER 
Part of primary Keyno 
Foreign Key on table, columnAtom_chem_shift, ID 
Saveframe ID no 
Row Indexno 
Secondary Indexno 
Internal Flagno 
Nulls allowed in database?yes 
PromptAtom chem shift ID  
Examples
Help text 

_Ambiguous_atom_chem_shift.Sf_ID (SfID)

(go to parent tag category listing)
NMR-STAR tag name_Ambiguous_atom_chem_shift.Sf_ID 
DescriptionNMR-STAR name: _Ambiguous_atom_chem_shift.Sf_ID
Pointer to '_Assigned_chem_shift_list.Sf_ID'  
Database field nameSfID 
SQL Database typeINTEGER 
Part of primary Keyno 
Foreign Key on table, columnAssigned_chem_shift_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 

_Ambiguous_atom_chem_shift.Entry_ID (EntryID)

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

_Ambiguous_atom_chem_shift.Assigned_chem_shift_list_ID (AssignedChemShiftListID)

(go to parent tag category listing)
NMR-STAR tag name_Ambiguous_atom_chem_shift.Assigned_chem_shift_list_ID 
DescriptionNMR-STAR name: _Ambiguous_atom_chem_shift.Assigned_chem_shift_list_ID
Pointer to '_Assigned_chem_shift_list.ID'  
Database field nameAssignedChemShiftListID 
SQL Database typeINTEGER 
Part of primary Keyyes 
Foreign Key on table, columnAssigned_chem_shift_list, ID 
Saveframe ID no 
Row Indexno 
Secondary Indexno 
Internal Flagno 
Nulls allowed in database?yes 
PromptAssigned chemical shifts ID  
Examples
Help text