User Roles

public enum UserRole {
    TOURIST,
    GUIDE,
    ADMIN
}

@Entity
@Table(name = "users")
public class User {
    private Long userId;
    private UserRole role;
    private String fullName;
    private LocalDate dateOfBirth;
    private String email;
    private String passwordHash;
    private String countryCode;
    private String phoneNumber;
    private String phoneE164;
    private String preferredLanguageCode;
    private UserAccountStatus accountStatus;
    private LocalDateTime emailVerifiedAt;
    private LocalDateTime lastLoginAt;
    private LocalDateTime createdAt;
    private LocalDateTime updatedAt;
}

public enum UserAccountStatus {
    PENDING,    // Registration initiated, awaiting verification
    ACTIVE,     // Account fully activated and usable
    SUSPENDED,  // Temporarily restricted access
    DELETED     // Account marked for deletion
}

@Entity
@Table(name = "tourist_profiles")
public class TouristProfile {
    private Long userId;
    private String location;
    private String bio;
    private LocalDate memberSince;
    private String badge;
    private String travelStyle;
    private String tripType;
    private String paceAndCompany;
    private TouristProfileActivityLevel activityLevel;
    private String groupPreference;
    private String dietaryPreferences;
    private TouristProfilePlanningLevel planningLevel;
    private String amenities;
    private String transport;
    private String photoPreference;
    private String accessibility;
    private String additionalNotes;
    private String avatarUrl;
    private String coverUrl;
    private LocalDateTime updatedAt;
}

@Entity
@Table(name = "guide_profiles")
public class GuideProfile {
    private Long userId;
    private String summary;
    private String story;
    private String statusText;
    private BigDecimal hourlyRate;
    private String currency;
    private BigDecimal ratingAvg;
    private Integer reviewsCount;
    private String locationLabel;
    private String experienceLevel;
    private String style;
    private String groupSize;
    private String tourIntensity;
    private String transportOffered;
    private String photoStyle;
    private String additionalNotes;
    private String avatarUrl;
    private String coverUrl;
    private String postText;
    private String postImageUrl;
    private String postCaption;
    private LocalDateTime postPublishedAt;
    private LocalDateTime updatedAt;
}