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 10558

Field Documentation

◆ provsql

UUID update_provenance::provsql

◆ query

TEXT update_provenance::query

◆ query_type

QUERY_TYPE_ENUM update_provenance::query_type

◆ ts

TIMESTAMP update_provenance::ts

◆ username

TEXT update_provenance::username

◆ valid_time

TSTZMULTIRANGE update_provenance::valid_time

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

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

Attributes