mini Dooray

Tables (8)

Comment

  • comment_id — VARCHAR(255) — Primary key — NOT NULL
  • content — TEXT — NOT NULL
  • task_id — VARCHAR(255) — Foreign key → Task.task_id — NOT NULL
  • Key (user_id2) — Foreign key → User.Key — NOT NULL

Member

  • member_id — VARCHAR(255) — Primary key — NOT NULL
  • project_id — VARCHAR(255) — Foreign key → Project.project_id — NOT NULL
  • role — VARCHAR(255) — NOT NULL
  • Key (user_id2) — Foreign key → User.Key — NOT NULL

Milestone

  • milestone_id — VARCHAR(255) — Primary key — NOT NULL
  • name — VARCHAR(255) — NOT NULL
  • project_id — VARCHAR(255) — Foreign key → Project.project_id — NOT NULL

Project

  • project_id — VARCHAR(255) — Primary key — NOT NULL
  • name — VARCHAR(255) — NOT NULL
  • status — VARCHAR(255) — NOT NULL
  • Key (user_id2) — Foreign key → User.Key — NOT NULL

Tag

  • tag_id — VARCHAR(255) — Primary key — NOT NULL
  • name — VARCHAR(255) — NOT NULL
  • project_id — VARCHAR(255) — Foreign key → Project.project_id — NOT NULL

Task

  • task_id — VARCHAR(255) — Primary key — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • content — TEXT
  • project_id — VARCHAR(255) — Foreign key → Project.project_id — NOT NULL
  • milestone_id — VARCHAR(255) — Foreign key → Milestone.milestone_id

Task_Tag

  • task_id — VARCHAR(255) — Foreign key → Task.task_id — NOT NULL
  • tag_id — VARCHAR(255) — Foreign key → Tag.tag_id — NOT NULL

User

  • Key (user_id) — Primary key — NOT NULL
  • Field (username)
  • Field (email)