NMR-STAR dictionary: detail of NMRSpectrometerProbe table

NMR-STAR dictionary: database table: NMRSpectrometerProbe

Detailed description of the fields

_NMR_spectrometer_probe.Sf_category (SfCategory)

(go to parent tag category listing)

NMR-STAR tag name	_NMR_spectrometer_probe.Sf_category
Description	NMR-STAR name: _NMR_spectrometer_probe.Sf_category Category assigned to the information in the saveframe.
Database field name	SfCategory
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?	yes
Prompt	Sf category
Examples	?
Help text

_NMR_spectrometer_probe.Sf_framecode (SfFramecode)

(go to parent tag category listing)

NMR-STAR tag name	_NMR_spectrometer_probe.Sf_framecode
Description	NMR-STAR name: _NMR_spectrometer_probe.Sf_framecode A label that uniquely identifies the probe from other probes listed in the entry.
Database field name	SfFramecode
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?	yes
Prompt	NMR spectrometer probe label
Examples	?
Help text

_NMR_spectrometer_probe.Entry_ID (EntryID)

(go to parent tag category listing)

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

_NMR_spectrometer_probe.Sf_ID (SfID)

(go to parent tag category listing)

NMR-STAR tag name	_NMR_spectrometer_probe.Sf_ID
Description	NMR-STAR name: _NMR_spectrometer_probe.Sf_ID An integer value that is the unique identifier for the saveframe that applies across the archive. This value is not stable and may be reassigned each time the data are loaded into a database system.
Database field name	SfID
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	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

_NMR_spectrometer_probe.ID (NMRSpectrometerProbeID)

(go to parent tag category listing)

NMR-STAR tag name	_NMR_spectrometer_probe.ID
Description	NMR-STAR name: _NMR_spectrometer_probe.ID A value that uniquely identifies the NMR probe from other probes listed in the entry.
Database field name	NMRSpectrometerProbeID
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	NMR spectrometer probe ID
Examples	?
Help text

_NMR_spectrometer_probe.Details (Details)

(go to parent tag category listing)

NMR-STAR tag name	_NMR_spectrometer_probe.Details
Description	NMR-STAR name: _NMR_spectrometer_probe.Details Text information describing the NMR spectrometer probe.
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

_NMR_spectrometer_probe.Manufacturer (Manufacturer)

(go to parent tag category listing)

NMR-STAR tag name	_NMR_spectrometer_probe.Manufacturer
Description	NMR-STAR name: _NMR_spectrometer_probe.Manufacturer Name of the company or other entity that built the NMR probe.
Database field name	Manufacturer
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?	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	Manufacturer
Examples	?
Help text

_NMR_spectrometer_probe.Model (Model)

(go to parent tag category listing)

NMR-STAR tag name	_NMR_spectrometer_probe.Model
Description	NMR-STAR name: _NMR_spectrometer_probe.Model The name or acronym used to describe the model of the probe.
Database field name	Model
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?	yes
Prompt	Model
Examples	?
Help text

_NMR_spectrometer_probe.Serial_number (SerialNumber)

(go to parent tag category listing)

NMR-STAR tag name	_NMR_spectrometer_probe.Serial_number
Description	NMR-STAR name: _NMR_spectrometer_probe.Serial_number Unique code assigned to a specific probe by the manufacturer.
Database field name	SerialNumber
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	Serial number
Examples	?
Help text

_NMR_spectrometer_probe.Diameter (Diameter)

(go to parent tag category listing)

NMR-STAR tag name	_NMR_spectrometer_probe.Diameter
Description	NMR-STAR name: _NMR_spectrometer_probe.Diameter The diameter of the probe bore.
Database field name	Diameter
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	Diameter
Examples	?
Help text

_NMR_spectrometer_probe.Rotor_length (RotorLength)

(go to parent tag category listing)

NMR-STAR tag name	_NMR_spectrometer_probe.Rotor_length
Description	NMR-STAR name: _NMR_spectrometer_probe.Rotor_length Length of the rotor used in the probe.
Database field name	RotorLength
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	Rotor length
Examples	?
Help text

_NMR_spectrometer_probe.Rotor_composition (RotorComposition)

(go to parent tag category listing)

NMR-STAR tag name	_NMR_spectrometer_probe.Rotor_composition
Description	NMR-STAR name: _NMR_spectrometer_probe.Rotor_composition Chemical composition of the rotor used in the probe.
Database field name	RotorComposition
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	Rotor composition
Examples	?
Help text

_NMR_spectrometer_probe.Internal_volume (InternalVolume)

(go to parent tag category listing)

NMR-STAR tag name	_NMR_spectrometer_probe.Internal_volume
Description	NMR-STAR name: _NMR_spectrometer_probe.Internal_volume The internal volume of the probe.
Database field name	InternalVolume
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	Internal volume
Examples	?
Help text

_NMR_spectrometer_probe.Spacer_present (SpacerPresent)

(go to parent tag category listing)

NMR-STAR tag name	_NMR_spectrometer_probe.Spacer_present
Description	NMR-STAR name: _NMR_spectrometer_probe.Spacer_present A code indicating the presence of a spacer in the probe.
Database field name	SpacerPresent
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	Spacer present
Examples	?
Help text