mini Dooray

Tables (8)

Comment

  • id — BIGINT
  • task_id — BIGINT — NOT NULL
  • user_id — BIGINT — NOT NULL
  • content — TEXT — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME

MileStone

  • id — BIGINT
  • project_id — BIGINT — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME

Project

  • admin_id — BIGINT — Primary key — NOT NULL
  • id — BIGINT
  • name — VARCHAR(255) — NOT NULL
  • status — ENUM('ACTIVE', 'DORMANT', 'CLOSED') — NOT NULL

ProjectMember

  • id — BIGINT
  • project_id — BIGINT — NOT NULL
  • user_id — BIGINT — NOT NULL
  • created_at — DATETIME — NOT NULL

Tag

  • id — BIGINT
  • project_id — BIGINT — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME

Task

  • id — BIGINT — Primary key
  • admin_id — BIGINT — Foreign key → Project.admin_id — NOT NULL
  • project_id — BIGINT — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • description — TEXT

TaskTag

  • id — BIGINT
  • task_id — BIGINT — NOT NULL
  • tag_id — BIGINT — NOT NULL
  • created_at — DATETIME — NOT NULL

User

  • id — BIGINT — Primary key
  • admin_id — BIGINT — Foreign key → Project.admin_id — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • status — ENUM('ACTIVE', 'INACTIVE', 'DELETED') — NOT NULL