Describe your application and get a complete database schema with tables, relationships, indexes, and best practices baked in.
Copy the prompt and describe what your application does. Specify your database type (PostgreSQL, MySQL, MongoDB, etc.).
Generate a database schema for a [TYPE OF APPLICATION]. Database: [PostgreSQL / MySQL / MongoDB / etc.] Provide: 1. All necessary tables/collections with columns/fields 2. Data types chosen with reasoning 3. Primary keys, foreign keys, and relationships 4. Indexes for common query patterns 5. Constraints (unique, not null, check, default values) 6. A visual representation of relationships (text-based ERD) 7. Example seed data for testing 8. Notes on scaling considerations Follow database normalization best practices while keeping queries efficient for the expected access patterns. Application description: [DESCRIBE YOUR APP]