e

Tables (6)

Comment

  • id — BIGINT — Primary key
  • content — TEXT — NOT NULL
  • task_id — BIGINT — Foreign key → Task.task_id
  • member_id — BIGINT — Foreign key → ProjectMember.member_id — NOT NULL

Milestone

  • id — BIGINT — Primary key
  • progress — VARCHAR(255) — NOT NULL
  • project_id — BIGINT — Foreign key → Project.project_id

Project

  • project_id — BIGINT — Primary key
  • name — VARCHAR(255) — NOT NULL
  • status — ENUM('활성', '휴면', '종료') — NOT NULL

ProjectMember

  • member_id — BIGINT — Primary key — NOT NULL
  • project_id — BIGINT — Foreign key → Project.project_id
  • user_id — BIGINT — Foreign key → User.user_id — NOT NULL

Task

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

User

  • user_id — BIGINT — Primary key — NOT NULL
  • id — VARCHAR(255) — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • password — VARCHAR(255)