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)