provsql.update_provenance TABLE Reference

Table recording the history of INSERT, UPDATE, DELETE, and UNDO operations. More...

Attributes
UUID	provsql
TEXT	query
QUERY_TYPE_ENUM	query_type
TEXT	username
TIMESTAMP	ts
TSTZMULTIRANGE	valid_time

Detailed Description

Table recording the history of INSERT, UPDATE, DELETE, and UNDO operations.

Each row records one provenance-tracked modification, linking the operation's provenance token to metadata (query TEXT, type, user, TIMESTAMP) and the temporal validity range of the affected rows.

Source code

provsql.sql line 1572

Field Documentation

provsql

UUID provsql.update_provenance::provsql

query

TEXT provsql.update_provenance::query

query_type

QUERY_TYPE_ENUM provsql.update_provenance::query_type

ts

TIMESTAMP provsql.update_provenance::ts

username

TEXT provsql.update_provenance::username

valid_time

TSTZMULTIRANGE provsql.update_provenance::valid_time

---

The documentation for this TYPE was generated from the following file:

• /home/pierre/git/software/provsql/sql/provsql.sql