products

100 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT 10 √ null
cart_items.product_id cart_items_product_id_fkey R
coordinate_products.product_id coordinate_products_product_id_fkey R
influencer_products.original_product_id influencer_products_original_product_id_fkey R
live_product_sales.product_id live_product_sales_product_id_fkey R
live_products.product_id live_products_product_id_fkey R
live_promotions.product_id live_promotions_product_id_fkey R
order_items.product_id order_items_product_ibfk R
product_apparel_details.product_id product_apparel_details_product_id_fkey R
product_images.product_id product_images_product_id_fkey C
product_other_details.product_id product_other_details_product_id_fkey R
product_shipping.product_id product_shipping_product_id_fkey R
product_sizes.product_id product_sizes_product_id_fkey C
product_variants.product_id product_variants_product_id_fkey C
reviews.product_id reviews_product_id_fkey N
shop_coupon_products.product_id shop_coupon_products_product_id_fkey R
video_products.product_id video_products_product_id_fkey R
name VARCHAR 255 null
description TEXT 65535 √ null
price DECIMAL 12,2 null
status enum('ACTIVE', 'INACTIVE', 'OUT_OF_STOCK') 12 null
is_public BIT 1 1
category_id INT 10 null
product_categories.id products_category_id_fkey R
shop_id INT 10 null
shops.id products_shop_id_fkey R
created_at DATETIME 19 CURRENT_TIMESTAMP
updated_at DATETIME 19 CURRENT_TIMESTAMP
deleted_at DATETIME 19 √ null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
idx_products_category_id Performance Asc category_id
idx_products_name Performance Asc name
idx_products_shop_id Performance Asc shop_id
idx_products_status Performance Asc status

Relationships

Close relationships within degrees of separation