Samples


Columns

Column Type Size Nulls Auto Default Children Parents Comments
PointId uniqueidentifier 16 null
Points.PointId Samples_Points_ForeignKey C
SampleId uniqueidentifier 16 null
BrazilianTests.SampleId BrazilianTests_Samples_ForeignKey C
ClassificationTests.SampleId ClassificationTests_Samples_ForeignKey C
ConsolidationTests.SampleId ConsolidationTests_Samples_ForeignKey C
DSSTests.SampleId DSSTests_Samples_ForeignKey C
Fissures.SampleId Fissures_Samples_ForeignKey C
GrainSizes.SampleId GrainSizes_Samples_ForeignKey C
Indurations.SampleId Indurations_Samples_ForeignKey C
LabVaneTests.SampleId LabVaneTests_Samples_ForeignKey C
PointLoadTests.SampleId PointLoadTests_Samples_ForeignKey C
ProctorTests.SampleId ProctorTests_Samples_ForeignKey C
ShearBoxTests.SampleId ShearBoxTests_Samples_ForeignKey C
SwellTests.SampleId SwellTests_Samples_ForeignKey C
TriaxialTests.SampleId TriaxialTests_Samples_ForeignKey C
UCTData.SampleId UCTData_Samples_ForeignKey C
SampleNo nvarchar 40 null
SampleRef nvarchar 40 null
SampleType nvarchar 100 null
Depth1 real 4 null
Depth2 real 4 null
Length real 4 null
CoreRun real 4 null
CoreLostFromTop bit 1 null
Diameter real 4 null
Recovery real 4 null
RecoverySolid real 4 null
RQD real 4 null
Description nvarchar 2147483647 null
Description2 nvarchar 2147483647 null
Liths nvarchar 2147483647 null
Symbols nvarchar 200 null
Weathering nvarchar 20 null
WaterAbsorption real 4 null
AbrasionValue real 4 null
RockMassRating real 4 null
TestList nvarchar 510 null
LabCompanyId uniqueidentifier 16 null
LabSampleNo nvarchar 100 null
LayerId uniqueidentifier 16 null
Layers.LayerId Samples_Layers_ForeignKey R
LayerId2 uniqueidentifier 16 null
EDepth1 real 4 null
EDepth2 real 4 null
JupiterId int 4 null
FRef int 4 null
FRefCom nvarchar 100 null
FRefJob nvarchar 100 null
FRefBor nvarchar 100 null
FRefSeries nvarchar 40 null
FRefLayer nvarchar 40 null

Table contained 393 rows

Indexes

Constraint Name Type Sort Column(s)
Samples_PrimaryKey Primary key Asc SampleId
Samples_FRef_Index Performance Asc FRef
Samples_FRefBor_Index Performance Asc FRefBor
Samples_FRefCom_Index Performance Asc FRefCom
Samples_FRefJob_Index Performance Asc FRefJob
Samples_FRefLayer_Index Performance Asc FRefLayer
Samples_FRefSeries_Index Performance Asc FRefSeries
Samples_LayerId_Index Performance Asc LayerId
Samples_PointId_Index Performance Asc PointId
Samples_SampleId_Index Performance Asc SampleId
Samples_SampleNo_Index Performance Asc SampleNo
Samples_SampleType_Index Performance Asc SampleType

Relationships