#MySQL Schema Design

#Design Principles

• Start from query patterns before defining columns and indexes.
• Keep consistency first; denormalize only with clear evidence.
• Separate hot fields from large payload fields.