Layers


Columns

Column Type Size Nulls Auto Default Children Parents Comments
SeriesId uniqueidentifier 16 null
LayerSeries.SeriesId Layers_LayerSeries_ForeignKey C
LayerId uniqueidentifier 16 null
ClassificationTests.TestLayerId ClassificationTests_Layers_ForeignKey R
CPTData.LayerId CPTData_Layers_ForeignKey R
CPTInterpretationLayers.LayerId CPTInterpretationLayers_Layers_ForeignKey R
DPTData.LayerId Implied Constraint R
DrillingObservations.LayerId Implied Constraint R
Fissures.TestLayerId Fissures_Layers_ForeignKey R
GrainSizes.TestLayerId GrainSizes_Layers_ForeignKey R
Indurations.TestLayerId Indurations_Layers_ForeignKey R
InsituVaneTests.LayerId InsituVaneTests_Layers_ForeignKey R
Intakes.LayerId Intakes_Layers_ForeignKey R
LabVaneTests.TestLayerId LabVaneTests_Layers_ForeignKey R
ModelCells.LayerId ModelCells_Layers_ForeignKey R
PenetrationTests.LayerId PenetrationTests_Layers_ForeignKey R
PointLoadTests.TestLayerId PointLoadTests_Layers_ForeignKey R
PointSummary.LayerId PointSummary_Layers_ForeignKey R
PressuremeterTests.LayerId PressuremeterTests_Layers_ForeignKey R
ProctorTests.TestLayerId ProctorTests_Layers_ForeignKey R
ProjectSummary.LayerId Implied Constraint R
qryAnalysisSamples.LayerId Implied Constraint R
qryAnalysisValues.LayerId Implied Constraint R
qryBrazilianTests.LayerId Implied Constraint R
qryClassificationTestGrainSizes.LayerId Implied Constraint R
qryClassificationTests.LayerId Implied Constraint R
qryConsolidationTests.LayerId Implied Constraint R
qryCPTData.LayerId Implied Constraint R
qryCPTInterpretationLayers.LayerId Implied Constraint R
qryCPTInterpretationValues.LayerId Implied Constraint R
qryDocumentItems.LayerId Implied Constraint R
qryDPTData.LayerId Implied Constraint R
qryDrillingObservations.LayerId Implied Constraint R
qryDSSTests.LayerId Implied Constraint R
qryFissures.LayerId Implied Constraint R
qryGrainSizes.LayerId Implied Constraint R
qryIndurations.LayerId Implied Constraint R
qryInsituVaneTests.LayerId Implied Constraint R
qryIntakes.LayerId Implied Constraint R
qryLabVaneTests.LayerId Implied Constraint R
qryLayers.LayerId Implied Constraint R
qryModelCells.LayerId Implied Constraint R
qryPenetrationTests.LayerId Implied Constraint R
qryPointLoadTests.LayerId Implied Constraint R
qryPointSummary.LayerId Implied Constraint R
qryPressuremeterTests.LayerId Implied Constraint R
qryProctorTests.LayerId Implied Constraint R
qryProjectSummary.LayerId Implied Constraint R
qrySamples.LayerId Implied Constraint R
qrySamples2.LayerId Implied Constraint R
qryShearBoxTests.LayerId Implied Constraint R
qrySPTData.LayerId Implied Constraint R
qryStrata.LayerId Implied Constraint R
qrySurfaces.LayerId Implied Constraint R
qrySwellTests.LayerId Implied Constraint R
qryTriaxialTests.LayerId Implied Constraint R
qryUCTData.LayerId Implied Constraint R
Samples.LayerId Samples_Layers_ForeignKey R
SPTData.LayerId SPTData_Layers_ForeignKey R
Strata.LayerId Strata_Layers_ForeignKey R
Surfaces.LayerId Implied Constraint R
SwellTests.TestLayerId SwellTests_Layers_ForeignKey R
TriaxialTests.TestLayerId TriaxialTests_Layers_ForeignKey R
UCTData.TestLayerId UCTData_Layers_ForeignKey R
Sequence int 4 null
Version.Sequence Implied Constraint R
ZoneNo int 4 null
Layer nvarchar 100 null
Description nvarchar 510 null
SoilTypeId int 4 null
SoilTypes.SoilTypeId Layers_SoilTypes_ForeignKey R
MC real 4 null
BDen real 4 null
UW real 4 null
E real 4 null
DS real 4 null
Search nvarchar 510 null
SearchFrost nvarchar 100 null
SearchCACode nvarchar 100 null
MC1 real 4 null
MC2 real 4 null
C0BE real 4 null
C1BE real 4 null
C2BE real 4 null
ALB real 4 null
BLB real 4 null
ABE real 4 null
BBE real 4 null
AUB real 4 null
BUB real 4 null
NkLB real 4 null
NkBE real 4 null
NkUB real 4 null
Liths nvarchar 2147483647 null
Symbols nvarchar 200 null
SymbolNo int 4 null
Color int 4 null
Active bit 1 null
FRef nvarchar 100 null

Table contained 617 rows

Indexes

Constraint Name Type Sort Column(s)
Layers_PrimaryKey Primary key Asc LayerId
Layers_FRef_Index Performance Asc FRef
Layers_LayerId_Index Performance Asc LayerId
Layers_SeriesId_Index Performance Asc SeriesId

Relationships