cart_items

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT 10 √ null
user_id INT 10 null
users.id cart_items_user_id_fkey R
product_id INT 10 null
products.id cart_items_product_id_fkey R
variant_id INT 10 √ null
quantity INT 10 1
added_at DATETIME 23 CURRENT_TIMESTAMP(3)

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
cart_items_product_id_fkey Performance Asc product_id
cart_items_user_id_product_id_variant_id_key Must be unique Asc/Asc/Asc user_id + product_id + variant_id

Relationships

Close relationships within degrees of separation