HR

Tables (5)

COUNTRIES (Untitled2)

  • COUNTRY_ID (Key) — Primary key — NOT NULL
  • RESION_ID (Key2) — Foreign key → RESIONS.RESION_ID — NOT NULL
  • COUNTRY_NAME (Field)

DEPARTMENTS (Untitled3)

  • DEPARTMENT_ID (Key) — Primary key — NOT NULL
  • LOCATION_ID (Key2) — Foreign key → LOCATIONS.LOCATION_ID — NOT NULL
  • COUNTRY_ID (Key22) — Foreign key → LOCATIONS.COUNTRY_ID — NOT NULL
  • RESION_ID (Key222) — Foreign key → LOCATIONS.RESION_ID — NOT NULL
  • DEPARTMENT_NAME (Field)
  • MANAGER_ID (Field2)

EMPLOYEES (Untitled5)

  • EMPLOYEE_ID (Key) — Primary key — NOT NULL
  • DEPARTMENT_ID (Key2) — Foreign key → DEPARTMENTS.DEPARTMENT_ID — NOT NULL
  • LOCATION_ID (Key22) — Foreign key → DEPARTMENTS.LOCATION_ID — NOT NULL
  • COUNTRY_ID (Key222) — Foreign key → DEPARTMENTS.COUNTRY_ID — NOT NULL
  • RESION_ID (Key2222) — Foreign key → DEPARTMENTS.RESION_ID — NOT NULL
  • FIRST_NAME (Field)
  • LAST_NAME (Field2)
  • EMAIL (Field3)
  • PHONE_NUMBER (Field4)
  • HIRE_DATE (Field5)
  • JOB_ID (Field6)
  • SALARY (Field7)
  • MANAGER_ID (Field8)

LOCATIONS (Untitled4)

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

RESIONS (Untitled)

  • RESION_ID (Key) — Primary key — NOT NULL
  • RESION_NAME (Field)