NMR-STAR dictionary: detail of StructureInteraction table

NMR-STAR dictionary: database table: StructureInteraction

Detailed description of the fields

_Structure_interaction.ID (StructureInteractionID)

NMR-STAR tag name	_Structure_interaction.ID
Description	NMR-STAR name: _Structure_interaction.ID Unique identifier for the reported structural interaction.
Database field name	StructureInteractionID
SQL Database type	INTEGER
Part of primary Key	yes
Foreign Key on table, column	,
Saveframe ID	yes: This tag contains the identifier for this saveframe in the entry.
Row Index	yes: 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 Index	no
Internal Flag	no
Nulls allowed in database?	yes
Prompt	ID
Examples	?
Help text

_Structure_interaction.Type (Type)

(go to parent tag category listing)

NMR-STAR tag name	_Structure_interaction.Type
Description	NMR-STAR name: _Structure_interaction.Type A code defining the type of interaction observed.
Database field name	Type
SQL Database type	VARCHAR(127)
Part of primary Key	no
Foreign Key on table, column	,
Saveframe ID	no
Row Index	no
Secondary Index	no
Internal Flag	no
Nulls allowed in database?	yes
Prompt	Type
Examples	?
Help text

_Structure_interaction.Selection_method_ID (SelectionMethodID)

(go to parent tag category listing)

NMR-STAR tag name	_Structure_interaction.Selection_method_ID
Description	NMR-STAR name: _Structure_interaction.Selection_method_ID Pointer to '_Method.ID'
Database field name	SelectionMethodID
SQL Database type	INTEGER
Part of primary Key	no
Foreign Key on table, column	Method, ID
Saveframe ID	no
Row Index	no
Secondary Index	no
Internal Flag	no
Nulls allowed in database?	no
Prompt	Selection method ID
Examples	?
Help text

_Structure_interaction.Assembly_atom_ID_1 (AssemblyAtomID1)

(go to parent tag category listing)

NMR-STAR tag name	_Structure_interaction.Assembly_atom_ID_1
Description	NMR-STAR name: _Structure_interaction.Assembly_atom_ID_1 Pointer to '_Atom.Assembly_atom_ID'
Database field name	AssemblyAtomID1
SQL Database type	INTEGER
Part of primary Key	no
Foreign Key on table, column	Atom, Assembly_atom_ID
Saveframe ID	no
Row Index	no
Secondary Index	no
Internal Flag	no
Nulls allowed in database?	no
Prompt	Assembly atom ID 1
Examples	?
Help text

_Structure_interaction.Entity_assembly_ID_1 (EntityAssemblyID1)

(go to parent tag category listing)

NMR-STAR tag name	_Structure_interaction.Entity_assembly_ID_1
Description	NMR-STAR name: _Structure_interaction.Entity_assembly_ID_1 Pointer to '_Entity_assembly.ID'
Database field name	EntityAssemblyID1
SQL Database type	INTEGER
Part of primary Key	no
Foreign Key on table, column	Entity_assembly, ID
Saveframe ID	no
Row Index	no
Secondary Index	no
Internal Flag	no
Nulls allowed in database?	yes
Prompt	Entity assembly ID 1
Examples	?
Help text

_Structure_interaction.Entity_ID_1 (EntityID1)

(go to parent tag category listing)

NMR-STAR tag name	_Structure_interaction.Entity_ID_1
Description	NMR-STAR name: _Structure_interaction.Entity_ID_1 Pointer to '_Entity.ID'
Database field name	EntityID1
SQL Database type	INTEGER
Part of primary Key	no
Foreign Key on table, column	Entity, ID
Saveframe ID	no
Row Index	no
Secondary Index	no
Internal Flag	no
Nulls allowed in database?	yes
Prompt	Entity ID 1
Examples	?
Help text

_Structure_interaction.Comp_index_ID_1 (CompIndexID1)

(go to parent tag category listing)

