NMR-STAR dictionary: database table: AtomNomenclature

Detailed description of the fields

_Atom_nomenclature.Atom_ID (AtomID)

(go to parent tag category listing)
NMR-STAR tag name_Atom_nomenclature.Atom_ID 
DescriptionNMR-STAR name: _Atom_nomenclature.Atom_ID
Pointer to '_Chem_comp_atom.Atom_ID'  
Database field nameAtomID 
SQL Database typeCHAR(12) 
Part of primary Keyyes 
Foreign Key on table, columnChem_comp_atom, Atom_ID 
Saveframe ID no 
Row Indexno 
Secondary Indexno 
Internal Flagno 
Nulls allowed in database?yes 
PromptAtom ID  
Examples
Help text 

_Atom_nomenclature.Atom_name (AtomName)

(go to parent tag category listing)
NMR-STAR tag name_Atom_nomenclature.Atom_name 
DescriptionNMR-STAR name: _Atom_nomenclature.Atom_name
Alternate atom name defined by an organization or official body.  
Database field nameAtomName 
SQL Database typeVARCHAR(15) 
Part of primary Keyno 
Foreign Key on table, column,  
Saveframe ID no 
Row Indexno 
Secondary Indexno 
Internal Flagno 
Nulls allowed in database?yes 
PromptNaming system atom name  
Examples
Help text 

_Atom_nomenclature.Naming_system (NamingSystem)

(go to parent tag category listing)
NMR-STAR tag name_Atom_nomenclature.Naming_system 
DescriptionNMR-STAR name: _Atom_nomenclature.Naming_system
The name of the systematic atom nomenclature.  
Database field nameNamingSystem 
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 
PromptNaming system  
Examples
Help text 

_Atom_nomenclature.Sf_ID (SfID)

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

_Atom_nomenclature.Entry_ID (EntryID)

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

_Atom_nomenclature.Comp_ID (CompID)

(go to parent tag category listing)
NMR-STAR tag name_Atom_nomenclature.Comp_ID 
DescriptionNMR-STAR name: _Atom_nomenclature.Comp_ID
Pointer to '_Chem_comp.ID'  
Database field nameCompID 
SQL Database typeCHAR(12) 
Part of primary Keyyes 
Foreign Key on table, columnChem_comp, ID 
Saveframe ID no 
Row Indexno 
Secondary Indexno 
Internal Flagno 
Nulls allowed in database?yes 
PromptComp ID  
Examples
Help text