Nhom

Notes

Tour Operators Models - Detailed Field Analysis & Usage

This Django travel system contains 16 interconnected models that manage comprehensive tour operations, from operator management to flight bookings. Here's a detailed analysis:

🏢 1. TourOperator Model - Tour Company Management

Purpose: Manages tour companies that create and operate tours, including in-house, partner, and broker operators.

Core Identity Fields:

• name (CharField): Primary company name in English
• name_vi (CharField): Vietnamese company name for multilingual support
• description/description_vi (TextField): Company description in both languages
• operator_type (CharField): Categorizes operators:
  • inhouse: Direct company tours
  • partner: Trusted external operators
  • broker: Third-party aggregators

Contact & Location Fields:

• email/phone/website: Essential business contact information
• address (TextField): Full business address
• city (ForeignKey to geo.Location): Links to geographic location system
• country (ForeignKey to destinations.Country): Country-level association

Business Credentials:

• license_number: Government tourism license
• certification: Industry certifications (IATA, ASTA, Local Tourism Board)
• established_year: Company founding year for credibility

API Integration Fields (for external brokers):

• api_endpoint: URL for fetching external tour data
• api_key: Authentication for API access
• commission_rate: Revenue sharing percentage (default 10%)

Management & Status:

• user (OneToOne): Primary owner account
• managers (ManyToMany): Multiple admin users
• is_active/is_verified: Status controls for business operations

Performance Metrics:

• average_rating/total_reviews: Customer satisfaction tracking

total_tours: Portfolio size indicator

🏷️ 2. TourCategory Model - Tour Classification System

Purpose: Hierarchical categorization system for organizing tours (Adventure, Cultural, Food, etc.).

Category Structure:

• name/name_vi: Category names in both languages
• description/description_vi: Category explanations
• icon: FontAwesome icon class for UI display
• parent (Self-ForeignKey): Creates hierarchical structure (e.g., "Adventure > Hiking")
• is_active: Controls category visibility

Usage: Enables filtering, search, and browse functionality across the tour catalog.

🎯 3. Tour Model - Core Tour Information

Purpose: The central model containing all tour details, pricing, and operational information.

Basic Information:

• uuid: Unique identifier for external integrations
• title/title_vi: Tour names in both languages
• slug: SEO-friendly URLs
• short_description/description + _vi: Marketing content in both languages

Tour Classification:

• tour_operator (ForeignKey): Links to operating company
• categories (ManyToMany): Multiple category associations
• tour_type: Group, Private, Self-guided, Custom
• difficulty: Easy, Moderate, Challenging, Extreme

Duration & Geography:

• duration_days/duration_hours: Flexible duration system
• start_location/end_location: Geographic start/end points
• destinations (ManyToMany): Multiple destination associations

✈️ Flight Integration Fields:

• requires_flights: Boolean flag for international tours
• departure_airport/arrival_airport: Required airports
• return_flight_included: Packaging options
• flight_class_options: Available service classes (economy,business,first)
• flight_booking_deadline_days: Booking timeline management

Capacity Management:

• min_participants/max_participants: Group size controls
• min_age/max_age: Age restrictions

Pricing Structure:

• base_price: Standard adult pricing
• price_currency: Multi-currency support
• child_price/senior_price: Demographic pricing
• group_discount_rate: Volume discounts

External Source Management:

• source: Origin tracking (inhouse, viator, getyourguide, partner, api)
• external_id/external_url: Third-party system integration
• last_synced: Data freshness tracking

Feature Flags:

• includes_accommodation/meals/transport/guide/tickets: Package components
• is_active/is_featured/is_available: Operational status
• requires_approval: Quality control workflow

Performance Analytics:

• total_bookings/average_rating/total_reviews: Business intelligence

✈️ 4. TourFlight Model - Flight Options & Integration

Purpose: Links specific flights to tours with pricing and availability management.

Flight Association:

• tour (ForeignKey): Parent tour
• flight (ForeignKey to transport.Flight): Specific flight connection
• flight_type: Outbound, Return, Internal, Connecting

