test

Tables (8)

cancellation_policies

  • cancellation_policy_id — BIGINT — Primary key — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • description — TEXT

facilities

  • facilities_id — BIGINT — Primary key — NOT NULL
  • facilities_name — VARCHAR(100) — NOT NULL
  • category — ENUM('BATHROOM','BEDROOM','LAUNDRY_ROOM','ENTERTAINMENT','HVAC','SAFETY','INTERNET','KITCHEN','PARKING_SERVICE','OTHER') — NOT NULL

reservations

  • reservation_id — BIGINT — Primary key — NOT NULL
  • stay_uuid — BIGINT — NOT NULL
  • user_id — BIGINT — NOT NULL
  • checkin_date — DATE — NOT NULL
  • checkout_date — DATE — NOT NULL
  • reservation_date — DATETIME — NOT NULL
  • status — ENUM('PENDING','CONFIRMED','CANCELLED') — NOT NULL
  • guests_count — INT — NOT NULL
  • requests — TEXT
  • reservation_info — VARCHAR(255)

stay_facilities

  • stay_uuid — BIGINT — Primary key — NOT NULL
  • facilities_id — BIGINT — Primary key — NOT NULL

stay_photos

  • photo_id — BIGINT — Primary key — NOT NULL
  • stay_uuid — BIGINT — NOT NULL
  • url — VARCHAR(500) — NOT NULL
  • sort_order — INT — NOT NULL

stay_pricing

  • price_id — BIGINT — Primary key — NOT NULL
  • stay_uuid — BIGINT — NOT NULL
  • weekday_price — INT — NOT NULL
  • weekend_price — INT — NOT NULL
  • currency — CHAR(3) — NOT NULL
  • effective_from — DATE
  • effective_to — DATE

stays

  • stay_uuid — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • description — TEXT
  • bedrooms — INT — NOT NULL
  • beds — INT — NOT NULL
  • bathrooms — INT — NOT NULL
  • address_line1 — VARCHAR(255) — NOT NULL
  • address_line2 — VARCHAR(255)
  • city — VARCHAR(100) — NOT NULL
  • region — VARCHAR(100) — NOT NULL
  • postal_code — VARCHAR(100) — NOT NULL
  • max_guests — INT — NOT NULL
  • cancellation_policy_id — BIGINT
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME

users

  • user_id — BIGINT — Primary key — NOT NULL
  • user_role — ENUM('ROLE_GUEST','ROLE_HOST') — NOT NULL
  • name — VARCHAR(255) — NOT NULL
  • nickname — VARCHAR(100) — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • phone — VARCHAR(30) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME