🔍 Referral System Diagnostic

1. Table Schemas

local_users:
FieldTypeNullKeyDefault
idintNO (strict!)PRI
emailvarchar(255)NO (strict!)UNI
first_namevarchar(100)YES
last_namevarchar(100)YES
usernamevarchar(100)YESUNI
password_hashvarchar(255)YES
phonevarchar(20)YES
profile_imagevarchar(255)YES
is_verifiedtinyint(1)YES0
phone_verifiedtinyint(1)YES0
mobilevarchar(20)YES
roleenum('normal','influencer','business')YESnormal
can_withdrawtinyint(1)YES0
upi_idvarchar(100)YES
bank_detailstextYES
referral_codevarchar(20)YESUNI
referred_byvarchar(150)YES
created_attimestampYESCURRENT_TIMESTAMP
deletion_scheduled_atdatetimeYES
user_wallets:
FieldTypeNullKeyDefault
idintNO (strict!)PRI
emailvarchar(150)YESUNI
usernamevarchar(100)YES
balancedecimal(10,2)YES0.00
created_attimestampYESCURRENT_TIMESTAMP
updated_attimestampYESCURRENT_TIMESTAMP
wallet_transactions:
FieldTypeNullKeyDefault
idintNO (strict!)PRI
reference_idvarchar(150)YESUNI
emailvarchar(150)YES
usernamevarchar(100)YES
amountdecimal(10,2)NO (strict!)
typeenum('credit','debit')NO (strict!)
descriptionvarchar(255)YES
created_attimestampYESCURRENT_TIMESTAMP
referrals:
FieldTypeNullKeyDefault
idintNO (strict!)PRI
referrer_emailvarchar(150)YES
referrer_usernamevarchar(100)YES
referee_emailvarchar(150)YES
referee_usernamevarchar(100)YES
reward_amountdecimal(10,2)YES0.00
statusenum('pending','completed')YESpending
created_attimestampYESCURRENT_TIMESTAMP

2. Auto-patching NULL constraints

✅ ALTER TABLE user_wallets MODIFY email VARCHAR(150) NULL
✅ ALTER TABLE user_wallets MODIFY username VARCHAR(100) NULL
✅ ALTER TABLE referrals MODIFY referrer_email VARCHAR(150) NULL
✅ ALTER TABLE referrals MODIFY referee_email VARCHAR(150) NULL
✅ ALTER TABLE wallet_transactions MODIFY email VARCHAR(150) NULL
✅ ALTER TABLE wallet_transactions MODIFY username VARCHAR(100) NULL

3. Current Database Records

local_users (top 10):
idemailusernamereferral_codereferred_bycreated_at
200armycargoexpressnew@gmail.comarmycargoexpressnew@gmail.com2026-10-06 18:06:36
199dhananjaysaini01@gmail.comdhananjaysaini01@gmail.com2026-10-05 09:32:14
198ritumonikakati123@gmail.comritumonikakati123@gmail.com9B8452572026-10-03 03:30:20
197barmanmrinal618@gmail.combarmanmrinal618@gmail.com2026-09-29 08:14:50
196work.finixia@gmail.comfinixia125DC03BD02026-09-28 09:57:05
195rishitakashyapofficial@gmail.comRishitaaaak_12026-09-28 09:45:32
194rishitasubhangi001@gmail.comRishitakashyap_15596149C2026-09-28 09:32:07
190wildwoodweaves@gmail.compranjalsaikia2026-09-24 12:45:42
189shuvamchakraborty689@gmail.comsanjita057C992FFF2026-09-24 04:37:08
188neog840@gmail.comneog840@gmail.com2026-09-23 11:48:11

