CREATE TABLE `sales` ( `purchase_id` int NOT NULL AUTO_INCREMENT, `date_of_purchase` date DEFAULT NULL, `customer_id` int DEFAULT NULL, `item_code` varchar(10) DEFAULT NULL, PRIMARY KEY (`purchase_id`), KEY `constraint_1` (`customer_id`), CONSTRAINT `constraint_1` FOREIGN KEY (`customer_id`) REFERENCES `customers` (`customer_id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci CREATE TABLE `customers` ( `customer_id` int NOT NULL AUTO_INCREMENT, `first_name` varchar(255) DEFAULT NULL, `last_name` varchar(255) DEFAULT NULL, `email_address` varchar(255) DEFAULT NULL, `number_of_complaints` int DEFAULT NULL, PRIMARY KEY (`customer_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci

Thanks for your reply, appreciated.

I have the same problem. It shows up in DDL and schemas but not in FK section (I click the refreshed button on the bottom right corner). Also if I may ask too, I made sure to select ON Update NO Action but why does it show ON UPDATE Restrict on the definition? I appreciate the response!

I have the same problem, I can't find the foreign key in the foreign keys tab, any solution, please?

Hi Gilliane and Mohamed! Thanks for reaching out. This is a well-known bug in the Workbench. You can continue with the smooth taking of the course. Hope this helps. Best, Tsvetelin