5주차
테이블 (6)
COMPANY
- Key (compID) — int(15) — 기본 키 — NOT NULL
- Field (compName) — char(15)
- Field (compAddress) — char(15)
- Field (pdtcompPH) — int(12)
COMPONENT
- Key (compoID) — int(15) — 기본 키 — NOT NULL
- Field (compoExpianation) — long text
- Field (compoName) — char(30)
- Field (compomodelName) — char(20)
- Key (categoryID) — int(10) — 외래 키 → COMPONENT CATEGORY.Key — NOT NULL
- Key (prodID) — int(15) — 외래 키 → PRODUCTOR.Key — NOT NULL
COMPONENT CATEGORY (.)
- Key (categoryID) — int(10) — 기본 키 — NOT NULL
- Field (categoryName) — char(20)
MAKE
- Key (prdNumber) — int(15) — 외래 키 → PRODUCT.Key — NOT NULL
- Key (compoID) — int(15) — 외래 키 → COMPONENT.Key — NOT NULL
- Field (amount) — int
PRODUCT
- Key (prdNumber) — int(15) — 기본 키 — NOT NULL
- Field (prdtExpianation) — text
- Field (prdtPrice) — int
- Field (prdtName) — char(30)
- Field (prdtmodelName) — char(30)
PRODUCTOR
- Key (prodID) — int(15) — 기본 키 — NOT NULL
- Field (prodName) — char(15)
- Field (prodAddress) — char(15)
- Field (prodPH) — int(12)
- Field (prodEmail) — char(30)
- Field (prodExpianation) — long text