NMR-STAR dictionary: database table: HChemShiftConstraintExpt

Detailed description of the fields

_H_chem_shift_constraint_expt.Experiment_ID (ExperimentID)

(go to parent tag category listing)
NMR-STAR tag name_H_chem_shift_constraint_expt.Experiment_ID 
DescriptionNMR-STAR name: _H_chem_shift_constraint_expt.Experiment_ID
Pointer to '_Experiment.ID'  
Database field nameExperimentID 
SQL Database typeINTEGER 
Part of primary Keyyes 
Foreign Key on table, columnExperiment, ID 
Saveframe ID no 
Row Indexno 
Secondary Indexno 
Internal Flagno 
Nulls allowed in database?yes 
PromptExperiment ID  
Examples
Help text 

_H_chem_shift_constraint_expt.Experiment_name (ExperimentName)

(go to parent tag category listing)
NMR-STAR tag name_H_chem_shift_constraint_expt.Experiment_name 
DescriptionNMR-STAR name: _H_chem_shift_constraint_expt.Experiment_name
Pointer to a saveframe of the category 'NMR_spectrometer_expt'  
Database field nameExperimentName 
SQL Database typeVARCHAR(127) 
Part of primary Keyno 
Foreign Key on table, columnExperiment, Name 
Saveframe ID no 
Row Indexno 
Secondary Indexno 
Internal Flagno 
Nulls allowed in database?no 
Enumerations[click for a list of enumerations]
This is a closed enumeration. The list of values are the only ones allowed. 
PromptExperiment name  
Examples
Help text 

_H_chem_shift_constraint_expt.Method_ID (MethodID)

(go to parent tag category listing)
NMR-STAR tag name_H_chem_shift_constraint_expt.Method_ID 
DescriptionNMR-STAR name: _H_chem_shift_constraint_expt.Method_ID
Pointer to '_Method.ID'  
Database field nameMethodID 
SQL Database typeINTEGER 
Part of primary Keyno 
Foreign Key on table, columnMethod, ID 
Saveframe ID no 
Row Indexno 
Secondary Indexno 
Internal Flagno 
Nulls allowed in database?no 
PromptMethods ID  
Examples
Help text 

_H_chem_shift_constraint_expt.Method_label (MethodLabel)

(go to parent tag category listing)
NMR-STAR tag name_H_chem_shift_constraint_expt.Method_label 
DescriptionNMR-STAR name: _H_chem_shift_constraint_expt.Method_label
Pointer to a saveframe of the category 'method'  
Database field nameMethodLabel 
SQL Database typeVARCHAR(127) 
Part of primary Keyno 
Foreign Key on table, columnMethod, Sf_framecode 
Saveframe ID no 
Row Indexno 
Secondary Indexno 
Internal Flagno 
Nulls allowed in database?no 
PromptMethod label  
Examples
Help text 

_H_chem_shift_constraint_expt.Sample_ID (SampleID)

(go to parent tag category listing)
NMR-STAR tag name_H_chem_shift_constraint_expt.Sample_ID 
DescriptionNMR-STAR name: _H_chem_shift_constraint_expt.Sample_ID
Pointer to '_Sample.ID'  
Database field nameSampleID 
SQL Database typeINTEGER 
Part of primary Keyyes 
Foreign Key on table, columnSample, ID 
Saveframe ID no 
Row Indexno 
Secondary Indexno 
Internal Flagno 
Nulls allowed in database?yes 
PromptSample ID  
Examples
Help text 

_H_chem_shift_constraint_expt.Sample_label (SampleLabel)

(go to parent tag category listing)
NMR-STAR tag name_H_chem_shift_constraint_expt.Sample_label 
DescriptionNMR-STAR name: _H_chem_shift_constraint_expt.Sample_label
Sample(s) used in deriving the data  
Database field nameSampleLabel 
SQL Database typeVARCHAR(127) 
Part of primary Keyno 
Foreign Key on table, columnSample, Sf_framecode 
Saveframe ID no 
Row Indexno 
Secondary Indexno 
Internal Flagno 
Nulls allowed in database?yes 
PromptSample label  
Examples
Help text 

_H_chem_shift_constraint_expt.Sample_state (SampleState)

(go to parent tag category listing)
NMR-STAR tag name_H_chem_shift_constraint_expt.Sample_state 
DescriptionNMR-STAR name: _H_chem_shift_constraint_expt.Sample_state
Physical state of the sample either anisotropic or isotropic.  
Database field nameSampleState 
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 an open enumeration. The list of values are only suggestions. They are not enforced. 
PromptSample state  
Examples
Help text 

_H_chem_shift_constraint_expt.Sf_ID (SfID)

(go to parent tag category listing)
NMR-STAR tag name_H_chem_shift_constraint_expt.Sf_ID 
DescriptionNMR-STAR name: _H_chem_shift_constraint_expt.Sf_ID
Pointer to '_H_chem_shift_constraint_list.Sf_ID'  
Database field nameSfID 
SQL Database typeINTEGER 
Part of primary Keyno 
Foreign Key on table, columnH_chem_shift_constraint_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 

_H_chem_shift_constraint_expt.Entry_ID (EntryID)

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

_H_chem_shift_constraint_expt.H_chem_shift_constraint_list_ID (HChemShiftConstraintListID)

(go to parent tag category listing)
NMR-STAR tag name_H_chem_shift_constraint_expt.H_chem_shift_constraint_list_ID 
DescriptionNMR-STAR name: _H_chem_shift_constraint_expt.H_chem_shift_constraint_list_ID
Pointer to '_H_chem_shift_constraint_list.ID'  
Database field nameHChemShiftConstraintListID 
SQL Database typeINTEGER 
Part of primary Keyyes 
Foreign Key on table, columnH_chem_shift_constraint_list, ID 
Saveframe ID no 
Row Indexno 
Secondary Indexno 
Internal Flagno 
Nulls allowed in database?yes 
PromptH chem shift constraint list ID  
Examples
Help text