ERD Exercise7(여영규)
테이블 (6)
ABC_CORPORATION (Untitled)
LOAN (Untitled6)
- loanID (Key) — char(10) — 기본 키 — NOT NULL
- loanAmount (Field) — char(10)
- loanPaymentamount (Field2) — char(10)
- projectNumber (Key2) — char(10) — 외래 키 → PROJECT.projectNumber — NOT NULL
- loanID (Key4) — char(10) — 외래 키 → PROJECT.loanID — NOT NULL
PROJECT (Untitled2)
- projectNumber (Key) — char(10) — 기본 키 — NOT NULL
- loanID (Key4) — char(10) — 외래 키 → LOAN.loanID — NOT NULL
- PMID (Key2) — char(10) — 외래 키 → PROJECT_MANAGER.PMID — NOT NULL
- Key (Key3) — 외래 키 → ABC_CORPORATION.Key — NOT NULL
PROJECT_MANAGER (Untitled3)
- PMID (Key) — char(10) — 기본 키 — NOT NULL
- PMName (Field) — char(20)
SPECIALIZATIONPART (Untitled5)
- specializedUniquecode (Key) — char(20) — 기본 키 — NOT NULL
- subcontractorID (Key2) — char(10) — 외래 키 → SUBCONTRACTOR.subcontractorID — NOT NULL
- loanID (Key4) — char(10) — 외래 키 → SUBCONTRACTOR.loanID — NOT NULL
SUBCONTRACTOR (Untitled4)
- subcontractorID (Key) — char(10) — 기본 키 — NOT NULL
- subcontractorName (Field) — char(20)
- Field2
- Key (Key2) — 외래 키 → ABC_CORPORATION.Key — NOT NULL
- projectNumber (Key3) — char(10) — 외래 키 → PROJECT.projectNumber — NOT NULL
- loanID (Key4) — char(10) — 외래 키 → PROJECT.loanID — NOT NULL