NMR-STAR dictionary: detail of DistConstraintValue table

NMR-STAR dictionary: database table: DistConstraintValue

Detailed description of the fields

_Dist_constraint_value.Constraint_ID (ConstraintID)

(go to parent tag category listing)

NMR-STAR tag name	_Dist_constraint_value.Constraint_ID
Description	NMR-STAR name: _Dist_constraint_value.Constraint_ID Pointer to '_Dist_constraint_tree.Constraint_ID'
Database field name	ConstraintID
SQL Database type	INTEGER
Part of primary Key	yes
Foreign Key on table, column	Dist_constraint_tree, Constraint_ID
Saveframe ID	no
Row Index	no
Secondary Index	no
Internal Flag	no
Nulls allowed in database?	yes
Prompt	Constraint ID
Examples	?
Help text

_Dist_constraint_value.Tree_node_ID (TreeNodeID)

(go to parent tag category listing)

NMR-STAR tag name	_Dist_constraint_value.Tree_node_ID
Description	NMR-STAR name: _Dist_constraint_value.Tree_node_ID Pointer to '_Dist_constraint_tree.Node_ID'
Database field name	TreeNodeID
SQL Database type	INTEGER
Part of primary Key	yes
Foreign Key on table, column	Dist_constraint_tree, Node_ID
Saveframe ID	no
Row Index	no
Secondary Index	no
Internal Flag	no
Nulls allowed in database?	yes
Prompt	Tree node ID
Examples	?
Help text

_Dist_constraint_value.Source_experiment_ID (SourceExperimentID)

(go to parent tag category listing)

NMR-STAR tag name	_Dist_constraint_value.Source_experiment_ID
Description	NMR-STAR name: _Dist_constraint_value.Source_experiment_ID Pointer to '_Experiment.ID'. This value links the reported constraint to the experiment used to derive the data used to define the constraint.
Database field name	SourceExperimentID
SQL Database type	INTEGER
Part of primary Key	no
Foreign Key on table, column	Experiment, ID
Saveframe ID	no
Row Index	no
Secondary Index	no
Internal Flag	no
Nulls allowed in database?	no
Prompt	Source experiment ID
Examples	?
Help text

_Dist_constraint_value.Spectral_peak_ID (SpectralPeakID)

(go to parent tag category listing)

NMR-STAR tag name	_Dist_constraint_value.Spectral_peak_ID
Description	NMR-STAR name: _Dist_constraint_value.Spectral_peak_ID Pointer to '_Peak.ID'
Database field name	SpectralPeakID
SQL Database type	INTEGER
Part of primary Key	no
Foreign Key on table, column	Peak, ID
Saveframe ID	no
Row Index	no
Secondary Index	no
Internal Flag	no
Nulls allowed in database?	no
Prompt	Spectral peak ID
Examples	?
Help text

_Dist_constraint_value.Spectral_peak_list_ID (SpectralPeakListID)

(go to parent tag category listing)

NMR-STAR tag name	_Dist_constraint_value.Spectral_peak_list_ID
Description	NMR-STAR name: _Dist_constraint_value.Spectral_peak_list_ID ?
Database field name	SpectralPeakListID
SQL Database type	INTEGER
Part of primary Key	no
Foreign Key on table, column	Spectral_peak_list, ID
Saveframe ID	no
Row Index	no
Secondary Index	no
Internal Flag	no
Nulls allowed in database?	no
Prompt	Spectral peak list ID
Examples	?
Help text

_Dist_constraint_value.Intensity_val (IntensityVal)

(go to parent tag category listing)

NMR-STAR tag name	_Dist_constraint_value.Intensity_val
Description	NMR-STAR name: _Dist_constraint_value.Intensity_val Intensity value
Database field name	IntensityVal
SQL Database type	FLOAT
Part of primary Key	no
Foreign Key on table, column	,
Saveframe ID	no
Row Index	no
Secondary Index	no
Internal Flag	no
Nulls allowed in database?	no
Prompt	Intensity val
Examples	?
Help text

_Dist_constraint_value.Intensity_lower_val_err (IntensityLowerValErr)

(go to parent tag category listing)

NMR-STAR tag name	_Dist_constraint_value.Intensity_lower_val_err
Description	NMR-STAR name: _Dist_constraint_value.Intensity_lower_val_err Intensity lower val err
Database field name	IntensityLowerValErr
SQL Database type	FLOAT
Part of primary Key	no
Foreign Key on table, column	,
Saveframe ID	no
Row Index	no
Secondary Index	no
Internal Flag	no
Nulls allowed in database?	no
Prompt	Intensity lower val err
Examples	?
Help text

