✅ Connected to SHREEDBSQL

📦 Table: [dbo].[Customers]

ColumnTypeMax LengthNullable
CustomerId int NO
Name varchar 100 NO
Country varchar 50 NO

Rows: 51

Preview Data (Top 5 rows)
CustomerIdNameCountry
11dadadadaUnited StatesUnited States
22dadadadaIndiaIndia
33dadadadaFranceFrance
44dadadadaUnited StatesUnited States
55dadadadaIndiaIndia

📦 Table: [dbo].[Sauda_Type_Master]

ColumnTypeMax LengthNullable
Id int NO
Sauda_ID int NO
Sauda_Type nvarchar 50 YES
Active bit NO
tblno nvarchar 255 YES
In_Out int YES
COL nvarchar 255 YES
tbR nvarchar 255 YES
S_mobile int YES

Rows: 45

Preview Data (Top 5 rows)
IdSauda_IDSauda_TypeActivetblnoIn_OutCOLtbRS_mobile
1111AKDAKD11TbTenCorss,TbPartyTbTenCorss,TbParty11TbTenCorss.tbN1,TbTenCorss.tbN1 AS Pana,TbParty.p_rakd AS RateTbTenCorss.tbN1,TbTenCorss.tbN1 AS Pana,TbParty.p_rakd AS RateTbParty.p_partyTbParty.p_party11
171722JodiJodi11TbJodi,TbPartyTbJodi,TbParty22TbJodi.JO_NO,TbJodi.JO_NO AS Pana,TbParty.p_rjodi AS RateTbJodi.JO_NO,TbJodi.JO_NO AS Pana,TbParty.p_rjodi AS RateTbParty.p_partyTbParty.p_party22
383833PanaPana11TbPanaTbPana33TbPana.Pana,TbPana.PanaTbPana.Pana,TbPana.PanaTbParty.p_partyTbParty.p_party33
414144ChukadaChukada11TbCHK,TbPartyTbCHK,TbParty22tb_Jodi,tb_JodiC AS Pana,TbParty.p_rjodi AS Ratetb_Jodi,tb_JodiC AS Pana,TbParty.p_rjodi AS RateTbParty.p_partyTbParty.p_party1414
404055MotorMotor11TbPanaTbPanaTbPana.Pana,TbPana.PanaTbPana.Pana,TbPana.PanaTbParty.p_partyTbParty.p_party77

📦 Table: [dbo].[Settings]

ColumnTypeMax LengthNullable
s_ID int YES
s_Password nvarchar 50 YES
s_Username nvarchar 50 YES
s_Decimal_Format bit NO
s_Display_Format bit NO
s_Party_Format bit NO
s_Display_Formats bit NO
s_Capital_Holder nvarchar 255 YES
s_Block_Galli bit NO
s_mhide int YES

Rows: 1

Preview Data (Top 5 rows)
s_IDs_Passwords_Usernames_Decimal_Formats_Display_Formats_Party_Formats_Display_Formatss_Capital_Holders_Block_Gallis_mhide
11123123ADMINADMIN1111001129-09-202029-09-20200011

📦 Table: [dbo].[tb_User_Password]

ColumnTypeMax LengthNullable
Customerid int YES
CustomerName nvarchar 50 YES
Mobile_No nchar 10 YES
tb_Username nvarchar 50 YES
tb_password nvarchar 50 YES

Rows: 4

Preview Data (Top 5 rows)
CustomeridCustomerNameMobile_Notb_Usernametb_password
11AdminAdmin12345678901234567890AdminAdmin123123
22HITESHHITESH12345678901234567890HiteshHitesh123123
33SHREE RAMSHREE RAM12345678901234567890Admin3Admin3123123
44AdministratorAdministrator12345678901234567890Admin@gmail.comAdmin@gmail.comadminadmin

📦 Table: [dbo].[TbAKADA]

