hotel

Tables (10)

holidays

  • holiday_id — BIGINT — Primary key — NOT NULL
  • holiday_date — DATE — NOT NULL
  • name — VARCHAR(100) — NOT NULL

hotels

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

points

  • point_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • amount — INT — NOT NULL
  • reason — TINYINT — NOT NULL
  • expires_at — DATETIME
  • is_expired — TINYINT(1) — NOT NULL

reservations

  • reservation_id — BIGINT — Primary key — NOT NULL
  • room_id — BIGINT — Foreign key → rooms.room_id — NOT NULL
  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • check_in — DATE — NOT NULL
  • check_out — DATE — NOT NULL
  • number_of_guests — TINYINT — NOT NULL
  • reservation_code — VARCHAR(100) — NOT NULL

review_photos

  • review_photo_id — BIGINT — Primary key — NOT NULL
  • review_id — BIGINT — Foreign key → reviews.review_id — NOT NULL
  • photo_url — VARCHAR(255) — NOT NULL

reviews

  • review_id — BIGINT — Primary key — NOT NULL
  • reservation_id — BIGINT — Foreign key → reservations.reservation_id — NOT NULL
  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • content — TEXT — NOT NULL
  • is_visible — TINYINT(1) — NOT NULL

room_photos

  • room_photo_id — BIGINT — Primary key — NOT NULL
  • room_id — BIGINT — Foreign key → rooms.room_id — NOT NULL
  • photo_url — VARCHAR(255) — NOT NULL

room_price_policies

  • room_price_policy_id — BIGINT — Primary key — NOT NULL
  • room_id — BIGINT — Foreign key → rooms.room_id — NOT NULL
  • season_type — TINYINT — NOT NULL
  • price — INT — NOT NULL

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

users

  • user_id — BIGINT — Primary key — NOT NULL
  • username — VARCHAR(100) — NOT NULL
  • password — VARCHAR(100) — NOT NULL