dooray
Tables (8)
comment
- comment_id — BIGINT — Primary key — NOT NULL
- content — TEXT — NOT NULL
- project_id — BIGINT — Foreign key → project.project_id — NOT NULL
- user_id — VARCHAR(50) — Foreign key → user.user_id — NOT NULL
- task_id — BIGINT — Foreign key → task.task_id — NOT NULL
milestone
- milestone_id — BIGINT — Primary key — NOT NULL
- project_id — BIGINT — Foreign key → project.project_id — NOT NULL
- name — VARCHAR(100) — NOT NULL
- description — TEXT
project
- project_id — BIGINT — Primary key — NOT NULL
- name — VARCHAR(100) — NOT NULL
- status — ENUM('ACTIVE', 'DORMANT', 'TERMINATED') — NOT NULL
project_member
- project_id — BIGINT — Foreign key → project.project_id — NOT NULL
- user_id — VARCHAR(50) — Foreign key → user.user_id — NOT NULL
- role — ENUM('ADMIN', 'MEMBER') — NOT NULL
tag
- tag_id — BIGINT — Primary key — NOT NULL
- project_id — BIGINT — Foreign key → project.project_id — NOT NULL
- name — VARCHAR(50) — NOT NULL
task
- task_id — BIGINT — Primary key — NOT NULL
- project_id — BIGINT — Foreign key → project.project_id — NOT NULL
- milestone_id — BIGINT
- title — VARCHAR(200) — NOT NULL
- content — TEXT
- user_id — VARCHAR(50) — Foreign key → user.user_id — NOT NULL
task_tag
- tag_id — BIGINT — Foreign key → tag.tag_id — NOT NULL
- task_id — BIGINT — Foreign key → task.task_id — NOT NULL
user
- user_id — VARCHAR(50) — Primary key — NOT NULL
- name — VARCHAR(50) — NOT NULL
- email — VARCHAR(100) — NOT NULL