What schema does amazon store use?

help
1

Do you think they have a master database of products?

Then an inventory table that vendors are inserting their products into? This table has a key referencing the product from the master catalogue?

So me, as a consumer, I’m searching through the master database of products. I see my search results. I click a result and on the product detail page I see the product details and a list of vendors who have it (which is a query to the inventory table using the masterProductKey)?

# MasterProductTable
id: ID
title: String
description: String

# InventoryTable
id: ID
title: String
description: String
vendorId: ID
masterProductId: ID