Dev.Database Schema

Normalization

Naming conventions

• All in lowercase
• No hypthen, space
• Naming tables/fields in singular
• Always define a auto_increment column "id", as primary key if applicable
• Do not prepend table name to field name
• Do not use preserved keywords, like "date"

Attributes suggestion