ProjectSummary


Columns

Column Type Size Nulls Auto Default Children Parents Comments
ProjectId uniqueidentifier 16 null
Projects.ProjectId ProjectSummary_Projects_ForeignKey C
SummaryId uniqueidentifier 16 null
LayerId uniqueidentifier 16 null
Layers.LayerId Implied Constraint R
SoilTypeId int 4 null
SoilTypes.SoilTypeId Implied Constraint R
MCLB real 4 null
MCBE real 4 null
MCUB real 4 null
BDenLB real 4 null
BDenBE real 4 null
BDenUB real 4 null
UWLB real 4 null
UWBE real 4 null
UWUB real 4 null
DS 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
C0BE real 4 null
C1BE real 4 null
C2BE real 4 null
ALB real 4 null
BLB real 4 null
ABE real 4 null
BBE real 4 null
AUB real 4 null
BUB real 4 null
NkLB real 4 null
NkBE real 4 null
NkUB real 4 null

Table contained 0 rows

Indexes

Constraint Name Type Sort Column(s)
ProjectSummary_PrimaryKey Primary key Asc SummaryId
ProjectSummary_LayerId_Index Performance Asc LayerId
ProjectSummary_ProjectId_Index Performance Asc ProjectId
ProjectSummary_SummaryId_Index Performance Asc SummaryId
ProjectSummary_SummaryId_UniqueKey Must be unique Asc SummaryId

Relationships