Exercise7

Tables (5)

Loan (Untitled5)

  • ID (Key) — char(30) — Primary key — NOT NULL
  • amount (Field) — char(30)
  • payment amount (Field2) — char(30)
  • ID (Key2) — char(30) — Foreign key → Project.ID — NOT NULL

PM (Untitled2)

  • ID (Key) — char(30) — Primary key — NOT NULL
  • Name (Field) — char(30)
  • ID (Key2) — char(30) — Foreign key → Project.ID — NOT NULL
  • ID (Key3) — char(30) — Foreign key → Subcontractor.ID — NOT NULL

Project (Untitled)

  • ID (Key) — char(30) — Primary key — NOT NULL

Specialty (Untitled4)

  • ID (Key) — char(30) — Primary key — NOT NULL
  • ID (Key2) — char(30) — Foreign key → Subcontractor.ID — NOT NULL

Subcontractor (Untitled3)

  • ID (Key) — char(30) — Primary key — NOT NULL