|
acct_id
|
varchar(40)
|
utf8mb4_general_ci
|
|
|
|
creation_date
|
bigint(20)
|
|
|
|
|
noren_time_stamp
|
bigint(20)
|
|
|
|
|
mob_num
|
varchar(40)
|
utf8mb4_general_ci
|
|
|
|
display_precision
|
int(10)
|
|
|
|
|
dp_type
|
varchar(40)
|
utf8mb4_general_ci
|
|
|
|
dp_id
|
varchar(40)
|
utf8mb4_general_ci
|
|
|
|
broker_id
|
varchar(40)
|
utf8mb4_general_ci
|
|
|
|
region
|
varchar(128)
|
utf8mb4_general_ci
|
|
|
|
acct_name
|
varchar(256)
|
utf8mb4_general_ci
|
|
|
|
src_user_id
|
varchar(40)
|
utf8mb4_general_ci
|
|
|
|
email_id
|
varchar(256)
|
utf8mb4_general_ci
|
|
|
|
pan_num
|
varchar(40)
|
utf8mb4_general_ci
|
|
|
|
addr
|
varchar(512)
|
utf8mb4_general_ci
|
|
|
|
acct_type
|
varchar(40)
|
utf8mb4_general_ci
|
|
|
|
status
|
varchar(40)
|
utf8mb4_general_ci
|
|
|
|
office_addr
|
varchar(40)
|
utf8mb4_general_ci
|
|
|
|
addr_city
|
varchar(40)
|
utf8mb4_general_ci
|
|
|
|
addr_state
|
varchar(40)
|
utf8mb4_general_ci
|
|
|
|
gender
|
varchar(40)
|
utf8mb4_general_ci
|
|
|
|
occupation
|
varchar(40)
|
utf8mb4_general_ci
|
|
|
|
exch_acct_id
|
varchar(40)
|
utf8mb4_general_ci
|
|
|
|
family_id
|
varchar(40)
|
utf8mb4_general_ci
|
|
|
|
context
|
varchar(40)
|
utf8mb4_general_ci
|
|
|
|
product
|
varchar(40)
|
utf8mb4_general_ci
|
|
|
|
dp_actnum1
|
varchar(40)
|
utf8mb4_general_ci
|
|
|
|
dp_actnum2
|
varchar(40)
|
utf8mb4_general_ci
|
|
|
|
dp_actnum3
|
varchar(40)
|
utf8mb4_general_ci
|
|
|
|
mail
|
tinyint(1)
|
|
|
|
|
sms
|
tinyint(1)
|
|
|
|
|
trade_notification
|
varchar(40)
|
utf8mb4_general_ci
|
|
|
|
cust_firm
|
varchar(40)
|
utf8mb4_general_ci
|
|
|
|
bank_addr1
|
varchar(256)
|
utf8mb4_general_ci
|
|
|
|
bank_brnch_name1
|
varchar(40)
|
utf8mb4_general_ci
|
|
|
|
bank_name1
|
varchar(40)
|
utf8mb4_general_ci
|
|
|
|
bank_acct_type1
|
varchar(40)
|
utf8mb4_general_ci
|
|
|
|
bank_acct_num1
|
varchar(256)
|
utf8mb4_general_ci
|
|
|
|
bank_ifsc_code1
|
varchar(256)
|
utf8mb4_general_ci
|
|
|
|
bank_addr2
|
varchar(256)
|
utf8mb4_general_ci
|
|
|
|
bank_brnch_name2
|
varchar(40)
|
utf8mb4_general_ci
|
|
|
|
bank_name2
|
varchar(40)
|
utf8mb4_general_ci
|
|
|
|
bank_acct_type2
|
varchar(40)
|
utf8mb4_general_ci
|
|
|
|
bank_acct_num2
|
varchar(256)
|
utf8mb4_general_ci
|
|
|
|
bank_ifsc_code2
|
varchar(256)
|
utf8mb4_general_ci
|
|
|
|
bank_addr3
|
varchar(256)
|
utf8mb4_general_ci
|
|
|
|
bank_brnch_name3
|
varchar(40)
|
utf8mb4_general_ci
|
|
|
|
bank_name3
|
varchar(40)
|
utf8mb4_general_ci
|
|
|
|
bank_acct_type3
|
varchar(40)
|
utf8mb4_general_ci
|
|
|
|
bank_acct_num3
|
varchar(256)
|
utf8mb4_general_ci
|
|
|
|
bank_ifsc_code3
|
varchar(256)
|
utf8mb4_general_ci
|
|
|
|
bank_addr4
|
varchar(256)
|
utf8mb4_general_ci
|
|
|
|
bank_brnch_name4
|
varchar(40)
|
utf8mb4_general_ci
|
|
|
|
bank_name4
|
varchar(40)
|
utf8mb4_general_ci
|
|
|
|
bank_acct_type4
|
varchar(40)
|
utf8mb4_general_ci
|
|
|
|
bank_acct_num4
|
varchar(256)
|
utf8mb4_general_ci
|
|
|
|
bank_ifsc_code4
|
varchar(256)
|
utf8mb4_general_ci
|
|
|
|
bank_addr5
|
varchar(256)
|
utf8mb4_general_ci
|
|
|
|
bank_brnch_name5
|
varchar(40)
|
utf8mb4_general_ci
|
|
|
|
bank_name5
|
varchar(40)
|
utf8mb4_general_ci
|
|
|
|
bank_acct_type5
|
varchar(40)
|
utf8mb4_general_ci
|
|
|
|
bank_acct_num5
|
varchar(256)
|
utf8mb4_general_ci
|
|
|
|
bank_ifsc_code5
|
varchar(256)
|
utf8mb4_general_ci
|
|
|
|
bank_addr6
|
varchar(256)
|
utf8mb4_general_ci
|
|
|
|
bank_brnch_name6
|
varchar(40)
|
utf8mb4_general_ci
|
|
|
|
bank_name6
|
varchar(40)
|
utf8mb4_general_ci
|
|
|
|
bank_acct_type6
|
varchar(40)
|
utf8mb4_general_ci
|
|
|
|
bank_acct_num6
|
varchar(256)
|
utf8mb4_general_ci
|
|
|
|
bank_ifsc_code6
|
varchar(256)
|
utf8mb4_general_ci
|
|
|
|
sor_flag
|
tinyint(1)
|
|
|
|
