ㅇ
Tables (8)
DEPARTMENTS
- DEPARTMENT_ID — NUMBER — Primary key — NOT NULL
- DEPARTMENT_NAME — VARCHAR2
- MANAGER_ID — NUMBER
- LOCATION_ID — NUMBER
EMPLOYEES
- EMPLOYEE_ID — NUMBER — Primary key — NOT NULL
- FIRST_NAME — VARCHAR2
- LAST_NAME — VARCHAR2
- EMAIL — VARCHAR2
- PHONE_NUMBER — VARCHAR2
- HIRE_DATE — DATE
- JOB_ID — VARCHAR2
- SALARY — NUMBER
- COMMISSION_PCT — NUMBER
- MANAGER_ID — NUMBER
- DEPARTMENT_ID — NUMBER — Foreign key → DEPARTMENTS.DEPARTMENT_ID — NOT NULL
JOBS
- JOB_ID — VARCHAR2 — Primary key — NOT NULL
- JOB_TITLE — VARCHAR2
- MIN_SALARY — NUMBER
- MAX_SALARY — NUMBER
JOB_GRADES
- GRADE_LEVEL — VARCHAR2
- LOWEST_SAL — NUMBER
- HIGHEST_SAL — NUMBER
JOB_HISTORY
- START_DATE — DATE — Primary key — NOT NULL
- END_DATE — DATE
- DEPARTMENT_ID — NUMBER — Foreign key → DEPARTMENTS.DEPARTMENT_ID — NOT NULL
- JOB_ID — VARCHAR2 — Foreign key → JOBS.JOB_ID — NOT NULL
- EMPLOYEE_ID — NUMBER — Foreign key → EMPLOYEES.EMPLOYEE_ID — NOT NULL
LOCATIONS
- LOCATION_ID — NUMBER — Primary key — NOT NULL
- STREET_ADDRESS — VARCHAR2
- POSTAL_CODE — VARCHAR2
- CITY — VARCHAR2
- STATE_PROVINCE — VARCHAR2
- COUNTRY_ID — CHAR
REGIONS
- REGION_ID — NUMBER — Primary key — NOT NULL
- REGION_NAME — VARCHAR2
countries
- COUNTRY_ID — CHAR — Primary key — NOT NULL
- COUNTRY_NAME — VARCHAR2
- REGION_ID — NUMBER