NMR-STAR dictionary: database table: SampleConditionVariable

Detailed description of the fields

_Sample_condition_variable.Type (Type)

(go to parent tag category listing)
NMR-STAR tag name_Sample_condition_variable.Type 
DescriptionNMR-STAR name: _Sample_condition_variable.Type
The name of the variable used to define a specific sample condition (i.e., temperature) when conducting experiments used to derive the experimental data included in the file.  
Database field nameType 
SQL Database typeVARCHAR(31) 
Part of primary Keyyes 
Foreign Key on table, column,  
Saveframe ID no 
Row Indexno 
Secondary Indexno 
Internal Flagno 
Nulls allowed in database?yes 
Enumerations[click for a list of enumerations]
This is a closed enumeration. The list of values are the only ones allowed. 
PromptVariable type  
Examplestemperature, pressure, pH  
Help text 

_Sample_condition_variable.Val (Val)

(go to parent tag category listing)
NMR-STAR tag name_Sample_condition_variable.Val 
DescriptionNMR-STAR name: _Sample_condition_variable.Val
Value for the variable (temperature, pressure, pH) defined in the previous field. Do not include the units in this field. The units for the value are entered in a following field.  
Database field nameVal 
SQL Database typeVARCHAR(31) 
Part of primary Keyno 
Foreign Key on table, column,  
Saveframe ID no 
Row Indexno 
Secondary Indexno 
Internal Flagno 
Nulls allowed in database?no 
PromptVariable value  
Examples308  
Help text 

_Sample_condition_variable.Val_err (ValErr)

(go to parent tag category listing)
NMR-STAR tag name_Sample_condition_variable.Val_err 
DescriptionNMR-STAR name: _Sample_condition_variable.Val_err
Provide the estimated error on the value for the sample condition given in the previous field.  
Database field nameValErr 
SQL Database typeVARCHAR(31) 
Part of primary Keyno 
Foreign Key on table, column,  
Saveframe ID no 
Row Indexno 
Secondary Indexno 
Internal Flagno 
Nulls allowed in database?no 
PromptVariable value error  
Examples0.2  
Help text 

_Sample_condition_variable.Val_units (ValUnits)

(go to parent tag category listing)
NMR-STAR tag name_Sample_condition_variable.Val_units 
DescriptionNMR-STAR name: _Sample_condition_variable.Val_units
Provide the units for the value of the sample condition (temperature, pressure, pH, ect.) given in the previous field.  
Database field nameValUnits 
SQL Database typeVARCHAR(31) 
Part of primary Keyno 
Foreign Key on table, column,  
Saveframe ID no 
Row Indexno 
Secondary Indexno 
Internal Flagno 
Nulls allowed in database?no 
Enumerations[click for a list of enumerations]
This is an open enumeration. The list of values are only suggestions. They are not enforced. 
PromptVariable value units  
ExamplesK  
Help text 

_Sample_condition_variable.Sf_ID (SfID)

(go to parent tag category listing)
NMR-STAR tag name_Sample_condition_variable.Sf_ID 
DescriptionNMR-STAR name: _Sample_condition_variable.Sf_ID
Pointer to '_Sample_condition_list.Sf_ID'  
Database field nameSfID 
SQL Database typeINTEGER 
Part of primary Keyno 
Foreign Key on table, columnSample_condition_list, Sf_ID 
Saveframe ID no 
Row Indexno 
Secondary Indexno 
Internal Flagyes
This field's data is for internal use only and should be hidden in public versiond of the data. 
Nulls allowed in database?yes 
PromptSf ID  
Examples
Help text 

_Sample_condition_variable.Entry_ID (EntryID)

(go to parent tag category listing)
NMR-STAR tag name_Sample_condition_variable.Entry_ID 
DescriptionNMR-STAR name: _Sample_condition_variable.Entry_ID
Pointer to '_Entry.ID'  
Database field nameEntryID 
SQL Database typeCHAR(12) 
Part of primary Keyno 
Foreign Key on table, columnSample_condition_list, Entry_ID 
Saveframe ID no 
Row Indexno 
Secondary Indexno 
Internal Flagno 
Nulls allowed in database?yes 
PromptEntry ID  
Examples
Help text 

_Sample_condition_variable.Sample_condition_list_ID (SampleConditionListID)

(go to parent tag category listing)
NMR-STAR tag name_Sample_condition_variable.Sample_condition_list_ID 
DescriptionNMR-STAR name: _Sample_condition_variable.Sample_condition_list_ID
Pointer to '_Sample_condition_list.ID'  
Database field nameSampleConditionListID 
SQL Database typeINTEGER 
Part of primary Keyno 
Foreign Key on table, columnSample_condition_list, ID 
Saveframe ID no 
Row Indexno 
Secondary Indexno 
Internal Flagno 
Nulls allowed in database?yes 
PromptVariable sample conditions ID  
Examples
Help text