Snake case names separate words with underscores, usually in lowercase: first_name. It gives database attributes a consistent, readable form and helps prevent typos and query-maintenance errors. section 4.2
Use snake case as part of a deliberate naming policy:
- Choose one convention for attribute names and apply it consistently. section 4.2
- Write multiword attributes with underscores, such as first_name. section 4.2
- Check that names stay within the database system’s length limit; MariaDB allows up to 64 characters. section 4.2
- Avoid reserved SQL keywords as entity or attribute names because they can cause syntax and maintenance problems. section 4.2
