erd
Tables (8)
COUNTRIES
- COUNTRY_ID — CHAR(2 BYTE) — Primary key — NOT NULL
- COUNTRY_NAME — VARCHAR2(40 BYTE)
- REGION_ID — VARCHAR2(40 BYTE) — NOT NULL
DEPARTMENTS
- DEPARTMENT_ID — NUMBER(4,0) — Primary key — NOT NULL
- DEPARTMENT_NAME — NUMBER(4,0)
- MANAGER_ID — VARCHAR2(40 BYTE)
- LOCATION_ID — VARCHAR2(40 BYTE) — NOT NULL
EMPLOYEES
- EMPLOYEE_ID — NUMBER(4,0) — Primary key — NOT NULL
- FIRST_NAME — VARCHAR2(40 BYTE)
- LAST_NAME — NUMBER(4,0)
- EMAIL — NUMBER(4,0)
- PHONE_NUMBER — VARCHAR2(40 BYTE)
- HIRE_DATE — NUMBER(4,0)
- JOB_ID — NUMBER(4,0)
- SALARY — VARCHAR2(40 BYTE)
- COMMISSION_PCT — VARCHAR2(40 BYTE)
- MANAGER_ID — VARCHAR2(40 BYTE) — NOT NULL
- DEPARTMENT_ID — VARCHAR2(40 BYTE) — NOT NULL
JOBS
- JOB_ID — NUMBER(4,0) — Primary key — NOT NULL
- JOB_TITLE — NUMBER(4,0)
- MIN_SALARY — VARCHAR2(40 BYTE)
- MAX_SALARY — VARCHAR2(40 BYTE)
JOB_GRADES
- LOWEST_SAL — VARCHAR2(40 BYTE)
- HIGHEST_SAL — VARCHAR2(40 BYTE)
- GRADE_LEVEL — VARCHAR2(40 BYTE)
JOB_HISTORY
- EMPLOYEE_ID — NUMBER(4,0) — Foreign key → EMPLOYEES.EMPLOYEE_ID — NOT NULL
- START_DATE — NUMBER(4,0)
- END_DATE — NUMBER(4,0)
- JOB_ID — NUMBER(4,0)
- DEPARTMENT_ID — VARCHAR2(40 BYTE)
- JOB_ID2 — NUMBER(4,0) — NOT NULL
- EMPLOYEE_ID (EMPLOYEE_ID2) — NUMBER(4,0) — Foreign key → JOB_HISTORY.EMPLOYEE_ID — NOT NULL
LOCATIONS
- LOCATION_ID — NUMBER(4,0) — Primary key — NOT NULL
- STREET_ADDRESS — VARCHAR2(40 BYTE)
- POSTAL_CODE — VARCHAR2(12 BYTE)
- CITY — VARCHAR2(30 BYTE)
- STATE_PROVINCE — VARCHAR2(25 BYTE)
- COUNTRY_ID — VARCHAR2(40 BYTE) — NOT NULL
REGIONS
- REGION_ID — NUMBER — Primary key — NOT NULL
- REGION_NAME — VARCHAR2(40 BYTE)