store_product

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
store_id INT UNSIGNED 10 null
store.store_id store_product_store_store_id_fk R
product_id INT UNSIGNED 10 null
product.product_id store_product_product_product_id_fk R
stock_level INT UNSIGNED 10 0

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc/Asc store_id + product_id
store_product_product_product_id_fk Performance Asc product_id

Relationships

Close relationships within degrees of separation