SQL Schema Explorer by Tim Abell

sqlite-chinook

PlaylistTrack

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 PlaylistId INTEGER NOT NULL Playlist(PlaylistId) IPK_PlaylistTrack
Primary Key TrackId INTEGER NOT NULL Track(TrackId) IFK_PlaylistTrackTrackId IPK_PlaylistTrack

Foreign Keys

Outbound

From To
TrackId Track(TrackId)
PlaylistId Playlist(PlaylistId)

Indexes

Name Columns Unique
IFK_PlaylistTrackTrackId TrackId
IPK_PlaylistTrack PlaylistId,TrackId Unique

Data

Skip to Data Controls Show just the data
sort PlaylistId sort TrackId
1Music 3402Band Members Discuss Tracks from "Revelations"
1Music 3389Revelations
1Music 3390One and the Same
1Music 3391Sound of a Gun
1Music 3392Until We Fall
1Music 3393Original Fire
1Music 3394Broken City
1Music 3395Somedays
1Music 3396Shape of Things to Come
1Music 3397Jewel of the Summertime
1Music 3398Wide Awake
1Music 3399Nothing Left to Say But Goodbye
1Music 3400Moth
1Music 3401Show Me How to Live (Live at the Quart Festival)
1Music 3336War Pigs
1Music 3478Slowness
1Music 3375No Such Thing
1Music 3376Poison Eye
1Music 3377Arms Around Your Love
1Music 3378Safe and Sound
1Music 3379She'll Never Be Your Man
1Music 3380Ghosts
1Music 3381Killing Birds
1Music 3382Billie Jean
1Music 3383Scar On the Sky
1Music 3384Your Soul Today
1Music 3385Finally Forever
1Music 3386Silence the Voices
1Music 3387Disappearing Act
1Music 3388You Know My Name
1Music 3365Say Hello 2 Heaven
1Music 3366Reach Down
1Music 3367Hunger Strike
1Music 3368Pushin Forward Back
1Music 3369Call Me a Dog
1Music 3370Times of Trouble
1Music 3371Wooden Jesus
1Music 3372Your Savior
1Music 3373Four Walled World
1Music 3374All Night Thing
1Music 99Your Time Has Come
1Music 100Out Of Exile
1Music 101Be Yourself
1Music 102Doesn't Remind Me
1Music 103Drown Me Slowly
1Music 104Heaven's Dead
1Music 105The Worm
1Music 106Man Or Animal
1Music 107Yesterday To Tomorrow
1Music 108Dandelion
1Music 109#1 Zero
1Music 110The Curse
1Music 166Smoked Pork
1Music 167Body Count's In The House
1Music 168Now Sports
1Music 169Body Count
1Music 170A Statistic
1Music 171Bowels Of The Devil
1Music 172The Real Problem
1Music 173KKK Bitch
1Music 174D Note
1Music 175Voodoo
1Music 176The Winner Loses
1Music 177There Goes The Neighborhood
1Music 178Oprah
1Music 179Evil Dick
1Music 180Body Count Anthem
1Music 181Momma's Gotta Die Tonight
1Music 182Freedom Of Speech
1Music 2591White Riot
1Music 2592Remote Control
1Music 2593Complete Control
1Music 2594Clash City Rockers
1Music 2595(White Man) In Hammersmith Palais
1Music 2596Tommy Gun
1Music 2597English Civil War
1Music 2598I Fought The Law
1Music 2599London Calling
1Music 2600Train In Vain
1Music 2601Bankrobber
1Music 2602The Call Up
1Music 2603Hitsville UK
1Music 2604The Magnificent Seven
1Music 2605This Is Radio Clash
1Music 2606Know Your Rights
1Music 2607Rock The Casbah
1Music 2608Should I Stay Or Should I Go
1Music 923Collision
1Music 924Stripsearch
1Music 925Last Cup Of Sorrow
1Music 926Naked In Front Of The Computer
1Music 927Helpless
1Music 928Mouth To Mouth
1Music 929Ashes To Ashes
1Music 930She Loves Me Not
1Music 931Got That Feeling
1Music 932Paths Of Glory
1Music 933Home Sick Home
1Music 934Pristina
1Music 935Land Of Sunshine
Page
No earlier pages
Next Page >
8715 rows in table
100 rows shown
Showing rows 1 to 100

Display
Switch to card view
^ top