Salary Market

use socle;

CREATE TABLE IF NOT EXISTS company_reports_files (

    report_id INT NOT NULL,

    files_id INT NOT NULL,

    PRIMARY KEY (report_id, files_id),

    FOREIGN KEY (report_id) REFERENCES company_reports(id) ON DELETE CASCADE ON UPDATE CASCADE,

    FOREIGN KEY (files_id) REFERENCES company_files(id) ON DELETE CASCADE ON UPDATE CASCADE

);