CREATE TABLE IF NOT EXISTS company (
    id INT NOT NULL PRIMARY KEY AUTO_INCREMENT,
    name VARCHAR (250) NOT NULL
);

CREATE TABLE IF NOT EXISTS employee (
    id INT NOT NULL PRIMARY KEY AUTO_INCREMENT,
    name VARCHAR (250),
    company_id INT,
    FOREIGN KEY (company_id) REFERENCES Company (id)
);

CREATE TABLE IF NOT EXISTS company_employee (
    company_id INT NOT NULL,
    employee_id INT NOT NULL,
    hire_date DATE,
    resign_date DATE,
    FOREIGN KEY (company_id) REFERENCES Company (id),
    FOREIGN KEY (employee_id) REFERENCES Employee (id)
);