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