NMR-STAR tag name	_Structure_interaction.Comp_index_ID_1
Description	NMR-STAR name: _Structure_interaction.Comp_index_ID_1 Pointer to '_Entity_comp_index.ID'
Database field name	CompIndexID1
SQL Database type	INTEGER
Part of primary Key	no
Foreign Key on table, column	Entity_comp_index, ID
Saveframe ID	no
Row Index	no
Secondary Index	no
Internal Flag	no
Nulls allowed in database?	yes
Prompt	Comp index ID 1
Examples	?
Help text

_Structure_interaction.Seq_ID_1 (SeqID1)

(go to parent tag category listing)

NMR-STAR tag name	_Structure_interaction.Seq_ID_1
Description	NMR-STAR name: _Structure_interaction.Seq_ID_1 Pointer to '_PDBX_poly_seq_scheme.Seq_ID'
Database field name	SeqID1
SQL Database type	INTEGER
Part of primary Key	no
Foreign Key on table, column	Entity_poly_seq, Num
Saveframe ID	no
Row Index	no
Secondary Index	no
Internal Flag	no
Nulls allowed in database?	yes
Prompt	Seq ID 1
Examples	?
Help text

_Structure_interaction.Comp_ID_1 (CompID1)

(go to parent tag category listing)

NMR-STAR tag name	_Structure_interaction.Comp_ID_1
Description	NMR-STAR name: _Structure_interaction.Comp_ID_1 Pointer to '_Chem_comp.ID'
Database field name	CompID1
SQL Database type	CHAR(12)
Part of primary Key	no
Foreign Key on table, column	Chem_comp, ID
Saveframe ID	no
Row Index	no
Secondary Index	no
Internal Flag	no
Nulls allowed in database?	yes
Prompt	Comp ID 1
Examples	?
Help text

_Structure_interaction.Atom_ID_1 (AtomID1)

(go to parent tag category listing)

NMR-STAR tag name	_Structure_interaction.Atom_ID_1
Description	NMR-STAR name: _Structure_interaction.Atom_ID_1 Pointer to '_Chem_comp_atom.Atom_ID'
Database field name	AtomID1
SQL Database type	CHAR(12)
Part of primary Key	no
Foreign Key on table, column	Chem_comp_atom, Atom_ID
Saveframe ID	no
Row Index	no
Secondary Index	no
Internal Flag	no
Nulls allowed in database?	no
Prompt	Atom ID 1
Examples	?
Help text

_Structure_interaction.Atom_type_1 (AtomType1)

(go to parent tag category listing)

NMR-STAR tag name	_Structure_interaction.Atom_type_1
Description	NMR-STAR name: _Structure_interaction.Atom_type_1 Standard symbol used to define the atom element type.
Database field name	AtomType1
SQL Database type	VARCHAR(15)
Part of primary Key	no
Foreign Key on table, column	,
Saveframe ID	no
Row Index	no
Secondary Index	no
Internal Flag	no
Nulls allowed in database?	no
Prompt	Atom type 1
Examples	?
Help text

_Structure_interaction.Assembly_atom_ID_2 (AssemblyAtomID2)

(go to parent tag category listing)

NMR-STAR tag name	_Structure_interaction.Assembly_atom_ID_2
Description	NMR-STAR name: _Structure_interaction.Assembly_atom_ID_2 Pointer to '_Atom.Assembly_atom_ID'
Database field name	AssemblyAtomID2
SQL Database type	INTEGER
Part of primary Key	no
Foreign Key on table, column	Atom, Assembly_atom_ID
Saveframe ID	no
Row Index	no
Secondary Index	no
Internal Flag	no
Nulls allowed in database?	no
Prompt	Assembly atom ID 2
Examples	?
Help text

_Structure_interaction.Entity_assembly_ID_2 (EntityAssemblyID2)

(go to parent tag category listing)

NMR-STAR tag name	_Structure_interaction.Entity_assembly_ID_2
Description	NMR-STAR name: _Structure_interaction.Entity_assembly_ID_2 Pointer to '_Entity_assembly.ID'
Database field name	EntityAssemblyID2
SQL Database type	INTEGER
Part of primary Key	no
Foreign Key on table, column	Entity_assembly, ID
Saveframe ID	no
Row Index	no
Secondary Index	no
Internal Flag	no
Nulls allowed in database?	yes
Prompt	Entity assembly ID 2
Examples	?
Help text

