ex7

Tables (5)

Projects (Untitled)

  • ProjectsNumber (Key) — Primary key — NOT NULL
  • ProjectsNaum (Field)
  • PM (Key2) — Foreign key → ProjectsManagerPM.PM — NOT NULL

ProjectsManagerPM (Untitled2)

  • PM (Key) — Primary key — NOT NULL
  • employeeNumber (Field)
  • employeeName (Field2)

Specialization (Untitled4)

  • indentifycode (Key) — Primary key — NOT NULL
  • specialName (Field)
  • indentifyNumber (Key2) — Foreign key → Subcontractor.indentifyNumber — NOT NULL

Subcontractor (Untitled5)

  • indentifyNumber (Key) — Primary key — NOT NULL
  • plumbingsubcontractor (Field)
  • subcontractorId (Field2)
  • ProjectsNumber (Key2) — Foreign key → Projects.ProjectsNumber — NOT NULL

loan (Untitled3)

  • indentifyNumber (Key) — Primary key — NOT NULL
  • amount (Field)
  • payment (Field2)
  • ProjectsNumber (Key2) — Foreign key → Projects.ProjectsNumber — NOT NULL