<aside>

</aside>

Bảng promotion_user_targets

Cột Kiểu Null? Default Ràng buộc / Ghi chú
promotion_id UUID NO FK → promotions(id) ON DELETE CASCADE
user_id UUID NO FK → users(id) ON DELETE CASCADE
PK — — — (promotion_id, user_id)

Bảng promotion_product_targets

Cột Kiểu Null? Default Ràng buộc / Ghi chú
promotion_id UUID NO FK → promotions(id) ON DELETE CASCADE
product_id UUID NO FK → products(id) ON DELETE CASCADE
PK — — — (promotion_id, product_id)

Add Promotion Product Target Command

Remove Promotion Product Target Command

List Promotion Product Targets Query

Add Promotion User Target Command

Remove Promotion User Target Command

List Promotion User Targets Query