zoekharvey/build-your-own-backend

build-your-own-backend's Issues

Not allowing songs to have an id that connects to albums

Background

• I updated initial migration to add a foreign key in 'song' referencing album_id
• Did so by rollback to edit initial migration

The Problem

• With how the seed file was initially made (with an albums_id key in songs that would ideally connect song to album), now it's throwing an error that it doesn't fit constraints of foreign key
• Because of this error, the data was not updating to database
• Comment the line out where it declares songs to have the key of albums_id (in the seed file), and everything works besides now there's nothing connecting the two tables (I think)

Screenshots

Migration/Schema relationship

What's Wrong

• Within songs schema, there is no relationship addition to link songs to albums (should be based on album_id)

Why it's not fixed yet

• Cannot figure out how to reliably edit the column to include foreign/references
• Don't want to delete & redo database incase there is a fix that doesn't require this

Next steps

Either:

• figure out a way to edit column without having
  Or:
• delete/redo the database all together, which is very not ideal

Solution (within migration file in the songs schema) will end up adding something like:

table.integer('album_id').unsigned()
table.foreign('album_id').references('album.id')