InvoiceLine

sqlite-chinook

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.

	Name	Type	Nulls	Outbound Foreign Key	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

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

sort InvoiceLineId	sort InvoiceId	sort TrackId	sort UnitPrice	sort Quantity
732	136	933Home Sick Home	0.99	1

Filter
Clear Filter
TrackId	933

Page
No earlier pages No more pages
2240 rows in table
1 row for this filter
1 row shown
Showing rows 1 to end
rows per page

Display
Switch to card view

^ top