CREATE TABLE forecast_mapping (
	id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
	region_id INT,
	job_category_id INT,
	job_type_id INT,
	zone_id INT,
	ophours TINYINT UNSIGNED NOT NULL,
	UNIQUE KEY (region_id, job_category_id, job_type_id, zone_id),
	FOREIGN KEY fk_region (region_id) REFERENCES regions (id),
	FOREIGN KEY fk_job_category_id (job_category_id) REFERENCES job_categories (id),
	FOREIGN KEY fk_job_type_id (job_type_id) REFERENCES job_types (id),
	FOREIGN KEY fk_zone_id (zone_id) REFERENCES zones (id)
) ENGINE=InnoDB;