NMR-STAR dictionary: database table: ChemCompTor

Detailed description of the fields

_Chem_comp_tor.ID (ChemCompTorID)

(go to parent tag category listing)
NMR-STAR tag name_Chem_comp_tor.ID 
DescriptionNMR-STAR name: _Chem_comp_tor.ID
The value of _chem_comp_tor.id must uniquely identify a record in the Chem_comp_tor list.  
Database field nameChemCompTorID 
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 
PromptID  
Examples
Help text 

_Chem_comp_tor.Atom_ID_1 (AtomID1)

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

_Chem_comp_tor.Atom_ID_2 (AtomID2)

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

_Chem_comp_tor.Atom_ID_3 (AtomID3)

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

_Chem_comp_tor.Atom_ID_4 (AtomID4)

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

_Chem_comp_tor.Details (Details)

(go to parent tag category listing)
NMR-STAR tag name_Chem_comp_tor.Details 
DescriptionNMR-STAR name: _Chem_comp_tor.Details
A text description of the torsion angle.  
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 

_Chem_comp_tor.Sf_ID (SfID)

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

_Chem_comp_tor.Entry_ID (EntryID)

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

_Chem_comp_tor.Comp_ID (CompID)

(go to parent tag category listing)
NMR-STAR tag name_Chem_comp_tor.Comp_ID 
DescriptionNMR-STAR name: _Chem_comp_tor.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