{ "activities": [ "id", "name", "slug", "destination", "location", "description", "duration_hours", "created_at" ], "activity_images": [ "id", "activity_id", "image_path", "image_url", "alt_text", "is_primary" ], "air_india_leads": [ "id", "name", "phone", "from_city", "to_city", "trip_type", "departure_date", "return_date", "passengers", "travel_class", "source", "status", "utm_source", "utm_medium", "utm_campaign", "ip_address", "user_agent", "created_at" ], "airports": [ "iata_code", "city", "airport_name", "country", "metro_mapping", "search_aliases", "active_flag", "popularity_score", "route_availability" ], "backlinks": [ "id", "target_url", "anchor_text", "source_url", "vendor", "status", "scheduled_at", "posted_at", "log", "created_at" ], "booking_events": [ "id", "booking_id", "event_name", "event_data", "ip_address", "user_agent", "created_at" ], "careers_application_docs": [ "id", "application_id", "dob", "gender", "father_name", "current_address", "city", "state", "pincode", "aadhaar_no", "pan_no", "tenth_board", "tenth_year", "tenth_percentage", "graduation_degree", "graduation_stream", "graduation_college", "graduation_year", "graduation_percentage", "total_experience_years", "last_company", "last_designation", "last_ctc", "aadhaar_file", "pan_file", "tenth_marksheet_file", "graduation_marksheet_file", "resume_file", "experience_letter_file", "last_offer_letter_file", "salary_slip_1_file", "salary_slip_2_file", "salary_slip_3_file", "created_at", "updated_at" ], "careers_applications": [ "id", "application_id", "role", "full_name", "phone", "email", "resume_file", "passport_photo", "payment_status", "assessment_status", "assessment_score", "created_at", "updated_at", "ip_address", "user_agent", "amount_paise", "currency", "razorpay_order_id", "razorpay_payment_id", "razorpay_signature", "amount_paid", "paid_at", "father_name", "dob", "gender", "current_address", "city", "state", "pincode", "patna_confirm", "aadhaar_no", "pan_no", "tenth_board", "tenth_year", "tenth_percentage", "graduation_degree", "graduation_stream", "graduation_college", "graduation_year", "graduation_percentage", "has_experience", "total_experience_years", "last_company", "last_designation", "last_ctc", "aadhaar_file", "pan_file", "tenth_marksheet_file", "graduation_marksheet_file", "experience_letter_file", "last_offer_letter_file", "salary_slip_1_file", "salary_slip_2_file", "salary_slip_3_file" ], "destinations": [ "id", "name", "slug", "hero_image", "description", "seo_title", "seo_desc", "is_active", "display_order", "created_at", "pkg_count" ], "flight_bookings": [ "id", "ref_id", "slug", "status", "pax_name", "pax_phone", "pax_email", "flight_airline", "flight_number", "flight_from", "flight_to", "flight_dep_date", "flight_dep_time", "flight_arr_date", "flight_arr_time", "flight_class", "flight_operator", "flight_dep_terminal", "flight_arr_terminal", "fare_base", "fare_taxes", "fare_total", "razorpay_order_id", "razorpay_payment_id", "razorpay_signature", "pnr", "ticket_sent", "admin_notes", "created_by", "created_at", "updated_at", "ret_airline", "ret_flight_number", "ret_dep_date", "ret_dep_time", "ret_arr_date", "ret_arr_time", "ret_operator", "trip_type", "flight_aircraft", "flight_stops", "flight_stopover", "flight_baggage", "flight_cabin_bag", "flight_meal", "flight_refund", "ret_aircraft", "ret_stops", "ret_stopover", "ret_baggage", "ret_cabin_bag", "ret_dep_terminal", "ret_arr_terminal", "pax_details", "pax_adults", "pax_children", "pax_infants", "ticket_number", "booking_type", "agent_id" ], "flights": [ "id", "origin_code", "dest_code", "flight_date", "airline", "flight_no", "dep_time", "arr_time", "price", "seats", "sold_out", "message", "pulled_at", "uploaded_to_portal" ], "group_booking_requests": [ "id", "origin", "destination", "travel_date", "pax_count", "contact_name", "contact_email", "contact_phone", "status", "created_at" ], "holiday_leads": [ "id", "package_id", "package_title", "destination", "name", "email", "phone", "travel_date", "num_adults", "num_children", "message", "source", "status", "assigned_to", "priority", "follow_up_date", "last_contacted", "lead_score", "tags", "utm_source", "utm_medium", "utm_campaign", "landing_page", "created_at", "auto_contacted", "intent_score", "followup_24h", "followup_72h", "wa_deeplink", "auto_messages", "closing_tier", "closing_offer_at", "closing_wa_link" ], "hotel_images": [ "id", "hotel_id", "image_path", "image_url", "alt_text", "is_primary" ], "hotels": [ "id", "name", "slug", "city", "destination", "star_rating", "address", "description", "highlights", "negatives", "created_at", "room_info" ], "inclusions": [ "id", "package_id", "content", "is_exclusion", "category", "display_order" ], "itinerary": [ "id", "package_id", "day_number", "title", "description", "hotel_name", "city", "meals", "hotel_star", "room_type", "meals_breakfast", "meals_lunch", "meals_dinner" ], "jobs": [ "id", "type", "payload", "status", "error", "created_at", "updated_at" ], "lead_notes": [ "id", "lead_id", "note", "type", "created_by", "created_at" ], "package_activities": [ "id", "package_id", "activity_id", "day_number", "is_included", "notes", "display_order" ], "package_flights": [ "id", "package_id", "flight_from", "flight_to", "is_included", "airline", "notes" ], "package_hotels": [ "id", "package_id", "hotel_id", "room_type", "day_from", "day_to", "meal_plan", "city", "display_order" ], "package_transfers": [ "id", "package_id", "day_number", "transfer_type", "vehicle_name", "notes", "from_location", "to_location", "is_included", "created_at", "route_from", "route_to" ], "packages": [ "id", "dest_id", "title", "slug", "overview", "price_per_person", "original_price", "price_label", "nights", "days", "cities", "cities_count", "hero_image", "nexus_link", "ex_city", "is_honeymoon", "is_premium", "is_active", "hotels_count", "activities_count", "transfers_count", "star_rating", "created_at", "nexus_id", "flights_included", "flights_info", "travel_insurance", "commission", "commission_type" ], "page_analytics": [ "id", "page_url", "page_type", "job_role", "ip_address", "user_agent", "referrer", "session_id", "viewed_at" ], "page_tracker": [ "id", "page_name", "ip_address", "visit_time" ], "page_views": [ "id", "page_url", "package_id", "dest_id", "ip_address", "user_agent", "referrer", "created_at" ], "pages": [ "id", "title", "slug", "body", "status", "created_at", "updated_at" ], "posts": [ "id", "title", "slug", "excerpt", "body", "cover_image_url", "status", "scheduled_at", "published_at", "author_id", "created_at", "updated_at" ], "route_clicks": [ "id", "from_city", "to_city", "segment", "click_count", "clicked_at" ], "saved_travellers": [ "id", "user_email", "title", "first_name", "last_name", "dob", "gender", "created_at" ], "search_misses": [ "id", "search_term", "created_at" ], "settings": [ "k", "v", "updated_at" ], "sightseeing_library": [ "id", "title", "description", "location", "destination", "image_path", "created_at" ], "sikkim_bookings": [ "id", "booking_code", "name", "phone", "email", "city", "pax", "amount", "status", "remarks", "source", "razorpay_order_id", "payment_id", "created_at", "updated_at", "lastfollowup", "aadhaar_path", "photo_path" ], "support_tickets": [ "id", "booking_id", "lead_id", "category", "priority", "owner", "status", "SLA_due", "message", "created_at", "updated_at" ], "tbf_ab_tests": [ "id", "test_name", "variant_a", "variant_b", "impressions_a", "impressions_b", "conversions_a", "conversions_b", "status", "winner", "confidence", "created_at" ], "tbf_ad_leads": [ "id", "session_id", "utm_source", "utm_medium", "utm_campaign", "utm_content", "utm_term", "landing_page", "referrer", "ip_address", "user_agent", "device_type", "country", "city", "phone", "email", "lead_status", "notes", "created_at", "updated_at" ], "tbf_admin_notes": [ "id", "order_ref", "note", "note_type", "created_by", "created_at" ], "tbf_agent_attendance": [ "id", "session_id", "agent_id", "agent_name", "email", "session_date", "login_time", "logout_time", "status", "current_break_type", "current_break_start", "total_work_seconds", "total_break_seconds", "break_count", "last_heartbeat", "leads_handled", "messages_sent", "conversions", "created_at" ], "tbf_agent_break_logs": [ "id", "session_id", "agent_id", "break_type", "break_start", "break_end", "duration_seconds", "created_at" ], "tbf_agent_logs": [ "id", "agent_key", "run_at", "duration_ms", "result", "items_processed", "output_text", "error_message" ], "tbf_agent_registry": [ "id", "agent_key", "agent_name", "description", "icon", "category", "schedule_label", "file_path", "is_active", "last_run_at", "last_run_ms", "last_run_result", "last_run_output", "total_runs", "total_success", "total_errors", "items_processed", "created_at", "updated_at" ], "tbf_agent_tasks": [ "id", "lead_id", "assigned_agent", "task_type", "context", "status", "created_at", "completed_at" ], "tbf_agents": [ "id", "name", "email", "phone", "password_hash", "role", "is_active", "status", "last_login", "created_at", "updated_at" ], "tbf_amendment_requests": [ "id", "request_ref", "order_ref", "customer_id", "source", "request_type", "status", "priority", "details", "admin_notes", "refund_amount", "penalty_amount", "created_at", "updated_at", "resolved_at" ], "tbf_api_access_log": [ "id", "ip_address", "action", "user_agent", "referer", "origin", "payload_hash", "payload_size", "response_code", "order_ref", "contact_email", "risk_score", "duration_ms", "session_id", "geo_country", "created_at" ], "tbf_audit_logs": [ "id", "actor_type", "actor_id", "action", "entity_type", "entity_id", "metadata_redacted", "ip_address_hash", "user_agent_hash", "created_at" ], "tbf_b2b_agencies": [ "id", "agency_name", "contact_person", "email", "password_hash", "phone", "pan_number", "gst_number", "wallet_balance", "markup_type", "markup_value", "status", "created_at", "updated_at" ], "tbf_b2b_agents": [ "id", "agency_name", "contact_person", "email", "phone", "password_hash", "gst_number", "pan_number", "wallet_balance", "markup_percentage", "status", "created_at" ], "tbf_b2b_audit_logs": [ "id", "partner_id", "admin_id", "action", "description", "ip_address", "user_agent", "created_at" ], "tbf_b2b_leads": [ "id", "full_name", "phone", "email", "business_name", "city", "business_type", "monthly_volume", "main_requirement", "message", "source", "status", "created_at", "updated_at" ], "tbf_b2b_partners": [ "id", "agency_name", "contact_person", "email", "phone", "password_hash", "gst_number", "pan_number", "address", "city", "state", "monthly_booking_volume", "main_requirement", "business_type", "owner_name", "status", "application_status", "account_status", "kyc_status", "payment_mode", "markup_percentage", "wallet_balance", "credit_limit", "assigned_coordinator", "api_key", "created_at", "updated_at", "last_login_at", "approved_at", "approved_by", "rejected_at", "rejection_reason" ], "tbf_b2b_wallet_transactions": [ "id", "agent_id", "amount", "type", "reference_id", "description", "balance_after", "created_at", "status" ], "tbf_b2b_wallet_tx": [ "id", "partner_id", "amount", "type", "status", "reference_type", "reference_id", "description", "balance_after", "admin_notes", "created_at", "updated_at" ], "tbf_b2c_users": [ "id", "first_name", "last_name", "email", "password_hash", "phone", "user_type", "company_name", "gst_number", "created_at", "updated_at" ], "tbf_blocked_ips": [ "id", "ip_address", "reason", "blocked_by", "blocked_at", "expires_at", "is_active" ], "tbf_booking_comments": [ "id", "booking_id", "agent_id", "agent_name", "comment", "comment_type", "created_at" ], "tbf_booking_events": [ "id", "order_ref", "event_type", "event_data", "created_at" ], "tbf_booking_fingerprints": [ "fingerprint", "order_ref", "ip_address", "created_at" ], "tbf_booking_status_history": [ "id", "order_ref", "previous_status", "new_status", "source", "reason_code", "reason_message_sanitized", "actor_type", "actor_id", "to_status", "changed_by", "reason", "created_at" ], "tbf_campaigns": [ "id", "campaign_key", "name", "description", "campaign_type", "promo_code", "discount_type", "discount_value", "min_order", "target_segment", "start_date", "end_date", "status", "impressions", "clicks", "conversions", "revenue", "email_subject", "email_body", "social_post", "created_at" ], "tbf_competitor_intel": [ "id", "competitor", "intel_type", "title", "summary", "source_url", "our_response", "priority", "status", "created_at" ], "tbf_consent_audit": [ "id", "user_session_id", "trace_id", "old_fare", "new_fare", "decision", "created_at" ], "tbf_crm_leads": [ "id", "name", "phone", "email", "source", "lead_type", "origin", "destination", "travel_date", "return_date", "pax_count", "cabin_class", "budget", "status", "priority", "assigned_agent_id", "remarks", "meta_lead_id", "whatsapp_msg_id", "meta_form_id", "meta_page_id", "meta_ad_name", "last_wa_message", "last_contacted", "follow_up_date", "meta_campaign", "meta_adset", "utm_source", "utm_medium", "utm_campaign", "created_at", "updated_at", "agent_stage", "ai_paused", "last_agent_action", "ops_crm_synced" ], "tbf_crm_messages": [ "id", "lead_id", "direction", "channel", "sender_name", "sender_phone", "message_text", "message_type", "external_msg_id", "status", "agent_id", "created_at", "brain_processed", "intake_queued" ], "tbf_crm_remarks": [ "id", "lead_id", "agent_id", "type", "remark", "old_status", "new_status", "created_at" ], "tbf_customers": [ "id", "name", "email", "phone", "password_hash", "google_id", "otp", "otp_expires", "dob", "gender", "address_line", "city", "state", "pincode", "passport_no", "passport_expiry", "preferred_seat", "preferred_meal", "total_bookings", "total_spent", "avatar_url", "last_login_at", "created_at", "updated_at", "role", "agency_name", "gst_number", "wallet_balance", "markup_percentage", "agent_status" ], "tbf_fare_revalidations": [ "id", "order_ref", "result_id", "trace_id_hash", "old_amount", "new_amount", "currency", "search_id", "trace_id", "original_fare", "revalidated_fare", "price_changed", "fare_expiry_at", "supplier_response_ref", "fare_breakdown", "fare_diff", "revalidation_data", "created_at", "status", "result_index" ], "tbf_flight_offers": [ "id", "title", "slug", "description", "scope", "discount_type", "discount_value", "max_discount", "min_fare", "airline_code", "airline_name", "origin_iata", "destination_iata", "cabin_class", "valid_from", "valid_until", "is_active", "priority", "coupon_code", "usage_limit", "usage_count", "show_on_card", "created_at", "updated_at", "coupon_required", "coupon_mode", "offline_booking", "offline_message", "badge_text", "tooltip_text", "terms_text", "display_mode", "stackable", "trip_type", "travel_start", "travel_end", "booking_start", "booking_end", "max_fare", "include_reverse_sector", "airline_codes", "day_of_week", "min_pax", "max_pax", "route_type", "filters_json" ], "tbf_flight_orders": [ "id", "order_ref", "rzp_order_id", "rzp_payment_id", "rzp_signature", "payment_amount", "payment_status", "trace_id", "result_index", "is_lcc", "adivaha_booking_id", "pnr", "return_pnr", "ticket_status", "offline_booking", "offline_message", "airline_code", "airline_name", "flight_number", "origin", "destination", "departure_time", "arrival_time", "trip_type", "is_domestic", "fare_total", "lead_pax_name", "contact_email", "contact_phone", "customer_ip", "fraud_risk_score", "fraud_hold", "fraud_review_status", "passenger_count", "passenger_data", "booking_payload", "formatted_passengers", "book_response", "ticket_response", "details_response", "poll_count", "last_polled_at", "created_at", "updated_at", "email_sent" ], "tbf_fraud_alerts": [ "id", "order_ref", "risk_score", "risk_factors", "action_taken", "ip_address", "user_agent", "contact_email", "contact_phone", "lead_pax_name", "payload_hash", "reviewed_by", "reviewed_at", "review_notes", "created_at" ], "tbf_keyword_tracking": [ "id", "keyword", "current_position", "previous_position", "target_url", "impressions", "clicks", "last_checked" ], "tbf_leader_reports": [ "id", "report_type", "fleet_health", "active_agents", "error_agents", "total_items_processed", "report_json", "emailed_at", "created_at" ], "tbf_markup_rules": [ "id", "user_type", "airline_code", "markup_type", "markup_value", "is_active", "created_at", "updated_at" ], "tbf_mis_excel_imports": [ "id", "sector", "sub_sector", "route_name", "inquiries", "bookings", "gmv", "net_margin", "period_label", "created_at" ], "tbf_notifications": [ "id", "customer_id", "type", "title", "message", "link", "is_read", "created_at" ], "tbf_offers": [ "id", "title", "description", "image_url", "promo_code", "discount_type", "discount_value", "valid_until", "is_active", "created_at", "updated_at" ], "tbf_ops_crm": [ "id", "phone", "name", "email", "status", "sector_from", "sector_to", "travel_date", "return_date", "booking_ref", "agent_name", "last_comment", "created_at", "updated_at", "amount_quoted" ], "tbf_ops_crm_comments": [ "id", "crm_id", "comment", "status_at_time", "agent_name", "created_at" ], "tbf_ops_crm_views": [ "id", "crm_id", "agent_name", "viewed_at" ], "tbf_page_analytics": [ "id", "session_id", "visitor_id", "page_type", "page_url", "referrer", "utm_source", "utm_medium", "utm_campaign", "search_from", "search_to", "search_date", "search_cabin", "search_pax", "device_type", "browser", "screen_w", "ip_address", "country", "city", "created_at" ], "tbf_payment_attempts": [ "id", "order_ref", "rzp_order_id", "amount", "currency", "status", "failure_reason_sanitized", "gateway_response_ref", "idempotency_key", "rzp_payment_id", "gateway_response", "created_at", "updated_at", "attempt_number", "failure_reason" ], "tbf_price_alerts": [ "id", "user_name", "user_phone", "user_email", "from_city", "to_city", "target_price", "last_notified_price", "notifications_sent", "is_active", "created_at", "last_notified_at" ], "tbf_request_nonces": [ "nonce_hash", "action", "ip_address", "order_ref", "created_at" ], "tbf_reviews": [ "id", "lead_id", "customer_name", "customer_email", "rating", "review_text", "destination", "status", "review_requested_at", "reviewed_at", "google_review_requested", "created_at" ], "tbf_saved_travellers": [ "id", "customer_id", "title", "first_name", "last_name", "dob", "gender", "nationality", "passport_no", "passport_expiry", "passport_country", "created_at" ], "tbf_seo_metrics": [ "id", "metric_name", "metric_value", "recorded_at" ], "tbf_service_request_events": [ "id", "request_type", "request_id", "event_type", "old_status", "new_status", "message_sanitized", "visibility", "actor_type", "actor_id", "created_at" ], "tbf_settings": [ "setting_key", "setting_value", "setting_group", "is_secret", "description", "updated_by", "updated_at" ], "tbf_site_settings": [ "setting_key", "setting_value", "updated_at" ], "tbf_social_leads": [ "id", "platform", "sender_id", "sender_name", "message_text", "auto_replied", "created_at" ], "tbf_supplier_api_logs": [ "id", "request_id", "supplier", "endpoint", "request", "response", "status", "duration_ms", "retry_count", "request_redacted", "response_redacted", "error_category", "environment", "search_id", "created_at", "function_name", "internal_ref_type", "internal_ref_id", "http_status", "supplier_error_code", "supplier_error_message_sanitized", "response_time_ms", "request_payload", "response_payload", "error_message" ], "tbf_support_tickets": [ "id", "ticket_ref", "customer_id", "order_ref", "category", "subject", "description", "status", "priority", "assigned_to", "created_at", "updated_at", "resolved_at" ], "tbf_ticket_messages": [ "id", "ticket_id", "sender_type", "sender_name", "message", "attachment_url", "created_at" ], "tbf_ticketing_records": [ "id", "order_ref", "supplier", "ticketing_endpoint", "attempt_no", "status", "pnr", "ticket_number_masked", "supplier_booking_id", "error_category", "error_message_sanitized", "request_ref", "response_ref", "created_at", "updated_at" ], "tbf_visitor_heartbeat": [ "visitor_id", "session_id", "page_url", "page_type", "last_seen" ], "tbf_wa_agent_log": [ "id", "agent_name", "lead_id", "phone", "action", "details", "status", "tokens_used", "duration_ms", "created_at" ], "tbf_wa_automations_queue": [ "id", "lead_id", "phone", "trigger_type", "message_draft", "status", "created_at", "sent_at", "error_msg" ], "tbf_wa_intake_queue": [ "id", "lead_id", "phone", "conversation", "status", "extracted_data", "missing_fields", "gpt_tokens_used", "attempts", "created_at", "updated_at", "processed_at" ], "tbf_wa_outreach": [ "id", "lead_id", "phone", "name", "segment", "message", "wa_link", "status", "created_at", "sent_at", "responded_at", "brain_processed" ], "tbf_wa_quote_requests": [ "id", "intake_id", "lead_id", "phone", "origin", "destination", "travel_date", "return_date", "trip_type", "pax_adult", "pax_child", "pax_infant", "cabin_class", "preferences", "req_data", "status", "attempts", "created_at", "updated_at" ], "tbf_wa_quote_results": [ "id", "request_id", "lead_id", "phone", "raw_results", "formatted_message", "options_count", "status", "sent_at", "wa_msg_id", "created_at", "updated_at" ], "tbf_wa_system_logs": [ "id", "status", "last_ping_at", "error_message" ], "tbf_wallet_txns": [ "id", "agency_id", "amount", "txn_type", "reference_id", "description", "created_at" ], "tbf_webhook_events": [ "id", "provider", "event_id", "event_type", "signature_verified", "related_order_ref", "payload_redacted", "processing_status", "processed_at", "created_at" ], "tbf_webhook_logs": [ "id", "source", "event_type", "payload", "status", "error_message", "lead_id", "created_at" ], "users": [ "id", "email", "password_hash", "role", "created_at" ], "wa_conversations": [ "id", "remote_phone", "remote_name", "profile_pic_url", "assigned_agent_id", "last_message_at", "last_message_preview", "unread_count", "status", "crm_lead_id", "created_at" ], "wa_messages": [ "id", "conversation_id", "wa_message_id", "direction", "sender_type", "sender_agent_id", "body", "media_type", "media_url", "status", "created_at" ], "wa_quick_replies": [ "id", "title", "body", "category", "created_by", "created_at" ], "wa_sessions": [ "id", "status", "phone_number", "connected_at", "last_seen" ] }