test
Tables (6)
COUNTRY (Untitled6)
- COUNTRY_ID (Key) — Primary key — NOT NULL
- COUNTRY_NAME (Field)
DEPARTMENT (Untitled4)
- DEPT_ID (Key) — Primary key — NOT NULL
- DEPT_NAME (Field)
- LOC_ID (Key2) — Foreign key → LOCATION.LOCATION_ID — NOT NULL
EMPLOYEE (Untitled)
- EMP_ID (Key) — Primary key — NOT NULL
- EMP_NAME (Field)
- EMP_NO (Field2)
- EMAIL (Field3)
- PHONE (Field4)
- HIRE_DATE (Field5)
- SALARY (Field7)
- BONUS_PCT (Field8)
- MARRIAGE (Field9)
- DEPT_ID (Key2) — Foreign key → DEPARTMENT.DEPT_ID — NOT NULL
- JOB_ID (Key3) — Foreign key → JOB.JOB_ID — NOT NULL
- MGR_ID (Key4) — Foreign key → EMPLOYEE.EMP_ID — NOT NULL
JOB (Untitled2)
- JOB_ID (Key) — Primary key — NOT NULL
- JOB_TITLE (Field)
- JOB_SAL (Field2)
- MAX_SAL (Field3)
LOCATION (Untitled5)
- LOCATION_ID (Key) — Primary key — NOT NULL
- LOC_DESCRIBE (Field3)
- COUNTRY_ID (Key2) — Foreign key → COUNTRY.COUNTRY_ID — NOT NULL
SAL_GRADE (Untitled3)
- SLEVEL (Key) — Primary key — NOT NULL
- LOWEST (Field)
- HIGHEST (Field2)