Database Structure
Current as of July 22nd, 2023, patch level 147
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.