NMR-STAR dictionary: database table: ForceConstant

Detailed description of the fields

_Force_constant.ID (ForceConstantID)

(go to parent tag category listing)
NMR-STAR tag name_Force_constant.ID 
DescriptionNMR-STAR name: _Force_constant.ID
Unique identifier for the reported force constant.  
Database field nameForceConstantID 
SQL Database typeINTEGER 
Part of primary Keyyes 
Foreign Key on table, column,  
Saveframe ID yes: This tag contains the identifier for this saveframe in the entry. 
Row Indexyes: This tag contains the index of this row in the loop, which is used when the data is loaded into a database which has a relational model in which ordering doesn't matter 
Secondary Indexno 
Internal Flagno 
Nulls allowed in database?yes 
PromptID  
Examples
Help text 

_Force_constant.Term (Term)

(go to parent tag category listing)
NMR-STAR tag name_Force_constant.Term 
DescriptionNMR-STAR name: _Force_constant.Term
Select a force constant parameter from the list provided or enter your own name for the parameter that you are entering a value.  
Database field nameTerm 
SQL Database typeVARCHAR(31) 
Part of primary Keyno 
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. 
PromptForce constant parameter  
Examples
Help text 

_Force_constant.Units (Units)

(go to parent tag category listing)
NMR-STAR tag name_Force_constant.Units 
DescriptionNMR-STAR name: _Force_constant.Units
Provide the units for the value entered.  
Database field nameUnits 
SQL Database typeVARCHAR(15) 
Part of primary Keyno 
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. 
PromptUnits for the parameter  
Examples
Help text 

_Force_constant.Val (Val)

(go to parent tag category listing)
NMR-STAR tag name_Force_constant.Val 
DescriptionNMR-STAR name: _Force_constant.Val
Enter the value for the selected or manually entered force constant parameter.  
Database field nameVal 
SQL Database typeFLOAT 
Part of primary Keyno 
Foreign Key on table, column,  
Saveframe ID no 
Row Indexno 
Secondary Indexno 
Internal Flagno 
Nulls allowed in database?yes 
PromptValue for the parameter  
Examples
Help text 

_Force_constant.Sf_ID (SfID)

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

_Force_constant.Entry_ID (EntryID)

(go to parent tag category listing)
NMR-STAR tag name_Force_constant.Entry_ID 
DescriptionNMR-STAR name: _Force_constant.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.Force_constant_list_ID (ForceConstantListID)

(go to parent tag category listing)
NMR-STAR tag name_Force_constant.Force_constant_list_ID 
DescriptionNMR-STAR name: _Force_constant.Force_constant_list_ID
Pointer to '_Force_constant_list.ID'  
Database field nameForceConstantListID 
SQL Database typeINTEGER 
Part of primary Keyyes 
Foreign Key on table, columnForce_constant_list, ID 
Saveframe ID no 
Row Indexno 
Secondary Indexno 
Internal Flagno 
Nulls allowed in database?yes 
PromptForce constant list ID  
Examples
Help text