Projects


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CompanyId uniqueidentifier 16 null
Companies.CompanyId Projects_Companies_ForeignKey R
CompanyName nvarchar 100 null
ProjectId uniqueidentifier 16 null
Alignments.ProjectId Alignments_Projects_ForeignKey C
Areas.ProjectId Areas_Projects_ForeignKey C
CPTSettings.ProjectId CPTSettings_Projects_ForeignKey C
Models.ProjectId Models_Projects_ForeignKey C
Points.ProjectId Points_Projects_ForeignKey C
ProjectPhases.ProjectId ProjectPhases_Projects_ForeignKey C
ProjectRights.ProjectId ProjectRights_Projects_ForeignKey C
ProjectSummary.ProjectId ProjectSummary_Projects_ForeignKey C
qryAlignments.ProjectId Implied Constraint R
qryAlignmentVertices.ProjectId Implied Constraint R
qryAnalysisAmberValues.ProjectId Implied Constraint R
qryAnalysisRemarks.ProjectId Implied Constraint R
qryAnalysisSamples.ProjectId Implied Constraint R
qryAnalysisValues.ProjectId Implied Constraint R
qryAreas.ProjectId Implied Constraint R
qryAreaVertices.ProjectId Implied Constraint R
qryBackFill.ProjectId Implied Constraint R
qryBrazilianTests.ProjectId Implied Constraint R
qryCasings.ProjectId Implied Constraint R
qryClassificationTestGrainSizes.ProjectId Implied Constraint R
qryClassificationTests.ProjectId Implied Constraint R
qryConsolidationTests.ProjectId Implied Constraint R
qryCPTData.ProjectId Implied Constraint R
qryCPTPush.ProjectId Implied Constraint R
qryCPTSettings.ProjectId Implied Constraint R
qryDocumentItems.ProjectId Implied Constraint R
qryDocumentRevisions.ProjectId Implied Constraint R
qryDocuments.ProjectId Implied Constraint R
qryDPTData.ProjectId Implied Constraint R
qryDrillingObservations.ProjectId Implied Constraint R
qryDSSTests.ProjectId Implied Constraint R
qryEMMTestValues.ProjectId Implied Constraint R
qryFieldLogs.ProjectId Implied Constraint R
qryFissures.ProjectId Implied Constraint R
qryGrainSizes.ProjectId Implied Constraint R
qryGrainSizeTests.ProjectId Implied Constraint R
qryGrainSizeValues.ProjectId Implied Constraint R
qryGrouting.ProjectId Implied Constraint R
qryHoleDiameters.ProjectId Implied Constraint R
qryInclinations.ProjectId Implied Constraint R
qryIndurations.ProjectId Implied Constraint R
qryInjections.ProjectId Implied Constraint R
qryInsituVaneTests.ProjectId Implied Constraint R
qryIntakes.ProjectId Implied Constraint R
qryJackups.ProjectId Implied Constraint R
qryLabVaneTests.ProjectId Implied Constraint R
qryLegPenetrations.ProjectId Implied Constraint R
qryMeasurementData.ProjectId Implied Constraint R
qryMeasurements.ProjectId Implied Constraint R
qryModelCells.ProjectId Implied Constraint R
qryModels.ProjectId Implied Constraint R
qryPenetrationTests.ProjectId Implied Constraint R
qryPlasticityTestValues.ProjectId Implied Constraint R
qryPointLoadTests.ProjectId Implied Constraint R
qryPoints.ProjectId Implied Constraint R
qryPointSummary.ProjectId Implied Constraint R
qryPointSynonyms.ProjectId Implied Constraint R
qryPressuremeterTests.ProjectId Implied Constraint R
qryProctorTests.ProjectId Implied Constraint R
qryProctorTestValues.ProjectId Implied Constraint R
qryProjectPhases.ProjectId Implied Constraint R
qryProjectRights.ProjectId Implied Constraint R
qryProjects.ProjectId Implied Constraint R
qryProjectSummary.ProjectId Implied Constraint R
qryPumpingTests.ProjectId Implied Constraint R
qrySamples.ProjectId Implied Constraint R
qrySamples2.ProjectId Implied Constraint R
qrySectionPoints.ProjectId Implied Constraint R
qrySections.ProjectId Implied Constraint R
qrySelectionIds.ProjectId Implied Constraint R
qrySelectionPoints.ProjectId Implied Constraint R
qrySelectionProjects.ProjectId Implied Constraint R
qrySelections.ProjectId Implied Constraint R
qryShearBoxTests.ProjectId Implied Constraint R
qrySPTData.ProjectId Implied Constraint R
qryStrata.ProjectId Implied Constraint R
qrySurfaces.ProjectId Implied Constraint R
qrySwellTests.ProjectId Implied Constraint R
qryTriaxialTests.ProjectId Implied Constraint R
qryUCTData.ProjectId Implied Constraint R
qryWaterLevelMps.ProjectId Implied Constraint R
qryWaterLevels.ProjectId Implied Constraint R
qryWaterStrikes.ProjectId Implied Constraint R
qryWaterVolumes.ProjectId Implied Constraint R
Sections.ProjectId Sections_Projects_ForeignKey C
Selections.ProjectId Implied Constraint R
Strings.ProjectId Strings_Projects_ForeignKey C
Surfaces.ProjectId Surfaces_Projects_ForeignKey C
sProjectId uniqueidentifier 16 null
ProjectNo nvarchar 100 null
ProjectNo2 nvarchar 100 null
ProjectType nvarchar 40 null
Title nvarchar 510 null
LocationId uniqueidentifier 16 null
JupiterId int 4 null
DataOwner nvarchar 40 null
Location nvarchar 100 null
Description1 nvarchar 510 null
Description2 nvarchar 510 null
Description3 nvarchar 2147483647 null
Status nvarchar 100 null
Address nvarchar 240 null
Town nvarchar 240 null
Postalcode nvarchar 40 null
PostalCodes.PostalCode Implied Constraint R
RegionNo int 4 null
Regions.RegionNo Implied Constraint R
Region nvarchar 240 null
MunicipalityNo int 4 null
Municipalities.MunicipalityNo Implied Constraint R
Municipality nvarchar 240 null
MunicipalityNo2 int 4 null
Client nvarchar 240 null
Contractor nvarchar 160 null
Initials1 nvarchar 100 null
Initials2 nvarchar 100 null
Report nvarchar 510 null
Projection1 int 4 null
Projections.Epsg Projects_Projections_ForeignKey R
X1 float 8 null
Y1 float 8 null
Projection2 int 4 null
X2 float 8 null
Y2 float 8 null
XUTM32EUREF89 float 8 null
YUTM32EUREF89 float 8 null
DateStart datetime 16 null
DateEnd datetime 16 null
SyntaxId uniqueidentifier 16 null
Syntaxes.SyntaxId Projects_Syntaxes_ForeignKey R
Interpretation nvarchar 100 null
Interpretations.Interpretation Projects_Interpretations_ForeignKey R
SeriesId uniqueidentifier 16 null
LayerSeries.SeriesId Projects_LayerSeries_ForeignKey R
AutoGenerateStrata bit 1 null
AutoGenerateStrataAtSamples bit 1 null
AutoGenerateStrataIgnoreNoMatch bit 1 null
MaxInterpolationLength real 4 null
Interpretation2 nvarchar 100 null
SeriesId2 uniqueidentifier 16 null
AutoGenerateStrata2 bit 1 null
AutoGenerateStrataAtSamples2 bit 1 null
AutoGenerateStrataIgnoreNoMatch2 bit 1 null
MaxInterpolationLength2 real 4 null
Setup nvarchar 40 null
Setups.Setup Implied Constraint R
LinkId int identity 4 null
Locked bit 1 null
Url nvarchar 510 null
ProjectFolder nvarchar 510 null
Active bit 1 null
Wkt nvarchar 2147483647 null
Geom geometry 2147483647 null
FRef nvarchar 510 null
FRefCom nvarchar 100 null
FRefJob nvarchar 510 null

Table contained 6 rows

Indexes

Constraint Name Type Sort Column(s)
Projects_PrimaryKey Primary key Asc ProjectId
Projects_CompanyId_Index Performance Asc CompanyId
Projects_FRef_Index Performance Asc FRef
Projects_FRefCom_Index Performance Asc FRefCom
Projects_FRefJob_Index Performance Asc FRefJob
Projects_Interpretation_Index Performance Asc Interpretation
Projects_LinkId_Index Performance Asc LinkId
Projects_LinkId_UniqueKey Must be unique Asc LinkId
Projects_MunicipalityNo_Index Performance Asc MunicipalityNo
Projects_Postalcode_Index Performance Asc Postalcode
Projects_ProjectId_Index Performance Asc ProjectId
Projects_Projection1_Index Performance Asc Projection1
Projects_ProjectNo_UniqueKey Must be unique Asc ProjectNo
Projects_RegionNo_Index Performance Asc RegionNo
Projects_SeriesId_Index Performance Asc SeriesId
Projects_SyntaxId_Index Performance Asc SyntaxId

Relationships