NMR-STAR dictionary: database table: Method

Detailed description of the fields

_Method.Sf_category (SfCategory)

(go to parent tag category listing)
NMR-STAR tag name_Method.Sf_category 
DescriptionNMR-STAR name: _Method.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 

_Method.Sf_framecode (SfFramecode)

(go to parent tag category listing)
NMR-STAR tag name_Method.Sf_framecode 
DescriptionNMR-STAR name: _Method.Sf_framecode
Descriptive label used to uniquely identify this method.  
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 
PromptMethod label  
Examples
Help text 

_Method.Entry_ID (EntryID)

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

_Method.Sf_ID (SfID)

(go to parent tag category listing)
NMR-STAR tag name_Method.Sf_ID 
DescriptionNMR-STAR name: _Method.Sf_ID
An integer value that is the unique identifier for the saveframe that applies across the archive. This value is not stable and may be reassigned each time the data are loaded into a database system.  
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 

_Method.ID (MethodID)

(go to parent tag category listing)
NMR-STAR tag name_Method.ID 
DescriptionNMR-STAR name: _Method.ID
A value that uniquely identifies the method describe from other methods given in the entry.  
Database field nameMethodID 
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 
PromptMethod ID  
Examples
Help text 

_Method.Derivation_type (DerivationType)

(go to parent tag category listing)
NMR-STAR tag name_Method.Derivation_type 
DescriptionNMR-STAR name: _Method.Derivation_type
The type of derivation used in the reported method.  
Database field nameDerivationType 
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 
PromptDerivation type  
Examples
Help text 

_Method.Details (Details)

(go to parent tag category listing)
NMR-STAR tag name_Method.Details 
DescriptionNMR-STAR name: _Method.Details
Text description providing additional information about the reported method.  
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 
PromptDetails  
Examples
Help text 

_Method.Computer_ID (ComputerID)

(go to parent tag category listing)
NMR-STAR tag name_Method.Computer_ID 
DescriptionNMR-STAR name: _Method.Computer_ID
Pointer to '_Computer.ID'  
Database field nameComputerID 
SQL Database typeINTEGER 
Part of primary Keyno 
Foreign Key on table, columnComputer, ID 
Saveframe ID no 
Row Indexno 
Secondary Indexno 
Internal Flagno 
Nulls allowed in database?no 
PromptComputer ID  
Examples
Help text 

_Method.Computer_label (ComputerLabel)

(go to parent tag category listing)
NMR-STAR tag name_Method.Computer_label 
DescriptionNMR-STAR name: _Method.Computer_label
Pointer to a saveframe of the category computer.  
Database field nameComputerLabel 
SQL Database typeVARCHAR(127) 
Part of primary Keyno 
Foreign Key on table, columnComputer, Sf_framecode 
Saveframe ID no 
Row Indexno 
Secondary Indexno 
Internal Flagno 
Nulls allowed in database?no 
PromptComputer label  
Examples
Help text