Ex 7
Tables (5)
Associated (Untitled3)
- ProjectID (Key) — Char(20) — Foreign key → Project.ProjectID — NOT NULL
- HeatingID (Key2) — Char(20) — Foreign key → Subcontractor.HeatingID — NOT NULL
- PlumbingID (Key22) — Char(20) — Foreign key → Subcontractor.PlumbingID — NOT NULL
Loan (Untitled5)
- loanID (Key) — Char(20) — Primary key — NOT NULL
- Amount (Field) — Int
- PaymentAmount (Field2) — Int
- ProjectID (Key2) — Char(20) — Foreign key → Project.ProjectID — NOT NULL
PM (Untitled2)
- PMID (Key) — Char(20) — Primary key — NOT NULL
- EmployeNumber (Field) — Int
- Name (Field2) — Char(20)
Project (Untitled)
- ProjectID (Key) — Char(20) — Primary key — NOT NULL
- ProjectInfor1 (Field) — Char(20)
- ProjectInfor2 (Field2) — Char(20)
- PMID (Key2) — Char(20) — Foreign key → PM.PMID — NOT NULL
Subcontractor (Untitled4)
- HeatingID (Key) — Char(20) — Primary key — NOT NULL
- PlumbingID (Key2) — Char(20) — Primary key — NOT NULL