Points


Columns

Column Type Size Nulls Auto Default Children Parents Comments
ProjectId uniqueidentifier 16 null
Projects.ProjectId Points_Projects_ForeignKey C
PointId uniqueidentifier 16 null
AnalysisAmberValues.PointId AnalysisAmberValues_Points_ForeignKey C
AnalysisSamples.PointId AnalysisSamples_Points_ForeignKey C
BackFill.PointId BackFill_Points_ForeignKey C
Casings.PointId Casings_Points_ForeignKey C
CPTPush.PointId CPTPush_Points_ForeignKey C
Documents.PointId Documents_Points_ForeignKey C
DrillingObservations.PointId DrillingObservations_Points_ForeignKey C
FieldLogs.PointId FieldLogs_Points_ForeignKey C
GLogs.PointId GLogs_Points_ForeignKey C
HoleDiameters.PointId HoleDiameters_Points_ForeignKey C
Inclinations.PointId Inclinations_Points_ForeignKey C
Injections.PointId Injections_Points_ForeignKey C
InsituVaneTests.PointId InsituVaneTests_Points_ForeignKey C
Intakes.PointId Intakes_Points_ForeignKey C
Jackups.PointId Jackups_Points_ForeignKey C
Measurements.PointId Measurements_Points_ForeignKey C
PenetrationTests.PointId PenetrationTests_Points_ForeignKey C
PointSummary.PointId PointSummary_Points_ForeignKey C
PointSynonyms.PointId PointSynonyms_Points_ForeignKey C
PressuremeterTests.PointId PressuremeterTests_Points_ForeignKey C
qryAnalysisAmberValues.PointId Implied Constraint R
qryAnalysisRemarks.PointId Implied Constraint R
qryAnalysisSamples.PointId Implied Constraint R
qryAnalysisValues.PointId Implied Constraint R
qryBackFill.PointId Implied Constraint R
qryBrazilianTests.PointId Implied Constraint R
qryCasings.PointId Implied Constraint R
qryClassificationTestGrainSizes.PointId Implied Constraint R
qryClassificationTests.PointId Implied Constraint R
qryConsolidationTests.PointId Implied Constraint R
qryCPTData.PointId Implied Constraint R
qryCPTPush.PointId Implied Constraint R
qryDocumentItems.PointId Implied Constraint R
qryDocumentRevisions.PointId Implied Constraint R
qryDocuments.PointId Implied Constraint R
qryDPTData.PointId Implied Constraint R
qryDrillingObservations.PointId Implied Constraint R
qryDSSTests.PointId Implied Constraint R
qryEMMTestValues.PointId Implied Constraint R
qryFieldLogs.PointId Implied Constraint R
qryFissures.PointId Implied Constraint R
qryGrainSizes.PointId Implied Constraint R
qryGrainSizeTests.PointId Implied Constraint R
qryGrainSizeValues.PointId Implied Constraint R
qryGrouting.PointId Implied Constraint R
qryHoleDiameters.PointId Implied Constraint R
qryInclinations.PointId Implied Constraint R
qryIndurations.PointId Implied Constraint R
qryInjections.PointId Implied Constraint R
qryInsituVaneTests.PointId Implied Constraint R
qryIntakes.PointId Implied Constraint R
qryJackups.PointId Implied Constraint R
qryLabVaneTests.PointId Implied Constraint R
qryMeasurementData.PointId Implied Constraint R
qryMeasurements.PointId Implied Constraint R
qryPenetrationTests.PointId Implied Constraint R
qryPlasticityTestValues.PointId Implied Constraint R
qryPointLoadTests.PointId Implied Constraint R
qryPoints.PointId Implied Constraint R
qryPointSummary.PointId Implied Constraint R
qryPointSynonyms.PointId Implied Constraint R
qryPressuremeterTests.PointId Implied Constraint R
qryProctorTests.PointId Implied Constraint R
qryProctorTestValues.PointId Implied Constraint R
qryPumpingTests.PointId Implied Constraint R
qrySamples.PointId Implied Constraint R
qrySamples2.PointId Implied Constraint R
qrySectionPoints.PointId Implied Constraint R
qrySelectionPoints.PointId Implied Constraint R
qryShearBoxTests.PointId Implied Constraint R
qrySPTData.PointId Implied Constraint R
qryStrata.PointId Implied Constraint R
qrySwellTests.PointId Implied Constraint R
qryTriaxialTests.PointId Implied Constraint R
qryUCTData.PointId Implied Constraint R
qryWaterLevelMps.PointId Implied Constraint R
qryWaterLevels.PointId Implied Constraint R
qryWaterStrikes.PointId Implied Constraint R
qryWaterVolumes.PointId Implied Constraint R
Samples.PointId Samples_Points_ForeignKey C
SectionPoints.PointId Implied Constraint R
SPTData.PointId SPTData_Points_ForeignKey C
Strata.PointId Strata_Points_ForeignKey C
WaterStrikes.PointId WaterStrikes_Points_ForeignKey C
WaterVolumes.PointId WaterVolumes_Points_ForeignKey C
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
Companies.CompanyId Points_Companies_ForeignKey R
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 identity 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

Table contained 115 rows

Indexes

Constraint Name Type Sort Column(s)
Points_PrimaryKey Primary key Asc PointId
Points_AreaId_Index Performance Asc AreaId
Points_ContractorId_Index Performance Asc ContractorId
Points_CoordinateMethod1_Index Performance Asc CoordinateMethod1
Points_CoordinateQuality1_Index Performance Asc CoordinateQuality1
Points_CoordinateSource1_Index Performance Asc CoordinateSource1
Points_DataOwner_Index Performance Asc DataOwner
Points_ElevationMethod1_Index Performance Asc ElevationMethod1
Points_FRef_Index Performance Asc FRef
Points_FRefBor2_Index Performance Asc FRefBor2
Points_FRefBor_Index Performance Asc FRefBor
Points_FRefCom_Index Performance Asc FRefCom
Points_FRefDB_Index Performance Asc FRefDB
Points_FRefJob_Index Performance Asc FRefJob
Points_Method_Index Performance Asc Method
Points_MunicipalityNo_Index Performance Asc MunicipalityNo
Points_PointId_Index Performance Asc PointId
Points_PointNo_Index Performance Asc PointNo
Points_PointType_Index Performance Asc PointType
Points_ProjectId_Index Performance Asc ProjectId
Points_ProjectId_PointNo_UniqueKey Must be unique Asc/Asc ProjectId + PointNo
Points_Projection1_Index Performance Asc Projection1
Points_Purpose_Index Performance Asc Purpose
Points_Use_Index Performance Asc Use
Points_VerticalRefId1_Index Performance Asc VerticalRefId1

Relationships