Invoice database schema

invoice_items

*InvoiceLineIdINTEGER

*InvoiceIdINTEGER↗

*TrackIdINTEGER↗

*UnitPriceNUMERIC(12,2)

*QuantityINTEGER

invoices

*InvoiceIdINTEGER↙

*CustomerIdINTEGER↗

*InvoiceDateDATETIME

BillingAddressTEXT

BillingCityTEXT

BillingStateTEXT

BillingCountryTEXT

BillingPostalCodeTEXT

*TotalNUMERIC(12,2)

customers

*CustomerIdINTEGER↙

*FirstNameTEXT

*LastNameTEXT

CompanyTEXT

AddressTEXT

CityTEXT

StateTEXT

CountryTEXT

PostalCodeTEXT

PhoneTEXT

FaxTEXT

*EmailTEXT

SupportRepIdINTEGER↗

department

*department_idINT↙

department_nameTEXT

LocationINT

BudgetDECIMAL