DataBase

테이블 설명

• users: 사용자 정보 테이블
• issues: 이슈트래커 이슈 정보 테이블
• labels: 이슈의 특징을 나타내는 레이블 테이블
• milestones: 이슈의 진행도를 나타내는 마일스톤 테이블
• comments: 이슈 댓글 정보 테이블

Table users as U {
  id int [pk, increment] // auto-increment
  user_id varchar
  password varchar
  name varchar
  profile varchar
}

Table issues as I {
  id int [pk, increment] // auto-increment
  issue_number int
  title varchar
  content varchar
  is_open tinyint
  user_id int
  milestone_id int
}

Table labels as L {
  id int [pk, increment] // auto-increment
  name varchar
  color varchar
  description varchar
}

Table milestones as M {
  id int [pk, increment] // auto-increment
  name varchar
  date date
  description varchar
  is_open tinyint
}

Table comments as C {
  id int [pk, increment] // auto-increment
  content varchar
  user_id varchar
  issue_id varchar
  created_at datetime
  updated_at datetime
}



Ref: "issues"."user_id" < "users"."id"

Ref: "issues"."milestone_id" < "milestones"."id"

Ref: "comments"."issue_id" < "issues"."id"

Table issue_assigned {
  issue_id int
  assigned_id int
}

Table issue_label {
  issue_id int
  label_id int
}

Ref: "users"."id" < "issue_assigned"."assigned_id"

Ref: "issue_assigned"."issue_id" < "issues"."id"

Ref: "labels"."id" < "issue_label"."label_id"

Ref: "issues"."id" < "issue_label"."issue_id"