SQL Schema Explorer by Tim Abell

sqlite-chinook

Invoice

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 InvoiceId INTEGER NOT NULL InvoiceLine(InvoiceId) IPK_Invoice
CustomerId INTEGER NOT NULL Customer(CustomerId) IFK_InvoiceCustomerId
InvoiceDate DATETIME NOT NULL
BillingAddress NVARCHAR(70) Nullable
BillingCity NVARCHAR(40) Nullable
BillingState NVARCHAR(40) Nullable
BillingCountry NVARCHAR(40) Nullable
BillingPostalCode NVARCHAR(10) Nullable
Total NUMERIC(10,2) NOT NULL

Foreign Keys

Outbound

From To
CustomerId Customer(CustomerId)

Inbound

From To
InvoiceLine(InvoiceId) InvoiceId

Indexes

Name Columns Unique
IFK_InvoiceCustomerId CustomerId
IPK_Invoice InvoiceId Unique

Data

Skip to Data Controls Show just the data
sort InvoiceId sort CustomerId sort InvoiceDate sort BillingAddress sort BillingCity sort BillingState sort BillingCountry sort BillingPostalCode sort Total Referenced by
28 34JoãoFernandesjfernandes@yahoo.pt 2009-05-05 00:00:00 +0000 UTC Rua da Assunção 53 Lisbon [null] Portugal [null] 1.98 InvoiceLine: InvoiceId - 2 rows
51 34JoãoFernandesjfernandes@yahoo.pt 2009-08-07 00:00:00 +0000 UTC Rua da Assunção 53 Lisbon [null] Portugal [null] 3.96 InvoiceLine: InvoiceId - 4 rows
73 34JoãoFernandesjfernandes@yahoo.pt 2009-11-09 00:00:00 +0000 UTC Rua da Assunção 53 Lisbon [null] Portugal [null] 5.94 InvoiceLine: InvoiceId - 6 rows
125 34JoãoFernandesjfernandes@yahoo.pt 2010-06-30 00:00:00 +0000 UTC Rua da Assunção 53 Lisbon [null] Portugal [null] 0.99 InvoiceLine: InvoiceId - 1 rows
246 34JoãoFernandesjfernandes@yahoo.pt 2011-12-22 00:00:00 +0000 UTC Rua da Assunção 53 Lisbon [null] Portugal [null] 1.98 InvoiceLine: InvoiceId - 2 rows
257 34JoãoFernandesjfernandes@yahoo.pt 2012-02-01 00:00:00 +0000 UTC Rua da Assunção 53 Lisbon [null] Portugal [null] 13.86 InvoiceLine: InvoiceId - 14 rows
312 34JoãoFernandesjfernandes@yahoo.pt 2012-10-01 00:00:00 +0000 UTC Rua da Assunção 53 Lisbon [null] Portugal [null] 10.91 InvoiceLine: InvoiceId - 9 rows
Filter
Clear Filter
CustomerId 34
Page
No earlier pages
No more pages
412 rows in table
7 rows for this filter
7 rows shown
Showing rows 1 to end

Display
Switch to card view
^ top