transactions.md

CREATE TABLE transactions (
    id BIGSERIAL PRIMARY KEY,
    account_number VARCHAR(20) NOT NULL,
    amount NUMERIC(15,2) NOT NULL,
    type VARCHAR(10) CHECK (type IN ('CREDIT', 'DEBIT')),
    status VARCHAR(15),
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);