diff options
Diffstat (limited to 'docs/SCHEMA.md')
| -rw-r--r-- | docs/SCHEMA.md | 16 |
1 files changed, 16 insertions, 0 deletions
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), |