AnalysisParameters


Columns

Column Type Size Nulls Auto Default Children Parents Comments
ParameterId int 4 null
AnalysisAmberValues.ParameterId AnalysisAmberValues_AnalysisParameters_ForeignKey R
AnalysisAttachedParameters.ParameterId AnalysisAttachedParameters_AnalysisParameters_ForeignKey C
AnalysisGroupParameters.ParameterId AnalysisGroupParameters_AnalysisParameters_ForeignKey R
AnalysisLimitValues.ParameterId AnalysisLimitValues_AnalysisParameters_ForeignKey R
AnalysisTriggerValues.ParameterId AnalysisTriggerValues_AnalysisParameters_ForeignKey R
AnalysisValues.ParameterId AnalysisValues_AnalysisParameters_ForeignKey R
Measurements.ParameterId Measurements_AnalysisParameters_ForeignKey R
qryAnalysisAmberValues.ParameterId Implied Constraint R
qryAnalysisAttachedParameters.ParameterId Implied Constraint R
qryAnalysisGroupParameters.ParameterId Implied Constraint R
qryAnalysisLimitValues.ParameterId Implied Constraint R
qryAnalysisValues.ParameterId Implied Constraint R
qryMeasurementData.ParameterId Implied Constraint R
qryMeasurements.ParameterId Implied Constraint R
Parameter nvarchar 160 null
LongName nvarchar 510 null
UnitId int 4 null
AnalysisUnits.UnitId Implied Constraint R
GroupId uniqueidentifier 16 null
AnalysisGroups.GroupId Implied Constraint R
GroupNo int 4 null
MainIon bit 1 null
IonType int 4 null
Formula nvarchar 20 null
Divisor real 4 null
Factor real 4 null
AggregationId nvarchar 2 null
MeasurementAggregations.AggregationId Implied Constraint R
AggregationMin int 4 null
StandatId int 4 null
ScCode int 4 null
CASNo nvarchar 100 null
EUNo nvarchar 100 null
Remark nvarchar 2147483647 null
ExpiredDate datetime 16 null
Active bit 1 null

Table contained 2150 rows

Indexes

Constraint Name Type Sort Column(s)
AnalysisParameters_PrimaryKey Primary key Asc ParameterId
AnalysisParameters_ParameterId_Index Performance Asc ParameterId

Relationships