To create a database table associated with the Eloquent model in Laravel, you need to define the structure through migration. 1. Use php artisan make:model Article -mf to generate the model, migration and factory at the same time; 2. If you only need to migrate, run php artisan make:migration create_articles_table; 3. Define fields in the up() method of the migration file, such as id, title, content, foreign key user_id, and use foreignId to establish constraints; 4. It is recommended to use plural forms for table names and consistent with the $table attribute in the model; 5. Run php artisan migrate to perform migration; 6. Pay attention to maintaining the consistency of the model, factory, and Seeder to avoid table name conflicts, foreign key failures and field types inconsistencies.

In Laravel, if you want to create a database table associated with the Eloquent model, you need to define the structure of this table through migration. Laravel's migration system allows you to manage changes in database structure in code and maintain good correspondence with the model.

Automatically generate migration files when creating a model

When you use the Artisan command to create a model, you can generate migration files and factory classes at the same time by adding -mf or --migration --factory parameters:

 php artisan make:model Article -mf

This command creates the following:

• A model file: app/Models/Article.php
• A migration file, such as: database/migrations/2025_04_05_000000_create_articles_table.php
• A factory class: database/factories/ArticleFactory.php

If you only want to migrate files, you can also run it separately:

 php artisan make:migration create_articles_table

Define table structure in migration file

After generating the migration file, open it and define the table and fields you want to create in up() method. For example, suppose you want to create a table for the Article model, you can write it like this:

 public function up()
{
    Schema::create('articles', function (Blueprint $table) {
        $table->id();
        $table->string('title');
        $table->text('content')->nullable();
        $table->unsignedBigInteger('user_id');
        $table->foreignId('user_id')->constrained()->onDelete('cascade');
        $table->timestamps();
    });
}

Here are a few key points to pay attention to:

• Table names are usually in plural forms (such as articles ) and are consistent with $table attribute in the model (if not specified, the default is automatically plural).
• Use foreignId to establish foreign key constraints to ensure data integrity
• If you need soft delete function, you can add $table->softDeletes();

Run the migration:

 php artisan migrate

Make sure the model binds table names correctly

The Eloquent model will automatically infer the corresponding table name based on the class name by default (converted to lowercase plural). But for the sake of safety, you can explicitly specify the table name in the model:

 class Article extends Model
{
    protected $table = 'articles';
}

If you have changed the table or field name, remember to synchronize the update of the model's properties, factory classes, and possible Seeder files to avoid inconsistent problems.

Frequently Asked Questions

• Table name conflict : If you created the migration file manually, make sure that the table name is not duplicated with other models.
• Foreign key constraint failed : When using foreignId , you must confirm that the association table already exists, otherwise an error may be reported because the main table cannot be found.
• Field type inconsistent : The fields used in the model must be defined in the migration, otherwise an error occurs when saving the data.
• Forgot to run the migration : Don't forget to execute migrate after the model is created, otherwise the table will not be created.

Basically these are the operations. As long as you follow the model naming specifications, use the Artisan tool to generate the infrastructure, and then complete the migration details, you can successfully create a data table bound to the Eloquent model.

The above is the detailed content of How do I create a database table associated with an Eloquent model?. For more information, please follow other related articles on the PHP Chinese website!