Design Profile Service Database Schema

[delucca]

Type of Issue

Feature Request

Description

Define the data models and database schema for managing guest and staff profiles. The schema should include fields for personal details (e.g., name, contact info), preferences, and relationships (e.g., linked bookings or activities).

Additional Context

This schema will serve as the foundation for all profile-related functionality, and it should allow scalability to accommodate more fields as new features are added. Consider how guest profiles will relate to bookings and staff profiles will relate to other internal systems.

Acceptance Criteria

1. Database schema for profiles (guest and staff) is defined.
2. Models for user details, preferences, and relationships are created.
3. Schema is documented and ready for implementation.