hotel

Tables (8)

Hotel (호텔)

  • hotel_id (호텔ID) — BIGINT — Primary key — NOT NULL
  • name (호텔명) — VARCHAR(100) — NOT NULL

Point (포인트)

  • point_id (포인트ID) — BIGINT — Primary key — NOT NULL
  • user_id (사용자ID) — BIGINT — Foreign key → User.user_id — NOT NULL
  • amount (포인트수량) — BIGINT — NOT NULL
  • create_at (생성일) — DATETIME — NOT NULL
  • type (포인트타입) — VARCHAR(20) — NOT NULL — 적립, 소멸, 회수, 사용

Reservation (예약)

  • resv_code (예약코드) — VARCHAR(255) — Primary key — NOT NULL
  • user_id (사용자ID) — BIGINT — Foreign key → User.user_id — NOT NULL
  • room_id (객실ID) — BIGINT — Foreign key → Room.room_id — NOT NULL
  • person_number (예약인원) — TINYINT — NOT NULL
  • check_in (체크인날짜) — DATETIME — NOT NULL
  • check_out (체크아웃날짜) — DATETIME — NOT NULL
  • cancel (취소여부) — TINYINT(1) — NOT NULL — false
  • created_at (예약생성일) — DATETIME — NOT NULL

Review (리뷰)

  • review_id (리뷰ID) — BIGINT — Primary key — NOT NULL
  • resv_code (예약코드) — VARCHAR(30) — Foreign key → Reservation.resv_code — NOT NULL
  • view_flag (노출여부) — TINYINT(1) — NOT NULL
  • content (내용) — TEXT — NOT NULL
  • created_at (생성일) — DATETIME — NOT NULL

ReviewImage (리뷰 이미지)

  • image_id (리뷰이지미ID) — BIGINT — Primary key — NOT NULL
  • image_url (이미지 경로) — VARCHAR(255) — NOT NULL
  • review_id (리뷰ID) — BIGINT — Foreign key → Review.review_id — NOT NULL

Room (객실)

  • room_id (객실ID) — BIGINT — Primary key — NOT NULL
  • hotel_id (호텔ID) — BIGINT — Foreign key → Hotel.hotel_id — NOT NULL
  • name (객실명) — VARCHAR(100) — NOT NULL
  • capacity (숙박인원) — TINYINT — NOT NULL
  • floor (층) — TINYINT — NOT NULL
  • bathtub_flag (욕조여부) — TINYINT(1) — NOT NULL
  • view_type (전망) — TINYINT — NOT NULL — 0:city, 1:ocean, 2:mountain
  • created_at (생성일) — DATETIME — NOT NULL
  • Field

RoomImage (객실 이미지)

  • image_id (이미지ID) — BIGINT — Primary key — NOT NULL
  • room_id (객실ID) — BIGINT — Foreign key → Room.room_id — NOT NULL
  • image_url (이미지경로) — VARCHAR(255) — NOT NULL

User (사용자)

  • user_id (사용자ID) — BIGINT — Primary key — NOT NULL
  • name (이름) — VARCHAR(20) — NOT NULL
  • login_id (로그인아이디) — VARCHAR(20) — NOT NULL
  • password (비밀번호) — VARCHAR(255) — NOT NULL