qryProjectSummary


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CompanyId uniqueidentifier 16 null
Companies.CompanyId Implied Constraint R
Company nvarchar 160 null
ProjectNo nvarchar 100 null
Title nvarchar 510 null
ProjectId uniqueidentifier 16 null
Projects.ProjectId Implied Constraint R
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
Layer nvarchar 100 null
Color int 4 null
Locked bit 1 null

Table contained 0 rows

Relationships

View Definition


Possibly Referenced Tables/Views