exercise7

Tables (7)

abc-corporation (Untitled)

  • proid (Key2) — Foreign key → project.proid — NOT NULL

loan (Untitled7)

  • loanid (Key) — Primary key — NOT NULL
  • amount (Field)
  • paymentamount (Field2)

project (Untitled2)

  • proid (Key2) — Primary key — NOT NULL
  • id (Key) — Foreign key → projectmanager.id — NOT NULL
  • loanid (Key3) — Foreign key → loan.loanid — NOT NULL

project-subcontractor (Untitled6)

  • proid (Key2) — Foreign key → project.proid — NOT NULL
  • subid (Key) — Foreign key → subcontractor.subid — NOT NULL

projectmanager (Untitled3)

  • id (Key) — Primary key — NOT NULL
  • name (Field)

specializationpart (Untitled5)

  • specode (Key) — Primary key — NOT NULL
  • subid (Key2) — Foreign key → subcontractor.subid — NOT NULL
  • name (Field)

subcontractor (Untitled4)

  • subid (Key) — Primary key — NOT NULL