SQL Schema Explorer by Tim Abell



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.


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

Foreign Keys


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


Name Columns Unique
IFK_InvoiceLineTrackId TrackId
IFK_InvoiceLineInvoiceId InvoiceId
IPK_InvoiceLine InvoiceLineId Unique


Skip to Data Controls Show just the data
sort InvoiceLineId sort InvoiceId sort TrackId sort UnitPrice sort Quantity
1723 319 3476Help Yourself 0.99 1
1724 319 3482Suite No. 3 in D, BWV 1068: III. Gavotte I & II 0.99 1
1725 319 3488Music for the Funeral of Queen Mary: VI. "Thou Knowest, Lord, the Secrets of Our Hearts" 0.99 1
1726 319 3494Symphony No. 2, Op. 16 - "The Four Temperaments": II. Allegro Comodo e Flemmatico 0.99 1
1727 319 3500String Quartet No. 12 in C Minor, D. 703 "Quartettsatz": II. Andante - Allegro assai 0.99 1
1728 319 3Fast As a Shark 0.99 1
1729 319 9Snowballed 0.99 1
1730 319 15Go Down 0.99 1
1731 319 21Hell Ain't A Bad Place To Be 0.99 1
Clear Filter
InvoiceId 319
No earlier pages
No more pages
2240 rows in table
9 rows for this filter
9 rows shown
Showing rows 1 to end

Switch to card view
^ top