qrySamples2


Columns

Column Type Size Nulls Auto Default Children Parents Comments
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
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
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
PointId uniqueidentifier 16 null
Points.PointId Implied Constraint R
SampleId uniqueidentifier 16 null
SampleNo nvarchar 40 null
SampleRef nvarchar 40 null
SampleType nvarchar 100 null
Depth1 real 4 null
Depth2 real 4 null
Length real 4 null
CoreRun real 4 null
CoreLostFromTop bit 1 null
Diameter real 4 null
Recovery real 4 null
RecoverySolid real 4 null
RQD real 4 null
Description nvarchar 2147483647 null
Description2 nvarchar 2147483647 null
Liths nvarchar 2147483647 null
Symbols nvarchar 200 null
Weathering nvarchar 20 null
WaterAbsorption real 4 null
AbrasionValue real 4 null
RockMassRating real 4 null
TestList nvarchar 510 null
LabCompanyId uniqueidentifier 16 null
LabSampleNo nvarchar 100 null
LayerId uniqueidentifier 16 null
Layers.LayerId Implied Constraint R
LayerId2 uniqueidentifier 16 null
EDepth1 real 4 null
EDepth2 real 4 null
JupiterId int 4 null
FRef int 4 null
FRefCom nvarchar 100 null
FRefJob nvarchar 100 null
FRefBor nvarchar 100 null
FRefSeries nvarchar 40 null
FRefLayer nvarchar 40 null
Level1 real 4 null
Level2 real 4 null
Layer nvarchar 100 null
LayerSymbols nvarchar 200 null
Color int 4 null
Layer2 nvarchar 100 null
LayerSymbols2 nvarchar 200 null
Color2 int 4 null
Active bit 1 null
Locked bit 1 null
WKT nvarchar 2147483647 null
Geom geometry 2147483647 null
DefaultLength real 4 null
GenericSampleType nvarchar 100 null
SymbolNo int 4 null

Table contained 0 rows

Relationships

View Definition


Possibly Referenced Tables/Views