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
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
Filter
Clear Filter
InvoiceId 33
Page
No earlier pages
No more pages
2240 rows in table
14 rows for this filter
14 rows shown
Showing rows 1 to end

Display
Switch to card view
^ top