ColumnTypeMax LengthNullable
ID int NO
A_AKD int YES
A_Sr int YES
A_Party nvarchar 50 YES
A_Mode nvarchar 20 YES
A_KL nvarchar 5 YES
A_Type nvarchar 50 YES
A_Rate money YES
A_Amount money YES
A_AKDNo nvarchar 10 YES
A_Balan money YES
A_Yes money YES
A_No money YES
A_Delete nvarchar 10 YES
A_Modify nvarchar 10 YES
A_CheckEntry nvarchar 10 YES
A_Date datetime YES
A_time datetime YES
A_Pass bit NO
A_Resalt int YES
On_ID int YES

Rows: 644

Preview Data (Top 5 rows)
IDA_AKDA_SrA_PartyA_ModeA_KLA_TypeA_RateA_AmountA_AKDNoA_BalanA_YesA_NoA_DeleteA_ModifyA_CheckEntryA_DateA_timeA_PassA_ResaltOn_ID
1948531948532211KAMALKAMALOPENOPENAKDAKD9.00009.0000500.0000500.000011.0000.0000.0000.0000.0000.00000000002025-08-28 00:00:00.0002025-08-28 00:00:00.0001900-01-01 23:06:42.0001900-01-01 23:06:42.000001111
4909404909404477HITESHHITESHOPENOPENAKDAKD.0000.00001001.00001001.000011.0000.0000.0000.0000.0000.00000000002025-10-19 00:00:00.0002025-10-19 00:00:00.0001900-01-01 15:54:08.0001900-01-01 15:54:08.000000011
4909414909415511KAMALKAMALOPENOPENAKDAKD9.00009.0000100.0000100.000011.0000.0000.0000.0000.0000.00001100002025-10-28 00:00:00.0002025-10-28 00:00:00.0001900-01-01 22:50:05.0001900-01-01 22:50:05.000000011
491034491034559494KAMALKAMALOPENOPENAKDAKD9.00009.00001.00001.000011.0000.0000.0000.0000.0000.00000000002025-11-25 00:00:00.0002025-11-25 00:00:00.0001900-01-01 11:12:30.0001900-01-01 11:12:30.000000011
4910354910357711KAMALKAMALOPENOPENAKDAKD9.00009.00001.00001.000011.0000.0000.0000.0000.0000.00001100002025-11-25 00:00:00.0002025-11-25 00:00:00.0001900-01-01 11:13:38.0001900-01-01 11:13:38.000000011

📦 Table: [dbo].[TbASTK]

ColumnTypeMax LengthNullable
ID int NO
tb_Jodi nvarchar 10 YES
tb_JodiA nvarchar 10 YES

Rows: 716

Preview Data (Top 5 rows)
IDtb_Joditb_JodiA
13113101011010
13213201011515
13313301016060
13413401016565
13513502022020

📦 Table: [dbo].[TbASTKFNO]

ColumnTypeMax LengthNullable
ID int NO
tb_Jodi nvarchar 10 YES
tb_JodiA nvarchar 10 YES

Rows: 712

Preview Data (Top 5 rows)
IDtb_Joditb_JodiA
13113101011010
13213201011515
13313301016060
13413401016565
13513502022020

📦 Table: [dbo].[TbCHK]

ColumnTypeMax LengthNullable
ID int NO
tb_Jodi nvarchar 10 YES
tb_JodiC nvarchar 10 YES

Rows: 400

Preview Data (Top 5 rows)
IDtb_Joditb_JodiC
12712700000000
12812800000505
12912900005050
13013000005555
13113101010101

📦 Table: [dbo].[TbCommanDP]

ColumnTypeMax LengthNullable
ID int NO
Pana nvarchar 10 YES
DPcomm nvarchar 255 YES

Rows: 180

Preview Data (Top 5 rows)
IDPanaDPcomm
1110010011
2211011011
3311211211
4411311311
5511411411

📦 Table: [dbo].[TbCommanSP]

ColumnTypeMax LengthNullable
ID int NO
Pana nvarchar 10 YES
TbCommSP nvarchar 255 YES

Rows: 360

Preview Data (Top 5 rows)
IDPanaTbCommSP
1112812811
2212912911
3312012011
4413013011
5514014011

📦 Table: [dbo].[TbCY]

ColumnTypeMax LengthNullable
ID int NO
tb_Panatype nvarchar 10 YES
Pana nvarchar 10 YES

Rows: 539

