ProjectPhases


Columns

Column Type Size Nulls Auto Default Children Parents Comments
ProjectId uniqueidentifier 16 null
Projects.ProjectId ProjectPhases_Projects_ForeignKey C
PhaseId uniqueidentifier 16 null
AnalysisSamples.PhaseId Implied Constraint R
Areas.PhaseId Implied Constraint R
Points.PhaseId Implied Constraint R
qryAnalysisSamples.PhaseId Implied Constraint R
qryAnalysisValues.PhaseId Implied Constraint R
qryAreas.PhaseId Implied Constraint R
qryBackFill.PhaseId Implied Constraint R
qryBrazilianTests.PhaseId Implied Constraint R
qryCasings.PhaseId Implied Constraint R
qryClassificationTestGrainSizes.PhaseId Implied Constraint R
qryClassificationTests.PhaseId Implied Constraint R
qryConsolidationTests.PhaseId Implied Constraint R
qryCPTData.PhaseId Implied Constraint R
qryCPTPush.PhaseId Implied Constraint R
qryDocumentRevisions.PhaseId Implied Constraint R
qryDocuments.PhaseId Implied Constraint R
qryDPTData.PhaseId Implied Constraint R
qryDrillingObservations.PhaseId Implied Constraint R
qryDSSTests.PhaseId Implied Constraint R
qryEMMTestValues.PhaseId Implied Constraint R
qryFieldLogs.PhaseId Implied Constraint R
qryFissures.PhaseId Implied Constraint R
qryGrainSizes.PhaseId Implied Constraint R
qryGrainSizeTests.PhaseId Implied Constraint R
qryGrainSizeValues.PhaseId Implied Constraint R
qryGrouting.PhaseId Implied Constraint R
qryHoleDiameters.PhaseId Implied Constraint R
qryInclinations.PhaseId Implied Constraint R
qryIndurations.PhaseId Implied Constraint R
qryInjections.PhaseId Implied Constraint R
qryInsituVaneTests.PhaseId Implied Constraint R
qryIntakes.PhaseId Implied Constraint R
qryJackups.PhaseId Implied Constraint R
qryLabVaneTests.PhaseId Implied Constraint R
qryLegPenetrations.PhaseId Implied Constraint R
qryPenetrationTests.PhaseId Implied Constraint R
qryPlasticityTestValues.PhaseId Implied Constraint R
qryPointLoadTests.PhaseId Implied Constraint R
qryPoints.PhaseId Implied Constraint R
qryPointSummary.PhaseId Implied Constraint R
qryPointSynonyms.PhaseId Implied Constraint R
qryPressuremeterTests.PhaseId Implied Constraint R
qryProctorTests.PhaseId Implied Constraint R
qryProctorTestValues.PhaseId Implied Constraint R
qryProjectPhases.PhaseId Implied Constraint R
qryPumpingTests.PhaseId Implied Constraint R
qrySamples.PhaseId Implied Constraint R
qrySamples2.PhaseId Implied Constraint R
qryShearBoxTests.PhaseId Implied Constraint R
qrySPTData.PhaseId Implied Constraint R
qryStrata.PhaseId Implied Constraint R
qrySwellTests.PhaseId Implied Constraint R
qryTriaxialTests.PhaseId Implied Constraint R
qryUCTData.PhaseId Implied Constraint R
qryWaterLevelMps.PhaseId Implied Constraint R
qryWaterLevels.PhaseId Implied Constraint R
qryWaterStrikes.PhaseId Implied Constraint R
qryWaterVolumes.PhaseId Implied Constraint R
PhaseType nvarchar 240 null
Phase nvarchar 240 null
Description nvarchar 510 null
PhaseStart datetime 16 null
PhaseEnd datetime 16 null
PhaseCompanyId uniqueidentifier 16 null
Companies.CompanyId ProjectPhases_Companies_ForeignKey R
WKT nvarchar 2147483647 null
Geom geometry 2147483647 null
Active bit 1 null
FRef uniqueidentifier 16 null

Table contained 32 rows

Indexes

Constraint Name Type Sort Column(s)
ProjectPhases_PrimaryKey Primary key Asc PhaseId
ProjectPhases_FRef_Index Performance Asc FRef
ProjectPhases_PhaseCompanyId_Index Performance Asc PhaseCompanyId
ProjectPhases_PhaseId_Index Performance Asc PhaseId
ProjectPhases_ProjectId_Index Performance Asc ProjectId

Relationships