주문

테이블 (3)

Customer (Untitled2)

  • Key (Cust) — 기본 키 — NOT NULL
  • Key (Invoice) — 외래 키 → lnvoice.Key — NOT NULL
  • Field (Cname)
  • Field (Street)
  • Field (City)
  • Field (Zip)
  • Field (State)
  • Field (Phone)
  • Key (Prod) — 외래 키 → Product.Key — NOT NULL
  • Key (Invoice2) — 외래 키 → Product.Key — NOT NULL

Product (Untitled3)

  • Key (Prod) — 기본 키 — NOT NULL
  • Key (Invoice) — 외래 키 → lnvoice.Key — NOT NULL
  • Field (Description)
  • Field (StandarPrice)

lnvoice (Untitled)

  • Key (Invoice) — 기본 키 — NOT NULL
  • Field (Date)
  • Field (Tems)
  • Field2 (TotalOrderAmt)
  • Field3 (ShipVia)