qryClassificationTests


Columns

Column Type Size Nulls Auto Default Children Parents Comments
SampleId uniqueidentifier 16 null
TestId uniqueidentifier 16 null
Distance real 4 null
LengthTest real 4 null
Diameter real 4 null
Volume real 4 null
SpecRef nvarchar 40 null
Description nvarchar 510 null
MC real 4 null
MCEstim real 4 null
UW real 4 null
UWCalc real 4 null
UWD real 4 null
BDen real 4 null
BDenCalc real 4 null
BDenD real 4 null
E real 4 null
ECalc real 4 null
N real 4 null
SR real 4 null
WMSAM real 4 null
WDSAM real 4 null
WTareNo nvarchar 20 null
WTARE real 4 null
WMSAMAIR real 4 null
WMSAMSUBM real 4 null
WTAREAIR real 4 null
WTARESUBM real 4 null
UWTemp real 4 null
Plastic nvarchar 20 null
WL real 4 null
WP real 4 null
WS real 4 null
IP real 4 null
IF real 4 null
IL real 4 null
IT real 4 null
CR real 4 null
IA real 4 null
DS real 4 null
DSEstim real 4 null
DSType nvarchar 2 null
Pycnometer nvarchar 100 null
Pycnometers.Pycnometer Implied Constraint R
MP real 4 null
MS real 4 null
MPS real 4 null
MPWS real 4 null
DSTemp real 4 null
DSTARE real 4 null
CA real 4 null
CACode nvarchar 20 null
CAMethod nvarchar 2 null
CAType nvarchar 2 null
MS1 real 4 null
MT1 real 4 null
MS2 real 4 null
MT2 real 4 null
NAOH real 4 null
HCL real 4 null
N1 real 4 null
N2 real 4 null
CL real 4 null
ORGC real 4 null
ORGCR real 4 null
ORGWSAMB real 4 null
ORGWSAMA real 4 null
ORGTARE real 4 null
Frost nvarchar 20 null
FrostEstim nvarchar 20 null
SE real 4 null
H1 real 4 null
H2 float 8 null
EMin real 4 null
EMax real 4 null
NMin real 4 null
NMax real 4 null
DMin real 4 null
DMax real 4 null
Dr real 4 null
TP nvarchar 2 null
PerK float 8 null
Q real 4 null
T real 4 null
DH real 4 null
PArea real 4 null
PL real 4 null
SArea real 4 null
HI real 4 null
HF real 4 null
tempv real 4 null
S real 4 null
CAttr real 4 null
Chlc real 4 null
PH real 4 null
Phi real 4 null
Eoed real 4 null
TestLayerId uniqueidentifier 16 null
FRef nvarchar 510 null
FRefCom nvarchar 100 null
FRefJob nvarchar 100 null
FRefBor nvarchar 100 null
FRefSam nvarchar 100 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
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
PublicNo nvarchar 100 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
Z2 real 4 null
Depth1 real 4 null
Depth2 real 4 null
Depth real 4 null
Level real 4 null
Length real 4 null
Level1 real 4 null
Level2 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