|
SlNo
|
bigint(20)
|
|
|
|
|
AccountId
|
varchar(10)
|
utf8mb4_general_ci
|
|
|
|
AccountName
|
varchar(50)
|
utf8mb4_general_ci
|
|
|
|
UserId
|
varchar(15)
|
utf8mb4_general_ci
|
|
|
|
BranchId
|
varchar(12)
|
utf8mb4_general_ci
|
|
|
|
Password
|
varchar(10)
|
utf8mb4_general_ci
|
|
|
|
TransactionPassword
|
varchar(10)
|
utf8mb4_general_ci
|
|
|
|
EmailID
|
varchar(50)
|
utf8mb4_general_ci
|
|
|
|
ResidenceAddr
|
text
|
utf8mb4_general_ci
|
|
|
|
OfficeAddr
|
text
|
utf8mb4_general_ci
|
|
|
|
OfficePhoneNo
|
varchar(30)
|
utf8mb4_general_ci
|
|
|
|
CellNo
|
varchar(30)
|
utf8mb4_general_ci
|
|
|
|
FamilyId
|
varchar(12)
|
utf8mb4_general_ci
|
|
|
|
DPId
|
varchar(30)
|
utf8mb4_general_ci
|
|
|
|
DPName
|
varchar(30)
|
utf8mb4_general_ci
|
|
|
|
DPAccountNo
|
varchar(30)
|
utf8mb4_general_ci
|
|
|
|
DecimalPreference
|
int(11)
|
|
|
|
|
PanNumber
|
varchar(20)
|
utf8mb4_general_ci
|
|
|
|
ClientType
|
varchar(3)
|
utf8mb4_general_ci
|
|
|
|
BankAccountNo
|
varchar(20)
|
utf8mb4_general_ci
|
|
|
|
MICRNumber
|
varchar(20)
|
utf8mb4_general_ci
|
|
|
|
BankName
|
varchar(50)
|
utf8mb4_general_ci
|
|
|
|
BankAddress
|
text
|
utf8mb4_general_ci
|
|
|
|
ClientStatus
|
varchar(1)
|
utf8mb4_general_ci
|
|
|
|
ClientRMSCategory
|
varchar(20)
|
utf8mb4_general_ci
|
|
|
|
UserRoleName
|
varchar(50)
|
utf8mb4_general_ci
|
|
|
|
ClientType2
|
varchar(50)
|
utf8mb4_general_ci
|
|
|
|
UserAccessType
|
text
|
utf8mb4_general_ci
|
|
|
|
MarketWatchCount
|
int(11)
|
|
|
|
|
MarketWatchScripCount
|
int(11)
|
|
|
|
|
DPAccountType
|
varchar(20)
|
utf8mb4_general_ci
|
|
|
|
Depository
|
varchar(10)
|
utf8mb4_general_ci
|
|
|
|
UserRights
|
varchar(10)
|
utf8mb4_general_ci
|
|
|
|
BrokerId
|
varchar(20)
|
utf8mb4_general_ci
|
|
|
|
ProductsEnabled
|
text
|
utf8mb4_general_ci
|
|
|
|
BankAccountNo2
|
varchar(20)
|
utf8mb4_general_ci
|
|
|
|
BankName2
|
varchar(50)
|
utf8mb4_general_ci
|
|
|
|
BankAddress2
|
text
|
utf8mb4_general_ci
|
|
|
|
BankAccountNo3
|
varchar(20)
|
utf8mb4_general_ci
|
|
|
|
BankName3
|
varchar(50)
|
utf8mb4_general_ci
|
|
|
|
BankAddress3
|
text
|
utf8mb4_general_ci
|
|
|
|
AutoPwdReset
|
varchar(1)
|
utf8mb4_general_ci
|
|
|
|
AutoTransactionPwdReset
|
varchar(1)
|
utf8mb4_general_ci
|
|
|
|
AccountCustId
|
varchar(25)
|
utf8mb4_general_ci
|
|
|
|
ClientDOB
|
varchar(20)
|
utf8mb4_general_ci
|
|
|
|
2FAEnabled
|
varchar(1)
|
utf8mb4_general_ci
|
|
|
|
ResetAnswerFlag
|
varchar(1)
|
utf8mb4_general_ci
|
|
|
|
UserStatus
|
varchar(1)
|
utf8mb4_general_ci
|
|
|
|
AddOrModify
|
varchar(50)
|
utf8mb4_general_ci
|
|
|
|
Validated
|
varchar(50)
|
utf8mb4_general_ci
|
|
|
|
ValidationText
|
text
|
utf8mb4_general_ci
|
|
|
|
DtTime
|
datetime
|
|
|
|
|
mail_sms_event
|
varchar(20)
|
utf8mb4_general_ci
|
|
|
|
mail_sms_frequency
|
varchar(10)
|
utf8mb4_general_ci
|
|
|
|
mailsms_event
|
varchar(10)
|
utf8mb4_general_ci
|
|
|
|
AccountType
|
varchar(30)
|
utf8mb4_general_ci
|
|
|
|
BranchName
|
text
|
utf8mb4_general_ci
|
|
|
|
CustomerId
|
varchar(20)
|
utf8mb4_general_ci
|
|
|
|
GENDER
|
varchar(5)
|
utf8mb4_general_ci
|
|
|
|
OCCUPATION
|
int(11)
|
|
|
|
|
TaxStatus
|
int(11)
|
|
|
|
|
KYCcomplaint
|
varchar(1)
|
utf8mb4_general_ci
|
|
|
|
CITY
|
varchar(20)
|
utf8mb4_general_ci
|
|
|
|
STATE
|
varchar(20)
|
utf8mb4_general_ci
|
|
|
|
PINCODE
|
varchar(20)
|
utf8mb4_general_ci
|
|
|
|
PreferredDiv
|
int(11)
|
|
|
|
|
PaymentMechanismCODE
|
varchar(20)
|
utf8mb4_general_ci
|
|
|
|
GuardianDOB
|
date
|
|
|
|
|
GuardianName
|
varchar(50)
|
utf8mb4_general_ci
|
|
|
|
GuardianPANNo
|
varchar(10)
|
utf8mb4_general_ci
|
|
|
|
StatementCommunicationMode
|
varchar(10)
|
utf8mb4_general_ci
|
|
|
|
MobileNo
|
varchar(30)
|
utf8mb4_general_ci
|
|
|
|
ARNNo
|
varchar(50)
|
utf8mb4_general_ci
|
|
|
|
ResidencePhoneNo
|
varchar(20)
|
utf8mb4_general_ci
|
|
|
|
DPAcctNo2
|
varchar(30)
|
utf8mb4_general_ci
|
|
|
|
DPAcctNo3
|
varchar(30)
|
utf8mb4_general_ci
|
|
|
|
DPAcctNo4
|
varchar(30)
|
utf8mb4_general_ci
|
|
|
|
DPAcctNo5
|
varchar(30)
|
utf8mb4_general_ci
|
|
|
|
DPAcctNo6
|
varchar(30)
|
utf8mb4_general_ci
|
|
|
|
BankBranchName2
|
varchar(50)
|
utf8mb4_general_ci
|
|
|
|
BankBranchName3
|
varchar(50)
|
utf8mb4_general_ci
|
|
|
|
BankName4
|
varchar(50)
|
utf8mb4_general_ci
|
|
|
|
BankBranchName4
|
varchar(50)
|
utf8mb4_general_ci
|
|
|
|
BankAccountNumber4
|
varchar(20)
|
utf8mb4_general_ci
|
|
|
|
BankAddress4
|
text
|
utf8mb4_general_ci
|
|
|
|
BankName5
|
varchar(50)
|
utf8mb4_general_ci
|
|
|
|
BankBranchName5
|
varchar(50)
|
utf8mb4_general_ci
|
|
|
|
BankAccountNumber5
|
varchar(20)
|
utf8mb4_general_ci
|
|
|
|
BankAddress5
|
text
|
utf8mb4_general_ci
|
|
|
|
BankName6
|
varchar(50)
|
utf8mb4_general_ci
|
|
|
|
BankBranchName6
|
varchar(50)
|
utf8mb4_general_ci
|
|
|
|
BankAccountNumber6
|
varchar(20)
|
utf8mb4_general_ci
|
|
|
|
BankAddress6
|
text
|
utf8mb4_general_ci
|
|
|
|
EnableSOR
|
varchar(1)
|
utf8mb4_general_ci
|
|
|
|
LoginSequence
|
int(11)
|
|
|
|
|
ExposureLimit
|
int(12)
|
|
|
|
|
TurnoverLimit
|
int(12)
|
|
|
|
|
GrossExposureDerivativeLimit
|
int(12)
|
|
|
|
