ex_7
Tables (5)
FINANCE (Untitled5)
- finance number (Field) — char(10) — Primary key
- payment amount (Field2) — char(30)
- payment infomation (Field3) — char(50)
- project number (Key) — char(10) — Foreign key → PROJECT.project number — NOT NULL
PROJECT (Untitled)
- project number (Key) — char(10) — Primary key — NOT NULL
- PM number (Key2) — char(10) — Foreign key → PROJECT MANAGER.PM number — NOT NULL
PROJECT MANAGER (Untitled2)
- PM number (Key) — char(10) — Primary key — NOT NULL
- PM name (Field) — char(30)
- PM infomation (Field2) — char(50)
SPECIALIZATION (Untitled4)
- SP code (Key) — char(10) — Primary key — NOT NULL
- SC number (Key2) — char(10) — Foreign key → SUBCONTRACTOR.SC number — NOT NULL
- SP infomation (Field) — char(50)
SUBCONTRACTOR (Untitled3)
- SC number (Key) — char(10) — Primary key — NOT NULL
- SC work (Field) — char(30)
- sc infomation (Field2) — char(50)
- project number (Key2) — char(10) — Foreign key → PROJECT.project number — NOT NULL