Our solution: tables
CREATE TABLE audit ( audit_id SERIAL PRIMARY KEY, timestamp TIMESTAMPTZ NOT NULL DEFAULT CURRENT_TIMESTAMP, app_user_id INTEGER, -- would link to app_user table audit_type_id INTEGER -- would link to audit_type table );
CREATE TABLE audit ( audit_id SERIAL PRIMARY KEY, timestamp TIMESTAMPTZ NOT NULL DEFAULT CURRENT_TIMESTAMP, app_user_id INTEGER, -- would link to app_user table audit_type_id INTEGER -- would link to audit_type table );