데이터베이스 다이어그램

Entity-Relationship Diagram

Code For dbdiagram.io

https://dbdiagram.io/d/5f9929ba3a78976d7b797bd8

Table users {
  sid int [pk, increment] // auto-increment
  id varchar
  profile_image_url varchar
  password varchar 
}

Table issues {
  id int [pk, increment] 
  user_sid int [ref: > users.sid]
  issue_content varchar
  issue_name varchar
  created_at timestamp
  milestone_name varchar
  milestone_id int [ref: > milestones.id]
  issue_status varchar
  assignee id
 }
 
Table assignees{
   id int [pk, increment]
   name varchar
 }
 
Table issue_assignees{
   id int [pk, increment]
   assignee_id int [ref:> assignees.id]
   issue_id int [ref:> issues.id]
   
 }
 

Table issue_comments {
  id int [pk, increment] 
  issue_id int [ref: > issues.id]
  comment_id int [ref: > comments.id]
}
 
Table milestones {
  id int [pk]
  milestone_name varchar
  milestone_description varchar
  end_date datetime
}


Table labels {
  id int [pk]
  label_name varchar
  color varchar
  label_description varchar
}

Table issue_labels {
  id int [pk]
  label_name int [ref: > labels.id]
  issue_id int [ref: > issues.id]
}

Table comments {
  id int [pk]
  merchant_id int
  country_code int
  start_date datetime
  end_date datetime
}

Table emojis {
  id int [pk, increment]
  unicode varchar
}

Table comment_emojis{
  id int [ref: > comments.id]
  user_id int [ref: > users.sid]
  emoji_id int [ref: > emojis.id]
}