kitri

Tables (8)

COUNTRIES

  • COUNTRY_ID — CHAR(2 BYTE) — Primary key — NOT NULL
  • COUNTRY_NAME — VARCHAR2(40 BYTE)
  • REGION_ID — VARCHAR2(40 BYTE) — NOT NULL
  • LOCATION_ID — NUMBER(4,0) — Foreign key → LOCATIONS.LOCATION_ID — NOT NULL

DEPARTMENTS

  • DEPARTMENT_ID — NUMBER(4,0) — Primary key — NOT NULL
  • DEPARTMENT_NAME — NUMBER(4,0)
  • MANAGER_ID — VARCHAR2(40 BYTE)
  • LOCATION_ID — VARCHAR2(40 BYTE) — NOT NULL
  • EMPLOYEE_ID — NUMBER(4,0) — Foreign key → EMPLOYEES.EMPLOYEE_ID — NOT NULL

EMPLOYEES

  • EMPLOYEE_ID — NUMBER(4,0) — Primary key — NOT NULL
  • FIRST_NAME — VARCHAR2(40 BYTE)
  • LAST_NAME — NUMBER(4,0)
  • EMAIL — NUMBER(4,0)
  • PHONE_NUMBER — VARCHAR2(40 BYTE)
  • HIRE_DATE — NUMBER(4,0)
  • JOB_ID — NUMBER(4,0)
  • SALARY — VARCHAR2(40 BYTE)
  • COMMISSION_PCT — VARCHAR2(40 BYTE)
  • MANAGER_ID — VARCHAR2(40 BYTE) — NOT NULL
  • DEPARTMENT_ID — VARCHAR2(40 BYTE) — NOT NULL

JOBS

  • JOB_ID — NUMBER(4,0) — Primary key — NOT NULL
  • EMPLOYEE_ID — NUMBER(4,0) — Foreign key → EMPLOYEES.EMPLOYEE_ID — NOT NULL
  • JOB_TITLE — NUMBER(4,0)
  • MIN_SALARY — VARCHAR2(40 BYTE)
  • MAX_SALARY — VARCHAR2(40 BYTE)

JOB_GRADES

  • LOWEST_SAL — VARCHAR2(40 BYTE)
  • HIGHEST_SAL — VARCHAR2(40 BYTE)
  • GRADE_LEVEL — VARCHAR2(40 BYTE)

JOB_HISTORY

  • EMPLOYEE_ID — NUMBER(4,0) — Foreign key → EMPLOYEES.EMPLOYEE_ID — NOT NULL
  • JOB_ID (JOB_ID3) — NUMBER(4,0) — Foreign key → JOBS.JOB_ID — NOT NULL
  • EMPLOYEE_ID (EMPLOYEE_ID2) — NUMBER(4,0) — Foreign key → JOBS.EMPLOYEE_ID — NOT NULL
  • START_DATE — NUMBER(4,0)
  • END_DATE — NUMBER(4,0)
  • JOB_ID — NUMBER(4,0)
  • DEPARTMENT_ID — VARCHAR2(40 BYTE)
  • JOB_ID2 — NUMBER(4,0) — NOT NULL
  • DEPARTMENT_ID (DEPARTMENT_ID2) — NUMBER(4,0) — Foreign key → DEPARTMENTS.DEPARTMENT_ID — NOT NULL

LOCATIONS

  • LOCATION_ID — NUMBER(4,0) — Primary key — NOT NULL
  • STREET_ADDRESS — VARCHAR2(40 BYTE)
  • POSTAL_CODE — VARCHAR2(12 BYTE)
  • CITY — VARCHAR2(30 BYTE)
  • STATE_PROVINCE — VARCHAR2(25 BYTE)
  • COUNTRY_ID — VARCHAR2(40 BYTE) — NOT NULL
  • DEPARTMENT_ID — NUMBER(4,0) — Foreign key → DEPARTMENTS.DEPARTMENT_ID — NOT NULL

REGIONS

  • REGION_ID — NUMBER — Primary key — NOT NULL
  • REGION_NAME — VARCHAR2(40 BYTE)
  • COUNTRY_ID — CHAR(2 BYTE) — Foreign key → COUNTRIES.COUNTRY_ID — NOT NULL