DrillingObservations


Columns

Column Type Size Nulls Auto Default Children Parents Comments
PointId uniqueidentifier 16 null
Points.PointId DrillingObservations_Points_ForeignKey C
TestId uniqueidentifier 16 null
Depth real 4 null
AlterationIndex float 8 null
PenetrationRate float 8 null
PenetrationResistance float 8 null
FlowDifference float 8 null
BitForce float 8 null
Torque float 8 null
RotateSpeed float 8 null
FlowIn float 8 null
FlowOut float 8 null
WaterPressure float 8 null
Description nvarchar 510 null
LayerId uniqueidentifier 16 null
Layers.LayerId Implied Constraint R

Table contained 0 rows

Indexes

Constraint Name Type Sort Column(s)
DrillingObservations_PrimaryKey Primary key Asc TestId
DrillingObservations_PointId_Index Performance Asc PointId
DrillingObservations_TestId_Index Performance Asc TestId
DrillingObservations_TestId_UniqueKey Must be unique Asc TestId

Relationships