ex7

Tables (4)

LOAN (Untitled4)

  • loanNumber (Key) — Primary key — NOT NULL
  • loanAmount (Field)
  • loanPaymentAmount (Field2)

PM (Untitled2)

  • pmNumber (Key) — Primary key — NOT NULL
  • pmName (Key2) — Primary key — NOT NULL

PROJECT (Untitled)

  • projectNumber (Key) — Primary key — NOT NULL
  • pmNumber (Key2) — Foreign key → PM.pmNumber — NOT NULL
  • pmName (Key22) — Foreign key → PM.pmName — NOT NULL
  • loanNumber (Key3) — Foreign key → LOAN.loanNumber — NOT NULL

SUBCONTRACTOR (Untitled3)

  • subNumber (Key) — Primary key — NOT NULL
  • sunSpecialization (Field)
  • projectNumber (Key2) — Foreign key → PROJECT.projectNumber — NOT NULL
  • pmNumber (Key22) — Foreign key → PROJECT.pmNumber — NOT NULL
  • pmName (Key222) — Foreign key → PROJECT.pmName — NOT NULL