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