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)