todo

Tables (3)

task_lists

  • id — UUID — Primary key — NOT NULL
  • owner_id — UUID — Foreign key → users.id — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • list_type — VARCHAR(20) — NOT NULL
  • sort_order — BIGINT — NOT NULL
  • archived_at — TIMESTAMPTZ
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

tasks

  • id — UUID — Primary key — NOT NULL
  • owner_id — UUID — Foreign key → users.id — NOT NULL
  • list_id — UUID — Foreign key → task_lists.id — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • description — TEXT
  • status — VARCHAR(20) — NOT NULL
  • priority — SMALLINT — NOT NULL
  • planned_on — DATE
  • due_on — DATE
  • due_at — TIMESTAMPTZ
  • completed_at — TIMESTAMPTZ
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

users

  • id — UUID — Primary key — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • password_hash — VARCHAR(255) — NOT NULL
  • display_name — VARCHAR(100) — NOT NULL
  • timezone — VARCHAR(64) — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL