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
1 For Those About To Rock (We Salute You) 1For Those About To Rock We Salute You 1MPEG audio file 1Rock Angus Young, Malcolm Young, Brian Johnson 343719 11170334 0.99 InvoiceLine: TrackId - 1 rows
PlaylistTrack: TrackId - 3 rows
6 Put The Finger On You 1For Those About To Rock We Salute You 1MPEG audio file 1Rock Angus Young, Malcolm Young, Brian Johnson 205662 6713451 0.99 InvoiceLine: TrackId - 1 rows
PlaylistTrack: TrackId - 2 rows
7 Let's Get It Up 1For Those About To Rock We Salute You 1MPEG audio file 1Rock Angus Young, Malcolm Young, Brian Johnson 233926 7636561 0.99 InvoiceLine: TrackId - 0 rows
PlaylistTrack: TrackId - 2 rows
8 Inject The Venom 1For Those About To Rock We Salute You 1MPEG audio file 1Rock Angus Young, Malcolm Young, Brian Johnson 210834 6852860 0.99 InvoiceLine: TrackId - 2 rows
PlaylistTrack: TrackId - 2 rows
9 Snowballed 1For Those About To Rock We Salute You 1MPEG audio file 1Rock Angus Young, Malcolm Young, Brian Johnson 203102 6599424 0.99 InvoiceLine: TrackId - 2 rows
PlaylistTrack: TrackId - 2 rows
10 Evil Walks 1For Those About To Rock We Salute You 1MPEG audio file 1Rock Angus Young, Malcolm Young, Brian Johnson 263497 8611245 0.99 InvoiceLine: TrackId - 1 rows
PlaylistTrack: TrackId - 2 rows
11 C.O.D. 1For Those About To Rock We Salute You 1MPEG audio file 1Rock Angus Young, Malcolm Young, Brian Johnson 199836 6566314 0.99 InvoiceLine: TrackId - 0 rows
PlaylistTrack: TrackId - 2 rows
12 Breaking The Rules 1For Those About To Rock We Salute You 1MPEG audio file 1Rock Angus Young, Malcolm Young, Brian Johnson 263288 8596840 0.99 InvoiceLine: TrackId - 1 rows
PlaylistTrack: TrackId - 2 rows
13 Night Of The Long Knives 1For Those About To Rock We Salute You 1MPEG audio file 1Rock Angus Young, Malcolm Young, Brian Johnson 205688 6706347 0.99 InvoiceLine: TrackId - 1 rows
PlaylistTrack: TrackId - 2 rows
14 Spellbound 1For Those About To Rock We Salute You 1MPEG audio file 1Rock Angus Young, Malcolm Young, Brian Johnson 270863 8817038 0.99 InvoiceLine: TrackId - 1 rows
PlaylistTrack: TrackId - 2 rows
Filter
Clear Filter
AlbumId 1
Page
No earlier pages
No more pages
3503 rows in table
10 rows for this filter
10 rows shown
Showing rows 1 to end

Display
Switch to card view
^ top