SQL Schema Explorer by Tim Abell

sqlite-chinook

Track

Nearest Tables

Tap a table in the diagram to jump straight to it. Tap & drag in a gap to pan around. Tap & drag a table to re-arrange the diagram.

Tap the "enable zoom" button, then use the mouse wheel to zoom in to where the mouse pointer is.

Customised table layout is not remembered. Refresh the page to reset the diagram.

Columns

Name Type Nulls Outbound Foreign Key Inbound Foreign Keys Indexes
Primary Key TrackId INTEGER NOT NULL InvoiceLine(TrackId) PlaylistTrack(TrackId) IPK_Track
Name NVARCHAR(200) NOT NULL
AlbumId INTEGER Nullable Album(AlbumId) IFK_TrackAlbumId
MediaTypeId INTEGER NOT NULL MediaType(MediaTypeId) IFK_TrackMediaTypeId
GenreId INTEGER Nullable Genre(GenreId) IFK_TrackGenreId
Composer NVARCHAR(220) Nullable
Milliseconds INTEGER NOT NULL
Bytes INTEGER Nullable
UnitPrice NUMERIC(10,2) NOT NULL

Foreign Keys

Outbound

From To
MediaTypeId MediaType(MediaTypeId)
GenreId Genre(GenreId)
AlbumId Album(AlbumId)

Inbound

From To
InvoiceLine(TrackId) TrackId
PlaylistTrack(TrackId) TrackId

Indexes

Name Columns Unique
IFK_TrackMediaTypeId MediaTypeId
IFK_TrackGenreId GenreId
IFK_TrackAlbumId AlbumId
IPK_Track TrackId Unique

Data

Skip to Data Controls Show just the data
sort TrackId sort Name sort AlbumId sort MediaTypeId sort GenreId sort Composer sort Milliseconds sort Bytes sort UnitPrice Referenced by
23 Walk On Water 5Big Ones 1MPEG audio file 1Rock Steven Tyler, Joe Perry, Jack Blades, Tommy Shaw 295680 9719579 0.99 InvoiceLine: TrackId - 0 rows
PlaylistTrack: TrackId - 3 rows
24 Love In An Elevator 5Big Ones 1MPEG audio file 1Rock Steven Tyler, Joe Perry 321828 10552051 0.99 InvoiceLine: TrackId - 1 rows
PlaylistTrack: TrackId - 3 rows
25 Rag Doll 5Big Ones 1MPEG audio file 1Rock Steven Tyler, Joe Perry, Jim Vallance, Holly Knight 264698 8675345 0.99 InvoiceLine: TrackId - 1 rows
PlaylistTrack: TrackId - 3 rows
26 What It Takes 5Big Ones 1MPEG audio file 1Rock Steven Tyler, Joe Perry, Desmond Child 310622 10144730 0.99 InvoiceLine: TrackId - 1 rows
PlaylistTrack: TrackId - 3 rows
27 Dude (Looks Like A Lady) 5Big Ones 1MPEG audio file 1Rock Steven Tyler, Joe Perry, Desmond Child 264855 8679940 0.99 InvoiceLine: TrackId - 0 rows
PlaylistTrack: TrackId - 3 rows
28 Janie's Got A Gun 5Big Ones 1MPEG audio file 1Rock Steven Tyler, Tom Hamilton 330736 10869391 0.99 InvoiceLine: TrackId - 1 rows
PlaylistTrack: TrackId - 3 rows
29 Cryin' 5Big Ones 1MPEG audio file 1Rock Steven Tyler, Joe Perry, Taylor Rhodes 309263 10056995 0.99 InvoiceLine: TrackId - 0 rows
PlaylistTrack: TrackId - 3 rows
30 Amazing 5Big Ones 1MPEG audio file 1Rock Steven Tyler, Richie Supa 356519 11616195 0.99 InvoiceLine: TrackId - 1 rows
PlaylistTrack: TrackId - 3 rows
31 Blind Man 5Big Ones 1MPEG audio file 1Rock Steven Tyler, Joe Perry, Taylor Rhodes 240718 7877453 0.99 InvoiceLine: TrackId - 1 rows
PlaylistTrack: TrackId - 3 rows
32 Deuces Are Wild 5Big Ones 1MPEG audio file 1Rock Steven Tyler, Jim Vallance 215875 7074167 0.99 InvoiceLine: TrackId - 2 rows
PlaylistTrack: TrackId - 3 rows
33 The Other Side 5Big Ones 1MPEG audio file 1Rock Steven Tyler, Jim Vallance 244375 7983270 0.99 InvoiceLine: TrackId - 0 rows
PlaylistTrack: TrackId - 3 rows
34 Crazy 5Big Ones 1MPEG audio file 1Rock Steven Tyler, Joe Perry, Desmond Child 316656 10402398 0.99 InvoiceLine: TrackId - 0 rows
PlaylistTrack: TrackId - 3 rows
35 Eat The Rich 5Big Ones 1MPEG audio file 1Rock Steven Tyler, Joe Perry, Jim Vallance 251036 8262039 0.99 InvoiceLine: TrackId - 0 rows
PlaylistTrack: TrackId - 3 rows
36 Angel 5Big Ones 1MPEG audio file 1Rock Steven Tyler, Desmond Child 307617 9989331 0.99 InvoiceLine: TrackId - 1 rows
PlaylistTrack: TrackId - 3 rows
37 Livin' On The Edge 5Big Ones 1MPEG audio file 1Rock Steven Tyler, Joe Perry, Mark Hudson 381231 12374569 0.99 InvoiceLine: TrackId - 1 rows
PlaylistTrack: TrackId - 3 rows
Filter
Clear Filter
AlbumId 5
Page
No earlier pages
No more pages
3503 rows in table
15 rows for this filter
15 rows shown
Showing rows 1 to end

Display
Switch to card view
^ top