qryGrainSizes


Columns

Column Type Size Nulls Auto Default Children Parents Comments
SampleId uniqueidentifier 16 null
GrainSizeId uniqueidentifier 16 null
GrainSizes.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 Implied Constraint R
Description nvarchar 510 null
TestLayerId uniqueidentifier 16 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
SampleNo nvarchar 40 null
SampleType nvarchar 100 null
SampleDescription nvarchar 2147483647 null
Projection1 int 4 null
X1 float 8 null
Y1 float 8 null
VerticalRefId1 nvarchar 100 null
Z1 real 4 null
Projection2 int 4 null
X2 float 8 null
Y2 float 8 null
VerticalRefId2 nvarchar 100 null
Depth1 real 4 null
Depth2 real 4 null
Length real 4 null
Level1 real 4 null
Level2 real 4 null
Depth real 4 null
Level real 4 null
LayerId uniqueidentifier 16 null
Layers.LayerId Implied Constraint R
Layer nvarchar 100 null
Color int 4 null
LayerId2 uniqueidentifier 16 null
Layer2 nvarchar 100 null
Color2 int 4 null
Active bit 1 null
Locked bit 1 null
LayerTest nvarchar 100 null
ColorTest int 4 null
WKT nvarchar 2147483647 null
Geom geometry 2147483647 null

Table contained 0 rows

Relationships

View Definition


Possibly Referenced Tables/Views