Preview Data (Top 5 rows)
IDtb_PanatypePana
111010100100
221010110110
331010120120
441010130130
551010140140

📦 Table: [dbo].[TbDP]

ColumnTypeMax LengthNullable
ID int NO
DP_1 nvarchar 10 YES
DP_2 nvarchar 10 YES
DP_3 nvarchar 10 YES
DP_4 nvarchar 10 YES
DP_5 nvarchar 10 YES
DP_6 nvarchar 10 YES
DP_7 nvarchar 10 YES
DP_8 nvarchar 10 YES
DP_9 nvarchar 10 YES
DP_0 nvarchar 10 YES

Rows: 90

Preview Data (Top 5 rows)
IDDP_1DP_2DP_3DP_4DP_5DP_6DP_7DP_8DP_9DP_0
11100100200200300300400400500500600600700700800800900900226226
22335335336336355355338338339339448448223223288288225225668668
33344344499499445445446446366366466466377377440440388388488488
44119119110110166166112112113113114114115115116116117117118118
55399399660660599599455455447447556556449449477477559559334334

📦 Table: [dbo].[TbFamily]

ColumnTypeMax LengthNullable
ID int NO
tb_Familytyp nvarchar 10 YES
Pana1 nvarchar 5 YES
Pana nvarchar 255 YES
FamilyJ nvarchar 255 YES

Rows: 220

Preview Data (Top 5 rows)
IDtb_FamilytypPana1PanaFamilyJ
22022011111111111112812816A16A
22122111111111611613713716A16A
22222211111116616623623616A16A
22322311111166666667867816A16A
22422411211211211236736716A16A

📦 Table: [dbo].[TbJodi]

ColumnTypeMax LengthNullable
ID int NO
JO_NO nvarchar 10 YES
JO_OS nvarchar 10 YES
JO_CS nvarchar 10 YES

Rows: 100

Preview Data (Top 5 rows)
IDJO_NOJO_OSJO_CS
1100000000
2201010011
3302020022
4403030033
5504040044

📦 Table: [dbo].[tbMain]

ColumnTypeMax LengthNullable
ID int NO
tbId int YES
tbOther nvarchar 255 YES

Rows: 1

Preview Data (Top 5 rows)
IDtbIdtbOther
1177

📦 Table: [dbo].[TbNewGame]

ColumnTypeMax LengthNullable
ID int NO
N_Id int YES
N_Date datetime YES
N_time datetime YES
N_BazarName nvarchar 100 YES
N_BazarOpen nvarchar 50 YES
N_BazarResult nvarchar 50 YES
N_Other int YES
N_Declear_OPEN nvarchar 255 YES
N_Declear_Close nvarchar 255 YES
N_OpneANK nvarchar 255 YES
N_CloseANK nvarchar 255 YES
N_OpanPana1 nvarchar 50 YES
N_ClosePana1 nvarchar 50 YES

Rows: 7

Preview Data (Top 5 rows)
IDN_IdN_DateN_timeN_BazarNameN_BazarOpenN_BazarResultN_OtherN_Declear_OPENN_Declear_CloseN_OpneANKN_CloseANKN_OpanPana1N_ClosePana1
12881288112025-08-14 00:00:00.0002025-08-14 00:00:00.0001900-01-01 08:45:00.0001900-01-01 08:45:00.000DEMOSDEMOSMondayMonday11
12891289222025-08-27 00:00:00.0002025-08-27 00:00:00.0001900-01-01 18:51:00.0001900-01-01 18:51:00.000TEST BAZARTEST BAZARSundaySundayDeclearDeclear11OPENOPEN00569569
12901290332025-10-02 00:00:00.0002025-10-02 00:00:00.0001900-01-01 18:31:00.0001900-01-01 18:31:00.000TEST 3TEST 3SundaySunday11
12911291442025-10-02 00:00:00.0002025-10-02 00:00:00.0001900-01-01 18:32:00.0001900-01-01 18:32:00.000TEST 4TEST 4MondayMondayDeclearDeclear11OPENOPENCLOSECLOSE100100100100
22902290552025-10-28 00:00:00.0002025-10-28 00:00:00.0001900-01-01 22:49:00.0001900-01-01 22:49:00.000TEST 5TEST 5WednesdayWednesday11

