plan_psector_x_node - Giswater/giswater_dbmodel GitHub Wiki
Description:
Table of relations between nodes and planification sectors.
Fields:
| Column name | Data type | Description |
|---|---|---|
| id | serial | Id |
| node_id | character varying(16) | Id of node included into psector |
| psector_id | integer | Id of psector, defined on plan_psector |
| state | smallint | State of feature inside psector |
| doable | boolean | If true, feature value enters into calculation of psector budget |
| descript | character varying(254) | Description |
| addparam | json | Additional parameter |
| active | boolean | Default will be TRUE, in case of FALSE, the item will not be shown in the inventory with the active psector |
| insert_tstamp | timestamp | Date and time of data insert |
| insert_user | text | User that inserted data |