NMR-STAR dictionary: detail of NMRExperimentFile table

NMR-STAR dictionary: database table: NMRExperimentFile

Detailed description of the fields

_NMR_experiment_file.Name (Name)

(go to parent tag category listing)

NMR-STAR tag name	_NMR_experiment_file.Name
Description	NMR-STAR name: _NMR_experiment_file.Name Enter the name of a file or directory that has been uploaded that contains information relevant to the NMR experiment. These directories or files might include the time-domain (raw) data for the NMR experiment, the pulse sequence for the experiment, and parameters for acquiring and processing the data.
Database field name	Name
SQL Database type	VARCHAR(127)
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	Name of a file or directory
Examples	1H15N_HSQC
Help text

_NMR_experiment_file.Type (Type)

(go to parent tag category listing)

NMR-STAR tag name	_NMR_experiment_file.Type
Description	NMR-STAR name: _NMR_experiment_file.Type The type of time-domain file being deposited.
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	Type of file
Examples	NMR experiment directory
Help text

_NMR_experiment_file.Directory_path (DirectoryPath)

(go to parent tag category listing)

NMR-STAR tag name	_NMR_experiment_file.Directory_path
Description	NMR-STAR name: _NMR_experiment_file.Directory_path The directory path within the BMRB archive that must be followed to locate listed NMR experiment file.
Database field name	DirectoryPath
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	Directory path
Examples	?
Help text

_NMR_experiment_file.Byte_order (ByteOrder)

(go to parent tag category listing)

NMR-STAR tag name	_NMR_experiment_file.Byte_order
Description	NMR-STAR name: _NMR_experiment_file.Byte_order How the bytes (usually 4, but sometimes 3, for example on AM spectrometers) are arranged. Depends on the computer platform employed.
Database field name	ByteOrder
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	Byte order
Examples	?
Help text

_NMR_experiment_file.Bytes_per_data_point (BytesPerDataPoint)

(go to parent tag category listing)

NMR-STAR tag name	_NMR_experiment_file.Bytes_per_data_point
Description	NMR-STAR name: _NMR_experiment_file.Bytes_per_data_point Number of bytes per data point. Most Sun, SGI, and Linux systems use 4 bytes ( of 8 bits each yielding a total of 32 bits) per point.
Database field name	BytesPerDataPoint
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	Bytes per data point
Examples	?
Help text

_NMR_experiment_file.File_header_size (FileHeaderSize)

(go to parent tag category listing)

NMR-STAR tag name	_NMR_experiment_file.File_header_size
Description	NMR-STAR name: _NMR_experiment_file.File_header_size Size in bytes of the file header associated with the raw unprocessed data.
Database field name	FileHeaderSize
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	File header size
Examples	?
Help text

_NMR_experiment_file.Record_header_size (RecordHeaderSize)

(go to parent tag category listing)

NMR-STAR tag name	_NMR_experiment_file.Record_header_size
Description	NMR-STAR name: _NMR_experiment_file.Record_header_size Size in bytes of the record header within the NMR experiment file.
Database field name	RecordHeaderSize
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	Record header size
Examples	?
Help text

_NMR_experiment_file.Record_trailer_size (RecordTrailerSize)

(go to parent tag category listing)

NMR-STAR tag name	_NMR_experiment_file.Record_trailer_size
Description	NMR-STAR name: _NMR_experiment_file.Record_trailer_size Size in bytes of the record trailer within the NMR experiment file.
Database field name	RecordTrailerSize
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	Record trailer size
Examples	?
Help text

_NMR_experiment_file.Compression_algorithm (CompressionAlgorithm)

(go to parent tag category listing)

NMR-STAR tag name	_NMR_experiment_file.Compression_algorithm
Description	NMR-STAR name: _NMR_experiment_file.Compression_algorithm Algorithm used to compress the NMR experiment file.
Database field name	CompressionAlgorithm
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	Compression algorithm
Examples	?
Help text

_NMR_experiment_file.Details (Details)

(go to parent tag category listing)

NMR-STAR tag name	_NMR_experiment_file.Details
Description	NMR-STAR name: _NMR_experiment_file.Details Additional information regarding the time-domain (raw) data file for this NMR experiment.
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_experiment_file.Sf_ID (SfID)

(go to parent tag category listing)

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

_NMR_experiment_file.Entry_ID (EntryID)

(go to parent tag category listing)

NMR-STAR tag name	_NMR_experiment_file.Entry_ID
Description	NMR-STAR name: _NMR_experiment_file.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	NMR_spec_expt, 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_experiment_file.NMR_spec_expt_ID (NMRSpecExptID)

(go to parent tag category listing)

NMR-STAR tag name	_NMR_experiment_file.NMR_spec_expt_ID
Description	NMR-STAR name: _NMR_experiment_file.NMR_spec_expt_ID Pointer to '_NMR_spec_expt.ID'
Database field name	NMRSpecExptID
SQL Database type	INTEGER
Part of primary Key	yes
Foreign Key on table, column	NMR_spec_expt, ID
Saveframe ID	no
Row Index	no
Secondary Index	no
Internal Flag	no
Nulls allowed in database?	yes
Prompt	NMR spec expt ID
Examples	?
Help text