Salary Market

use socle ;

CREATE TABLE company_reports_authorization (

id INT AUTO_INCREMENT PRIMARY KEY,

report_generated INT NOT NULL,

report_authorized VARCHAR(255) NOT 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);