test
Tables (7)
comment
- comment_id — bigint — Primary key — NOT NULL
- created_at — datetime — NOT NULL
- member_id — varchar(40) — NOT NULL
- text — text
- task_id — bigint — Foreign key → task.task_id — NOT NULL
milestone
- milestone_id — bigint — Primary key — NOT NULL
- finish_at — datetime
- name — varchar(20) — NOT NULL
- start_at — datetime
- project_id — bigint — Foreign key → project.project_id — NOT NULL
project
- project_id — bigint — Primary key — NOT NULL
- admin_id — varchar(40) — NOT NULL
- created_at — datetime — NOT NULL
- name — varchar(100) — NOT NULL
- status — varchar(20) — NOT NULL
tag
- tag_id — bigint — Primary key — NOT NULL
- name — varchar(20) — NOT NULL
- project_id — bigint — Foreign key → project.project_id — NOT NULL
task
- task_id — bigint — Primary key — NOT NULL
- created_at — datetime — NOT NULL
- text — text
- title — varchar(50) — NOT NULL
- milestone_id — bigint
- project_id — bigint — Foreign key → project.project_id — NOT NULL
task_tag
- task_id — bigint — Primary key — NOT NULL
- tag_id — bigint — Foreign key → tag.tag_id — NOT NULL
team
- team_id — bigint — Primary key — NOT NULL
- member_id — varchar(40) — NOT NULL
- role — varchar(10) — NOT NULL
- project_id — bigint — Foreign key → project.project_id — NOT NULL