SchemaSpy Analysis of qwat.qwat_sys - Columns Generated by
SchemaSpy
Generated by SchemaSpy on mar. mars 21 17:52 CET 2017
Legend: SourceForge.net
Primary key columns
Columns with indexes
 

qwat.qwat_sys contains 30 columns - click on heading to sort:
Table Column Type Size Nulls Auto Default Comments
logged_actions event_id bigserial 19  √  nextval('qwat_sys.logged_actions_event_id_seq'::regclass) Unique identifier for each auditable event
settings id serial 10  √  nextval('qwat_sys.settings_id_seq'::regclass)
versions id serial 10  √  nextval('qwat_sys.versions_id_seq'::regclass)
logged_actions action text 2147483647 Action type; I = insert, D = delete, U = update, T = truncate
logged_actions action_tstamp_clk timestamptz 35,6 Wall clock time at which audited event's trigger call occurred
logged_actions action_tstamp_stm timestamptz 35,6 Statement start timestamp for tx in which audited event occurred
logged_actions action_tstamp_tx timestamptz 35,6 Transaction start timestamp for tx in which audited event occurred
logged_actions application_name text 2147483647  √  null Application name set when this audit event occurred. Can be changed in-session by client.
logged_actions changed_fields hstore 2147483647  √  null New values of fields changed by UPDATE. Null except for row-level UPDATE events.
logged_actions client_addr inet 2147483647  √  null IP address of client that issued query. Null for unix domain socket.
logged_actions client_port int4 10  √  null Remote peer IP port address of client that issued query. Undefined for unix socket.
logged_actions client_query text 2147483647 Top-level query that caused this auditable event. May be more than one statement.
settings description text 2147483647  √  null
versions module varchar 2147483647  √  null
settings name varchar 30  √  null
logged_relations relation_name text 2147483647 Relation (table or view) name (with schema if needed)
logged_actions relid oid 10 Table OID. Changes with drop/create. Get with 'tablename'::regclass
logged_actions 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.
logged_actions schema_name text 2147483647 Database schema audited table for this event is in
logged_actions session_user_name text 2147483647  √  null Login / session user whose statement caused the audited event
logged_actions statement_only bool 1 't' if audit event is from an FOR EACH STATEMENT trigger, 'f' for FOR EACH ROW
logged_actions table_name text 2147483647 Non-schema-qualified table name of table event occured in
logged_actions transaction_id int8 19  √  null Identifier of transaction that made the change. May wrap, but unique paired with action_tstamp_tx.
settings type regtype 2147483647  √  null
logged_relations uid_column text 2147483647 Name of a column that is used to uniquely identify a row in the relation
settings v_max float8 17,17  √  null
settings v_min float8 17,17  √  null
settings v_not_null bool 1  √  true
settings value text 2147483647  √  null
versions version varchar 2147483647  √  null