[다시]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