EMPLOYEE
Tables (6)
Untitled (JOB)
- EMP_ID (JOB_ID) — Primary key — NOT NULL
- Field (JOB_TITLE)
- Field2 (MIN_SAL)
- Field3 (MAX_SAL)
Untitled (EMPLOYEE)
- EMP_ID — Primary key — NOT NULL
- Field (EMP_NAME)
- Field2 (EMP_NO)
- Field3 (EMAIL)
- Field4 (PHONE)
- EMP_ID (JOB_ID) — Foreign key → Untitled.EMP_ID — NOT NULL
- Field5 (HIRE_DATE)
- Field2 (SALARY)
- Field3 (BONUS_PCT)
- Field4 (MGR_ID)
- Key (DEPT_ID) — Foreign key → Untitled.Key — NOT NULL
Untitled (DEPARTMENT)
- Key (DEPT_ID) — Primary key — NOT NULL
- Key (LOC_ID) — Foreign key → Untitled.Key — NOT NULL
- Field (DEPT_NAME)
Untitled (LOCATION)
- Key (LOCATION_ID) — Primary key — NOT NULL
- Key (COUNTRY_ID) — Foreign key → Untitled.Key — NOT NULL
- Field (LOC_DESCRIBE)
Untitled (COUNTRY)
- Key (COUNTRIY_ID) — Primary key — NOT NULL
- Field (COUNTRY_NAME)
Untitled2 (SAL_GRADE)
- Key (SLEVEL) — Primary key — NOT NULL
- Field (LOWEST)
- Field2 (HIGHEST)