-- DROP TABLE IF EXISTS public.event_meta CASCADE;
CREATE TABLE public.event_meta (
    id                  BIGSERIAL PRIMARY KEY,
    user_id             BIGINT NOT NULL REFERENCES public.user(id),
    event_id            BIGINT NOT NULL REFERENCES public.event(id),
    key                 TEXT NOT NULL,
    value               TEXT NOT NULL,
    created_ts          TIMESTAMPTZ NOT NULL DEFAULT NOW(),
    updated_ts          TIMESTAMPTZ NOT NULL DEFAULT NOW()
);
CREATE INDEX idx__public__event_meta__event_id       ON public.event_meta (event_id);
CREATE INDEX idx__public__event_meta__user_id        ON public.event_meta (user_id);
CREATE INDEX idx__public__event_meta__key            ON public.event_meta (key);
CREATE INDEX idx__public__event_meta__value          ON public.event_meta (value);
CREATE INDEX idx__public__event_meta__created_ts     ON public.event_meta (created_ts);
CREATE INDEX idx__public__event_meta__updated_ts     ON public.event_meta (updated_ts);

-- DROP TABLE IF EXISTS public.audit_meta CASCADE;
CREATE TABLE public.audit_meta (
    id                  BIGSERIAL PRIMARY KEY,
    audit_id            BIGINT NOT NULL REFERENCES public.audit(audit_id),
    key                 TEXT NOT NULL,
    value               TEXT NOT NULL,
    created_ts          TIMESTAMPTZ NOT NULL DEFAULT NOW(),
    updated_ts          TIMESTAMPTZ NOT NULL DEFAULT NOW()
);
CREATE INDEX idx__public__audit_meta__audit_id       ON public.audit_meta (audit_id);
CREATE INDEX idx__public__audit_meta__key            ON public.audit_meta (key);
CREATE INDEX idx__public__audit_meta__value          ON public.audit_meta (value);
CREATE INDEX idx__public__audit_meta__created_ts     ON public.audit_meta (created_ts);
CREATE INDEX idx__public__audit_meta__updated_ts     ON public.audit_meta (updated_ts);