Invoice


Description

Markdown syntax example

Invoice table

Important column is Invoice.Total

This is a blockquote.

This is the second paragraph in the blockquote.

This is an H2 in a blockquote

Some of these words are emphasized. Some of these words are emphasized also.

Use two asterisks for strong emphasis. Or, if you prefer, use two underscores instead.

Bullet list:

This is an SchemaSpy.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
InvoiceId int 4 null
InvoiceLine.InvoiceId FK_InvoiceLineInvoiceId R
CustomerId int 4 null
Customer.CustomerId FK_InvoiceCustomerId R
InvoiceDate datetime 16,3 null
BillingAddress nvarchar 140 √ null
BillingCity nvarchar 80 √ null
BillingState nvarchar 80 √ null
BillingCountry nvarchar 80 √ null
BillingPostalCode nvarchar 20 √ null
Total numeric 12,2 null

Table contained 412 rows

Indexes

Constraint Name Type Sort Column(s)
PK_Invoice Primary key Asc InvoiceId
IFK_InvoiceCustomerId Performance Asc CustomerId

Relationships

Close relationships within degrees of separation