SectionPoints


Columns

Column Type Size Nulls Auto Default Children Parents Comments
SectionId uniqueidentifier 16 null
Sections.SectionId SectionPoints_Sections_ForeignKey C
SectionPointId uniqueidentifier 16 null
qrySectionPoints.SectionPointId Implied Constraint R
Sequence int 4 null
Version.Sequence Implied Constraint R
PointId uniqueidentifier 16 null
Points.PointId Implied Constraint R
BoreholeNo nvarchar 20 null
Station float 8 null
Offset float 8 null
X float 8 null
Y float 8 null
DrawingId uniqueidentifier 16 null
dx real 4 null
dz real 4 null
Angle real 4 null
DbId uniqueidentifier 16 null
Active bit 1 null
FRef int 4 null
FRefSCom nvarchar 100 null
FRefSJob nvarchar 510 null

Table contained 63 rows

Indexes

Constraint Name Type Sort Column(s)
SectionPoints_PrimaryKey Primary key Asc SectionPointId
SectionPoints_FRef_Index Performance Asc FRef
SectionPoints_FRefSCom_Index Performance Asc FRefSCom
SectionPoints_FRefSJob_Index Performance Asc FRefSJob
SectionPoints_PointId_Index Performance Asc PointId
SectionPoints_SectionId_Index Performance Asc SectionId
SectionPoints_SectionPointId_Index Performance Asc SectionPointId

Relationships