(TODO) REFERAL CODE & USAGES | Notion

<aside>

</aside>

Bảng `referral_codes`

Cột	Kiểu	Null?	Default	Ràng buộc / Ghi chú
`id`	`UUID`	NO		PK
`code`	`VARCHAR`	NO		UNIQUE, mã referral
`owner_user_id`	`UUID`	NO		FK → `users(id)` ON DELETE CASCADE
`campaign_id`	`UUID`	YES		FK → `promotion_campaigns(id)` ON DELETE SET NULL
`created_at`	`TIMESTAMP`	NO	`now()`

Bảng `referral_usages`

Cột	Kiểu	Null?	Default	Ràng buộc / Ghi chú
`id`	`UUID`	NO		PK
`referral_code_id`	`UUID`	NO		FK → `referral_codes(id)` ON DELETE CASCADE
`new_user_id`	`UUID`	NO		FK → `users(id)` ON DELETE CASCADE
`order_id`	`UUID`	NO		FK → `orders(id)` ON DELETE RESTRICT
`used_at`	`TIMESTAMP`	NO	`now()`	Thời điểm sử dụng

Create Referral Code Command

Update Referral Code Command

Remove Referral Code Command

Assign Referral Code To Campaign Command

Unassign Referral Code To Campaign Command

Record Referral Usage Command

Apply Referral Code Command

Get Referral Code Detail Query

List Referral Codes By User Query

List Referral Usages By Code Query

List Referral Usages By User Query

Get Referral Stats Query