OpenVaultDB database

Chinook music store

The Chinook sample database: a digital music store with artists, albums, tracks, playlists, customers, employees and invoices. Read-only, served from a pinned copy of the upstream SQLite fixture.

Explore the database site Read-only API Server directory

Published collections

11 read-only collections

11 declared foreign-key relationships. Names and keys preserve the source database schema. The database site includes the complete native schema, including views.

Explore complete schema and exports ↗

Machine-readable database descriptor ↗

Published recordsets

Read-only collections

11 collections

table

Album

3 columns · 347 rows

Albums released by an artist.

AlbumIdINTEGER · PKTitleNVARCHAR(160)ArtistIdINTEGER

References Artist.ArtistId

table

Artist

2 columns · 275 rows

Artists represented in the music catalogue.

ArtistIdINTEGER · PKNameNVARCHAR(120) · nullable

table

Customer

13 columns · 59 rows

Customers who purchase music from the store.

CustomerIdINTEGER · PKFirstNameNVARCHAR(40)LastNameNVARCHAR(20)CompanyNVARCHAR(80) · nullableAddressNVARCHAR(70) · nullableCityNVARCHAR(40) · nullableStateNVARCHAR(40) · nullableCountryNVARCHAR(40) · nullablePostalCodeNVARCHAR(10) · nullablePhoneNVARCHAR(24) · nullableFaxNVARCHAR(24) · nullableEmailNVARCHAR(60)SupportRepIdINTEGER · nullable

References Employee.EmployeeId

table

Employee

15 columns · 8 rows

Store employees and their reporting relationships.

EmployeeIdINTEGER · PKLastNameNVARCHAR(20)FirstNameNVARCHAR(20)TitleNVARCHAR(30) · nullableReportsToINTEGER · nullableBirthDateDATETIME · nullableHireDateDATETIME · nullableAddressNVARCHAR(70) · nullableCityNVARCHAR(40) · nullableStateNVARCHAR(40) · nullableCountryNVARCHAR(40) · nullablePostalCodeNVARCHAR(10) · nullablePhoneNVARCHAR(24) · nullableFaxNVARCHAR(24) · nullableEmailNVARCHAR(60) · nullable

References Employee.EmployeeId

table

Genre

2 columns · 25 rows

Music genres assigned to tracks.

GenreIdINTEGER · PKNameNVARCHAR(120) · nullable

table

Invoice

9 columns · 412 rows

Billing invoices issued to customers for music purchases.

InvoiceIdINTEGER · PKCustomerIdINTEGERInvoiceDateDATETIMEBillingAddressNVARCHAR(70) · nullableBillingCityNVARCHAR(40) · nullableBillingStateNVARCHAR(40) · nullableBillingCountryNVARCHAR(40) · nullableBillingPostalCodeNVARCHAR(10) · nullableTotalNUMERIC(10,2)

References Customer.CustomerId

table

InvoiceLine

5 columns · 2,240 rows

Individual tracks and quantities on an invoice.

InvoiceLineIdINTEGER · PKInvoiceIdINTEGERTrackIdINTEGERUnitPriceNUMERIC(10,2)QuantityINTEGER

References Track.TrackId, Invoice.InvoiceId

table

MediaType

2 columns · 5 rows

File and encoding types used by tracks.

MediaTypeIdINTEGER · PKNameNVARCHAR(120) · nullable

table

Playlist

2 columns · 18 rows

Named collections of tracks.

PlaylistIdINTEGER · PKNameNVARCHAR(120) · nullable

table

PlaylistTrack

2 columns · 8,715 rows

The many-to-many link between playlists and tracks.

PlaylistIdINTEGER · PKTrackIdINTEGER · PK

References Track.TrackId, Playlist.PlaylistId

table

Track

9 columns · 3,503 rows

Individual audio tracks available in the store.

TrackIdINTEGER · PKNameNVARCHAR(200)AlbumIdINTEGER · nullableMediaTypeIdINTEGERGenreIdINTEGER · nullableComposerNVARCHAR(220) · nullableMillisecondsINTEGERBytesINTEGER · nullableUnitPriceNUMERIC(10,2)

References MediaType.MediaTypeId, Genre.GenreId, Album.AlbumId

Provenance

Published data

Source: https://github.com/lerocha/chinook-database at 7f67772503d71ba90f19283c38e93923addb43fa.

Source licence: MIT. Model licence: MIT. Meaning licence: CC0-1.0.

Published by DemoDB; provider repository ↗.

The checked-in SQLite fixture is byte-for-byte the upstream SQLite file from the pinned revision.

Semantic references

Published models

ModelSpec: modelspec://github.com/demo-db/chinook/chinook ↗ · HCL source ↗

MeaningGraph: meaning://github.com/demo-db/chinook ↗

Browse model and meaning files ↗