CPTData


Columns

Column Type Size Nulls Auto Default Children Parents Comments
TestId uniqueidentifier 16 null
CPTPush.TestId CPTData_CPTPush_ForeignKey C
ValueId uniqueidentifier 16 null
Depth real 4 null
Timestamp datetime 16 null
Velocity real 4 null
qc real 4 null
fs real 4 null
u1 real 4 null
u2 real 4 null
u3 real 4 null
Conductivity real 4 null
Temperature real 4 null
PH real 4 null
Slope1 real 4 null
Slope2 real 4 null
REDX real 4 null
MAGT real 4 null
MAGX real 4 null
MAGY real 4 null
MAGZ real 4 null
MC real 4 null
NG real 4 null
PID real 4 null
FID real 4 null
ECD real 4 null
EC real 4 null
XSD real 4 null
Flow real 4 null
RFlow real 4 null
Rf real 4 null
QT real 4 null
FT real 4 null
QE real 4 null
CPO real 4 null
CPOD real 4 null
QNET real 4 null
Rfc real 4 null
ExcessU real 4 null
BQ real 4 null
ISPP real 4 null
NQT real 4 null
NRf real 4 null
ISBT real 4 null
Ic real 4 null
Remark nvarchar 510 null
Active bit 1 null
LayerId uniqueidentifier 16 null
Layers.LayerId CPTData_Layers_ForeignKey R
LayerId2 uniqueidentifier 16 null
CPTLayerId uniqueidentifier 16 null
CPTLayerId2 uniqueidentifier 16 null
qcMovA real 4 null
qcMovAStDev real 4 null
qcMovASpike bit 1 null
fsMovA real 4 null
fsMovAStDev real 4 null
fsMovASpike bit 1 null
u2MovA real 4 null
u2MovAStDev real 4 null
u2MovASpike bit 1 null
SoilTypeId int 4 null
SoilTypes.SoilTypeId Implied Constraint R
BDen real 4 null
UW real 4 null
RelativeDensityLB float 8 null
RelativeDensityBE float 8 null
RelativeDensityUB float 8 null
FrictionAngleLB float 8 null
FrictionAngleBE float 8 null
FrictionAngleUB float 8 null
UndrainedShearStrengthLB float 8 null
UndrainedShearStrengthBE float 8 null
UndrainedShearStrengthUB float 8 null
SmallStrainShearModulusLB float 8 null
SmallStrainShearModulusBE float 8 null
SmallStrainShearModulusUB float 8 null
EPS50LB float 8 null
EPS50BE float 8 null
EPS50UB float 8 null

Table contained 0 rows

Indexes

Constraint Name Type Sort Column(s)
CPTData_PrimaryKey Primary key Asc ValueId
CPTData_Depth_Index Performance Asc Depth
CPTData_LayerId_Index Performance Asc LayerId
CPTData_TestId_Index Performance Asc TestId
CPTData_ValueId_Index Performance Asc ValueId

Relationships