_Dist_constraint_value.Intensity_upper_val_err (IntensityUpperValErr)

(go to parent tag category listing)

NMR-STAR tag name	_Dist_constraint_value.Intensity_upper_val_err
Description	NMR-STAR name: _Dist_constraint_value.Intensity_upper_val_err Intensity upper val err
Database field name	IntensityUpperValErr
SQL Database type	FLOAT
Part of primary Key	no
Foreign Key on table, column	,
Saveframe ID	no
Row Index	no
Secondary Index	no
Internal Flag	no
Nulls allowed in database?	no
Prompt	Intensity upper val err
Examples	?
Help text

_Dist_constraint_value.Distance_val (DistanceVal)

(go to parent tag category listing)

NMR-STAR tag name	_Dist_constraint_value.Distance_val
Description	NMR-STAR name: _Dist_constraint_value.Distance_val A single value assigned to the distance constraint.
Database field name	DistanceVal
SQL Database type	FLOAT
Part of primary Key	no
Foreign Key on table, column	,
Saveframe ID	no
Row Index	no
Secondary Index	no
Internal Flag	no
Nulls allowed in database?	no
Prompt	Distance val
Examples	3
Help text

_Dist_constraint_value.Distance_lower_bound_val (DistanceLowerBoundVal)

(go to parent tag category listing)

NMR-STAR tag name	_Dist_constraint_value.Distance_lower_bound_val
Description	NMR-STAR name: _Dist_constraint_value.Distance_lower_bound_val The value of the lower bound for the distance constraint.
Database field name	DistanceLowerBoundVal
SQL Database type	FLOAT
Part of primary Key	no
Foreign Key on table, column	,
Saveframe ID	no
Row Index	no
Secondary Index	no
Internal Flag	no
Nulls allowed in database?	no
Prompt	Distance lower bound val
Examples	2
Help text

_Dist_constraint_value.Distance_upper_bound_val (DistanceUpperBoundVal)

(go to parent tag category listing)

NMR-STAR tag name	_Dist_constraint_value.Distance_upper_bound_val
Description	NMR-STAR name: _Dist_constraint_value.Distance_upper_bound_val The value of the upper bound for the distance constraint.
Database field name	DistanceUpperBoundVal
SQL Database type	FLOAT
Part of primary Key	no
Foreign Key on table, column	,
Saveframe ID	no
Row Index	no
Secondary Index	no
Internal Flag	no
Nulls allowed in database?	no
Prompt	Distance upper bound val
Examples	4
Help text

_Dist_constraint_value.Sf_ID (SfID)

(go to parent tag category listing)

NMR-STAR tag name	_Dist_constraint_value.Sf_ID
Description	NMR-STAR name: _Dist_constraint_value.Sf_ID Pointer to '_Distance_constraint_list.Sf_ID'
Database field name	SfID
SQL Database type	INTEGER
Part of primary Key	no
Foreign Key on table, column	Distance_constraint_list, Sf_ID
Saveframe ID	no
Row Index	no
Secondary Index	no
Internal Flag	yes This field's data is for internal use only and should be hidden in public versiond of the data.
Nulls allowed in database?	yes
Prompt	Sf ID
Examples	?
Help text

_Dist_constraint_value.Entry_ID (EntryID)

(go to parent tag category listing)

NMR-STAR tag name	_Dist_constraint_value.Entry_ID
Description	NMR-STAR name: _Dist_constraint_value.Entry_ID Pointer to '_Entry.ID'
Database field name	EntryID
SQL Database type	CHAR(12)
Part of primary Key	yes
Foreign Key on table, column	Entry, ID
Saveframe ID	no
Row Index	no
Secondary Index	no
Internal Flag	no
Nulls allowed in database?	yes
Prompt	Entry ID
Examples	?
Help text

_Dist_constraint_value.Distance_constraint_list_ID (DistanceConstraintListID)

(go to parent tag category listing)

NMR-STAR tag name	_Dist_constraint_value.Distance_constraint_list_ID
Description	NMR-STAR name: _Dist_constraint_value.Distance_constraint_list_ID Pointer to '_Distance_constraint_list.ID'
Database field name	DistanceConstraintListID
SQL Database type	INTEGER
Part of primary Key	yes
Foreign Key on table, column	Distance_constraint_list, ID
Saveframe ID	no
Row Index	no
Secondary Index	no
Internal Flag	no
Nulls allowed in database?	yes
Prompt	Distance constraint list ID
Examples	?
Help text