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
3TV Shows 2819Battlestar Galactica: The Story So Far
3TV Shows 2820Occupation / Precipice
3TV Shows 2821Exodus, Pt. 1
3TV Shows 2822Exodus, Pt. 2
3TV Shows 2823Collaborators
3TV Shows 2824Torn
3TV Shows 2825A Measure of Salvation
3TV Shows 2826Hero
3TV Shows 2827Unfinished Business
3TV Shows 2828The Passage
3TV Shows 2829The Eye of Jupiter
3TV Shows 2830Rapture
3TV Shows 2831Taking a Break from All Your Worries
3TV Shows 2832The Woman King
3TV Shows 2833A Day In the Life
3TV Shows 2834Dirty Hands
3TV Shows 2835Maelstrom
3TV Shows 2836The Son Also Rises
3TV Shows 2837Crossroads, Pt. 1
3TV Shows 2838Crossroads, Pt. 2
3TV Shows 2839Genesis
3TV Shows 2840Don't Look Back
3TV Shows 2841One Giant Leap
3TV Shows 2842Collision
3TV Shows 2843Hiros
3TV Shows 2844Better Halves
3TV Shows 2845Nothing to Hide
3TV Shows 2846Seven Minutes to Midnight
3TV Shows 2847Homecoming
3TV Shows 2848Six Months Ago
3TV Shows 2849Fallout
3TV Shows 2850The Fix
3TV Shows 2851Distractions
3TV Shows 2852Run!
3TV Shows 2853Unexpected
3TV Shows 2854Company Man
3TV Shows 2855Company Man
3TV Shows 2856Parasite
3TV Shows 2857A Tale of Two Cities
3TV Shows 2858Lost (Pilot, Part 1) [Premiere]
3TV Shows 2859Man of Science, Man of Faith (Premiere)
3TV Shows 2860Adrift
3TV Shows 2861Lost (Pilot, Part 2)
3TV Shows 2862The Glass Ballerina
3TV Shows 2863Further Instructions
3TV Shows 2864Orientation
3TV Shows 2865Tabula Rasa
3TV Shows 2866Every Man for Himself
3TV Shows 2867Everybody Hates Hugo
3TV Shows 2868Walkabout
3TV Shows 2869...And Found
3TV Shows 2870The Cost of Living
3TV Shows 2871White Rabbit
3TV Shows 2872Abandoned
3TV Shows 2873House of the Rising Sun
3TV Shows 2874I Do
3TV Shows 2875Not In Portland
3TV Shows 2876Not In Portland
3TV Shows 2877The Moth
3TV Shows 2878The Other 48 Days
3TV Shows 2879Collision
3TV Shows 2880Confidence Man
3TV Shows 2881Flashes Before Your Eyes
3TV Shows 2882Lost Survival Guide
3TV Shows 2883Solitary
3TV Shows 2884What Kate Did
3TV Shows 2885Raised By Another
3TV Shows 2886Stranger In a Strange Land
3TV Shows 2887The 23rd Psalm
3TV Shows 2888All the Best Cowboys Have Daddy Issues
3TV Shows 2889The Hunting Party
3TV Shows 2890Tricia Tanaka Is Dead
3TV Shows 2891Enter 77
3TV Shows 2892Fire + Water
3TV Shows 2893Whatever the Case May Be
3TV Shows 2894Hearts and Minds
3TV Shows 2895Par Avion
3TV Shows 2896The Long Con
3TV Shows 2897One of Them
3TV Shows 2898Special
3TV Shows 2899The Man from Tallahassee
3TV Shows 2900Exposé
3TV Shows 2901Homecoming
3TV Shows 2902Maternity Leave
3TV Shows 2903Left Behind
3TV Shows 2904Outlaws
3TV Shows 2905The Whole Truth
3TV Shows 2906...In Translation
3TV Shows 2907Lockdown
3TV Shows 2908One of Us
3TV Shows 2909Catch-22
3TV Shows 2910Dave
3TV Shows 2911Numbers
3TV Shows 2912D.O.C.
3TV Shows 2913Deus Ex Machina
3TV Shows 2914S.O.S.
3TV Shows 2915Do No Harm
3TV Shows 2916Two for the Road
3TV Shows 2917The Greater Good
3TV Shows 2918"?"
Filter
Clear Filter
PlaylistId 3
Page
No earlier pages
Next Page >
8715 rows in table
213 rows for this filter
100 rows shown
Showing rows 1 to 100

Display
Switch to card view
^ top