_Structure_interaction.Entity_ID_2 (EntityID2)

(go to parent tag category listing)

NMR-STAR tag name	_Structure_interaction.Entity_ID_2
Description	NMR-STAR name: _Structure_interaction.Entity_ID_2 Pointer to '_Entity.ID'
Database field name	EntityID2
SQL Database type	INTEGER
Part of primary Key	no
Foreign Key on table, column	Entity, ID
Saveframe ID	no
Row Index	no
Secondary Index	no
Internal Flag	no
Nulls allowed in database?	yes
Prompt	Entity ID 2
Examples	?
Help text

_Structure_interaction.Comp_index_ID_2 (CompIndexID2)

(go to parent tag category listing)

NMR-STAR tag name	_Structure_interaction.Comp_index_ID_2
Description	NMR-STAR name: _Structure_interaction.Comp_index_ID_2 Pointer to '_Entity_comp_index.ID'
Database field name	CompIndexID2
SQL Database type	INTEGER
Part of primary Key	no
Foreign Key on table, column	Entity_comp_index, ID
Saveframe ID	no
Row Index	no
Secondary Index	no
Internal Flag	no
Nulls allowed in database?	yes
Prompt	Comp index ID 2
Examples	?
Help text

_Structure_interaction.Seq_ID_2 (SeqID2)

(go to parent tag category listing)

NMR-STAR tag name	_Structure_interaction.Seq_ID_2
Description	NMR-STAR name: _Structure_interaction.Seq_ID_2 Pointer to '_PDBX_poly_seq_scheme.Seq_ID'
Database field name	SeqID2
SQL Database type	INTEGER
Part of primary Key	no
Foreign Key on table, column	Entity_poly_seq, Num
Saveframe ID	no
Row Index	no
Secondary Index	no
Internal Flag	no
Nulls allowed in database?	yes
Prompt	Seq ID 2
Examples	?
Help text

_Structure_interaction.Comp_ID_2 (CompID2)

(go to parent tag category listing)

NMR-STAR tag name	_Structure_interaction.Comp_ID_2
Description	NMR-STAR name: _Structure_interaction.Comp_ID_2 Pointer to '_Chem_comp.ID'
Database field name	CompID2
SQL Database type	CHAR(12)
Part of primary Key	no
Foreign Key on table, column	Chem_comp, ID
Saveframe ID	no
Row Index	no
Secondary Index	no
Internal Flag	no
Nulls allowed in database?	yes
Prompt	Comp ID 2
Examples	?
Help text

_Structure_interaction.Atom_ID_2 (AtomID2)

(go to parent tag category listing)

NMR-STAR tag name	_Structure_interaction.Atom_ID_2
Description	NMR-STAR name: _Structure_interaction.Atom_ID_2 Pointer to '_Chem_comp_atom.Atom_ID'
Database field name	AtomID2
SQL Database type	CHAR(12)
Part of primary Key	no
Foreign Key on table, column	Chem_comp_atom, Atom_ID
Saveframe ID	no
Row Index	no
Secondary Index	no
Internal Flag	no
Nulls allowed in database?	no
Prompt	Atom ID 2
Examples	?
Help text

_Structure_interaction.Atom_type_2 (AtomType2)

(go to parent tag category listing)

NMR-STAR tag name	_Structure_interaction.Atom_type_2
Description	NMR-STAR name: _Structure_interaction.Atom_type_2 Standard symbol used to define the atom element type.
Database field name	AtomType2
SQL Database type	VARCHAR(15)
Part of primary Key	no
Foreign Key on table, column	,
Saveframe ID	no
Row Index	no
Secondary Index	no
Internal Flag	no
Nulls allowed in database?	no
Prompt	Atom type 2
Examples	?
Help text

_Structure_interaction.Details (Details)

(go to parent tag category listing)

