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)