CREATE TABLE transactions (
        id SERIAL,
        transaction_id VARCHAR(50) NOT NULL,
        account_id VARCHAR(50) NOT NULL,
        type VARCHAR(50) NOT NULL,
        channel VARCHAR(8) NOT NULL,
        created_at timestamp with time zone DEFAULT now(),
        updated_at timestamp with time zone DEFAULT now()
);
ALTER TABLE ONLY transactions
    ADD CONSTRAINT transactions_id_key UNIQUE (id);