excercise 7
Tables (5)
familiar subcontractors (Untitled5)
- no (Key) — char(10) — Primary key — NOT NULL
- Field
loans (Untitled4)
- loans no (Key) — char(20) — Primary key — NOT NULL
- quantity (Field) — char(10)
- payment (Field2) — char(10)
- prono (Key2) — char(10) — Foreign key → project.prono — NOT NULL
project (Untitled)
- prono (Key) — char(10) — Primary key — NOT NULL
- managerno (Key2) — char(10) — Foreign key → project manager.managerno — NOT NULL
- no (Key3) — char(10) — Foreign key → familiar subcontractors.no — NOT NULL
project manager (Untitled2)
- managerno (Key) — char(10) — Primary key — NOT NULL
- name (Field) — char(10)
subcontractor (Untitled3)
- one's field (Key) — char(20) — Primary key — NOT NULL
- prono (Key2) — char(10) — Foreign key → project.prono — NOT NULL