{"message":"API Backend Admin C1DO1","status":"running","description":"Simple backend with database connection test","endpoints":["GET /db-test - Test database connection","GET /users?days=7&offset=0&university_id=123 - Get consolidated user statistics (registration, activity, demographics)","GET /users/top-active?days=30&limit=20 - Get top active users in period","GET /users/growth?days=30&offset=0 - Get user growth metrics","GET /videos?days=7&offset=0&university_id=123 - Get consolidated video statistics (uploaded content, processing queue, storage)","GET /videos/by-institution?days=30&limit=10 - Get video statistics by institution","GET /pilots?days=7&offset=0&university_id=123 - Get consolidated pilot statistics (adoption rate, user engagement, license utilization)","GET /pilots/adoption-rate?days=30&limit=20 - Get pilot adoption rate by institution","GET /pilots/user-engagement?days=30&limit=20 - Get pilot user engagement metrics","GET /pilots/license-utilization?days=30&limit=20 - Get license utilization statistics","GET /pilots/engagement-metrics?days=30&limit=20 - Get detailed engagement metrics","GET /pilots/institutional-admins-activity?days=30&limit=20 - Get institutional admins activity","GET /courses?days=7&offset=0&university_id=123 - Get consolidated course statistics (inventory, utilization, completion, quality)","GET /courses/list?university_id=123&limit=100&offset=0 - Get list of courses for a university (for frontend filters)","GET /courses/ai-stages?university_id=123&limit=100 - Get stages with AI enabled (basic info)","GET /courses/ai-stages/processing-stats?stage_id=7020 - Get detailed AI processing statistics for stages","GET /institutions/universities - Get all universities in the system","GET /institutions/faculties?university_id=123 - Get faculties for a university","GET /institutions/careers?faculty_id=456 - Get careers for a faculty","POST /technical-sheets - Create new technical sheet","GET /technical-sheets - Get all technical sheets with filters","GET /technical-sheets/:id - Get technical sheet by ID","PUT /technical-sheets/:id - Update technical sheet","DELETE /technical-sheets/:id - Delete technical sheet","GET /technical-sheets/stats - Get technical sheets statistics","GET /ai/courses-by-type?university_id=123 - Get count of courses by AI type","GET /ai/stages-by-type?university_id=123 - Get count of stages by AI type","POST /ai/configurations - Activate AI in course or stage","GET /ai/feedback-stats?university_id=123 - Get AI feedback usage statistics by institution, course, or stage","GET /processing/ai-teach1 - Get AI Teach1 processing list (filters: course_id, university_id, status, dates, client, limit, offset)","GET /billing/consolidated-daily-stats - Get consolidated daily stats (tokens + costs, only complete days)"],"features":["🔄 Multi-database support (General + DUOC)","🎯 Flexible filtering by university, faculty, and career","📊 Time-based analytics with customizable periods","🛡️ Robust error handling and timeout protection","⚡ Parallel query execution for optimal performance"]}