게스트하우스 예약 서비스

테이블 (14)

Accommodation (숙소)

  • id — Long — 기본 키 — NOT NULL
  • name — String
  • contact — String
  • address — String
  • city — String
  • district — String
  • latitude — double
  • longitude — double
  • type — varchar
  • description — String
  • checkin_time (checkinTime) — datetime
  • checkout_time (checkoutTime) — datetime
  • rating_average (ratingAverage) — double
  • review_count (reviewCount) — int
  • bookmark_count (bookmarkCount) — int
  • created_at (createdAt) — datetime
  • updated_at (updatedAt) — datetime
  • deleted_at (deletedAt) — datetime
  • user_id (userId) — Long — 외래 키 → User.id — NOT NULL

AccommodationAmenity (숙소, 편의시설 중간테이블)

  • id — Long — 기본 키 — NOT NULL
  • accommodation_id (accommodationId) — Long — 외래 키 → Accommodation.id — NOT NULL
  • amenity_id (amenityId) — Long — 외래 키 → Amenity.id — NOT NULL

AccommodationImage (숙소 사진)

  • id — Long — 기본 키 — NOT NULL
  • url — String
  • accommodation_id (accommodationId) — Long — 외래 키 → Accommodation.id — NOT NULL

Amenity (편의시설)

  • id — Long — 기본 키 — NOT NULL
  • type — String

BlackList (블랙리스트)

  • id — Long — 기본 키 — NOT NULL
  • reason — varchar
  • accommodation_id (accommodationId) — Long — 외래 키 → Accommodation.id — NOT NULL
  • user_id (userId) — Long — 외래 키 → User.id — NOT NULL
  • created_at (createdAt) — datetime

Bookmark (북마크)

  • id — Long — 기본 키 — NOT NULL
  • accommodation_id (accommodationId) — Long — 외래 키 → Accommodation.id — NOT NULL
  • user_id (userId) — Long — 외래 키 → User.id — NOT NULL

DayOff (휴무 요일)

  • id — Long — 기본 키 — NOT NULL
  • day_of_week (dayOfWeek) — String
  • accommodation_id (accommodationId) — Long — 외래 키 → Accommodation.id — NOT NULL

Reservation (예약)

  • id — Long — 기본 키 — NOT NULL
  • checkin_date (checkinDate) — date
  • checkout_date (checkoutDate) — date
  • state — varchar
  • created_at (createdAt) — datetime
  • updated_at (updatedAt) — datetime
  • user_id (userId) — Long — 외래 키 → User.id — NOT NULL
  • room_id (roomId) — Long — 외래 키 → Room.id — NOT NULL

Review (후기)

  • id — Long — 기본 키 — NOT NULL
  • content — String
  • star_rating (starRating) — int
  • comment — String
  • created_at (createdAt) — datetime
  • updated_at (updatedAt) — datetime
  • reservation_id (reservationId) — Long — 외래 키 → Reservation.id — NOT NULL
  • accommodation_id (accommodationId) — Long — 외래 키 → Accommodation.id — NOT NULL

ReviewTag (리뷰, 태그 중간테이블)

  • id — Long — 기본 키 — NOT NULL
  • tag_id (tagId) — Long — 외래 키 → Tag.id — NOT NULL
  • review_id (reviewId) — Long — 외래 키 → Review.id — NOT NULL

Room (방)

  • id — Long — 기본 키 — NOT NULL
  • name — String
  • gender — varchar
  • capacity — int
  • description — String
  • accommodation_id (accommodationId) — Long — 외래 키 → Accommodation.id — NOT NULL

RoomImage (방 사진)

  • id — Long — 기본 키 — NOT NULL
  • url — String
  • room_id (roomId) — Long — 외래 키 → Room.id — NOT NULL

Tag (태그)

  • id — Long — 기본 키 — NOT NULL
  • name — String

User (회원)

  • id — Long — 기본 키 — NOT NULL
  • name — String
  • password — String
  • nickname — String
  • contact — String
  • gender — String
  • birth — date
  • dType — String
  • created_at (createdAt) — datetime
  • updated_at (updatedAt) — datetime
  • deleted_at (deletedAt) — datetime