SPTData


Columns

Column Type Size Nulls Auto Default Children Parents Comments
PointId uniqueidentifier 16 null
Points.PointId SPTData_Points_ForeignKey C
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 SPTData_Layers_ForeignKey R

Table contained 0 rows

Indexes

Constraint Name Type Sort Column(s)
SPTData_PrimaryKey Primary key Asc TestId
SPTData_LayerId_Index Performance Asc LayerId
SPTData_PointId_Index Performance Asc PointId
SPTData_TestId_Index Performance Asc TestId
SPTData_TestType_Index Performance Asc TestType

Relationships