asd
Tables (7)
comments
- comment_id — BIGINT — NOT NULL
- comment_content — TEXT — NOT NULL
- task_id — BIGINT — NOT NULL
- account_id — VARCHAR(50) — NOT NULL
milestones
- milestone_id — BIGINT — NOT NULL
- milestone_name — VARCHAR(50) — NOT NULL
- project_id — BIGINT — NOT NULL
project_member
- account_id — VARCHAR(50) — Primary key — NOT NULL
- project_id — BIGINT — Primary key — NOT NULL
projects
- project_id — BIGINT — NOT NULL
- account_id — VARCHAR(50) — NOT NULL
- project_status — VARCHAR(10) — NOT NULL
- project_name — VARCHAR(100) — NOT NULL
- project_explain — VARCHAR(300)
tags
- task_id — BIGINT — Foreign key → task_tag.task_id — NOT NULL
- tag_id — BIGINT — NOT NULL
- tag_name — VARCHAR(12) — NOT NULL
- project_id — BIGINT — NOT NULL
task_tag
- task_id — BIGINT — Foreign key → tasks.task_id — NOT NULL
tasks
- task_id — BIGINT — Primary key — NOT NULL
- task_title — VARCHAR(100) — NOT NULL
- task_content — TEXT — NOT NULL
- project_id — BIGINT — NOT NULL
- milestone_id — BIGINT — NOT NULL
- account_id — VARCHAR(50) — NOT NULL