7
Tables (5)
Customer
- Cust# — Primary key — NOT NULL
- Cname
- Street
- City
- Zip
- Phone
- State
Invoice
- Invoice# — Primary key — NOT NULL
- TotalOrderAmt
- Date
- Terms
- ShipVia
- Cust# — Foreign key → Customer.Cust# — NOT NULL
LineItem
- Invoice# — Foreign key → Invoice.Invoice# — NOT NULL
- Prod# — Foreign key → Product.Prod# — NOT NULL
- SellPrice
- Quantity
Place (Untitled)
Product
- Prod# — Primary key — NOT NULL
- description
- StandardPrice