Products > Database > DatabaseDocumentation > DatabaseSchema > Editors
Database Schema: Editors (or Users)
See the Database Schema page for an overview of the MusicBrainz Database and links to pages which describe each parts of the schema in more detail (like this page).
Editors' (i.e. registered users') details are stored in the moderator table. The main things of interest are the ID, login name, password, and e-mail address. Each editor can also store their preferences for various things, such as their preferred date/time display format, their time zone and numerous other preferences. Such information is held in the moderator_preference table, where each preference simply as a textual "key", and a textual "value" (although the interpretation of that value isn't specified here; for example, for some preferences, it might be a number).
Moderators can also "subscribe" to artists, which means that they get sent an e-mail in regular intervals when one of their subscribed artists has new edits against them (if no new edits have been entered for their artists, then no e-mail is sent). For each artist to which an editor subscribes, a row is added to the moderator_subscribe_artist table. Each row includes the last EditID which was processed by the subscription system for this editor/artist pair - in other words, only moderations after this "lastmodsent" will be considered. "lastmodsent" is updated each time the subscription process runs. Finally, if one of an editors subscribed artists is deleted, or merged into another artist, then the "mergedbymod" or "deletedbymod" values are used; when the subscription process next runs, the user is told that one of their subscribed artists has been removed, and is given a link to the moderation which did it. Then, the moderator_subscribe_artist row is removed.
CategoryWikiDocsPage CategoryDevelopment