Tours

@Entity
@Table(name = "tours")
public class Tour {
    private Long tourId;
    private Long guideId;
    private Integer categoryId;
    private String title;
    private String description;
    private BigDecimal price;
    private String currency;
    private BigDecimal durationHours;
    private Integer maxGroupSize;
    private String meetingPoint;
    private TourStatus status;
    private String coverImageUrl;
    private String imageClass;
    private BigDecimal ratingAvg;
    private Integer bookingsCount;
    private LocalDateTime createdAt;
    private LocalDateTime updatedAt;
}

public enum TourStatus {
    DRAFT,      // Tour being created, not visible to tourists
    ACTIVE,     // Published and available for booking
    PAUSED,     // Temporarily unavailable
    ARCHIVED    // No longer offered
}

@Entity
@Table(name = "tour_categories")
public class TourCategory {
    private Integer categoryId;
    private String name;
}

@Entity
@Table(name = "destinations")
public class Destination {
    private Long destinationId;
    private String city;
    private String state;
    private String country;
    private String description;
    private String imageUrl;
    private Boolean isFeatured;
}

@Entity
@Table(name = "tour_destinations")
public class TourDestination {
    @EmbeddedId
    private TourDestinationId id; // Composite key: tourId + destinationId
    
    private Integer visitOrder;
}

@Entity
@Table(name = "tour_included_items")
public class TourIncludedItem {
    private Long itemId;
    private Long tourId;
    private String itemText;
    private Integer sortOrder;
}

private BigDecimal price;     // Tour price
private String currency;       // Currency code (USD, MXN, EUR)
private BigDecimal durationHours; // Duration for pricing context

@Entity
@Table(name = "trip_bookings")
public class TripBooking {
    private Long tripId;
    private Long tourId;
    private Long touristId;
    private Long guideId;
    private LocalDateTime startDatetime;
    private LocalDateTime endDatetime;
    private TripBookingStatus status;
    private String cancelReason;
    private String notes;
    private LocalDateTime createdAt;
    private LocalDateTime updatedAt;
}

public enum TripBookingStatus {
    PENDING,            // Booking requested, awaiting guide confirmation
    CONFIRMED,          // Guide accepted, tour scheduled
    COMPLETED,          // Tour finished successfully
    CANCELLED,          // Booking cancelled by tourist or guide
    CHANGE_REQUESTED    // Modification requested to existing booking
}

@Entity
@Table(name = "trip_status_history")
public class TripStatusHistory {
    private Long historyId;
    private Long tripId;
    private TripStatusHistoryOldStatus oldStatus;
    private TripStatusHistoryNewStatus newStatus;
    private LocalDateTime changedAt;
}

private BigDecimal ratingAvg;      // Average rating (0-5)
private Integer bookingsCount;     // Total completed bookings

@Entity
@Table(name = "guide_calendar_events")
public class GuideCalendarEvent {
    private Long eventId;
    private Long guideId;
    private LocalDateTime startTime;
    private LocalDateTime endTime;
    private GuideCalendarEventEventType eventType;
    private GuideCalendarEventStatus status;
    private GuideCalendarEventSource source;
    private Long tripId;
    private String notes;
}