NMR-STAR dictionary: database table: ChemCompIdentifier

Detailed description of the fields

_Chem_comp_identifier.Identifier (Identifier)

(go to parent tag category listing)
NMR-STAR tag name_Chem_comp_identifier.Identifier 
DescriptionNMR-STAR name: _Chem_comp_identifier.Identifier
This data item contains the identifier value for this component.  
Database field nameIdentifier 
SQL Database typeVARCHAR(1024) 
Part of primary Keyno 
Foreign Key on table, column,  
Saveframe ID no 
Row Indexno 
Secondary Indexno 
Internal Flagno 
Nulls allowed in database?yes 
PromptIdentifier  
Examples
Help text 

_Chem_comp_identifier.Type (Type)

(go to parent tag category listing)
NMR-STAR tag name_Chem_comp_identifier.Type 
DescriptionNMR-STAR name: _Chem_comp_identifier.Type
This data item contains the identifier type.  
Database field nameType 
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 
Enumerations[click for a list of enumerations]
This is an open enumeration. The list of values are only suggestions. They are not enforced. 
PromptType  
Examples
Help text 

_Chem_comp_identifier.Program (Program)

(go to parent tag category listing)
NMR-STAR tag name_Chem_comp_identifier.Program 
DescriptionNMR-STAR name: _Chem_comp_identifier.Program
This data item contains the name of the program or library used to compute the identifier.  
Database field nameProgram 
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. 
PromptProgram  
Examples
Help text 

_Chem_comp_identifier.Program_version (ProgramVersion)

(go to parent tag category listing)
NMR-STAR tag name_Chem_comp_identifier.Program_version 
DescriptionNMR-STAR name: _Chem_comp_identifier.Program_version
This data item contains the version of the program or library used to compute the identifier.  
Database field nameProgramVersion 
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 
PromptProgram version  
Examples
Help text 

_Chem_comp_identifier.Sf_ID (SfID)

(go to parent tag category listing)
NMR-STAR tag name_Chem_comp_identifier.Sf_ID 
DescriptionNMR-STAR name: _Chem_comp_identifier.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 Flagno 
Nulls allowed in database?yes 
PromptSf ID  
Examples
Help text 

_Chem_comp_identifier.Entry_ID (EntryID)

(go to parent tag category listing)
NMR-STAR tag name_Chem_comp_identifier.Entry_ID 
DescriptionNMR-STAR name: _Chem_comp_identifier.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_identifier.Comp_ID (CompID)

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