Exe5-006

Tables (7)

Untitled (신발)

  • Key (신발Code) — char(20) — Primary key — NOT NULL
  • Key (공급자ID) — char(20) — Foreign key → Untitled4.Key — NOT NULL
  • Field (이름) — char(20)
  • Field (스타일) — char(20)
  • Field (사이즈) — char(10)
  • Field (색상) — char(10)

Untitled (판매사원)

  • Key (사원ID) — char(10) — Primary key — NOT NULL
  • Field (이름) — char(10)
  • Field (전화) — char(10)
  • Field (직급) — char(10)

Untitled (급여)

  • Key (사원ID) — char(10) — Foreign key → Untitled.Key — NOT NULL
  • Field (판매량) — char(20)
  • Field (수수료) — char(20)
  • Field (영업목표) — char(20)

Untitled2 (판매)

  • Key (판매코드) — Primary key — NOT NULL
  • Field (판매일) — char(10)
  • Field (수량) — char(10)
  • Field (금액) — char(10)
  • Field (결재수단) — char(10)
  • Key (사원ID) — char(10) — Foreign key → Untitled.Key — NOT NULL
  • Key (신발Code) — char(20) — Foreign key → Untitled.Key — NOT NULL
  • Key (고객ID) — char(10) — Foreign key → Untitled5.Key — NOT NULL

Untitled3 (신발정보)

  • Key (사이즈code) — char(20) — Primary key — NOT NULL
  • Key (신발Code) — char(20) — Foreign key → Untitled.Key — NOT NULL
  • Field (재고량) — integer

Untitled4 (공급자)

  • Key (공급자ID) — char(20) — Primary key — NOT NULL
  • Field (이름) — char(20)
  • Field (주소) — char(30)
  • Field (전화) — char(20)
  • Field

Untitled5 (고객)

  • Key (고객ID) — char(10) — Primary key — NOT NULL
  • Field (이름) — char(10)
  • Field (주소) — char(10)
  • Field (전화) — char(10)
  • Field (특이사항) — text