ex7
Tables (4)
LOAN (Untitled4)
- loanID (Key) — char(10) — Primary key — NOT NULL
- amount (Field) — char(10)
- paymentAmount (Field2) — char(10)
- projectNo (Key2) — char(10) — Foreign key → PROJECT.projectNo — NOT NULL
MANAGER (Untitled2)
- managerID (Key) — char(10) — Primary key — NOT NULL
- managerPhone (Field) — char(10)
- managerAddress (Field2) — char(20)
PROJECT (Untitled)
- projectNo (Key) — char(10) — Primary key — NOT NULL
- projectCode (Field) — char(10)
- projectName (Field2) — char(10)
- projectDate (Field3)
- ID (Key2) — char(10) — Foreign key → SUBCONTRACTOR.ID — NOT NULL
- managerID (Key3) — char(10) — Foreign key → MANAGER.managerID — NOT NULL
SUBCONTRACTOR (Untitled3)
- ID (Key) — char(10) — Primary key — NOT NULL
- No (Field) — char(10)
- lineOfWork (Field2) — char(10)
- managerID (Key2) — char(10) — Foreign key → MANAGER.managerID — NOT NULL