Pricing Management:

• is_included_in_price: Package inclusion flag
• additional_cost_economy/business/first: Class-specific pricing
• booking_deadline: Time-sensitive availability
• min_passengers/max_passengers: Group booking requirements

Status Tracking:

• status: Available, Unavailable, Fully Booked, Cancelled

notes_en/notes_vi: Multilingual booking information

📅 5. TourItinerary Model - Daily Schedule Management

Purpose: Day-by-day breakdown of tour activities and logistics.

Itinerary Structure:

• tour (ForeignKey): Parent tour
• day_number: Sequential day ordering
• title/title_vi: Daily theme/focus
• description/description_vi: Detailed daily activities

Daily Logistics:

• activities: Comma-separated activity list
• meals_included: Meal planning (Breakfast, Lunch, Dinner)
• accommodation: Lodging information
• location (ForeignKey): Geographic context

📆 6. TourSchedule Model - Availability Management

Purpose: Manages tour availability dates, times, and capacity.

Schedule Types:

• schedule_type: Fixed Date, Recurring, On Demand
• start_date/end_date/start_time: Specific scheduling
• days_of_week (JSONField): Recurring schedule patterns

Capacity Management:

• available_spots/booked_spots: Real-time availability
• price_override: Date-specific pricing
• is_active: Schedule status control

👨‍🏫 7. TourGuide Model - Guide Management & Verification

Purpose: Comprehensive guide profile and verification system.

Guide Identity:

• user (OneToOne): Connected user account
• tour_operator (ForeignKey): Employment relationship
• bio/bio_vi: Professional descriptions
• specializations (ManyToMany to TourCategory): Expertise areas

Qualifications:

• languages (JSONField): Multi-language support
• years_experience: Experience tracking
• certifications: Text description of credentials
• license_number: Professional licensing

Document Verification System:

• certification_document: Uploaded certification files
• license_document: Professional license files
• photo_id_document: Identity verification
• verification_status: Pending, Verified, Rejected, Expired
• verification_date/notes: Admin tracking
• verified_by: Staff accountability

Business Operations:

• is_available: Current availability status
• hourly_rate/daily_rate: Pricing structure
• average_rating/total_reviews/total_tours_guided: Performance metrics
• base_location: Operating geography

🏨 8. TourAccommodation Model - Lodging Management

Purpose: Manages hotels, resorts, and other accommodations within tours.

Accommodation Details:

• tour (ForeignKey): Parent tour
• name: Property name
• accommodation_type: Hotel, Resort, Guesthouse, Hostel, etc.
• star_rating: Quality classification (1-5 stars)

Location & Logistics:

• address/city: Geographic location
• check_in_day/check_out_day: Tour day scheduling
• room_type/occupancy: Room specifications

Amenities & Booking:

• description/amenities: Property features
• external_booking_url/booking_reference: Third-party integration

🚌 9. TourTransport Model - Transportation Planning

Purpose: Manages all transportation between tour locations.

Transport Details:

• tour (ForeignKey): Parent tour
• transport_type: Bus, Minivan, Car, Train, Plane, Boat, Walking, etc.
• from_location/to_location: Route endpoints
• departure_day/departure_time/arrival_time: Scheduling

Technical Specifications:

• duration_minutes/distance_km: Route metrics
• vehicle_model/capacity/amenities: Vehicle details
• external_booking_url/booking_reference: Third-party booking

🎡 10. TourAttraction Model - Activity & Attraction Management

Purpose: Manages attractions, activities, and sightseeing within tours.

Attraction Details:

• tour (ForeignKey): Parent tour
• what_to_see (ForeignKey): Links to destinations app
• name/description: Custom attraction details
• visit_day/visit_time/duration_minutes: Scheduling

Location & Pricing:

• address/city: Geographic context
• entrance_fee_included/ticket_price: Cost management
• external_booking_url/booking_reference: Third-party integration

📋 11. TourBooking Model - Customer Booking Management

Purpose: Central booking management with integrated flight booking capabilities.

Booking Identity:

