podverse-api icon indicating copy to clipboard operation
podverse-api copied to clipboard

Investigate if we can delete unused relationship tables

Open mitchdowney opened this issue 2 years ago • 3 comments

When I inspect these tables in the database, I see 0 rows. I don't why or when these tables were created.

episodes_authors_authors
episodes_categories_categories
media_refs_authors_authors
media_refs_categories_categories

mitchdowney avatar Dec 21 '22 03:12 mitchdowney

@mitchdowney these are still empty. Can I drop them?

suorcd avatar Apr 26 '24 17:04 suorcd

@suorcd I think so but I will make sure the API still works if I drop them in the stage environment.

mitchdowney avatar Apr 26 '24 23:04 mitchdowney

@suorcd on second thought, there is a bit of code in the API where we could use these tables, but I'm just not using them right now. I'm thinking of just keeping these 4 tables for now even though they're empty.

mitchdowney avatar Apr 29 '24 02:04 mitchdowney