HR "employees" standalone

hr_employees_simple.sql

CREATE TABLE IF NOT EXISTS public.employees_simple
(
    employee_id numeric(6,0) NOT NULL,
    first_name character varying(20),
    last_name character varying(25) NOT NULL,
    email character varying(25) NOT NULL,
    phone_numeric character varying(20),
    hire_date date NOT NULL,
    job_id character varying(10),
    salary numeric(8,2),
    commission_pct numeric(2,2),
    manager_id numeric(6,0),
    department_id numeric(4,0),
    CONSTRAINT emp_simple_emp_id_pk PRIMARY KEY (employee_id),
    CONSTRAINT emp_simple_email_uk UNIQUE (email),
    CONSTRAINT emp_simple_salary_min CHECK (salary > 0::numeric)
);