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