forked from Wintermute0110/plugin.program.AEL.dev
-
Notifications
You must be signed in to change notification settings - Fork 1
Database
Christian Jungerius edited this page Oct 12, 2022
·
4 revisions
The AKL database is stored in a SQLite file and is the base for how the AKL data schema for Kodi list items is generated. On this page we describe what we store and collect about categories, collections and roms. If you want to know more about the data scheme for the library list items in Kodi, then you need to read up the documentation under the skins page of this wiki.
We describe each table and view:
This table contains all generic metadata for each entity in the application. Categories, collections and ROMs all inherit from this table.
| Column | Type | Description |
|---|---|---|
| id | text | unique identifier |
| year | text | Release year (e.g. 1991) |
| genre | text | Genre name |
| developer | text | The developer/studio/company of the entity |
| rating | integer | Number from 0-10 indicating the rating of the entity |
| plot | text | Description of the entity |
This table contains all category specific data. Inherits metadata
| Column | Type | Description |
|---|---|---|
| id | text | unique identifier |
| name | text | Name of the category |
| parent_id | text | Foreign key to the parent containing this category, NULL if root |
| metadata_id | text | Foreign key to the metadata to inherit |
| default_icon | text | default asset to use as icon |
| default_fanart | text | default asset to use as fanart |
| default_banner | text | default asset to use as banner |
| default_poster | text | default asset to use as poster |
| default_clearlogo | text | default asset to use as clearlogo |
This table contains all rom collection specific data. Inherits metadata
| Column | Type | Description |
|---|---|---|
| id | text | unique identifier |
| name | text | Name of the collection |
| platform | text | Platform/system of the collection |
| box_size | text | Default box size of covers |
| parent_id | text | Foreign key to the parent containing this collection, NULL if root |
| metadata_id | text | Foreign key to the metadata to inherit |
| default_icon | text | default asset to use as icon |
| default_fanart | text | default asset to use as fanart |
| default_banner | text | default asset to use as banner |
| default_poster | text | default asset to use as poster |
| default_controller | text | default asset to use as controller |
| default_clearlogo | text | default asset to use as clearlogo |
| roms_default_icon | text | default asset to use with ROMs in this collection as icon |
| roms_default_fanart | text | default asset to use with ROMs in this collection as fanart |
| roms_default_banner | text | default asset to use with ROMs in this collection as banner |
| roms_default_poster | text | default asset to use with ROMs in this collection as poster |
| roms_default_clearlogo | text | default asset to use with ROMs in this collection as clearlogo |
This table contains all ROM/Game specific data. Inherits metadata
| Column | Type | Description |
|---|---|---|
| id | text | unique identifier |
| name | text | Name of the ROM |
| num_of_players | integer | Local number of players supported |
| num_of_players_online | integer | Online number of players supported |
| esrb_rating | text | ESRB rating for this game |
| nointro_status | text | todo |
| pclone_status | text | todo |
| cloneof | text | todo |
| platform | text | Platform/system of the ROM |
| box_size | text | Default box size of covers |
| rom_status | text | todo |
| is_favourite | integer | Flag indicating if this ROM is a favourite (0/1) |
| launch_count | integer | Number of times this ROM has been launched |
| last_launch_timestamp | timestamp | Last time this ROM was launched |
| metadata_id | text | Foreign key to the metadata to inherit |
| scanned_by_id | text | Foreign key to the scanner which scanned this specific ROM |