mini

Tables (7)

Comment

  • 댓글id (comment_id) — Primary key
  • 사용자id (user_id) — INT — Foreign key → User.사용자id
  • 댓글내용 (content) — TEXT — NOT NULL
  • 만든시간 (created_at) — DATETIME — NOT NULL
  • 작업id (id2) — INT — Foreign key → Task.작업id
  • 관리자id (manager_id) — INT — Foreign key → Task.관리자id

MileStone

  • 마일스톤id (milestone_id) — DATETIME — Primary key
  • 프로젝트id (project_id2) — INT — Foreign key → Project.프로젝트id
  • 마일스톤이름 (milestone_name) — VARCHAR(255) — NOT NULL
  • 마일스톤 시작 (mileStart)
  • 마일스톤 끝 (mileEnd)

Project

  • 프로젝트id (project_id) — INT — Primary key
  • 관리자id (manager_id) — INT — Foreign key → User.사용자id
  • name — VARCHAR(255) — NOT NULL
  • state — ENUM('active', 'dormant', 'closed') — NOT NULL

Tag

  • 태그id (Tag_id) — INT — Primary key
  • project_id — INT — NOT NULL
  • name — VARCHAR(255) — NOT NULL
  • 프로젝트id (project_id2) — INT — Foreign key → Project.프로젝트id
  • 관리자id (manager_id) — INT — Foreign key → Project.관리자id

Task

  • 작업id (task_id) — INT — Primary key
  • 관리자id (manager_id) — INT — Foreign key → Project.관리자id
  • 제목 (title) — VARCHAR(255) — NOT NULL
  • 업무설명 (description) — TEXT
  • 마일스톤id (milestone_id2) — DATETIME — Foreign key → MileStone.마일스톤id
  • 프로젝트id (project_id) — INT — Foreign key → Project.프로젝트id

TaskTag

  • 태그id (Tag_id) — INT — Foreign key → Tag.태그id
  • 작업id (task_id) — INT — Foreign key → Task.작업id

User

  • 사용자id (user_id) — INT — Primary key
  • email — VARCHAR(255) — NOT NULL
  • password — VARCHAR(255) — NOT NULL