|
entity_id
|
varchar(40)
|
utf8mb4_general_ci
|
|
|
|
profile_name
|
varchar(40)
|
utf8mb4_general_ci
|
|
|
|
segment
|
varchar(40)
|
utf8mb4_general_ci
|
|
|
|
exch_seg
|
varchar(40)
|
utf8mb4_general_ci
|
|
|
|
product
|
varchar(40)
|
utf8mb4_general_ci
|
|
|
|
family_risk
|
int(10)
|
|
|
|
|
cash
|
double(40,4)
|
|
|
|
|
turnover_limit
|
double(40,4)
|
|
|
|
|
pending_order_limit
|
double(40,4)
|
|
|
|
|
noren_time_stamp
|
bigint(20)
|
|
|
|
|
noren_nsecs
|
bigint(20)
|
|
|
|
|
src_user_id
|
varchar(40)
|
utf8mb4_general_ci
|
|
|
|
src_broker_id
|
varchar(40)
|
utf8mb4_general_ci
|
|
|
|
payin
|
double(20,4)
|
|
|
|
|
payout
|
double(20,4)
|
|
|
|
|
daylong_cash
|
double(20,4)
|
|
|
|
|
uncleared_cash
|
double(20,4)
|
|
|
|
|
broker_collateral
|
double(20,4)
|
|
|
|
|
brokerage_perc_eq_margin
|
double(20,4)
|
|
|
|
|
brokerage_perc_eq_intraday
|
double(20,4)
|
|
|
|
|
brokerage_perc_eq_cac
|
double(20,4)
|
|
|
|
|
brokerage_perc_eq_hl
|
double(20,4)
|
|
|
|
|
brokerage_perc_eq_bo
|
double(20,4)
|
|
|
|
|
brokerage_perc_der_margin
|
double(20,4)
|
|
|
|
|
brokerage_perc_der_intraday
|
double(20,4)
|
|
|
|
|
brokerage_perc_der_hl
|
double(20,4)
|
|
|
|
|
brokerage_perc_der_bo
|
double(20,4)
|
|
|
|
|
brokerage_perc_fx_margin
|
double(20,4)
|
|
|
|
|
brokerage_perc_fx_intraday
|
double(20,4)
|
|
|
|
|
brokerage_perc_fx_hl
|
double(20,4)
|
|
|
|
|
brokerage_perc_fx_bo
|
double(20,4)
|
|
|
|
|
brokerage_perc_com_margin
|
double(20,4)
|
|
|
|
|
brokerage_perc_com_intraday
|
double(20,4)
|
|
|
|
|
brokerage_perc_com_hl
|
double(20,4)
|
|
|
|
|
brokerage_perc_com_bo
|
double(20,4)
|
|
|
|
|
brokerage_flat_perc
|
double(20,4)
|
|
|
|
|
from_segment
|
varchar(40)
|
utf8mb4_general_ci
|
|
|
|
from_exch_seg
|
varchar(40)
|
utf8mb4_general_ci
|
|
|
|
from_product
|
varchar(40)
|
utf8mb4_general_ci
|
|
|
|
aux_daylong_cash
|
double(20,4)
|
|
|
|
|
aux_uncleared_cash
|
double(20,4)
|
|
|
|
|
aux_broker_collateral
|
double(20,4)
|
|
|
|
