NMR-STAR dictionary: database table: ChemCompAssembly

Detailed description of the fields

_Chem_comp_assembly.Assembly_chem_comp_ID (AssemblyChemCompID)

(go to parent tag category listing)
NMR-STAR tag name_Chem_comp_assembly.Assembly_chem_comp_ID 
DescriptionNMR-STAR name: _Chem_comp_assembly.Assembly_chem_comp_ID
A sequence number from a sequence numbering scheme employed because of a requirement of a software applications.  
Database field nameAssemblyChemCompID 
SQL Database typeCHAR(12) 
Part of primary Keyno 
Foreign Key on table, column,  
Saveframe ID no 
Row Indexno 
Secondary Indexno 
Internal Flagno 
Nulls allowed in database?no 
PromptAssembly chem comp ID  
Examples
Help text 

_Chem_comp_assembly.Entity_assembly_ID (EntityAssemblyID)

(go to parent tag category listing)
NMR-STAR tag name_Chem_comp_assembly.Entity_assembly_ID 
DescriptionNMR-STAR name: _Chem_comp_assembly.Entity_assembly_ID
Pointer to '_Entity_assembly.ID'  
Database field nameEntityAssemblyID 
SQL Database typeINTEGER 
Part of primary Keyyes 
Foreign Key on table, columnEntity_assembly, ID 
Saveframe ID no 
Row Indexno 
Secondary Indexno 
Internal Flagno 
Nulls allowed in database?yes 
PromptEntity assembly ID  
Examples
Help text 

_Chem_comp_assembly.Entity_ID (EntityID)

(go to parent tag category listing)
NMR-STAR tag name_Chem_comp_assembly.Entity_ID 
DescriptionNMR-STAR name: _Chem_comp_assembly.Entity_ID
Pointer to '_Entity.ID'  
Database field nameEntityID 
SQL Database typeINTEGER 
Part of primary Keyno 
Foreign Key on table, columnEntity, ID 
Saveframe ID no 
Row Indexno 
Secondary Indexno 
Internal Flagno 
Nulls allowed in database?no 
PromptEntity ID  
Examples
Help text 

_Chem_comp_assembly.Comp_index_ID (CompIndexID)

(go to parent tag category listing)
NMR-STAR tag name_Chem_comp_assembly.Comp_index_ID 
DescriptionNMR-STAR name: _Chem_comp_assembly.Comp_index_ID
Pointer to '_Entity_comp_index.ID'  
Database field nameCompIndexID 
SQL Database typeINTEGER 
Part of primary Keyyes 
Foreign Key on table, columnEntity_comp_index, ID 
Saveframe ID no 
Row Indexno 
Secondary Indexno 
Internal Flagno 
Nulls allowed in database?yes 
PromptComp index ID  
Examples
Help text 

_Chem_comp_assembly.Comp_ID (CompID)

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

_Chem_comp_assembly.Seq_ID (SeqID)

(go to parent tag category listing)
NMR-STAR tag name_Chem_comp_assembly.Seq_ID 
DescriptionNMR-STAR name: _Chem_comp_assembly.Seq_ID
Pointer to '_PDBX_poly_seq_scheme.Seq_ID'  
Database field nameSeqID 
SQL Database typeINTEGER 
Part of primary Keyno 
Foreign Key on table, columnEntity_poly_seq, Num 
Saveframe ID no 
Row Indexno 
Secondary Indexno 
Internal Flagno 
Nulls allowed in database?yes 
PromptSeq ID  
Examples
Help text 

_Chem_comp_assembly.Sf_ID (SfID)

(go to parent tag category listing)
NMR-STAR tag name_Chem_comp_assembly.Sf_ID 
DescriptionNMR-STAR name: _Chem_comp_assembly.Sf_ID
Pointer to '_Assembly.Sf_ID'  
Database field nameSfID 
SQL Database typeINTEGER 
Part of primary Keyno 
Foreign Key on table, columnAssembly, 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_assembly.Entry_ID (EntryID)

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

_Chem_comp_assembly.Assembly_ID (AssemblyID)

(go to parent tag category listing)
NMR-STAR tag name_Chem_comp_assembly.Assembly_ID 
DescriptionNMR-STAR name: _Chem_comp_assembly.Assembly_ID
Pointer to '_Assembly.ID'  
Database field nameAssemblyID 
SQL Database typeINTEGER 
Part of primary Keyyes 
Foreign Key on table, columnAssembly, ID 
Saveframe ID no 
Row Indexno 
Secondary Indexno 
Internal Flagno 
Nulls allowed in database?yes 
PromptAssembly ID  
Examples
Help text