user_wallets (all):
idemailusernamebalanceupdated_at
292armycargoexpressnew@gmail.com₹0.002026-10-06 18:06:36
291dhananjaysaini01@gmail.com₹0.002026-10-05 09:32:14
290ritumonikakati123@gmail.comritumonikakati123@gmail.com₹0.002026-10-03 03:34:19
289barmanmrinal618@gmail.com₹0.002026-09-29 08:14:50
287rishitakashyapofficial@gmail.com₹0.002026-09-28 09:45:32
283rishitasubhangi001@gmail.comRishitakashyap_1₹0.002026-09-30 17:15:57
281wildwoodweaves@gmail.com₹0.002026-09-24 12:45:42
280shuvamchakraborty689@gmail.comsanjita05₹0.002026-09-24 04:38:35
279neog840@gmail.com₹0.002026-09-23 11:48:11
278jackyagarwal01@gmail.comjackyagarwal₹0.002026-09-22 03:09:20
277bornilraj2009@gmail.comBornil Raj₹0.002026-09-16 12:25:37
276sonaliagarwalla0@gmail.comAura31₹0.002026-09-16 07:57:35
275sonaliagarwalla005@gmail.com₹0.002026-09-16 07:39:58
274hritiknangliya12102004@gmail.comhritiknangliya12₹0.002026-09-11 13:21:59
273hritiknangliya12102004@gmaill.com₹0.002026-09-11 13:17:55
268loopsbysuu@gmail.comloopsby_suu₹0.002026-09-03 09:33:44
267kittyjamir3@gmail.comkitty₹0.002026-09-02 15:31:52
266bilkissahin290@gmail.combilkissahin290@gmail.com₹0.002026-09-02 13:56:34
265pilotpathshalacon@gmail.compilotpathshalacon@gmail.com₹0.002026-08-31 20:03:57
259support@curozip.comsupport@curozip.com₹0.002026-08-29 12:15:39
258varadsabne2410@gmail.com₹0.002026-08-28 04:02:44
257tiffy1355@gmail.com₹0.002026-08-17 06:23:49
256whimsy1578@gmail.comwhimsy1578₹0.002026-09-04 12:45:02
255olyboruah123@gmail.com₹0.002026-08-16 12:21:48
254pawarbhausahebb@gmail.com₹0.002026-08-15 13:55:07
253wenibo6372@beiwoh.com₹0.002026-08-13 20:10:05
252mehfuz7840@gmail.com₹0.002026-08-13 10:27:35
251ritampaul62184@gmail.com₹0.002026-08-06 06:14:21
250sonaliagarwalla008@gmail.comSonali₹0.002026-07-28 11:17:02
249sonalisgarwalla008@gmail.col₹0.002026-07-28 11:10:43
248bishnudas8835@gmail.comparishmita₹0.002026-07-27 14:24:34
247bisnudas7658@gmail.com₹0.002026-07-27 14:14:27
246bd6742635@gmail.com₹0.002026-07-27 14:13:27
245a@gmail.com₹0.002026-07-21 09:02:25
244swbq47061409@gmail.com₹0.002026-07-19 03:59:16
243libe47061409@gmail.com₹0.002026-07-19 03:59:16
242oqrq29573002@gmail.com₹0.002026-07-19 03:59:04
241vdhj10912340@gmail.com₹0.002026-07-19 03:59:02
240rayz14869160@gmail.com₹0.002026-07-19 03:58:52
239rxjw97873446@gmail.com₹0.002026-07-19 03:58:51
238nzkj86612935@gmail.com₹0.002026-07-19 03:58:40
237jyyz68517369@gmail.com₹0.002026-07-19 03:58:38
236fzsd46621289@gmail.com₹0.002026-07-19 03:58:26
235rbji37335489@gmail.com₹0.002026-07-19 03:58:25
234iyxk67224204@gmail.com₹0.002026-07-19 03:58:22
233jjdb79333131@gmail.com₹0.002026-07-19 03:58:14
232azes20780988@gmail.com₹0.002026-07-19 03:58:13
231nmyc75797535@gmail.com₹0.002026-07-19 03:58:04
230gceq98484262@gmail.com₹0.002026-07-19 03:57:55
229ziio94654857@gmail.com₹0.002026-07-19 03:57:47
228megw17605688@gmail.com₹0.002026-07-19 03:57:38
227eqxe73707013@gmail.com₹0.002026-07-19 03:57:28
226budv89887533@gmail.com₹0.002026-07-19 03:57:20
225sobv33755101@gmail.com₹0.002026-07-19 03:57:14
224arfv82416124@gmail.com₹0.002026-07-19 03:57:11
223jfnz08943783@gmail.com₹0.002026-07-19 03:57:02
222jydr91196012@gmail.com₹0.002026-07-19 03:56:54
221xeyj28162959@gmail.com₹0.002026-07-19 03:56:46
220yowo82177888@gmail.com₹0.002026-07-19 03:56:38
219cbvs27952647@gmail.com₹0.002026-07-19 03:56:28
218qydz01108558@gmail.com₹0.002026-07-19 03:56:20
217nwtl47064778@gmail.com₹0.002026-07-19 03:56:12
216cowe19704786@gmail.com₹0.002026-07-19 03:56:03
215csua65901283@gmail.com₹0.002026-07-19 03:55:55
214sbju94777515@gmail.com₹0.002026-07-19 03:55:46
213ywqy60455924@gmail.com₹0.002026-07-19 03:55:37
212nbgb03491855@gmail.com₹0.002026-07-19 03:55:24
211otav79344493@gmail.com₹0.002026-07-19 03:55:16
210ydev12116988@gmail.com₹0.002026-07-19 03:55:04
209fhns98268002@gmail.com₹0.002026-07-19 03:54:51
208gzjt04333992@gmail.com₹0.002026-07-19 03:54:43
207zpul78318454@gmail.com₹0.002026-07-19 03:54:34
206pcti23318204@gmail.com₹0.002026-07-19 03:54:25
205vonc96900087@gmail.com₹0.002026-07-19 03:54:16
204xkyz32004192@gmail.com₹0.002026-07-19 03:54:07
203sbpq15632700@gmail.com₹0.002026-07-19 03:53:42
202vbdf18708064@gmail.com₹0.002026-07-19 03:53:34
201tazf03365721@gmail.com₹0.002026-07-19 03:53:25
200klct37242272@gmail.com₹0.002026-07-19 03:53:16
199qidi22195407@gmail.com₹0.002026-07-19 03:53:08
198tnod56247016@gmail.com₹0.002026-07-19 03:52:47
197wugn40939911@gmail.com₹0.002026-07-19 03:52:27
196fsfm31404836@gmail.com₹0.002026-07-19 03:52:19
195ptss27348171@gmail.com₹0.002026-07-19 03:52:10
194xwxm40123487@gmail.com₹0.002026-07-19 03:52:02
193gmfu46096404@gmail.com₹0.002026-07-19 03:51:52
192uggm48577598@gmail.com₹0.002026-07-19 03:51:44
191itab53871163@gmail.com₹0.002026-07-19 03:51:21
190puak68942366@gmail.com₹0.002026-07-19 03:51:12
189gvga72460177@gmail.com₹0.002026-07-19 03:51:04
188sveq02247206@gmail.com₹0.002026-07-19 03:50:55
187ghsg91191108@gmail.com₹0.002026-07-19 03:50:47
186zdta14121117@gmail.com₹0.002026-07-19 03:50:38
185qykg36937003@gmail.com₹0.002026-07-19 03:50:30
184bjpu22765123@gmail.com₹0.002026-07-19 03:50:22
183vzsd55583669@gmail.com₹0.002026-07-19 03:50:13
182jfjd31734590@gmail.com₹0.002026-07-19 03:50:04
181jtlc31437562@gmail.com₹0.002026-07-19 03:49:55
180omws60388708@gmail.com₹0.002026-07-19 03:49:44
179uufq58796141@gmail.com₹0.002026-07-19 03:49:36
178kpfz77019506@gmail.com₹0.002026-07-19 03:49:27
177ywyn06090412@gmail.com₹0.002026-07-19 03:49:18
176olob06118292@gmail.com₹0.002026-07-19 03:49:10
175aths06090412@gmail.com₹0.002026-07-19 03:49:01
174exkm05939395@gmail.com₹0.002026-07-19 03:48:52
173sjze06118292@gmail.com₹0.002026-07-19 03:48:43
172hvry95027781@gmail.com₹0.002026-07-19 03:48:35
171zbga94771444@gmail.com₹0.002026-07-19 03:48:26
170bqsy94791436@gmail.com₹0.002026-07-19 03:48:17
169ztun95019726@gmail.com₹0.002026-07-19 03:48:09
168obgp94751456@gmail.com₹0.002026-07-19 03:48:00
167tyjx83463471@gmail.com₹0.002026-07-19 03:47:52
166irbg83645714@gmail.com₹0.002026-07-19 03:47:43
165geyo83634593@gmail.com₹0.002026-07-19 03:47:34
164opjd83645714@gmail.com₹0.002026-07-19 03:47:26
163fpyp83624046@gmail.com₹0.002026-07-19 03:47:18
162necb75029175@gmail.com₹0.002026-07-19 03:47:09
161oiod75029175@gmail.com₹0.002026-07-19 03:47:01
160ikdr72267284@gmail.com₹0.002026-07-19 03:46:52
159fnik75029175@gmail.com₹0.002026-07-19 03:46:44
158lobg75029175@gmail.com₹0.002026-07-19 03:46:35
157bagb74049263@gmail.com₹0.002026-07-19 03:46:27
156qrwg74049263@gmail.com₹0.002026-07-19 03:46:18
155hazl74049263@gmail.com₹0.002026-07-19 03:46:09
154uvzw74049263@gmail.com₹0.002026-07-19 03:46:00
153efqs60925992@gmail.com₹0.002026-07-19 03:45:52
152btow72960927@gmail.com₹0.002026-07-19 03:45:44
151iyvv72912681@gmail.com₹0.002026-07-19 03:45:35
150buht72847316@gmail.com₹0.002026-07-19 03:45:25
149rdem72867477@gmail.com₹0.002026-07-19 03:45:17
148zxxd72912681@gmail.com₹0.002026-07-19 03:45:08
147glcx66656838@gmail.com₹0.002026-07-19 03:44:59
1461234@gmail.com₹0.002026-07-18 20:03:21
145123@gmail.com₹0.002026-07-18 19:59:16
14412@gmail.com₹0.002026-07-18 19:50:56
143shivamgupta.dev1@gmail.com₹0.002026-07-18 19:38:11
142chaitanyapawar0410@gmail.comchaitanyapawar0410@gmail.com₹0.002026-07-18 11:44:07
141jurisaikiajurisaikia1960@gmail.combhaskar34₹0.002026-07-18 11:32:52
140Umashankarg714@gmail.com₹0.002026-07-18 08:33:00
139banking.babakan@gmail.combhaskargram91₹0.002026-07-17 21:33:10
90vinitchakraborty06@gmail.com₹0.002026-07-17 11:37:32
87ankurbaruah2315@gmail.com₹0.002026-07-17 11:37:32
76biswasikangkan@gmail.com₹0.002026-07-17 11:37:32
74ghanshyampanging69@gmail.com₹0.002026-07-17 11:37:32
66work.finixia@gmail.comfinixia12₹0.002026-09-28 10:03:42
65arupnath4666@gmail.comnathrabindra₹0.002026-07-12 10:45:47
62devanshgarodia8638@gmail.comdevgarodia₹0.002026-07-03 13:22:58
55finixiaglobal@gmail.comfinixiadedecons₹50.002026-07-01 19:34:00
52bhaskarjyotisaikia780@gmail.combhaskargram_₹100.002026-07-01 19:45:56
51bhaskarjyotisaikia078@gmail.combhaskargram₹808.132026-09-24 18:04:56
49prasenjitnath983@gmail.comhawkeye221₹50.002026-07-01 20:23:36
44hr.nityasarga@gmail.comchaitanya₹0.002026-07-01 16:40:14
43chaitanyapawar410@gmail.comchaitanya6722₹0.002026-07-01 08:31:04
31aniki15424@gmail.com₹100.002026-06-30 19:04:37
29sukumar.ghy@gmail.com₹0.002026-06-30 17:54:19
25guptanitisha65@gmail.com₹508.842026-07-08 01:48:51
21paricrama@gmail.comPari₹0.002026-07-18 03:38:11
19piyushgupta98544@gmail.com₹0.002026-06-30 17:39:47
18nikashdutta@gmail.com₹0.002026-06-17 12:45:53
17rahuldeb9d@gmail.com₹0.002026-06-16 18:09:41
16anurag231032@gmail.com₹0.002026-06-16 14:17:34
15rosanxonar143@gmail.com₹0.002026-06-15 19:28:21
14akashdeepchoudhury141994@gmail.com₹0.002026-06-15 18:31:32
13aniketpoddar45@gmail.com₹0.002026-06-15 07:51:56
12windrhythm21@gmail.com₹0.002026-06-12 08:48:00
11katrinagogoi88@gmail.com₹0.002026-06-07 16:18:53
10nandiniagarwal24300@gmail.com₹0.002026-06-07 09:07:42
9dhritiman.saikia.dts@gmail.com₹0.002026-06-06 15:44:13
8dd5044215@gmail.com₹0.002026-06-05 14:48:56
7rehabfarhin12@gmail.com₹0.002026-06-04 08:34:55
6khushboorara9132@gmail.com₹0.002026-06-04 08:05:07
5pronobbora06@gmail.com₹0.002026-06-04 07:39:45
4curozip@gmail.comcurozip₹1158.002026-07-08 01:48:51
2ankitabhagawati21@gmail.com₹100.002026-07-01 16:43:54
1dawncapitalglobal@gmail.com₹10.002026-06-03 23:06:13

