Level 5
Hi John for mysql workbench check the documentation, Try to reverse engineer your database,
https://dev.mysql.com/doc/workbench/en/wb-reverse-engineer-create-script.html
1 like
Apr 12, 2017
3
Level 2
Eloquent relationships and MySQL tables relationships.
Hi,
I am using a MySQL Workbench and i were trying to display my table relationships as an EER Diagram.The point is that relationships defined in laravel doesnt exists in mysql.When diagram loads there are no nodes between tables.I have check foreign keys in the workbench,they are not defined.
Relationships defined in my app works fine,but i would like to have some graphic diagram where i can easy manage/see defined relationships.
What am i doing wrong?How do you manage your table relationships?write some kind of documentation?
Thank you ,John
Level 15
I guess that when creating your migration files you define the relationship by adding eg.
$table->integer('rank_id')->unsigned();
On mySql server this is just a field but enough for laravel to do its magic.
Laravel of course offers the ability to enforce referential integrity
$table->foreign('user_id')->references('id')->on('users');
If you add foreign keys in your migration files then you will see the connections in your Entity Diagram.
Take a look:
Foreign Key Constraints https://laravel.com/docs/5.4/migrations#generating-migrations
1 like
Level 2
Thanks guys!thats great and it works!
Please or to participate in this conversation.