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