NMR-STAR dictionary: database table: ForceConstantList

Detailed description of the fields

_Force_constant_list.Sf_category (SfCategory)

(go to parent tag category listing)
NMR-STAR tag name_Force_constant_list.Sf_category 
DescriptionNMR-STAR name: _Force_constant_list.Sf_category
Category definition for the information content of 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 

_Force_constant_list.Sf_framecode (SfFramecode)

(go to parent tag category listing)
NMR-STAR tag name_Force_constant_list.Sf_framecode 
DescriptionNMR-STAR name: _Force_constant_list.Sf_framecode
A label for the saveframe that describes in very brief terms the information contained in the saveframe.  
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 

_Force_constant_list.Entry_ID (EntryID)

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

_Force_constant_list.Sf_ID (SfID)

(go to parent tag category listing)
NMR-STAR tag name_Force_constant_list.Sf_ID 
DescriptionNMR-STAR name: _Force_constant_list.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 

_Force_constant_list.ID (ForceConstantListID)

(go to parent tag category listing)
NMR-STAR tag name_Force_constant_list.ID 
DescriptionNMR-STAR name: _Force_constant_list.ID
Unique identifier for the list of reported force constants used in calculating structures.  
Database field nameForceConstantListID 
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 

_Force_constant_list.Data_file_name (DataFileName)

(go to parent tag category listing)
NMR-STAR tag name_Force_constant_list.Data_file_name 
DescriptionNMR-STAR name: _Force_constant_list.Data_file_name
Name of the uploaded data file that contains the list of force constant values used in calculating the structure.  
Database field nameDataFileName 
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?no 
PromptData filename  
Examples
Help text 

_Force_constant_list.Default_software_values_used (DefaultSoftwareValuesUsed)

(go to parent tag category listing)
NMR-STAR tag name_Force_constant_list.Default_software_values_used 
DescriptionNMR-STAR name: _Force_constant_list.Default_software_values_used
Code defining if the default force constant values provided with the software package were used.  
Database field nameDefaultSoftwareValuesUsed 
SQL Database typeVARCHAR(3) 
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 a closed enumeration. The list of values are the only ones allowed. 
PromptDefault software values used  
Examplesyes  
Help text 

_Force_constant_list.Details (Details)

(go to parent tag category listing)
NMR-STAR tag name_Force_constant_list.Details 
DescriptionNMR-STAR name: _Force_constant_list.Details
Text providing additional information regarding the force constants used in calculating a structure.  
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