exam01_hotel

Tables (8)

hotels

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

point_log

  • point_log (point_id) — BIGINT — Primary key — NOT NULL
  • point_description — VARCHAR(50) — NOT NULL — ex)회원가입 축하
  • point_usage — INT — NOT NULL
  • created_at — DATETIME — NOT NULL
  • user_no — BIGINT — Foreign key → user.user_no — NOT NULL

reservation

  • reservation_id — BIGINT — Primary key — NOT NULL
  • check_in_date — DATETIME
  • check_out_date — DATETIME
  • num_of_people — TINYINT
  • room_id — BIGINT — Foreign key → rooms.room_id — NOT NULL
  • user_no — BIGINT — Foreign key → user.user_no — NOT NULL
  • hotel_id — BIGINT — Foreign key → rooms.hotel_id — NOT NULL

review

  • review_id — BIGINT — Primary key — NOT NULL
  • room_id — BIGINT — Foreign key → rooms.room_id — NOT NULL
  • hotel_id — BIGINT — Foreign key → rooms.hotel_id — NOT NULL
  • review_content — VARCHAR(255)
  • review_score (reivew_score) — INT

review_image

  • review_id — BIGINT — Foreign key → review.review_id — NOT NULL
  • room_id — BIGINT — Foreign key → review.room_id — NOT NULL
  • hotel_id — BIGINT — Foreign key → review.hotel_id — NOT NULL
  • file_path — VARCHAR(255)

rooms

  • room_id — BIGINT — Primary key — NOT NULL
  • hotel_id — BIGINT — Foreign key → hotels.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
  • created_at — DATETIME — NOT NULL
  • INDEX — `fk_Rooms_hotels_idx`
  • INDEX1 — `uk_hotel_roomname`
  • peak_price — BIGINT
  • non_peak_price — BIGINT

rooms_image

  • room_id — BIGINT — Foreign key → rooms.room_id — NOT NULL
  • hotel_id — BIGINT — Foreign key → rooms.hotel_id — NOT NULL
  • file_path — VARCHAR(255)

user

  • user_no — BIGINT — Primary key — NOT NULL
  • user_id — VARCHAR(50)
  • user_password — VARCHAR(255)
  • user_role — TINYINT