Product
Tableproduct, id prefix prod. The shared master product, not owned by any
store. The marketplace-relevant fields:
Relations used by the marketplace:
variants, options, categories,
collection, tags, type, images (native Medusa), plus Mercur’s sellers
(the allowlist), offers, scoped_attributes, and changes (audit history).
product_seller
The allowlist: a many-to-many link table betweenProduct and Seller
controlling which stores may sell a master product.
A store on this table can create an offer against the
product; a store not on it cannot.
ProductVariant
Tableproduct_variant, id prefix variant. A purchasable configuration of a
master product, generated from its options and variant-axis attributes. Holds the
SKU-level catalog structure. Offer-scoped price and inventory live on the offer,
not here.
ProductCategory
Tableproduct_category, id prefix pcat. Hierarchical, nestable
classification. Participates in the marketplace layer through the
category_seller allowlist and the media_images link.
ProductCollection
Tableproduct_collection, id prefix pcol. Flat, curated grouping of products,
with a media_images link for collection artwork.
ProductTag and ProductType round out the native grouping models: free-form
labels and a single type classification per product, respectively. They carry
no Mercur-specific columns.