factures

1 row where drop_id = 22

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: date (date), created_at (date)

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));