ClassificationTests


Columns

Column Type Size Nulls Auto Default Children Parents Comments
SampleId uniqueidentifier 16 null
Samples.SampleId ClassificationTests_Samples_ForeignKey C
TestId uniqueidentifier 16 null
EMMTestValues.TestId EMMTestValues_ClassificationTests_ForeignKey C
PlasticityTestValues.TestId PlasticityTestValues_ClassificationTests_ForeignKey C
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
Layers.LayerId ClassificationTests_Layers_ForeignKey R
FRef nvarchar 510 null
FRefCom nvarchar 100 null
FRefJob nvarchar 100 null
FRefBor nvarchar 100 null
FRefSam nvarchar 100 null

Table contained 173 rows

Indexes

Constraint Name Type Sort Column(s)
ClassificationTests_PrimaryKey Primary key Asc TestId
ClassificationTests_FRef_Index Performance Asc FRef
ClassificationTests_FRefBor_Index Performance Asc FRefBor
ClassificationTests_FRefCom_Index Performance Asc FRefCom
ClassificationTests_FRefJob_Index Performance Asc FRefJob
ClassificationTests_FRefSam_Index Performance Asc FRefSam
ClassificationTests_SampleId_Index Performance Asc SampleId
ClassificationTests_TestId_Index Performance Asc TestId
ClassificationTests_TestLayerId_Index Performance Asc TestLayerId

Relationships