passages
1 row where client_id = 8
This data as json, CSV (advanced)
Suggested facets: date (date)
| id ▼ | client_id | date | paye | montant | note | moyen_paiement | statut |
|---|---|---|---|---|---|---|---|
| 20 | 8 8 | 2026-03-17 | 1 | 40.0 | 17h30-18h00 (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)
);