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
964 From Out Of Nowhere 77The Real Thing 1MPEG audio file 4Alternative & Punk Faith No More 202527 6587802 0.99 InvoiceLine: TrackId - 1 rows
PlaylistTrack: TrackId - 2 rows
965 Epic 77The Real Thing 1MPEG audio file 4Alternative & Punk Faith No More 294008 9631296 0.99 InvoiceLine: TrackId - 1 rows
PlaylistTrack: TrackId - 2 rows
966 Falling To Pieces 77The Real Thing 1MPEG audio file 4Alternative & Punk Faith No More 316055 10333123 0.99 InvoiceLine: TrackId - 1 rows
PlaylistTrack: TrackId - 2 rows
967 Surprise! You're Dead! 77The Real Thing 1MPEG audio file 4Alternative & Punk Faith No More 147226 4823036 0.99 InvoiceLine: TrackId - 1 rows
PlaylistTrack: TrackId - 2 rows
968 Zombie Eaters 77The Real Thing 1MPEG audio file 4Alternative & Punk Faith No More 360881 11835367 0.99 InvoiceLine: TrackId - 0 rows
PlaylistTrack: TrackId - 2 rows
969 The Real Thing 77The Real Thing 1MPEG audio file 4Alternative & Punk Faith No More 493635 16233080 0.99 InvoiceLine: TrackId - 0 rows
PlaylistTrack: TrackId - 2 rows
970 Underwater Love 77The Real Thing 1MPEG audio file 4Alternative & Punk Faith No More 231993 7634387 0.99 InvoiceLine: TrackId - 1 rows
PlaylistTrack: TrackId - 2 rows
971 The Morning After 77The Real Thing 1MPEG audio file 4Alternative & Punk Faith No More 223764 7355898 0.99 InvoiceLine: TrackId - 1 rows
PlaylistTrack: TrackId - 2 rows
972 Woodpecker From Mars 77The Real Thing 1MPEG audio file 4Alternative & Punk Faith No More 340532 11174250 0.99 InvoiceLine: TrackId - 1 rows
PlaylistTrack: TrackId - 2 rows
973 War Pigs 77The Real Thing 1MPEG audio file 4Alternative & Punk Tony Iommi, Bill Ward, Geezer Butler, Ozzy Osbourne 464770 15267802 0.99 InvoiceLine: TrackId - 0 rows
PlaylistTrack: TrackId - 2 rows
974 Edge Of The World 77The Real Thing 1MPEG audio file 4Alternative & Punk Faith No More 250357 8235607 0.99 InvoiceLine: TrackId - 0 rows
PlaylistTrack: TrackId - 2 rows
Filter
Clear Filter
AlbumId 77
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