Skip to main content

Database Structure

Current as of July 22nd, 2023

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