Development Template Components
The
development_template_components table represents buildings or parts of buildings included in a particular template. The records in this table are combined with the records in the
DevelopmentTemplates table to generate project proposals. By breaking development templates into components, development project templates can be configured as hierarchies or combinations of building blocks, providing a very flexible means of representing a wide variety of development types. Note that the templates can be generated using real or hypothetical data, since they will be compared to regulatory constraints and the size constraints of parcels. This table is roughly equivalent to the development_project_proposal_components table.
| Column Name |
Data Type |
Required |
Description |
| component_id |
Integer |
Y |
A unique identifier for the component |
| template_id |
Integer |
Y |
The id of the corresponding template in the development_template table |
| building_type_id |
Integer |
Y |
The building type id of the component |
| percent_building_sqft |
Integer |
Y |
The percent of the building area the component constitutes |
| construction_cost_per_unit |
Integer |
Y |
The cost of the template per square foot |
| building_sqft_per_unit |
Integer |
|
The square feet per unit for residential buildings |
--
PeterMcNally - 09 Nov 2009