plan_psector_x_connec - Giswater/giswater_dbmodel GitHub Wiki
Description:
Table of relations between connecs and planification sectors.
Fields:
| Column name | Data type | Description |
|---|---|---|
| id | serial | Id |
| connec_id | character varying(16) | Id of connec included into psector |
| arc_id | character varying(16) | Id of arc to which new connec 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 link, which connects connec with network |
| 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 |