NMR-STAR dictionary: database table: TertiaryStructElementSel

Detailed description of the fields

_Tertiary_struct_element_sel.Method_ID (MethodID)

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

_Tertiary_struct_element_sel.Method_label (MethodLabel)

(go to parent tag category listing)
NMR-STAR tag name_Tertiary_struct_element_sel.Method_label 
DescriptionNMR-STAR name: _Tertiary_struct_element_sel.Method_label
Name of the method used to select the chemical components of the system that make up the tertiary structural element.  
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 used to identify and define this structure element  
Examplesauthor defined  
Help text 

_Tertiary_struct_element_sel.Sf_ID (SfID)

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

_Tertiary_struct_element_sel.Entry_ID (EntryID)

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

_Tertiary_struct_element_sel.Tertiary_struct_element_list_ID (TertiaryStructElementListID)

(go to parent tag category listing)
NMR-STAR tag name_Tertiary_struct_element_sel.Tertiary_struct_element_list_ID 
DescriptionNMR-STAR name: _Tertiary_struct_element_sel.Tertiary_struct_element_list_ID
Pointer to '_Tertiary_struct_element_list.ID'  
Database field nameTertiaryStructElementListID 
SQL Database typeINTEGER 
Part of primary Keyyes 
Foreign Key on table, columnTertiary_struct_element_list, ID 
Saveframe ID no 
Row Indexno 
Secondary Indexno 
Internal Flagno 
Nulls allowed in database?yes 
PromptTertiary struct element list ID  
Examples1  
Help text