[Request] Database Documentation

[roycebautista]

I want to know how to interpret the ids stored in the database, so an ERD might be a good place to start:

However there are ids that do not have a table in your database (job_id, world_id, content_id, entity_id etc) so these might already be documented somewhere else? could you please provide a link to the documentation so that I could interpret the ids? As much as possible we don't want you to duplicate documentation that already exist somewhere else.

I am also curious on what the customize column is?

Are these the values under the "Settings" tab?

[kalilistic]

I don't have an updated ERD but I can give some quick hints in the meantime.

You can see the schemas by looking through the migration files.
https://github.com/kalilistic/PlayerTrack/tree/master/PlayerTrack.Infrastructure/Migrations

Some columns like job_id, world_id, and content_id are from the game data tables.
https://github.com/xivapi/ffxiv-datamining/blob/master/csv/World.csv

Other columns like entity_id, content_id, etc. are IDs from the game assigned to game objects. The entity_id is subject to change but is reliable enough within a game session. I don't actually need to store this but I did so for convenience. content id is more valuable as it does not change.

Customize is a byte array from a game struct. It holds data like race, gender, tribe, height, etc.
https://github.com/kalilistic/PlayerTrack/blob/master/PlayerTrack.Models/Structs/CharaCustomizeData.cs

There's two types of config. global settings are in "config" and player settings (once customized) are stored in "player_config".