exam-hotel

Tables (8)

Hotels (호텔)

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

Images (이미지)

  • image_id (Key) — BIGINT — Primary key — NOT NULL
  • review_id (Key2) — BIGINT — Foreign key → Reviews.review_id — NOT NULL
  • room_id (Key3) — BIGINT — Foreign key → Rooms.room_id — NOT NULL
  • url (Field) — varchar(255)
  • created_at (Field2) — LocalDateTime

Point (포인트)

  • point_id (Key) — BIGINT — Primary key — NOT NULL
  • user_id (Key2) — varchar(100) — Foreign key → Users.user_id — NOT NULL
  • point_history (Field) — int
  • created_at (Field2) — LocalDateTime

Reservations (예약)

  • reservation_id (Key) — BIGINT — Primary key — NOT NULL
  • room_id (Key3) — BIGINT — Foreign key → Rooms.room_id — NOT NULL
  • user_id (Key2) — varchar(100) — Foreign key → Users.user_id — NOT NULL
  • check_in (Field) — LocalDate
  • check_out (Field2) — LocalDate
  • capacity (Field3) — int
  • total_price (Field4) — int
  • status (Field5) — boolean
  • created_at (Field6) — LocalDate

Reviews (리뷰)

  • review_id (Key) — BIGINT — Primary key — NOT NULL
  • user_id (Key2) — varchar(100) — Foreign key → Users.user_id — NOT NULL
  • room_id (Key3) — BIGINT — Foreign key → Rooms.room_id — NOT NULL
  • review_content (Field) — TEXT
  • rating (Field2) — int
  • created_at (Field3) — LocalDateTime
  • is_visible (Field4) — boolean

RoomPrices (객실가격표)

  • room_price_id (Key) — BIGINT — Primary key — NOT NULL
  • room_id (Key2) — BIGINT — Foreign key → Rooms.room_id — NOT NULL
  • season_type (Field) — enum
  • price (Field2) — int

Rooms (객실)

  • room_id (Key) — BIGINT — Primary key — NOT NULL
  • hotel_id (Key2) — BIGINT — Foreign key → Hotels.hotel_id — NOT NULL
  • name (Field) — varchar(100)
  • capacity (Field2) — TINYINT
  • floor (Field3) — TINYINT
  • bathtub_flag (Field4) — TINYINT(1)
  • view_type (Field5) — TINYINT
  • created_at (Field6) — DATETIME

Users (고객)

  • user_id (Key) — varchar(100) — Primary key — NOT NULL
  • user_name (Field) — varchar(20)
  • password (Field2) — varchar(20)
  • point (Field3) — int
  • created_at (Field4) — DATETIME