referrals (all):
idreferrer_emailreferrer_usernamereferee_emailreferee_usernamereward_amountstatuscreated_at
9guptanitisha65@gmail.comNitishacurozip@gmail.comcurozip50.00completed2026-07-08 01:48:51
8guptanitisha65@gmail.comNitishaprasenjitnath983@gmail.comhawkeye22150.00completed2026-07-01 20:23:36
7guptanitisha65@gmail.comNitishabhaskarjyotisaikia780@gmail.combhaskargram_50.00completed2026-07-01 19:45:56
6guptanitisha65@gmail.comNitishafinixiaglobal@gmail.comfinixiadedecons50.00completed2026-07-01 19:34:00
5bhaskarjyotisaikia780@gmail.combhaskargram_bhaskarjyotisaikia078@gmail.combhaskarjyotisaikia780@gmail.com50.00completed2026-07-01 19:20:31
4curozip@gmail.comcurozipankitabhagawati21@gmail.com50.00completed2026-07-01 16:43:54
3curozip@gmail.comcurozipankitabhagawati21@gmail.com50.00completed2026-07-01 16:43:54
2guptanitisha65@gmail.comaniki15424@gmail.com50.00completed2026-06-30 18:15:24
1paricrama@gmail.comguptanitisha65@gmail.com50.00completed2026-06-30 17:50:10

