AnalysisLimitValues


Columns

Column Type Size Nulls Auto Default Children Parents Comments
LimitId uniqueidentifier 16 null
AnalysisLimits.LimitId AnalysisLimitValues_AnalysisLimits_ForeignKey C
ValueId uniqueidentifier 16 null
ParameterId int 4 null
AnalysisParameters.ParameterId AnalysisLimitValues_AnalysisParameters_ForeignKey R
MediumId int 4 null
AnalysisMedia.MediumId Implied Constraint R
ValueMin float 8 null
ValueMax float 8 null
UnitId int 4 null
AnalysisUnits.UnitId Implied Constraint R
Weight int 4 null
Remark nvarchar 2147483647 null

Table contained 2851 rows

Indexes

Constraint Name Type Sort Column(s)
AnalysisLimitValues_PrimaryKey Primary key Asc ValueId
AnalysisLimitValues_LimitId_Index Performance Asc LimitId
AnalysisLimitValues_LimitId_ParameterId_MediumId_UniqueKey Must be unique Asc/Asc/Asc LimitId + ParameterId + MediumId
AnalysisLimitValues_MediumId_Index Performance Asc MediumId
AnalysisLimitValues_ParameterId_Index Performance Asc ParameterId
AnalysisLimitValues_UnitId_Index Performance Asc UnitId
AnalysisLimitValues_ValueId_Index Performance Asc ValueId

Relationships