test
Tables (6)
COUNTRY (Untitled5)
- COUNRTY_ID (Key) — Primary key — NOT NULL
DEPARTMENT (Untitled2)
- DEPT_ID (Key) — Primary key — NOT NULL
- LOC_ID (Field)
- LOCATION_ID (Key2) — Foreign key → LOCATION.LOCATION_ID — NOT NULL
EMPLOYEE (Untitled)
- EMP_ID (Key) — Primary key — NOT NULL
- JOB_ID (Key2) — Foreign key → JOB.JOB_ID — NOT NULL
- DEPT_ID (Field)
- DEPT_ID (Key3) — Foreign key → DEPARTMENT.DEPT_ID — NOT NULL
- EMP_ID (Key4) — Foreign key → EMPLOYEE.EMP_ID — NOT NULL
JOB (Untitled3)
- JOB_ID (Key) — Primary key — NOT NULL
LOCATION (Untitled4)
- LOCATION_ID (Key) — Primary key — NOT NULL
- COUNTRY_ID (Field)
- COUNRTY_ID (Key2) — Foreign key → COUNTRY.COUNRTY_ID — NOT NULL
SAL_GRADE
- SLEVEL (Key) — Primary key — NOT NULL