hotel-exam

Tables (9)

hotels

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

points

  • Key (point_id) — BIGINT — Primary key — NOT NULL
  • 유저ID (user_id) — BIGINT — Foreign key → users.유저ID — NOT NULL
  • 예약ID (reservation_id) — BIGINT — Foreign key → reservation.예약ID — NOT NULL
  • Key (review_id) — BIGINT — Foreign key → reviews.Key — NOT NULL
  • Field (point) — INT — NOT NULL
  • Field2 (expire_date) — DATETIME
  • Field (created_at) — DATETIME — NOT NULL
  • Field (type) — VARCHAR(20) — NOT NULL

reservation

  • 예약ID (reservation_id) — BIGINT — Primary key — NOT NULL
  • 유저ID (user_id) — BIGINT — Foreign key → users.유저ID — NOT NULL
  • 객실 ID (room_id) — BIGINT — Foreign key → rooms.객실 ID — NOT NULL
  • Field (check_in_date) — DATETIME — NOT NULL
  • Field (check_out_date) — DATETIME — NOT NULL
  • Field2 (people_count) — INT — NOT NULL
  • Field3 (status) — VARCHAR(20) — NOT NULL
  • Field (reservation_code) — VARCHAR(20) — NOT NULL
  • Field (created_at) — DATETIME — NOT NULL

review_images

  • Key (image_id) — BIGINT — Primary key — NOT NULL
  • Key (review_id) — BIGINT — Foreign key → reviews.Key — NOT NULL
  • Field (image_url) — VARCHAR(500) — NOT NULL
  • Field (created_at) — DATETIME — NOT NULL

reviews

  • Key (review_id) — BIGINT — Primary key — NOT NULL
  • 유저ID (user_id) — BIGINT — Foreign key → users.유저ID — NOT NULL
  • 객실 ID (room_id) — BIGINT — Foreign key → rooms.객실 ID — NOT NULL
  • Field (content) — VARCHAR(500) — NOT NULL
  • Field2 (visible_flag) — BOOLEAN
  • Field3 (created_at) — DATETIME — NOT NULL

room_images

  • Key (image_id) — BIGINT — Primary key — NOT NULL
  • 객실 ID (room_id) — BIGINT — Foreign key → rooms.객실 ID — NOT NULL
  • Field (image_url) — VARCHAR(500) — NOT NULL
  • Field (sort_order) — INT — NOT NULL
  • Field (created_at) — DATETIME — NOT NULL

rooms

  • 객실 ID (room_id) — BIGINT — Primary key — NOT NULL
  • 호텔ID (hotel_id) — BIGINT — Foreign key → hotels.호텔ID — NOT NULL
  • 이름 (name) — VARCHAR(100) — NOT NULL
  • 숙박인원 (capacity) — TINYINT — NOT NULL
  • 층 (floor) — TINYINT — NOT NULL
  • 욕조 (bathtub_flag) — TINYINT — NOT NULL
  • 전망 (VIEW_TYPE) — TINYINT — NOT NULL
  • 생성시간 (created_at) — DATETIME — NOT NULL

season_prices

  • Key (season_price_id) — BIGINT — Primary key — NOT NULL
  • 객실 ID (room_id) — BIGINT — Foreign key → rooms.객실 ID — NOT NULL
  • Field (season_type) — VARCHAR(20) — NOT NULL
  • Field (price) — INT — NOT NULL
  • Field (week_day) — TINYINT — NOT NULL

users

  • 유저ID (user_id) — BIGINT — Primary key — NOT NULL
  • 이메일 (email) — VARCHAR(100) — NOT NULL
  • 비밀번호 (password) — VARCHAR(100) — NOT NULL
  • 이름 (name) — VARCHAR(50) — NOT NULL
  • 생성시간 (created_at) — DATETIME — NOT NULL