qrySPTData


Columns

Column Type Size Nulls Auto Default Children Parents Comments
PointId uniqueidentifier 16 null
Points.PointId Implied Constraint R
TestId uniqueidentifier 16 null
Depth real 4 null
SampleId uniqueidentifier 16 null
TestType nvarchar 4 null
PenetrationTestTypes.TestType Implied Constraint R
SeatingDrive real 4 null
TestLength real 4 null
TotalLength real 4 null
TestCode nvarchar 2 null
N int 4 null
Num.n Implied Constraint R
NReport nvarchar 240 null
N1 int 4 null
N2 int 4 null
N3 int 4 null
N4 int 4 null
N5 int 4 null
N6 int 4 null
P1 real 4 null
P2 real 4 null
P3 real 4 null
P4 real 4 null
P5 real 4 null
P6 real 4 null
Description nvarchar 510 null
LayerId uniqueidentifier 16 null
Layers.LayerId Implied Constraint R
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
PhaseId uniqueidentifier 16 null
ProjectPhases.PhaseId Implied Constraint R
DateEnd datetime 16 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
Active bit 1 null
Locked bit 1 null
Level real 4 null
Layer nvarchar 100 null
Color int 4 null
WKT nvarchar 2147483647 null
Geom geometry 2147483647 null

Table contained 0 rows

Relationships

View Definition


Possibly Referenced Tables/Views