ERD 7

Tables (5)

Loans (Untitled3)

  • ID (Key) — Primary key — NOT NULL
  • Quantity (Field)
  • Amount (Field2)
  • ID (Key2) — Foreign key → Project.ID — NOT NULL

PM (Untitled5)

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

Project (Untitled2)

  • ID (Key) — Primary key — NOT NULL
  • PM (Field)
  • Worker (Field2)
  • ID (Key2) — Foreign key → company.ID — NOT NULL
  • ID (Key3) — Foreign key → PM.ID — NOT NULL
  • ID (Key4) — Foreign key → subcontractor.ID — NOT NULL

company (Untitled)

  • ID (Key) — Primary key — NOT NULL
  • ProjectID (Field)
  • Field2

subcontractor (Untitled4)

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