2023사서교육원_준사서C반_김종우_연습문제1
테이블 (4)
Company (Untitled4)
- Field (companySsn) — 기본 키
Component (Untitled3)
- Key (componentSsn) — 기본 키 — NOT NULL
- Field (componentExplanation) — text — 기본 키
- Key (producerSsn) — 외래 키 → Producer.Key — NOT NULL
- Field (companySsn) — 외래 키 → Company.Field
- Key (productSsn) — 외래 키 → Product.Key — NOT NULL
Producer (Untitled2)
- Key (producerSsn) — 기본 키 — NOT NULL
- Field (producerName)
- Field (producerAddress) — address
- Field (porducerPhoneNumber) — number
Product (Untitled)
- Key (productSsn) — 기본 키 — NOT NULL
- Field (productExplanation) — text
- Field (productPrice) — money
- Field (companySsn) — 외래 키 → Company.Field
- Key (componentSsn) — 외래 키 → Component.Key — NOT NULL
- Field (componentExplanation) — text — 외래 키 → Component.Field