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)