mini Dooray
Tables (8)
Comment
- id — BIGINT
- task_id — BIGINT — NOT NULL
- user_id — BIGINT — NOT NULL
- content — TEXT — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME
MileStone
- id — BIGINT
- project_id — BIGINT — NOT NULL
- name — VARCHAR(100) — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME
Project
- admin_id — BIGINT — Primary key — NOT NULL
- id — BIGINT
- name — VARCHAR(255) — NOT NULL
- status — ENUM('ACTIVE', 'DORMANT', 'CLOSED') — NOT NULL
ProjectMember
- id — BIGINT
- project_id — BIGINT — NOT NULL
- user_id — BIGINT — NOT NULL
- created_at — DATETIME — NOT NULL
Tag
- id — BIGINT
- project_id — BIGINT — NOT NULL
- name — VARCHAR(100) — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME
Task
- id — BIGINT — Primary key
- admin_id — BIGINT — Foreign key → Project.admin_id — NOT NULL
- project_id — BIGINT — NOT NULL
- title — VARCHAR(255) — NOT NULL
- description — TEXT
TaskTag
- id — BIGINT
- task_id — BIGINT — NOT NULL
- tag_id — BIGINT — NOT NULL
- created_at — DATETIME — NOT NULL
User
- id — BIGINT — Primary key
- admin_id — BIGINT — Foreign key → Project.admin_id — NOT NULL
- email — VARCHAR(255) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- status — ENUM('ACTIVE', 'INACTIVE', 'DELETED') — NOT NULL