Are you running any alter query?

Without showing your code I cannot help much. Please share the Parent table migration and existing child table migration

This might be parent table. Right?

I don’t understand what you mean by parent table. I’m new to laravel

In orders table why are you using order_id column?

id inrements, as 1,2,3… I want the order id to be in uuid format

Eg: You have orders (parent table), order_items (child table) tables.

Now you want to add order_id (foreign key) in order_items table

I want to add vendor_id foreign key as well in order table. The vendor places the order

In order model put the following code

protected $primaryKey = ‘id’;

protected $keyType = ‘string’;

public $incrementing = false;

In migrations use the following

$table->uuid(‘id’)->primary();

Already vendor_id is there in orders table

Thanks man

You are now my mentor 🙏🏽

how can i place an order using a specific vendor_id so I can attach that vendor id as value to the vendor_id variable in that order?

I am not sure but I think you might be displaying the products. And every products will be having vendors. So when your creating order make sure to pull the vendor_id from the products table.

ok

Syntax error or access violation: 1072 Key column ‘vendor_id’ doesn’t exist in table (SQL: alter table orders add constraint orders_vendor_id_foreign foreign key (`vendor_id`) references vendors (`id`))

I’m getting this error after trying to migrate:fresh

Check in orders model fillable in vendor_id is added or not

Or show your order model

Whats the name of your vendors table

vendors

Easy

Are you running any alter query?

alter query?

I don’t think so. I don’t even know what that is

Lets continue in private chat

anyOne????

https://stackcoder.in/posts/file-upload-in-laravel-php

THNX

show vendors migration table

solved.

❓