Place

Tables (4)

Customer (Untitled2)

  • Cust (Field) — Primary key
  • Cname (Field2)
  • Street (Field3)
  • City (Field4)
  • State (Field5)
  • Zip (Field6)
  • Phone (Field7)

Invoice (Untitled)

  • Invoice (Field5) — Primary key
  • ShipVia (Field)
  • Terms (Field2)
  • Date (Field3)
  • TotalOrderAmt (Field4)
  • Cust (Field6) — Foreign key → Customer.Cust

LineItem (Untitled3)

  • Invoice (Field5) — Foreign key → Invoice.Invoice
  • Prod (Field3) — Foreign key → Product.Prod
  • SellPrice (Field)
  • Quantity (Field2)

Product (Untitled4)

  • Prod (Field) — Primary key
  • Description (Field2)
  • StandardPrice (Field3)