MiniDoorayDb

Tables (8)

Account (mysql1)

  • ID (account_id) — INT — Primary key
  • username — VARCHAR(255) — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • status — VARCHAR(50) — NOT NULL

Comment

  • ID — INT — Primary key
  • ID (task_id) — INT — Foreign key → Task.ID
  • ID (member_id) — INT — Foreign key → Member.ID
  • content — TEXT — NOT NULL
  • created_at — TIMESTAMP

Member

  • ID (member_id) — INT — Primary key
  • ID (account_id) — INT — Foreign key → Account.ID
  • ID (project_id) — INT — Foreign key → Project.ID

Milestone

  • ID (milestone_id) — INT — Primary key
  • project_id — INT
  • name — VARCHAR(255) — NOT NULL
  • description — TEXT

Project

  • ID (project_id) — INT — Primary key
  • name — VARCHAR(255) — NOT NULL
  • status — VARCHAR(50) — NOT NULL
  • admin_id — INT

Tag

  • ID (tag_id) — INT — Primary key
  • project_id — INT
  • name — VARCHAR(255) — NOT NULL
  • description — TEXT

Task

  • ID (task_id) — INT — Primary key
  • ID (project_id) — INT — Foreign key → Project.ID
  • ID (milestone_id) — INT — Foreign key → Milestone.ID
  • title — VARCHAR(255) — NOT NULL
  • description — TEXT
  • status — VARCHAR(50) — NOT NULL

TaskTag

  • ID (task_id) — INT — Foreign key → Task.ID
  • ID (tag_id) — INT — Foreign key → Tag.ID