hr
Tables (7)
COUNTRIES
- COUNTRY_ID — CHAR(2) — Primary key — NOT NULL
- COUNTRY_NAME — VARCHAR2(40)
- REGION_ID — NUMBER — Foreign key → REGIONS.REGION_ID
DEPARTMENTS
- DEPARTMENT_ID — NUMBER(4,0)
- DEPARTMENT_NAME — VARCHAR2(30) — NOT NULL
- MANAGER_ID — NUMBER(6,0) — Foreign key → EMPLOYEES.EMPLOYEE_ID
- LOCATION_ID — NUMBER(4,0) — Foreign key → LOCATIONS.LOCATION_ID
EMPLOYEES
- EMPLOYEE_ID — NUMBER(6,0)
- FIRST_NAME — VARCHAR2(20)
- LAST_NAME — VARCHAR2(25) — NOT NULL
- EMAIL — VARCHAR2(25) — NOT NULL
- PHONE_NUMBER — VARCHAR2(20)
- HIRE_DATE — DATE — NOT NULL
- JOB_ID — VARCHAR2(10) — Foreign key → JOBS.JOB_ID — NOT NULL
- SALARY — NUMBER(8,2)
- COMMISSION_PCT — NUMBER(2,2)
- MANAGER_ID — NUMBER(6,0) — Foreign key → EMPLOYEES.EMPLOYEE_ID
- DEPARTMENT_ID — NUMBER(4,0) — Foreign key → DEPARTMENTS.DEPARTMENT_ID
JOBS
- JOB_ID — VARCHAR2(10)
- JOB_TITLE — VARCHAR2(35) — NOT NULL
- MIN_SALARY — NUMBER(6,0)
- MAX_SALARY — NUMBER(6,0)
JOB_HISTORY
- START_DATE — DATE — Primary key — NOT NULL
- EMPLOYEE_ID — NUMBER(6,0) — Foreign key → EMPLOYEES.EMPLOYEE_ID — NOT NULL
- END_DATE — DATE — NOT NULL
- JOB_ID — VARCHAR2(10) — Foreign key → JOBS.JOB_ID — NOT NULL
- DEPARTMENT_ID — NUMBER(4,0) — Foreign key → DEPARTMENTS.DEPARTMENT_ID
LOCATIONS
- LOCATION_ID — NUMBER(4,0)
- STREET_ADDRESS — VARCHAR2(40)
- POSTAL_CODE — VARCHAR2(12)
- CITY — VARCHAR2(30) — NOT NULL
- STATE_PROVINCE — VARCHAR2(25)
- COUNTRY_ID — CHAR(2) — Foreign key → COUNTRIES.COUNTRY_ID
REGIONS
- REGION_ID — NUMBER — Primary key — NOT NULL
- REGION_NAME — VARCHAR2(25)