ㄴㄴㄴㄴ

Tables (8)

Hotel (호텔)

  • 호텔 식별자 (hotel_id) — bigint — Primary key — NOT NULL
  • 제목 (title) — varchar(255)
  • 호텔점수 (hotelScore)
  • 호텔주소 (address)
  • 좌표 x (location_x)
  • 좌표 y (location_y)
  • 호텔 서비스 (service)
  • 카테고리 (category)
  • wish_list_id — bigint — Foreign key → wish_list.wish_list_id — NOT NULL

hotelImage (호텔 이미지)

  • image_id — bigint — Primary key — NOT NULL
  • image — varchar(255)
  • title — varchar(255)
  • 호텔 식별자 (hotel_id) — bigint — Foreign key → Hotel.호텔 식별자 — NOT NULL
  • review_id — bigint — Foreign key → review.review_id — NOT NULL

member

  • member_id — bigint — Primary key — NOT NULL
  • created_at — datetime(6)
  • modified_at — datetime(6)
  • email — varchar(255) — NOT NULL
  • image — varchar(255)
  • name — varchar(255) — NOT NULL
  • password — varchar(255)
  • provider — varchar(255)
  • roles

member_roles

  • roles — varchar(255)
  • member_id — bigint — Foreign key → member.member_id — NOT NULL

reservation

  • reservation_id — bigint — Primary key — NOT NULL
  • checkin — date
  • checkout — date
  • adult — integer
  • child — integer
  • price — bigint
  • status — bit
  • reservation_date — varchar(255)
  • member_id — bigint — Foreign key → member.member_id — NOT NULL
  • room_id — bigint — Foreign key → room.room_id — NOT NULL

review

  • review_id — bigint — Primary key — NOT NULL
  • created_at — datetime(6)
  • modified_at — datetime(6)
  • content — varchar(255) — NOT NULL
  • score — integer — NOT NULL
  • hotelImage (image_id) — bigint
  • member_id — bigint — Foreign key → member.member_id — NOT NULL
  • 호텔 식별자 (hotel_id) — bigint — Foreign key → Hotel.호텔 식별자 — NOT NULL

room

  • room_id — bigint — Primary key — NOT NULL
  • head_count — int
  • room_type — varchar(255)
  • quantity — int
  • price — int
  • 호텔 식별자 (hotel_id) — bigint — Foreign key → Hotel.호텔 식별자 — NOT NULL

wish_list

  • wish_list_id — bigint — Primary key — NOT NULL
  • hotel_id — bigint
  • member_id — bigint — Foreign key → member.member_id — NOT NULL