Difference between revisions of "User:Mineo/CDStubs"

From MusicBrainz Wiki
(Created page with "===CDStubs table structure=== right|300px")
 
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.