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