<aside>

</aside>

Bảng promotion_conditions

Cột Kiểu Null? Default Ràng buộc / Ghi chú
id UUID NO PK
promotion_id UUID NO FK → promotions(id) ON DELETE CASCADE
condition_type promotion_condition_type NO Enum: min_total
operator VARCHAR NO >=, <=, ...
value INT NO Giá trị so sánh
created_at TIMESTAMP NO now()
updated_at TIMESTAMP NO now()
INDEX (promotion_id)

Add Promotion Condition Command

Update Promotion Condition Command

Remove Promotion Condition Command

List Promotion Conditions Query