hr
Tables (8)
COUNTRIES (Untitled7)
- country_id (Key) — Primary key — NOT NULL
- country_name (Field)
- region_id (Key2) — Foreign key → REGIONS.region_id — NOT NULL
DEPARTMENTS (Untitled)
- department_id (Key) — Primary key — NOT NULL
- department_name (Field)
- manager_id (Field2)
- location_id (Key2) — Foreign key → LOCATIONS.location_id — NOT NULL
EMPLOYEES (Untitled2)
- employee_id (Key) — Primary key — NOT NULL
- department_id (Key2) — Foreign key → DEPARTMENTS.department_id — NOT NULL
- job_id (Key3) — Foreign key → JOBS.job_id — NOT NULL
- first_name (Field)
- last_name (Field2)
- email (Field3)
- phone_number (Field4)
- hire_date (Field5)
- salary (Field7)
- commission_pct (Field8)
- manager_id (Field9)
JOBS (Untitled3)
- job_id (Key) — Primary key — NOT NULL
- job_title (Field)
- min_salary (Field2)
- max_salary (Field3)
JOB_GRADES (Untitled5)
- grade_level (Field)
- lowest_sal (Field2)
- highest_sal (Field3)
JOB_HISTORY (Untitled4)
- start_date (Key2) — Primary key — NOT NULL
- job_id (Key3) — Foreign key → JOBS.job_id — NOT NULL
- department_id (Key4) — Foreign key → DEPARTMENTS.department_id — NOT NULL
- employee_id (Key) — Foreign key → EMPLOYEES.employee_id — NOT NULL
- end_date (Field)
LOCATIONS (Untitled6)
- location_id (Key) — Primary key — NOT NULL
- street_address (Field)
- postal_code (Field2)
- city (Field3)
- state_province (Field4)
- country_id (Key2) — Foreign key → COUNTRIES.country_id — NOT NULL
REGIONS (Untitled8)
- region_id (Key) — Primary key — NOT NULL
- region_name (Field)