[다시]ERD 연습문제 5

테이블 (5)

Untitled (supplier)

  • Key (supcode) — char(30) — 기본 키 — NOT NULL
  • Field (supaddress) — char(30)
  • Field (supphone) — int(15)
  • Field (supname) — char(20)

Untitled (customer)

  • Key (ccode) — char(30) — 기본 키 — NOT NULL
  • Field (caddress) — char(30)
  • Field (cname) — char(20)
  • Field (cphone) — int(15)

Untitled (sales)

  • Key (sacode) — char(30) — 기본 키 — NOT NULL
  • Field (sadate) — date
  • Field (saamount) — int(4)
  • Field (safees) — int(3)
  • Key (scode) — char(30) — 외래 키 → shoes.Key — NOT NULL
  • Key (ccode) — char(30) — 외래 키 → Untitled.Key — NOT NULL
  • Key (smcode) — char(30) — 외래 키 → Untitled.Key — NOT NULL

Untitled (salesman)

  • Key (smcode) — char(30) — 기본 키 — NOT NULL
  • Field (successrate) — int(3)
  • Field (smname) — char(20)
  • Field (smphone) — int(15)

shoes

  • Key (scode) — char(30) — 기본 키 — NOT NULL
  • Field (sstyle) — char(30)
  • Field (ssize) — int(3)
  • Field (scolor) — char(30)
  • Field (samount) — int(3)
  • Key (supcode) — char(30) — 외래 키 → Untitled.Key — NOT NULL
  • Field (sprice) — int(10)