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 a shadow of accountAuthorizations that replaces
the scope varchar with a scopeId foreign key. v1 remains authoritative
while the app dual-writes both behind a config flag.