Zend certified PHP/Magento developer

What is the difference between inventory_source_item and inventory_stock_x?

With Magento’s new multi-source inventory system, various new tables have been introduced into the database.

inventory_source_item contains the machine name of the source, SKU, quantity, and the status.

inventory_stock_x is a table that exists for each source, containing the SKU, quantity, and if it’s salable.

Why does the second table exist, when the first could store all of that information?