hotel

테이블 (15)

결제 (payments)

  • pay_id (Key) — int — 기본 키 — NOT NULL
  • reservation_id (Key4) — int — 외래 키 → 예약.reservation_id — NOT NULL
  • total (Field) — int
  • paid (Field2) — int
  • created_at (Field3) — timestamp
  • updated_at (Field4) — timestamp
  • status (Field5) — varchar(255)

결제수단 (payment_types)

  • payment_type_id (Key) — int — 기본 키 — NOT NULL
  • type (Field) — varchar(20)
  • type_code (Field2) — int
  • card_number (Field3) — varchar(255)
  • approve_no (Field4) — varchar(20)
  • acquire_status (Field5) — varchar(20)
  • issuer_code (Field6) — varchar(20)
  • acquirer_code (Field7) — varchar(20)
  • acquirer_status (Field8) — varchar(25)
  • pay_id (Key2) — int — 외래 키 → 결제.pay_id — NOT NULL

공지 (notice)

  • notice_id (Key) — int — 기본 키 — NOT NULL
  • content (Field) — varchar(100)
  • usage_guide (Field2) — varchar(100)
  • introduction (Field5) — varchar(100)
  • own_hotel_id (Key2) — int — 외래 키 → 소유숙소.own_hotel_id — NOT NULL

리뷰 (reviews)

  • review_id (Key) — int — 기본 키 — NOT NULL
  • score (Field) — float
  • content (Field2) — varchar(80)
  • user_id (Key2) — int — 외래 키 → 회원.user_id — NOT NULL
  • hotel_id (Key3) — int — 외래 키 → 숙소.hotel_id — NOT NULL
  • created_at (Field3) — timestamp
  • updated_at (Field4) — timestamp

리뷰답변 (review_replies)

  • reveiw_reply_id (Key) — int — 기본 키 — NOT NULL
  • created_at (Field) — timestamp
  • updated_at (Field2) — timestamp
  • is_del (Field3) — boolean
  • review_id (Key2) — int — 외래 키 → 리뷰.review_id — NOT NULL
  • reply_content (Field4) — varchar(50)

리뷰사진테이블 (review_picutres)

  • review_picture_id (Key) — int — 기본 키 — NOT NULL
  • picture_name (Field) — varchar(20)
  • picture_path (Field2) — varchar(20)
  • created_at (Field3) — timestamp
  • updated_at (Field4) — timestamp
  • review_id (Key2) — int — 외래 키 → 리뷰.review_id — NOT NULL

북마크 (bookmarks)

  • bookmark_id (Key) — nt — 기본 키 — NOT NULL
  • user_id (Key2) — int — 외래 키 → 회원.user_id — NOT NULL
  • hotel_id (Key3) — int — 외래 키 → 숙소.hotel_id — NOT NULL
  • created_at (Field) — timstamp
  • updated_at (Field2) — timestamp

소유숙소 (own_hotels)

  • own_hotel_id (Key) — int — 기본 키 — NOT NULL
  • price (Field3) — bigint
  • count_room (Field) — int
  • created_at (Field2) — timestamp
  • updated_at (Field4) — timestamp
  • check_in (Field5) — TIME
  • check_out (Field6) — TIME
  • hotel_id (Key2) — int — 외래 키 → 숙소.hotel_id — NOT NULL
  • room_name (Field7) — varchar(100)
  • room_type (Field8) — varchar(50)
  • max_person (Field9) — int
  • min_person (Field10) — int
  • owner_discount (Field11) — double
  • platform_discount (Field12) — double

소유숙소사진 (own_hotel_pictures)

  • own_hotel_picture_id (Key2) — int — 기본 키 — NOT NULL
  • own_hotel_id (Key) — int — 외래 키 → 소유숙소.own_hotel_id — NOT NULL
  • picture_name (Field) — varchar(100)
  • picture_url (Field2) — varchar(200)
  • created_at (Field3) — timestamp
  • updated_at (Field4) — timestamp

숙소 (hotels)

  • hotel_id (Key) — int — 기본 키 — NOT NULL
  • location (Field) — varchar(20)
  • name (Field2) — varchar(20)
  • tel (Field3) — varchar(20)
  • owner (Field4) — varchar(20)
  • business_number (Field5) — varchar(20)
  • regist_number (Field6) — varchar(20)
  • region (Field7) — varchar(20)
  • facility_id (Key2) — int — 외래 키 → 편의시설.facility_id — NOT NULL
  • hotel_picture_id (Key3) — int — 외래 키 → 호텔숙소사진.hotel_picture_id — NOT NULL
  • hotel_type (Field8) — varchar(20)

예약 (reservations)

  • reservation_id (Key) — int — 기본 키 — NOT NULL
  • start_date (Field) — timestamp
  • end_date (Field2) — timestamp
  • duration (Field5) — int
  • created_at (Field6) — timestamp
  • updated_at (Field7) — timestamp
  • hotel_id (Key2) — int — 외래 키 → 숙소.hotel_id — NOT NULL
  • user_id (Key3) — int — 외래 키 → 회원.user_id — NOT NULL
  • person_count (Field8) — int
  • own_hotel_id (Key4) — int — 외래 키 → 소유숙소.own_hotel_id — NOT NULL
  • reserved_name (Field3) — varchar(20)
  • reserved_phone (Field4) — varchar(11)

편의시설 (facilities)

  • facility_id (Key) — int — 기본 키 — NOT NULL
  • service_name (Field) — varchar(50)
  • service_detail (Field2) — varchar(100)

프로필사진 (profile_photo)

  • profile_photo_id (Key) — int — 기본 키 — NOT NULL
  • photo_name (Field) — varchar(20)
  • photo_url (Field2) — varchar(20)
  • created_at (Field3) — timestamp
  • updated_at (Field4) — timestamp

호텔숙소사진 (hotel_pictures)

  • hotel_picture_id (Key) — int — 기본 키 — NOT NULL
  • picture_name (Field)
  • picture_url (Field2)
  • created_at (Field3)
  • updated_at (Field4)

회원 (users)

  • user_id (Key) — int — 기본 키 — NOT NULL
  • oauth_id (Field) — bigint
  • email (Field2) — varchar(20)
  • password (Field7) — varchar(30)
  • fullname (Field3) — varchar(20)
  • created_at (Field4) — timestamp
  • updated_at (Field5) — timestamp
  • phone (Field6) — varchar(20)
  • profile_photo_id (Key2) — int — 외래 키 → 프로필사진.profile_photo_id — NOT NULL