exercise7
Tables (7)
abc-corporation (Untitled)
- proid (Key2) — Foreign key → project.proid — NOT NULL
loan (Untitled7)
- loanid (Key) — Primary key — NOT NULL
- amount (Field)
- paymentamount (Field2)
project (Untitled2)
- proid (Key2) — Primary key — NOT NULL
- id (Key) — Foreign key → projectmanager.id — NOT NULL
- loanid (Key3) — Foreign key → loan.loanid — NOT NULL
project-subcontractor (Untitled6)
- proid (Key2) — Foreign key → project.proid — NOT NULL
- subid (Key) — Foreign key → subcontractor.subid — NOT NULL
projectmanager (Untitled3)
- id (Key) — Primary key — NOT NULL
- name (Field)
specializationpart (Untitled5)
- specode (Key) — Primary key — NOT NULL
- subid (Key2) — Foreign key → subcontractor.subid — NOT NULL
- name (Field)
subcontractor (Untitled4)
- subid (Key) — Primary key — NOT NULL