CPTPush


Columns

Column Type Size Nulls Auto Default Children Parents Comments
PointId uniqueidentifier 16 null
Points.PointId CPTPush_Points_ForeignKey C
TestId uniqueidentifier 16 null
CPTData.TestId CPTData_CPTPush_ForeignKey C
DPTData.TestId DPTData_CPTPush_ForeignKey C
TestNo int 4 null
Test nvarchar 100 null
Depth1 real 4 null
Depth2 real 4 null
Cone nvarchar 240 null
CPTCones.Cone CPTPush_CPTCones_ForeignKey R
ConeNo nvarchar 240 null
FrictionReducer bit 1 null
ConeArea float 8 null
ConeAreaRatio float 8 null
SleeveAreaRatio float 8 null
Start nvarchar 510 null
Termination nvarchar 510 null
Remark nvarchar 2147483647 null
Filename nvarchar 510 null
Active bit 1 null

Table contained 0 rows

Indexes

Constraint Name Type Sort Column(s)
CPTPush_PrimaryKey Primary key Asc TestId
CPTPush_Cone_Index Performance Asc Cone
CPTPush_PointId_Index Performance Asc PointId
CPTPush_PointId_TestNo_UniqueKey Must be unique Asc/Asc PointId + TestNo
CPTPush_TestId_Index Performance Asc TestId
CPTPush_TestNo_Index Performance Asc TestNo

Relationships