1. The supplier_id column was defined as NOT NULL, which would prevent the deletion of a supplier if there were associated purchase orders. Changing it to allow NULL values enables the ON DELETE SET NULL behavior to work correctly.
2. The column name for the JSON data was changed from "lines" to "po_lines" to better reflect its purpose and avoid potential confusion with other tables that might have