MusicBrainz Database/Schema: Revision history

21 July 2023

• curprev 18:4418:44, 21 July 2023‎ YvanZo talk contribs‎ 21,879 bytes +139‎ →‎Musical work inquiring: Add diagram and rephrase after it
• curprev 18:3718:37, 21 July 2023‎ YvanZo talk contribs‎ 21,740 bytes +127‎ →‎Audio file tagging: Add diagram and rephrase after it
• curprev 17:0217:02, 21 July 2023‎ YvanZo talk contribs‎ 21,613 bytes +35‎ →‎Undocumented tables: List the private table unreferenced_row_log added in schema 28

20 July 2023

• curprev 18:0918:09, 20 July 2023‎ YvanZo talk contribs‎ 21,578 bytes +31‎ →‎Undocumented tables: Add new private table from schema 28
• curprev 17:3717:37, 20 July 2023‎ YvanZo talk contribs‎ m 21,547 bytes −15‎ →‎Types: Fix style
• curprev 17:3317:33, 20 July 2023‎ YvanZo talk contribs‎ m 21,562 bytes −52‎ →‎Tags: Primary entity type names should not be styled as code unless it is about their main table.
• curprev 17:3217:32, 20 July 2023‎ YvanZo talk contribs‎ 21,614 bytes +9‎ →‎Ratings: Fix style for editor table
• curprev 17:3217:32, 20 July 2023‎ YvanZo talk contribs‎ 21,605 bytes −28‎ →‎Ratings: Primary entity type names should not be styled as code unless it is about their main table.
• curprev 17:3017:30, 20 July 2023‎ YvanZo talk contribs‎ 21,633 bytes +4‎ →‎MBID redirects: Fix oversight: 13 entity types
• curprev 17:2917:29, 20 July 2023‎ YvanZo talk contribs‎ 21,629 bytes −160‎ →‎Edits: Drop the list of primary entity types
• curprev 17:2617:26, 20 July 2023‎ YvanZo talk contribs‎ 21,789 bytes +10‎ →‎Relationship table structure: Update with diagram’s comments from https://github.com/metabrainz/musicbrainz-server/pull/2987
• curprev 17:2317:23, 20 July 2023‎ YvanZo talk contribs‎ 21,779 bytes −52‎ →‎Annotations: Primary entity type names should not be styled as code unless it is about their main table.
• curprev 17:2317:23, 20 July 2023‎ YvanZo talk contribs‎ m 21,831 bytes 0‎ →‎Aliases: Primary entity type names should not be styled as code unless it is about their main table.
• curprev 17:2017:20, 20 July 2023‎ YvanZo talk contribs‎ m 21,831 bytes 0‎ →‎Overview: Style: move below
• curprev 17:1917:19, 20 July 2023‎ YvanZo talk contribs‎ 21,831 bytes +40‎ →‎Overview: Some primary entity types are linked through foreign key constraint such as release_country or release_label
• curprev 16:4216:42, 20 July 2023‎ YvanZo talk contribs‎ 21,791 bytes +4‎ →‎Overview: Update with diagram’s comments from https://github.com/metabrainz/musicbrainz-server/pull/2987
• curprev 16:2016:20, 20 July 2023‎ YvanZo talk contribs‎ m 21,787 bytes −1‎ →‎Overview: Typo -.
• curprev 16:2016:20, 20 July 2023‎ YvanZo talk contribs‎ 21,788 bytes +2‎ →‎Overview: Update with diagram’s comments from https://github.com/metabrainz/musicbrainz-server/pull/2987
• curprev 16:1716:17, 20 July 2023‎ YvanZo talk contribs‎ 21,786 bytes +49‎ →‎Overview: Update with diagram’s comments from https://github.com/metabrainz/musicbrainz-server/pull/2987
• curprev 13:4013:40, 20 July 2023‎ YvanZo talk contribs‎ 21,737 bytes 0‎ →‎Entity complementary data: Sort sections alphabetically
• curprev 13:4013:40, 20 July 2023‎ YvanZo talk contribs‎ m 21,737 bytes +2‎ →‎Types: Formatting typo: fix closing code tags
• curprev 13:3913:39, 20 July 2023‎ YvanZo talk contribs‎ m 21,735 bytes +1‎ →‎Types: Formatting typo: fix closing code tag
• curprev 13:3913:39, 20 July 2023‎ YvanZo talk contribs‎ 21,734 bytes +36‎ →‎Entity complementary data: Remove code from section titles, use <code> for table names
• curprev 13:2513:25, 20 July 2023‎ YvanZo talk contribs‎ m 21,698 bytes +2‎ →‎Entity satellite tables: Back on earth
• curprev 13:1413:14, 20 July 2023‎ YvanZo talk contribs‎ 21,696 bytes +82‎ →‎Undocumented tables: Add private tables for series subscription
• curprev 13:1413:14, 20 July 2023‎ YvanZo talk contribs‎ 21,614 bytes −1‎ →‎Undocumented tables: Reorder private tables
• curprev 13:1313:13, 20 July 2023‎ YvanZo talk contribs‎ 21,615 bytes −157‎ →‎Undocumented tables: editor_watch_* tables have been dropped with schema 28
• curprev 13:1213:12, 20 July 2023‎ YvanZo talk contribs‎ 21,772 bytes −59‎ →‎Undocumented tables: artist_deletion & label_deletion have been dropped with schema 23
• curprev 13:1113:11, 20 July 2023‎ YvanZo talk contribs‎ 21,831 bytes +79‎ →‎Undocumented tables: Split private tables apart
• curprev 13:0213:02, 20 July 2023‎ YvanZo talk contribs‎ 21,752 bytes +468‎ →‎Undocumented tables: Add a section for frequent use cases such as audio file tagging and musical work inquiring
• curprev 12:5312:53, 20 July 2023‎ YvanZo talk contribs‎ 21,284 bytes +449‎ →‎Overview: Expand overview to give a plan of the documentation

