NMR-STAR dictionary: database table: AssemblyInteraction

Detailed description of the fields

_Assembly_interaction.ID (AssemblyInteractionID)

(go to parent tag category listing)
NMR-STAR tag name_Assembly_interaction.ID 
DescriptionNMR-STAR name: _Assembly_interaction.ID
Unique identifier for the interaction between two components of the assembly that is being described.  
Database field nameAssemblyInteractionID 
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 
PromptMol interaction ID  
Examples1  
Help text 

_Assembly_interaction.Entity_assembly_ID_1 (EntityAssemblyID1)

(go to parent tag category listing)
NMR-STAR tag name_Assembly_interaction.Entity_assembly_ID_1 
DescriptionNMR-STAR name: _Assembly_interaction.Entity_assembly_ID_1
Identifier for the first component of the assembly that is involved interaction. Pointer to '_Entity_assembly.ID'  
Database field nameEntityAssemblyID1 
SQL Database typeINTEGER 
Part of primary Keyno 
Foreign Key on table, columnEntity_assembly, ID 
Saveframe ID no 
Row Indexno 
Secondary Indexno 
Internal Flagno 
Nulls allowed in database?yes 
PromptMol 1 entity ID  
Examples1  
Help text 

_Assembly_interaction.Entity_assembly_ID_2 (EntityAssemblyID2)

(go to parent tag category listing)
NMR-STAR tag name_Assembly_interaction.Entity_assembly_ID_2 
DescriptionNMR-STAR name: _Assembly_interaction.Entity_assembly_ID_2
Identifier for the second component of the assembly involved in the interaction. Pointer to '_Entity_assembly.ID'  
Database field nameEntityAssemblyID2 
SQL Database typeINTEGER 
Part of primary Keyno 
Foreign Key on table, columnEntity_assembly, ID 
Saveframe ID no 
Row Indexno 
Secondary Indexno 
Internal Flagno 
Nulls allowed in database?yes 
PromptMol 2 entity ID  
Examples2  
Help text 

_Assembly_interaction.Mol_interaction_type (MolInteractionType)

(go to parent tag category listing)
NMR-STAR tag name_Assembly_interaction.Mol_interaction_type 
DescriptionNMR-STAR name: _Assembly_interaction.Mol_interaction_type
covalent- noncovalent/coordination- confromational/configurational exchange- chemical exchange  
Database field nameMolInteractionType 
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. 
PromptMol interaction type  
Examplesprotein-protein  
Help text 

_Assembly_interaction.Sf_ID (SfID)

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

_Assembly_interaction.Entry_ID (EntryID)

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

_Assembly_interaction.Assembly_ID (AssemblyID)

(go to parent tag category listing)
NMR-STAR tag name_Assembly_interaction.Assembly_ID 
DescriptionNMR-STAR name: _Assembly_interaction.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 
PromptMolecular assembly identifier  
Examples1  
Help text