NMR-STAR dictionary: database table: EntityCompIndexAlt

Detailed description of the fields

_Entity_comp_index_alt.Entity_comp_index_ID (EntityCompIndexID)

(go to parent tag category listing)
NMR-STAR tag name_Entity_comp_index_alt.Entity_comp_index_ID 
DescriptionNMR-STAR name: _Entity_comp_index_alt.Entity_comp_index_ID
Pointer to '_Entity_comp_index.ID'  
Database field nameEntityCompIndexID 
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 
PromptEntity comp index ID  
Examples35  
Help text 

_Entity_comp_index_alt.Auth_seq_ID (AuthSeqID)

(go to parent tag category listing)
NMR-STAR tag name_Entity_comp_index_alt.Auth_seq_ID 
DescriptionNMR-STAR name: _Entity_comp_index_alt.Auth_seq_ID
Author supplied sequence number identifying the position in the sequence of the polymer where the alternate residue or chemical compound is located.  
Database field nameAuthSeqID 
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 
PromptSequence number  
Examples27  
Help text 

_Entity_comp_index_alt.Comp_ID (CompID)

(go to parent tag category listing)
NMR-STAR tag name_Entity_comp_index_alt.Comp_ID 
DescriptionNMR-STAR name: _Entity_comp_index_alt.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  
ExamplesALA  
Help text 

_Entity_comp_index_alt.Comp_label (CompLabel)

(go to parent tag category listing)
NMR-STAR tag name_Entity_comp_index_alt.Comp_label 
DescriptionNMR-STAR name: _Entity_comp_index_alt.Comp_label
Pointer to a saveframe of the category chem_comp.  
Database field nameCompLabel 
SQL Database typeVARCHAR(127) 
Part of primary Keyno 
Foreign Key on table, columnChem_comp, Sf_framecode 
Saveframe ID no 
Row Indexno 
Secondary Indexno 
Internal Flagno 
Nulls allowed in database?yes 
PromptResidue or chemical compound label  
ExamplesALA  
Help text 

_Entity_comp_index_alt.Sf_ID (SfID)

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

_Entity_comp_index_alt.Entry_ID (EntryID)

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

_Entity_comp_index_alt.Entity_ID (EntityID)

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