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