Relationship Model
Supplies join to items onitem_id. Each item has at least one active supply listing, and each product has at least one item. Items roll up to a product, represented in these shared views by product_name.
How To Use The Views
UseCATALOG_ITEMS when you need one row per manufacturer item. Use CATALOG_SUPPLIES when you need distributor-level listing detail. Join CATALOG_SUPPLIES to CATALOG_ITEMS on item_id to combine distributor listing fields with canonical item descriptions.