General Layout

The above image is a little confusing, so I'll break things down.





Section 1: Isaac Episodes

This is what you're probably here for. All runs and gameplay events are saved in those 4 tables!
An episode can be broken down into a series of one-to-many relationships:

The corresponding tables:

The tables also reference themselves in that direction, meaning...





Section 2: Game Resources

All game resources are stored in "isaac_resources". Be it pills, items, transformations, floors, characters, enemies... everything. The only thing that keeps them apart is the "type" column.

"mods" and "mod_url" store mods from which "isaac_resources" came, as well as hyperlinks to those (for example a link to the steam workshop page)

If collecting an "isaac_resource" counts as transformation progress, then that property is saved in the "transformative_resources" table.





Section 3: Video Data

"videos" saves youtube-video related stuff like upload date, video duration and so on. Most of this stuff is directly pulled from youtube. The "thumbnails" table is self-explanatory.

"quotes" are the funny quotes that users submitted while watching.

"discussion_topics" are tangents and broad themes NL talked about during an episode.





Next Step

A detailed table description and query examples