mouvements

57 rows where source_revenu_id = 3

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: date, montant, compte_id, date (date)

CREATE TABLE "mouvements" (
            id INTEGER PRIMARY KEY AUTOINCREMENT,
            date TEXT NOT NULL,
            montant REAL NOT NULL,
            devise TEXT NOT NULL DEFAULT 'CHF',
            type TEXT NOT NULL DEFAULT 'depense',
            categorie TEXT DEFAULT 'autre',
            compte_id INTEGER REFERENCES comptes(id),
            description TEXT
        , source_revenu TEXT, archived_at TEXT, source_revenu_id INTEGER REFERENCES sources_revenus(id), vitre_passage_id INTEGER);
CREATE UNIQUE INDEX idx_vitre_passage_id ON "mouvements"(vitre_passage_id) WHERE vitre_passage_id IS NOT NULL;