Apartment Rentals

The "Bookings" table records all apartment rental bookings. It includes the booking number, apartment address, guest name, booking status, start and end dates, and additional booking details. This table ensures that each booking is meticulously tracked from initiation to completion, facilitating smooth management of rental schedules and guest stays.

The "Buildings" table contains detailed information about each building in the rental portfolio. It includes the building's full name, short name, description, address, manager, and contact information. This table helps in maintaining a comprehensive record of all buildings, ensuring that each one is managed effectively and any issues are promptly addressed.

The "Apartments" table stores information about individual apartments within the buildings. It includes the registered address, apartment number, building name, type of apartment, and counts of bathrooms, bedrooms, and total rooms. This table is crucial for tracking the specifics of each apartment, aiding in the management of property details and facilitating accurate apartment listings.

The "Facilities" table documents the facilities available in each apartment. It includes the apartment's registered address, apartment number, and details about the facilities. This table ensures that all amenities are accurately recorded, helping property managers provide complete and detailed information to prospective guests.

The "Guests" table maintains records of all guests who book apartments. It includes their full name, gender, date of birth, and other relevant details. This table is essential for keeping accurate and organized records of guests, facilitating communication, and ensuring a personalized experience for returning visitors.