Touchstone 2022 Database Reference
tSoilType Table
AIRReference Database : tSoilType Table
Description
Stores the soil types.
Properties
Creation Date2/16/2011 6:00 PM
File GroupPRIMARY
Text File Group
System Object
Published for Replication
Rows11
Data Space Used8.00 KB
Index Space Used8.00 KB
Columns
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
Primary Key 

Code that represents the soil type.

  • 0 = Very Hard Rock
  • 1 = Hard Rock
  • 2 = Firm to Hard Rock
  • 3 = Firm Rock
  • 4 = Soft to Firm Rock (stiff soil)
  • 5 = Soft Rock
  • 6 = Stiff clay and Sandy soil (firm soil)
  • 7 = Soft Soil to Firm Soil
  • 8 = Soft Soil (shallow soil)
  • 9 = Soft Soil
  • 10 = Water
smallint2   
 

Name of the soil type.

Corresponds to the code in SoilTypeCode.

varchar40  
 

Description of the soil type.

varchar1024  
See Also

Related Objects

AIRReference Database