Task_API
Tables (7)
comment
- id — bigint — Primary key — NOT NULL
- task_id — bigint — Foreign key → task.id — NOT NULL
- account_id — bigint — NOT NULL
- content — tinytext — NOT NULL
- created_at — datetime — NOT NULL
milestone
- id — bigint — Primary key — NOT NULL
- project_id — bigint — Foreign key → project.id — NOT NULL
- name — varchar(100) — NOT NULL
project
- id — bigint — Primary key — NOT NULL
- title — varchar(255) — NOT NULL
- state — enum('ACTIVE', 'DORMANT', 'CLOSED') — NOT NULL
- created_at — datetime — NOT NULL
project_member
- id — bigint — Primary key — NOT NULL
- project_id — bigint — Foreign key → project.id — NOT NULL
- account_id — bigint — NOT NULL
- is_admin — tinyint(1) — NOT NULL
- created_at — datetime(6) — NOT NULL
tag
- id — bigint — Primary key — NOT NULL
- project_id — bigint — Foreign key → project.id — NOT NULL
- name — varchar(100) — NOT NULL
task
- id — bigint — Primary key — NOT NULL
- project_id — bigint — Foreign key → project.id — NOT NULL
- milestone_id — bigint — Foreign key → milestone.id
- title — varchar(255) — NOT NULL
- content — tinytext — NOT NULL
- started_at — datetime — NOT NULL
- ended_at — datetime — NOT NULL
- created_at — datetime — NOT NULL
task_tag
- id — bigint — Primary key — NOT NULL
- tag_id — bigint — Foreign key → tag.id — NOT NULL
- task_id — bigint — Foreign key → task.id — NOT NULL