factures
2 rows
This data as json, CSV (advanced)
Suggested facets: date (date), created_at (date)
| id ▼ | troupe_id | numero | date | montant | created_at | drop_id |
|---|---|---|---|---|---|---|
| 1 | 16 | 2026-161 | 2026-04-03 | 80.0 | 2026-04-03 14:16:20 | |
| 2 | 19 | 2026-168 | 2026-04-10 | 25.0 | 2026-04-10 10:11:10 | 22 22 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE factures (id INTEGER PRIMARY KEY AUTOINCREMENT, troupe_id INTEGER NOT NULL, numero TEXT NOT NULL UNIQUE, date TEXT NOT NULL, montant REAL NOT NULL, created_at TEXT DEFAULT (datetime('now')), drop_id INTEGER REFERENCES drops(id));