qryGrainSizeTests


Columns

Column Type Size Nulls Auto Default Children Parents Comments
GrainSizeId uniqueidentifier 16 null
GrainSizes.GrainSizeId Implied Constraint R
TestId uniqueidentifier 16 null
TestNo int 4 null
HydrometerId uniqueidentifier 16 null
Hydrometers.HydrometerId Implied Constraint R
Peptisator nvarchar 40 null
SieveId uniqueidentifier 16 null
Sieves.SieveId Implied Constraint 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
CompanyId uniqueidentifier 16 null
Companies.CompanyId Implied Constraint R
Company nvarchar 160 null
ProjectId uniqueidentifier 16 null
Projects.ProjectId Implied Constraint R
ProjectNo nvarchar 100 null
PointId uniqueidentifier 16 null
Points.PointId Implied Constraint R
PointNo nvarchar 160 null
sPointId uniqueidentifier 16 null
sPointNo nvarchar 160 null
PhaseId uniqueidentifier 16 null
ProjectPhases.PhaseId Implied Constraint R
DateEnd datetime 16 null
SampleId uniqueidentifier 16 null
SampleNo nvarchar 40 null
SampleType nvarchar 100 null
SpecRef nvarchar 40 null
Depth1 real 4 null
Depth2 real 4 null
Length real 4 null
Level1 real 4 null
Level2 real 4 null
Distance real 4 null
Depth real 4 null
Level real 4 null
Active bit 1 null
Locked bit 1 null

Table contained 0 rows

Relationships

View Definition


Possibly Referenced Tables/Views