NMR-STAR dictionary: detail of DipoleDipoleRelax table

NMR-STAR dictionary: database table: DipoleDipoleRelax

Detailed description of the fields

_Dipole_dipole_relax.ID (DipoleDipoleRelaxID)

NMR-STAR tag name	_Dipole_dipole_relax.ID
Description	NMR-STAR name: _Dipole_dipole_relax.ID Unique identifier for the observed dipole-dipole relaxation value.
Database field name	DipoleDipoleRelaxID
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

_Dipole_dipole_relax.Assembly_atom_ID_1 (AssemblyAtomID1)

(go to parent tag category listing)

NMR-STAR tag name	_Dipole_dipole_relax.Assembly_atom_ID_1
Description	NMR-STAR name: _Dipole_dipole_relax.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

_Dipole_dipole_relax.Entity_assembly_ID_1 (EntityAssemblyID1)

(go to parent tag category listing)

NMR-STAR tag name	_Dipole_dipole_relax.Entity_assembly_ID_1
Description	NMR-STAR name: _Dipole_dipole_relax.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

_Dipole_dipole_relax.Entity_ID_1 (EntityID1)

(go to parent tag category listing)

NMR-STAR tag name	_Dipole_dipole_relax.Entity_ID_1
Description	NMR-STAR name: _Dipole_dipole_relax.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

_Dipole_dipole_relax.Comp_index_ID_1 (CompIndexID1)

(go to parent tag category listing)

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

_Dipole_dipole_relax.Seq_ID_1 (SeqID1)

(go to parent tag category listing)

NMR-STAR tag name	_Dipole_dipole_relax.Seq_ID_1
Description	NMR-STAR name: _Dipole_dipole_relax.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

_Dipole_dipole_relax.Comp_ID_1 (CompID1)

(go to parent tag category listing)

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

_Dipole_dipole_relax.Atom_ID_1 (AtomID1)

(go to parent tag category listing)

NMR-STAR tag name	_Dipole_dipole_relax.Atom_ID_1
Description	NMR-STAR name: _Dipole_dipole_relax.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 ID 1
Examples	?
Help text

_Dipole_dipole_relax.Atom_type_1 (AtomType1)

(go to parent tag category listing)

NMR-STAR tag name	_Dipole_dipole_relax.Atom_type_1
Description	NMR-STAR name: _Dipole_dipole_relax.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?	yes
Prompt	Atom type 1
Examples	?
Help text

_Dipole_dipole_relax.Atom_isotope_number_1 (AtomIsotopeNumber1)

(go to parent tag category listing)

NMR-STAR tag name	_Dipole_dipole_relax.Atom_isotope_number_1
Description	NMR-STAR name: _Dipole_dipole_relax.Atom_isotope_number_1 ?
Database field name	AtomIsotopeNumber1
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	Atom isotope number 1
Examples	?
Help text

_Dipole_dipole_relax.Assembly_atom_ID_2 (AssemblyAtomID2)

(go to parent tag category listing)

NMR-STAR tag name	_Dipole_dipole_relax.Assembly_atom_ID_2
Description	NMR-STAR name: _Dipole_dipole_relax.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

_Dipole_dipole_relax.Entity_assembly_ID_2 (EntityAssemblyID2)

(go to parent tag category listing)

NMR-STAR tag name	_Dipole_dipole_relax.Entity_assembly_ID_2
Description	NMR-STAR name: _Dipole_dipole_relax.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

_Dipole_dipole_relax.Entity_ID_2 (EntityID2)

(go to parent tag category listing)

NMR-STAR tag name	_Dipole_dipole_relax.Entity_ID_2
Description	NMR-STAR name: _Dipole_dipole_relax.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

_Dipole_dipole_relax.Comp_index_ID_2 (CompIndexID2)

(go to parent tag category listing)

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

_Dipole_dipole_relax.Seq_ID_2 (SeqID2)

(go to parent tag category listing)

NMR-STAR tag name	_Dipole_dipole_relax.Seq_ID_2
Description	NMR-STAR name: _Dipole_dipole_relax.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

_Dipole_dipole_relax.Comp_ID_2 (CompID2)

(go to parent tag category listing)

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

_Dipole_dipole_relax.Atom_ID_2 (AtomID2)

(go to parent tag category listing)

NMR-STAR tag name	_Dipole_dipole_relax.Atom_ID_2
Description	NMR-STAR name: _Dipole_dipole_relax.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 ID 2
Examples	?
Help text

_Dipole_dipole_relax.Atom_type_2 (AtomType2)

(go to parent tag category listing)

NMR-STAR tag name	_Dipole_dipole_relax.Atom_type_2
Description	NMR-STAR name: _Dipole_dipole_relax.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?	yes
Prompt	Atom type 2
Examples	?
Help text

_Dipole_dipole_relax.Atom_isotope_number_2 (AtomIsotopeNumber2)

(go to parent tag category listing)

NMR-STAR tag name	_Dipole_dipole_relax.Atom_isotope_number_2
Description	NMR-STAR name: _Dipole_dipole_relax.Atom_isotope_number_2 ?
Database field name	AtomIsotopeNumber2
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	Atom isotope number 2
Examples	?
Help text

_Dipole_dipole_relax.Val (Val)

(go to parent tag category listing)

