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
326 61 1955Please Don't Touch 0.99 1
327 61 1964Já Foi 0.99 1
328 61 1973Wild Side 0.99 1
329 61 1982Primal Scream 0.99 1
330 61 1991Been A Son 0.99 1
331 61 2000Breed 0.99 1
332 61 2009Territorial Pissings 0.99 1
333 61 2018Folhas Secas 0.99 1
334 61 2027Menino De Rua 0.99 1
335 61 2036Denúncia 0.99 1
336 61 2045O Trem Da Juventude 0.99 1
337 61 2054Selvagem 0.99 1
338 61 2063Nebulosa Do Amor 0.99 1
339 61 2072Luis Inacio (300 Picaretas) 0.99 1
Filter
Clear Filter
InvoiceId 61
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