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