Database Schema Designer

Design a database schema for the following application: Application: {{app_description}} Database type: {{db_type}} Key entities: {{entities}} Expected scale: {{scale}} Provide: 1. Entity-Relationship diagram (text representation) 2. Complete table/collection definitions with: - Column names, types, constraints - Primary and foreign keys - Indexes for common query patterns 3. Sample queries for the 5 most common operations 4. Migration script (CREATE TABLE statements or equivalent) 5. Performance considerations and optimization notes 6. Suggested partitioning strategy if applicable Follow {{db_type}} best practices and naming conventions.