exercise 5 모범

테이블 (5)

BUY (Untitled3)

  • buyID (Key) — char(10) — 기본 키 — NOT NULL
  • method (Field) — char(4)
  • date (Field2) — date
  • customerID (Field3) — char(20)
  • empID (Key2) — char(5) — 외래 키 → EMPLOYEE.empID — NOT NULL
  • customerID (Key3) — char(20) — 외래 키 → CUSTOMER.customerID — NOT NULL

CUSTOMER (Untitled2)

  • customerID (Key) — char(20) — 기본 키 — NOT NULL
  • name (Field) — char(30)
  • phoe (Field2) — char(10)
  • VIP (Field3) — char(1)

EMPLOYEE (Untitled4)

  • empID (Key) — char(5) — 기본 키 — NOT NULL
  • name (Field) — char(30)
  • phone (Field2) — char(14)

SALE (Untitled5)

  • saleID (Key) — char(100) — 기본 키 — NOT NULL
  • qty (Field) — int
  • buyID (Key2) — char(10) — 외래 키 → BUY.buyID — NOT NULL

SUPPLIER (Untitled)