• booking_number: Unique identifier (auto-generated)
• tour/schedule: Booked tour and specific date
• customer: User account association

Customer Information:

• lead_traveler_name/email/phone: Primary contact
• adult_count/child_count/senior_count/total_participants: Group composition

Financial Management:

• base_price/total_price: Pricing breakdown
• discount_amount/tax_amount/commission_amount: Financial details
• booking_status/payment_status: Status tracking

Special Requirements:

• special_requests/dietary_requirements/accessibility_needs: Customer needs
• external_booking_id/external_confirmation: Third-party integration

✈️ Integrated Flight Booking:

• flight_booking_required: Boolean flag
• selected_flights (ManyToMany): Associated flights
• flight_class: Economy, Business, First
• flight_total_cost: Financial tracking
• flight_booking_status/confirmation_number: Flight-specific status
• flight_notes: Special flight requirements

Staff Assignment:

• assigned_guide/sales_agent: Human resource allocation

👥 12. TourParticipant Model - Individual Traveler Management

Purpose: Detailed information for each tour participant.

Participant Classification:

• booking (ForeignKey): Parent booking
• participant_type: Adult, Child, Senior, Infant

Personal Information:

• first_name/last_name/date_of_birth: Identity
• nationality/passport_number/passport_expiry: Travel documents
• passport_image: Document verification upload

Special Needs:

• dietary_requirements/medical_conditions: Health considerations
• emergency_contact_name/phone: Safety information

✈️ 13. TourFlightBooking Model - Individual Flight Reservations

Purpose: Manages individual flight bookings for each tour participant.

Flight Association:

• tour_booking/participant/flight: Three-way relationship
• seat_class/seat_number: Seating preferences
• meal_preference: Special dietary needs

Financial Tracking:

• base_fare/taxes_fees/total_cost: Detailed pricing
• booking_status: Pending, Confirmed, Ticketed, Cancelled, Refunded

Airline Integration:

• airline_booking_reference/ticket_number: Airline system integration
• special_requests: Wheelchair assistance, extra legroom, etc.

14. TourImage Model - Visual Content Management

Purpose: Manages tour photo galleries and visual content.

Image Management:

• tour (ForeignKey): Parent tour
• image: File upload to 'tours/gallery/'
• caption/caption_vi/alt_text: Multilingual descriptions
• is_featured/order: Display priority and sequencing

📋 15. TourInclusion Model - Package Component Management

Purpose: Detailed tracking of what's included, excluded, or optional in tours.

Inclusion Management:

• tour (ForeignKey): Parent tour
• inclusion_type: Included, Not Included, Optional
• item/item_vi: Multilingual item descriptions
• description/description_vi: Detailed explanations
• additional_cost: Pricing for optional items

🔄 16. ExternalTourSync Model - Third-Party Integration

Purpose: Manages synchronization with external tour providers like Viator, GetYourGuide.

Sync Management:

• tour (OneToOne): Connected tour
• external_provider/external_tour_id: Source system identification
• last_sync_date/sync_status/sync_errors: Sync health monitoring

Pricing Sync:

• external_price/markup_percentage: Dynamic pricing management

🎯 Business Workflow Integration

Complete Tour Creation Workflow:

1. TourOperator → Creates company profile
2. TourCategory → Organizes tour types
3. Tour → Core tour creation with flight requirements
4. TourFlight → Links specific flights to tours
5. TourItinerary → Day-by-day planning
6. TourSchedule → Availability management
7. TourAccommodation/Transport/Attraction → Logistics planning
8. TourGuide → Staff assignment

Customer Booking Workflow:

1. TourBooking → Customer makes reservation
2. TourParticipant → Individual traveler details
3. TourFlightBooking → Individual flight reservations
4. Payment & Confirmation → Complete booking process

Operational Management:

• TourImage/TourInclusion → Marketing content
• ExternalTourSync → Third-party integration
• Performance tracking → Analytics across all models

This comprehensive model structure supports a full-featured tour operations platform with integrated flight booking, multilingual support, external API integration, and detailed participant management