ERD Exercise5(여영규)

테이블 (10)

BUY (Untitled3)

  • buyinfoID (Key) — char(10) — 기본 키 — NOT NULL
  • method (Field) — char(4(
  • date (Field2) — date
  • Field3
  • customersId (Key2) — char(10) — 외래 키 → CUSTOMER.customersId — NOT NULL
  • empID — char(10) — 외래 키 → EMPLOYEE.empID — NOT NULL

COLOR

  • colorID (Key) — char(50 — 기본 키 — NOT NULL
  • color (Field) — char(30)
  • RGB (Field2) — char(9)
  • description (Field3) — text
  • Field4

CUSTOMER (고객)

  • customersId (Key) — char(10) — 기본 키 — NOT NULL
  • customersName (Field) — char(10)
  • customersAddress (Field2) — char(30)
  • customersPhone (Field3) — char(10)
  • VIP (Field4) — char(1)

EMPLOYEE (Untitled4)

  • empID — char(10) — 기본 키 — NOT NULL
  • name — char(19)
  • phone (Field) — char(10)

GOAL (Untitled5)

  • goalID (Key) — char(10) — 기본 키 — NOT NULL
  • year (Field) — date
  • month (Field2) — date
  • qty (Field3) — int
  • description (Field4) — text
  • empID — char(10) — 외래 키 → EMPLOYEE.empID — NOT NULL

SALES (Untitled2)

  • salesID (Key) — char(10) — 기본 키 — NOT NULL
  • qty (Field) — int
  • shoesCid (Key3) — char(10) — 외래 키 → SHOES.shoesCid — NOT NULL
  • buyinfoID (Key2) — char(10) — 외래 키 → BUY.buyinfoID — NOT NULL

SHOES (Untitled)

  • shoesCid (Key) — char(10) — 기본 키 — NOT NULL
  • Quantity (Field) — int
  • styleID (Key2) — char(5) — 외래 키 → STYLLE.styleID — NOT NULL
  • sizeID (Key3) — char(5) — 외래 키 → SIZE.sizeID — NOT NULL
  • colorID (Key4) — char(50 — 외래 키 → COLOR.colorID — NOT NULL
  • supID (Key5) — char(10) — 외래 키 → SUPPLIER.supID — NOT NULL

SIZE

  • sizeID (Key) — char(5) — 기본 키 — NOT NULL
  • size (Field) — float
  • USsize (Field2) — float
  • Field3

STYLLE (STYLE)

  • styleID (Key) — char(5) — 기본 키 — NOT NULL
  • Field

SUPPLIER (공급자)

  • supID (Key) — char(10) — 기본 키 — NOT NULL
  • supName (Field) — char(d10)
  • phone (Field2) — char(14)
  • email (Field3) — char(d30)