CEDE 8.0 Database Reference
tRoofAttachedStructure Table
AIRReference Database : tRoofAttachedStructure Table
Description

Stores codes that represent types of mechanical and other equipment that is attached to the roof of a building.

The codes are used in the tLocFeature Table.

Properties
Creation Date3/18/2011 4:08 PM
File GroupPRIMARY
Text File Group
System Object
Published for Replication
Rows14
Data Space Used8.00 KB
Index Space Used8.00 KB
Columns
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
Primary Key RoofAttachedStructureCode

Code that represents the equipment attached to the roof.

  • 0 = Unknown/ default
  • 1 = Chimneys
  • 2 = A/C Units
  • 3 = Skylights
  • 4 = Parapet Walls
  • 5 = Overhang/Rake (8-36 in., null)
  • 6 = Dormers
  • 7 = Other
  • 8 = No Attached Structures
  • 9 = Overhang/Rake (< 8 in., null)
  • 10 = Overhang/Rake (> 36 in., null)
  • 11 = Waterproof membrane/fabric
  • 12 = Secondary water resistance - Yes
  • 13 = Secondary water resistance - No
tinyint1   
 RoofAttachedStructure

Name of the equipment attached to the roof.

Corresponds to the code in RoofAttachedStructureCode.

varchar40   
 Description

Description of the equipment attached to the roof.

varchar1024  
See Also

Related Objects

AIRReference Database