📦 Table: [dbo].[TbPana]

ColumnTypeMax LengthNullable
SR_ID int NO
Pana_ID smallint YES
Pana nvarchar 5 YES
Pana_Type smallint YES
Chart30 nvarchar 255 YES
Chart40 nvarchar 255 YES
Chart50B nvarchar 255 YES
Chart60 nvarchar 255 YES
Chart70 nvarchar 255 YES
Chart56 nvarchar 255 YES
Chart64 nvarchar 255 YES
Pana48 nvarchar 255 YES
Pana26 nvarchar 255 YES
Chart72 nvarchar 255 YES
PanaCut50 nvarchar 255 YES
68Pana nvarchar 255 YES
For_Get nvarchar 255 YES
For_GetOut nvarchar 255 YES
100_DP nvarchar 255 YES
50PanaoneShot nvarchar 255 YES
52Pana nvarchar 255 YES
SP30ABR nvarchar 255 YES
SP90ABRCut nvarchar 255 YES
Family nvarchar 255 YES
CP nvarchar 255 YES
SP nvarchar 255 YES
DP nvarchar 6 YES
TP nvarchar 6 YES

Rows: 220

Preview Data (Top 5 rows)
SR_IDPana_IDPanaPana_TypeChart30Chart40Chart50BChart60Chart70Chart56Chart64Pana48Pana26Chart72PanaCut5068PanaFor_GetFor_GetOut100_DP50PanaoneShot52PanaSP30ABRSP90ABRCutFamilyCPSPDPTP
11111281281010NoNo11NoNo1111NoNo1111NoNo11NoNo1111NoNoNoNoNoNoNoNoNoNo1111
22111371371111NoNoNoNo11NoNoNoNoNoNo1111NoNoNoNoNoNoNoNoNoNo11NoNoNoNo1111NoNo11
3311146146101011NoNo11NoNoNoNoNoNo1111NoNoNoNo11NoNo11NoNoNoNoNoNo11NoNo1111
44112362361010NoNo11NoNo111111NoNo11NoNo11NoNo11NoNo11NoNoNoNoNoNoNoNo1111
55112452451010NoNo11NoNo111111NoNoNoNoNoNo11NoNo11NoNo11NoNoNoNoNoNoNoNo1111

📦 Table: [dbo].[TbParty]

ColumnTypeMax LengthNullable
ID int NO
p_party nvarchar 50 YES
p_status nvarchar 255 YES
p_Bcommi int YES
p_bcomiAgent nvarchar 255 YES
p_bAtransfer nvarchar 255 YES
p_rakd nvarchar 255 YES
p_rpati nvarchar 255 YES
p_rsp nvarchar 255 YES
p_rdp nvarchar 255 YES
p_rtp nvarchar 255 YES
p_rcp nvarchar 255 YES
p_rcoman nvarchar 255 YES
p_rcomanDP nvarchar 255 YES
p_rmotor nvarchar 255 YES
p_rmotorDP nvarchar 255 YES
p_rfamily nvarchar 255 YES
p_rjodi nvarchar 255 YES
p_rjodiCors nvarchar 255 YES
p_sakd int YES
p_spati int YES
p_ssp int YES
p_sdp int YES
p_stp int YES
p_scp int YES
p_scoman int YES
p_smotor int YES
p_sfamily int YES
p_sjodi int YES
p_Agname nvarchar 50 YES
p_aakd int YES
p_apati int YES
p_asp int YES
p_adp int YES
p_atp int YES
p_acp int YES
p_acoman int YES
p_amotor int YES
p_afamily int YES
p_ajodi int YES
p_Paname nvarchar 50 YES
p_pakd int YES
p_ppati int YES
p_psp int YES
p_pdp int YES
p_ptp int YES
p_pcp int YES
p_pcoman int YES
p_pmotor int YES
p_pfamily int YES
p_pjodi int YES
P_Otranser nvarchar 255 YES
p_Paname_1 nvarchar 50 YES
p_pakd_1 int YES
p_pjodi_1 int YES
p_ppati_1 int YES
p_pcp_1 int YES
number nvarchar 50 YES

