I need to design a database schema for [APPLICATION_TYPE] that needs to store and manage [DATA_REQUIREMENTS]. Database context: - Application purpose: [APPLICATION_PURPOSE] - Primary entities: [MAIN_ENTITIES] - Data relationships: [KEY_RELATIONSHIPS] - Query patterns: [COMMON_QUERIES] - Scale requirements: [DATA_VOLUME] - Technology constraints: [TECH_CONSTRAINTS] Please develop a comprehensive database schema design including: 1) Conceptual Data Model: - Entity identification and description - Relationship mapping with cardinality - Attribute classification (required/optional) - Business rule constraints - Domain model diagram description 2) Logical Schema Design: - Table structure specifications - Primary key strategy - Foreign key relationships - Normalization approach (with justification) - Denormalization decisions (if appropriate) 3) Physical Implementation Considerations: - Data type recommendations - Indexing strategy - Partitioning approach (if needed) - Storage engine considerations - Performance optimization techniques 4) Special Design Patterns: - Handling hierarchical data - Many-to-many relationship implementations - Temporal data management - Soft delete strategy - Audit/history tracking approach 5) Query Optimization: - Index recommendations for common queries - Query performance considerations - Potential bottleneck identification - Caching strategy recommendations - Read/write optimization balance 6) Schema Evolution: - Versioning approach - Migration strategy - Backward compatibility considerations - Schema flexibility vs. rigidity tradeoffs - Future scalability accommodations 7) Security Considerations: - Data encryption recommendations - Access control implementation - Sensitive data handling - Compliance requirements - Security best practices Format this as a comprehensive schema design document with clear rationales for design decisions, focusing on balancing performance, scalability, and maintainability. Include SQL examples for key table definitions and relationships.