[프로젝트] 공연 예매 연습 웹 사이트: ERD

// Use DBML to define your database structure

// Docs: https://dbml.dbdiagram.io/docs

Table user {

  user_id bigint [primary key]

  image_id bigint

  nickname varchar

  username varchar

  password varchar

  email varchar

  phone varchar

  birth varchar

  gender varchar

  role varchar

  created_at datetime

  updated_at datetime

}

Table artist {

  artist_id bigint [primary key]

  image_id bigint

  name varchar

  created_at datetime

  updated_at datetime

}

Table concert {

  concert_id bigint [primary key]

  place_id bigint

  artist_id bigint

  image_id bigint

  title varchar

  content varchar

  hits bigint

  opened_ticket_at datetime

  performed_at datetime

  created_at datetime

  updated_at datetime

}

Table place {

  place_id bigint [primary key]

  name varchar

  created_at datetime

  updated_at datetime

}

Table board {

  board_id bigint [primary key]

  name varchar

  created_at datetime

  updated_at datetime

}

Table article {

  article_id bigint [primary key]

  board_id bigint

  user_id bigint

  image_id bigint

  title varchar

  content varchar

  hits bigint

  created_at datetime

  updated_at datetime

}

Table article_comment {

  article_comment_id bigint [primary key]

  article_id bigint  

  user_id bigint

  content varchar

  created_at datetime

  updated_at datetime

}

Table concert_comment {

  concert_comment_id bigint [primary key]

  concert_id bigint  

  user_id bigint

  content varchar

  created_at datetime

  updated_at datetime

}

Table concert_wishlist {

  concert_wishlist_id bigint [primary key]

  concert_id bigint

  user_id bigint

  created_at datetime

  updated_at datetime

}

Table artist_wishlist {

  artist_wishlist_id bigint [primary key]

  artist_id bigint

  user_id bigint

  created_at datetime

  updated_at datetime

}

Table district {

  district_id bigint [primary key]

  concert_id bigint

  district_name varchar

  created_at datetime

  updated_at datetime

}

Table seat {

  seat_id bigint [primary key]

  district_id bigint

  row_num intger

  seat_num integer

  created_at datetime

  updated_at datetime

}

Table reservation {

  reservation_id bigint [primary key]

  user_id bigint

  seat_id bigint

  deposited bool

  created_at datetime

  updated_at datetime

}

Table image {

  image_id bigint [primary key]

  name varchar

  data longblob

  compressed_data longblob

  created_at datetime

  updated_at datetime

}

Ref: concert.artist_id > artist.artist_id

Ref: article.user_id > user.user_id  

Ref: article.board_id > board.board_id  

Ref: article_comment.article_id > article.article_id

Ref: concert_comment.concert_id > concert.concert_id

Ref: concert.place_id > place.place_id  

Ref: concert_wishlist.user_id > user.user_id  

Ref: concert_wishlist.concert_id > concert.concert_id  

Ref: artist_wishlist.user_id > user.user_id

Ref: artist_wishlist.artist_id > artist.artist_id

Ref: article_comment.user_id > user.user_id

Ref: concert_comment.user_id > user.user_id

Ref: reservation.user_id > user.user_id

Ref: reservation.seat_id - seat.seat_id

Ref: district.concert_id > concert.concert_id

Ref: seat.district_id > district.district_id

// Ref: user.profile_image_id - image.image_id  

// Ref: artist.image_id - image.image_id    

// Ref: concert.image_id - image.image_id  

// Ref: article.image_id - image.image_id    

   

 

https://dbdiagram.io/d/665692c6b65d933879ef0df7

dbdiagram.io - Database Relationship Diagrams Design Tool