dd

Tables (8)

Comment

  • comment_id — INT
  • task_id — INT — NOT NULL
  • user_id — INT — NOT NULL
  • comment_text — TEXT — NOT NULL
  • created_at — TIMESTAMP

Milestone

  • milestone_id — INT
  • milestone_name — VARCHAR(255) — NOT NULL
  • project_id — INT — NOT NULL

Project

  • project_id — INT
  • project_name — VARCHAR(255) — NOT NULL
  • status — ENUM('ACTIVE', 'INACTIVE', 'CLOSED') — NOT NULL

ProjectMember

  • project_member_id — INT
  • project_id — INT — NOT NULL
  • user_id — INT — NOT NULL
  • is_admin — BOOLEAN — NOT NULL

Tag

  • tag_id — INT
  • tag_name — VARCHAR(255) — NOT NULL

Task

  • task_id — INT
  • project_id — INT — NOT NULL
  • task_name — VARCHAR(255) — NOT NULL
  • description — TEXT
  • milestone_id — INT

TaskTag

  • task_id — INT
  • tag_id — INT

User

  • user_id — INT
  • username — VARCHAR(255) — NOT NULL
  • username — VARCHAR(255) — NOT NULL