mini Dooray
Tables (8)
Comment
- comment_id — VARCHAR(255) — Primary key — NOT NULL
- content — TEXT — NOT NULL
- task_id — VARCHAR(255) — Foreign key → Task.task_id — NOT NULL
- Key (user_id2) — Foreign key → User.Key — NOT NULL
Member
- member_id — VARCHAR(255) — Primary key — NOT NULL
- project_id — VARCHAR(255) — Foreign key → Project.project_id — NOT NULL
- role — VARCHAR(255) — NOT NULL
- Key (user_id2) — Foreign key → User.Key — NOT NULL
Milestone
- milestone_id — VARCHAR(255) — Primary key — NOT NULL
- name — VARCHAR(255) — NOT NULL
- project_id — VARCHAR(255) — Foreign key → Project.project_id — NOT NULL
Project
- project_id — VARCHAR(255) — Primary key — NOT NULL
- name — VARCHAR(255) — NOT NULL
- status — VARCHAR(255) — NOT NULL
- Key (user_id2) — Foreign key → User.Key — NOT NULL
Tag
- tag_id — VARCHAR(255) — Primary key — NOT NULL
- name — VARCHAR(255) — NOT NULL
- project_id — VARCHAR(255) — Foreign key → Project.project_id — NOT NULL
Task
- task_id — VARCHAR(255) — Primary key — NOT NULL
- title — VARCHAR(255) — NOT NULL
- content — TEXT
- project_id — VARCHAR(255) — Foreign key → Project.project_id — NOT NULL
- milestone_id — VARCHAR(255) — Foreign key → Milestone.milestone_id
Task_Tag
- task_id — VARCHAR(255) — Foreign key → Task.task_id — NOT NULL
- tag_id — VARCHAR(255) — Foreign key → Tag.tag_id — NOT NULL
User
- Key (user_id) — Primary key — NOT NULL
- Field (username)
- Field (email)