NMR-STAR dictionary: detail of EntityPurity table

NMR-STAR dictionary: database table: EntityPurity

Detailed description of the fields

_Entity_purity.ID (EntityPurityID)

(go to parent tag category listing)

NMR-STAR tag name	_Entity_purity.ID
Description	NMR-STAR name: _Entity_purity.ID An integer value that uniquely identifies the purity value in the table of reported purity values in the entry.
Database field name	EntityPurityID
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

_Entity_purity.Sample_ID (SampleID)

(go to parent tag category listing)

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

_Entity_purity.Sample_label (SampleLabel)

(go to parent tag category listing)

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

_Entity_purity.Entity_ID (EntityID)

(go to parent tag category listing)

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

_Entity_purity.Entity_label (EntityLabel)

(go to parent tag category listing)

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

_Entity_purity.Val (Val)

(go to parent tag category listing)

NMR-STAR tag name	_Entity_purity.Val
Description	NMR-STAR name: _Entity_purity.Val Purity value
Database field name	Val
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?	yes
Prompt	Val
Examples	?
Help text

_Entity_purity.Val_units (ValUnits)

(go to parent tag category listing)

NMR-STAR tag name	_Entity_purity.Val_units
Description	NMR-STAR name: _Entity_purity.Val_units Units for the reported purity value.
Database field name	ValUnits
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?	yes
Prompt	Val units
Examples	?
Help text

_Entity_purity.Measurement_method (MeasurementMethod)

(go to parent tag category listing)

NMR-STAR tag name	_Entity_purity.Measurement_method
Description	NMR-STAR name: _Entity_purity.Measurement_method Technique used to determine the purity of the molecule.
Database field name	MeasurementMethod
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	Measurement method
Examples	mass spectrometry
Help text

_Entity_purity.Details (Details)

(go to parent tag category listing)

NMR-STAR tag name	_Entity_purity.Details
Description	NMR-STAR name: _Entity_purity.Details Text describing the reported purity values and measurements.
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

_Entity_purity.Sf_ID (SfID)

(go to parent tag category listing)

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

_Entity_purity.Entry_ID (EntryID)

(go to parent tag category listing)

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

_Entity_purity.Entity_purity_list_ID (EntityPurityListID)

(go to parent tag category listing)

NMR-STAR tag name	_Entity_purity.Entity_purity_list_ID
Description	NMR-STAR name: _Entity_purity.Entity_purity_list_ID Pointer to '_Entity_purity_list.ID'
Database field name	EntityPurityListID
SQL Database type	INTEGER
Part of primary Key	yes
Foreign Key on table, column	Entity_purity_list, ID
Saveframe ID	no
Row Index	no
Secondary Index	no
Internal Flag	no
Nulls allowed in database?	yes
Prompt	Entity purity ID
Examples	?
Help text