NMR-STAR dictionary: detail of ResonanceAssignment table

NMR-STAR dictionary: database table: ResonanceAssignment

Detailed description of the fields

_Resonance_assignment.Resonance_set_ID (ResonanceSetID)

(go to parent tag category listing)

NMR-STAR tag name	_Resonance_assignment.Resonance_set_ID
Description	NMR-STAR name: _Resonance_assignment.Resonance_set_ID ?
Database field name	ResonanceSetID
SQL Database type	INTEGER
Part of primary Key	yes
Foreign Key on table, column	,
Saveframe ID	no
Row Index	no
Secondary Index	no
Internal Flag	no
Nulls allowed in database?	yes
Prompt	Resonance set ID
Examples	?
Help text

_Resonance_assignment.Assembly_atom_ID (AssemblyAtomID)

(go to parent tag category listing)

NMR-STAR tag name	_Resonance_assignment.Assembly_atom_ID
Description	NMR-STAR name: _Resonance_assignment.Assembly_atom_ID Pointer to '_Atom.Assembly_atom_ID'
Database field name	AssemblyAtomID
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
Examples	?
Help text

_Resonance_assignment.Entity_assembly_ID (EntityAssemblyID)

(go to parent tag category listing)

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

_Resonance_assignment.Entity_ID (EntityID)

(go to parent tag category listing)

NMR-STAR tag name	_Resonance_assignment.Entity_ID
Description	NMR-STAR name: _Resonance_assignment.Entity_ID Pointer to '_Entity.ID'
Database field name	EntityID
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?	no
Prompt	Entity ID
Examples	?
Help text

_Resonance_assignment.Comp_index_ID (CompIndexID)

(go to parent tag category listing)

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

_Resonance_assignment.Comp_ID (CompID)

(go to parent tag category listing)

NMR-STAR tag name	_Resonance_assignment.Comp_ID
Description	NMR-STAR name: _Resonance_assignment.Comp_ID Pointer to '_Chem_comp.ID'
Database field name	CompID
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?	no
Prompt	Comp ID
Examples	?
Help text

_Resonance_assignment.Atom_ID (AtomID)

(go to parent tag category listing)

NMR-STAR tag name	_Resonance_assignment.Atom_ID
Description	NMR-STAR name: _Resonance_assignment.Atom_ID Pointer to '_Chem_comp_atom.Atom_ID'
Database field name	AtomID
SQL Database type	CHAR(12)
Part of primary Key	yes
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
Examples	?
Help text

_Resonance_assignment.Atom_type (AtomType)

(go to parent tag category listing)

NMR-STAR tag name	_Resonance_assignment.Atom_type
Description	NMR-STAR name: _Resonance_assignment.Atom_type ?
Database field name	AtomType
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
Examples	?
Help text

_Resonance_assignment.Atom_isotope_number (AtomIsotopeNumber)

(go to parent tag category listing)

NMR-STAR tag name	_Resonance_assignment.Atom_isotope_number
Description	NMR-STAR name: _Resonance_assignment.Atom_isotope_number ?
Database field name	AtomIsotopeNumber
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
Examples	?
Help text

_Resonance_assignment.Atom_set_ID (AtomSetID)

(go to parent tag category listing)

NMR-STAR tag name	_Resonance_assignment.Atom_set_ID
Description	NMR-STAR name: _Resonance_assignment.Atom_set_ID ?
Database field name	AtomSetID
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 set ID
Examples	?
Help text

_Resonance_assignment.Sf_ID (SfID)

(go to parent tag category listing)

NMR-STAR tag name	_Resonance_assignment.Sf_ID
Description	NMR-STAR name: _Resonance_assignment.Sf_ID Pointer to '_Resonance_linker_list.Sf_ID'
Database field name	SfID
SQL Database type	INTEGER
Part of primary Key	no
Foreign Key on table, column	Resonance_linker_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?	no
Prompt	Sf ID
Examples	?
Help text

_Resonance_assignment.Entry_ID (EntryID)

(go to parent tag category listing)

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

_Resonance_assignment.Resonance_linker_list_ID (ResonanceLinkerListID)

(go to parent tag category listing)

NMR-STAR tag name	_Resonance_assignment.Resonance_linker_list_ID
Description	NMR-STAR name: _Resonance_assignment.Resonance_linker_list_ID Pointer to '_Resonance_linker_list.ID'
Database field name	ResonanceLinkerListID
SQL Database type	INTEGER
Part of primary Key	yes
Foreign Key on table, column	Resonance_linker_list, ID
Saveframe ID	no
Row Index	no
Secondary Index	no
Internal Flag	no
Nulls allowed in database?	yes
Prompt	Resonance linker list ID
Examples	?
Help text