periodes_financieres
2 rows
This data as json, CSV (advanced)
Suggested facets: date_debut (date), date_fin (date), created_at (date)
| id ▼ | mois | date_debut | date_fin | mouvement_id | montant_declencheur | created_at |
|---|---|---|---|---|---|---|
| 1 | 2026-03 | 2026-02-25 | 2026-03-23 11:04 | 1 | 3530.45 | 2026-03-29 13:41:05 |
| 2 | 2026-04 | 2026-03-23 11:05 | 86 | 1900.0 | 2026-03-29 13:41:05 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE periodes_financieres (
id INTEGER PRIMARY KEY AUTOINCREMENT,
mois TEXT UNIQUE NOT NULL,
date_debut TEXT NOT NULL,
date_fin TEXT,
mouvement_id INTEGER,
montant_declencheur REAL,
created_at TEXT DEFAULT (datetime('now'))
);