GrainSizes


Columns

Column Type Size Nulls Auto Default Children Parents Comments
SampleId uniqueidentifier 16 null
Samples.SampleId GrainSizes_Samples_ForeignKey C
GrainSizeId uniqueidentifier 16 null
GrainSizeTests.GrainSizeId GrainSizeTests_GrainSizes_ForeignKey C
qryGrainSizes.GrainSizeId Implied Constraint R
qryGrainSizeTests.GrainSizeId Implied Constraint R
qryGrainSizeValues.GrainSizeId Implied Constraint R
Distance real 4 null
SpecRef nvarchar 40 null
D10 real 4 null
D15 real 4 null
D25 real 4 null
D30 real 4 null
D50 real 4 null
D60 real 4 null
D75 real 4 null
D90 real 4 null
UC real 4 null
Clayf real 4 null
Siltf real 4 null
Sandf real 4 null
Gravelf real 4 null
Cobblesf real 4 null
P425 real 4 null
P16 real 4 null
P75 real 4 null
MSand real 4 null
GrainSizeClassId uniqueidentifier 16 null
GrainSizeClassifications.GrainSizeClassId GrainSizes_GrainSizeClassifications_ForeignKey R
Description nvarchar 510 null
TestLayerId uniqueidentifier 16 null
Layers.LayerId GrainSizes_Layers_ForeignKey R
FRefCom nvarchar 100 null
FRefJob nvarchar 100 null
FRefBor nvarchar 100 null
FRefSam nvarchar 100 null

Table contained 0 rows

Indexes

Constraint Name Type Sort Column(s)
GrainSizes_PrimaryKey Primary key Asc GrainSizeId
GrainSizes_FRefBor_Index Performance Asc FRefBor
GrainSizes_FRefCom_Index Performance Asc FRefCom
GrainSizes_FRefJob_Index Performance Asc FRefJob
GrainSizes_FRefSam_Index Performance Asc FRefSam
GrainSizes_GrainSizeClassId_Index Performance Asc GrainSizeClassId
GrainSizes_GrainSizeId_Index Performance Asc GrainSizeId
GrainSizes_SampleId_Index Performance Asc SampleId
GrainSizes_TestLayerId_Index Performance Asc TestLayerId

Relationships