NMR-STAR tag name	_Structure_interaction.Details
Description	NMR-STAR name: _Structure_interaction.Details Text description providing additional information about the reported structure interaction.
Database field name	Details
SQL Database type	TEXT
Part of primary Key	no
Foreign Key on table, column	,
Saveframe ID	no
Row Index	no
Secondary Index	no
Internal Flag	no
Nulls allowed in database?	no
Prompt	Details
Examples	?
Help text

_Structure_interaction.Auth_entity_assembly_ID_1 (AuthEntityAssemblyID1)

(go to parent tag category listing)

NMR-STAR tag name	_Structure_interaction.Auth_entity_assembly_ID_1
Description	NMR-STAR name: _Structure_interaction.Auth_entity_assembly_ID_1 ?
Database field name	AuthEntityAssemblyID1
SQL Database type	INTEGER
Part of primary Key	no
Foreign Key on table, column	,
Saveframe ID	no
Row Index	no
Secondary Index	no
Internal Flag	no
Nulls allowed in database?	no
Prompt	Auth entity assembly ID 1
Examples	2
Help text

_Structure_interaction.Auth_seq_ID_1 (AuthSeqID1)

(go to parent tag category listing)

NMR-STAR tag name	_Structure_interaction.Auth_seq_ID_1
Description	NMR-STAR name: _Structure_interaction.Auth_seq_ID_1 An alternative identifier for Seq_id that may be provided by an author in order to match that used in the publication that describes the experimental data. Note that the value is not required to be a number and does not need to correspond to the value for Seq_ID or Comp_index_ID.
Database field name	AuthSeqID1
SQL Database type	VARCHAR(15)
Part of primary Key	no
Foreign Key on table, column	,
Saveframe ID	no
Row Index	no
Secondary Index	no
Internal Flag	no
Nulls allowed in database?	no
Prompt	Auth seq ID 1
Examples	-3
Help text

_Structure_interaction.Auth_comp_ID_1 (AuthCompID1)

(go to parent tag category listing)

NMR-STAR tag name	_Structure_interaction.Auth_comp_ID_1
Description	NMR-STAR name: _Structure_interaction.Auth_comp_ID_1 An alternative identifier for Comp_id that may be provided by an author in order to match that used in the publication that describes the experimental data.
Database field name	AuthCompID1
SQL Database type	VARCHAR(15)
Part of primary Key	no
Foreign Key on table, column	,
Saveframe ID	no
Row Index	no
Secondary Index	no
Internal Flag	no
Nulls allowed in database?	no
Prompt	Auth comp ID 1
Examples	DPN
Help text

_Structure_interaction.Auth_atom_ID_1 (AuthAtomID1)

(go to parent tag category listing)

NMR-STAR tag name	_Structure_interaction.Auth_atom_ID_1
Description	NMR-STAR name: _Structure_interaction.Auth_atom_ID_1 An alternative identifier for Atom_id that may be provided by an author in order to match that used in the publication that describes the experimental data.
Database field name	AuthAtomID1
SQL Database type	VARCHAR(15)
Part of primary Key	no
Foreign Key on table, column	,
Saveframe ID	no
Row Index	no
Secondary Index	no
Internal Flag	no
Nulls allowed in database?	no
Prompt	Auth atom ID 1
Examples	HB1
Help text

_Structure_interaction.Auth_entity_assembly_ID_2 (AuthEntityAssemblyID2)

(go to parent tag category listing)

NMR-STAR tag name	_Structure_interaction.Auth_entity_assembly_ID_2
Description	NMR-STAR name: _Structure_interaction.Auth_entity_assembly_ID_2 ?
Database field name	AuthEntityAssemblyID2
SQL Database type	INTEGER
Part of primary Key	no
Foreign Key on table, column	,
Saveframe ID	no
Row Index	no
Secondary Index	no
Internal Flag	no
Nulls allowed in database?	no
Prompt	Auth entity assembly ID 2
Examples	2
Help text

_Structure_interaction.Auth_seq_ID_2 (AuthSeqID2)

