search

themetadb / metametametadb

4 stars 0 forks source link

Develop sane database schema supporting various media types #3

Open oddstr13 opened 4 years ago

oddstr13 commented 4 years ago

Franchise -> Series -> Season -> Episode

nielsvanvelzen commented 4 years ago

Some questions that need answers for a proper schema:

heyhippari commented 3 years ago

How do we handle specials / extras? (like extra episode(s) from a DVD release) How do we handle movies? (I guess Franchise -> Series -> Movie) How do we handle crossovers?

I think all of these can essentially be dealt with properly by enabling multiple episode orders (or "orders" in general) from the get go.

An order could be composed of any number of things: episode, movie, book, comic, manga, extra, whatever. The order can then be assigned to any number of "container" item (ie any item type that can be a parent of other items, so a series, a franchise, an album, etc)

As for where to store specials, a "Specials" season of sorts still makes the most sense, but with strict guidelines on content (OVA series, movies and such would go on the Franchise, not in Specials)

For crossovers, being able to link to multiple franchises (With a relationship type) would make sense. Or maybe a flag.

For example, Series A would be part of Franchise A. Series B would be part of Franchise B, but also of Franchise A, with a crossover flag.

nielsvanvelzen commented 3 years ago

Personally I think using a season for specials is some hack to make it work. We should have a special entity for it with the ability to link it to seasons IMO.

oddstr13 commented 3 years ago

I think a special is a episode that doesn't belong in the normal episode ordering, but it can be defined as being before and/or after a specified episode (by timeline in the show).

This way, a special could be between E3 and E4 (before E4, after E3), or E6 and E8 (parallel story to E7). Between seasons could be defined as after S1E12, but before S2E1. Working out the logic of how exactly this is defined is an exercise for the reader :wink:

oddstr13 commented 3 years ago

As a benchmark for episode ordering, I propose the MCU including series (this independent article seems to have a decent overview).

+ an anime with n.5 episodes and extras, I'm sure there are plenty to choose from.

heyhippari commented 3 years ago

There are a few benchmarks we could take for anime, to ensure we handle weird cases.

  1. Monogatari Series - https://www.reddit.com/r/araragi/wiki/order Lots of series, a few movies, one thing that was released as a movie but aired as a series in the west. It's generally handled like a mess by every single database out there.
  2. Lupin III It doesn't have a real order. Every show is self-contained, with the same characters and main actors over a 50 years period. It also has a ton of movies, OVAs and TV specials.
  3. Ghost in the Shell Multiple continuities (At least 3: original movies, Stand Alone Complex and ARISE). Stand Alone Complex and ARISE contain both TV series and movies.
  4. Angel Beats Covers the "OVA inserted as an episode in the middle of the series" case (aka Episode n.5). The order would be Angel Beats! Episodes 1-2 -> Hell's Kitchen OVA -> Angel Beats! Episodes 3-4 -> Stairway to Heaven OVA -> Angel Beats! Episodes 5-13 -> Another Epilogue OVA

There's probably a few other examples we could figure out.

For movies, in addition to Marvel, there are other weird series. Fantômas would be one of them, imo.
It has a first serial from the 1910s. Then a couple of standalone movies from the 30s and 40s. Then a trilogy from the 60s. None of these are in continuity with each-other and it covers both both serials and movies.