admin_category_mappings

152 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: category_id, notes, created_at, updated_at, pattern_type, created_at (date), updated_at (date)

Next page

CREATE TABLE admin_category_mappings (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    vendor_pattern TEXT NOT NULL,
    category_name TEXT NOT NULL, 
    category_id TEXT,
    notes TEXT,
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
, pattern_type TEXT DEFAULT 'payee');