NMR-STAR dictionary: detail of ChromatographicSystem table

NMR-STAR dictionary: database table: ChromatographicSystem

Detailed description of the fields

_Chromatographic_system.Sf_category (SfCategory)

(go to parent tag category listing)

NMR-STAR tag name	_Chromatographic_system.Sf_category
Description	NMR-STAR name: _Chromatographic_system.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

_Chromatographic_system.Sf_framecode (SfFramecode)

(go to parent tag category listing)

NMR-STAR tag name	_Chromatographic_system.Sf_framecode
Description	NMR-STAR name: _Chromatographic_system.Sf_framecode A label that uniquely identifies the Mass spectrometer from other spectrometers 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	Mass spectrometer label
Examples	?
Help text

_Chromatographic_system.Entry_ID (EntryID)

(go to parent tag category listing)

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

_Chromatographic_system.Sf_ID (SfID)

(go to parent tag category listing)

NMR-STAR tag name	_Chromatographic_system.Sf_ID
Description	NMR-STAR name: _Chromatographic_system.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

_Chromatographic_system.ID (ChromatographicSystemID)

(go to parent tag category listing)

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

_Chromatographic_system.Type (Type)

(go to parent tag category listing)

NMR-STAR tag name	_Chromatographic_system.Type
Description	NMR-STAR name: _Chromatographic_system.Type ?
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?	no
Prompt	Type
Examples	?
Help text

_Chromatographic_system.Pump_manufacturer (PumpManufacturer)

(go to parent tag category listing)

NMR-STAR tag name	_Chromatographic_system.Pump_manufacturer
Description	NMR-STAR name: _Chromatographic_system.Pump_manufacturer Name of the company or other entity that built the Mass spectrometer.
Database field name	PumpManufacturer
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

_Chromatographic_system.Pump_model (PumpModel)

(go to parent tag category listing)

NMR-STAR tag name	_Chromatographic_system.Pump_model
Description	NMR-STAR name: _Chromatographic_system.Pump_model The name or acronym used to describe the model of the spectrometer.
Database field name	PumpModel
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

_Chromatographic_system.Pump_serial_number (PumpSerialNumber)

(go to parent tag category listing)

NMR-STAR tag name	_Chromatographic_system.Pump_serial_number
Description	NMR-STAR name: _Chromatographic_system.Pump_serial_number Unique code assigned to a specific spectrometer by the manufacturer.
Database field name	PumpSerialNumber
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

_Chromatographic_system.Autosampler_manufacturer (AutosamplerManufacturer)

(go to parent tag category listing)

NMR-STAR tag name	_Chromatographic_system.Autosampler_manufacturer
Description	NMR-STAR name: _Chromatographic_system.Autosampler_manufacturer ?
Database field name	AutosamplerManufacturer
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	Autosampler manufacturer
Examples	?
Help text

_Chromatographic_system.Autosampler_model (AutosamplerModel)

(go to parent tag category listing)

NMR-STAR tag name	_Chromatographic_system.Autosampler_model
Description	NMR-STAR name: _Chromatographic_system.Autosampler_model ?
Database field name	AutosamplerModel
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	Autosampler model
Examples	?
Help text

_Chromatographic_system.Autosampler_serial_number (AutosamplerSerialNumber)

(go to parent tag category listing)

NMR-STAR tag name	_Chromatographic_system.Autosampler_serial_number
Description	NMR-STAR name: _Chromatographic_system.Autosampler_serial_number ?
Database field name	AutosamplerSerialNumber
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	Autosampler serial number
Examples	?
Help text

_Chromatographic_system.Col_compartment_manufacturer (ColCompartmentManufacturer)

(go to parent tag category listing)

NMR-STAR tag name	_Chromatographic_system.Col_compartment_manufacturer
Description	NMR-STAR name: _Chromatographic_system.Col_compartment_manufacturer ?
Database field name	ColCompartmentManufacturer
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	Col compartment manufacturer
Examples	?
Help text

_Chromatographic_system.Col_compartment_model (ColCompartmentModel)

(go to parent tag category listing)

NMR-STAR tag name	_Chromatographic_system.Col_compartment_model
Description	NMR-STAR name: _Chromatographic_system.Col_compartment_model ?
Database field name	ColCompartmentModel
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	Col compartment model
Examples	?
Help text

_Chromatographic_system.Col_compartment_serial_number (ColCompartmentSerialNumber)

(go to parent tag category listing)

NMR-STAR tag name	_Chromatographic_system.Col_compartment_serial_number
Description	NMR-STAR name: _Chromatographic_system.Col_compartment_serial_number ?
Database field name	ColCompartmentSerialNumber
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	Col compartment serial number
Examples	?
Help text

_Chromatographic_system.Details (Details)

(go to parent tag category listing)

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