wallet_transactions (top 10):
idemailusernameamounttypedescriptioncreated_at
52bhaskarjyotisaikia078@gmail.com1291.39debitOrder Payment CRZ-81C23E2026-09-24 18:04:56
51bhaskarjyotisaikia078@gmail.com2000.00creditAdmin update2026-09-24 14:02:32
50bhaskarjyotisaikia078@gmail.com179.36debitOrder Payment CRZ-6B21802026-09-09 22:25:10
49bhaskarjyotisaikia078@gmail.com200.00creditAdmin update2026-09-09 22:23:59
48bhaskarjyotisaikia078@gmail.com179.36debitOrder Payment CRZ-AEA3852026-09-09 22:15:22
47bhaskarjyotisaikia078@gmail.com200.00creditAdmin update2026-09-09 22:14:16
46bhaskarjyotisaikia078@gmail.com212.40debitOrder Payment CRZ-A6C7422026-09-09 21:59:38
45bhaskarjyotisaikia078@gmail.com200.00creditAdmin update2026-09-09 21:56:00
44bhaskarjyotisaikia078@gmail.com179.36debitOrder Payment CRZ-7255C42026-09-09 21:22:47
43bhaskarjyotisaikia078@gmail.com200.00creditAdmin update2026-09-09 21:20:42

4. Manual Referral Test

Simulate a Referral (Test)