plan_psector - Giswater/giswater_dbmodel GitHub Wiki
Description:
Table with basic data of planification sector.
Fields:
| Column name | Data type | Description | Example |
|---|---|---|---|
| psector_id | integer | Id | 1 |
| name | character varying(50) | Name of planification sector | Masterplan 01 |
| psector_type | integer | Type of psector, defined on plan_typevalue as psector_type | Planified |
| descript | text | Description | |
| expl_id | integer | Id of an exploitation, defined on exploitation | |
| priority | character varying(16) | Priority of sector execution, defined on plan_typevalue as value_priority | HIGH_PRIORITY |
| text1 | text | Additional information | |
| text2 | text | Additional information | |
| observ | text | Description | |
| rotation | numeric(8,4) | Rotation of the output report map, used on QGIS composer | 0.0 |
| scale | numeric(8,2) | Scale of the output report map, used on QGIS composer | 750.00 |
| atlas_id | character varying(16) | Atlas identifies, used on QGIS composer | |
| gexpenses | numeric(4,2) | Percentage of overhead | 2.0 |
| vat | numeric(4,2) | VAT value applied on budget calculation | 21.00 |
| other | numeric(4,2) | Percentage of other expenses | |
| active | boolean | If true, sector is being used | |
| the_geom | geometry(MultiPolygon,SRID) | Multi polygon geometry of sector | |
| enable_all | boolean | If true, visualize obsolete state on features related to psector | |
| status | integer | Status of planification sector, defined on plan_typevalue as psector_status | EXECUTED |
| ext_code | character varying(50) | External code of planification | |
| text3 | text | Additional information | |
| text4 | text | Additional information | |
| text5 | text | Additional information | |
| text6 | text | Additional information | |
| num_value | numeric | Additional numeric information | |
| workcat_id | text | ||
| parent_id | integer |