GrainSizeTests


Columns

Column Type Size Nulls Auto Default Children Parents Comments
GrainSizeId uniqueidentifier 16 null
GrainSizes.GrainSizeId GrainSizeTests_GrainSizes_ForeignKey C
TestId uniqueidentifier 16 null
GrainSizeValues.TestId GrainSizeValues_GrainSizeTests_ForeignKey C
TestNo int 4 null
HydrometerId uniqueidentifier 16 null
Hydrometers.HydrometerId GrainSizeTests_Hydrometers_ForeignKey R
Peptisator nvarchar 40 null
SieveId uniqueidentifier 16 null
Sieves.SieveId GrainSizeTests_Sieves_ForeignKey R
DW real 4 null
MW real 4 null
MC real 4 null
WMSAM real 4 null
WDSAM real 4 null
WTARE real 4 null
WW real 4 null
WM real 4 null
WP real 4 null
DSEstim real 4 null
CheckSum real 4 null
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)
GrainSizeTests_PrimaryKey Primary key Asc TestId
GrainSizeTests_FRefBor_Index Performance Asc FRefBor
GrainSizeTests_FRefCom_Index Performance Asc FRefCom
GrainSizeTests_FRefJob_Index Performance Asc FRefJob
GrainSizeTests_FRefSam_Index Performance Asc FRefSam
GrainSizeTests_GrainSizeId_Index Performance Asc GrainSizeId
GrainSizeTests_HydrometerId_Index Performance Asc HydrometerId
GrainSizeTests_SieveId_Index Performance Asc SieveId
GrainSizeTests_TestId_Index Performance Asc TestId
GrainSizeTests_TestId_UniqueKey Must be unique Asc TestId

Relationships