ArchitectureGeneric
Database Schema Design
Design a database schema from requirements
Prompt
I need a database schema for [describe the domain]. Key requirements:
[list requirements]
Design the schema with:
1. Tables, columns, and types
2. Primary and foreign keys
3. Indexes for expected query patterns: [list main queries]
4. Any constraints or validations at the DB level
Explain any non-obvious decisions. Use [PostgreSQL/MySQL/SQLite] conventions.