Affiliates Schema

ext_affiliates - Affiliates

Schema: ext_affiliates | Auto-generated on 2026-03-30

---

affiliates

Affiliate registrations under a program owner.

Column	Type	Nullable	Default
id	uuid	NO	gen_random_uuid()
user_id	uuid	NO	—
program_owner_id	uuid	NO	—
status	text	NO	'pending'
commission_rate	numeric	NO	10
total_earnings	numeric	NO	0
total_referrals	integer	NO	0
approved_at	timestamptz	YES	—
created_at	timestamptz	NO	now()
updated_at	timestamptz	NO	now()

codes

Affiliate discount/referral codes.

Column	Type	Nullable	Default
id	uuid	NO	gen_random_uuid()
affiliate_id	uuid	NO	—
code	text	NO	—
discount_percent	numeric	NO	0
usage_count	integer	NO	0
is_active	boolean	NO	true
created_at	timestamptz	NO	now()

referrals

Tracked referral conversions with commission amounts.

Column	Type	Nullable	Default
id	uuid	NO	gen_random_uuid()
code_id	uuid	NO	—
affiliate_id	uuid	NO	—
referred_user_id	uuid	NO	—
order_reference_id	uuid	YES	—
order_reference_type	text	YES	—
order_amount	numeric	YES	—
commission_amount	numeric	YES	—
status	text	NO	'pending'
confirmed_at	timestamptz	YES	—
paid_at	timestamptz	YES	—
created_at	timestamptz	NO	now()
updated_at	timestamptz	NO	now()

payout_requests

Affiliate payout withdrawal requests.

Column	Type	Nullable	Default
id	uuid	NO	gen_random_uuid()
affiliate_id	uuid	NO	—
amount	numeric	NO	—
status	text	NO	'pending'
payment_id	uuid	YES	—
notes	text	YES	—
requested_at	timestamptz	NO	now()
processed_at	timestamptz	YES	—
created_at	timestamptz	NO	now()
updated_at	timestamptz	NO	now()