ERD 연습문제 7
테이블 (6)
Untitled (project)
- Key (pno) — char(10) — 기본 키 — NOT NULL
- Field (pname) — char(10)
- Key (pmno) — char(20) — 외래 키 → Untitled.Key — NOT NULL
- Field (pDescription) — text
Untitled (pmanager)
- Key (pmno) — char(10) — 기본 키 — NOT NULL
- Field (pmName) — char(4)
- Field (pmCell) — int(10)
- Field (pmAddress) — char(20)
Untitled (subcontractor)
- Key (sno) — char(10) — 기본 키 — NOT NULL
- Field (sname) — char(10)
- Field (sfriendly) — int(2)
- Key (spCode) — char(10) — 외래 키 → Untitled.Key — NOT NULL
- Field (sAbility) — int(2)
Untitled (project_subcontractor)
- Key (pno) — char(10) — 외래 키 → Untitled.Key — NOT NULL
- Key (sno) — char(10) — 외래 키 → Untitled.Key — NOT NULL
Untitled (specialty)
- Key (spCode) — char(10) — 기본 키 — NOT NULL
- Field (spName) — char(20)
- Field (spDescription) — text
Untitled (loan)
- Key (lcode) — char(10) — 기본 키 — NOT NULL
- Field (lamount) — int(3)
- Field (lprice) — int
- Key (pno) — char(10) — 외래 키 → Untitled.Key — NOT NULL