Chinook schema
Tables
Explore the complete relational shape of the Chinook sample database. Every table has a schema reference, preview, relationships, and direct data downloads.
Artist Artists represented in the music catalogue. 2 columns; 0 FKs; 1 connected table; 275 records Album Albums released by an artist. 3 columns; 1 FK; 2 connected tables; 347 records Track Individual audio tracks available in the store. 9 columns; 3 FKs; 5 connected tables; 3,503 records Genre Music genres assigned to tracks. 2 columns; 0 FKs; 1 connected table; 25 records MediaType File and encoding types used by tracks. 2 columns; 0 FKs; 1 connected table; 5 records Playlist Named collections of tracks. 2 columns; 0 FKs; 1 connected table; 18 records PlaylistTrack The many-to-many link between playlists and tracks. 2 columns; 2 FKs; 2 connected tables; 8,715 records Customer Customers who purchase music from the store. 13 columns; 1 FK; 2 connected tables; 59 records Employee Store employees and their reporting relationships. 15 columns; 1 FK; 2 connected tables; 8 records Invoice Orders raised for a customer. 9 columns; 1 FK; 2 connected tables; 412 records InvoiceLine Individual tracks and quantities on an invoice. 5 columns; 2 FKs; 2 connected tables; 2,240 records
Relationship map