plan_psector_x_gully - Giswater/giswater_dbmodel GitHub Wiki
Description:
Table of relations between gullies and planification sectors.
Fields:
| Column name | Data type | Description | Example |
|---|---|---|---|
| id | serial | Id | |
| gully_id | character varying(16) | Id of gully included into psector | |
| arc_id | character varying(16) | Id of arc to which new gully is connected | |
| 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 | |
| vnode_geom | geometry(Point,SRID) | Point geometry of vnode, final point of link | |
| link_id | integer | Id of the related link | |
| active | boolean | If true, catalog value is being used | |
| insert_tstamp | timestamp | Date and time of data insert | |
| insert_user | text | User of record insertion |