From beb52c4a2ca23f29dc992e145810a47241c7d43b Mon Sep 17 00:00:00 2001 From: Anders Betts Date: Sat, 19 Sep 2026 21:10:54 +0200 Subject: årsredovisning: Information om året per räkenskapsår (schema v6) MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit --- docs/SCHEMA.md | 16 ++++++++++++++++ 1 file changed, 16 insertions(+) (limited to 'docs/SCHEMA.md') diff --git a/docs/SCHEMA.md b/docs/SCHEMA.md index 4fc4397..2100990 100644 --- a/docs/SCHEMA.md +++ b/docs/SCHEMA.md @@ -68,6 +68,8 @@ CREATE TABLE orgs ( country TEXT NOT NULL DEFAULT 'SE', email TEXT, phone TEXT, + description TEXT NOT NULL DEFAULT '', -- verksamhetsbeskrivning + shares INTEGER NOT NULL DEFAULT 0,-- antal aktier fiscal_year_start_month INTEGER NOT NULL DEFAULT 1 CHECK (fiscal_year_start_month BETWEEN 1 AND 12), moms_period TEXT NOT NULL DEFAULT 'month' CHECK (moms_period IN ('month','quarter','year')), framework TEXT NOT NULL DEFAULT 'K2' CHECK (framework IN ('K2','K3')), @@ -86,6 +88,15 @@ CREATE TABLE users ( disabled_at TEXT ) STRICT; +CREATE TABLE board_members ( -- signatures in the årsredovisning + org_id INTEGER NOT NULL REFERENCES orgs(id), + id INTEGER PRIMARY KEY, + name TEXT NOT NULL, + title TEXT NOT NULL, -- "Styrelseledamot", "Ordförande", … + created_at TEXT NOT NULL, + UNIQUE (org_id, id) +) STRICT; + CREATE TABLE memberships ( org_id INTEGER NOT NULL REFERENCES orgs(id), user_id INTEGER NOT NULL REFERENCES users(id), @@ -149,6 +160,11 @@ CREATE TABLE fiscal_years ( status TEXT NOT NULL DEFAULT 'open' CHECK (status IN ('open','closed')), locked_until TEXT, -- inclusive last locked date dividend_ore INTEGER NOT NULL DEFAULT 0, -- board's proposed dividend + events TEXT NOT NULL DEFAULT '', -- väsentliga händelser (årsredovisning) + agm_date TEXT NOT NULL DEFAULT '', -- årsstämmodatum (YYYY-MM-DD) + dividend_date TEXT NOT NULL DEFAULT '', -- utbetalningsdatum (YYYY-MM-DD) + employees TEXT NOT NULL DEFAULT '', -- medelantal anställda + notes TEXT NOT NULL DEFAULT '', -- övriga upplysningar (t.ex. revisor) created_at TEXT NOT NULL, closed_at TEXT, closed_by INTEGER REFERENCES users(id), -- cgit v1.3