qryMeasurements


Columns

Column Type Size Nulls Auto Default Children Parents Comments
PointId uniqueidentifier 16 null
Points.PointId Implied Constraint R
MeasurementId uniqueidentifier 16 null
Measurements.MeasurementId Implied Constraint R
Alias nvarchar 160 null
Description nvarchar 510 null
DurationId nvarchar 2 null
MeasurementDurations.DurationId Implied Constraint R
ParameterId int 4 null
AnalysisParameters.ParameterId Implied Constraint R
UnitId int 4 null
AnalysisUnits.UnitId Implied Constraint R
MethodId int 4 null
AnalysisMethods.MethodId Implied Constraint R
AggregationId nvarchar 2 null
MeasurementAggregations.AggregationId Implied Constraint R
Type nvarchar 40 null
MeasurementTypes.Type Implied Constraint R
MissingData bit 1 null
Active bit 1 null
FRef int 4 null
CompanyId uniqueidentifier 16 null
Companies.CompanyId Implied Constraint R
Company nvarchar 160 null
ProjectId uniqueidentifier 16 null
Projects.ProjectId Implied Constraint R
ProjectNo nvarchar 100 null
PointNo nvarchar 160 null
sPointId uniqueidentifier 16 null
sPointNo nvarchar 160 null
Projection1 int 4 null
X1 float 8 null
Y1 float 8 null
VerticalRefId1 nvarchar 100 null
Z1 real 4 null
Projection2 int 4 null
X2 float 8 null
Y2 float 8 null
VerticalRefId2 nvarchar 100 null
Z2 real 4 null
Locked bit 1 null
WKT nvarchar 2147483647 null
Geom geometry 2147483647 null

Table contained 0 rows

Relationships

View Definition


Possibly Referenced Tables/Views