bookings

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

✎ View and edit SQL

This data as json

0 records

CREATE TABLE bookings (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    date TEXT NOT NULL,
    description TEXT NOT NULL,
    debit_account TEXT,
    credit_account TEXT,
    amount REAL NOT NULL,
    tax_rate REAL DEFAULT 19.0,
    tax_amount REAL,
    booking_text TEXT,
    period TEXT,
    status TEXT DEFAULT 'draft' CHECK(status IN ('draft','booked','paid','cancelled')),
    created_at TEXT DEFAULT (datetime('now'))
);
CREATE INDEX idx_bookings_date ON bookings(date);
CREATE INDEX idx_bookings_status ON bookings(status);