v_audit_log - birhythm_metabase.public

Columns

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

id

int4

10

√

null

topic

varchar

2147483647

√

null

timestamp

timestamptz

35,6

√

null

end_timestamp

text

2147483647

√

null

user_id

int4

10

√

null

entity_type

text

2147483647

√

null

entity_id

int4

10

√

null

entity_qualified_id

text

2147483647

√

null

details

text

2147483647

√

null

Relationships

Close relationships within degrees of separation

One

View Definition

SELECT id,
        CASE
            WHEN ((topic)::text = 'card-create'::text) THEN 'card-create'::character varying
            WHEN ((topic)::text = 'card-delete'::text) THEN 'card-delete'::character varying
            WHEN ((topic)::text = 'card-update'::text) THEN 'card-update'::character varying
            WHEN ((topic)::text = 'pulse-create'::text) THEN 'subscription-create'::character varying
            WHEN ((topic)::text = 'pulse-delete'::text) THEN 'subscription-delete'::character varying
            ELSE topic
        END AS topic,
    "timestamp",
    NULL::text AS end_timestamp,
    COALESCE(user_id, 0) AS user_id,
    lower((model)::text) AS entity_type,
    model_id AS entity_id,
        CASE
            WHEN ((model)::text = 'Dataset'::text) THEN ('card_'::text || model_id)
            WHEN (model_id IS NULL) THEN NULL::text
            ELSE ((lower((model)::text) || '_'::text) || model_id)
        END AS entity_qualified_id,
    details
   FROM audit_log
  WHERE ((topic)::text <> ALL ((ARRAY['card-read'::character varying, 'card-query'::character varying, 'dashboard-read'::character varying, 'dashboard-query'::character varying, 'table-read'::character varying])::text[]));

Possibly Referenced Tables/Views

audit_log