General input on schema

[Michael Botsko]

Schema: https://pastebin.com/KfEgqkJb

I've included explanations for the data and how they'll be used. I've tried my best to choose appropriate column types, normalize data where possible, add foreign keys correctly, etc but welcome any and all input.

I'm rewriting a decade-old java plugin I had written for Minecraft servers as a hobby. It uses mysql/maria and logs game event data and can potentially log millions of records in the activities table. This schema is essentially written from scratch.

Users download this app and provide their own MySQL databases so I can't always guarantee the environment but I want to be as smart about the schema as possible.

The above schema is my current progress with my rewrite. I have yet to add query-focused indexes to the activities table but everything else should be complete.

I don't really have any specific questions anymore but you might see things worth commenting on.