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
38 All I Really Want 6Jagged Little Pill 1MPEG audio file 1Rock Alanis Morissette & Glenn Ballard 284891 9375567 0.99 InvoiceLine: TrackId - 1 rows
PlaylistTrack: TrackId - 3 rows
39 You Oughta Know 6Jagged Little Pill 1MPEG audio file 1Rock Alanis Morissette & Glenn Ballard 249234 8196916 0.99 InvoiceLine: TrackId - 1 rows
PlaylistTrack: TrackId - 3 rows
40 Perfect 6Jagged Little Pill 1MPEG audio file 1Rock Alanis Morissette & Glenn Ballard 188133 6145404 0.99 InvoiceLine: TrackId - 0 rows
PlaylistTrack: TrackId - 3 rows
41 Hand In My Pocket 6Jagged Little Pill 1MPEG audio file 1Rock Alanis Morissette & Glenn Ballard 221570 7224246 0.99 InvoiceLine: TrackId - 0 rows
PlaylistTrack: TrackId - 3 rows
42 Right Through You 6Jagged Little Pill 1MPEG audio file 1Rock Alanis Morissette & Glenn Ballard 176117 5793082 0.99 InvoiceLine: TrackId - 1 rows
PlaylistTrack: TrackId - 3 rows
43 Forgiven 6Jagged Little Pill 1MPEG audio file 1Rock Alanis Morissette & Glenn Ballard 300355 9753256 0.99 InvoiceLine: TrackId - 1 rows
PlaylistTrack: TrackId - 3 rows
44 You Learn 6Jagged Little Pill 1MPEG audio file 1Rock Alanis Morissette & Glenn Ballard 239699 7824837 0.99 InvoiceLine: TrackId - 1 rows
PlaylistTrack: TrackId - 3 rows
45 Head Over Feet 6Jagged Little Pill 1MPEG audio file 1Rock Alanis Morissette & Glenn Ballard 267493 8758008 0.99 InvoiceLine: TrackId - 0 rows
PlaylistTrack: TrackId - 3 rows
46 Mary Jane 6Jagged Little Pill 1MPEG audio file 1Rock Alanis Morissette & Glenn Ballard 280607 9163588 0.99 InvoiceLine: TrackId - 0 rows
PlaylistTrack: TrackId - 3 rows
47 Ironic 6Jagged Little Pill 1MPEG audio file 1Rock Alanis Morissette & Glenn Ballard 229825 7598866 0.99 InvoiceLine: TrackId - 0 rows
PlaylistTrack: TrackId - 3 rows
48 Not The Doctor 6Jagged Little Pill 1MPEG audio file 1Rock Alanis Morissette & Glenn Ballard 227631 7604601 0.99 InvoiceLine: TrackId - 2 rows
PlaylistTrack: TrackId - 3 rows
49 Wake Up 6Jagged Little Pill 1MPEG audio file 1Rock Alanis Morissette & Glenn Ballard 293485 9703359 0.99 InvoiceLine: TrackId - 1 rows
PlaylistTrack: TrackId - 3 rows
50 You Oughta Know (Alternate) 6Jagged Little Pill 1MPEG audio file 1Rock Alanis Morissette & Glenn Ballard 491885 16008629 0.99 InvoiceLine: TrackId - 0 rows
PlaylistTrack: TrackId - 3 rows
Filter
Clear Filter
AlbumId 6
Page
No earlier pages
No more pages
3503 rows in table
13 rows for this filter
13 rows shown
Showing rows 1 to end

Display
Switch to card view
^ top