NMR-STAR dictionary: database table: DistConstraintTree

Detailed description of the fields

_Dist_constraint_tree.Constraint_ID (ConstraintID)

(go to parent tag category listing)
NMR-STAR tag name_Dist_constraint_tree.Constraint_ID 
DescriptionNMR-STAR name: _Dist_constraint_tree.Constraint_ID
Unique identifier for the constraint in the list of constraints contained in one save frame.  
Database field nameConstraintID 
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 
PromptConstraint ID  
Examples
Help text 

_Dist_constraint_tree.Node_ID (NodeID)

(go to parent tag category listing)
NMR-STAR tag name_Dist_constraint_tree.Node_ID 
DescriptionNMR-STAR name: _Dist_constraint_tree.Node_ID
Nodes with logic only do not need to be listed here. Combined atoms into pseudo atoms (e.g. LEU QG for all 6 protons) is preferred to keep this loop limited.  
Database field nameNodeID 
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 
PromptNode ID  
Examples1  
Help text 

_Dist_constraint_tree.Down_node_ID (DownNodeID)

(go to parent tag category listing)
NMR-STAR tag name_Dist_constraint_tree.Down_node_ID 
DescriptionNMR-STAR name: _Dist_constraint_tree.Down_node_ID
ID of first sibling down. 0 means no node below.  
Database field nameDownNodeID 
SQL Database typeINTEGER 
Part of primary Keyno 
Foreign Key on table, column,  
Saveframe ID no 
Row Indexno 
Secondary Indexno 
Internal Flagno 
Nulls allowed in database?no 
PromptDown node ID  
Examples1  
Help text 

_Dist_constraint_tree.Right_node_ID (RightNodeID)

(go to parent tag category listing)
NMR-STAR tag name_Dist_constraint_tree.Right_node_ID 
DescriptionNMR-STAR name: _Dist_constraint_tree.Right_node_ID
ID of another sibling to the right. 0 means no node to the right.  
Database field nameRightNodeID 
SQL Database typeINTEGER 
Part of primary Keyno 
Foreign Key on table, column,  
Saveframe ID no 
Row Indexno 
Secondary Indexno 
Internal Flagno 
Nulls allowed in database?no 
PromptRight node ID  
Examples1  
Help text 

_Dist_constraint_tree.Logic_operation (LogicOperation)

(go to parent tag category listing)
NMR-STAR tag name_Dist_constraint_tree.Logic_operation 
DescriptionNMR-STAR name: _Dist_constraint_tree.Logic_operation
A code describing a logic operation (OR, AND, XOR, etc.)  
Database field nameLogicOperation 
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?no 
PromptLogic operation  
ExamplesOR  
Help text 

_Dist_constraint_tree.Sf_ID (SfID)

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

_Dist_constraint_tree.Entry_ID (EntryID)

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

_Dist_constraint_tree.Distance_constraint_list_ID (DistanceConstraintListID)

(go to parent tag category listing)
NMR-STAR tag name_Dist_constraint_tree.Distance_constraint_list_ID 
DescriptionNMR-STAR name: _Dist_constraint_tree.Distance_constraint_list_ID
Pointer to '_Distance_constraint_list.ID'  
Database field nameDistanceConstraintListID 
SQL Database typeINTEGER 
Part of primary Keyyes 
Foreign Key on table, columnDistance_constraint_list, ID 
Saveframe ID no 
Row Indexno 
Secondary Indexno 
Internal Flagno 
Nulls allowed in database?yes 
PromptDistance constraint list ID  
Examples
Help text