NMR-STAR dictionary: detail of SampleComponentAtomIsotope table

NMR-STAR dictionary: database table: SampleComponentAtomIsotope

Detailed description of the fields

_Sample_component_atom_isotope.Sample_component_ID (SampleComponentID)

NMR-STAR tag name	_Sample_component_atom_isotope.Sample_component_ID
Description	NMR-STAR name: _Sample_component_atom_isotope.Sample_component_ID Pointer to '_Sample_component.ID'
Database field name	SampleComponentID
SQL Database type	INTEGER
Part of primary Key	yes
Foreign Key on table, column	Sample_component, ID
Saveframe ID	no
Row Index	no
Secondary Index	no
Internal Flag	no
Nulls allowed in database?	yes
Prompt	Sample component ID
Examples	?
Help text

_Sample_component_atom_isotope.Mol_common_name (MolCommonName)

(go to parent tag category listing)

NMR-STAR tag name	_Sample_component_atom_isotope.Mol_common_name
Description	NMR-STAR name: _Sample_component_atom_isotope.Mol_common_name A common name used for the labaled chemical compound.
Database field name	MolCommonName
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?	no
Prompt	Mol common name
Examples	?
Help text

_Sample_component_atom_isotope.Assembly_atom_ID (AssemblyAtomID)

(go to parent tag category listing)

NMR-STAR tag name	_Sample_component_atom_isotope.Assembly_atom_ID
Description	NMR-STAR name: _Sample_component_atom_isotope.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

_Sample_component_atom_isotope.Entity_ID (EntityID)

(go to parent tag category listing)

NMR-STAR tag name	_Sample_component_atom_isotope.Entity_ID
Description	NMR-STAR name: _Sample_component_atom_isotope.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

_Sample_component_atom_isotope.Entity_label (EntityLabel)

(go to parent tag category listing)

NMR-STAR tag name	_Sample_component_atom_isotope.Entity_label
Description	NMR-STAR name: _Sample_component_atom_isotope.Entity_label Pointer to a saveframe of the category 'entity'
Database field name	EntityLabel
SQL Database type	VARCHAR(127)
Part of primary Key	no
Foreign Key on table, column	Entity, Sf_framecode
Saveframe ID	no
Row Index	no
Secondary Index	no
Internal Flag	no
Nulls allowed in database?	no
Prompt	Entity label
Examples	?
Help text

_Sample_component_atom_isotope.Comp_ID (CompID)

(go to parent tag category listing)

NMR-STAR tag name	_Sample_component_atom_isotope.Comp_ID
Description	NMR-STAR name: _Sample_component_atom_isotope.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?	yes
Prompt	Comp ID
Examples	?
Help text

_Sample_component_atom_isotope.Comp_isotope_label_code (CompIsotopeLabelCode)

(go to parent tag category listing)

NMR-STAR tag name	_Sample_component_atom_isotope.Comp_isotope_label_code
Description	NMR-STAR name: _Sample_component_atom_isotope.Comp_isotope_label_code A code that uniquely defines the atoms that are isotopically labeled in a chemical component.
Database field name	CompIsotopeLabelCode
SQL Database type	CHAR(12)
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	Comp isotope label code
Examples	?
Help text

_Sample_component_atom_isotope.Comp_index_ID (CompIndexID)

(go to parent tag category listing)

NMR-STAR tag name	_Sample_component_atom_isotope.Comp_index_ID
Description	NMR-STAR name: _Sample_component_atom_isotope.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

_Sample_component_atom_isotope.Seq_ID (SeqID)

(go to parent tag category listing)

NMR-STAR tag name	_Sample_component_atom_isotope.Seq_ID
Description	NMR-STAR name: _Sample_component_atom_isotope.Seq_ID Pointer to '_PDBX_poly_seq_scheme.Seq_ID'
Database field name	SeqID
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
Examples	?
Help text

_Sample_component_atom_isotope.Atom_ID (AtomID)

(go to parent tag category listing)

