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