ERD Exercise 7
Tables (5)
LINEOFWORK (Untitled4)
- codeNUMBER (Key) — char(10) — Primary key — NOT NULL
- project NUMBER (Key2) — char(10) — Foreign key → PROJECT.project NUMBER — NOT NULL
- pmCODE (Key22) — char(10) — Foreign key → PROJECT.pmCODE — NOT NULL
- subcontractorID (Key3) — char(10) — Foreign key → SUBCONTRACTOR.subcontractorID — NOT NULL
LOAN (Untitled5)
- loneCODE (Key) — char(1o) — Primary key — NOT NULL
- project NUMBER (Key2) — char(10) — Foreign key → PROJECT.project NUMBER — NOT NULL
- amount (Field) — char(15)
- paymentamount (Field2) — char(15)
MANAGER (Untitled2)
- pmCODE (Key) — char(10) — Primary key — NOT NULL
- name (Field) — char(15)
- address (Field2) — char(30)
PROJECT (Untitled)
- project NUMBER (Key) — char(10) — Primary key — NOT NULL
- pmCODE (Key2) — char(10) — Foreign key → MANAGER.pmCODE — NOT NULL
- name (Field) — char(15)
- description (Field2) — char(50)
- loneCODE (Key3) — char(1o) — Foreign key → LOAN.loneCODE — NOT NULL
SUBCONTRACTOR (Untitled3)
- subcontractorID (Key) — char(10) — Primary key — NOT NULL
- name (Field) — char(15)
- address (Field3) — char(30)