spring-trello

테이블 (7)

Board (boards)

  • ID (id) — bigint — 기본 키 — NOT NULL
  • workspaceId (workspace_id) — bigint — 외래 키 → Workspace.ID
  • name — varchar(255) — NOT NULL
  • background — varchar(255) — NOT NULL
  • createdAt (created_at) — datetime(6) — NOT NULL
  • modifiedAt (modified_at) — datetime(6) — NOT NULL

Card (cards)

  • ID (id) — bigint — 기본 키 — NOT NULL
  • listId (list_id) — bigint — 외래 키 → List.ID — NOT NULL
  • managerId (manager_id) — bigint — 외래 키 → User.ID — NOT NULL
  • name — varchar(255) — NOT NULL
  • sequence — bigint — NOT NULL
  • description — varchar(255) — NOT NULL
  • dueDate (due_date) — datetime(6) — NOT NULL
  • createdAt (created_at) — datetime(6) — NOT NULL
  • modifiedAt (modified_at) — datetime(6) — NOT NULL

Comment (comments)

  • ID (id) — bigint — 기본 키 — NOT NULL
  • cardId (card_id) — bigint — 외래 키 → Card.ID — NOT NULL
  • userId (user_id) — bigint — 외래 키 → User.ID — NOT NULL
  • emoji — varchar(255)
  • content — varchar(255) — NOT NULL
  • createdAt (created_at) — datetime(6) — NOT NULL
  • modifiedAt (modified_at) — datetime(6) — NOT NULL

List (lists)

  • ID (id) — bigint — 기본 키 — NOT NULL
  • boardId (board_id) — bigint — 외래 키 → Board.ID — NOT NULL
  • name — varchar(255) — NOT NULL
  • sequence — bigint — NOT NULL
  • createdAt (created_at) — datetime(6) — NOT NULL
  • modifiedAt (modified_at) — datetime(6) — NOT NULL

User (users)

  • ID (id) — bigint — 기본 키 — NOT NULL
  • email — varchar(255) — NOT NULL
  • password — varchar(255) — NOT NULL
  • userRole (user_role) — enum — NOT NULL
  • createdAt (created_at) — datetime(6) — NOT NULL
  • modifiedAt (modified_at) — datetime(6) — NOT NULL

User Workspace 중간테이블 (user_workspace)

  • ID (id) — bigint — 기본 키 — NOT NULL
  • workspaceId (workspace_id) — bigint — 외래 키 → Workspace.ID — NOT NULL
  • userId (user_id) — bigint — 외래 키 → User.ID — NOT NULL
  • createdAt (created_at) — datetime(6) — NOT NULL
  • modifiedAt (modified_at) — datetime(6) — NOT NULL

Workspace (workspace)

  • ID (id) — bigint — 기본 키 — NOT NULL
  • name — varchar(255) — NOT NULL
  • description — varchar(255) — NOT NULL
  • createdAt (created_at) — datetime(6) — NOT NULL
  • modifiedAt (modified_at) — datetime(6) — NOT NULL