Development Project Proposals

The development_project_proposals table is an optional table to include in the base year database. This table should be populated for the base year if the user desires to include known future projects. The model will generate this table for future years and include projects from the base year table if it is populated.

 

Column Name Data Type Required Description
proposal_id Integer Y A unique identifier for the record
parcel_id Integer Y The parcel_id of the proposal
template_id Integer Y The corresponding record in the development_templates table
status_id Integer Y The status of the project (1-6): 1 (in active development), 2 (proposed for development), 3 (planned and will be developed), 4 (tentative), 5 (not available), 6 (refused)
start_year Integer Y The year the project is expected to begin
is_redevelopment Integer Y Indicates whether the proposal requires redevelopment (1) or not (0)

 

-- PeterMcNally - 10 Nov 2009

Topic revision: r1 - 10 Nov 2009 - 15:12:17 - PeterMcNally
 
This site is powered by FoswikiCopyright © by the contributing authors. All material on this collaboration platform is the property of the contributing authors.
Ideas, requests, problems regarding Foswiki? Send feedback