SingleElevations
less than a minute
The table SingleElevations stores quite the same information as the table Elevations. If you need one datarow for every piece of elevation, you can use this table.
| Name | Type | Size | Property |
|---|---|---|---|
| Amount | Double | 8 | Always “1” because every elevation has its own row. |
| ElevationGroupId | Long Integer | 4 | FOREIGN KEY refers to ElevationGroups.ElevationGroupID |
| LK_ElevationId | Long Integer | 4 | LOOKUP KEY refers to Elevations.ElevationID |
| OrgAmount | Double | 8 | The original amount of the elevaton. |
| SingleElevationID | Long Integer | 4 | PRIMARY KEY |
| LocationInObject | Text | 255 | Describes where the element is located. |
| FireProtectionUsage | INTEGER | Describes fire protection values.0 = Inside1 = Outside2 = None | |
| … | … | … | All other fields are the same as in the table Elevations . |