-- The purpose of this table is to map level 3 managers to their lower level managers (and the reverse)
CREATE TABLE manager_map (
	manager_service_number INT NOT NULL,
	level3_service_number INT NOT NULL,
	PRIMARY KEY (manager_service_number, level3_service_number),
	CONSTRAINT FOREIGN KEY idx_manager_service_number (manager_service_number) REFERENCES users (service_number) ON DELETE CASCADE,
	CONSTRAINT FOREIGN KEY idx_level3_service_number (level3_service_number) REFERENCES users (service_number) ON DELETE CASCADE
) ENGINE=InnoDB;
