SQL Schema Explorer by Tim Abell

sqlite-chinook

Album

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 AlbumId INTEGER NOT NULL Track(AlbumId) IPK_Album
Title NVARCHAR(160) NOT NULL
ArtistId INTEGER NOT NULL Artist(ArtistId) IFK_AlbumArtistId

Foreign Keys

Outbound

From To
ArtistId Artist(ArtistId)

Inbound

From To
Track(AlbumId) AlbumId

Indexes

Name Columns Unique
IFK_AlbumArtistId ArtistId
IPK_Album AlbumId Unique

Data

Skip to Data Controls Show just the data
sort AlbumId sort Title sort ArtistId Referenced by
3 Restless and Wild 2Accept Track: AlbumId - 3 rows
Filter
Clear Filter
AlbumId 3
Page
No earlier pages
No more pages
347 rows in table
1 row for this filter
1 row shown
Showing rows 1 to end

Display
Switch to card view
^ top