Level 104
You mean a pivot table?
https://laravel.com/docs/9.x/eloquent-relationships#many-to-many-table-structure
Jan 23, 2023
17
Level 6
create table between or after table
how can create map table between 2 tables ?
Create a table between two other tables. It is not a relationship. I made the tables, now I want to add another table imagine 1 2 4 5 6 7 8 Now I understand that I didn't make table 3 and I have to make between 2 and 4
Level 6
Hello @tykus Create a table between two other tables. It is not a relationship. I made the tables, now I want to add another table imagine 1 2 4 5 6 7 8 Now I understand that I didn't make table 3 and I have to make between 2 and 4
Level 102
@LoverToHelp how is "map between sliders and projects" not a relationship? What is the point of the table? What does "between" mean then?
Level 104
@LoverToHelp do you mean rows; if 1 2 3 4 5 6 7 8 etc, are primary keys, then you don't want to be interfering with them! What are you actually wanting to achieve here; what is the context?
Level 35
@LoverToHelp You mean a migration to create the table?
If they depend on each other somehow you can create a new migration and change the timestamp of the migration file to a timestamp between the one of #2 and #4.
When done, run artisan migrate:fresh (this will wipe out your entire database and run all migrations again)
1 like
Level 51
@Sinnbeck hey this is like chatting someone up.
@lovertohelp, can you show some code? That may illustrated things...
Level 102
Level 6
I made the tables, now I want to add another table imagine name tables are : 1 2 4 5 6 7 8
Now I understand that I didn't make table 3 and I have to make between 2 and 4
Level 102
@LoverToHelp Tables does not have an order, and cannot be numbers. Most editors order them by name
Level 6
Please help / assuming their names are numbers 😄😄
Level 102
@LoverToHelp Then you make a new table with a new migration and it will end up in the correct place alphabetically.
Level 6
I made all the tables. I did not make one that is original and has a foreign key. Now I have to delete and create the tables from scratch or is there a way
Level 102
@LoverToHelp You can alter a table to add the foreign key in a new migration.
Level 6
Why didn't the creator of Laravel think that we might need a table in the middle of the path 😂😂
Level 102
@LoverToHelp You can always manually change the timestamp of a migration as mentioned by @click
Level 6
@Sinnbeck This click gives a privacy error. I created my question with an image https://laracasts.com/discuss/channels/laravel/command-create-table-between-2-tables
Level 102
@LoverToHelp What? @click is a person like me :p And its a file. You can just rename it
Please or to participate in this conversation.