PointSummary


Columns

Column Type Size Nulls Auto Default Children Parents Comments
PointId uniqueidentifier 16 null
Points.PointId PointSummary_Points_ForeignKey C
SummaryId uniqueidentifier 16 null
Depth1 real 4 null
Depth2 real 4 null
LayerId uniqueidentifier 16 null
Layers.LayerId PointSummary_Layers_ForeignKey R
SoilTypeId int 4 null
SoilTypes.SoilTypeId Implied Constraint R
BDen real 4 null
UW real 4 null
RelativeDensityLB float 8 null
RelativeDensityBE float 8 null
RelativeDensityUB float 8 null
FrictionAngleLB float 8 null
FrictionAngleBE float 8 null
FrictionAngleUB float 8 null
UndrainedShearStrengthLB float 8 null
UndrainedShearStrengthBE float 8 null
UndrainedShearStrengthUB float 8 null
SmallStrainShearModulusLB float 8 null
SmallStrainShearModulusBE float 8 null
SmallStrainShearModulusUB float 8 null
EPS50BE float 8 null
EPS50LB float 8 null
EPS50UB float 8 null
Remark nvarchar 2147483647 null
RelativeDensityLB2 float 8 null
RelativeDensityBE2 float 8 null
RelativeDensityUB2 float 8 null
FrictionAngleLB2 float 8 null
FrictionAngleBE2 float 8 null
FrictionAngleUB2 float 8 null
UndrainedShearStrengthLB2 float 8 null
UndrainedShearStrengthBE2 float 8 null
UndrainedShearStrengthUB2 float 8 null
SmallStrainShearModulusLB2 float 8 null
SmallStrainShearModulusBE2 float 8 null
SmallStrainShearModulusUB2 float 8 null
EPS50BE2 float 8 null
EPS50LB2 float 8 null
EPS50UB2 float 8 null

Table contained 0 rows

Indexes

Constraint Name Type Sort Column(s)
PointSummary_PrimaryKey Primary key Asc SummaryId
PointSummary_LayerId_Index Performance Asc LayerId
PointSummary_PointId_Index Performance Asc PointId
PointSummary_SummaryId_Index Performance Asc SummaryId
PointSummary_SummaryId_UniqueKey Must be unique Asc SummaryId

Relationships