HR

Tables (7)

Untitled (JOB_HISTORY)

  • Key (EMPLOYEE_ID) — Primary key — NOT NULL
  • Key2 (START_DATE) — Primary key — NOT NULL
  • Field (END_DATE)
  • Field2 (JOB_ID)
  • Field3 (DEPARTMENT_ID)

Untitled (JOBS)

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

Untitled (EMPLOYEES)

  • Key (EMPLOYEE_ID) — Primary key — NOT NULL
  • Field (FIRST_NAME)
  • Field2 (LAST_NAME)
  • Field3 (EMAIL)
  • Field4 (PHONE_NUMBER)
  • Field5 (HIRE_DATE)
  • Field6 (JOB_ID)
  • Field7 (SALARY)
  • Field8 (COMMISSION_PCT)
  • Field9 (MANAGER_ID)
  • Field10 (DEPARTMENT_ID)

Untitled (DEPARTMENTS)

  • Key (DEPARTMENT_ID) — Primary key — NOT NULL
  • Field (DEPARTMENT_NAME)
  • Field2 (MANAGER_ID)
  • Field3 (LOCATION_ID)

Untitled (LOCATIONS)

  • Key (LOCATION_ID) — Primary key — NOT NULL
  • Field (STREET_ADDRESS)
  • Field2 (POSTAL_CODE)
  • Field3 (CITY)
  • Field4 (STATE_PROVINCE)
  • Field5 (COUNTRY_ID)

Untitled (COUNTRIES)

  • Key (COUNTRY_ID) — Primary key — NOT NULL
  • Field (COUNTRY_NAME)
  • Field2 (REGION_ID)

Untitled (REGIONS)

  • Key (REGION_ID) — Primary key — NOT NULL
  • Field (REGION_NAME)