qryPoints


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CompanyId uniqueidentifier 16 null
Companies.CompanyId Implied Constraint R
Company nvarchar 160 null
ProjectNo nvarchar 100 null
Title nvarchar 510 null
RegionNo int 4 null
Regions.RegionNo Implied Constraint R
ProjectMunicipalityNo int 4 null
ProjectId uniqueidentifier 16 null
Projects.ProjectId Implied Constraint R
PointId uniqueidentifier 16 null
Points.PointId Implied Constraint R
PointNo nvarchar 160 null
sPointId uniqueidentifier 16 null
Sequence int 4 null
Version.Sequence Implied Constraint R
PublicNo nvarchar 100 null
Synonym nvarchar 100 null
Description1 nvarchar 510 null
Description2 nvarchar 510 null
Description3 nvarchar 2147483647 null
PointType nvarchar 40 null
DataOwner nvarchar 40 null
ContractorId uniqueidentifier 16 null
Contractor nvarchar 100 null
ContractorInitials nvarchar 100 null
GeoCompany nvarchar 100 null
GeoInitials nvarchar 100 null
PhaseId uniqueidentifier 16 null
ProjectPhases.PhaseId Implied Constraint R
DateStart datetime 16 null
DateEnd datetime 16 null
DateClose datetime 16 null
AbandonDate datetime 16 null
AbandonCause nvarchar 40 null
AbandonContractorId uniqueidentifier 16 null
Purpose nvarchar 40 null
Method nvarchar 40 null
Use nvarchar 40 null
Projection1 int 4 null
X1 float 8 null
Y1 float 8 null
CoordinateMethod1 nvarchar 40 null
CoordinateSource1 nvarchar 40 null
CoordinateQuality1 nvarchar 40 null
VerticalRefId1 nvarchar 100 null
Z1 real 4 null
ElevationMethod1 nvarchar 40 null
Projection2 int 4 null
X2 float 8 null
Y2 float 8 null
CoordinateMethod2 nvarchar 40 null
CoordinateSource2 nvarchar 40 null
CoordinateQuality2 nvarchar 40 null
VerticalRefId2 nvarchar 100 null
Z2 real 4 null
ElevationMethod2 nvarchar 40 null
XUTM32EUREF89 float 8 null
YUTM32EUREF89 float 8 null
ZDVR90 float 8 null
XLocal float 8 null
YLocal float 8 null
ZLocal real 4 null
Top real 4 null
Bottom real 4 null
AlignmentId uniqueidentifier 16 null
Alignments.AlignmentId Implied Constraint R
Station float 8 null
Offset real 4 null
MunicipalityNo int 4 null
Municipalities.MunicipalityNo Implied Constraint R
Address nvarchar 240 null
Town nvarchar 240 null
Postalcode nvarchar 40 null
PostalCodes.PostalCode Implied Constraint R
AreaId uniqueidentifier 16 null
Areas.AreaId Implied Constraint R
Marking nvarchar 240 null
Rig nvarchar 100 null
Rigs.Rig Implied Constraint R
AngleX real 4 null
AngleZ real 4 null
Enclosure nvarchar 100 null
ExecutedBy nvarchar 40 null
ExecutedDate datetime 16 null
CheckedBy nvarchar 100 null
CheckedDate datetime 16 null
ApprovedBy nvarchar 100 null
ApprovedDate datetime 16 null
PlanEnclosure nvarchar 100 null
Owner nvarchar 100 null
Status int 4 null
WaterSounding bit 1 null
WaterDepth real 4 null
LockGeology bit 1 null
Active bit 1 null
LinkId int 4 null
WKT nvarchar 2147483647 null
Geom geometry 2147483647 null
JupiterId int 4 null
FRef nvarchar 510 null
FRefCom nvarchar 100 null
FRefJob nvarchar 100 null
FRefBor nvarchar 100 null
FRefBor2 nvarchar 100 null
FRefDB nvarchar 510 null
Locked bit 1 null
sPointNo nvarchar 160 null
ZTop real 4 null
ZBottom real 4 null
WaterLevel real 4 null
Setup nvarchar 40 null
Setups.Setup Implied Constraint R

Table contained 0 rows

Relationships

View Definition


Possibly Referenced Tables/Views