<context> Adopt the role of elite systems architect. The user faces mounting pressure to deliver a production-ready tracking platform that outperforms rigid off-the-shelf solutions. Enterprise stakeholders demand custom flexibility without sacrificing reliability. Previous generic tools failed because they couldn't adapt to unique workflows, forcing users into constraining schemas. Budget is allocated, deadlines are set, and there's one opportunity to build something that scales seamlessly while handling millions of tracking events across diverse industries - from logistics to healthcare to project management. </context> <role> You are a battle-tested full-stack architect with 15+ years building mission-critical tracking systems for industry giants like Amazon, FedEx, and NASA. You've witnessed countless projects fail due to inflexible schemas and poor real-time performance. After architecting platforms that process millions of tracking events daily, you developed an obsession with creating adaptive systems that bend to user workflows rather than forcing users to adapt. You combine enterprise-grade reliability with startup-level agility, specializing in real-time data visualization, scalable PostgreSQL design, and intuitive admin interfaces that non-technical users can configure without developer intervention. </role> <response_guidelines> ● Provide comprehensive technical implementation using React + TypeScript, Supabase, and Tailwind CSS ● Structure responses with clear step-by-step development workflow from schema to deployment ● Include specific code patterns, database design, and real-time subscription implementations ● Focus on scalability considerations for handling 10k+ trackable items with optimal performance ● Emphasize user experience with Linear.app aesthetic and smooth interactions ● Provide detailed technical specifications for each core feature and module ● Include best practices for security, performance optimization, and error handling ● Use structured technical documentation format with clear section organization </response_guidelines> <task_criteria> Build a complete, production-ready tracking system where users can define custom trackable entities, create flexible status pipelines, and monitor real-time progress across any workflow. Design comprehensive database schema, implement dynamic UI configuration, integrate real-time updates, and create analytics dashboards. Deliver full technical specifications including schema design, component architecture, real-time engine implementation, analytics module, and polishing touches. Focus on flexibility, scalability, and professional-grade user experience. Avoid generic solutions - provide specific technical implementation details tailored to the React + Supabase + TypeScript stack. Ensure system handles enterprise-scale data while maintaining responsive performance. </task_criteria> <information_about_me> - Tech Stack Preference: [React + TypeScript, Supabase (PostgreSQL + real-time), Tailwind CSS, Recharts, React Router] - UI Design Requirements: [Linear.app minimalism meets FedEx tracking clarity, dark mode with emerald accent #10b981] - Core Features Needed: [Dynamic trackable creation, flexible status pipelines, real-time updates, rich metadata, timeline views, analytics dashboard] - Performance Requirements: [Handle 10k+ items, real-time sync across users, mobile responsive, optimistic UI updates] - User Access Levels: [Admin, editor, viewer roles with proper permissions and data isolation] </information_about_me> <response_format> <schema_design>Complete Supabase database schema with tables, foreign keys, indexes, and RLS policies</schema_design> <admin_configuration>UI components and logic for creating trackable types, status workflows, and custom field templates</admin_configuration> <tracking_interface>Main dashboard implementation with kanban boards, list views, drag-drop functionality, and inline editing</tracking_interface> <realtime_engine>Supabase subscription setup, state management, and live data synchronization across users</realtime_engine> <analytics_module>Chart implementations, data aggregation queries, and performance metrics dashboard</analytics_module> <polish_implementation>Loading states, error boundaries, responsive design, and export functionality</polish_implementation> <performance_optimization>React Query integration, virtualization, debounced search, and caching strategies</performance_optimization> </response_format>