econrich
Tables (7)
countries (Untitled)
- country_id (Key) — String — Primary key — NOT NULL
- country_name (Field) — String
- region_id (Key2) — Long — Foreign key → regions.region_id — NOT NULL
departments (Untitled5)
- department_id (Key) — Long — Primary key — NOT NULL
- department_name (Field) — String
- manager_id (Key3) — Long — Foreign key → employees.employee_id — NOT NULL
- location_id (Key2) — Long — Foreign key → locations.location_id — NOT NULL
employees (Untitled4)
- employee_id (Key) — Long — Primary key — NOT NULL
- manager_id (Key2) — Long — Foreign key → employees.employee_id — NOT NULL
- first_name (Field) — String
- last_name (Field2) — String
- email (Field3) — String
- phone_number (Field4) — String
- hire_date (Field5) — Date
- salary (Field6) — Long
- commission_pct (Field7) — Long
- job_id (Key3) — String — Foreign key → jobs.job_id — NOT NULL
- department_id (Key4) — Long — Foreign key → departments.department_id — NOT NULL
job_history (Untitled7)
- start_date (Key2) — Date — Primary key — NOT NULL
- employee_id (Key) — Long — Foreign key → employees.employee_id — NOT NULL
- end_date (Field2) — Date
- job_id (Key3) — String — Foreign key → jobs.job_id — NOT NULL
- department_id (Key4) — Long — Foreign key → departments.department_id — NOT NULL
jobs (Untitled2)
- job_id (Key) — String — Primary key — NOT NULL
- job_title (Field) — String
- min_salary (Field2) — Long
- max_salary (Field3) — Long
locations (Untitled6)
- location_id (Key) — Long — Primary key — NOT NULL
- street_address (Field) — String
- postal_code (Field2) — String
- city (Field3) — String
- state_province (Field4) — String
- country_id (Key2) — String — Foreign key → countries.country_id — NOT NULL
regions (Untitled3)
- region_id (Key) — Long — Primary key — NOT NULL
- region_name (Field) — String