Laravel – Database, Table and Column Naming Conventions?

by

Laravel has its own naming convention. For example, if your model name is User.php then Laravel expects class ‘User’ to be inside that file. It also expects users table for User model. However, you can override this convention by defining a table property on your model like,

    class User extends Eloquent implements UserInterface, RemindableInterface {
        protected $table="user";
    }

From Laravel official documentation:

Note that we did not tell Eloquent which table to use for our User model.
The lower-case, plural name of the class will be used as the table name
unless another name is explicitly specified. So, in this case, Eloquent
will assume the User model stores records in the users table. You may specify a
custom table by defining a $table property on your model

If you will use user table id in another table as a foreign key then, it should be snake-case like user_id so that it can be used automatically in case of relation. Again, you can override this convention by specifying additional arguments in relationship function. For example,

    class User extends Eloquent implements UserInterface, RemindableInterface {
        public function post(){
            return $this->hasMany('Post', 'userId', 'id');
        }
    }

    class Post extends Eloquent{
        public function user(){
            return $this->belongsTo('User', 'userId', 'id');
        }   
    }

Docs for Laravel eloquent relationship

For other columns in table, you can name them as you like.

I suggest you to go through documentation once.

More Related Contents:

  1. Laravel one to many relation with a one to one relation
  2. Get the Last Inserted Id Using Laravel Eloquent
  3. PDOException SQLSTATE[HY000] [2002] No such file or directory
  4. Property Property Property [title] does not exist on this collection instance does not exist on this collection instance does not exist on this collection instance
  5. How to Create Multiple Where Clause Query Using Laravel Eloquent?
  6. How to do this in Laravel, subquery where in
  7. Laravel Eloquent Query Using WHERE with OR AND OR?
  8. How to insert multiple rows from a single query using eloquent/fluent
  9. Laravel – Eloquent or Fluent random row
  10. Laravel update model with unique validation rule for attribute
  11. Add a custom attribute to a Laravel / Eloquent model on load?
  12. Creating and Update Laravel Eloquent
  13. How to sort a Laravel query builder result by multiple columns?
  14. How to alias a table in Laravel Eloquent queries (or using Query Builder)?
  15. Laravel Eloquent Sum of relation’s column
  16. Get the Query Executed in Laravel 3/4
  17. What does “Mass Assignment” mean in Laravel?
  18. Laravel Checking If a Record Exists
  19. How to exclude certains columns while using eloquent
  20. How to alias the name of a column in Eloquent
  21. Laravel 5 hasMany relationship on two columns
  22. Laravel $q->where() between dates
  23. Laravel Recursive Relationships
  24. Laravel nested relationships
  25. Laravel Eloquent – Attach vs Sync
  26. How to create a subquery using Laravel Eloquent?
  27. Natural ORDER in Laravel Eloquent ORM
  28. Eloquent many-to-many-to-many – how to load distant relation easily
  29. Eloquent groupBy make “SQLSTATE[42000]” with valid SQL query in Laravel 5.3
  30. Laravel Eloquent update just if changes have been made

Leave a Comment