연습문제 3 교수님

테이블 (3)

Untitled (serviceprovider)

  • Key (providerID) — int(100) — 기본 키 — NOT NULL
  • Field (name) — char(100)
  • Field (phone) — int(12)
  • Field (grade) — float(3)
  • Field (memo) — longtext
  • Field (type) — char(10)

Untitled (dependant)

  • Key (dependentID) — int(5) — 기본 키 — NOT NULL
  • Field (name) — char(10)
  • Field (phone) — int(11)
  • Field (clientid) — int(5)
  • Field (ssn) — clar(15)

Untitled (enroll/client_service)

  • Key (enrollID) — 기본 키 — NOT NULL