[다시]ERD 연습문제 7

테이블 (6)

Untitled (pmanager)

  • Key (pmcode) — char(20) — 기본 키 — NOT NULL
  • Field (pmname) — char(20)
  • Field (pmphone) — int(15)
  • Field (pmaddress) — char(20)
  • Field (pmbdate) — date

Untitled (substractor)

  • Key (scode) — char(20) — 기본 키 — NOT NULL
  • Field (ssize) — int(3)
  • Field (sname) — char(20)
  • Field (slike) — int(3)
  • Field (scell) — int(15)
  • Key (spcode) — char(20) — 외래 키 → Untitled.Key — NOT NULL

Untitled (speciality)

  • Key (spcode) — char(20) — 기본 키 — NOT NULL
  • Field (spname) — char(20)
  • Field (spdescription) — text

Untitled (project_substractor)

  • Key (pno) — char(20) — 외래 키 → project.Key — NOT NULL
  • Key (scode) — char(20) — 외래 키 → Untitled.Key — NOT NULL

Untitled (loan)

  • Key (lcode) — char(20) — 기본 키 — NOT NULL
  • Field (lamount) — int(3)
  • Field (lprice) — int(10)
  • Field (lstartdate) — date
  • Field (lfinishdate) — date
  • Field (lender) — char(20)
  • Field (linterest) — char(10)
  • Key (pno) — char(20) — 외래 키 → project.Key — NOT NULL

project

  • Key (pno) — char(20) — 기본 키 — NOT NULL
  • Field (pname) — char(20)
  • Field (pstartdate) — date
  • Key (pmcode) — char(20) — 외래 키 → Untitled.Key — NOT NULL