Poor database schema design and missing composite indexes cause catastrophic performance bottlenecks once an application scales to tens of thousands of active users.
Act as a Chief Technology Architect. Design a production-grade database schema and API architecture for [Application Name]. Provide SQL DDL with foreign keys, composite index justifications, RESTful API contracts, and scalability trade-off analysis.