(go to parent tag category listing)

NMR-STAR tag name	_Structure_interaction.Auth_seq_ID_2
Description	NMR-STAR name: _Structure_interaction.Auth_seq_ID_2 An alternative identifier for Seq_id that may be provided by an author in order to match that used in the publication that describes the experimental data. Note that the value is not required to be a number and does not need to correspond to the value for Seq_ID or Comp_index_ID.
Database field name	AuthSeqID2
SQL Database type	VARCHAR(15)
Part of primary Key	no
Foreign Key on table, column	,
Saveframe ID	no
Row Index	no
Secondary Index	no
Internal Flag	no
Nulls allowed in database?	no
Prompt	Auth seq ID 2
Examples	-3
Help text

_Structure_interaction.Auth_comp_ID_2 (AuthCompID2)

(go to parent tag category listing)

NMR-STAR tag name	_Structure_interaction.Auth_comp_ID_2
Description	NMR-STAR name: _Structure_interaction.Auth_comp_ID_2 An alternative identifier for Comp_id that may be provided by an author in order to match that used in the publication that describes the experimental data.
Database field name	AuthCompID2
SQL Database type	VARCHAR(15)
Part of primary Key	no
Foreign Key on table, column	,
Saveframe ID	no
Row Index	no
Secondary Index	no
Internal Flag	no
Nulls allowed in database?	no
Prompt	Auth comp ID 2
Examples	DPN
Help text

_Structure_interaction.Auth_atom_ID_2 (AuthAtomID2)

(go to parent tag category listing)

NMR-STAR tag name	_Structure_interaction.Auth_atom_ID_2
Description	NMR-STAR name: _Structure_interaction.Auth_atom_ID_2 An alternative identifier for Atom_id that may be provided by an author in order to match that used in the publication that describes the experimental data.
Database field name	AuthAtomID2
SQL Database type	VARCHAR(15)
Part of primary Key	no
Foreign Key on table, column	,
Saveframe ID	no
Row Index	no
Secondary Index	no
Internal Flag	no
Nulls allowed in database?	no
Prompt	Auth atom ID 2
Examples	HB1
Help text

_Structure_interaction.Sf_ID (SfID)

(go to parent tag category listing)

NMR-STAR tag name	_Structure_interaction.Sf_ID
Description	NMR-STAR name: _Structure_interaction.Sf_ID Pointer to '_Structure_interaction_list.Sf_ID'
Database field name	SfID
SQL Database type	INTEGER
Part of primary Key	no
Foreign Key on table, column	Structure_interaction_list, Sf_ID
Saveframe ID	no
Row Index	no
Secondary Index	no
Internal Flag	yes This field's data is for internal use only and should be hidden in public versiond of the data.
Nulls allowed in database?	yes
Prompt	Sf ID
Examples	?
Help text

_Structure_interaction.Entry_ID (EntryID)

(go to parent tag category listing)

NMR-STAR tag name	_Structure_interaction.Entry_ID
Description	NMR-STAR name: _Structure_interaction.Entry_ID Pointer to '_Entry.ID'
Database field name	EntryID
SQL Database type	CHAR(12)
Part of primary Key	yes
Foreign Key on table, column	Entry, ID
Saveframe ID	no
Row Index	no
Secondary Index	no
Internal Flag	no
Nulls allowed in database?	yes
Prompt	Entry ID
Examples	?
Help text

_Structure_interaction.Structure_interaction_list_ID (StructureInteractionListID)

(go to parent tag category listing)

NMR-STAR tag name	_Structure_interaction.Structure_interaction_list_ID
Description	NMR-STAR name: _Structure_interaction.Structure_interaction_list_ID Pointer to '_Structure_interaction_list.ID'
Database field name	StructureInteractionListID
SQL Database type	INTEGER
Part of primary Key	yes
Foreign Key on table, column	Structure_interaction_list, ID
Saveframe ID	no
Row Index	no
Secondary Index	no
Internal Flag	no
Nulls allowed in database?	yes
Prompt	Structure interaction list ID
Examples	?
Help text