Entity 1. Plan
Version 5.1 by Hyunji Cho on 2022/06/07 11:57
| 1 | PLAN | ||
| Definition | A list of steps with times and RESOURCEs, used to achieve an OBJECTIVE. | ||
| Examples | A local air pollution plan, a national decarbonization action plan. | ||
Fields of entity (Attributes) | Attribute | Description | Type of Data |
| PLAN_ID | Plan code | Integer | |
| Plan Name | Name of plan | Varchar | |
| Plan type | Type of plan | Varchar | |
| ORGANISATION_ID | Organisation (e.g. local authority) published this plan | Integer | |
| Scope of the plan | National plan/regional plan/city plan/ neighbourhood plan | ||
| ADMIN_DIV_ID | The area that this plan is about | Integer | |
| Focus of the plan | Sustainability/ transportation / regeneration.. | Varchar | |
| Timescale | Frequency of plans | Integer | |
| Start Date | This plan starts from.. | Date | |
| End Date | This plan is valid until.. | Date | |
| Status | Active/achieved | Varchar | |
| Documents | Related files attached | Varchar | |
| OBJECTIVE_ID | Objective categorisation of this plan (list of sub-impact area) | Varchar | |
| ORGANISATION_ID | Organisations who participated | Integer | |
| DivAirCity Plan | Yes/No | Boolean | |
| Target area (ha) | Total target area of this plan | Float | |
| NBS_PROJECT_ID | NBS projects that are implemented under this plan | Varchar | |
| Existence of citizen science element | Yes/No | Boolean | |
| Outcomes | Description of the outcomes of this plan | Varchar | |
| Relationships | See below diagram | ||
| Notes | |||
| Usage Example or Sample Data | Air pollution strategy – London – timescale 10 years Diversity action plan – Paris – timescale 5 years | ||