passages
1 row where client_id = 14
This data as json, CSV (advanced)
Suggested facets: date (date)
| id ▼ | client_id | date | paye | montant | note | moyen_paiement | statut |
|---|---|---|---|---|---|---|---|
| 23 | 14 14 | 2026-03-18 | 1 | 35.0 | 18h00-19h00 (1h) | 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)
);