ex_7
Tables (6)
ABC DEVELOPMENT CORP (Untitled)
- CorpId (Key) — char(12) — Primary key — NOT NULL
LOAN (Untitled6)
- LoanId (Key) — char(8) — Primary key — NOT NULL
- ProjectNo (Key2) — char(8) — Foreign key → PROJECT.ProjectNo — NOT NULL
- PMId (Key22) — char(8) — Foreign key → PROJECT.PMId — NOT NULL
- ProjectNo (Key222) — char(8) — Foreign key → PROJECT.ProjectNo — NOT NULL
- numbers (Field) — char(6)
- paymentAmount (Field2) — char(6)
PM (Untitled3)
- PMId (Key) — char(8) — Primary key — NOT NULL
- ProjectNo (Key2) — char(8) — Foreign key → PROJECT.ProjectNo — NOT NULL
- PMId (Key22) — char(8) — Foreign key → PROJECT.PMId — NOT NULL
- ProjectNo (Key222) — char(8) — Foreign key → PROJECT.ProjectNo — NOT NULL
- PMName (Field) — char(4)
PROJECT (Untitled2)
- ProjectNo (Key) — char(8) — Primary key — NOT NULL
- PMId (Key2) — char(8) — Foreign key → PM.PMId — NOT NULL
- ProjectNo (Key22) — char(8) — Foreign key → PM.ProjectNo — NOT NULL
- CorpId (Key3) — char(12) — Foreign key → ABC DEVELOPMENT CORP.CorpId — NOT NULL
SPECIALIZATION (Untitled5)
- SpecialId (Key) — char(8) — Primary key — NOT NULL
- heating (Field) — char(4)
- plumbing (Field2) — char(4)
- SubId (Key2) — char(8) — Foreign key → SUBCONTRACTOR.SubId — NOT NULL
SUBCONTRACTOR (Untitled4)
- SubId (Key) — char(8) — Primary key — NOT NULL
- ProjectNo (Key2) — char(8) — Foreign key → PROJECT.ProjectNo — NOT NULL
- PMId (Key22) — char(8) — Foreign key → PROJECT.PMId — NOT NULL
- ProjectNo (Key222) — char(8) — Foreign key → PROJECT.ProjectNo — NOT NULL
- CorpId (Key3) — char(12) — Foreign key → ABC DEVELOPMENT CORP.CorpId — NOT NULL