comptes_snapshots

6 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: solde, devise, date (date)

CREATE TABLE comptes_snapshots (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    date TEXT NOT NULL,
    semaine INTEGER NOT NULL,
    annee INTEGER NOT NULL,
    compte_id INTEGER NOT NULL REFERENCES comptes(id),
    solde REAL NOT NULL,
    devise TEXT NOT NULL,
    UNIQUE(date, compte_id)
);