NMR-STAR dictionary: detail of AtomType table

NMR-STAR dictionary: database table: AtomType

Detailed description of the fields

_Atom_type.ID (AtomTypeID)

(go to parent tag category listing)

NMR-STAR tag name	_Atom_type.ID
Description	NMR-STAR name: _Atom_type.ID Integer value that uniquely defines the atom type. The primary key for this table.
Database field name	AtomTypeID
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	ID
Examples	1
Help text

_Atom_type.Symbol (Symbol)

(go to parent tag category listing)

NMR-STAR tag name	_Atom_type.Symbol
Description	NMR-STAR name: _Atom_type.Symbol Standard symbol used to define the atom element type.
Database field name	Symbol
SQL Database type	VARCHAR(3)
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	Symbol
Examples	C
Help text

_Atom_type.Atomic_number (AtomicNumber)

(go to parent tag category listing)

NMR-STAR tag name	_Atom_type.Atomic_number
Description	NMR-STAR name: _Atom_type.Atomic_number Atomic number for the atom (number of protons in the nucleus).
Database field name	AtomicNumber
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	Atomic number
Examples	6
Help text

_Atom_type.Isotope_number (IsotopeNumber)

(go to parent tag category listing)

NMR-STAR tag name	_Atom_type.Isotope_number
Description	NMR-STAR name: _Atom_type.Isotope_number Isotope number for the atom (number of protons plus the number of neutrons in the nucleus).
Database field name	IsotopeNumber
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	Isotope number
Examples	13
Help text

_Atom_type.Oxidation_number (OxidationNumber)

(go to parent tag category listing)

NMR-STAR tag name	_Atom_type.Oxidation_number
Description	NMR-STAR name: _Atom_type.Oxidation_number Oxidation number for the atom.
Database field name	OxidationNumber
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?	no
Prompt	Oxidation number
Examples	0
Help text

_Atom_type.Paramagnetic (Paramagnetic)

(go to parent tag category listing)

NMR-STAR tag name	_Atom_type.Paramagnetic
Description	NMR-STAR name: _Atom_type.Paramagnetic Code or flag indicating if the atom in the is paramagnetic.
Database field name	Paramagnetic
SQL Database type	VARCHAR(3)
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
Enumerations	[click for a list of enumerations] This is a closed enumeration. The list of values are the only ones allowed.
Prompt	Paramagnetic
Examples	no
Help text

_Atom_type.Electron_configuration (ElectronConfiguration)

(go to parent tag category listing)

NMR-STAR tag name	_Atom_type.Electron_configuration
Description	NMR-STAR name: _Atom_type.Electron_configuration The configuration of electrons in the electron orbitals of the atom.
Database field name	ElectronConfiguration
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?	no
Prompt	Electron configuration
Examples	?
Help text

_Atom_type.Unpaired_electron_number (UnpairedElectronNumber)

(go to parent tag category listing)

NMR-STAR tag name	_Atom_type.Unpaired_electron_number
Description	NMR-STAR name: _Atom_type.Unpaired_electron_number Number of unpaired electrons surrounding the atom.
Database field name	UnpairedElectronNumber
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	Unpaired electron number
Examples	0
Help text

_Atom_type.Atomic_mass (AtomicMass)

(go to parent tag category listing)

NMR-STAR tag name	_Atom_type.Atomic_mass
Description	NMR-STAR name: _Atom_type.Atomic_mass Atomic mass for the atom.
Database field name	AtomicMass
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	Atomic mass
Examples	?
Help text

_Atom_type.Van_der_Vaals_radii (VanDerVaalsRadii)

(go to parent tag category listing)

NMR-STAR tag name	_Atom_type.Van_der_Vaals_radii
Description	NMR-STAR name: _Atom_type.Van_der_Vaals_radii Van der Vaals radii for the atom
Database field name	VanDerVaalsRadii
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	Van der Vaals radii
Examples	?
Help text

_Atom_type.Sf_ID (SfID)

(go to parent tag category listing)

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

_Atom_type.Entry_ID (EntryID)

(go to parent tag category listing)

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

_Atom_type.Assembly_ID (AssemblyID)

(go to parent tag category listing)

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