과제
테이블 (4)
Untitled (Supplier)
- Key (SuppilerID) — char — 기본 키 — NOT NULL
- Field (name) — char
- Field (address) — char
- Field (phonenumber) — char
Untitled (Part)
- Key (PartID) — char — 기본 키 — NOT NULL
- Field (partModelNumber) — char
- Field (describe) — char
- Key (SuppilerID) — char — 외래 키 → Untitled.Key — NOT NULL
Untitled (Product_Part)
- Key (ProductID) — char — 외래 키 → Untitled2.Key — NOT NULL
- Key (PartID) — char — 외래 키 → Untitled.Key — NOT NULL
- Field (Quantity) — int
Untitled2 (Product)
- Key (ProductID) — char — 기본 키 — NOT NULL
- Field (productName) — char
- Field (descreibe) — text
- Field (price) — int