qryConsolidationTests


Columns

Column Type Size Nulls Auto Default Children Parents Comments
SampleId uniqueidentifier 16 null
TestId uniqueidentifier 16 null
Distance real 4 null
Laboratory nvarchar 100 null
Description nvarchar 510 null
Oedometer nvarchar 100 null
Oedometers.Oedometer Implied Constraint R
di real 4 null
hi real 4 null
wi real 4 null
uwi real 4 null
uwdi real 4 null
ei real 4 null
ni real 4 null
sri real 4 null
dsi real 4 null
Cp real 4 null
Cs real 4 null
C real 4 null
pg real 4 null
smv real 4 null
pgsmv real 4 null
Cmp real 4 null
Cms real 4 null
Cm real 4 null
Cc real 4 null
Ap real 4 null
As real 4 null
A real 4 null
Cpr real 4 null
Csr real 4 null
Cre real 4 null
Csw real 4 null
Cr real 4 null
cv real 4 null
mv real 4 null
Eoed real 4 null
TestLayerId uniqueidentifier 16 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
PointId uniqueidentifier 16 null
Points.PointId Implied Constraint R
PointNo nvarchar 160 null
sPointId uniqueidentifier 16 null
sPointNo nvarchar 160 null
PhaseId uniqueidentifier 16 null
ProjectPhases.PhaseId Implied Constraint R
DateEnd datetime 16 null
SampleNo nvarchar 40 null
SampleType nvarchar 100 null
SampleDescription nvarchar 2147483647 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
Depth1 real 4 null
Depth2 real 4 null
Depth real 4 null
Level real 4 null
Length real 4 null
Level1 real 4 null
Level2 real 4 null
LayerId uniqueidentifier 16 null
Layers.LayerId Implied Constraint R
Layer nvarchar 100 null
Color int 4 null
LayerId2 uniqueidentifier 16 null
Layer2 nvarchar 100 null
Color2 int 4 null
Active bit 1 null
Locked bit 1 null
LayerTest nvarchar 100 null
ColorTest int 4 null
WKT nvarchar 2147483647 null
Geom geometry 2147483647 null

Table contained 0 rows

Relationships

View Definition


Possibly Referenced Tables/Views