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