Database Structure
Current as of:
Below you'll find some ER diagrams of the Mozilla accounts and Subscription Platform databases. Some notes:
- You'll find very few enforced foreign keys. This was a choice made a long time ago because of the tooling being used at the time. We'd make a different choice now (and you can see newer tables do have foreign keys).
- Unless noted, all charsets are some form of
utf8.
Database: fxa
Database: fxa_oauth
accountAuthorizations_v2 is an unused shadow of accountAuthorizations that
replaces the scope varchar with a scopeId foreign key. The migration to it
was abandoned: the app neither reads nor writes the table, and it stays only
until a follow-up migration drops it.