njtynhj

Multi tool use

I need to add three tables to MySql but I don't know how to organize them.

My tables are :

And my relations :

Surfaces are enter after apartment, so I can't use surfaces floor as my apartment floor.

At the moment I have apartment table and floor table with a pivot table (many to many).

In Mysql, what's the best way to handle this ? And after inside laravel ?

Thank for yourhelp !

Edit : my work on laravel so far (only floor table and apartment table)

In Apartment.php :

In Floor.php :

Edit 2 : my migration so far :

I can think of below kind of relationships in Laravel, I have not created the sample code although but it should help.

Apartment model:

Floor model:

Surface model:

However, it will bring more clarity to the answers if you can provide table schema or migration schema on the same question. Also, you can mention which kinds of SQL queries you are expecting and want to execute. Thanks. Hope this helps.

By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.