User:Mineo/CDStubs

From MusicBrainz Wiki
< User:Mineo
Revision as of 13:03, 5 February 2015 by Mineo (talk | contribs)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

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). A tracks artist can be different than the artist of the release, so there's an artist column which can optionally contain the name of the tracks artist.

Each CDStub needs an associated Disc ID, which is stored in the cdtoc_raw table, together with the track count of the disc, as well as the leadout and track offset (Disc ID Calculation contains more information about the latter two).