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
51 We Die Young 7Facelift 1MPEG audio file 1Rock Jerry Cantrell 152084 4925362 0.99 InvoiceLine: TrackId - 0 rows
PlaylistTrack: TrackId - 3 rows
52 Man In The Box 7Facelift 1MPEG audio file 1Rock Jerry Cantrell, Layne Staley 286641 9310272 0.99 InvoiceLine: TrackId - 0 rows
PlaylistTrack: TrackId - 4 rows
53 Sea Of Sorrow 7Facelift 1MPEG audio file 1Rock Jerry Cantrell 349831 11316328 0.99 InvoiceLine: TrackId - 1 rows
PlaylistTrack: TrackId - 3 rows
54 Bleed The Freak 7Facelift 1MPEG audio file 1Rock Jerry Cantrell 241946 7847716 0.99 InvoiceLine: TrackId - 1 rows
PlaylistTrack: TrackId - 3 rows
55 I Can't Remember 7Facelift 1MPEG audio file 1Rock Jerry Cantrell, Layne Staley 222955 7302550 0.99 InvoiceLine: TrackId - 1 rows
PlaylistTrack: TrackId - 3 rows
56 Love, Hate, Love 7Facelift 1MPEG audio file 1Rock Jerry Cantrell, Layne Staley 387134 12575396 0.99 InvoiceLine: TrackId - 0 rows
PlaylistTrack: TrackId - 3 rows
57 It Ain't Like That 7Facelift 1MPEG audio file 1Rock Jerry Cantrell, Michael Starr, Sean Kinney 277577 8993793 0.99 InvoiceLine: TrackId - 1 rows
PlaylistTrack: TrackId - 3 rows
58 Sunshine 7Facelift 1MPEG audio file 1Rock Jerry Cantrell 284969 9216057 0.99 InvoiceLine: TrackId - 0 rows
PlaylistTrack: TrackId - 3 rows
59 Put You Down 7Facelift 1MPEG audio file 1Rock Jerry Cantrell 196231 6420530 0.99 InvoiceLine: TrackId - 0 rows
PlaylistTrack: TrackId - 3 rows
60 Confusion 7Facelift 1MPEG audio file 1Rock Jerry Cantrell, Michael Starr, Layne Staley 344163 11183647 0.99 InvoiceLine: TrackId - 1 rows
PlaylistTrack: TrackId - 3 rows
61 I Know Somethin (Bout You) 7Facelift 1MPEG audio file 1Rock Jerry Cantrell 261955 8497788 0.99 InvoiceLine: TrackId - 1 rows
PlaylistTrack: TrackId - 3 rows
62 Real Thing 7Facelift 1MPEG audio file 1Rock Jerry Cantrell, Layne Staley 243879 7937731 0.99 InvoiceLine: TrackId - 1 rows
PlaylistTrack: TrackId - 3 rows
Filter
Clear Filter
AlbumId 7
Page
No earlier pages
No more pages
3503 rows in table
12 rows for this filter
12 rows shown
Showing rows 1 to end

Display
Switch to card view
^ top