Invoice

412 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
InvoiceId INTEGER 2000000000 null
InvoiceLine.InvoiceId R
CustomerId INTEGER 2000000000 null
Customer.CustomerId R
InvoiceDate DATETIME 2000000000,10 null
BillingAddress NVARCHAR 70 √ null
BillingCity NVARCHAR 40 √ null
BillingState NVARCHAR 40 √ null
BillingCountry NVARCHAR 40 √ null
BillingPostalCode NVARCHAR 10 √ null
Total NUMERIC 12,2 null

Indexes

Constraint Name Type Sort Column(s)
IFK_InvoiceCustomerId Performance Asc CustomerId

Relationships

Close relationships within degrees of separation