User:Mineo/CDStubs: Difference between revisions

From MusicBrainz Wiki
Jump to navigationJump to search
(Created page with "===CDStubs table structure=== right|300px")
 
No edit summary
Line 1: Line 1:
===CDStubs table structure===
===CDStubs table structure===
[[Image:cdstubs.png|right|300px]]
[[Image:cdstubs.png|right|300px]]

The [[CDStub]]s table structure consists of only 3 tables: cdtoc_raw, release_raw and track_raw.
The ''release_raw'' table contains basic metadata about the stub release, such as the artist and title. The individual tracks of each stub release are in the ''track_raw'' table, which holds the track title and its track number (in the ''sequence'' column). Each CDStub needs an associated [[Disc ID]], which is stored in the ''cdtoc_raw'' table.

Revision as of 12:59, 5 February 2015

CDStubs table structure

cdstubs.png

The CDStubs table structure consists of only 3 tables: cdtoc_raw, release_raw and track_raw. The release_raw table contains basic metadata about the stub release, such as the artist and title. The individual tracks of each stub release are in the track_raw table, which holds the track title and its track number (in the sequence column). Each CDStub needs an associated Disc ID, which is stored in the cdtoc_raw table.