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 sort TrackId sort UnitPrice sort Quantity
101 19 590Seis Da Tarde 0.99 1
102 19 599Compulsion 0.99 1
103 19 608The Pan Piper 0.99 1
104 19 617Jean Pierre (Live) 0.99 1
105 19 626Drum Boogie 0.99 1
106 19 635Lemon Drop 0.99 1
107 19 644Showcase 0.99 1
108 19 653Como É Duro Trabalhar 0.99 1
109 19 662Pela Luz dos Olhos Teus (Miúcha e Tom Jobim) 0.99 1
110 19 671As Rosas Não Falam (Beth Carvalho) 0.99 1
111 19 680Green River 0.99 1
112 20 694Someday Never Comes 0.99 1
113 21 695Walking On The Water 0.99 1
114 21 696Suzie-Q, Pt. 2 0.99 1
115 22 698Good Golly Miss Molly 0.99 1
116 22 700Wrote A Song For Everyone 0.99 1
117 23 702Cotton Fields 0.99 1
118 23 704Don't Look Now 0.99 1
119 23 706Before You Accuse Me 0.99 1
120 23 708Pagan Baby 0.99 1
121 24 712Born To Move 0.99 1
122 24 716Brasil 0.99 1
123 24 720Coroné Antonio Bento 0.99 1
124 24 724Música Urbana 2 0.99 1
125 24 728Woman Is The Nigger Of The World (Ao Vivo) 0.99 1
126 24 732Smells Like Teen Spirit (Ao Vivo) 0.99 1
127 25 738Admirável Gado Novo 0.99 1
128 25 744Mis Penas Lloraba Yo (Ao Vivo) Soy Gitano (Tangos) 0.99 1
129 25 750Drifter 0.99 1
130 25 756Child In Time 0.99 1
131 25 762No No No 0.99 1
132 25 768Knocking At Your Back Door 0.99 1
133 25 774The Unwritten Law 0.99 1
134 25 780Maybe I'm A Leo 0.99 1
135 25 786Vavoom : Ted The Mechanic 0.99 1
136 26 795Hey Cisco 0.99 1
137 26 804Fortuneteller 0.99 1
138 26 813High Ball Shooter 0.99 1
139 26 822A Twist In The Tail 0.99 1
140 26 831Animal 0.99 1
141 26 840Hysteria 0.99 1
142 26 849Baltimore, DC 0.99 1
143 26 858Esquinas 0.99 1
144 26 867Açai 0.99 1
145 26 876Um Amor Puro 0.99 1
146 26 885Fascinação 0.99 1
147 26 894Sunshine Of Your Love 0.99 1
148 26 903Lay Down Sally 0.99 1
149 26 912Tears In Heaven 0.99 1
150 27 926Naked In Front Of The Computer 0.99 1
151 28 927Helpless 0.99 1
152 28 928Mouth To Mouth 0.99 1
153 29 930She Loves Me Not 0.99 1
154 29 932Paths Of Glory 0.99 1
155 30 934Pristina 0.99 1
156 30 936Caffeine 0.99 1
157 30 938RV 0.99 1
158 30 940Everything's Ruined 0.99 1
159 31 944A Small Victory 0.99 1
160 31 948Easy 0.99 1
161 31 952The Gentle Art Of Making Enemies 0.99 1
162 31 956Ugly In The Morning 0.99 1
163 31 960What A Day 0.99 1
164 31 964From Out Of Nowhere 0.99 1
165 32 970Underwater Love 0.99 1
166 32 976Falamansa Song 0.99 1
167 32 982Avisa 0.99 1
168 32 988Desaforo 0.99 1
169 32 994The Last Song 0.99 1
170 32 1000What If I Do? 0.99 1
171 32 1006Virginia Moon 0.99 1
172 32 1012Times Like These 0.99 1
173 32 1018Burn Away 0.99 1
174 33 1027See You 0.99 1
175 33 1036I Get A Kick Out Of You 0.99 1
176 33 1045Fly Me To The Moon 0.99 1
177 33 1054Mack The Knife 0.99 1
178 33 1063Funk Hum 0.99 1
179 33 1072Forty Days Instrumental 0.99 1
180 33 1081Pau-De-Arara 0.99 1
181 33 1090Stir It Up (Live) 0.99 1
182 33 1099A Novidade (Live) 0.99 1
183 33 1108Realce 0.99 1
184 33 1117Aquele Abraço 0.99 1
185 33 1126Re-Align 0.99 1
186 33 1135Holiday 0.99 1
187 33 1144Homecoming / The Death Of St. Jimmy / East 12th St. / Nobody Likes You / Rock And Roll Girlfriend / We're Coming Home Again 0.99 1
188 34 1158Right Next Door to Hell 0.99 1
189 35 1159Dust N' Bones 0.99 1
190 35 1160Live and Let Die 0.99 1
191 36 1162Perfect Crime 0.99 1
192 36 1164Bad Obsession 0.99 1
193 37 1166Double Talkin' Jive 0.99 1
194 37 1168The Garden 0.99 1
195 37 1170Don't Damn Me 0.99 1
196 37 1172Dead Horse 0.99 1
197 38 1176Yesterdays 0.99 1
198 38 1180Breakdown 0.99 1
199 38 1184Estranged 0.99 1
200 38 1188Colibri 0.99 1
Page
< Previous Page
Next Page >
2240 rows in table
100 rows shown
Showing rows 101 to 200

Display
Switch to card view
^ top