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