transactions

Data license: Intern · Data source: PayPal CSV + PDF-Belege

11,369 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: source, type, created_at, date (date), created_at (date)

Next page

CREATE TABLE transactions (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    source TEXT NOT NULL CHECK(source IN ('paypal','bank','manual')),
    date TEXT NOT NULL,
    amount REAL NOT NULL,
    currency TEXT DEFAULT 'EUR',
    type TEXT CHECK(type IN ('income','expense','transfer','refund')),
    counterparty TEXT,
    description TEXT,
    reference TEXT,
    transaction_id TEXT,
    raw_json TEXT,
    matched INTEGER DEFAULT 0,
    created_at TEXT DEFAULT (datetime('now'))
);
CREATE INDEX idx_tx_date ON transactions(date);
CREATE INDEX idx_tx_amount ON transactions(amount);
CREATE INDEX idx_tx_counterparty ON transactions(counterparty);
CREATE INDEX idx_tx_source ON transactions(source);