#,TABLE_SCHEMA,TABLE_TYPE,ENGINE,TABLE_NAME,ORDINAL_POSITION,COLUMN_NAME,COLUMN_TYPE,IS_NULLABLE,COLUMN_KEY,EXTRA,COLUMN_COMMENT,COLUMN_REMARK
1,liquidnet_wac,BASE TABLE,InnoDB,fin_ac_n01,1,FA0,varchar(32),NO,PRI,account.acc_no,Funding account number,acc_no = specified_group_id(wallet_no) + acc_type_no
2,liquidnet_wac,BASE TABLE,InnoDB,fin_ac_n01,2,FA1,varchar(32),YES,,account.fin_id,Wallet user ID,
3,liquidnet_wac,BASE TABLE,InnoDB,fin_ac_n01,3,FA2,varchar(16),YES,,account.acc_type,Funding account type,"000:Available Balance,001:Pending Balance,002:Frozen Balance"
4,liquidnet_wac,BASE TABLE,InnoDB,fin_ac_n01,4,FA3,varchar(5),YES,,account.acc_currency,Funding currency alphabetic code,
5,liquidnet_wac,BASE TABLE,InnoDB,fin_ac_n01,5,FA4,int(5),YES,,account.acc_status,Funding account status,<> `wallet.pay_status`
6,liquidnet_wac,BASE TABLE,InnoDB,fin_ac_n01,6,FA5,varchar(100),YES,,account.acc_alias,Funding account alias,<> `wallet.status`
7,liquidnet_wac,BASE TABLE,InnoDB,fin_ac_n01,7,FA6,varchar(32),YES,,account.acc_group_id,# Funding reserved field,Can be specified when opening an account.
8,liquidnet_wac,BASE TABLE,InnoDB,fin_ac_n01,8,FA7,varchar(32),YES,,account.acc_parent,# Funding reserved field,
9,liquidnet_wac,BASE TABLE,InnoDB,fin_ac_n01,9,FA8,int(5),YES,,account.acc_level,# Funding reserved field,
10,liquidnet_wac,BASE TABLE,InnoDB,fin_ac_n01,10,FA9,int(5),YES,,account.acc_state,# Funding reserved field,
11,liquidnet_wac,BASE TABLE,InnoDB,fin_ac_n01,11,FA10,datetime,YES,,account.create_time,Funding account opening time,
12,liquidnet_wac,BASE TABLE,InnoDB,fin_ac_n01,12,FA11,datetime,YES,,account.update_time,,
13,liquidnet_wac,BASE TABLE,InnoDB,fin_ac_n01,13,FA12,datetime,YES,,account.closing_time,# Funding reserved field,
14,liquidnet_wac,BASE TABLE,InnoDB,fin_ac_n01,14,FA13,datetime,YES,,account.check_time,# Funding reserved field,
15,liquidnet_wac,BASE TABLE,InnoDB,fin_ac_n01,15,FA14,int(5),YES,,account.check_status,# Funding reserved field,
16,liquidnet_wac,BASE TABLE,InnoDB,fin_ac_n01,16,FA15,varchar(32),YES,,account.check_id,# Funding reserved field,
17,liquidnet_wac,BASE TABLE,InnoDB,fin_ac_n02_*,1,FAB0,varchar(32),NO,PRI,account_bill.bill_no,Funding account bill number,
18,liquidnet_wac,BASE TABLE,InnoDB,fin_ac_n02_*,2,FAB1,varchar(32),YES,MUL,account_bill.acc_no,Funding account number,
19,liquidnet_wac,BASE TABLE,InnoDB,fin_ac_n02_*,3,FAB2,varchar(32),YES,,account_bill.wallet_id,Wallet number,
20,liquidnet_wac,BASE TABLE,InnoDB,fin_ac_n02_*,4,FAB3,varchar(32),YES,,account_bill.fin_id,Wallet user ID,
21,liquidnet_wac,BASE TABLE,InnoDB,fin_ac_n02_*,5,FAB4,varchar(8),YES,,account_bill.category,Type of credit and debit,"C:+,D:-"
22,liquidnet_wac,BASE TABLE,InnoDB,fin_ac_n02_*,6,FAB5,"decimal(20,6)",YES,,account_bill.amount,Transaction amount,
23,liquidnet_wac,BASE TABLE,InnoDB,fin_ac_n02_*,7,FAB6,varchar(32),YES,,account_bill.trans_no,Wallet transaction number,
24,liquidnet_wac,BASE TABLE,InnoDB,fin_ac_n02_*,8,FAB7,int(5),YES,,account_bill.acc_status,Funding account status,Status at the time of the transaction
25,liquidnet_wac,BASE TABLE,InnoDB,fin_ac_n02_*,9,FAB8,varchar(64),YES,,account_bill.tracing_no,Transaction ID,
26,liquidnet_wac,BASE TABLE,InnoDB,fin_ac_n02_*,10,FAB9,datetime,YES,,account_bill.tracing_time,Transaction time,
27,liquidnet_wac,BASE TABLE,InnoDB,fin_ac_n02_*,11,FAB10,datetime,YES,,account_bill.create_time,,
28,liquidnet_wac,BASE TABLE,InnoDB,fin_ac_n02_*,12,FAB11,varchar(100),YES,,account_bill.remark,# Funding reserved field,
29,liquidnet_wac,BASE TABLE,InnoDB,fin_n01,1,FD0,varchar(32),NO,PRI,dict.dict_id,,
30,liquidnet_wac,BASE TABLE,InnoDB,fin_n01,2,FD1,varchar(32),YES,MUL,dict.dict_code,,
31,liquidnet_wac,BASE TABLE,InnoDB,fin_n01,3,FD2,varchar(50),YES,,dict.dict_name,,
32,liquidnet_wac,BASE TABLE,InnoDB,fin_n01,4,FD3,int(5),YES,,dict.status,,
33,liquidnet_wac,BASE TABLE,InnoDB,fin_n01,5,FD4,varchar(100),YES,,dict.remark,,
34,liquidnet_wac,BASE TABLE,InnoDB,fin_n02,1,FDV0,varchar(32),NO,PRI,dict_value.value_id,,
35,liquidnet_wac,BASE TABLE,InnoDB,fin_n02,2,FDV1,varchar(32),YES,MUL,dict_value.dict_id,,
36,liquidnet_wac,BASE TABLE,InnoDB,fin_n02,3,FDV2,varchar(50),YES,,dict_value.value_code,,
37,liquidnet_wac,BASE TABLE,InnoDB,fin_n02,4,FDV3,varchar(100),YES,,dict_value.value_name,,
38,liquidnet_wac,BASE TABLE,InnoDB,fin_n02,5,FDV4,int(5),YES,,dict_value.status,,
39,liquidnet_wac,BASE TABLE,InnoDB,fin_n02,6,FDV5,varchar(255),YES,,dict_value.remark,,
40,liquidnet_wac,BASE TABLE,InnoDB,fin_wl_n01,1,FC0,varchar(32),NO,PRI,channel.channel_id,Wallet channel ID,
41,liquidnet_wac,BASE TABLE,InnoDB,fin_wl_n01,2,FC1,varchar(12),YES,,channel.channel_code,Wallet channel alphabetic code,
42,liquidnet_wac,BASE TABLE,InnoDB,fin_wl_n01,3,FC2,varchar(50),YES,,channel.channel_name,Wallet channel name,
43,liquidnet_wac,BASE TABLE,InnoDB,fin_wl_n01,4,FC3,varchar(8),YES,,channel.channel_status,Wallet channel status,"0:INIT,1:NORMAL,2:DISABLE"
44,liquidnet_wac,BASE TABLE,InnoDB,fin_wl_n01,5,FC4,varchar(128),YES,,channel.channel_key,# Wallet reserved field,
45,liquidnet_wac,BASE TABLE,InnoDB,fin_wl_n01,6,FC5,datetime,YES,,channel.create_time,,
46,liquidnet_wac,BASE TABLE,InnoDB,fin_wl_n01,7,FC6,datetime,YES,,channel.update_time,,
47,liquidnet_wac,BASE TABLE,InnoDB,fin_wl_n01,8,FC7,varchar(64),YES,,channel.operator,Recent operator,
48,liquidnet_wac,BASE TABLE,InnoDB,fin_wl_n03,1,FU0,varchar(32),NO,PRI,user.fin_id,Wallet user ID,
49,liquidnet_wac,BASE TABLE,InnoDB,fin_wl_n03,2,FU1,varchar(64),YES,MUL,user.user_ext_id,User association ID,
50,liquidnet_wac,BASE TABLE,InnoDB,fin_wl_n03,3,FU2,varchar(150),YES,,user.user_ext_name,User association name,
51,liquidnet_wac,BASE TABLE,InnoDB,fin_wl_n03,4,FU3,varchar(32),YES,,user.channel_id,Wallet channel ID,
52,liquidnet_wac,BASE TABLE,InnoDB,fin_wl_n03,5,FU4,varchar(8),YES,,user.user_status,Wallet user status,"0:INIT,1:NORMAL,2:DISABLE"
53,liquidnet_wac,BASE TABLE,InnoDB,fin_wl_n03,6,FU5,varchar(32),YES,,user.user_seq_no,# Wallet reserved field,
54,liquidnet_wac,BASE TABLE,InnoDB,fin_wl_n03,7,FU6,varchar(2),YES,,user.user_flag,Wallet user type,"0:BUSINESS,1:PERSONAL"
55,liquidnet_wac,BASE TABLE,InnoDB,fin_wl_n03,8,FU7,datetime,YES,,user.create_time,,
56,liquidnet_wac,BASE TABLE,InnoDB,fin_wl_n03,9,FU8,datetime,YES,,user.update_time,,
57,liquidnet_wac,BASE TABLE,InnoDB,fin_wl_n05,1,FW0,varchar(32),NO,PRI,wallet.wallet_no,Wallet number,
58,liquidnet_wac,BASE TABLE,InnoDB,fin_wl_n05,2,FW1,varchar(5),YES,,wallet.currency,Wallet currency alphabetic code,
59,liquidnet_wac,BASE TABLE,InnoDB,fin_wl_n05,3,FW2,varchar(100),YES,,wallet.alias,Wallet alias,
60,liquidnet_wac,BASE TABLE,InnoDB,fin_wl_n05,4,FW3,int(5),YES,,wallet.status,Wallet status code,"0:INIT,1:NORMAL,2:DISABLE"
61,liquidnet_wac,BASE TABLE,InnoDB,fin_wl_n05,5,FW4,int(5),YES,,wallet.pay_status,Wallet pay status code,"1:NORMAL,2:NO_IN,3:NO_OUT,4:ARCHIVE"
62,liquidnet_wac,BASE TABLE,InnoDB,fin_wl_n05,6,FW5,varchar(32),YES,,wallet.fin_id,Wallet user ID,
63,liquidnet_wac,BASE TABLE,InnoDB,fin_wl_n05,7,FW6,varchar(32),YES,,wallet.user_ext_id,User association ID,
64,liquidnet_wac,BASE TABLE,InnoDB,fin_wl_n05,8,FW7,varchar(32),YES,,wallet.user_ext_name,User association name,
65,liquidnet_wac,BASE TABLE,InnoDB,fin_wl_n05,9,FW8,datetime,YES,,wallet.create_time,Wallet account opening time,
66,liquidnet_wac,BASE TABLE,InnoDB,fin_wl_n05,10,FW9,varchar(64),YES,,wallet.create_operator,Wallet account opening operator,
67,liquidnet_wac,BASE TABLE,InnoDB,fin_wl_n05,11,FW10,datetime,YES,,wallet.update_time,Recently updated time,
68,liquidnet_wac,BASE TABLE,InnoDB,fin_wl_n05,12,FW11,varchar(64),YES,,wallet.update_operator,Recently updated operator,
69,liquidnet_wac,BASE TABLE,InnoDB,fin_wl_n05,13,FW12,datetime,YES,,wallet.closing_time,Wallet account closure time,When the `wallet.status` set 2
70,liquidnet_wac,BASE TABLE,InnoDB,fin_wl_n05,14,FW13,varchar(64),YES,,wallet.closing_operator,Wallet account closure operator,
71,liquidnet_wac,BASE TABLE,InnoDB,fin_wl_n07,1,FBT0,varchar(64),NO,PRI,biz_trans.trans_no,Wallet transaction number,
72,liquidnet_wac,BASE TABLE,InnoDB,fin_wl_n07,2,FBT1,varchar(32),YES,,biz_trans.wallet_no,Wallet number,
73,liquidnet_wac,BASE TABLE,InnoDB,fin_wl_n07,3,FBT2,varchar(32),YES,,biz_trans.fin_id,Wallet user ID,
74,liquidnet_wac,BASE TABLE,InnoDB,fin_wl_n07,4,FBT3,"decimal(20,6)",YES,,biz_trans.amount,Transaction amount,
75,liquidnet_wac,BASE TABLE,InnoDB,fin_wl_n07,5,FBT4,varchar(22),YES,,biz_trans.trans_type,Wallet transaction type,"CREDIT_ONWAY,CREDIT_CONFIRM,CREDIT_CANCEL,DEBIT_ONWAY,DEBIT_CONFIRM,DEBIT_CANCEL"
76,liquidnet_wac,BASE TABLE,InnoDB,fin_wl_n07,6,FBT5,int(5),YES,,biz_trans.trans_status,Wallet transaction status,"Default:1 (0:PROCESSING,1:SUCCESS,2:FAILED)"
77,liquidnet_wac,BASE TABLE,InnoDB,fin_wl_n07,7,FBT6,varchar(64),YES,,biz_trans.trade_no,Wallet API interaction trade number,
78,liquidnet_wac,BASE TABLE,InnoDB,fin_wl_n07,8,FBT7,varchar(64),YES,,biz_trans.tracing_no,Transaction ID,
79,liquidnet_wac,BASE TABLE,InnoDB,fin_wl_n07,9,FBT8,varchar(30),YES,,biz_trans.tracing_type,Transaction type,
80,liquidnet_wac,BASE TABLE,InnoDB,fin_wl_n07,10,FBT9,datetime,YES,,biz_trans.tracing_time,Transaction time,
81,liquidnet_wac,BASE TABLE,InnoDB,fin_wl_n07,11,FBT10,varchar(100),YES,,biz_trans.tracing_title,Transaction title,
82,liquidnet_wac,BASE TABLE,InnoDB,fin_wl_n07,12,FBT11,varchar(100),YES,,biz_trans.tracing_desc,Transaction description,
83,liquidnet_wac,BASE TABLE,InnoDB,fin_wl_n07,13,FBT12,datetime,YES,,biz_trans.create_time,,
84,liquidnet_wac,BASE TABLE,InnoDB,fin_wl_n07,14,FBT13,datetime,YES,,biz_trans.complete_time,# Wallet reserved field,
85,liquidnet_wac,BASE TABLE,InnoDB,fin_wl_n07,15,FBT14,datetime,YES,,biz_trans.update_time,# Wallet reserved field,
86,liquidnet_wac,BASE TABLE,InnoDB,fin_wl_n07,16,FBT15,varchar(255),YES,,biz_trans.remark,# Wallet reserved field,
87,liquidnet_wac,BASE TABLE,InnoDB,fin_wl_n07,17,FBT16,varchar(100),YES,,biz_trans.reasons,# Wallet reserved field,
88,liquidnet_wac,BASE TABLE,InnoDB,fin_wl_n08,1,FBTE0,varchar(64),NO,PRI,biz_trans_extra.trans_no,Wallet transaction number,
89,liquidnet_wac,BASE TABLE,InnoDB,fin_wl_n08,2,FBTE1,varchar(32),YES,,biz_trans_extra.wallet_no,Wallet number,
90,liquidnet_wac,BASE TABLE,InnoDB,fin_wl_n08,3,FBTE2,"decimal(20,6)",YES,,biz_trans_extra.balance_available,Wallet available balance,
91,liquidnet_wac,BASE TABLE,InnoDB,fin_wl_n08,4,FBTE3,"decimal(20,6)",YES,,biz_trans_extra.balance_pending,Wallet pending balance,
92,liquidnet_wac,BASE TABLE,InnoDB,fin_wl_n08,5,FBTE4,"decimal(20,6)",YES,,biz_trans_extra.balance_frozen,Wallet frozen balance,
93,liquidnet_wac,BASE TABLE,InnoDB,fin_wl_n08,6,FBTE5,int(5),YES,,biz_trans_extra.received,# Wallet reserved field,"0:INIT,1:RECEIVED"
94,liquidnet_wac,BASE TABLE,InnoDB,fin_wl_n08,7,FBTE6,datetime,YES,,biz_trans_extra.cal_time,Calculating time,
95,liquidnet_wac,BASE TABLE,InnoDB,fin_wl_n08,8,FBTE7,datetime,YES,,biz_trans_extra.received_time,# Wallet reserved field,
96,liquidnet_wac,BASE TABLE,InnoDB,fin_wl_n10,1,FBT10,varchar(64),NO,PRI,biz_trade.trade_no,Wallet API interaction trade number,
97,liquidnet_wac,BASE TABLE,InnoDB,fin_wl_n10,2,FBT11,varchar(32),YES,,biz_trade.channel_id,Wallet channel ID,
98,liquidnet_wac,BASE TABLE,InnoDB,fin_wl_n10,3,FBT12,varchar(16),YES,,biz_trade.biz_type,Wallet channel business type,
99,liquidnet_wac,BASE TABLE,InnoDB,fin_wl_n10,4,FBT13,varchar(50),YES,,biz_trade.trade_type,Wallet API interaction trade type,API model class name
100,liquidnet_wac,BASE TABLE,InnoDB,fin_wl_n10,5,FBT14,int(5),YES,,biz_trade.trade_status,Wallet API interaction trade status,"Default:1 (0:PROCESSING,1:SUCCESS,2:FAILED)"
101,liquidnet_wac,BASE TABLE,InnoDB,fin_wl_n10,6,FBT15,datetime,YES,,biz_trade.create_time,,
102,liquidnet_wac,BASE TABLE,InnoDB,fin_wl_n10,7,FBT16,datetime,YES,,biz_trade.update_time,,
103,liquidnet_wac,BASE TABLE,InnoDB,fin_wl_n10,8,FBT17,varchar(2048),YES,,biz_trade.additional,Wallet API interaction trade additional parameters,API model class parameter value
104,liquidnet_wac,BASE TABLE,InnoDB,fin_wl_n10,9,FBT18,varchar(255),YES,,biz_trade.remark,# Wallet reserved field,
