SchemaSpy Analysis of qwat.qwat_sys - Columns | Generated by SchemaSpy |
Generated by SchemaSpy on mar. mars 21 17:52 CET 2017 |
| ||||||
|
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 | |
logged_actions | statement_only | bool | 1 | 't' if audit event is from an FOR EACH STATEMENT trigger, 'f' for FOR EACH ROW | |||
settings | v_not_null | bool | 1 | √ | true | ||
settings | v_max | float8 | 17,17 | √ | null | ||
settings | v_min | float8 | 17,17 | √ | null | ||
logged_actions | changed_fields | hstore | 2147483647 | √ | null | New values of fields changed by UPDATE. Null except for row-level UPDATE events. | |
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 | 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 | transaction_id | int8 | 19 | √ | null | Identifier of transaction that made the change. May wrap, but unique paired with action_tstamp_tx. | |
logged_actions | relid | oid | 10 | Table OID. Changes with drop/create. Get with 'tablename'::regclass | |||
settings | type | regtype | 2147483647 | √ | null | ||
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 | application_name | text | 2147483647 | √ | null | Application name set when this audit event occurred. Can be changed in-session by client. | |
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 | ||
logged_relations | relation_name | text | 2147483647 | Relation (table or view) name (with schema if needed) | |||
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 | table_name | text | 2147483647 | Non-schema-qualified table name of table event occured in | |||
logged_relations | uid_column | text | 2147483647 | Name of a column that is used to uniquely identify a row in the relation | |||
settings | value | text | 2147483647 | √ | null | ||
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 | |||
settings | name | varchar | 30 | √ | null | ||
versions | module | varchar | 2147483647 | √ | null | ||
versions | version | varchar | 2147483647 | √ | null |