[BUG] Migration Script 2abb9260c6fd_add_batch_user_id_to_claims_table throwing error

[taylorlynn]

Essentially, this happens because the user has yet to be created within the user table, and adding the foreign key to the social media table violates the foreign key constraint as the user with that auth0_id does not exist.

[taylorlynn]

The insert isn't working, because the FK isn't defined. This is social media data streaming - where there is a need for specific FKs to mean something in the database.

The easiest thing to do is to not insert the FKs in the script, but make a note to manually do it.

[dorsafsallami]

What I did for now is to prevent inserts into social_media_clients unless the referenced user already exists in users

[dorsafsallami]

eventually we need to redo the FK constraint but that is the temp fix I was using as well