Products > Database > DatabaseDocumentation > DatabaseSchema > TRMs

Database Schema: TRMs

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).

• TRMs identify tracks. Each time a new TRM is submitted to the server, it is looked up in the trm table. If it is not there, then it is added. Each TRM submission also includes the version string of the client software submitting it. Those version strings are stored in clientversion, and each TRM is linked to the client version which (first) submitted it.

* Whenever a new association between a track and a TRM is submitted, the relevant row is added to the trmjoin table (if it is not already there). Finally, whenever a TRM lookup is performed, the lookupcount value is incremented for that trm.

CategoryWikiDocsPage CategoryDevelopment