Dev.Database Schema

Normalization

Naming conventions

• All in lowercase
• No hyphen, space
• Always use semantically meaningful names
• 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