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