# Pastebin egMvfJ6n
CREATE TABLE oauth.code (
    id              INTEGER GENERATED ALWAYS AS IDENTITY NOT NULL, -- PK
    user_id         INTEGER NOT NULL, -- FK, user
    client_id       INTEGER NOT NULL, -- FK, client
    code            TEXT NOT NULL UNIQUE,
    redirect_uri    TEXT NOT NULL,
    response_type   TEXT NOT NULL,
    scopes          INTEGER[] NOT NULL,
    code_challenge  TEXT,
    code_challenge_method TEXT,
    granted_at      TIMESTAMP WITHOUT TIME ZONE NOT NULL
);