NMR-STAR dictionary: database table: ExperimentList

Detailed description of the fields

_Experiment_list.Sf_category (SfCategory)

(go to parent tag category listing)
NMR-STAR tag name_Experiment_list.Sf_category 
DescriptionNMR-STAR name: _Experiment_list.Sf_category
Category assigned to the information in the saveframe.  
Database field nameSfCategory 
SQL Database typeVARCHAR(127) 
Part of primary Keyno 
Foreign Key on table, column,  
Saveframe ID no 
Row Indexno 
Secondary Indexno 
Internal Flagno 
Nulls allowed in database?yes 
PromptSf category  
Examples
Help text 

_Experiment_list.Sf_framecode (SfFramecode)

(go to parent tag category listing)
NMR-STAR tag name_Experiment_list.Sf_framecode 
DescriptionNMR-STAR name: _Experiment_list.Sf_framecode
Descriptive label used to uniquely identify the NMR experiment list within the entry.  
Database field nameSfFramecode 
SQL Database typeVARCHAR(127) 
Part of primary Keyno 
Foreign Key on table, column,  
Saveframe ID no 
Row Indexno 
Secondary Indexno 
Internal Flagno 
Nulls allowed in database?yes 
PromptSf framecode  
Examples
Help text 

_Experiment_list.Entry_ID (EntryID)

(go to parent tag category listing)
NMR-STAR tag name_Experiment_list.Entry_ID 
DescriptionNMR-STAR name: _Experiment_list.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 

_Experiment_list.Sf_ID (SfID)

(go to parent tag category listing)
NMR-STAR tag name_Experiment_list.Sf_ID 
DescriptionNMR-STAR name: _Experiment_list.Sf_ID
A value that uniquely identifies the NMR experiment list and is unique across the full database of entries.  
Database field nameSfID 
SQL Database typeINTEGER 
Part of primary Keyno 
Foreign Key on table, column,  
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 

_Experiment_list.ID (ExperimentListID)

(go to parent tag category listing)
NMR-STAR tag name_Experiment_list.ID 
DescriptionNMR-STAR name: _Experiment_list.ID
Unique identifier for the list of NMR experiments.  
Database field nameExperimentListID 
SQL Database typeINTEGER 
Part of primary Keyyes 
Foreign Key on table, column,  
Saveframe ID no 
Row Indexno 
Secondary Indexno 
Internal Flagno 
Nulls allowed in database?yes 
PromptID  
Examples
Help text 

_Experiment_list.Details (Details)

(go to parent tag category listing)
NMR-STAR tag name_Experiment_list.Details 
DescriptionNMR-STAR name: _Experiment_list.Details
Enter any additional details describing the NMR experiment(s).  
Database field nameDetails 
SQL Database typeTEXT 
Part of primary Keyno 
Foreign Key on table, column,  
Saveframe ID no 
Row Indexno 
Secondary Indexno 
Internal Flagno 
Nulls allowed in database?no 
PromptOther details  
ExamplesThe structure was determined using a combination of NOE and residual dipolar coupling data.  
Help text