budget_semaines

✎ View and edit SQL

This data as json

0 records

CREATE TABLE budget_semaines (
            id INTEGER PRIMARY KEY AUTOINCREMENT,
            mois TEXT NOT NULL,
            semaine INTEGER NOT NULL,
            categorie TEXT NOT NULL,
            montant_budget REAL NOT NULL DEFAULT 0,
            devise TEXT DEFAULT 'CHF',
            UNIQUE(mois, semaine, categorie)
        );