Rows: 7

Preview Data (Top 5 rows)
IDp_partyp_statusp_Bcommip_bcomiAgentp_bAtransferp_rakdp_rpatip_rspp_rdpp_rtpp_rcpp_rcomanp_rcomanDPp_rmotorp_rmotorDPp_rfamilyp_rjodip_rjodiCorsp_sakdp_spatip_sspp_sdpp_stpp_scpp_scomanp_smotorp_sfamilyp_sjodip_Agnamep_aakdp_apatip_aspp_adpp_atpp_acpp_acomanp_amotorp_afamilyp_ajodip_Panamep_pakdp_ppatip_pspp_pdpp_ptpp_pcpp_pcomanp_pmotorp_pfamilyp_pjodiP_Otranserp_Paname_1p_pakd_1p_pjodi_1p_ppati_1p_pcp_1number
11*SHREE GANESH*SHREE GANESHRegularRegular0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
22KAMALKAMALRegularRegular9090991401401501503003009009009915015030030090090000909090901010101010100010101010000010101010LD KAMLLD KAML101010100000001010000000101000000000000000000000000000000089622299988962229998
44S SS SBookyBooky10101010101015015030030090090010101551553003009009000010010010100000000000000000000000000000000000000000000000000000000000000000000000
55HITESHHITESHDummyDummy000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000919309375149919309375149
66RAMRAMRegularRegular10101010101010101010101010101010101010101010001010101010101010101010101010101000000010101010101010100000001010000000101019191010101000000000000000000000000088888888888888888888

📦 Table: [dbo].[TbPatti]

ColumnTypeMax LengthNullable
ID int NO
P_1 nvarchar 10 YES
P_2 nvarchar 10 YES
P_3 nvarchar 10 YES
P_4 nvarchar 10 YES
P_5 nvarchar 10 YES
P_6 nvarchar 10 YES
P_7 nvarchar 10 YES
P_8 nvarchar 10 YES
P_9 nvarchar 10 YES
P_0 nvarchar 10 YES
0 nvarchar 255 YES
1 nvarchar 255 YES
2 nvarchar 255 YES
3 nvarchar 255 YES
4 nvarchar 255 YES
5 nvarchar 255 YES
6 nvarchar 255 YES
7 nvarchar 255 YES
8 nvarchar 255 YES
9 nvarchar 255 YES

Rows: 22

Preview Data (Top 5 rows)
IDP_1P_2P_3P_4P_5P_6P_7P_8P_9P_00123456789
101280129012001300140012301240125012601271270000000000
201370138013901490159015001600134013501361360000000000
301460147014801580168016901790170018001451450000000000
402360156015701670230017802500189023401901900000000000
502450237023802390249024002690260027002352350000000000

📦 Table: [dbo].[TbSP]

ColumnTypeMax LengthNullable
ID int NO
SP_1 nvarchar 10 YES
SP_2 nvarchar 10 YES
SP_3 nvarchar 10 YES
SP_4 nvarchar 10 YES
SP_5 nvarchar 10 YES
SP_6 nvarchar 10 YES
SP_7 nvarchar 10 YES
SP_8 nvarchar 10 YES
SP_9 nvarchar 10 YES
SP_0 nvarchar 10 YES

Rows: 12

Preview Data (Top 5 rows)
IDSP_1SP_2SP_3SP_4SP_5SP_6SP_7SP_8SP_9SP_0
11128128129129120120130130140140123123124124125125126126127127
22290290246246247247248248258258259259278278279279289289235235
33579579589589670670680680690690457457467467468468478478569569
44137137138138139139149149159159150150160160134134135135136136
55380380345345256256257257267267268268340340350350360360370370

📦 Table: [dbo].[TbSP2]

ColumnTypeMax LengthNullable
ID int NO
SP_P nvarchar 50 YES
tb_NubeT int YES

Rows: 120

Preview Data (Top 5 rows)
IDSP_Ptb_NubeT
1112812811
2229029011
3357957911
4413713711
5538038011

📦 Table: [dbo].[TbTenCorss]

