exam

Tables (5)

Hotels (Untitled2)

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

PointDetails (Untitled4)

  • point_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT
  • amout (amount) — INT
  • point_policyp (oint_policy) — TINYINT
  • expire_date — DATETIME
  • reservation_id — BIGINT
  • review_id — BIGINT

Reservations (Untitled3)

  • reservation_id — BIGINT — Primary key — NOT NULL
  • room_id — BIGINT — Foreign key → Rooms.room_id — NOT NULL
  • user_id — BIGINT
  • check_in_date — LOCALDATE
  • check_out_date — LOCALDATE
  • reservation_num — INT
  • canceled — TINYINT(1)
  • Field

Reviews (Untitled5)

  • review_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT
  • contentc (ontent) — VARCHAR(500)
  • review_image_url — VARCHAR(500)
  • public_review — TINYINT(1)

Rooms (Untitled)

  • room_id — BIGINT — Primary key — NOT NULL
  • hotel_id — BIGINT — Foreign key → Hotels.hotel_id — NOT NULL
  • name — VARCHAR(100)
  • capacity — TINYINT
  • floor — TINYINT
  • bathtub_flag — TINYINT(1)
  • view_type — TINYINT
  • off_season_price — INT
  • season_price — INT
  • room_image_url — VARCHAR(500)
  • created_at — DATETIME