Contents
As of version 0.7 the pgmemento schema consist of 6 log tables and 2 view:
* transaction_log [TABLE]: Stores metadata about transactions
* table_event_log [TABLE]: Stores metadata about table events related to transactions
* row_log [TABLE]: Table for data log
* audit_schema_log [TABLE]: Stores information about audited schemas
* audit_table_log [TABLE]: Stores information about audited tables
* audit_column_log [TABLE]: Stores information about columns of audited tables
* audit_tables [VIEW]: Displays tables currently audited by pgMemento incl. information about the transaction range
* audit_tables_dependency [VIEW]: Lists audited tables in order of their dependencies with each other
The following figure shows how the log tables are referenced with each other:
