Wiki source code of Entity 1. Plan
Version 2.1 by Hyunji Cho on 2022/06/07 11:56
Hide last authors
| author | version | line-number | content |
|---|---|---|---|
 |
2.1 | 1 | |**1**|(% colspan="3" %)**PLAN** |
| 2 | |**Definition**|(% colspan="3" %)((( | ||
| 3 | A list of steps with times and RESOURCEs, used to achieve an | ||
 |
1.1 | 4 | |
| |
2.1 | 5 | OBJECTIVE. |
| 6 | ))) | ||
| 7 | |**Examples**|(% colspan="3" %)A local air pollution plan, a national decarbonization action plan. | ||
| 8 | |(% rowspan="20" %)((( | ||
| 9 | **Fields of entity** | ||
| |
1.1 | 10 | |
| |
2.1 | 11 | **(Attributes)** |
| 12 | )))|**Attribute**|**Description**|**Type of Data** | ||
| 13 | |PLAN_ID|Plan code|Integer | ||
| 14 | |Plan Name|Name of plan|Varchar | ||
| 15 | |Plan type|Type of plan|Varchar | ||
| 16 | |ORGANISATION_ID|Organisation (e.g. local authority) published this plan|Integer | ||
| 17 | |Scope of the plan|National plan/regional plan/city plan/ neighbourhood plan| | ||
| 18 | |ADMIN_DIV_ID|The area that this plan is about|Integer | ||
| 19 | |Focus of the plan|Sustainability/ transportation / regeneration..|Varchar | ||
| 20 | |Timescale|Frequency of plans|Integer | ||
| 21 | |Start Date|This plan starts from..|Date | ||
| 22 | |End Date|This plan is valid until..|Date | ||
| 23 | |Status|Active/achieved|Varchar | ||
| 24 | |Documents|Related files attached|Varchar | ||
| 25 | |OBJECTIVE_ID|Objective categorisation of this plan (list of sub-impact area)|Varchar | ||
| 26 | |ORGANISATION_ID|Organisations who participated|Integer | ||
| 27 | |DivAirCity Plan|Yes/No|Boolean | ||
| 28 | |Target area (ha)|Total target area of this plan|Float | ||
| 29 | |NBS_PROJECT_ID|NBS projects that are implemented under this plan|Varchar | ||
| 30 | |Existence of citizen science element|Yes/No|Boolean | ||
| 31 | |Outcomes|Description of the outcomes of this plan|Varchar | ||
| 32 | |**Relationships**|(% colspan="3" %)See below diagram | ||
| 33 | |**Notes**|(% colspan="3" %) | ||
| 34 | |**Usage Example or Sample Data**|(% colspan="3" %)((( | ||
| 35 | Air pollution strategy – London – timescale 10 years | ||
| |
1.1 | 36 | |
| |
2.1 | 37 | Diversity action plan – Paris – timescale 5 years |
| 38 | ))) |
