Database Schema Designer

Design a database schema for [application/project]. REQUIREMENTS: • [Core entity 1] with attributes: [list] • [Core entity 2] with attributes: [list] • Relationships: [one-to-many, many-to-many, etc.] SCHEMA: ```sql CREATE TABLE [entity1] ( id UUID PRIMARY KEY DEFAULT gen_random_uuid(), created_at TIMESTAMPTZ DEFAULT NOW(), updated_at TIMESTAMPTZ DEFAULT NOW() ); ``` INDEXES: • Primary key on id (clustered) • Foreign key indexes on [columns] • Composite index on [columns] for common queries • Full-text search index on [text columns] RELATIONSHIPS: • [Entity1] → [Entity2]: One-to-Many via [foreign_key] • [Entity1] ↔ [Entity3]: Many-to-Many via [join_table] MIGRATION STRATEGY: • Version-controlled SQL migrations • Up/down functions for rollback • Seed data for development