MiniDoorayDb
Tables (8)
Account (mysql1)
- ID (account_id) — INT — Primary key
- username — VARCHAR(255) — NOT NULL
- email — VARCHAR(255) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- status — VARCHAR(50) — NOT NULL
Comment
- ID — INT — Primary key
- ID (task_id) — INT — Foreign key → Task.ID
- ID (member_id) — INT — Foreign key → Member.ID
- content — TEXT — NOT NULL
- created_at — TIMESTAMP
Member
- ID (member_id) — INT — Primary key
- ID (account_id) — INT — Foreign key → Account.ID
- ID (project_id) — INT — Foreign key → Project.ID
Milestone
- ID (milestone_id) — INT — Primary key
- project_id — INT
- name — VARCHAR(255) — NOT NULL
- description — TEXT
Project
- ID (project_id) — INT — Primary key
- name — VARCHAR(255) — NOT NULL
- status — VARCHAR(50) — NOT NULL
- admin_id — INT
Tag
- ID (tag_id) — INT — Primary key
- project_id — INT
- name — VARCHAR(255) — NOT NULL
- description — TEXT
Task
- ID (task_id) — INT — Primary key
- ID (project_id) — INT — Foreign key → Project.ID
- ID (milestone_id) — INT — Foreign key → Milestone.ID
- title — VARCHAR(255) — NOT NULL
- description — TEXT
- status — VARCHAR(50) — NOT NULL
TaskTag
- ID (task_id) — INT — Foreign key → Task.ID
- ID (tag_id) — INT — Foreign key → Tag.ID