HR
Tables (7)
COUNTRIES
- COUNTRY ID (COUNTRY_ID) — CHAR(2) — Primary key — NOT NULL
- COUNTRY NAME (COUNTRY_NAME) — VARCHAR2(40)
- REGIONS ID (REGIONS_ID) — NUMBER — Foreign key → REGIONS.REGIONS ID
DEPARTMENTS
- DEPARTMENT ID (DEPARTMENT_ID) — NUMBER(4) — Primary key — NOT NULL
- DEPARTMENT NAME (DEPARTMENT_NAME) — VARCHAR2(30) — NOT NULL
- LOCATION ID (LOCATION_ID) — NUMVER(4) — Foreign key → LOCATIONS.LOCATION ID
- EMPLOYEE ID (EMPLOYEE_ID) — NUMBER(6) — Foreign key → EMPLOYEES.EMPLOYEE ID
EMPLOYEES
- EMPLOYEE ID (EMPLOYEE_ID) — NUMBER(6) — Primary key — NOT NULL
- JOB ID (JOB_ID) — VARCHAR2(10) — Foreign key → JOBS.JOB ID — NOT NULL
- FIRST NAME (FIRST_NAME) — VARCHAR(20)
- LAST NAME (LAST_NAME) — VARCHAR2(25) — NOT NULL
- EMAIL — VARCHAR2(25) — NOT NULL
- PHONE NUMBER (PHONE_NUMBER) — VARCHAR2(20)
- HIRE DATE (HIRE_DATE) — DATE — NOT NULL
- SALARY — NUMBER(8,2)
- COMMISSION PCT (COMMISSION_PCT) — NUMBER(2,2)
- DEPARTMENT ID (DEPARTMENT_ID) — NUMBER(4) — Foreign key → DEPARTMENTS.DEPARTMENT ID
JOBS
- JOB ID (JOB_ID) — VARCHAR2(10) — Primary key — NOT NULL
- JOB TITLE (JOB_TITLE) — VARCHAR2(35) — NOT NULL
- MIN SALARY (MIN_SALARY) — NUMBER(6)
- MAX SALARY (MAX_SALARY) — NUMBER(6)
JOB_HISTORY
- START DATE — DATE — Primary key — NOT NULL
- EMPLOYEE ID (EMPLOYEE_ID) — NUMBER(6) — Foreign key → EMPLOYEES.EMPLOYEE ID — NOT NULL
- JOB ID (JOB_ID) — VARCHAR2(10) — Foreign key → JOBS.JOB ID — NOT NULL
- END DATE (END_DATE) — DATE — NOT NULL
- DEPARTMENT ID (DEPARTMENT_ID) — NUMBER(4) — Foreign key → DEPARTMENTS.DEPARTMENT ID
- Field
LOCATIONS
- LOCATION ID (LOCATION_ID) — NUMVER(4) — Primary key — NOT NULL
- STREET ADDRESS (STREET_ADDRESS) — VARCHAR2(40)
- POSTAL CODE (POSTAL_CODE) — VARCHAR2(12)
- CITY — VARCHAR2(30) — NOT NULL
- STATE PROVINCE (STATE_PROVINCE) — VARCHAR2(25)
- COUNTRY ID (COUNTRY_ID) — CHAR(2) — Foreign key → COUNTRIES.COUNTRY ID
REGIONS
- REGIONS ID (REGIONS_ID) — NUMBER — Primary key — NOT NULL
- REGION NAME (REGION_NAME) — VARCHAR2(25)