工作單 #255
是由 martin zhuo 於 8 個月 前更新
彙整veriid 模型使用哪些postgresql table 及 elasticsearch index有哪些資料需修改 表有部分column名稱重複、牽涉學習系統使用的column名稱、配合台北時區時間欄位需+8 # ## account takeover: ### postgresql table: * tb_account_takeover_info > logstash: > remove_field => ["@version","@timestamp"] > gsub => ["create_time","Z",""] > update => {"create_time" => "%{create_time}+08:00"} * tb_account_takeover_predict_abnormalLogin_result > logstash: > rename => {"account_takeover_aph_score" => "abnormalLogin_account_takeover_aph_score"} > rename => {"account_takeover_reason" => "abnormalLogin_account_takeover_reason"} > rename => {"account_takeover_return_code" => "abnormalLogin_account_takeover_return_code"} > rename => {"account_takeover_score" => "abnormalLogin_account_takeover_score"} > rename => {"account_takeover_weight" => "abnormalLogin_account_takeover_weight"} > rename => {"ato_info_id" => "abnormalLogin_ato_info_id"} > rename => {"pk_id" => "abnormalLogin_pk_id"} > rename => {"policy_score" => "abnormalLogin_policy_score"} > rename => {"total_score" => "abnormalLogin_total_score"} * tb_account_takeover_predict_accountTest_result > logstash: > rename => {"account_takeover_aph_score" => "accountTest_account_takeover_aph_score"} > rename => {"account_takeover_reason" => "accountTest_account_takeover_reason"} > rename => {"account_takeover_return_code" => "accountTest_account_takeover_return_code"} > rename => {"account_takeover_score" => "accountTest_account_takeover_score"} > rename => {"account_takeover_weight" => "accountTest_account_takeover_weight"} > rename => {"ato_info_id" => "accountTest_ato_info_id"} > rename => {"pk_id" => "accountTest_pk_id"} > rename => {"policy_score" => "accountTest_policy_score"} > rename => {"total_score" => "accountTest_total_score"} ### elasticsearch index: veri_id_aws_prd_tb_model_account_takeover_predict_data_v2.0 # ## fraud detect: ### postgresql table: tb_fraud_detect_info tb_fraud_detect_predict_result ### elasticsearch index: veri_id_aws_prd_tb_model_fraud_detect_predict_data_v2.0 # ## card abnormal: ### postgresql table: tb_card_abnormal_v2 tb_card_abnormal_info tb_card_abnormal_predict_result ### elasticsearch index: veri_id_aws_prd_tb_model_card_abnormal_predict_data_v2.0 # ## card testing: ### elasticsearch index: veri_id_aws_prd_tb_model_card_testing_predict_data_v2.0