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