Measurements


Columns

Column Type Size Nulls Auto Default Children Parents Comments
PointId uniqueidentifier 16 null
Points.PointId Measurements_Points_ForeignKey C
MeasurementId uniqueidentifier 16 null
MeasurementData.MeasurementId MeasurementData_Measurements_ForeignKey C
qryMeasurementData.MeasurementId Implied Constraint R
qryMeasurements.MeasurementId Implied Constraint R
Alias nvarchar 160 null
Description nvarchar 510 null
DurationId nvarchar 2 null
MeasurementDurations.DurationId Measurements_MeasurementDurations_ForeignKey R
ParameterId int 4 null
AnalysisParameters.ParameterId Measurements_AnalysisParameters_ForeignKey R
UnitId int 4 null
AnalysisUnits.UnitId Measurements_AnalysisUnits_ForeignKey R
MethodId int 4 null
AnalysisMethods.MethodId Measurements_AnalysisMethods_ForeignKey R
AggregationId nvarchar 2 null
MeasurementAggregations.AggregationId Measurements_MeasurementAggregations_ForeignKey R
Type nvarchar 40 null
MeasurementTypes.Type Measurements_MeasurementTypes_ForeignKey R
MissingData bit 1 null
Active bit 1 null
FRef int 4 null

Table contained 0 rows

Indexes

Constraint Name Type Sort Column(s)
Measurements_PrimaryKey Primary key Asc MeasurementId
Measurements_AggregationId_Index Performance Asc AggregationId
Measurements_Alias_Index Performance Asc Alias
Measurements_Alias_UniqueKey Must be unique Asc Alias
Measurements_DurationId_Index Performance Asc DurationId
Measurements_FRef_Index Performance Asc FRef
Measurements_MeasurementId_Index Performance Asc MeasurementId
Measurements_MethodId_Index Performance Asc MethodId
Measurements_ParameterId_Index Performance Asc ParameterId
Measurements_PointId_Index Performance Asc PointId
Measurements_Type_Index Performance Asc Type
Measurements_UnitId_Index Performance Asc UnitId

Relationships