19 July 2023

• curprev 21:2321:23, 19 July 2023‎ YvanZo talk contribs‎ m 20,835 bytes +6‎ →‎Overview: Format diagram’s comments as a list
• curprev 20:5920:59, 19 July 2023‎ YvanZo talk contribs‎ m 20,829 bytes +56‎ →‎Primary entities: Format table names using <code>
• curprev 20:4420:44, 19 July 2023‎ YvanZo talk contribs‎ 20,773 bytes −5‎ →‎Overview: Replace PNG with SVG after fixing the SVG rendering in settings
• curprev 19:0419:04, 19 July 2023‎ YvanZo talk contribs‎ m 20,778 bytes −5‎ →‎Overview: Fix typo+s
• curprev 18:5218:52, 19 July 2023‎ YvanZo talk contribs‎ 20,783 bytes +234‎ →‎Overview: Add a 3rd diagram with all the tables, justifying the length of the documentation.
• curprev 16:3816:38, 19 July 2023‎ YvanZo talk contribs‎ 20,549 bytes +2‎ →‎Schema: Rename to Overview and move to the top of the page
• curprev 16:2616:26, 19 July 2023‎ YvanZo talk contribs‎ 20,547 bytes +27‎ →‎Schema: Split into explanatory parts, the remaining might have to be moved to the top of the page
• curprev 16:1416:14, 19 July 2023‎ YvanZo talk contribs‎ m 20,520 bytes +2‎ Fix formatting
• curprev 16:1416:14, 19 July 2023‎ YvanZo talk contribs‎ 20,518 bytes +105‎ Add intro to clarify the topic and the targeted audience.

18 July 2023

• curprev 17:2017:20, 18 July 2023‎ YvanZo talk contribs‎ m 20,413 bytes −9‎ →‎Area: actually unneeded
• curprev 17:1917:19, 18 July 2023‎ YvanZo talk contribs‎ 20,422 bytes +193‎ →‎Release group: Mention that the (m) in the diagram stands for materialized table.
• curprev 17:1017:10, 18 July 2023‎ YvanZo talk contribs‎ 20,229 bytes +226‎ →‎Release: Mention that the (m) in the diagram stands for materialized table.
• curprev 17:0917:09, 18 July 2023‎ YvanZo talk contribs‎ 20,003 bytes +201‎ →‎Recording: Mention that the (m) in the diagram stands for materialized table.
• curprev 17:0817:08, 18 July 2023‎ YvanZo talk contribs‎ 19,802 bytes +220‎ →‎Artist: Mention that the (m) in the diagram stands for materialized table.
• curprev 16:5216:52, 18 July 2023‎ YvanZo talk contribs‎ 19,582 bytes +126‎ →‎Area: Link to the anchor being added in https://github.com/metabrainz/musicbrainz-server/pull/2987
• curprev 16:3416:34, 18 July 2023‎ YvanZo talk contribs‎ 19,456 bytes +72‎ →‎Area: Mention that the (m) in the diagram stands for materialized table.
• curprev 16:2316:23, 18 July 2023‎ Bitmap talk contribs‎ 19,384 bytes +23‎ mention that artists credits have gid redirects Tag: Visual edit

10 March 2023

