Database Schema

Database Schema Design

Instructions

1. Table structure

   • Use clear, descriptive table names
   • Define primary keys (id)
   • Choose correct data types
   • Add timestamps (created_at, updated_at)

2. Relationships

   • One-to-one, one-to-many, many-to-many
   • Use foreign keys
   • Apply cascading rules where needed
   • Normalize data to avoid duplication

3. Migrations

   • Create versioned migrations
   • Separate create, update, and delete migrations
   • Ensure migrations are reversible
   • Keep migrations small and focused

4. Schema constraints

   • NOT NULL where required
   • UNIQUE for emails, usernames, slugs
   • Index frequently queried columns