exam-hotel

Tables (7)

hotel (Untitled)

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

image (Untitled6)

  • image_id (Key) — bigint — Primary key — NOT NULL
  • review_id (Key2) — bigint — Foreign key → review.review_id — NOT NULL
  • path (Field) — varchar

point (Untitled7)

  • id (Key) — bigint — Primary key — NOT NULL
  • user_id (Field) — bigint
  • amount (Field2) — int
  • reason (Field3) — varchar
  • earned_at (Field4) — datetime
  • expires_at (Field5) — datetime
  • expired (Field6) — tinyint(1)

price (Untitled4)

  • price_id (Key2) — bigint — Primary key — NOT NULL
  • room_id (Key) — bigint — Foreign key → room.room_id — NOT NULL
  • peak_season_price (Field) — int
  • off_season_price (Field2) — int

reservation (Untitled3)

  • reservation_id (Key2) — bigint — Primary key — NOT NULL
  • room_id (Key) — bigint — Foreign key → room.room_id — NOT NULL
  • check_in_date (Field) — datetime
  • check_out_date (Field2) — datetime
  • reserved_number (Field3) — tinyint
  • is_cancelled (Field4) — tinyint(1)
  • price (Field5) — int

review (Untitled5)

  • review_id (Key) — bigint — Primary key — NOT NULL
  • reservation_id (Key2) — bigint — Foreign key → reservation.reservation_id — NOT NULL
  • expose (Field2) — tinyint(1)
  • content (Field) — varchar

room (Untitled2)

  • room_id (Key) — bigint — Primary key — NOT NULL
  • hotel_id (Key2) — bigint — Foreign key → hotel.hotel_id — NOT NULL
  • name (Field) — varchar
  • capacity (Field2) — tinyint
  • floor (Field3) — tinyint
  • bathtub_flag (Field4) — tinyint(1)
  • view_type (Field5) — tinyint
  • created_at (Field6) — datetime