d
Tables (8)
Comment
- id — BIGINT
- content — TEXT — NOT NULL
- task_id — BIGINT — NOT NULL
- user_id — BIGINT — NOT NULL
Milestone
- id — BIGINT
- name — VARCHAR(255) — NOT NULL
- project_id — BIGINT — NOT NULL
Project
- id — BIGINT
- name — VARCHAR(255) — NOT NULL
- status — ENUM('활성', '휴면', '종료') — NOT NULL
- admin_id — BIGINT — NOT NULL
ProjectMember
- id — BIGINT
- project_id — BIGINT — NOT NULL
- user_id — BIGINT — NOT NULL
Tag
- id — BIGINT
- name — VARCHAR(255) — NOT NULL
- project_id — BIGINT — NOT NULL
Task
- id — BIGINT
- title — VARCHAR(255) — NOT NULL
- description — TEXT
- project_id — BIGINT — NOT NULL
- milestone_id — BIGINT
TaskTag
- id — BIGINT
- task_id — BIGINT — NOT NULL
- tag_id — BIGINT — NOT NULL
User
- id — BIGINT
- name — VARCHAR(255) — NOT NULL
- email — VARCHAR(255) — NOT NULL