Structure MySQL database with different media types such as movies, music and games

[Guldstrand]

I have a question about how to solve it with a database I am working on.
The idea is to have different types of optical media, and I'm thinking a bit about how to solve it with the categories.

There will be two different levels in the categories, but the question is whether I should include the formats under, for example, the game category.
Having "ps4, ps5, wii" together with the game types / genre "platform games, action games" etc.?
(Same for movies that have the formats "vhs, dvd, blu-ray".)

Or is it better to have all the "formats" in a separate table?
And when is it really a "category" or a "type / format" thing?

I am grateful for all the feedback and suggestions.

[requinix]

That's, like, half of a description.

Sounds like you just want a list of different things - media types, consoles, whatever. A list. Right?
That's just a basic enum table: ID column, "value" column, then use the ID for foreign keys wherever you need them.