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