Table qwat.qwat_sys.logged_actions
History of auditable actions on audited tables, from qwat_sys.if_modified_func()

Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
event_id bigserial 19  √  nextval('qwat_sys.logged_actions_event_id_seq'::regclass) Unique identifier for each auditable event
schema_name text 2147483647 Database schema audited table for this event is in
table_name text 2147483647 Non-schema-qualified table name of table event occured in
relid oid 10 Table OID. Changes with drop/create. Get with 'tablename'::regclass
session_user_name text 2147483647  √  null Login / session user whose statement caused the audited event
action_tstamp_tx timestamptz 35,6 Transaction start timestamp for tx in which audited event occurred
action_tstamp_stm timestamptz 35,6 Statement start timestamp for tx in which audited event occurred
action_tstamp_clk timestamptz 35,6 Wall clock time at which audited event's trigger call occurred
transaction_id int8 19  √  null Identifier of transaction that made the change. May wrap, but unique paired with action_tstamp_tx.
application_name text 2147483647  √  null Application name set when this audit event occurred. Can be changed in-session by client.
client_addr inet 2147483647  √  null IP address of client that issued query. Null for unix domain socket.
client_port int4 10  √  null Remote peer IP port address of client that issued query. Undefined for unix socket.
client_query text 2147483647 Top-level query that caused this auditable event. May be more than one statement.
action text 2147483647 Action type; I = insert, D = delete, U = update, T = truncate
row_data hstore 2147483647  √  null Record value. Null for statement-level trigger. For INSERT this is the new tuple. For DELETE and UPDATE it is the old tuple.
changed_fields hstore 2147483647  √  null New values of fields changed by UPDATE. Null except for row-level UPDATE events.
statement_only bool 1 't' if audit event is from an FOR EACH STATEMENT trigger, 'f' for FOR EACH ROW

Table contained 2 947 rows at mar. mars 21 17:52 CET 2017

Indexes:
Column(s) Type Sort Constraint Name
event_id Primary key Asc logged_actions_pkey
action Performance Asc logged_actions_action_idx
action_tstamp_stm Performance Asc logged_actions_action_tstamp_tx_stm_idx
relid Performance Asc logged_actions_relid_idx