ws_audit_psector_arc_traceability - Giswater/giswater_dbmodel GitHub Wiki

---

Description:

Traceability table where information about arcs of executed or canceled psectors are stored. In the first rows you can find information from plan_psector_x_arc and after that an exact copy of the arc table.

Features on that table no longer exists on inventroy tables.

Node fields:

Column name	Data type	Description
id	serial4	Id (automatically assigned on insert)
psector_id	int4	Id of psector
psector_state	int2	State of the element on the psector (0 or 1)
doable	bool	Copy of the element's doable value from plan_psector_x_arc
addparam	json	Copy of the element's addparam value from plan_psector_x_arc
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