Companies


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CompanyId uniqueidentifier 16 null
Initials.CompanyId Initials_Companies_ForeignKey C
Points.ContractorId Points_Companies_ForeignKey R
ProjectPhases.PhaseCompanyId ProjectPhases_Companies_ForeignKey R
Projects.CompanyId Projects_Companies_ForeignKey R
qryAlignments.CompanyId Implied Constraint R
qryAlignmentVertices.CompanyId Implied Constraint R
qryAnalysisAmberValues.CompanyId Implied Constraint R
qryAnalysisRemarks.CompanyId Implied Constraint R
qryAnalysisSamples.CompanyId Implied Constraint R
qryAnalysisValues.CompanyId Implied Constraint R
qryAreas.CompanyId Implied Constraint R
qryAreaVertices.CompanyId Implied Constraint R
qryBackFill.CompanyId Implied Constraint R
qryBrazilianTests.CompanyId Implied Constraint R
qryCasings.CompanyId Implied Constraint R
qryClassificationTestGrainSizes.CompanyId Implied Constraint R
qryClassificationTests.CompanyId Implied Constraint R
qryConsolidationTests.CompanyId Implied Constraint R
qryCPTData.CompanyId Implied Constraint R
qryCPTPush.CompanyId Implied Constraint R
qryCPTSettings.CompanyId Implied Constraint R
qryDocumentItems.CompanyId Implied Constraint R
qryDocumentRevisions.CompanyId Implied Constraint R
qryDocuments.CompanyId Implied Constraint R
qryDPTData.CompanyId Implied Constraint R
qryDrillingObservations.CompanyId Implied Constraint R
qryDSSTests.CompanyId Implied Constraint R
qryEMMTestValues.CompanyId Implied Constraint R
qryFieldLogs.CompanyId Implied Constraint R
qryFissures.CompanyId Implied Constraint R
qryGrainSizes.CompanyId Implied Constraint R
qryGrainSizeTests.CompanyId Implied Constraint R
qryGrainSizeValues.CompanyId Implied Constraint R
qryGrouting.CompanyId Implied Constraint R
qryHoleDiameters.CompanyId Implied Constraint R
qryInclinations.CompanyId Implied Constraint R
qryIndurations.CompanyId Implied Constraint R
qryInjections.CompanyId Implied Constraint R
qryInsituVaneTests.CompanyId Implied Constraint R
qryIntakes.CompanyId Implied Constraint R
qryJackups.CompanyId Implied Constraint R
qryLabVaneTests.CompanyId Implied Constraint R
qryLegPenetrations.CompanyId Implied Constraint R
qryMeasurementData.CompanyId Implied Constraint R
qryMeasurements.CompanyId Implied Constraint R
qryModels.CompanyId Implied Constraint R
qryPenetrationTests.CompanyId Implied Constraint R
qryPlasticityTestValues.CompanyId Implied Constraint R
qryPointLoadTests.CompanyId Implied Constraint R
qryPoints.CompanyId Implied Constraint R
qryPointSummary.CompanyId Implied Constraint R
qryPointSynonyms.CompanyId Implied Constraint R
qryPressuremeterTests.CompanyId Implied Constraint R
qryProctorTests.CompanyId Implied Constraint R
qryProctorTestValues.CompanyId Implied Constraint R
qryProjectPhases.CompanyId Implied Constraint R
qryProjectRights.CompanyId Implied Constraint R
qryProjects.CompanyId Implied Constraint R
qryProjectSummary.CompanyId Implied Constraint R
qryPumpingTests.CompanyId Implied Constraint R
qrySamples.CompanyId Implied Constraint R
qrySamples2.CompanyId Implied Constraint R
qrySectionPoints.CompanyId Implied Constraint R
qrySections.CompanyId Implied Constraint R
qrySelections.CompanyId Implied Constraint R
qryShearBoxTests.CompanyId Implied Constraint R
qrySPTData.CompanyId Implied Constraint R
qryStrata.CompanyId Implied Constraint R
qrySurfaces.CompanyId Implied Constraint R
qrySwellTests.CompanyId Implied Constraint R
qryTriaxialTests.CompanyId Implied Constraint R
qryUCTData.CompanyId Implied Constraint R
qryWaterLevelMps.CompanyId Implied Constraint R
qryWaterLevels.CompanyId Implied Constraint R
qryWaterStrikes.CompanyId Implied Constraint R
qryWaterVolumes.CompanyId Implied Constraint R
Company nvarchar 160 null
Name nvarchar 510 null
JupiterId nvarchar 510 null
Address nvarchar 510 null
Town nvarchar 240 null
Postalcode int 4 null
CompanyType nvarchar 100 null
Active bit 1 null
FRef nvarchar 240 null
FRefCom nvarchar 100 null

Table contained 835 rows

Indexes

Constraint Name Type Sort Column(s)
Companies_PrimaryKey Primary key Asc CompanyId
Companies_CompanyId_Index Performance Asc CompanyId
Companies_FRef_Index Performance Asc FRef
Companies_FRefCom_Index Performance Asc FRefCom

Relationships