Table naming conventions in Laravel - Mini Project: Build & Apply

Table Naming Conventions in Laravel

📖 Scenario: You are building a simple Laravel application to manage books and authors. Laravel uses conventions to name database tables automatically based on model names.

🎯 Goal: Learn how to create tables with proper Laravel naming conventions and understand how Laravel links models to tables.

📋 What You'll Learn

Create a model called Book and understand its default table name

Create a model called Author and understand its default table name

Create a custom table name for a model

Use Laravel's migration files to define tables with correct names

💡 Why This Matters

🌍 Real World

Most Laravel applications use these naming conventions to keep code clean and predictable when working with databases.

💼 Career

Understanding Laravel's table naming conventions is essential for backend developers working with Laravel to build scalable and maintainable applications.

1

Create a Book model and migration

Run the artisan command to create a model called Book with a migration file. The migration will create a table named books by Laravel's default naming convention.

Laravel

# Run the artisan command to create Book model and migration
# Your code here

Hint

Use php artisan make:model Book -m to create both model and migration.

2

Create an Author model and migration

Run the artisan command to create a model called Author with a migration file. Laravel will create a table named authors by default.

Laravel

php artisan make:model Book -m
# Run the artisan command to create Author model and migration
# Your code here

Hint

Use php artisan make:model Author -m to create both model and migration.

3

Create a model with a custom table name

Create a model called Person with a migration. Then, inside the Person model file, set the protected property $table to 'people' to override Laravel's default table name.

Laravel

php artisan make:model Book -m
php artisan make:model Author -m
# Create Person model and migration
php artisan make:model Person -m

# In app/Models/Person.php, add protected $table = 'people';
# Your code here

Hint

Override the table name by adding protected $table = 'people'; inside the model class.

4

Define migration files with correct table names

Open the migration files for books, authors, and people tables. Ensure the Schema::create method uses the correct table names: books, authors, and people respectively.

Laravel

php artisan make:model Book -m
php artisan make:model Author -m
php artisan make:model Person -m

// In app/Models/Person.php
<?php

namespace App\Models;

use Illuminate\Database\Eloquent\Model;

class Person extends Model
{
    protected $table = 'people';
}

// Edit migration files to use correct table names
# Your code here

Hint

Check each migration file uses Schema::create with the correct table name.

Practice

1. In Laravel, what is the recommended naming convention for database tables?

easy

A. Plural, lowercase, and use underscores (snake_case)

B. Singular, uppercase, and use camelCase

C. Plural, uppercase, and use hyphens

D. Singular, lowercase, and use spaces

Solution

1. Step 1: Understand Laravel's default table naming

   Laravel expects table names to be plural and lowercase with underscores separating words (snake_case).

2. Step 2: Compare options with Laravel conventions

   Only Plural, lowercase, and use underscores (snake_case) matches plural, lowercase, and underscores. Others use singular, uppercase, or invalid characters.

3. Final Answer:

   Plural, lowercase, and use underscores (snake_case) -> Option A

4. Quick Check:

   Table names = plural + lowercase + underscores [OK]

Hint: Tables are plural and snake_case in Laravel [OK]

Common Mistakes:

• Using singular table names
• Using camelCase or spaces in table names
• Using uppercase letters in table names

2. Which of the following is the correct Laravel table name for a model named ProductCategory?

easy

A. productCategories

B. productcategories

C. ProductCategories

D. product_categories

Solution

1. Step 1: Convert model name to table name format

   Laravel converts camel case model names to snake_case plural table names.

2. Step 2: Apply plural and snake_case

   ProductCategory becomes product_category, then plural is product_categories.

3. Final Answer:

   product_categories -> Option D

4. Quick Check:

   Model ProductCategory = table product_categories [OK]

Hint: Convert camelCase to snake_case and pluralize [OK]

Common Mistakes:

• Not pluralizing the table name
• Using camelCase or PascalCase for table names
• Using singular form instead of plural

3. Given the Laravel model UserProfile, which table name will Laravel assume by default when querying?

medium

A. userProfile

B. userprofile

C. user_profiles

D. UserProfiles

Solution

1. Step 1: Understand Laravel's default table naming from model

   Laravel converts model names from camel case to snake_case and pluralizes them.

2. Step 2: Apply to UserProfile

   UserProfile becomes user_profile, then pluralized to user_profiles.

3. Final Answer:

   user_profiles -> Option C

4. Quick Check:

   UserProfile model = user_profiles table [OK]

Hint: Model name to snake_case plural table [OK]

Common Mistakes:

• Using singular or camelCase table names
• Not pluralizing the table name
• Using uppercase letters in table names

4. You have a Laravel model named OrderItem but the table is named orderitems. What issue will this cause?

medium

A. Laravel will query the orderitems table correctly without issues.

B. Laravel will not find the table automatically and cause a runtime error.

C. Laravel will throw a syntax error due to table name casing.

D. Laravel will convert the table name automatically to order_items.

Solution

1. Step 1: Check Laravel's table naming expectation

   Laravel expects the table name to be plural and snake_case, so for OrderItem it expects order_items.

2. Step 2: Analyze mismatch impact

   If the table is named orderitems (no underscore), Laravel won't find it automatically and will cause a runtime error.

3. Final Answer:

   Laravel will not find the table automatically and cause a runtime error. -> Option B

4. Quick Check:

   Table name mismatch = runtime error [OK]

Hint: Table name must match snake_case plural exactly [OK]

Common Mistakes:

• Assuming Laravel auto-corrects table names
• Thinking casing causes syntax errors
• Ignoring runtime errors from missing tables

5. You want to use a Laravel model Person but your database table is named people_records. How can you correctly link the model to this table?

hard

A. Set the protected $table property in the model to 'people_records'.

B. Rename the table to people to follow conventions.

C. Change the model name to PeopleRecord to match the table.

D. Laravel will automatically detect the table people_records.

Solution

1. Step 1: Understand Laravel's default table detection

   Laravel expects the table name to be plural snake_case of the model name, so Person expects people.

2. Step 2: Link model to custom table

   To use a differently named table like people_records, set protected $table = 'people_records' in the model.

3. Final Answer:

   Set the protected $table property in the model to 'people_records'. -> Option A

4. Quick Check:

   Custom table name = set $table property [OK]

Hint: Use $table property to link custom table names [OK]

Common Mistakes:

• Assuming Laravel auto-detects non-standard table names
• Renaming model instead of setting $table
• Renaming database tables unnecessarily