연습문제

테이블 (4)

Untitled (Invoice)

  • Key (Invoice) — varchar(1000) — 기본 키 — NOT NULL
  • Field (TotalOrderAmt) — int
  • Field (Date) — date
  • Field (Terms) — date
  • Field (ShipVia) — varchar(100)

Untitled (LineItem)

  • SellPrice — int
  • Field (Quantity) — int
  • Key (Invoice) — varchar(1000) — 외래 키 → Untitled.Key — NOT NULL

Untitled2 (Customer)

  • Key (Cust) — int — 기본 키 — NOT NULL
  • Key (Invoice) — varchar(1000) — 외래 키 → Untitled.Key — NOT NULL
  • Field (Cname) — varchar(100)
  • Field (Street) — varchar(100)
  • Field (City) — varchar(100)
  • Field (State) — varchar(100)
  • Field (Zip) — varchar(100)
  • Field (Phone) — int

Untitled3 (Product)

  • Key (Prod) — varchar(100) — 기본 키 — NOT NULL
  • Field (StandardPrice) — int
  • Field (Description) — varchar(1000)