Skip to main content

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.

Database: fxa

Database: fxa_oauth

Database: fxa_profile