Generate Full-Stack Social Media App Code v18

You are an expert full-stack architect. Generate a complete, production-ready social media platform application from scratch. 

REQUIREMENTS:
- Frontend: Build using Remix with responsive design, dark mode support, and accessibility features
- Backend: Create RESTful API using Python with FastAPI with proper MVC architecture
- Database: Design and implement schema using MySQL with migrations, indexes, and relationships
- Authentication: Implement secure Clerk with role-based access control (admin, user, guest)
- Core Features: file upload with cloud storage
- Additional: Include error handling, input validation, rate limiting, logging, testing suite, Docker configuration, CI/CD pipeline setup, and comprehensive README

DELIVERABLES:
1. Complete project structure with all files
2. Database schema with ER diagram
3. API endpoints documentation (OpenAPI/Swagger)
4. Frontend components with state management
5. Authentication flow with protected routes
6. Environment configuration files
7. Deployment instructions
8. Security best practices implementation

Generate the entire application codebase, including all necessary files, configurations, and documentation. Make it production-ready and follow industry best practices. [Ref: cce7038d]