2주차
테이블 (3)
DEPARTMENT (Untitled3)
- depNo (Key) — int — 기본 키 — NOT NULL
- depName (Field) — char
- managerNO (Field2) — int
- producerName (Key2) — char — 외래 키 → PRODUCER.producerName — NOT NULL
PRODUCER (Untitled2)
- producerName (Key) — char — 기본 키 — NOT NULL
- address (Field) — char
- producerNo (Field2) — int
- email (Field3) — char
- depNo (Key2) — int — 외래 키 → DEPARTMENT.depNo — NOT NULL
PRODUCT (Untitled)
- productName (Key) — char — 기본 키 — NOT NULL
- product No (Key2) — int — 기본 키 — NOT NULL
- product Price (Field) — int
- product Description (Field2) — text
- depNo (Key3) — int — 외래 키 → DEPARTMENT.depNo — NOT NULL
- producerName (Key4) — char — 외래 키 → PRODUCER.producerName — NOT NULL