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