product_variants

400 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT 10 √ null
inventory.variant_id inventory_variant_id_fkey C
order_items.variant_id order_items_variant_ibfk R
product_variant_images.variant_id product_variant_images_variant_id_fkey R
reviews.product_variant_id reviews_product_variant_id_fkey N
product_id INT 10 null
products.id product_variants_product_id_fkey C
size_id INT 10 √ null
product_sizes.id product_variants_size_id_fkey N
color_id INT 10 √ null
sku VARCHAR 100 null
price DECIMAL 12,2 null
created_at DATETIME 19 CURRENT_TIMESTAMP
updated_at DATETIME 19 null
deleted_at DATETIME 19 √ null
color_masterId INT 10 √ null
color_master.id product_variants_color_masterId_fkey N
size_masterId INT 10 √ null
size_master.id product_variants_size_masterId_fkey N

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
idx_product_variants_product_id Performance Asc product_id
idx_product_variants_size_id Performance Asc size_id
product_variants_color_masterId_fkey Performance Asc color_masterId
product_variants_size_masterId_fkey Performance Asc size_masterId
product_variants_sku_key Must be unique Asc sku

Relationships

Close relationships within degrees of separation