PMSKPI

Tables (4)

PM_DEPT (Untitled3)

  • COMP_ID (Key) — Primary key — NOT NULL
  • DEPT_ID (Key2) — Primary key — NOT NULL

PM_STD_KPI (Untitled2)

  • KPI_YEAR (Key) — Primary key — NOT NULL
  • KPI_CODE (Key2) — Primary key — NOT NULL

PM_STD_KPI_DEPT (Untitled)

  • KPI_YEAR (Key) — Primary key — NOT NULL
  • KPI_DEPT (Key2) — Primary key — NOT NULL
  • Field
  • COMP_ID (Key3) — Foreign key → PM_DEPT.COMP_ID — NOT NULL
  • DEPT_ID (Key22) — Foreign key → PM_DEPT.DEPT_ID — NOT NULL
  • KPI_YEAR (Key4) — Foreign key → PM_STD_KPI.KPI_YEAR — NOT NULL
  • KPI_CODE (Key23) — Foreign key → PM_STD_KPI.KPI_CODE — NOT NULL

Untitled4