I am facing problem , can't migrate Product table

[maiden spire]

class Product extends Model
{
    use HasFactory;
    protected $primaryKey = "p_Id";
    public function category()
    {
        return $this->belongsTo(App\Models\Category::class, 'C_Id');
    }
}

class Category extends Model
{
    use HasFactory;

    protected $primaryKey = "C_ID";
    public function products()
    {
        return $this->hasMany(App\Models\Product::class, 'C_ID');
    }
}

        Schema::create('products', function (Blueprint $table) {
            $table->id('p_Id');
            $table->foreignId('C_ID')->constrained('categories');
            $table->string('Title');
            $table->text('Description');
            $table->string('Image');
            $table->decimal('Price', 10, 2);
            $table->decimal('Sale', 10, 2)->nullable();

            $table->timestamps();
        });
    }

[wheat zealot]

Are you getting any errors?

[maiden spire]

SQLSTATE[HY000]: General error: 1005 Can't create table myblog.products (errno: 150 "Foreign key constraint is incorrectly formed") (Connection: mysql, SQL: alter table products add constraint products_c_id_foreign foreign key (C_ID) references categories (id))

[quasi nest]

Why are you changing primary and foreign key names?

The casing of them is all over the place so no wonder you’re getting errors.

[maiden spire]

I am newbie student

[quasi nest]

So stop making your life harder and stick to Laravel’s naming conventions, and then things will work? 🤷‍♂️

[wheat zealot]

The foreignId() type assumes you're using conventional names for your keys. if you're not following conventions, you'll have to manually create the column and foreign key constraint

[maiden spire]

i am sorry i never heard about conventional names

[wheat zealot]

https://laravel.com/docs/10.x/eloquent#eloquent-model-conventions reading the documentation for the framework you're using is mandatory

[maiden spire]

Thank you

[quasi nest]

Probably a good idea to actually read the documentation of a framework you’ve chosen to work with, rather than just blindly start typing stuff into a text editor without knowing how it works.

[maiden spire]

sure I will , thanks ,

[maiden spire]

what do you mean by that , is it C_ID in Category table you mean?

[quasi nest]

You don’t need to specify names like that.

Just use $table->id() and it will create a column named id

[maiden spire]

I did it because It was in normalization table ,

of design

[quasi nest]

What?

There’s nothing “normalising” about using “C_ID” over id as the name of a primary key column.

Laravel has conventions. Learn them.