hr

Tables (7)

COUNTRIES (Untitled)

  • COUNTRY_ID (Key) — VARCHAR(2) — Primary key — NOT NULL
  • COUNTRY_NAME (Field) — VARCHAR2(40)
  • REGION_ID — NUMBER(22) — Foreign key → REGIONS.REGION_ID — NOT NULL

DEPARTMENTS (-)

  • DEPARTMENT_ID (Key) — NUMBER(22) — Primary key — NOT NULL
  • DEPARTMENT_NAME (Field) — VARCHAR2(40)
  • LOCATION_ID (Field3) — NUMBER(22)
  • MANAGER_ID (LOCATION_ID) — NUMBER(22) — Foreign key → LOCATIONS.LOCATION_ID — NOT NULL
  • LOCATION_ID (EMPLOYEE_ID) — NUMBER(22) — Foreign key → EMPLOYEES.EMPLOYEE_ID — NOT NULL

EMPLOYEES (Untitled4)

  • EMPLOYEE_ID (Key) — NUMBER(6,0) — Primary key — NOT NULL
  • FIRST_NAME (Field) — VARCHAR2(20 BYTE)
  • LAST_NAME (Field2) — VARCHAR2(30)
  • EMAIL (Field3) — VARCHAR2(30)
  • PHONE_NUMBER (Field4) — VARCHAR2(20 BYTE)
  • HIRE_DATE (Field5) — VARCHAR2(30)
  • JOB_ID — VARCHAR2(10 BYTE) — Foreign key → JOBS.JOB_ID — NOT NULL
  • SALARY (Field7) — VARCHAR2(30)
  • COMMISSION_PCT (Field8) — NUMBER(2,2)
  • MANAGER_ID (EMPLOYEE_ID) — NUMBER(6,0) — Foreign key → EMPLOYEES.EMPLOYEE_ID — NOT NULL
  • DEPARTMENT_ID — NUMBER(4,0) — Foreign key → DEPARTMENTS.DEPARTMENT_ID — NOT NULL

JOBS (Untitled3)

  • JOB_ID (Key) — VARCHAR(2) — Primary key — NOT NULL
  • JOB_TITLE (Field) — VARCHAR2(30)
  • MIN_SALARY (Field2) — NUMBER(6,0)
  • MAX_SALARY (Field3) — NUMBER(6,0)
  • Field4

JOB_HISTORY (Untitled6)

  • START_DATE (Key2) — DATE — Primary key — NOT NULL
  • EMPLOYEE_ID — NUMBER(6) — Foreign key → EMPLOYEES.EMPLOYEE_ID — NOT NULL
  • END_DATE (Field) — DATE
  • JOB_ID — VARCHAR2(10) — Foreign key → JOBS.JOB_ID — NOT NULL
  • DEPARTMENT_ID — NUMBER(4) — Foreign key → DEPARTMENTS.DEPARTMENT_ID — NOT NULL

LOCATIONS (Untitled2)

  • LOCATION_ID (Key) — VARCHAR(2) — Primary key — NOT NULL
  • STREET_ADDRESS (Field) — VARCHAR2(40)
  • POSTAL_CODE (Field2) — VARCHAR2(12)
  • CITY (Field3) — VARCHAR2(30)
  • STATE_PROVINCE (Field4) — VARCHAR2(25)
  • COUNTRY_ID — CHAR(2)(22) — Foreign key → COUNTRIES.COUNTRY_ID — NOT NULL

REGIONS (Untitled5)

  • REGION_ID (Key) — VARCHAR(2) — Primary key — NOT NULL
  • REGION_NAME (Field) — VARCHAR2(25)