Strata


Columns

Column Type Size Nulls Auto Default Children Parents Comments
PointId uniqueidentifier 16 null
Points.PointId Strata_Points_ForeignKey C
StratumId uniqueidentifier 16 null
qryStrata.StratumId Implied Constraint R
Interpretation nvarchar 100 null
Interpretations.Interpretation Strata_Interpretations_ForeignKey R
Depth1 real 4 null
Depth2 real 4 null
LayerId uniqueidentifier 16 null
Layers.LayerId Strata_Layers_ForeignKey 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

Table contained 272 rows

Indexes

Constraint Name Type Sort Column(s)
Strata_PrimaryKey Primary key Asc StratumId
Strata_FRef_Index Performance Asc FRef
Strata_FRefLayer_Index Performance Asc FRefLayer
Strata_FRefSeries_Index Performance Asc FRefSeries
Strata_Interpretation_Index Performance Asc Interpretation
Strata_LayerId_Index Performance Asc LayerId
Strata_PointId_Index Performance Asc PointId
Strata_StratumId_Index Performance Asc StratumId

Relationships