ud_audit_psector_gully_traceability - Giswater/giswater_dbmodel GitHub Wiki
Description:
Traceability table where information about gully of executed or canceled psectors are stored. In the first rows you can find information from plan_psector_x_gully and after that an exact copy of the gully table.
Features on that table no longer exists on inventroy tables.
Gully fields:
| Column name | Data type | Description |
|---|---|---|
| id | character serial4 | Id |
| psector_id | int4 | Id of planification sector |
| psector_state | int2 | State of psector |
| doable | bool | If true, feature value enters into calculation of psector budget |
| psector_arc_id | varchar(16) | Id of arc's psector |
| link_id | int4 | Id of link |
| link_the_geom | int4 | |
| audit_tstamp | timestamp | Date and time of audit data insert |
| audit_user | text | User that executed the action of change psector status |
| action | varchar(16) | Establish if the psector was Executed or Canceled |