shop_coupon_uses

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT 10 √ null
coupon_id INT 10 null
shop_coupons.id shop_coupon_uses_coupon_id_fkey R
user_id INT 10 null
users.id shop_coupon_uses_user_id_fkey R
order_id INT 10 √ null
discount_amount DOUBLE 22 null
used_at DATETIME 23 CURRENT_TIMESTAMP(3)

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
shop_coupon_uses_coupon_id_fkey Performance Asc coupon_id
shop_coupon_uses_user_id_fkey Performance Asc user_id

Relationships

Close relationships within degrees of separation