home / vitre

passages

1 row where client_id = 28

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: date (date)

id ▼ client_id date paye montant note moyen_paiement statut
34 28 28 2026-03-19 1 15.0   Cash effectué

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

CREATE TABLE passages (
            id INTEGER PRIMARY KEY AUTOINCREMENT,
            client_id INTEGER NOT NULL,
            date TEXT NOT NULL,
            paye INTEGER DEFAULT 0,
            montant REAL,
            note TEXT, moyen_paiement TEXT, statut TEXT DEFAULT 'effectué',
            FOREIGN KEY (client_id) REFERENCES clients(id)
        );
Powered by Datasette · Queries took 9.6ms