CPTSettings


Columns

Column Type Size Nulls Auto Default Children Parents Comments
ProjectId uniqueidentifier 16 null
Projects.ProjectId CPTSettings_Projects_ForeignKey C
CPTSettingsId uniqueidentifier 16 null
Description nvarchar 510 null
SkipMissingqc bit 1 null
SkipMissingfs bit 1 null
SkipMissingu2 bit 1 null
SkipTop real 4 null
SkipBottom real 4 null
CPTInterpretationId1 uniqueidentifier 16 null
Interpretation1 nvarchar 100 null
CPTInterpretationId2 uniqueidentifier 16 null
CPTInterpretations.CPTInterpretationId CPTSettings_CPTInterpretations_ForeignKey R
Interpretation2 nvarchar 100 null
MinInterpolationLength real 4 null
MaxInterpolationLength real 4 null
CalculateqcMovA bit 1 null
qcMovAInterval real 4 null
qcMovAFactor real 4 null
qcMovAUnSpike bit 1 null
UseqcMovA bit 1 null
CalculatefsMovA bit 1 null
fsMovAInterval real 4 null
fsMovAFactor real 4 null
fsMovAUnSpike bit 1 null
UsefsMovA bit 1 null
Calculateu2MovA bit 1 null
u2MovAInterval real 4 null
u2MovAFactor real 4 null
u2MovAUnSpike bit 1 null
Useu2MovA bit 1 null
SoilTypeId int 4 null
SoilTypes.SoilTypeId Implied Constraint R
g real 4 null
BDen real 4 null
UW real 4 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
RelativeDensityLBExpr nvarchar 2147483647 null
RelativeDensityBEExpr nvarchar 2147483647 null
RelativeDensityUBExpr nvarchar 2147483647 null
FrictionAngleLBExpr nvarchar 2147483647 null
FrictionAngleBEExpr nvarchar 2147483647 null
FrictionAngleUBExpr nvarchar 2147483647 null
UndrainedShearStrengthLBExpr nvarchar 2147483647 null
UndrainedShearStrengthBEExpr nvarchar 2147483647 null
UndrainedShearStrengthUBExpr nvarchar 2147483647 null
SmallStrainShearModulusLBExpr nvarchar 2147483647 null
SmallStrainShearModulusBEExpr nvarchar 2147483647 null
SmallStrainShearModulusUBExpr nvarchar 2147483647 null
EPS50LBExpr nvarchar 2147483647 null
EPS50BEExpr nvarchar 2147483647 null
EPS50UBExpr nvarchar 2147483647 null

Table contained 0 rows

Indexes

Constraint Name Type Sort Column(s)
CPTSettings_PrimaryKey Primary key Asc CPTSettingsId
CPTSettings_CPTSettingsId_Index Performance Asc CPTSettingsId

Relationships