test
Tables (6)
COUNTRY
- COUNTRY_ID — Primary key
- COUNTRY_NAME — NOT NULL
DEPARTMENT
- DEPT_ID — Primary key
- DEPT_NAME
- LOC_ID — NOT NULL, FK
- LOCATION_ID — Foreign key → LOCATION.LOCATION_ID
EMPLOYEE
- Field (EMP_ID) — Primary key
- EMP_NO — NOT NULL
- EMAIL
- PHONE
- HIRE_DATE
- JOB_ID — FK
- SALARY
- BONUS_PCT
- MARRIAGE — CHECK
- MGR_ID — FK
- DEPT_ID — FK
- DEPT_ID (DEPT_ID2) — Foreign key → DEPARTMENT.DEPT_ID
- JOB_ID (JOB_ID2) — Foreign key → JOB.JOB_ID
- Field (Field2) — Foreign key → EMPLOYEE.Field
JOB
- JOB_ID — Primary key
- JOB_TITLE
- MIN_SAL
- MAX_SAL
LOCATION
- LOCATION_ID — Primary key
- COUNTRY_ID — FK
- LOC_DESCRIBE
- COUNTRY_ID (COUNTRY_ID2) — Foreign key → COUNTRY.COUNTRY_ID
SAL_GRADE
- SLEVEL — Primary key
- LOWEST
- HIGHEST