ex7
Tables (4)
LOAN (Untitled4)
- loanNumber (Key) — Primary key — NOT NULL
- loanAmount (Field)
- loanPaymentAmount (Field2)
PM (Untitled2)
- pmNumber (Key) — Primary key — NOT NULL
- pmName (Key2) — Primary key — NOT NULL
PROJECT (Untitled)
- projectNumber (Key) — Primary key — NOT NULL
- pmNumber (Key2) — Foreign key → PM.pmNumber — NOT NULL
- pmName (Key22) — Foreign key → PM.pmName — NOT NULL
- loanNumber (Key3) — Foreign key → LOAN.loanNumber — NOT NULL
SUBCONTRACTOR (Untitled3)
- subNumber (Key) — Primary key — NOT NULL
- sunSpecialization (Field)
- projectNumber (Key2) — Foreign key → PROJECT.projectNumber — NOT NULL
- pmNumber (Key22) — Foreign key → PROJECT.pmNumber — NOT NULL
- pmName (Key222) — Foreign key → PROJECT.pmName — NOT NULL