ㅇ

Tables (8)

DEPARTMENTS

  • DEPARTMENT_ID — NUMBER — Primary key — NOT NULL
  • DEPARTMENT_NAME — VARCHAR2
  • MANAGER_ID — NUMBER
  • LOCATION_ID — NUMBER

EMPLOYEES

  • EMPLOYEE_ID — NUMBER — Primary key — NOT NULL
  • FIRST_NAME — VARCHAR2
  • LAST_NAME — VARCHAR2
  • EMAIL — VARCHAR2
  • PHONE_NUMBER — VARCHAR2
  • HIRE_DATE — DATE
  • JOB_ID — VARCHAR2
  • SALARY — NUMBER
  • COMMISSION_PCT — NUMBER
  • MANAGER_ID — NUMBER
  • DEPARTMENT_ID — NUMBER — Foreign key → DEPARTMENTS.DEPARTMENT_ID — NOT NULL

JOBS

  • JOB_ID — VARCHAR2 — Primary key — NOT NULL
  • JOB_TITLE — VARCHAR2
  • MIN_SALARY — NUMBER
  • MAX_SALARY — NUMBER

JOB_GRADES

  • GRADE_LEVEL — VARCHAR2
  • LOWEST_SAL — NUMBER
  • HIGHEST_SAL — NUMBER

JOB_HISTORY

  • START_DATE — DATE — Primary key — NOT NULL
  • END_DATE — DATE
  • DEPARTMENT_ID — NUMBER — Foreign key → DEPARTMENTS.DEPARTMENT_ID — NOT NULL
  • JOB_ID — VARCHAR2 — Foreign key → JOBS.JOB_ID — NOT NULL
  • EMPLOYEE_ID — NUMBER — Foreign key → EMPLOYEES.EMPLOYEE_ID — NOT NULL

LOCATIONS

  • LOCATION_ID — NUMBER — Primary key — NOT NULL
  • STREET_ADDRESS — VARCHAR2
  • POSTAL_CODE — VARCHAR2
  • CITY — VARCHAR2
  • STATE_PROVINCE — VARCHAR2
  • COUNTRY_ID — CHAR

REGIONS

  • REGION_ID — NUMBER — Primary key — NOT NULL
  • REGION_NAME — VARCHAR2

countries

  • COUNTRY_ID — CHAR — Primary key — NOT NULL
  • COUNTRY_NAME — VARCHAR2
  • REGION_ID — NUMBER