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
85 Cochise 10Audioslave 1MPEG audio file 1Rock Audioslave/Chris Cornell 222380 5339931 0.99 InvoiceLine: TrackId - 1 rows
PlaylistTrack: TrackId - 2 rows
86 Show Me How to Live 10Audioslave 1MPEG audio file 1Rock Audioslave/Chris Cornell 277890 6672176 0.99 InvoiceLine: TrackId - 0 rows
PlaylistTrack: TrackId - 2 rows
87 Gasoline 10Audioslave 1MPEG audio file 1Rock Audioslave/Chris Cornell 279457 6709793 0.99 InvoiceLine: TrackId - 0 rows
PlaylistTrack: TrackId - 2 rows
88 What You Are 10Audioslave 1MPEG audio file 1Rock Audioslave/Chris Cornell 249391 5988186 0.99 InvoiceLine: TrackId - 0 rows
PlaylistTrack: TrackId - 2 rows
89 Like a Stone 10Audioslave 1MPEG audio file 1Rock Audioslave/Chris Cornell 294034 7059624 0.99 InvoiceLine: TrackId - 1 rows
PlaylistTrack: TrackId - 2 rows
90 Set It Off 10Audioslave 1MPEG audio file 1Rock Audioslave/Chris Cornell 263262 6321091 0.99 InvoiceLine: TrackId - 1 rows
PlaylistTrack: TrackId - 2 rows
91 Shadow on the Sun 10Audioslave 1MPEG audio file 1Rock Audioslave/Chris Cornell 343457 8245793 0.99 InvoiceLine: TrackId - 0 rows
PlaylistTrack: TrackId - 2 rows
92 I am the Highway 10Audioslave 1MPEG audio file 1Rock Audioslave/Chris Cornell 334942 8041411 0.99 InvoiceLine: TrackId - 0 rows
PlaylistTrack: TrackId - 2 rows
93 Exploder 10Audioslave 1MPEG audio file 1Rock Audioslave/Chris Cornell 206053 4948095 0.99 InvoiceLine: TrackId - 1 rows
PlaylistTrack: TrackId - 2 rows
94 Hypnotize 10Audioslave 1MPEG audio file 1Rock Audioslave/Chris Cornell 206628 4961887 0.99 InvoiceLine: TrackId - 1 rows
PlaylistTrack: TrackId - 2 rows
95 Bring'em Back Alive 10Audioslave 1MPEG audio file 1Rock Audioslave/Chris Cornell 329534 7911634 0.99 InvoiceLine: TrackId - 0 rows
PlaylistTrack: TrackId - 2 rows
96 Light My Way 10Audioslave 1MPEG audio file 1Rock Audioslave/Chris Cornell 303595 7289084 0.99 InvoiceLine: TrackId - 0 rows
PlaylistTrack: TrackId - 2 rows
97 Getaway Car 10Audioslave 1MPEG audio file 1Rock Audioslave/Chris Cornell 299598 7193162 0.99 InvoiceLine: TrackId - 0 rows
PlaylistTrack: TrackId - 2 rows
98 The Last Remaining Light 10Audioslave 1MPEG audio file 1Rock Audioslave/Chris Cornell 317492 7622615 0.99 InvoiceLine: TrackId - 1 rows
PlaylistTrack: TrackId - 2 rows
Filter
Clear Filter
AlbumId 10
Page
No earlier pages
No more pages
3503 rows in table
14 rows for this filter
14 rows shown
Showing rows 1 to end

Display
Switch to card view
^ top