passages
1 row where client_id = 10
This data as json, CSV (advanced)
Suggested facets: date (date)
| id ▼ | client_id | date | paye | montant | note | moyen_paiement | statut |
|---|---|---|---|---|---|---|---|
| 17 | 10 10 | 2026-03-17 | 1 | 30.0 | 17h00-17h30 (30 min) | Cash | effectué |
Advanced export
JSON shape: default, array, newline-delimited, object
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)
);