Media

Table actions
Film, TV, music, games, and reading data

Data license: All Rights Reserved · Data source: krisyotam.com · About: Kris Yotam

Custom SQL query

Tables

fav_actors

id, name, image, sort_order

19 rows

fav_directors

id, name, image, sort_order

13 rows

fav_film_characters

id, name, image, actor, sort_order

8 rows

fav_film_companies

id, name, image, description, sort_order

12 rows

fav_producers

id, name, description, works, sort_order

10 rows

fav_showrunners

id, name, image, sort_order

6 rows

fav_tv_actors

id, name, image, sort_order

8 rows

fav_tv_characters

id, name, image, actor, show, sort_order

17 rows

fav_tv_networks

id, name, image, description, sort_order

5 rows

fav_tv_shows

id, name, year, poster, sort_order

4 rows

favorites

id, type, position, cover, title, link

40 rows

films

id, slug, title, director, original_title, year, country, runtime, genre, poster_url, production, collection, language, classification, sub_classification

2 rows

gallery_images

id, src, alt, width, height, caption, category, sort_order, created_at

12 rows

game_characters

id, name, game, role, avatar_image, description

10 rows

game_consoles

id, name, manufacturer, release_date, cover_image, owned_start, owned_end

10 rows

game_platforms

id, name, company, release_date, cover_image, description

10 rows

games

id, name, version, release_date, console, hours_played, genres, cover_image, developer, publisher, rating, favorite, favorite_weight, date_last_played

15 rows

library

id, slug, title, author, authors, editors, series, edition, publisher, year_published, copyright, isbn, cover_url, classification, sub_classification

8 rows

library_notes

id, date, title, content

5 rows

movies

id, title, year, poster_url, genres, runtime, director, last_watched_at, rating, overview, times_watched

29 rows

music

id, playlist_name, slug, cover_url, amount_of_songs, last_updated, category, tidal, qobuz, apple_music, spotify, status

3 rows

playlist

id, slug, title, description, cover_image, link

18 rows

reading_audiobooks

id, title, subtitle, author, cover, link

1 row

reading_blogs

id, title, author, source_link, archive_link, publication_year

7 rows

reading_books

id, title, subtitle, author, cover, link

66 rows

reading_essays

id, title, author, source_link, archive_link, publication_year

3 rows

reading_lists

id, list_id, title, description, author, books

6 rows

reading_log

id, date, title, author, type, minutes

2 rows

reading_now

id, title, subtitle, author, cover, link

8 rows

reading_papers

id, title, author, source_link, archive_link, publication_year

3 rows

reading_verse

id, title, author, verse_type, source_link, publication_year

12 rows

short_stories

id, title, author, publication_year

4 rows

sqlite_sequence

name, seq

27 rows

tv_watched

id, tmdb_id, name, year, synopsis, poster, rating, watched_date, creator, cast, networks, countries, languages, genres, runtime, seasons, episodes, status, sort_order

15 rows

videos

id, slug, title, subtitle, preview, image, video, category, tags, date, status, confidence, importance, state

10 rows

want_to_read

id, title, subtitle, author, cover, link

3 rows

watched

id, tmdb_id, letterboxd_url, watched_date, name, year, synopsis, poster, rating, director, cast, studios, countries, languages, genres, runtime, release_date, budget, revenue

269 rows

... and 16 hidden tables