database-schema-design

Design scalable, normalized database schemas with proper relationships, constraints, and data types. Includes normalization techniques, relationship patterns, and constraint strategies.

❌ Don't skip normalization for convenience ❌ Don't use VARCHAR(MAX) for all text fields ❌ Don't forget to add foreign key constraints ❌ Don't use natural keys as primary keys ❌ Don't store calculated values in base tables

✅ DO use UUIDs or sequences for primary keys ✅ DO normalize data appropriately ✅ DO add CHECK constraints for data validity ✅ DO create indexes on foreign keys ✅ DO use TIMESTAMP for audit trails

تصميم مخططات قاعدة البيانات مع التطبيع والعلاقات والقيود. يُستخدم عند إنشاء مخططات قاعدة بيانات جديدة، أو تصميم الجداول، أو تخطيط نماذج البيانات لـ PostgreSQL وMySQL. المصدر: aj-geddes/useful-ai-prompts.