dooray

Tables (8)

comment

  • comment_id — BIGINT — Primary key — NOT NULL
  • content — TEXT — NOT NULL
  • project_id — BIGINT — Foreign key → project.project_id — NOT NULL
  • user_id — VARCHAR(50) — Foreign key → user.user_id — NOT NULL
  • task_id — BIGINT — Foreign key → task.task_id — NOT NULL

milestone

  • milestone_id — BIGINT — Primary key — NOT NULL
  • project_id — BIGINT — Foreign key → project.project_id — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • description — TEXT

project

  • project_id — BIGINT — Primary key — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • status — ENUM('ACTIVE', 'DORMANT', 'TERMINATED') — NOT NULL

project_member

  • project_id — BIGINT — Foreign key → project.project_id — NOT NULL
  • user_id — VARCHAR(50) — Foreign key → user.user_id — NOT NULL
  • role — ENUM('ADMIN', 'MEMBER') — NOT NULL

tag

  • tag_id — BIGINT — Primary key — NOT NULL
  • project_id — BIGINT — Foreign key → project.project_id — NOT NULL
  • name — VARCHAR(50) — NOT NULL

task

  • task_id — BIGINT — Primary key — NOT NULL
  • project_id — BIGINT — Foreign key → project.project_id — NOT NULL
  • milestone_id — BIGINT
  • title — VARCHAR(200) — NOT NULL
  • content — TEXT
  • user_id — VARCHAR(50) — Foreign key → user.user_id — NOT NULL

task_tag

  • tag_id — BIGINT — Foreign key → tag.tag_id — NOT NULL
  • task_id — BIGINT — Foreign key → task.task_id — NOT NULL

user

  • user_id — VARCHAR(50) — Primary key — NOT NULL
  • name — VARCHAR(50) — NOT NULL
  • email — VARCHAR(100) — NOT NULL