Be part of JetBrains PHPverse 2026 on June 9 – a free online event bringing PHP devs worldwide together.

hasanhatem's avatar

how to structure this database and table for huge project with laravel?

Hello my friends,

I have problem with database structure or what is the best way to handle the tables for the future with laravel.

Actually, i am working on big project it have too much things and details to do,

one of them in registration.

So i have website the users can add their Sports Facilities, stores or maybe he is Personal trainer. i handled every thing about the multi-vendor store. Sure i make is in separate tables.

the options in the registration like that:

Categories

As you see the sports facilities have also sub categories like ball sports and Sport club. But the Meditation and relaxation it don't have sub categories.

in the sub categories the users can choose from black text. (check the image, please) like (Football, basketball, etc...) but for stores and Personal trainer he can direct fill the required fields.

So i have tables for stores, and tables for Personal trainer. but what about the other activities. how can i handle all this things together, because the website will have more than 20 sports . and each one will have deferent custom fields.

is it good idea to make (separate tables for stores, personal trainer, and activities)?

is this good way to make the Sport Facilities (activities). because in the future they will add more categories and sub categories

and how can i know what the user have (store, personal trainer, football court or GYM) because all of them have deferent tables.

or is their better idea to handle this steps because every category or sub category have deferent custom field and some public fields

this image just to be clear how the user will go throw the website:

it's a good idea to make 1 main table for (Meditation and relaxation, and sport facilities) because i think it's same structure but deferent custom fields and levels

I am sorry it's long story but i am so confusing.

0 likes
3 replies
shaungbhone's avatar

Hey my friend. Believe yourself and just do it.

2 likes
vincent15000's avatar

Not an answer to your question, but which software are you using for your class diagram ?

1 like

Please or to participate in this conversation.