Light한 ClickUp
테이블 (7)
projects
- id — BIGINT — 기본 키 — NOT NULL
- workspace_id — BIGINT — 외래 키 → workspaces.id — NOT NULL
- name — VARCHAR(120)
- description — VARCHAR(500)
- created_at — TIMESTAMPTZ
- deleted_at — TIMESTAMPTZ
todo_assignees
- id — BIGINT — 기본 키 — NOT NULL
- todo_id — BIGINT — 외래 키 → todos.id — NOT NULL
- user_id — BIGINT — 외래 키 → users.id — NOT NULL
- created_at — TIMESTAMP
todos
- id — BIGINT — 기본 키 — NOT NULL
- user_id — BIGINT — 외래 키 → users.id — NOT NULL
- title — VARCHAR(200)
- content — TEXT
- order_index — INTEGER
- due_date — TIMESTAMPTZ
- deleted_at — TIMESTAMPTZ
- completed_at (completedAt) — TIMESTAMPTZ
users
- id — BIGINT — 기본 키 — NOT NULL
- name — VARCHAR(200) — NOT NULL
- email — VARCHAR(200) (UNIQUE) — NOT NULL
- password — VARCHAR(255)
workspace_invitations
- id — BIGINT — 기본 키 — NOT NULL
- workspace_id — BIGINT — 외래 키 → workspaces.id — NOT NULL
- user_id — BIGINT — 외래 키 → users.id — NOT NULL
workspace_members
- id — BIGINT — 기본 키 — NOT NULL
- workspace_id — BIGINT — 외래 키 → workspaces.id — NOT NULL
- user_id — BIGINT — 외래 키 → users.id — NOT NULL
- role — VARCHAR(20)
- status — VARCHAR(20)
- joined_at — TIMESTAMPTZ
- status_changed_at — TIMESTAMPTZ
workspaces
- id — BIGINT — 기본 키 — NOT NULL
- ower_user_id (owner_user_id) — BIGINT — 외래 키 → users.id — NOT NULL
- name — VARCHAR(100) — NOT NULL
- description — VARCHAR(500)
- is_personal — BOOLEAN
- deleted_at — TIMESTAMPTZ