• curprev 10:4810:48, 10 March 2023‎ YvanZo talk contribs‎ m 19,361 bytes −1,114‎ Replace original image links (currently broken when transcluded) with class "zoomable" to provision for https://tickets.metabrainz.org/browse/MBS-12984

9 March 2023

• curprev 09:3709:37, 9 March 2023‎ YvanZo talk contribs‎ m 20,475 bytes +22‎ This page has not been updated for years, updates from the last year are just work-in-progress; For follow-up; See https://tickets.metabrainz.org/browse/MBS-12402

27 July 2022

• curprev 15:4915:49, 27 July 2022‎ YvanZo talk contribs‎ 20,453 bytes +367‎ →‎Primary entities: Add diagrams for genre and instrument too
• curprev 15:3615:36, 27 July 2022‎ YvanZo talk contribs‎ m 20,086 bytes +7‎ →‎CDStubs table structure: Use a table layout to fill the large white space at the right of the image with text
• curprev 15:3515:35, 27 July 2022‎ YvanZo talk contribs‎ m 20,079 bytes +7‎ →‎Cover Art Archive table structure: Use a table layout to fill the large white space at the right of the image with text
• curprev 15:3015:30, 27 July 2022‎ YvanZo talk contribs‎ 20,072 bytes +1,972‎ →‎Primary entities: Add diagram for most primary entity types (but genre and instrument that were missing before) as a clickable thumbnail in a table.
• curprev 14:1014:10, 27 July 2022‎ YvanZo talk contribs‎ 18,100 bytes +1,298‎ →‎Schema: MBS-12403 (a): Replace current diagrams with updated ones; Update/add companion paragraphs; Simplify layout a bit

26 May 2022

• curprev 13:1813:18, 26 May 2022‎ Reosarevok talk contribs‎ m 16,802 bytes +1‎ →‎*_type tables
• curprev 13:1713:17, 26 May 2022‎ Reosarevok talk contribs‎ 16,801 bytes +67‎ →‎*_alias tables
• curprev 13:1613:16, 26 May 2022‎ Reosarevok talk contribs‎ m 16,734 bytes +1‎ →‎annotation table, & the *_annotation tables
• curprev 13:1613:16, 26 May 2022‎ Reosarevok talk contribs‎ 16,733 bytes +51‎ →‎annotation table, & the *_annotation tables
• curprev 13:1613:16, 26 May 2022‎ Reosarevok talk contribs‎ m 16,682 bytes +1‎ →‎edit table & the edit_* tables
• curprev 13:1613:16, 26 May 2022‎ Reosarevok talk contribs‎ 16,681 bytes +48‎ →‎edit table & the edit_* tables
• curprev 13:1513:15, 26 May 2022‎ Reosarevok talk contribs‎ 16,633 bytes +31‎ →‎tag table, & the *_tag and _tag_raw tables
• curprev 13:1313:13, 26 May 2022‎ Reosarevok talk contribs‎ 16,602 bytes +18‎ →‎*_rating_raw & *_meta tables
• curprev 13:1213:12, 26 May 2022‎ Reosarevok talk contribs‎ 16,584 bytes +50‎ →‎l_* tables
• curprev 13:1213:12, 26 May 2022‎ Reosarevok talk contribs‎ 16,534 bytes +75‎ →‎*_type tables
• curprev 13:0913:09, 26 May 2022‎ Reosarevok talk contribs‎ 16,459 bytes +278‎ No edit summary

11 March 2020

• curprev 15:0215:02, 11 March 2020‎ Chaban talk contribs‎ 16,181 bytes −14‎ remove PUID from recording description

28 September 2017

• curprev 11:3011:30, 28 September 2017‎ Reosarevok talk contribs‎ 16,195 bytes +156‎ No edit summary

2 May 2016

• curprev 21:5921:59, 2 May 2016‎ CallerNo6 talk contribs‎ 16,039 bytes +311‎ →‎Primary entities: adding 'series'
• curprev 21:5521:55, 2 May 2016‎ CallerNo6 talk contribs‎ m 15,728 bytes +2‎ fixing heading hierarchy
• curprev 21:4621:46, 2 May 2016‎ CallerNo6 talk contribs‎ 15,726 bytes +183‎ →‎Primary entities: adding 'event'

14 December 2015

• curprev 14:4414:44, 14 December 2015‎ Mathiaskunter talk contribs‎ m 15,543 bytes −4‎ →‎*_ipi & *_isni tables: typo

24 May 2015

• curprev 12:1712:17, 24 May 2015‎ Reosarevok talk contribs‎ m 15,547 bytes −18‎ No edit summary

5 February 2015

