Chinook schema
Tables and views
Explore the native recordsets with their real names, schema, relationships, row counts, and direct downloads.
table Album Albums released by an artist. 3 columns · 1 links · 347 rows · 2 matches in other samples table Artist Artists represented in the music catalogue. 2 columns · 0 links · 275 rows · 1 matches in other samples table Customer Customers who purchase music from the store. 13 columns · 1 links · 59 rows · 2 matches in other samples table Employee Store employees and their reporting relationships. 15 columns · 1 links · 8 rows · 2 matches in other samples table Genre Music genres assigned to tracks. 2 columns · 0 links · 25 rows · 1 matches in other samples table Invoice Billing invoices issued to customers for music purchases. 9 columns · 1 links · 412 rows · 2 matches in other samples table InvoiceLine Individual tracks and quantities on an invoice. 5 columns · 2 links · 2,240 rows · 2 matches in other samples table MediaType File and encoding types used by tracks. 2 columns · 0 links · 5 rows · 1 matches in other samples table Playlist Named collections of tracks. 2 columns · 0 links · 18 rows · 1 matches in other samples table PlaylistTrack The many-to-many link between playlists and tracks. 2 columns · 2 links · 8,715 rows · 2 matches in other samples table Track Individual audio tracks available in the store. 9 columns · 3 links · 3,503 rows · 5 matches in other samples
Relationship map