NMR-STAR tag name	_Dipole_dipole_relax.Val
Description	NMR-STAR name: _Dipole_dipole_relax.Val The dipole-dipole relaxation value.
Database field name	Val
SQL Database type	FLOAT
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	Val
Examples	?
Help text

_Dipole_dipole_relax.Val_err (ValErr)

(go to parent tag category listing)

NMR-STAR tag name	_Dipole_dipole_relax.Val_err
Description	NMR-STAR name: _Dipole_dipole_relax.Val_err The estimated error in the reported dipole-dipole relaxation value.
Database field name	ValErr
SQL Database type	FLOAT
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	Val err
Examples	?
Help text

_Dipole_dipole_relax.Resonance_ID_1 (ResonanceID1)

(go to parent tag category listing)

NMR-STAR tag name	_Dipole_dipole_relax.Resonance_ID_1
Description	NMR-STAR name: _Dipole_dipole_relax.Resonance_ID_1 Pointer to '_Resonance.ID'
Database field name	ResonanceID1
SQL Database type	INTEGER
Part of primary Key	no
Foreign Key on table, column	Resonance, ID
Saveframe ID	no
Row Index	no
Secondary Index	no
Internal Flag	no
Nulls allowed in database?	no
Prompt	Resonance ID 1
Examples	?
Help text

_Dipole_dipole_relax.Resonance_ID_2 (ResonanceID2)

(go to parent tag category listing)

NMR-STAR tag name	_Dipole_dipole_relax.Resonance_ID_2
Description	NMR-STAR name: _Dipole_dipole_relax.Resonance_ID_2 Pointer to '_Resonance.ID'
Database field name	ResonanceID2
SQL Database type	INTEGER
Part of primary Key	no
Foreign Key on table, column	Resonance, ID
Saveframe ID	no
Row Index	no
Secondary Index	no
Internal Flag	no
Nulls allowed in database?	no
Prompt	Resonance ID 2
Examples	?
Help text

_Dipole_dipole_relax.Auth_entity_assembly_ID_1 (AuthEntityAssemblyID1)

(go to parent tag category listing)

NMR-STAR tag name	_Dipole_dipole_relax.Auth_entity_assembly_ID_1
Description	NMR-STAR name: _Dipole_dipole_relax.Auth_entity_assembly_ID_1 ?
Database field name	AuthEntityAssemblyID1
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 entity assembly ID 1
Examples	?
Help text

_Dipole_dipole_relax.Auth_seq_ID_1 (AuthSeqID1)

(go to parent tag category listing)

NMR-STAR tag name	_Dipole_dipole_relax.Auth_seq_ID_1
Description	NMR-STAR name: _Dipole_dipole_relax.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

_Dipole_dipole_relax.Auth_comp_ID_1 (AuthCompID1)

(go to parent tag category listing)

NMR-STAR tag name	_Dipole_dipole_relax.Auth_comp_ID_1
Description	NMR-STAR name: _Dipole_dipole_relax.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

_Dipole_dipole_relax.Auth_atom_ID_1 (AuthAtomID1)

(go to parent tag category listing)

NMR-STAR tag name	_Dipole_dipole_relax.Auth_atom_ID_1
Description	NMR-STAR name: _Dipole_dipole_relax.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

_Dipole_dipole_relax.Auth_entity_assembly_ID_2 (AuthEntityAssemblyID2)

(go to parent tag category listing)

NMR-STAR tag name	_Dipole_dipole_relax.Auth_entity_assembly_ID_2
Description	NMR-STAR name: _Dipole_dipole_relax.Auth_entity_assembly_ID_2 ?
Database field name	AuthEntityAssemblyID2
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 entity assembly ID 2
Examples	?
Help text

_Dipole_dipole_relax.Auth_seq_ID_2 (AuthSeqID2)

(go to parent tag category listing)

NMR-STAR tag name	_Dipole_dipole_relax.Auth_seq_ID_2
Description	NMR-STAR name: _Dipole_dipole_relax.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

_Dipole_dipole_relax.Auth_comp_ID_2 (AuthCompID2)

(go to parent tag category listing)

NMR-STAR tag name	_Dipole_dipole_relax.Auth_comp_ID_2
Description	NMR-STAR name: _Dipole_dipole_relax.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

_Dipole_dipole_relax.Auth_atom_ID_2 (AuthAtomID2)

(go to parent tag category listing)

NMR-STAR tag name	_Dipole_dipole_relax.Auth_atom_ID_2
Description	NMR-STAR name: _Dipole_dipole_relax.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

_Dipole_dipole_relax.Sf_ID (SfID)

(go to parent tag category listing)

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

_Dipole_dipole_relax.Entry_ID (EntryID)

(go to parent tag category listing)

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

_Dipole_dipole_relax.Dipole_dipole_relax_list_ID (DipoleDipoleRelaxListID)

(go to parent tag category listing)

NMR-STAR tag name	_Dipole_dipole_relax.Dipole_dipole_relax_list_ID
Description	NMR-STAR name: _Dipole_dipole_relax.Dipole_dipole_relax_list_ID Pointer to '_Dipole_dipole_relax_list.ID'
Database field name	DipoleDipoleRelaxListID
SQL Database type	INTEGER
Part of primary Key	yes
Foreign Key on table, column	Dipole_dipole_relax_list, ID
Saveframe ID	no
Row Index	no
Secondary Index	no
Internal Flag	no
Nulls allowed in database?	yes
Prompt	Dipole dipole relax list ID
Examples	?
Help text