ColumnTypeMax LengthNullable
ID int NO
tbN nvarchar 10 YES
tbN1 nvarchar 10 YES

Rows: 10

Preview Data (Top 5 rows)
IDtbNtbN1
11111111
33222222
44333333
55444444
66555555

📦 Table: [dbo].[TbTP]

ColumnTypeMax LengthNullable
ID int NO
TP_1 nvarchar 10 YES
TP_2 nvarchar 10 YES
TP_3 nvarchar 10 YES
TP_4 nvarchar 10 YES
TP_5 nvarchar 10 YES
TP_6 nvarchar 10 YES
TP_7 nvarchar 10 YES
TP_8 nvarchar 10 YES
TP_9 nvarchar 10 YES
TP_0 nvarchar 10 YES

Rows: 10

Preview Data (Top 5 rows)
IDTP_1TP_2TP_3TP_4TP_5TP_6TP_7TP_8TP_9TP_0
11777777444444111111888888555555222222999999666666333333000000
1111444444
1212111111
1313888888
1414555555

📦 Table: [dbo].[TbTrancation]

ColumnTypeMax LengthNullable
ID int NO
tb_Party nvarchar 250 YES
tb_Amount money YES
tb_Remark nvarchar 250 YES
tb_date datetime YES
tb_time datetime YES
tb_BazarId int YES
tb_BazarName nvarchar 255 YES
tb_Type nvarchar 150 YES
tb_OPCO nvarchar 50 YES
tb_Monday nvarchar 250 YES
tb_Monday_Final nvarchar 50 YES
tb_Hawala nvarchar 255 YES
tb_modify int YES
tb_delete nvarchar 2 YES
tb_Pana nvarchar 10 YES
tb_Day nvarchar 10 YES

Rows: 39

Preview Data (Top 5 rows)
IDtb_Partytb_Amounttb_Remarktb_datetb_timetb_BazarIdtb_BazarNametb_Typetb_OPCOtb_Mondaytb_Monday_Finaltb_Hawalatb_modifytb_deletetb_Panatb_Day
5688956889KAMALKAMAL.0000.00002 - TEST BAZAR2 - TEST BAZAR2025-08-27 00:00:00.0002025-08-27 00:00:00.0001900-01-01 23:13:06.0001900-01-01 23:13:06.00022PanaPanaBazarBazarOPENOPEN00NoNo000000569569PP
5691356913*SHREE GANESH*SHREE GANESH.0000.00004 - TEST 44 - TEST 42025-10-02 00:00:00.0002025-10-02 00:00:00.0001900-01-01 22:43:29.0001900-01-01 22:43:29.00044BazarBazarOPENOPEN00NoNo000000100100PP
5691456914HITESHHITESH.0000.00004 - TEST 44 - TEST 42025-10-02 00:00:00.0002025-10-02 00:00:00.0001900-01-01 22:43:29.0001900-01-01 22:43:29.00044AKDAKDBazarBazarOPENOPEN00NoNo000000100100PP
5691556915KAMALKAMAL.0000.00004 - TEST 44 - TEST 42025-10-02 00:00:00.0002025-10-02 00:00:00.0001900-01-01 22:43:29.0001900-01-01 22:43:29.00044AKDAKDBazarBazarOPENOPEN00NoNo000000100100PP
5691656916HITESHHITESH-1001.0000-1001.0000Business 4 - TEST 4Business 4 - TEST 42025-10-02 00:00:00.0002025-10-02 00:00:00.0001900-01-01 22:43:29.0001900-01-01 22:43:29.00044AKDAKDBazarBazarOPENOPEN00NoNo000000100100BB

📦 Table: [dbo].[User_setting]

ColumnTypeMax LengthNullable
tb_ID int NO
tb_tabll_1 nvarchar 50 YES
tb_table_2 nvarchar 50 YES
tb_table_3 nvarchar 50 YES
tb_table_4 nvarchar 50 YES

Rows: 1

Preview Data (Top 5 rows)
tb_IDtb_tabll_1tb_table_2tb_table_3tb_table_4
11Pal_FullPal_FullAmountAmount00OPEN,CLOSEOPEN,CLOSE