hotel_exam

Tables (8)

Hotels (Untitled)

  • hotel_id (Key) — BIGINT — Primary key — NOT NULL
  • name (Field) — VARCHAR(100)

Points (Untitled9)

  • poin_id (Key) — BIGINT — Primary key — NOT NULL
  • user_id (Key2) — BIGINT — Foreign key → Users.user_id — NOT NULL
  • reserve_id (Key3) — BIGINT — Foreign key → Rerservation.reserve_id — NOT NULL
  • review_id (Key4) — BIGINT — Foreign key → Review.review_id — NOT NULL
  • amount (포인트 적립액) — INT
  • status (사용, 소멸 상태) — ENUM('VALID', 'CANCELLED')
  • earn_at (적립날짜) — DATETIME
  • expired_at (소멸 날짜) — DATETIME

Rerservation (Untitled5)

  • reserve_id (Key) — BIGINT — Primary key — NOT NULL
  • check_in (체크인날짜) — DATETIME
  • check_out (체크아웃 날짜) — DATETIME
  • head_count (인원 수) — TINYINT
  • reserve_num (예약번호) — VARCHAR(100)
  • reserve_status (예약 상태) — ENUM('COMPLETED', 'CANCELLED')
  • room_id (Key2) — BIGINT — Foreign key → Rooms.room_id — NOT NULL
  • user_id (Key3) — BIGINT — Foreign key → Users.user_id — NOT NULL

Review (Untitled7)

  • review_id (Key) — BIGINT — Primary key — NOT NULL
  • rating (평점) — DECIMAL(2,1)
  • is_visible (리뷰보이게) — boolean
  • reserve_id (Key2) — BIGINT — Foreign key → Rerservation.reserve_id — NOT NULL

Review_Images (Untitled8)

  • review_image_id (Key) — BIGINT — Primary key — NOT NULL
  • image_url (Field) — VARCHAR(255)
  • review_id (Key2) — BIGINT — Foreign key → Review.review_id — NOT NULL

Room_images (Untitled6)

  • room_image_id (Key) — BIGINT — Primary key — NOT NULL
  • image_url (Field) — VARCHAR(255)
  • room_id (Key2) — BIGINT — Foreign key → Rooms.room_id — NOT NULL

Rooms (Untitled2)

  • room_id (Key) — BIGINT — Primary key — NOT NULL
  • name (Field) — VARCHAR(100)
  • hotel_id (Key2) — BIGINT — Foreign key → Hotels.hotel_id — NOT NULL
  • capacity (수용인원) — TINYINT
  • floor (층수) — TINYINT
  • has_bathtub (욕조 유무) — TINYINT(1)
  • view_type (뷰 타입) — TINYINT
  • created_at (Field6) — DATETIME

Users (Untitled4)

  • user_id (Key) — BIGINT — Primary key — NOT NULL
  • name (사용자 이름) — VARCHAR(100)