test

Tables (7)

Amenities

  • amenity_id — INT
  • name — VARCHAR(50) — NOT NULL
  • description — TEXT
  • icon_url — VARCHAR(200)

Campsite_Amenity

  • campsite_id — INT
  • amenity_id — INT

Campsites

  • campsite_id — INT
  • name — VARCHAR(100) — NOT NULL
  • type — VARCHAR(50)
  • capacity — INT
  • price_per_night — DECIMAL(10, 2)
  • description — TEXT
  • image_url — VARCHAR(200)
  • location_id — INT

Locations

  • location_id — INT
  • name — VARCHAR(100) — NOT NULL
  • address — VARCHAR(200)
  • latitude — DECIMAL(10, 7)
  • longitude — DECIMAL(10, 7)
  • contact_number — VARCHAR(20)
  • operating_season — VARCHAR(100)
  • website_url — VARCHAR(200)

Payments

  • payment_id — INT
  • reservation_id — INT
  • payment_method — VARCHAR(50)
  • transaction_id — VARCHAR(100)
  • payment_date — TIMESTAMP
  • amount — DECIMAL(10, 2)
  • payment_status — VARCHAR(20)

Reservations

  • reservation_id — INT
  • user_id — INT
  • campsite_id — INT
  • start_date — DATE — NOT NULL
  • end_date — DATE — NOT NULL
  • number_of_guests — INT
  • total_price — DECIMAL(10, 2)
  • reservation_status — VARCHAR(20)
  • created_at — TIMESTAMP
  • payment_id — INT

Users

  • user_id — INT
  • username — VARCHAR(50) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • email — VARCHAR(100)
  • phone_number — VARCHAR(20)
  • name — VARCHAR(50)
  • address — VARCHAR(200)
  • created_at — TIMESTAMP
  • gender — VARCHAR(20)
  • preferred_region — VARCHAR(100)