NMR-STAR dictionary: detail of EntityBond table

NMR-STAR dictionary: database table: EntityBond

Detailed description of the fields

_Entity_bond.ID (EntityBondID)

(go to parent tag category listing)

NMR-STAR tag name	_Entity_bond.ID
Description	NMR-STAR name: _Entity_bond.ID The value of _Entity_bond.id must uniquely identify a record in the Entity_bond list.
Database field name	EntityBondID
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	Chem comp bond ID
Examples	?
Help text

_Entity_bond.Type (Type)

(go to parent tag category listing)

NMR-STAR tag name	_Entity_bond.Type
Description	NMR-STAR name: _Entity_bond.Type A common chemical bond descriptive name.
Database field name	Type
SQL Database type	VARCHAR(31)
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
Enumerations	[click for a list of enumerations] This is an open enumeration. The list of values are only suggestions. They are not enforced.
Prompt	Chem comp bond type
Examples	?
Help text

_Entity_bond.Value_order (ValueOrder)

(go to parent tag category listing)

NMR-STAR tag name	_Entity_bond.Value_order
Description	NMR-STAR name: _Entity_bond.Value_order The value that should be taken as the target for the chemical bond associated with the specified atoms expressed as a bond order.
Database field name	ValueOrder
SQL Database type	VARCHAR(31)
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	Chem comp bond order
Examples	?
Help text

_Entity_bond.Comp_index_ID_1 (CompIndexID1)

(go to parent tag category listing)

NMR-STAR tag name	_Entity_bond.Comp_index_ID_1
Description	NMR-STAR name: _Entity_bond.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

_Entity_bond.Comp_ID_1 (CompID1)

(go to parent tag category listing)

NMR-STAR tag name	_Entity_bond.Comp_ID_1
Description	NMR-STAR name: _Entity_bond.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

_Entity_bond.Atom_ID_1 (AtomID1)

(go to parent tag category listing)

NMR-STAR tag name	_Entity_bond.Atom_ID_1
Description	NMR-STAR name: _Entity_bond.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?	yes
Prompt	Atom 1 atom ID
Examples	?
Help text

_Entity_bond.Comp_index_ID_2 (CompIndexID2)

(go to parent tag category listing)

NMR-STAR tag name	_Entity_bond.Comp_index_ID_2
Description	NMR-STAR name: _Entity_bond.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

_Entity_bond.Comp_ID_2 (CompID2)

(go to parent tag category listing)

NMR-STAR tag name	_Entity_bond.Comp_ID_2
Description	NMR-STAR name: _Entity_bond.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

_Entity_bond.Atom_ID_2 (AtomID2)

(go to parent tag category listing)

NMR-STAR tag name	_Entity_bond.Atom_ID_2
Description	NMR-STAR name: _Entity_bond.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?	yes
Prompt	Atom 2 atom ID
Examples	?
Help text

_Entity_bond.Details (Details)

(go to parent tag category listing)

NMR-STAR tag name	_Entity_bond.Details
Description	NMR-STAR name: _Entity_bond.Details A text description of the bond.
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

_Entity_bond.Sf_ID (SfID)

(go to parent tag category listing)

NMR-STAR tag name	_Entity_bond.Sf_ID
Description	NMR-STAR name: _Entity_bond.Sf_ID Pointer to '_Entity.Sf_ID'
Database field name	SfID
SQL Database type	INTEGER
Part of primary Key	no
Foreign Key on table, column	Entity, 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

_Entity_bond.Entry_ID (EntryID)

(go to parent tag category listing)

NMR-STAR tag name	_Entity_bond.Entry_ID
Description	NMR-STAR name: _Entity_bond.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	Entity, 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

_Entity_bond.Entity_ID (EntityID)

(go to parent tag category listing)

NMR-STAR tag name	_Entity_bond.Entity_ID
Description	NMR-STAR name: _Entity_bond.Entity_ID Pointer to '_Entity.ID'
Database field name	EntityID
SQL Database type	INTEGER
Part of primary Key	yes
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
Examples	?
Help text