How to make a table with multiples primarykeys auto increment?

Hi what you are asking for seems more like multi-tenancy where the data is unique by store. If all of the data is valid for a single company or account you would need to use a different structure something like

id   store_id  store_seq
-----------------------------
1     1               1
2     1               2
3     1               3
4     2               1
5     2               2
6     3               1
7     3               2

The id is a record id so it must be unique. The store_id is an identifier for which store is involved The store_seq is a unique counter within each store. This you would need to manually calculate the current maximum value and increment.

There can only be one primary key in a table but the primary key can be a combination of two fields. Not sure what you are trying to do but I think you should look at your database model and think again.

@Dalma yeah, that is what I'm doing now, but without the id column I'l explain why in the next answer

@Tray2 I got this database ready when I enter in this company, for me I would create from scratch

Sounds like you need to back way up and learn how the foreign Keys work. And if you plan on using eloquent the documentation gives examples of how the Foreign Relations work and how to set them up.

https://laravel.com/docs/5.6/eloquent-relationships

@jlrdw How I said in the previous answer, I got this database already created when I enter in this company, I would love to reacreate it from scratch using eloquent