AirBnB

Tables (21)

Accommodation (숙소)

  • Accommodation_Id (숙소 아이디) — Primary key — NOT NULL
  • Accommodation_Name (숙소 이름)
  • Accommodation_descripe (숙소 설명)
  • Host_Id (호스트 아이디) — Foreign key → Host.Host_Id — NOT NULL

Accommodation_Category (숙소 카테고리)

  • Accommodation_Id (숙소 아이디) — Foreign key → Accommodation.Accommodation_Id — NOT NULL

Accommodation_Facility (숙소 편의시설)

  • Accommodation_Id (숙소 아이디) — Foreign key → Accommodation.Accommodation_Id — NOT NULL

Accommodation_Image (숙소 이미지)

  • Accommodation_Image (Key) — Primary key — NOT NULL
  • Accommodation_Id (숙소 아이디) — Foreign key → Accommodation.Accommodation_Id — NOT NULL

Accommodation_Option (숙소 옵션)

  • Accommodation_Option (Key) — Primary key — NOT NULL
  • Accommodation_Id (숙소 아이디) — Foreign key → Accommodation.Accommodation_Id — NOT NULL

Accommodation_Report (Untitled)

    Chat (채팅방)

      ChatMember (채팅방 맴버)

        Guest_Report (게스트 신고)

        • Guest_Report_Id (게스트 신고 아이디) — Primary key — NOT NULL
        • Guest_Report_Reason (게스트 신고 사유)
        • Guest_Report_Content (게스트 신고 내용)

        Host (호스트)

        • Host_Id (호스트 아이디) — Primary key — NOT NULL
        • Host_SuperYN (호스트 슈퍼호스트유무)
        • Host_Period (호스트 경력 기간)
        • Host_Rating (호스트 평점)
        • Host_CreateAt (호스트 생성일시)
        • Member_Id (회원 아이디) — Foreign key → Member.Member_Id — NOT NULL

        Member (회원)

        • Member_Id (회원 아이디) — Primary key — NOT NULL
        • Member_Name (회원 이름)
        • Member_Email (회원 이메일)
        • Member_Password (회원 비밀번호)
        • Member_Gender (회원 성별)
        • Member_Birthday (회원 생일)
        • Member_PhoneNumber (회원 전화번호)
        • Member_CreateAt (회원 생성일시)
        • Member_UpdateAt (회원 갱신일시)

        Member_Image (회원 이미지)

        • Member_Image_Id (회원 이미지 아이디) — Primary key — NOT NULL
        • Member_Id (회원 아이디) — Foreign key → Member.Member_Id — NOT NULL
        • Member_Image_Link (회원 이미지 링크)
        • Member_Image_CreatAt (회원 이미지 생성일)
        • Member_Image_UpdateAt (회원 이미지 갱신일)

        Message (메세지)

          Payment (결제)

          • PayMent (Key) — Primary key — NOT NULL
          • Reservation_Id (Key2) — Foreign key → Reservation.Reservation_Id — NOT NULL

          PaymentRefund (결제 환불)

          • PayMent (Key) — Foreign key → Payment.PayMent — NOT NULL

          Reservation (숙박 예약)

          • Reservation_Id (Key) — Primary key — NOT NULL
          • Accommodation_Id (숙소 아이디) — Foreign key → Accommodation.Accommodation_Id — NOT NULL
          • Member_Id (회원 아이디) — Foreign key → Member.Member_Id — NOT NULL

          ReservationState (숙소 예약 상태)

          • ReservationState (Key) — Primary key — NOT NULL
          • Reservation_Id (Key2) — Foreign key → Reservation.Reservation_Id — NOT NULL

          Review (리뷰)

          • Review_Id (Key) — Primary key — NOT NULL
          • Reservation_Id (Key2) — Foreign key → Reservation.Reservation_Id — NOT NULL

          Term (약관)

            Wish (위시)

            • Wish (위시 아이디) — Primary key — NOT NULL
            • WishList_Id (위시리스트 아이디) — Foreign key → WishList.WishList_Id — NOT NULL

            WishList (위시리스트)

            • WishList_Id (위시리스트 아이디) — Primary key — NOT NULL
            • Member_Id (회원 아이디) — Foreign key → Member.Member_Id — NOT NULL