mirum2
Tables (6)
Board (보드)
- PK (id) — BIGINT — Primary key — NOT NULL
- FK (user_id) — User.id — Foreign key → Project.PK — NOT NULL
- FK (project_id) — Project.id — Foreign key → Project.FK — NOT NULL
- (name) — VARCHAR
- (updated_at) — DATETIME
Chat (채팅)
- PK (id) — BIGINT — Primary key — NOT NULL
- FK (user_id) — user.id — Foreign key → Task.PK — NOT NULL
- FK (project_id) — project.id — Foreign key → Task.FK — NOT NULL
- FK (board_id) — board.id — Foreign key → Task.FK — NOT NULL
- FK (task_id) — task.id — Foreign key → Task.FK — NOT NULL
- (message) — TEXT
File (결과 파일)
- PK (id) — BIGINT — Primary key — NOT NULL
- FK (user_id) — user.id — Foreign key → Task.PK — NOT NULL
- FK (project_id) — project.id — Foreign key → Task.FK — NOT NULL
- FK (board_id) — board_id — Foreign key → Task.FK — NOT NULL
- FK (task_id) — task_id — Foreign key → Task.FK — NOT NULL
- (file_url) — VARCHAR
- (original_name) — VARCHAR
- (size) — BIGINT
- (created_at)
Project (프로젝트)
- PK (id) — BIGINT — Primary key — NOT NULL
- FK (user_id) — User.id — Foreign key → User.PK — NOT NULL
- (name) — VARCHAR
- Field2 (desctiption) — TEXT
- created_at — DATETIME
Task (작업 카드)
- PK (id) — BIGINT — Primary key — NOT NULL
- FK (user_id) — user.id — Foreign key → Board.PK — NOT NULL
- FK (project_id) — project.id — Foreign key → Board.FK — NOT NULL
- FK (board_id) — board.id — Foreign key → Board.FK — NOT NULL
- (assignee_id) — user.id
- (created_by) — user.id
- (title) — VARCHAR
- (desciption) — TEXT
- (status) — Enum
- (dead_line) — DATETIME
- (created_at) — DATETIME
- (updated_at) — DATETIME
User (유저 속성)
- PK (id) — BIGINT — Primary key — NOT NULL
- (username) — VARCHAR
- (password) — VARCHAR
- (name) — VARCHAR
- (email) — VARCHAR
- (role) — ENUM
- (created_at) — DATETIME
- (updated_at) — DATETIME