Create db_schema_whitelist.json file using CLI in Magento 2.

In Magento 2, From Magento Version 2.3 and higher version contains the declarative schema approach for InstallSchema/Upgrade schema, InstallData/Upgrade data functionality.

You can create db_schema_whitelist.json using Command line with a single command,

Generated file location is the <Vendorname>/<Modulename>/etc/db_schema_whitelist.json in your module. Continue reading “Create db_schema_whitelist.json file using CLI in Magento 2.”

Product Custom option table relation with other entity in Magento 2

Product with the custom option available Out of the box in Magento 2. You can add, delete or update custom option of a product using an admin panel or creating a script by programmatically.

You can check the relation for each custom option table with another table in Magento 2.3

catalog_product_option is the primary table to manage Custom Option related data for a product. Continue reading “Product Custom option table relation with other entity in Magento 2”