NMR-STAR tag name	_Sample_component_atom_isotope.Atom_ID
Description	NMR-STAR name: _Sample_component_atom_isotope.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

_Sample_component_atom_isotope.Atom_type (AtomType)

(go to parent tag category listing)

NMR-STAR tag name	_Sample_component_atom_isotope.Atom_type
Description	NMR-STAR name: _Sample_component_atom_isotope.Atom_type Standard symbol used to define the atom element type.
Database field name	AtomType
SQL Database type	CHAR(12)
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
Examples	?
Help text

_Sample_component_atom_isotope.Atom_isotope_number (AtomIsotopeNumber)

(go to parent tag category listing)

NMR-STAR tag name	_Sample_component_atom_isotope.Atom_isotope_number
Description	NMR-STAR name: _Sample_component_atom_isotope.Atom_isotope_number The isotope number for the chemical element (number of protons plus number of neutrons in the nucleus).
Database field name	AtomIsotopeNumber
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	Atom isotope number
Examples	?
Help text

_Sample_component_atom_isotope.Label_pct (LabelPct)

(go to parent tag category listing)

NMR-STAR tag name	_Sample_component_atom_isotope.Label_pct
Description	NMR-STAR name: _Sample_component_atom_isotope.Label_pct The percentage of the atoms at this site that are labeled with the designated isotope.
Database field name	LabelPct
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	Label pct
Examples	?
Help text

_Sample_component_atom_isotope.Auth_entity_assembly_ID (AuthEntityAssemblyID)

(go to parent tag category listing)

NMR-STAR tag name	_Sample_component_atom_isotope.Auth_entity_assembly_ID
Description	NMR-STAR name: _Sample_component_atom_isotope.Auth_entity_assembly_ID ?
Database field name	AuthEntityAssemblyID
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
Examples	?
Help text

_Sample_component_atom_isotope.Auth_entity_ID (AuthEntityID)

(go to parent tag category listing)

NMR-STAR tag name	_Sample_component_atom_isotope.Auth_entity_ID
Description	NMR-STAR name: _Sample_component_atom_isotope.Auth_entity_ID ?
Database field name	AuthEntityID
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 ID
Examples	?
Help text

_Sample_component_atom_isotope.Auth_seq_ID (AuthSeqID)

(go to parent tag category listing)

NMR-STAR tag name	_Sample_component_atom_isotope.Auth_seq_ID
Description	NMR-STAR name: _Sample_component_atom_isotope.Auth_seq_ID ?
Database field name	AuthSeqID
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
Examples	?
Help text

_Sample_component_atom_isotope.Auth_comp_ID (AuthCompID)

(go to parent tag category listing)

NMR-STAR tag name	_Sample_component_atom_isotope.Auth_comp_ID
Description	NMR-STAR name: _Sample_component_atom_isotope.Auth_comp_ID ?
Database field name	AuthCompID
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
Examples	?
Help text

_Sample_component_atom_isotope.Auth_atom_ID (AuthAtomID)

(go to parent tag category listing)

NMR-STAR tag name	_Sample_component_atom_isotope.Auth_atom_ID
Description	NMR-STAR name: _Sample_component_atom_isotope.Auth_atom_ID ?
Database field name	AuthAtomID
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
Examples	?
Help text

_Sample_component_atom_isotope.Sf_ID (SfID)

(go to parent tag category listing)

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

_Sample_component_atom_isotope.Entry_ID (EntryID)

(go to parent tag category listing)

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

_Sample_component_atom_isotope.Sample_ID (SampleID)

(go to parent tag category listing)

NMR-STAR tag name	_Sample_component_atom_isotope.Sample_ID
Description	NMR-STAR name: _Sample_component_atom_isotope.Sample_ID Pointer to '_Sample.ID'
Database field name	SampleID
SQL Database type	INTEGER
Part of primary Key	yes
Foreign Key on table, column	Sample, ID
Saveframe ID	no
Row Index	no
Secondary Index	no
Internal Flag	no
Nulls allowed in database?	yes
Prompt	Sample ID
Examples	?
Help text