Game Library Database Schema (Obsolete)

TODO: Finalize and replace this page with new, simpler schema

games

column name	type	description
id	INTEGER
title	TEXT NOT NULL	Game title (how do we get it ?)
is_favorite	BOOLEAN
console	TEXT NOT NULL	Should we maintain a list of consoles somewhere ?
region	TEXT	https://en.wikipedia.org/wiki/GoodTools#Country_codes
goodtools_code	TEXT	https://en.wikipedia.org/wiki/GoodTools#Standard_codes
time_played	DATETIME
artwork	TEXT	Path to artwork obtained by scraper using TheGamesDB API
directory	TEXT	path to the directory (how about remote dirs ?)
filename	TEXT	filename of rom file

• For now, simple algorithm to get game title based on common file name format ? E.g: "Game Title (Region) [!].ext"

schema_version

column name	type	description
version	INTEGER NOT NULL	Revision of the schema. For migration