V1__init.sql

CREATE TABLE payments_view (
    id                       UUID PRIMARY KEY,
    merchant_id              VARCHAR(64),
    status                   VARCHAR(32) NOT NULL,
    card_number_last_four    VARCHAR(4),
    expiry_month             INTEGER,
    expiry_year              INTEGER,
    currency                 CHAR(3),
    amount                   INTEGER,
    occurred_at              TIMESTAMPTZ NOT NULL
);

CREATE INDEX payments_view_by_merchant ON payments_view (merchant_id, occurred_at DESC);