HR

Tables (8)

COUNTRIES (Untitled2)

  • COUNTRY_ID (Key) — CHAR2 — Primary key — NOT NULL
  • REGION_ID (REGION_NAME) — NUMBER — Foreign key → REGIONS.REGION_ID — NOT NULL
  • COUNTRY_NAME (Field) — VARCHAR2

DEPARTMENTS (Untitled3)

  • DEPARTMENT_ID (Key) — NUMBER — Primary key — NOT NULL
  • LOCATION_ID (Key2) — NUMBER — Foreign key → LOCATIONS.LOCATION_ID — NOT NULL
  • DEPARTMENT_NAME (Field) — VARCHAR2
  • MANAGER_ID (Field2) — NUMBER

EMPLOYEES (Untitled7)

  • EMPLOYEE_ID (Key) — NUMBER — Primary key — NOT NULL
  • DEPARTMENT_ID (Key2) — NUMBER — Foreign key → DEPARTMENTS.DEPARTMENT_ID — NOT NULL
  • FIRST_NAME (Field) — VARCHAR2
  • LAST_NAME (Field2) — VARCHAR2
  • EMAIL (Field3) — VARCHAR2
  • PHONE_NUMBER (Field4) — VARCHAR2
  • HIRE_DATE (Field5) — DATE
  • JOB_ID (Field6) — VARCHAR2
  • SALARY (Field7) — NUMBER
  • COMMISSION_PCT (Field8) — NUMBER
  • MANAGER_ID (Field9) — NUMBER

JOBS (Untitled5)

  • JOB_ID (Key) — VARCHAR2 — Primary key — NOT NULL
  • JOB_TITLE (Field) — VARCHAR2
  • MIN_SALARY (Field2) — NUMBER
  • MAX_SALARY (Field3) — NUMBER

JOB_HISTORY (Untitled4)

  • EMPLOYEE_ID (Key) — NUMBER — Primary key — NOT NULL
  • DEPARTMENT_ID (Key2) — NUMBER — Foreign key → DEPARTMENTS.DEPARTMENT_ID — NOT NULL
  • START_DATE (Field) — DATE
  • END_DATE (Field2) — DATE
  • JOB_ID (Field3) — VARCHAR2

LOCATIONS (Untitled6)

  • LOCATION_ID (Key) — NUMBER — Primary key — NOT NULL
  • COUNTRY_ID (Key2) — CHAR — Foreign key → COUNTRIES.COUNTRY_ID — NOT NULL
  • STREET_ADDRESS (Field) — VARCHAR2
  • POSTAL_CODE (Field2) — VARCHAR2
  • CITY (Field3) — VARCHAR2
  • STATE_PROVINCE (Field4) — VARCHAR2

REGIONFILES (Untitled8)

  • Key (FILENUM) — NUMBER — Primary key — NOT NULL
  • Key (REGION_ID) — NUMBER — Foreign key → REGIONS.REGION_ID — NOT NULL
  • Field (FILENAME) — VARCHAR2(300)
  • Field (ORINAME) — VARCHAR2(300)

REGIONS (Untitled)

  • REGION_ID (KEY) — NUMBER — Primary key — NOT NULL
  • REGION_NAME (Field) — VARCHAR2