데이터베이스
테이블 (4)
Untitled (Company)
- Key (companyID) — int — 기본 키 — NOT NULL
- Field (companyName) — char
- Field (companyPNumber) — int(11)
- Key (componentNumber) — int — 외래 키 → Untitled.Key — NOT NULL
Untitled (Producer)
- Key (ProducerNumber) — int — 기본 키 — NOT NULL
- Field (producerName) — char
- Field (producerAddress) — char
- Field (producerPNumber) — int((11)
- Key (companyID) — int — 외래 키 → Untitled.Key — NOT NULL
- Key (componentNumber) — int — 외래 키 → Untitled.Key — NOT NULL
Untitled (Component)
- Key (componentNumber) — int — 기본 키 — NOT NULL
- Field (componentExp) — text
- Key (ProducerNumber) — int — 외래 키 → Untitled.Key — NOT NULL
- Key (productNumber) — int — 외래 키 → Untitled2.Key — NOT NULL
Untitled2 (Product)
- Key (productNumber) — int — 기본 키 — NOT NULL
- Field (productExp) — text
- Field (productPrice) — int
- Key (companyID) — int — 외래 키 → Untitled.Key — NOT NULL
- Key (componentNumber) — int — 외래 키 → Untitled.Key — NOT NULL