qrySectionPoints


Columns

Column Type Size Nulls Auto Default Children Parents Comments
SecCompanyId uniqueidentifier 16 null
SecCompany nvarchar 160 null
SecProjectId uniqueidentifier 16 null
SecProjectNo nvarchar 100 null
Sectitle nvarchar 510 null
Section nvarchar 100 null
SectionId uniqueidentifier 16 null
Sections.SectionId Implied Constraint R
SectionPointId uniqueidentifier 16 null
SectionPoints.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
CompanyId uniqueidentifier 16 null
Companies.CompanyId Implied Constraint R
Company nvarchar 160 null
ProjectId uniqueidentifier 16 null
Projects.ProjectId Implied Constraint R
ProjectNo nvarchar 100 null
Title nvarchar 510 null
PointNo nvarchar 160 null
PointType nvarchar 40 null
Purpose nvarchar 40 null
Method nvarchar 40 null
Projection1 int 4 null
X1 float 8 null
Y1 float 8 null
VerticalRefId1 nvarchar 100 null
Z1 real 4 null
Projection2 int 4 null
X2 float 8 null
Y2 float 8 null
VerticalRefId2 nvarchar 100 null
Z2 real 4 null
Top real 4 null
Bottom real 4 null
ZTop real 4 null
Zbottom real 4 null
Anglex real 4 null
Anglez real 4 null
Wkt nvarchar 2147483647 null
Geom geometry 2147483647 null
DefaultdrawingId uniqueidentifier 16 null

Table contained 0 rows

Relationships

View Definition


Possibly Referenced Tables/Views