Perform a comprehensive **database architecture and design review** of the entire monorepo, reviewing each application/folder independently as well as the platform as a whole. Analyze the database schema, data models, indexing strategy, queries, aggregations, relationships, transactions, migrations, data integrity, scalability, performance, security, and operational practices. Identify **critical, high, and medium-impact issues** related to database design, query efficiency, indexing, storage, consistency, maintainability, and future scalability. For each finding, provide the **issue, affected collections/tables, root cause, performance or operational impact, recommended improvement, implementation plan (high level), priority, and why it is critical**. Prioritize recommendations that improve query performance, scalability, data integrity, reliability, cost efficiency, and long-term maintainability while aligning with modern database best practices.