연습
테이블 (3)
component (PRODUCT)
- identification number (prdtNo) — int — 기본 키 — NOT NULL
- identification number (cpinpdNo) — int — 외래 키 → product.identification number — NOT NULL
- explanation (prdtName) — char(20)
- price (prdtExpln) — char(30)
- identification number (Key2) — 외래 키 → producer.identification number — NOT NULL
producer (PRODUCER)
- identification number (prdcNo) — 기본 키 — NOT NULL
- name (prdcName) — char(20)
- domicile (address) — chat(30)
- identification number (Key2) — int — 외래 키 → component.identification number — NOT NULL
- identification number (cpinpdNo) — int — 외래 키 → component.identification number — NOT NULL
product (COMPINPRODUCT)
- identification number (cpinpdNo) — int — 기본 키 — NOT NULL
- explanation (compAmount) — int
- Field (prdtNo)