Album

sqlite-chinook

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.

	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

From	To
ArtistId	Artist(ArtistId)

From	To
Track(AlbumId)	AlbumId

Name	Columns	Unique
IFK_AlbumArtistId	ArtistId
IPK_Album	AlbumId	Unique

sort AlbumId	sort Title	sort ArtistId	Referenced by
277	Bach: Goldberg Variations	211Wilhelm Kempff	Track: AlbumId - 1 rows

Filter
Clear Filter
AlbumId	277

Page
No earlier pages No more pages
347 rows in table
1 row for this filter
1 row shown
Showing rows 1 to end
rows per page

Display
Switch to card view

^ top