Tag

Schema Guidelines

1 views collected around this technical thread.

Efficient Ops
Efficient Ops
Jul 14, 2024 · Databases

10 Essential MySQL Table Naming Rules Every Engineer Should Follow

This article presents Alibaba's concise 10‑point MySQL schema standard, covering boolean field naming, lowercase identifiers, singular table names, reserved word avoidance, index naming conventions, decimal usage, fixed‑length char, variable‑length varchar/text, mandatory audit fields, and the prohibition of physical deletions, offering practical guidance for clean database design.

Best PracticesDatabase DesignMySQL
0 likes · 5 min read
10 Essential MySQL Table Naming Rules Every Engineer Should Follow