Generate comprehensive SQL database schemas with proper relationships, indexes, and performance optimizations for various application types.