uranux_desenv [uranux.xml]

Home

|

Tables

|

Schemas

|

Diagrams

|

Foreign Keys

|

Indexes

---

logged_actions

(Table)

Columns
PK	Name	Data Type	NULLs	A/N	Default	Comment	FK	Unique
	event_id	BigInt			nextval('logged_actions_event_id_seq'::regclass)	Unique identifier for each auditable event
	schema_name	Text				Database schema audited table for this event is in
	table_name	Text				Non-schema-qualified table name of table event occured in
	relid	UniqueID				Table OID. Changes with drop/create. Get with 'tablename'::regclass
	session_user_name	Text				Login / session user whose statement caused the audited event
	action_tstamp_tx	TimeStampWithTimeZone				Transaction start timestamp for tx in which audited event occurred
	action_tstamp_stm	TimeStampWithTimeZone				Statement start timestamp for tx in which audited event occurred
	action_tstamp_clk	TimeStampWithTimeZone				Wall clock time at which audited event's trigger call occurred
	transaction_id	BigInt				Identifier of transaction that made the change. May wrap, but unique paired with action_tstamp_tx.
	application_name	Text				Application name set when this audit event occurred. Can be changed in-session by client.
	client_addr	Inet				IP address of client that issued query. Null for unix domain socket.
	client_port	Integer				Remote peer IP port address of client that issued query. Undefined for unix socket.
	client_query	Text				Top-level query that caused this auditable event. May be more than one statement.
	action	Text				Action type; I = insert, D = delete, U = update, T = truncate
	row_data	hstore				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				New values of fields changed by UPDATE. Null except for row-level UPDATE events.
	statement_only	Boolean				't' if audit event is from an FOR EACH STATEMENT trigger, 'f' for FOR EACH ROW

Indexes
Name	Table	Columns	Unique	Clustered
idx_logged_actions_session_user_name	audit.logged_actions	session_user_name
idx_logged_actions_table_name	audit.logged_actions	table_name
logged_actions_action_idx	audit.logged_actions	action
logged_actions_action_tstamp_tx_stm_idx	audit.logged_actions	action_tstamp_stm
logged_actions_relid_idx	audit.logged_actions	relid
logged_actions_relid_idx_row_data	audit.logged_actions	row_data

Foreign Keys (none)

Parent Relations (none)

Triggers (none)

Used in Diagrams (none)