NMR-STAR dictionary: detail of MassSpectrometerView table

NMR-STAR dictionary: database table: MassSpectrometerView

Detailed description of the fields

_Mass_spectrometer_view.ID (MassSpectrometerViewID)

(go to parent tag category listing)

NMR-STAR tag name	_Mass_spectrometer_view.ID
Description	NMR-STAR name: _Mass_spectrometer_view.ID ?
Database field name	MassSpectrometerViewID
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

_Mass_spectrometer_view.Name (Name)

(go to parent tag category listing)

NMR-STAR tag name	_Mass_spectrometer_view.Name
Description	NMR-STAR name: _Mass_spectrometer_view.Name Enter a simple name for the spectrometer.
Database field name	Name
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	Name for the spectrometer
Examples	?
Help text

_Mass_spectrometer_view.Manufacturer (Manufacturer)

(go to parent tag category listing)

NMR-STAR tag name	_Mass_spectrometer_view.Manufacturer
Description	NMR-STAR name: _Mass_spectrometer_view.Manufacturer Name of the company or other entity that built the Mass spectrometer.
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

_Mass_spectrometer_view.Model (Model)

(go to parent tag category listing)

NMR-STAR tag name	_Mass_spectrometer_view.Model
Description	NMR-STAR name: _Mass_spectrometer_view.Model The name or acronym used to describe the model of the spectrometer.
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
Enumerations	[click for a list of enumerations] This is an open enumeration. The list of values are only suggestions. They are not enforced.
Prompt	Model
Examples	?
Help text

_Mass_spectrometer_view.Type (Type)

(go to parent tag category listing)

NMR-STAR tag name	_Mass_spectrometer_view.Type
Description	NMR-STAR name: _Mass_spectrometer_view.Type Approximate strength of the magnetic field for the spectrometer as defined by the proton frequency of the instrument expressed in MHz.
Database field name	Type
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	Field strength
Examples	?
Help text

_Mass_spectrometer_view.Fragmentation_method (FragmentationMethod)

(go to parent tag category listing)

NMR-STAR tag name	_Mass_spectrometer_view.Fragmentation_method
Description	NMR-STAR name: _Mass_spectrometer_view.Fragmentation_method Enter the method by the mass spectrometer to fragment compounds.
Database field name	FragmentationMethod
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	Fragmentation method
Examples	?
Help text

_Mass_spectrometer_view.Serial_number (SerialNumber)

(go to parent tag category listing)

NMR-STAR tag name	_Mass_spectrometer_view.Serial_number
Description	NMR-STAR name: _Mass_spectrometer_view.Serial_number Unique code assigned to a specific spectrometer 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

_Mass_spectrometer_view.Mass_ref_introduction_method (MassRefIntroductionMethod)

(go to parent tag category listing)

NMR-STAR tag name	_Mass_spectrometer_view.Mass_ref_introduction_method
Description	NMR-STAR name: _Mass_spectrometer_view.Mass_ref_introduction_method ?
Database field name	MassRefIntroductionMethod
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	Mass ref introduction method
Examples	?
Help text

_Mass_spectrometer_view.Details (Details)

(go to parent tag category listing)

NMR-STAR tag name	_Mass_spectrometer_view.Details
Description	NMR-STAR name: _Mass_spectrometer_view.Details A text description of the Mass spectrometer.
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

_Mass_spectrometer_view.Citation_ID (CitationID)

(go to parent tag category listing)

NMR-STAR tag name	_Mass_spectrometer_view.Citation_ID
Description	NMR-STAR name: _Mass_spectrometer_view.Citation_ID Pointer to '_Citation.ID'
Database field name	CitationID
SQL Database type	INTEGER
Part of primary Key	no
Foreign Key on table, column	Citation, ID
Saveframe ID	no
Row Index	no
Secondary Index	no
Internal Flag	no
Nulls allowed in database?	no
Prompt	Citation ID
Examples	?
Help text

_Mass_spectrometer_view.Citation_label (CitationLabel)

(go to parent tag category listing)

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

_Mass_spectrometer_view.Sf_ID (SfID)

(go to parent tag category listing)

NMR-STAR tag name	_Mass_spectrometer_view.Sf_ID
Description	NMR-STAR name: _Mass_spectrometer_view.Sf_ID Pointer to '_Mass_spectrometer_list.Sf_ID'
Database field name	SfID
SQL Database type	INTEGER
Part of primary Key	no
Foreign Key on table, column	Mass_spectrometer_list, Sf_ID
Saveframe ID	no
Row Index	no
Secondary Index	no
Internal Flag	no
Nulls allowed in database?	no
Prompt	Sf ID
Examples	?
Help text

_Mass_spectrometer_view.Entry_ID (EntryID)

(go to parent tag category listing)

NMR-STAR tag name	_Mass_spectrometer_view.Entry_ID
Description	NMR-STAR name: _Mass_spectrometer_view.Entry_ID Pointer to '_Entry.ID'
Database field name	EntryID
SQL Database type	CHAR(12)
Part of primary Key	no
Foreign Key on table, column	Mass_spectrometer_list, Entry_ID
Saveframe ID	no
Row Index	no
Secondary Index	no
Internal Flag	no
Nulls allowed in database?	no
Prompt	Entry ID
Examples	?
Help text

_Mass_spectrometer_view.Mass_spectrometer_list_ID (MassSpectrometerListID)

(go to parent tag category listing)

NMR-STAR tag name	_Mass_spectrometer_view.Mass_spectrometer_list_ID
Description	NMR-STAR name: _Mass_spectrometer_view.Mass_spectrometer_list_ID Pointer to '_Mass_spectrometer_list.ID'
Database field name	MassSpectrometerListID
SQL Database type	INTEGER
Part of primary Key	no
Foreign Key on table, column	Mass_spectrometer_list, ID
Saveframe ID	no
Row Index	no
Secondary Index	no
Internal Flag	no
Nulls allowed in database?	no
Prompt	Mass spectrometer list ID
Examples	?
Help text