230620

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)