#	Column Name	Nullable	Data Type	Max Length	Description
1	event_id		bigint	0	The primary key of this table, which is also a serial field.
2	schema_name		text	0
3	table_name		text	0
4	relid		oid	0
5	session_user_name		text	0
6	application_user_name		text	0
7	action_tstamp_tx		timestamp with time zone	0
8	action_tstamp_stm		timestamp with time zone	0
9	action_tstamp_clk		timestamp with time zone	0
10	transaction_id		bigint	0
11	application_name		text	0
12	client_addr		inet	0
13	client_port		integer	0
14	client_query		text	0
15	action		text	0
16	row_data		hstore	0
17	changed_fields		hstore	0
18	statement_only		boolean	0

Foreign Keys

#	Column Name	Key Name	References

Indices

Index Name	Owner	Access Method	Definition	Description
logged_actions_pkey	postgres	btree	event_id
logged_actions_action_idx	postgres	btree	action
logged_actions_action_tstamp_tx_stm_idx	postgres	btree	action_tstamp_stm
logged_actions_relid_idx	postgres	btree	relid

Check Constraints

Constraint Name	Description
logged_actions_action_check CHECK (action = ANY (ARRAY['I'::text, 'D'::text, 'U'::text, 'T'::text]))

Default Values

#	Column Name	Default
1	event_id	nextval('audit.logged_actions_event_id_seq'::regclass)

Triggers

Trigger Name	Targets	On Event	Timing	Condition	Order	Orientation	Description