• curprev 13:1113:11, 5 February 2015‎ Mineo talk contribs‎ m 15,565 bytes −71‎ No edit summary
• curprev 13:1013:10, 5 February 2015‎ Mineo talk contribs‎ 15,636 bytes +857‎ added cdstubs

21 July 2014

• curprev 23:1823:18, 21 July 2014‎ PavanChander talk contribs‎ m 14,779 bytes −202‎ Removed redundant github link
• curprev 23:0123:01, 21 July 2014‎ PavanChander talk contribs‎ m 14,981 bytes +157‎ Add link to sql directory in repo

17 April 2014

• curprev 06:0806:08, 17 April 2014‎ JesseW talk contribs‎ 14,824 bytes +63‎ →‎tag table, & the *_tag and _tag_raw tables: note that ref_count doesn't actually work anymore

9 January 2014

• curprev 18:5218:52, 9 January 2014‎ JonnyJD talk contribs‎ 14,761 bytes +203‎ add link to github repo (CreateTables.sql)

23 December 2013

• curprev 07:0207:02, 23 December 2013‎ JesseW talk contribs‎ 14,558 bytes +15‎ document the secondary entity main tables, by mentioning they exist, note that the tag table is documented
• curprev 06:5706:57, 23 December 2013‎ JesseW talk contribs‎ 14,543 bytes +16‎ switch url to be a primary, rather than a secondary entity, per discussion with Ian on IRC

21 December 2013

• curprev 22:5122:51, 21 December 2013‎ JesseW talk contribs‎ 14,527 bytes +252‎ document the edit tables
• curprev 08:0508:05, 21 December 2013‎ JesseW talk contribs‎ 14,275 bytes +106‎ document country_area

19 December 2013

• curprev 06:2706:27, 19 December 2013‎ JesseW talk contribs‎ 14,169 bytes +245‎ document the *_ipi and *_isni tables

18 December 2013

• curprev 08:1208:12, 18 December 2013‎ JesseW talk contribs‎ 13,924 bytes +3,193‎ document the ratings tables, and add a list of the tables remaining to be documented
• curprev 07:5307:53, 18 December 2013‎ JesseW talk contribs‎ 10,731 bytes +3‎ add stars for the sections discussing multiple tables
• curprev 07:5107:51, 18 December 2013‎ JesseW talk contribs‎ 10,728 bytes +953‎ add section on the _alias tables and the tables used for the tag feature
• curprev 07:2007:20, 18 December 2013‎ JesseW talk contribs‎ 9,775 bytes +127‎ minor rewording, reformatting

16 December 2013

• curprev 05:0805:08, 16 December 2013‎ JesseW talk contribs‎ 9,648 bytes +1,046‎ divide primary and secondary entities , other minor fixes
• curprev 01:2001:20, 16 December 2013‎ JesseW talk contribs‎ 8,602 bytes +299‎ add section on the 8 _annotation tables
• curprev 01:1601:16, 16 December 2013‎ JesseW talk contribs‎ 8,303 bytes +8‎ alphebetize the objects, to match the way they are defined in CreateTables.sql
• curprev 01:0401:04, 16 December 2013‎ JesseW talk contribs‎ 8,295 bytes +352‎ add mention of the 12 *_type tables

22 November 2013

• curprev 15:3315:33, 22 November 2013‎ Reosarevok talk contribs‎ 7,943 bytes −249‎ No edit summary

15 November 2013

• curprev 16:5016:50, 15 November 2013‎ PavanChander talk contribs‎ m 8,192 bytes 0‎ No edit summary
• curprev 16:5016:50, 15 November 2013‎ PavanChander talk contribs‎ m 8,192 bytes −13‎ →‎Relationship table structure
• curprev 16:4816:48, 15 November 2013‎ PavanChander talk contribs‎ m 8,205 bytes −83‎ →‎Schema

26 October 2013

• curprev 02:3802:38, 26 October 2013‎ Ianmcorvidae talk contribs‎ 8,288 bytes +91‎ No edit summary

14 February 2013

• curprev 09:3109:31, 14 February 2013‎ Ianmcorvidae talk contribs‎ 8,197 bytes +920‎ No edit summary

9 September 2012

• curprev 19:3919:39, 9 September 2012‎ Ianmcorvidae talk contribs‎ m 7,277 bytes 0‎ Ianmcorvidae moved page musicBrainz Database/Schema to MusicBrainz Database/Schema over redirect

8 September 2012

• curprev 22:0022:00, 8 September 2012‎ Conversion script talk‎ m 7,277 bytes 0‎ Conversion script moved page MusicBrainz Database/Schema to musicBrainz Database/Schema: Converting page titles to lowercase