|
user_id
|
varchar(40)
|
utf8mb4_general_ci
|
|
|
|
creation_date
|
bigint(20)
|
|
|
|
|
noren_time_stamp
|
bigint(20)
|
|
|
|
|
login_image
|
bigint(20)
|
|
|
|
|
last_password_time
|
bigint(20)
|
|
|
|
|
last_login_time
|
bigint(20)
|
|
|
|
|
mob_num
|
bigint(20)
|
|
|
|
|
display_precision
|
int(10)
|
|
|
|
|
max_contract_sub
|
int(10)
|
|
|
|
|
dob
|
varchar(40)
|
utf8mb4_general_ci
|
|
|
|
user_login_otp
|
varchar(40)
|
utf8mb4_general_ci
|
|
|
|
last_login_mac
|
varchar(40)
|
utf8mb4_general_ci
|
|
|
|
user_default_mw
|
varchar(40)
|
utf8mb4_general_ci
|
|
|
|
addr_city
|
varchar(40)
|
utf8mb4_general_ci
|
|
|
|
addr_state
|
varchar(40)
|
utf8mb4_general_ci
|
|
|
|
addr
|
varchar(256)
|
utf8mb4_general_ci
|
|
|
|
executing_broker_id
|
varchar(40)
|
utf8mb4_general_ci
|
|
|
|
email_id
|
varchar(40)
|
utf8mb4_general_ci
|
|
|
|
pan_num
|
varchar(40)
|
utf8mb4_general_ci
|
|
|
|
user_access_grp
|
varchar(40)
|
utf8mb4_general_ci
|
|
|
|
status
|
varchar(40)
|
utf8mb4_general_ci
|
|
|
|
user_ip_addr
|
varchar(40)
|
utf8mb4_general_ci
|
|
|
|
user_mac_addr
|
varchar(40)
|
utf8mb4_general_ci
|
|
|
|
noren_extras_grp
|
varchar(40)
|
utf8mb4_general_ci
|
|
|
|
noren_extras
|
varchar(40)
|
utf8mb4_general_ci
|
|
|
|
user_ord_validator
|
varchar(40)
|
utf8mb4_general_ci
|
|
|
|
prop_id
|
varchar(40)
|
utf8mb4_general_ci
|
|
|
|
user_name
|
varchar(40)
|
utf8mb4_general_ci
|
|
|
|
login_password
|
varchar(256)
|
utf8mb4_general_ci
|
|
|
|
user_sess_id
|
varchar(40)
|
utf8mb4_general_ci
|
|
|
|
src_user_id
|
varchar(40)
|
utf8mb4_general_ci
|
|
|
|
last_login_ip
|
varchar(40)
|
utf8mb4_general_ci
|
|
|
|
user_privilege
|
int(10)
|
|
|
|
|
access_type
|
varchar(40)
|
utf8mb4_general_ci
|
|
|
|
noren_app_version
|
varchar(40)
|
utf8mb4_general_ci
|
|
|
|
last_login_os
|
varchar(40)
|
utf8mb4_general_ci
|
|
|
|
broker_id
|
varchar(40)
|
utf8mb4_general_ci
|
|
|
|
region
|
varchar(40)
|
utf8mb4_general_ci
|
|
|
|
user_sess_otp
|
varchar(40)
|
utf8mb4_general_ci
|
|
|
|
login_proc_id
|
varchar(40)
|
utf8mb4_general_ci
|
|
|
|
prop_ord_flag
|
int(10)
|
|
|
|
|
acct_overview
|
int(10)
|
|
|
|
|
red_super_user
|
int(10)
|
|
|
|
|
user_2fa_flag
|
int(10)
|
|
|
|
|
password_reset
|
int(10)
|
|
|
|
|
last_attempt_count
|
int(10)
|
|
|
|
|
last_attempt_time
|
bigint(20)
|
|
|
|
|
product
|
varchar(40)
|
utf8mb4_general_ci
|
|
|
|
user_accesstype
|
varchar(40)
|
utf8mb4_general_ci
|
|
|
|
user_ordtype
|
varchar(40)
|
utf8mb4_general_ci
|
|
|
|
fcm_token
|
varchar(256)
|
utf8mb4_general_ci
|
|
|
|
user_tag
|
varchar(40)
|
utf8mb4_general_ci
|
|
|
|
remarks
|
varchar(256)
|
utf8mb4_general_ci
|
|
|
|
totp_sec
|
varchar(40)
|
utf8mb4_general_ci
|
|
|
|
last_otp_time
|
bigint(20)
|
|
|
|
|
otp_count
|
bigint(20)
|
|
|
|
