2022/03/04 DB 스키마 수정

https://dbdiagram.io/d/62240ce254f9ad109a671ed6

dbdiagram.io - Database Relationship Diagrams Design Tool

//// -- LEVEL 1
//// -- Tables and References

// Creating tables
Table Users as U {
  id int [pk] 
  nickname int
  email varchar
  password varchar
  createdAt timestamp
}

Table Posts as p {
  id int [pk, increment]
  userId int
  postTitle varchar
  image img
  postExplian varchar
  totalLike int
  totalComment int
  createdAt timestamp
}

Table Comments as c {
  id int [pk, increment] 
  userId int
  postId int
  comment varchar
  createdAt timestamp
}

Table Hashtags as h {
  id int [pk, increment]
  tagname varchar
}

Table Post_Hashtags as ph {
  postId  int [pk, increment] 
  hashtagId  int [pk, increment] 
}

Table Likes as pl {
  id int [pk, increment] 
  userId int
  postId int
}

Table MusicData as MU {
  id int [pk, increment] 
  musicTitle varchar
  artist varchar
  musicImage img
  musicUrl link
  genre varchar
  
}
Table Post_MusicData as pml {
  postId int [pk, increment] 
  musicDatumId  int [pk, increment] 
}






Ref: "Posts"."id" < "Post_Hashtags"."postId"

Ref: "Hashtags"."id" < "Post_Hashtags"."hashtagId"

Ref: "Posts"."id" < "Likes"."postId"

Ref: "Users"."id" < "Likes"."userId"

Ref: "Posts"."id" < "Post_MusicData"."postId"

Ref: "MusicData"."id" < "Post_MusicData"."musicDatumId"

Ref: "Users"."id" < "Comments"."userId"

Ref: "Posts"."id" < "Comments"."postId"

post테이블에 post title 추가, music data 테이블에 music image 추가

 

2022/03/06 수정 Users에 createAt 칼럼 추가, 다대다 관계 테이블에 primary key 2개로 설정