ElevationSurface
less than a minute
This table descripes the surface area and prices per color and elevation.
| Name | Type | Size | Description |
|---|---|---|---|
| ElevationId | Long Integer | 4 | FOREIGN KEY refers to Elevations.ElevationID**** |
| ElevationSurfaceID | Long Integer | 4 | PRIMARY KEY |
| PriceIncColor | Bool | 1 | 0 = Price of article not includes color 1 = Price of article includes color |
| SurfaceColor | Text | 255 | Description surface color |
| SurfacePrice | Double | 8 | Price of surface per unit |
| SurfaceTotal | Double | 8 | Sum of surface area |
| SurfaceTotal_Unit | Text | 255 | Surface area unit |
| SurfaceType | Long Integer | 4 | SurfaceType |