transactions

3,492 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: category, subtype, bank, source

Next page

CREATE TABLE transactions (
            id INTEGER PRIMARY KEY AUTOINCREMENT,
            tx_date TEXT NOT NULL,
            tx_time TEXT,
            category TEXT NOT NULL,
            amount INTEGER NOT NULL,
            description TEXT,
            note TEXT,
            location TEXT,
            acquirer TEXT,
            subtype TEXT
        , bank TEXT, source TEXT DEFAULT "", gmail_id TEXT DEFAULT "", yahoo_id TEXT DEFAULT "", metadata TEXT DEFAULT "");
CREATE INDEX idx_tx_date ON transactions(tx_date);
CREATE INDEX idx_tx_cat ON transactions(category);
CREATE INDEX idx_gmail ON transactions(gmail_id);
CREATE INDEX idx_yahoo ON transactions(yahoo_id);
CREATE INDEX idx_tx_content_dedup ON transactions(
    tx_date, tx_time, bank, category, amount, description, note
);