Guest
├── id, uuid, name, email, phone
├── vip_status
├── external_ids (Oracle, Maestro)
└── Relationships:
    ├── has_many Reservations
    ├── has_many Preferences
    ├── has_many Celebrations
    ├── has_many Nuggets
    ├── has_many Hurdles
    ├── has_many WowMoments
    ├── has_one Bio
    └── belongs_to Hotel

Reservation
├── id, check_in, check_out, status
├── external_id, confirmation_number
└── Relationships:
    ├── belongs_to Hotel
    ├── many_to_many Guests
    ├── has_many ReservationRooms
    └── has_many Notes

Preference    → Guest preferences (room, dietary, service)
Celebration   → Special occasions (birthday, anniversary)
Nugget        → Staff-captured insights
Touchpoint    → Interaction records
WowMoment     → Exceptional experiences created
Hurdle        → Guest issues with resolution tracking