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
1201 Different World 94A Matter of Life and Death 2Protected AAC audio file 1Rock [null] 258692 4383764 0.99 InvoiceLine: TrackId - 0 rows
PlaylistTrack: TrackId - 2 rows
1202 These Colours Don't Run 94A Matter of Life and Death 2Protected AAC audio file 1Rock [null] 412152 6883500 0.99 InvoiceLine: TrackId - 1 rows
PlaylistTrack: TrackId - 2 rows
1203 Brighter Than a Thousand Suns 94A Matter of Life and Death 2Protected AAC audio file 1Rock [null] 526255 8721490 0.99 InvoiceLine: TrackId - 1 rows
PlaylistTrack: TrackId - 2 rows
1204 The Pilgrim 94A Matter of Life and Death 2Protected AAC audio file 1Rock [null] 307593 5172144 0.99 InvoiceLine: TrackId - 1 rows
PlaylistTrack: TrackId - 2 rows
1205 The Longest Day 94A Matter of Life and Death 2Protected AAC audio file 1Rock [null] 467810 7785748 0.99 InvoiceLine: TrackId - 0 rows
PlaylistTrack: TrackId - 2 rows
1206 Out of the Shadows 94A Matter of Life and Death 2Protected AAC audio file 1Rock [null] 336896 5647303 0.99 InvoiceLine: TrackId - 0 rows
PlaylistTrack: TrackId - 2 rows
1207 The Reincarnation of Benjamin Breeg 94A Matter of Life and Death 2Protected AAC audio file 1Rock [null] 442106 7367736 0.99 InvoiceLine: TrackId - 0 rows
PlaylistTrack: TrackId - 2 rows
1208 For the Greater Good of God 94A Matter of Life and Death 2Protected AAC audio file 1Rock [null] 564893 9367328 0.99 InvoiceLine: TrackId - 2 rows
PlaylistTrack: TrackId - 2 rows
1209 Lord of Light 94A Matter of Life and Death 2Protected AAC audio file 1Rock [null] 444614 7393698 0.99 InvoiceLine: TrackId - 1 rows
PlaylistTrack: TrackId - 2 rows
1210 The Legacy 94A Matter of Life and Death 2Protected AAC audio file 1Rock [null] 562966 9314287 0.99 InvoiceLine: TrackId - 0 rows
PlaylistTrack: TrackId - 2 rows
1211 Hallowed Be Thy Name (Live) [Non Album Bonus Track] 94A Matter of Life and Death 2Protected AAC audio file 1Rock [null] 431262 7205816 0.99 InvoiceLine: TrackId - 0 rows
PlaylistTrack: TrackId - 2 rows
Filter
Clear Filter
AlbumId 94
Page
No earlier pages
No more pages
3503 rows in table
11 rows for this filter
11 rows shown
Showing rows 1 to end

Display
Switch to card view
^ top