Salary Market

CREATE TABLE company_reports (

  id INT AUTO_INCREMENT PRIMARY KEY,

  label VARCHAR(255) NOT NULL,

  date DATETIME NULL,

  description TEXT,

  file VARCHAR(255) 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

);