Shared Expenses

schema.sql 13 lines

CREATE TABLE expenses (
  id INTEGER PRIMARY KEY AUTOINCREMENT,
  cost TEXT NOT NULL CHECK (length(cost) > 0),
  description TEXT NOT NULL,
  details TEXT,
  date TEXT NOT NULL,
  currency_code TEXT NOT NULL CHECK (length(currency_code) = 3),
  group_id INTEGER,
  repeat_interval TEXT NOT NULL DEFAULT 'never' CHECK (repeat_interval IN ('never', 'weekly', 'fortnightly', 'monthly', 'yearly')),
  payment INTEGER NOT NULL DEFAULT 0 CHECK (payment IN (0, 1)),
  created_at TEXT,
  updated_at TEXT
);