Detailed component design

Handle user search requests for available rooms based on various criteria (location, dates, number of guests).
Retrieve and filter available rooms from the database.
Return search results to the user with relevant details such as price, amenities, and availability.

Search Rooms:
- Endpoint: GET /v1/hotels/rooms
- Query Parameters:
  - location: The location where the user wants to find hotels.
  - startDate: Check-in date.
  - endDate: Check-out date.
  - numberOfGuests: Number of guests.
- Response: A list of available rooms with details (hotel name, room type, price, amenities).

Search Database:
- Tables:
  - Hotels: Contains hotel details (ID, name, location, description).
  - Rooms: Contains room details (ID, hotel_id, room_type, price, amenities, available status).
- Indexing: Important fields (like location and availability) should be indexed to enhance search performance.

Receives booking requests from the API Gateway via the Load Balancer.
Validates room availability with the Search Database.
Creates a booking record upon successful availability check and returns confirmation to the user.
Communicates with the Payment Service to process payments.

Create Booking:
- Endpoint: POST /v1/bookings
- Request Body:
  - roomId: The ID of the room being booked.
  - userId: The ID of the user making the booking.
  - checkIn: Check-in date.
  - checkOut: Check-out date.
- Response: Booking confirmation including booking ID and status.

Booking & Payment Database:
- Tables:
  - Bookings: Contains booking details (ID, room_id, user_id, check_in, check_out, status).
  - Payments: Contains payment transaction details (ID, booking_id, amount, payment_method, status).
- Referential Integrity: Constraints should be applied to link booking records with their corresponding room and user records.

Database design

User: Contains all necessary user information such as ID, name, email, password, and phone number.
Hotel: Holds hotel details including name, location, and description.
Room: Details about the rooms, including which hotel they belong to, their type, pricing, and availability.
Booking: Contains booking details linking a user to a room for specific dates, including status, BookingID & RoomID.
Payment: Tracks payment details linked to bookings, including payment method and status. The fields may include, TransactionID, BookingID, PaymentStatus