ㅁ
Tables (8)
Comment
- comment_id — INT — Primary key — NOT NULL
- task_id — INT — NOT NULL
- user_id — INT — NOT NULL
- comment_text — TEXT — NOT NULL
- created_at — TIMESTAMP
Milestone
- milestone_id — INT — Primary key — NOT NULL
- milestone_name — VARCHAR(255) — NOT NULL
- project_id — INT — NOT NULL
Project
- project_id — INT — Primary key — NOT NULL
- project_name — VARCHAR(255) — NOT NULL
- status — ENUM('ACTIVE', 'INACTIVE', 'CLOSED') — NOT NULL
ProjectMember
- project_member_id — INT — Primary key — NOT NULL
- project_id — INT — NOT NULL
- user_id — INT — NOT NULL
- is_admin — BOOLEAN — NOT NULL
Tag
- tag_id — INT — Primary key — NOT NULL
- tag_name — VARCHAR(255) — NOT NULL
Task
- task_id — INT — Primary key — NOT NULL
- project_id — INT — NOT NULL
- task_name — VARCHAR(255) — NOT NULL
- description — TEXT
- milestone_id — INT
TaskTag
- task_id — INT — Primary key — NOT NULL
- tag_id — INT — Primary key — NOT NULL
User
- user_id — INT — Primary key — NOT NULL
- username — VARCHAR(255) — NOT NULL