연습5

테이블 (5)

customer (Untitled3)

  • cusID (Key) — 기본 키 — NOT NULL
  • name (Field)
  • address (Field2)
  • phone (Field3)

producer (Untitled2)

  • proID (Key) — 기본 키 — NOT NULL
  • address (Field)
  • phone (Field2)
  • name (Field3)

sale (Untitled5)

  • shoID (Key) — 외래 키 → shoes.shoID — NOT NULL
  • employeeNo (Key3) — 외래 키 → salesperson.employeeNo — NOT NULL
  • cusID (Key2) — 외래 키 → customer.cusID — NOT NULL
  • purchaseDATE (Field)
  • quantity (Field2)
  • paymentTYPE (Field3)

salesperson (Untitled4)

  • employeeNo (Key) — 기본 키 — NOT NULL
  • sales rate (Field)

shoes (Untitled)

  • shoID (Key) — 기본 키 — NOT NULL
  • style (Field)
  • size (Field2)
  • color (Field3)
  • proID (Key2) — 외래 키 → producer.proID — NOT NULL
  • stock (Field4)