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)