drops
1 row where troupe_id = 51
This data as json, CSV (advanced)
Suggested facets: date (date)
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "drops" (
id INTEGER PRIMARY KEY AUTOINCREMENT,
troupe_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 (troupe_id) REFERENCES "troupes"(id)
);