database-schema-design

SKILL.md

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.

원본 보기