SQL Schema Explorer by Tim Abell

sqlite-chinook

InvoiceLine

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 InvoiceLineId INTEGER NOT NULL IPK_InvoiceLine
InvoiceId INTEGER NOT NULL Invoice(InvoiceId) IFK_InvoiceLineInvoiceId
TrackId INTEGER NOT NULL Track(TrackId) IFK_InvoiceLineTrackId
UnitPrice NUMERIC(10,2) NOT NULL
Quantity INTEGER NOT NULL

Foreign Keys

Outbound

From To
TrackId Track(TrackId)
InvoiceId Invoice(InvoiceId)

Indexes

Name Columns Unique
IFK_InvoiceLineTrackId TrackId
IFK_InvoiceLineInvoiceId InvoiceId
IPK_InvoiceLine InvoiceLineId Unique

Data

Skip to Data Controls Show just the data
sort InvoiceLineId sort InvoiceId asc 1 TrackId sort UnitPrice sort Quantity
579 108 1For Those About To Rock (We Salute You) 0.99 1
1 1 2Balls to the Wall 0.99 1
1154 214 2Balls to the Wall 0.99 1
1728 319 3Fast As a Shark 0.99 1
2 1 4Restless and Wild 0.99 1
580 108 5Princess of the Dawn 0.99 1
3 2 6Put The Finger On You 0.99 1
4 2 8Inject The Venom 0.99 1
1155 214 8Inject The Venom 0.99 1
581 108 9Snowballed 0.99 1
1729 319 9Snowballed 0.99 1
5 2 10Evil Walks 0.99 1
6 2 12Breaking The Rules 0.99 1
582 108 13Night Of The Long Knives 0.99 1
1156 214 14Spellbound 0.99 1
1730 319 15Go Down 0.99 1
7 3 16Dog Eat Dog 0.99 1
583 109 19Problem Child 0.99 1
8 3 20Overdose 0.99 1
1157 214 20Overdose 0.99 1
1731 319 21Hell Ain't A Bad Place To Be 0.99 1
9 3 24Love In An Elevator 0.99 1
584 109 25Rag Doll 0.99 1
1158 214 26What It Takes 0.99 1
10 3 28Janie's Got A Gun 0.99 1
1732 320 30Amazing 0.99 1
585 109 31Blind Man 0.99 1
11 3 32Deuces Are Wild 0.99 1
1159 214 32Deuces Are Wild 0.99 1
12 3 36Angel 0.99 1
586 109 37Livin' On The Edge 0.99 1
1160 214 38All I Really Want 0.99 1
1733 320 39You Oughta Know 0.99 1
13 4 42Right Through You 0.99 1
587 109 43Forgiven 0.99 1
1161 214 44You Learn 0.99 1
14 4 48Not The Doctor 0.99 1
1734 320 48Not The Doctor 0.99 1
588 109 49Wake Up 0.99 1
1162 215 53Sea Of Sorrow 0.99 1
15 4 54Bleed The Freak 0.99 1
589 109 55I Can't Remember 0.99 1
1735 320 57It Ain't Like That 0.99 1
16 4 60Confusion 0.99 1
590 109 61I Know Somethin (Bout You) 0.99 1
1163 215 62Real Thing 0.99 1
17 4 66Por Causa De Você 0.99 1
1736 320 66Por Causa De Você 0.99 1
591 109 67Ligia 0.99 1
1164 215 71Falando De Amor 0.99 1
18 4 72Angela 0.99 1
1737 320 75O Boto (Bôto) 0.99 1
592 110 76Canta, Canta Mais 0.99 1
19 4 78Master Of Puppets 0.99 1
1165 215 80The Unforgiven 0.99 1
20 4 84Welcome Home (Sanitarium) 0.99 1
1738 320 84Welcome Home (Sanitarium) 0.99 1
593 110 85Cochise 0.99 1
1166 215 89Like a Stone 0.99 1
21 4 90Set It Off 0.99 1
1739 320 93Exploder 0.99 1
594 110 94Hypnotize 0.99 1
1167 215 98The Last Remaining Light 0.99 1
22 5 99Your Time Has Come 0.99 1
1740 320 102Doesn't Remind Me 0.99 1
595 110 103Drown Me Slowly 0.99 1
1168 215 107Yesterday To Tomorrow 0.99 1
23 5 108Dandelion 0.99 1
1741 320 111Money 0.99 1
596 110 112Long Tall Sally 0.99 1
1169 215 116C'Mon Everybody 0.99 1
24 5 117Rock 'N' Roll Music 0.99 1
1742 320 120Carol 0.99 1
597 110 121Good Golly Miss Molly 0.99 1
1170 215 125Spanish moss-"A sound portrait"-Spanish moss 0.99 1
25 5 126Moon germs 0.99 1
1743 320 129Solo-Panhandler 0.99 1
598 110 130Do what cha wanna 0.99 1
1171 215 134All For You 0.99 1
26 5 135Super Terrorizer 0.99 1
1744 320 138Bored To Tears 0.99 1
599 110 139A.N.D.R.O.T.A.Z. 0.99 1
1172 215 143The Begining... At Last 0.99 1
27 5 144Heart Of Gold 0.99 1
1745 320 147Blood In The Wall 0.99 1
600 110 148The Beginning...At Last 0.99 1
1173 215 152N.I.B. 0.99 1
28 5 153Evil Woman 0.99 1
601 110 157Tomorrow's Dream 0.99 1
1174 215 161Snowblind 0.99 1
1746 321 161Snowblind 0.99 1
29 5 162Cornucopia 0.99 1
1747 322 162Cornucopia 0.99 1
1748 322 163Laguna Sunrise 0.99 1
1749 323 165Under The Sun/Every Day Comes and Goes 0.99 1
602 110 166Smoked Pork 0.99 1
1750 323 167Body Count's In The House 0.99 1
1751 324 169Body Count 0.99 1
1175 215 170A Statistic 0.99 1
30 5 171Bowels Of The Devil 0.99 1
Sort
Reset Sort Order
TrackId Ascending
Page
No earlier pages
Next Page >
2240 rows in table
100 rows shown
Showing rows 1 to 100

Display
Switch to card view
^ top