test
Tables (8)
comments
- id — BIGINT — Primary key
- task_id (id2) — BIGINT — Foreign key → tasks.id
- create_by (id3) — BIGINT — Foreign key → project_members.id
- content — TEXT — NOT NULL
- created_at — TIMESTAMP
milestones
- id — BIGINT — Primary key
- name — VARCHAR(100) — NOT NULL
- status — ENUM(시작전, 진행중, 진행완료)
- created_at — TIMESTAMP
project_members
- id — BIGINT — Primary key
- project_id (id2) — BIGINT(Autoincrement) — Foreign key → projects.id
- user_id (id3) — VARCHAR(100) — Foreign key → users.id
- role — ENUM('MEMBER', 'ADMIN') — NOT NULL
projects
- id — BIGINT(Autoincrement) — Primary key
- name — VARCHAR(100) — NOT NULL
- status — ENUM('ACTIVE', 'SLEEP', 'CLOSED')
- created_at — TIMESTAMP
tags
- id — BIGINT — Primary key
- name — VARCHAR(50) — NOT NULL
task_tags
- task_tag_id (id) — autoincrement — Primary key — NOT NULL
- task_id (id2) — BIGINT — Foreign key → tasks.id
- tag_id (id3) — BIGINT — Foreign key → tags.id
tasks
- id — BIGINT — Primary key
- project_id (id2) — BIGINT(Autoincrement) — Foreign key → projects.id
- milestone_id (id3) — BIGINT — Foreign key → milestones.id
- created_by (id4) — BIGINT — Foreign key → project_members.id
- title — VARCHAR(200) — NOT NULL
- description — TEXT
- created_at — TIMESTAMP
users
- id — VARCHAR(100) — Primary key
- username — VARCHAR(50) — NOT NULL
- email — VARCHAR(100) — NOT NULL
- created_at — TIMESTAMP