ERD Exercise7(여영규)

테이블 (6)

ABC_CORPORATION (Untitled)

  • Key — 기본 키 — NOT NULL

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