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 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”