Database Design

Naming Convention

• Use lowercase: Will help on speed typing, avoid mistakes dues to case sensitivity e.t.c
• No space – use underscore instead
• No numbers in name only alpha English characters
• Valid understandable names like  blog, ecommerce e.t.c but not like project, james, e.t.c
• Name should be self explanatory
• Names should not be more than 64 characters.
• Avoid prefix

source: https://anandarajpandey.com/2015/05/10/mysql-naming-coding-conventions-tips-on-mysql-database/

Tags: database, design, standard