Salary Market

use socle;

CREATE TABLE company_reports (

id INT AUTO_INCREMENT PRIMARY KEY,

label VARCHAR(255) NOT NULL,

report_date DATETIME NULL,

description TEXT,

fileUrl TEXT NULL,

companyId INT NOT NULL,

createdAt TIMESTAMP DEFAULT CURRENT_TIMESTAMP,     

updatedAt TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,

FOREIGN KEY (companyId) REFERENCES company(id) ON DELETE CASCADE ON UPDATE CASCADE

);