연습문제
테이블 (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)