qryStrata


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
StratumId uniqueidentifier 16 null
Strata.StratumId Implied Constraint R
Interpretation nvarchar 100 null
Interpretations.Interpretation Implied Constraint R
Depth1 real 4 null
Depth2 real 4 null
LayerId uniqueidentifier 16 null
Layers.LayerId Implied Constraint R
Description nvarchar 2147483647 null
Description2 nvarchar 2147483647 null
Legend nvarchar 40 null
Geology nvarchar 40 null
Geology2 nvarchar 40 null
Formation nvarchar 40 null
Liths nvarchar 2147483647 null
Symbols nvarchar 200 null
MC real 4 null
BDen real 4 null
E real 4 null
DS real 4 null
Frost nvarchar 20 null
Qac nvarchar 8 null
FRef int 4 null
FRefSeries nvarchar 40 null
FRefLayer nvarchar 40 null
Level1 real 4 null
Level2 real 4 null
Interval real 4 null
SeriesId uniqueidentifier 16 null
LayerSeries.SeriesId Implied Constraint R
Layer nvarchar 100 null
ZoneNo int 4 null
LayerDescription nvarchar 510 null
LayerSymbols nvarchar 200 null
SymbolNo int 4 null
Color int 4 null
Active bit 1 null
Locked bit 1 null
WKT nvarchar 2147483647 null
Geom geometry 2147483647 null

Table contained 0 rows

Relationships

View Definition


Possibly Referenced Tables/Views