hotelDB

테이블 (28)

Booking

  • booking_id — INT — 기본 키 — NOT NULL
  • user_id — INT — 외래 키 — NOT NULL
  • booking_date — DATETIME — NOT NULL
  • checkin_date — DATE — NOT NULL
  • checkout_date — DATE — NOT NULL
  • room_id — INT — 외래 키 → room.room_id — NOT NULL

Coupon

  • coupon_id — INT — 기본 키 — NOT NULL
  • user_id — INT — 외래 키 — NOT NULL
  • coupon_code — VARCHAR(50) — NOT NULL
  • discount_rate — DECIMAL(5, 2) — NOT NULL
  • valid_from — DATE — NOT NULL
  • valid_to — DATE

Payment

  • payment_id — INT — 기본 키 — NOT NULL
  • booking_id — INT — 외래 키 → Booking.booking_id — NOT NULL
  • user_id — INT — 외래 키 — NOT NULL
  • coupon_id — INT — 외래 키 → Coupon.coupon_id
  • original_price — DECIMAL(10, 2)
  • total_price — DECIMAL(10, 2) — NOT NULL
  • payment_date — DATETIME — NOT NULL
  • payment_method_id — INT — 외래 키 — NOT NULL

event

  • event_id — INT — 기본 키 — NOT NULL
  • event_name — VARCHAR(255) — NOT NULL
  • event_date — DATETIME — NOT NULL
  • event_description — TEXT
  • hotel_id — INT — 외래 키 → hotel.hotel_id — NOT NULL

hotel

  • hotel_id — INT — 기본 키 — NOT NULL
  • hotel_name — VARCHAR(255) — NOT NULL
  • rating_avg — DECIMAL(2,1)
  • price_range — VARCHAR(50)
  • location_id — INT — NOT NULL
  • hotel_type_id — VARCHAR(255) — NOT NULL

hotel_description

  • hotel_description_id — INT — 기본 키 — NOT NULL
  • hotel_id — INT — 외래 키 → hotel.hotel_id — NOT NULL
  • hotel_description — TEXT — NOT NULL

hotel_image

  • hotel_image_id — INT — 기본 키 — NOT NULL
  • hotel_id — INT — 외래 키 → hotel.hotel_id — NOT NULL
  • hotel_image_url — VARCHAR(255)

hotel_type

  • hotel_type_id — VARCHAR(255) — 기본 키 — NOT NULL
  • hotel_type_name — VARCHAR(255)

location

  • location_id — INT — 기본 키 — NOT NULL
  • city_name — VARCHAR(255) — NOT NULL
  • country_name — VARCHAR(255) — NOT NULL

review

  • review_id — INT — 기본 키 — NOT NULL
  • rating — INT — NOT NULL
  • comment — TEXT
  • review_date — DATETIME — NOT NULL
  • booking_id — INT — 외래 키 → Booking.booking_id — NOT NULL
  • user_id — INT — 외래 키 — NOT NULL

room

  • room_id — INT — 기본 키 — NOT NULL
  • hotel_id — INT — 외래 키 → hotel.hotel_id — NOT NULL
  • room_number — VARCHAR(255)
  • is_reserved — TINYINT(1)
  • room_type_id — VARCHAR(255) — 외래 키 → room_type.room_type_id — NOT NULL

room_amenities

  • amenities_id — INT — 기본 키 — NOT NULL
  • room_type_id — VARCHAR(255) — 외래 키 → room_type.room_type_id — NOT NULL
  • is_refrigerator — TINYINT(1)
  • is_television — TINYINT(1)
  • is_internet — TINYINT(1)

room_image

  • room_image_id — INT — 기본 키 — NOT NULL
  • room_type_id — VARCHAR(255) — 외래 키 → room_type.room_type_id — NOT NULL
  • room_image_url — VARCHAR(255)

room_type

  • room_type_id — VARCHAR(255) — 기본 키 — NOT NULL
  • room_name — VARCHAR(255)
  • room_price — DECIMAL(10, 2)

객실정보 (RoomInfo)

    결제수단 (PaymentMethod)

      결제정보 (PaymentInfo)

        리뷰 (Review)

          사용자 (User)

          • Key — 기본 키 — NOT NULL
          • Field
          • Field2

          예약이력 (BookHistory)

            예약정보 (BookInfo)

              위치정보 (Location)

                장바구니 (ShoppingCart)

                  주변정보 (Around)

                    즐겨찾기 (Favorite)

                      편의시설 (Amenitiy)

                        할인정보 (DiscountInfo)

                          호텔 (Hotel)