nao devタヅナリンク

Database

データベース仕様

タヅナリンクで構築されるMySQLのテーブルとビュー、各カラムの仕様をまとめています。

127 tables / 11 views / Updated 2026-11-11

DB仕様ファイル(最新版)

生成AIにSQL作成を相談する際は、DB仕様ZIPを添付してください。実際のテーブル名やカラム名を確認しながら、分析に必要なSQLを作成するための資料として使えます。

タヅナリンクが使用する全テーブル・ビューのカラム定義です。テーブルは論理名・物理名・データ型と、共通項目のJVDataとの対応を掲載しています。ビューはカラム名・データ型・説明で構成しています。

Table categories

core

レース・出走馬の事前情報と結果、WIN5の対象レース・払戻を保存します。

dim

開催、競走馬、騎手、調教師、血統、コースなどのマスタ情報です。

aux

調教、オッズ、払戻、マイニング、速報、出走時点情報、独自のペース情報を保存します。

tav

基準時計とコース・クラス・馬場状態・開催日馬場差などの補正値、レース補正を管理します。

taf

補正した時計を基にした馬ごとの能力スナップショットと公開状態を管理します。

tfs

出走メンバー内の相対比較など、レース単位・出走馬単位の特徴量を保存します。

tai_h

総合的な独自能力値の計算・公開に関するデータを保存します。

ability

計算済み能力値の取り込み元、対象範囲、公開状態などを管理します。

audit

データ取得の処理件数、警告、エラーなどの監査記録です。

config

取得位置、セットアップ・再開、補完待ち、スキーマ適用状態などを管理します。

user

予想印、レース・馬メモ、注目馬、フリーメモ、購入記録を保存します。

maintenance

ペース計算の実行管理や競走馬プロフィールの補完管理などを保存します。

Table list

127テーブルを表示

テーブル名を選ぶと全カラムを開きます。コード一覧のある行は、行全体を選択できます。幅が足りない表だけ横スクロールできます。

core

レース基本情報core_ra_race23 fields
論理名物理名データ型データ種別レコード種別JVData項目名
レースIDrace_idBIGINT
スケジュールIDschedule_idBIGINT
レース範囲区分race_scope_cdTINYINT UNSIGNEDDIFN/RACERAデータ区分から派生
開催日race_dateDATEDIFN/RACERA受け入れたRAレコードの開催年 + 開催月日(代替開催時は実開催日)
競馬場コードracecourse_cdCHAR(2)DIFN/RACERA競馬場コード
開催回meeting_noTINYINT UNSIGNEDDIFN/RACERA開催回
開催日目schedule_day_noTINYINT UNSIGNEDDIFN/RACERA開催日目
レース番号race_noTINYINT UNSIGNEDDIFN/RACERAレース番号
レース中止フラグis_cancelledTINYINT(1)DIFN/RACERA同一開催日のデータ区分9から派生。代替開催日の通常データは旧開催日の中止情報より優先
競走名本題race_name_mainVARCHAR(60)DIFN/RACERA競走名本題
グレードコードgrade_cdCHAR(1)DIFN/RACERAグレードコード
競走種別コードrace_type_cdCHAR(2)DIFN/RACERA競走種別コード
競走記号コードrace_symbol_cdCHAR(3)DIFN/RACERA競走記号コード
重量種別コードweight_type_cdCHAR(1)DIFN/RACERA重量種別コード
競走条件コード 2歳condition_cd_2yoCHAR(3)DIFN/RACERA競走条件コード 2歳
競走条件コード 3歳condition_cd_3yoCHAR(3)DIFN/RACERA競走条件コード 3歳
競走条件コード 4歳condition_cd_4yoCHAR(3)DIFN/RACERA競走条件コード 4歳
競走条件コード 5歳以上condition_cd_5upCHAR(3)DIFN/RACERA競走条件コード 5歳以上
競走条件コード 最若年condition_cd_youngestCHAR(3)DIFN/RACERA競走条件コード 最若年
距離distance_mSMALLINT UNSIGNEDDIFN/RACERA距離
トラックコードtrack_cdCHAR(2)DIFN/RACERAトラックコード
コース区分course_cdCHAR(2)DIFN/RACERAコース区分
発走予定時刻scheduled_start_timeTIMEDIFN/RACERA発走予定時刻
コーナー通過情報core_ra_race_corner5 fields
論理名物理名データ型データ種別レコード種別JVData項目名
レースIDrace_idBIGINT
配列順corner_seq_noTINYINT UNSIGNEDDIFN/RACERA配列順
コーナーcorner_noTINYINT UNSIGNEDDIFN/RACERAコーナー
周回数lap_countTINYINT UNSIGNEDDIFN/RACERA周回数
各通過順位passing_order_rawVARCHAR(70)DIFN/RACERA各通過順位
レースラップcore_ra_race_lap4 fields
論理名物理名データ型データ種別レコード種別JVData項目名
レースIDrace_idBIGINT
ラップ連番lap_noTINYINT UNSIGNEDDIFN/RACERAラップ連番
区間距離lap_distance_mSMALLINT UNSIGNEDDIFN/RACERA区間距離
先頭馬ラップタイムlap_time_secDECIMAL(4,1)DIFN/RACERA先頭馬ラップタイム
レース結果情報core_ra_race_result10 fields
論理名物理名データ型データ種別レコード種別JVData項目名
レースIDrace_idBIGINT
出走頭数starter_countTINYINT UNSIGNEDDIFN/RACERA出走頭数
入線頭数finisher_countTINYINT UNSIGNEDDIFN/RACERA入線頭数
天候コードweather_cdCHAR(1)DIFN/RACERA天候コード
芝馬場状態コードturf_condition_cdCHAR(1)DIFN/RACERA芝馬場状態コード
ダート馬場状態コードdirt_condition_cdCHAR(1)DIFN/RACERAダート馬場状態コード
前3ハロンfirst_3f_secDECIMAL(4,1)DIFN/RACERA前3ハロン
前4ハロンfirst_4f_secDECIMAL(4,1)DIFN/RACERA前4ハロン
後3ハロンlast_3f_secDECIMAL(4,1)DIFN/RACERA後3ハロン
後4ハロンlast_4f_secDECIMAL(4,1)DIFN/RACERA後4ハロン
出走馬事前情報core_se_race_horse17 fields
論理名物理名データ型データ種別レコード種別JVData項目名
出走馬IDrace_horse_idBIGINT
レースIDrace_idBIGINT
競走馬IDhorse_idBIGINT
枠番frame_noTINYINT UNSIGNEDDIFN/RACESE枠番
馬番horse_noTINYINT UNSIGNEDDIFN/RACESE馬番
馬記号コードhorse_symbol_cdCHAR(2)DIFN/RACESE馬記号コード
性別コードsex_cdCHAR(1)DIFN/RACESE性別コード
品種コードbreed_cdCHAR(1)DIFN/RACESE品種コード
毛色コードcoat_color_cdCHAR(2)DIFN/RACESE毛色コード
馬齢horse_ageTINYINT UNSIGNEDDIFN/RACESE馬齢
東西所属コードaffiliation_cdCHAR(1)DIFN/RACESE東西所属コード
調教師コードtrainer_cdCHAR(5)DIFN/RACESE調教師コード
馬主コードowner_cdCHAR(6)DIFN/RACESE馬主コード
負担重量carried_weight_kgDECIMAL(4,1)DIFN/RACESE負担重量
ブリンカー使用区分is_blinkerTINYINT(1)DIFN/RACESEブリンカー使用区分
騎手コードjockey_cdCHAR(5)DIFN/RACESE騎手コード
騎手見習コードapprentice_cdCHAR(1)DIFN/RACESE騎手見習コード
出走馬結果情報core_se_race_horse_result25 fields
論理名物理名データ型データ種別レコード種別JVData項目名
出走馬IDrace_horse_idBIGINT
馬体重body_weight_kgSMALLINT UNSIGNEDDIFN/RACESE馬体重
斤量負担率(百分率、小数第3位以降切り捨て)carried_weight_ratio_pctDECIMAL(4,2)
馬体重増減body_weight_diff_kgSMALLINTDIFN/RACESE増減符号 + 増減差
異常区分コードabnormality_cdCHAR(1)DIFN/RACESE異常区分コード
入線順位arrival_orderTINYINT UNSIGNEDDIFN/RACESE入線順位
確定着順finish_orderTINYINT UNSIGNEDDIFN/RACESE確定着順
同着区分is_dead_heatTINYINT(1)DIFN/RACESE同着区分
同着頭数dead_heat_count_otherTINYINT UNSIGNEDDIFN/RACESE同着頭数
走破タイムfinish_time_secDECIMAL(5,1)DIFN/RACESE走破タイム
着差コードmargin_cdCHAR(3)DIFN/RACESE着差コード
着差コード秒換算margin_secDECIMAL(5,2)DIFN/RACESE定義済みの着差コードを秒換算。未定義形式はNULL
+着差コードmargin_plus_cdCHAR(3)DIFN/RACESE+着差コード
+着差コード秒換算margin_plus_secDECIMAL(5,2)DIFN/RACESE着差コードと同じ規則で秒換算。未定義形式はNULL
++着差コードmargin_plus_plus_cdCHAR(3)DIFN/RACESE++着差コード
++着差コード秒換算margin_plus_plus_secDECIMAL(5,2)DIFN/RACESE着差コードと同じ規則で秒換算。未定義形式はNULL
1コーナー順位corner1_orderTINYINT UNSIGNEDDIFN/RACESE1コーナー順位
2コーナー順位corner2_orderTINYINT UNSIGNEDDIFN/RACESE2コーナー順位
3コーナー順位corner3_orderTINYINT UNSIGNEDDIFN/RACESE3コーナー順位
4コーナー順位corner4_orderTINYINT UNSIGNEDDIFN/RACESE4コーナー順位
後4ハロンタイムlast_4f_secDECIMAL(4,1)DIFN/RACESE後4ハロンタイム
後3ハロンタイムlast_3f_secDECIMAL(4,1)DIFN/RACESE後3ハロンタイム
同一平地レース内の後3ハロン競技順位last_3f_rankTINYINT UNSIGNED
タイム差time_diff_secDECIMAL(5,1)DIFN/RACESEタイム差
今回レース脚質判定running_style_cdCHAR(1)DIFN/RACESE今回レース脚質判定
WIN5開催情報core_wf_win511 fields
論理名物理名データ型データ種別レコード種別JVData項目名
meeting_datemeeting_dateDATE
data_kubun_cddata_kubun_cdCHAR(1)
source_data_spec_cdsource_data_spec_cdVARCHAR(4)
source_created_datesource_created_dateDATE
source_sha256source_sha256CHAR(64)
sales_ticket_countsales_ticket_countBIGINT UNSIGNED
refund_flagrefund_flagCHAR(1)
invalid_flaginvalid_flagCHAR(1)
no_winner_flagno_winner_flagCHAR(1)
initial_carryover_yeninitial_carryover_yenBIGINT UNSIGNED
next_carryover_yennext_carryover_yenBIGINT UNSIGNED
WIN5対象レースcore_wf_win5_leg7 fields
論理名物理名データ型データ種別レコード種別JVData項目名
meeting_datemeeting_dateDATE
leg_noleg_noTINYINT UNSIGNED
venue_cdvenue_cdCHAR(2)
meeting_nomeeting_noTINYINT UNSIGNED
meeting_day_nomeeting_day_noTINYINT UNSIGNED
race_norace_noTINYINT UNSIGNED
valid_ticket_countvalid_ticket_countBIGINT UNSIGNED
WIN5払戻情報core_wf_win5_payout5 fields
論理名物理名データ型データ種別レコード種別JVData項目名
meeting_datemeeting_dateDATE
payout_slot_nopayout_slot_noSMALLINT UNSIGNED
selection_keyselection_keyCHAR(10)
payout_yenpayout_yenBIGINT UNSIGNED
winning_ticket_countwinning_ticket_countBIGINT UNSIGNED

dim

馬主マスタdim_bn_owner3 fields
論理名物理名データ型データ種別レコード種別JVData項目名
馬主IDowner_idBIGINT
馬主コードowner_cdCHAR(6)DIFNBN馬主コード
馬主名(法人格有)owner_nameVARCHAR(64)DIFNBN馬主名(法人格有)
生産者マスタdim_br_breeder3 fields
論理名物理名データ型データ種別レコード種別JVData項目名
生産者IDbreeder_idBIGINT
生産者コードbreeder_cdCHAR(8)DIFNBR生産者コード
生産者名(法人格有)breeder_nameVARCHAR(72)DIFNBR生産者名(法人格有)
系統情報dim_bt_lineage5 fields
論理名物理名データ型データ種別レコード種別JVData項目名
breeding_reg_nobreeding_reg_noCHAR(10)
lineage_idlineage_idCHAR(30)
lineage_namelineage_nameVARCHAR(36)
lineage_descriptionlineage_descriptionTEXT
source_created_datesource_created_dateDATE
調教師マスタdim_ch_trainer7 fields
論理名物理名データ型データ種別レコード種別JVData項目名
調教師IDtrainer_idBIGINT
調教師コードtrainer_cdCHAR(5)DIFNCH調教師コード
調教師名trainer_nameVARCHAR(34)DIFNCH調教師名
生年月日birth_dateDATEDIFNCH生年月日
調教師免許交付年月日license_issued_dateDATEDIFNCH調教師免許交付年月日
性別区分sex_cdCHAR(1)DIFNCH性別区分
affiliation_cdaffiliation_cdCHAR(1)
コース構成マスタdim_cs_course_layout5 fields
論理名物理名データ型データ種別レコード種別JVData項目名
コース構成IDcourse_layout_idBIGINT
競馬場コードracecourse_cdCHAR(2)COMMCS競馬場コード
距離distance_mSMALLINT UNSIGNEDCOMMCS距離
トラックコードtrack_cdCHAR(2)COMMCSトラックコード
コース改修年月日renovated_dateDATECOMMCSコース改修年月日
繁殖馬マスタdim_hn_breeding_horse13 fields
論理名物理名データ型データ種別レコード種別JVData項目名
繁殖馬IDbreeding_horse_idBIGINT
繁殖登録番号breeding_reg_noCHAR(10)BLDNHN繁殖登録番号
血統登録番号horse_reg_noCHAR(10)BLDNHN血統登録番号
馬名breeding_horse_nameVARCHAR(36)BLDNHN馬名
生年birth_yearSMALLINT UNSIGNEDBLDNHN生年
性別コードsex_cdCHAR(1)BLDNHN性別コード
品種コードbreed_cdCHAR(1)BLDNHN品種コード
毛色コードcoat_color_cdCHAR(2)BLDNHN毛色コード
繁殖馬持込区分import_type_cdCHAR(1)BLDNHN繁殖馬持込区分
輸入年import_yearSMALLINT UNSIGNEDBLDNHN輸入年
産地名origin_nameVARCHAR(20)BLDNHN産地名
父馬繁殖登録番号sire_breeding_reg_noCHAR(10)BLDNHN父馬繁殖登録番号
母馬繁殖登録番号dam_breeding_reg_noCHAR(10)BLDNHN母馬繁殖登録番号
騎手マスタdim_ks_jockey7 fields
論理名物理名データ型データ種別レコード種別JVData項目名
騎手IDjockey_idBIGINT
騎手コードjockey_cdCHAR(5)DIFNKS騎手コード
騎手名jockey_nameVARCHAR(34)DIFNKS騎手名
生年月日birth_dateDATEDIFNKS生年月日
騎手免許交付年月日license_issued_dateDATEDIFNKS騎手免許交付年月日
性別区分sex_cdCHAR(1)DIFNKS性別区分
affiliation_cdaffiliation_cdCHAR(1)
産駒情報dim_sk_offspring10 fields
論理名物理名データ型データ種別レコード種別JVData項目名
horse_reg_nohorse_reg_noCHAR(10)
birth_datebirth_dateDATE
sex_cdsex_cdCHAR(1)
breed_cdbreed_cdCHAR(1)
coat_color_cdcoat_color_cdCHAR(2)
import_type_cdimport_type_cdCHAR(1)
import_yearimport_yearSMALLINT UNSIGNED
breeder_cdbreeder_cdCHAR(8)
origin_nameorigin_nameVARCHAR(20)
source_created_datesource_created_dateDATE
産駒祖先情報dim_sk_offspring_ancestor3 fields
論理名物理名データ型データ種別レコード種別JVData項目名
horse_reg_nohorse_reg_noCHAR(10)
ancestor_slotancestor_slotTINYINT UNSIGNED
breeding_reg_nobreeding_reg_noCHAR(10)
競走馬マスタdim_um_horse4 fields
論理名物理名データ型データ種別レコード種別JVData項目名
競走馬IDhorse_idBIGINT
血統登録番号horse_reg_noCHAR(10)DIFNUM血統登録番号
馬名horse_nameVARCHAR(36)DIFNUM馬名
生年月日birth_dateDATEDIFNUM生年月日
開催スケジュールdim_ys_schedule8 fields
論理名物理名データ型データ種別レコード種別JVData項目名
スケジュールIDschedule_idBIGINT
開催年schedule_yearSMALLINT UNSIGNEDYSCHYS開催年
開催日race_dateDATEYSCHYS受け入れたYSレコードの開催年 + 開催月日(代替開催時は新しい開催日)
競馬場コードracecourse_cdCHAR(2)YSCHYS競馬場コード
開催回meeting_noTINYINT UNSIGNEDYSCHYS開催回
開催日目schedule_day_noTINYINT UNSIGNEDYSCHYS開催日目
開催状態コードschedule_status_cdTINYINT UNSIGNEDYSCHYSデータ区分から派生
開催中止フラグis_cancelledTINYINT(1)YSCHYS同一開催日のデータ区分9から派生。代替開催日の通常データは旧開催日の中止情報より優先

aux

速報出走取消・競走除外aux_av_prerace_race_horse_status7 fields
論理名物理名データ型データ種別レコード種別JVData項目名
速報出走状態IDav_prerace_race_horse_status_idBIGINT
レースIDrace_idBIGINT
出走馬IDrace_horse_idBIGINT
馬番horse_noTINYINT UNSIGNED0B14AV馬番
発表日時announced_atDATETIME0B14AV発表月日時分
異常区分コードabnormality_cdCHAR(1)0B14AVデータ区分
異常事由コードabnormality_reason_cdCHAR(3)0B14AV事由区分
速報コース変更aux_cc_prerace_course_change5 fields
論理名物理名データ型データ種別レコード種別JVData項目名
速報コース変更IDcc_prerace_course_change_idBIGINT
レースIDrace_idBIGINT
発表日時announced_atDATETIME0B14CC発表月日時分
変更後距離distance_mSMALLINT UNSIGNED0B14CC変更後情報の距離
変更後トラックコードtrack_cdCHAR(2)0B14CC変更後情報のトラックコード
競走馬出走時点スナップショットaux_ck_horse9 fields
論理名物理名データ型データ種別レコード種別JVData項目名
競走馬CK IDck_horse_idBIGINT
出走馬IDrace_horse_idBIGINT
平地本賞金累計flat_main_prize_yenBIGINT UNSIGNEDSNPNCK平地本賞金累計
障害本賞金累計jump_main_prize_yenBIGINT UNSIGNEDSNPNCK障害本賞金累計
平地付加賞金累計flat_added_prize_yenBIGINT UNSIGNEDSNPNCK平地付加賞金累計
障害付加賞金累計jump_added_prize_yenBIGINT UNSIGNEDSNPNCK障害付加賞金累計
平地収得賞金累計flat_earned_prize_yenBIGINT UNSIGNEDSNPNCK平地収得賞金累計
障害収得賞金累計jump_earned_prize_yenBIGINT UNSIGNEDSNPNCK障害収得賞金累計
登録レース数registered_race_countSMALLINT UNSIGNEDSNPNCK登録レース数
競走馬着度数aux_ck_horse_finish10 fields
論理名物理名データ型データ種別レコード種別JVData項目名
競走馬着度数IDck_horse_finish_count_idBIGINT
競走馬CK IDck_horse_idBIGINT
着度数分類コードfinish_count_category_cdVARCHAR(32)
着度数条件コードfinish_count_condition_cdVARCHAR(32)
1着回数first_countSMALLINT UNSIGNEDSNPNCK1着回数
2着回数second_countSMALLINT UNSIGNEDSNPNCK2着回数
3着回数third_countSMALLINT UNSIGNEDSNPNCK3着回数
4着回数fourth_countSMALLINT UNSIGNEDSNPNCK4着回数
5着回数fifth_countSMALLINT UNSIGNEDSNPNCK5着回数
着外回数other_countSMALLINT UNSIGNEDSNPNCK着外回数
競走馬脚質傾向aux_ck_horse_style6 fields
論理名物理名データ型データ種別レコード種別JVData項目名
競走馬脚質傾向IDck_horse_running_style_idBIGINT
競走馬CK IDck_horse_idBIGINT
逃げ回数nige_countSMALLINT UNSIGNEDSNPNCK逃げ回数
先行回数senko_countSMALLINT UNSIGNEDSNPNCK先行回数
差し回数sashi_countSMALLINT UNSIGNEDSNPNCK差し回数
追込回数oikomi_countSMALLINT UNSIGNEDSNPNCK追込回数
騎手出走時点スナップショットaux_ck_jockey9 fields
論理名物理名データ型データ種別レコード種別JVData項目名
騎手CK IDck_jockey_idBIGINT
騎手IDjockey_idBIGINT
取得元出走馬IDsource_race_horse_idBIGINT
集計範囲コードstats_scope_cdTINYINT UNSIGNED
設定年stats_yearSMALLINT UNSIGNEDSNPNCK設定年
平地本賞金合計flat_main_prize_yenBIGINT UNSIGNEDSNPNCK平地本賞金合計
障害本賞金合計jump_main_prize_yenBIGINT UNSIGNEDSNPNCK障害本賞金合計
平地付加賞金合計flat_added_prize_yenBIGINT UNSIGNEDSNPNCK平地付加賞金合計
障害付加賞金合計jump_added_prize_yenBIGINT UNSIGNEDSNPNCK障害付加賞金合計
騎手着度数aux_ck_jockey_finish10 fields
論理名物理名データ型データ種別レコード種別JVData項目名
騎手着度数IDck_jockey_finish_count_idBIGINT
騎手CK IDck_jockey_idBIGINT
着度数分類コードfinish_count_category_cdVARCHAR(32)
着度数条件コードfinish_count_condition_cdVARCHAR(32)
1着回数first_countMEDIUMINT UNSIGNEDSNPNCK1着回数
2着回数second_countMEDIUMINT UNSIGNEDSNPNCK2着回数
3着回数third_countMEDIUMINT UNSIGNEDSNPNCK3着回数
4着回数fourth_countMEDIUMINT UNSIGNEDSNPNCK4着回数
5着回数fifth_countMEDIUMINT UNSIGNEDSNPNCK5着回数
着外回数other_countMEDIUMINT UNSIGNEDSNPNCK着外回数
調教師出走時点スナップショットaux_ck_trainer9 fields
論理名物理名データ型データ種別レコード種別JVData項目名
調教師CK IDck_trainer_idBIGINT
調教師IDtrainer_idBIGINT
取得元出走馬IDsource_race_horse_idBIGINT
集計範囲コードstats_scope_cdTINYINT UNSIGNED
設定年stats_yearSMALLINT UNSIGNEDSNPNCK設定年
平地本賞金合計flat_main_prize_yenBIGINT UNSIGNEDSNPNCK平地本賞金合計
障害本賞金合計jump_main_prize_yenBIGINT UNSIGNEDSNPNCK障害本賞金合計
平地付加賞金合計flat_added_prize_yenBIGINT UNSIGNEDSNPNCK平地付加賞金合計
障害付加賞金合計jump_added_prize_yenBIGINT UNSIGNEDSNPNCK障害付加賞金合計
調教師着度数aux_ck_trainer_finish10 fields
論理名物理名データ型データ種別レコード種別JVData項目名
調教師着度数IDck_trainer_finish_count_idBIGINT
調教師CK IDck_trainer_idBIGINT
着度数分類コードfinish_count_category_cdVARCHAR(32)
着度数条件コードfinish_count_condition_cdVARCHAR(32)
1着回数first_countMEDIUMINT UNSIGNEDSNPNCK1着回数
2着回数second_countMEDIUMINT UNSIGNEDSNPNCK2着回数
3着回数third_countMEDIUMINT UNSIGNEDSNPNCK3着回数
4着回数fourth_countMEDIUMINT UNSIGNEDSNPNCK4着回数
5着回数fifth_countMEDIUMINT UNSIGNEDSNPNCK5着回数
着外回数other_countMEDIUMINT UNSIGNEDSNPNCK着外回数
予想タイム指数aux_dm_mining9 fields
論理名物理名データ型データ種別レコード種別JVData項目名
予想タイム指数IDdm_mining_idBIGINT
レースIDrace_idBIGINT
馬番horse_noTINYINT UNSIGNEDMING/0B13DM馬番
出走馬IDrace_horse_idBIGINT
データ作成時分data_creation_timeTIMEMING/0B13DMデータ作成時分
予想走破タイムpredicted_finish_time_secDECIMAL(5,2)MING/0B13DM予想走破タイム
予想誤差(信頼度)+predicted_error_plus_secDECIMAL(4,2)MING/0B13DM予想誤差(信頼度)+
予想誤差(信頼度)-predicted_error_minus_secDECIMAL(4,2)MING/0B13DM予想誤差(信頼度)-
坂路調教aux_hc_training11 fields
論理名物理名データ型データ種別レコード種別JVData項目名
坂路調教IDhc_training_idBIGINT
血統登録番号horse_reg_noCHAR(10)SLOPHC血統登録番号
トレセン区分training_center_cdCHAR(1)SLOPHCトレセン区分
調教日時training_datetimeDATETIMESLOPHC調教日時
4ハロンタイム合計(800M~0M)total_4f_secDECIMAL(4,1)SLOPHC4ハロンタイム合計(800M~0M)
ラップタイム(800M~600M)lap_800_600_secDECIMAL(3,1)SLOPHCラップタイム(800M~600M)
3ハロンタイム合計(600M~0M)total_3f_secDECIMAL(4,1)SLOPHC3ハロンタイム合計(600M~0M)
ラップタイム(600M~400M)lap_600_400_secDECIMAL(3,1)SLOPHCラップタイム(600M~400M)
2ハロンタイム合計(400M~0M)total_2f_secDECIMAL(4,1)SLOPHC2ハロンタイム合計(400M~0M)
ラップタイム(400M~200M)lap_400_200_secDECIMAL(3,1)SLOPHCラップタイム(400M~200M)
ラップタイム(200M~0M)lap_200_0_secDECIMAL(3,1)SLOPHCラップタイム(200M~0M)
払戻明細aux_hr_payout_detail9 fields
論理名物理名データ型データ種別レコード種別JVData項目名
払戻明細IDhr_payout_detail_idBIGINT
払戻ヘッダIDhr_payout_header_idBIGINT
払戻配列内連番payout_seq_noTINYINT UNSIGNEDRACEHR払戻配列内連番
組番selection_keyCHAR(6)RACEHR組番
選択番号1selection_no_1TINYINT UNSIGNEDRACEHR選択番号1
選択番号2selection_no_2TINYINT UNSIGNEDRACEHR選択番号2
選択番号3selection_no_3TINYINT UNSIGNEDRACEHR選択番号3
払戻金payout_amount_yenBIGINT UNSIGNEDRACEHR払戻金
人気順popularity_rankSMALLINT UNSIGNEDRACEHR人気順
払戻ヘッダaux_hr_payout_header6 fields
論理名物理名データ型データ種別レコード種別JVData項目名
払戻ヘッダIDhr_payout_header_idBIGINT
レースIDrace_idBIGINT
不成立フラグis_invalidTINYINT(1)RACEHR不成立フラグ
特払フラグis_special_payoutTINYINT(1)RACEHR特払フラグ
返還フラグhas_refundTINYINT(1)RACEHR返還フラグ
速報払戻明細aux_hr_realtime_payout_detail9 fields
論理名物理名データ型データ種別レコード種別JVData項目名
速報払戻明細IDhr_realtime_payout_detail_idBIGINT
速報払戻ヘッダIDhr_realtime_payout_header_idBIGINT
払戻配列内連番payout_seq_noTINYINT UNSIGNED0B12HR払戻配列内連番
組番selection_keyCHAR(6)0B12HR組番
選択番号1selection_no_1TINYINT UNSIGNED0B12HR選択番号1
選択番号2selection_no_2TINYINT UNSIGNED0B12HR選択番号2
選択番号3selection_no_3TINYINT UNSIGNED0B12HR選択番号3
払戻金payout_amount_yenBIGINT UNSIGNED0B12HR払戻金
人気順popularity_rankSMALLINT UNSIGNED0B12HR人気順
速報払戻ヘッダaux_hr_realtime_payout_header8 fields
論理名物理名データ型データ種別レコード種別JVData項目名
速報払戻ヘッダIDhr_realtime_payout_header_idBIGINT
レースIDrace_idBIGINT
賭式コードbet_type_cdCHAR(2)0B12HR賭式
データ区分data_kubun_cdCHAR(1)0B12HRデータ区分
観測日時observed_atDATETIME
不成立フラグis_invalidTINYINT(1)0B12HR不成立フラグ
特払フラグis_special_payoutTINYINT(1)0B12HR特払フラグ
返還フラグhas_refundTINYINT(1)0B12HR返還フラグ
速報騎手変更aux_jc_prerace_jockey_change8 fields
論理名物理名データ型データ種別レコード種別JVData項目名
速報騎手変更IDjc_prerace_jockey_change_idBIGINT
レースIDrace_idBIGINT
出走馬IDrace_horse_idBIGINT
馬番horse_noTINYINT UNSIGNED0B14JC馬番
発表日時announced_atDATETIME0B14JC発表月日時分
変更後負担重量carried_weight_kgDECIMAL(4,1)0B14JC変更後情報の負担重量
変更後騎手コードjockey_cdCHAR(5)0B14JC変更後情報の騎手コード
変更後見習コードapprentice_cdCHAR(1)0B14JC変更後情報の騎手見習コード
確定オッズ明細aux_o1o6_odds_detail11 fields
論理名物理名データ型データ種別レコード種別JVData項目名
確定オッズ明細IDo1o6_odds_detail_idBIGINT
確定オッズヘッダIDo1o6_odds_header_idBIGINT
組番selection_keyCHAR(6)RACEO1-O6組番
選択番号1selection_no_1TINYINT UNSIGNEDRACEO1-O6選択番号1
選択番号2selection_no_2TINYINT UNSIGNEDRACEO1-O6選択番号2
選択番号3selection_no_3TINYINT UNSIGNEDRACEO1-O6選択番号3
通常オッズodds_valueDECIMAL(7,1)RACEO1-O6通常オッズ
最低オッズodds_minDECIMAL(7,1)RACEO1/O3最低オッズ
最高オッズodds_maxDECIMAL(7,1)RACEO1/O3最高オッズ
人気順popularity_rankSMALLINT UNSIGNEDRACEO1-O6人気順
オッズ状態コードodds_status_cdCHAR(1)
確定オッズヘッダaux_o1o6_odds_header3 fields
論理名物理名データ型データ種別レコード種別JVData項目名
確定オッズヘッダIDo1o6_odds_header_idBIGINT
レースIDrace_idBIGINT
速報オッズ明細aux_o1o6_prerace_odds_detail11 fields
論理名物理名データ型データ種別レコード種別JVData項目名
速報オッズ明細IDo1o6_prerace_odds_detail_idBIGINT
速報オッズヘッダIDo1o6_prerace_odds_header_idBIGINT
組番selection_keyCHAR(6)0B30O1-O6組番
選択番号1selection_no_1TINYINT UNSIGNED0B30O1-O6選択番号1
選択番号2selection_no_2TINYINT UNSIGNED0B30O1-O6選択番号2
選択番号3selection_no_3TINYINT UNSIGNED0B30O1-O6選択番号3
通常オッズodds_valueDECIMAL(7,1)0B30O1-O6通常オッズ
最低オッズodds_minDECIMAL(7,1)0B30O1/O3最低オッズ
最高オッズodds_maxDECIMAL(7,1)0B30O1/O3最高オッズ
人気順popularity_rankSMALLINT UNSIGNED0B30O1-O6人気順
オッズ状態コードodds_status_cdCHAR(1)
速報オッズヘッダaux_o1o6_prerace_odds_header5 fields
論理名物理名データ型データ種別レコード種別JVData項目名
速報オッズヘッダIDo1o6_prerace_odds_header_idBIGINT
レースIDrace_idBIGINT0B30O1-O6レースキー
データ区分data_kubun_cdCHAR(1)0B30O1-O6データ区分
発表日時announced_atDATETIME0B30O1-O6発表月日時分
レースペース判定aux_ra_race_pace23 fields
論理名物理名データ型データ種別レコード種別JVData項目名
race_idrace_idBIGINT
classification_status_cdclassification_status_cdVARCHAR(20)
pace_labelpace_labelVARCHAR(12)
feature_idfeature_idVARCHAR(64)
feature_value_secfeature_value_secDECIMAL(38,28)
feature_value_textfeature_value_textVARCHAR(80)
interpolated_flaginterpolated_flagTINYINT(1)
applied_rule_idapplied_rule_idVARCHAR(80)
fallback_route_jsonfallback_route_jsonJSON
lower_threshold_seclower_threshold_secDECIMAL(38,28)
upper_threshold_secupper_threshold_secDECIMAL(38,28)
not_classifiable_reason_cdnot_classifiable_reason_cdVARCHAR(64)
diagnostic_jsondiagnostic_jsonJSON
model_idmodel_idCHAR(64)
model_sha256model_sha256CHAR(64)
manifest_sha256manifest_sha256CHAR(64)
code_tables_sha256code_tables_sha256CHAR(64)
source_fingerprintsource_fingerprintCHAR(64)
business_value_sha256business_value_sha256CHAR(64)
pace_job_idpace_job_idBIGINT
calculated_atcalculated_atDATETIME(6)
created_atcreated_atDATETIME(6)
updated_atupdated_atDATETIME(6)
レースペース予測aux_ra_race_pace_prediction20 fields
論理名物理名データ型データ種別レコード種別JVData項目名
race_idrace_idBIGINT
statusstatusVARCHAR(20)
pace_labelpace_labelVARCHAR(12)
confidence_labelconfidence_labelVARCHAR(4)
base_confidence_labelbase_confidence_labelVARCHAR(4)
rule_idrule_idVARCHAR(40)
model_idmodel_idCHAR(64)
feature_idfeature_idCHAR(64)
confidence_idconfidence_idCHAR(64)
manifest_sha256manifest_sha256CHAR(64)
source_fingerprintsource_fingerprintCHAR(64)
scores_jsonscores_jsonJSON
evidence_jsonevidence_jsonJSON
feature_snapshot_jsonfeature_snapshot_jsonJSON
race_daterace_dateDATE
scheduled_start_timescheduled_start_timeTIME
predicted_atpredicted_atDATETIME(6)
reason_cdreason_cdVARCHAR(128)
created_atcreated_atDATETIME(6)
updated_atupdated_atDATETIME(6)
速報レースコーナー通過順aux_ra_realtime_race_corner5 fields
論理名物理名データ型データ種別レコード種別JVData項目名
レースIDrace_idBIGINT
コーナー連番corner_seq_noTINYINT UNSIGNED0B12RA配列順
コーナー番号corner_noTINYINT UNSIGNED0B12RAコーナー
周回数lap_countTINYINT UNSIGNED0B12RA周回数
通過順rawpassing_order_rawVARCHAR(70)0B12RA各通過順位
速報レースラップaux_ra_realtime_race_lap4 fields
論理名物理名データ型データ種別レコード種別JVData項目名
レースIDrace_idBIGINT
ラップ連番lap_noTINYINT UNSIGNED0B12RA配列順
区間距離lap_distance_mSMALLINT UNSIGNED0B12RA区間距離
ラップタイムlap_time_secDECIMAL(4,1)0B12RAラップタイム
速報レース結果aux_ra_realtime_race_result12 fields
論理名物理名データ型データ種別レコード種別JVData項目名
レースIDrace_idBIGINT
データ区分data_kubun_cdCHAR(1)0B12RAデータ区分
観測日時observed_atDATETIME
出走頭数starter_countTINYINT UNSIGNED0B12RA出走頭数
入線頭数finisher_countTINYINT UNSIGNED0B12RA入線頭数
天候コードweather_cdCHAR(1)0B12RA天候コード
芝馬場状態コードturf_condition_cdCHAR(1)0B12RA芝馬場状態コード
ダート馬場状態コードdirt_condition_cdCHAR(1)0B12RAダート馬場状態コード
前3ハロンfirst_3f_secDECIMAL(4,1)0B12RA前3ハロン
前4ハロンfirst_4f_secDECIMAL(4,1)0B12RA前4ハロン
後3ハロンlast_3f_secDECIMAL(4,1)0B12RA後3ハロン
後4ハロンlast_4f_secDECIMAL(4,1)0B12RA後4ハロン
速報出走馬結果aux_se_realtime_race_horse_result29 fields
論理名物理名データ型データ種別レコード種別JVData項目名
出走馬IDrace_horse_idBIGINT
レースIDrace_idBIGINT
馬番horse_noTINYINT UNSIGNED0B12SE馬番
データ区分data_kubun_cdCHAR(1)0B12SEデータ区分
観測日時observed_atDATETIME
馬体重body_weight_kgSMALLINT UNSIGNED0B12SE馬体重
斤量負担率(百分率、小数第3位以降切り捨て)carried_weight_ratio_pctDECIMAL(4,2)
馬体重増減body_weight_diff_kgSMALLINT0B12SE増減符号 + 増減差
異常区分コードabnormality_cdCHAR(1)0B12SE異常区分コード
入線順位arrival_orderTINYINT UNSIGNED0B12SE入線順位
確定着順finish_orderTINYINT UNSIGNED0B12SE確定着順
同着区分is_dead_heatTINYINT(1)0B12SE同着区分
同着頭数dead_heat_count_otherTINYINT UNSIGNED0B12SE同着頭数
走破タイムfinish_time_secDECIMAL(5,1)0B12SE走破タイム
着差コードmargin_cdCHAR(3)0B12SE着差コード
着差コード秒換算margin_secDECIMAL(5,2)0B12SE定義済みの着差コードを秒換算。未定義形式はNULL
+着差コードmargin_plus_cdCHAR(3)0B12SE+着差コード
+着差コード秒換算margin_plus_secDECIMAL(5,2)0B12SE着差コードと同じ規則で秒換算。未定義形式はNULL
++着差コードmargin_plus_plus_cdCHAR(3)0B12SE++着差コード
++着差コード秒換算margin_plus_plus_secDECIMAL(5,2)0B12SE着差コードと同じ規則で秒換算。未定義形式はNULL
1コーナー順位corner1_orderTINYINT UNSIGNED0B12SE1コーナー順位
2コーナー順位corner2_orderTINYINT UNSIGNED0B12SE2コーナー順位
3コーナー順位corner3_orderTINYINT UNSIGNED0B12SE3コーナー順位
4コーナー順位corner4_orderTINYINT UNSIGNED0B12SE4コーナー順位
後4ハロンタイムlast_4f_secDECIMAL(4,1)0B12SE後4ハロンタイム
後3ハロンタイムlast_3f_secDECIMAL(4,1)0B12SE後3ハロンタイム
同一平地レース内の後3ハロン競技順位last_3f_rankTINYINT UNSIGNED
タイム差time_diff_secDECIMAL(5,1)0B12SEタイム差
脚質判定コードrunning_style_cdCHAR(1)0B12SE脚質判定コード
速報発走時刻変更aux_tc_prerace_start_time_change4 fields
論理名物理名データ型データ種別レコード種別JVData項目名
速報発走時刻変更IDtc_prerace_start_time_change_idBIGINT
レースIDrace_idBIGINT
発表日時announced_atDATETIME0B14TC発表月日時分
変更後発走時刻scheduled_start_timeTIME0B14TC変更後情報の発走時刻
対戦型マイニングaux_tm_mining7 fields
論理名物理名データ型データ種別レコード種別JVData項目名
対戦型マイニングIDtm_mining_idBIGINT
レースIDrace_idBIGINT
馬番horse_noTINYINT UNSIGNEDMING/0B17TM馬番
出走馬IDrace_horse_idBIGINT
データ作成時分data_creation_timeTIMEMING/0B17TMデータ作成時分
予測スコアpredicted_scoreDECIMAL(4,1)MING/0B17TM予測スコア
競走馬条件別着度数aux_um_horse_finish8 fields
論理名物理名データ型データ種別レコード種別JVData項目名
horse_reg_nohorse_reg_noCHAR(10)
condition_cdcondition_cdVARCHAR(32)
first_countfirst_countSMALLINT UNSIGNED
second_countsecond_countSMALLINT UNSIGNED
third_countthird_countSMALLINT UNSIGNED
fourth_countfourth_countSMALLINT UNSIGNED
fifth_countfifth_countSMALLINT UNSIGNED
other_countother_countSMALLINT UNSIGNED
競走馬詳細情報aux_um_horse_profile6 fields
論理名物理名データ型データ種別レコード種別JVData項目名
horse_reg_nohorse_reg_noCHAR(10)
source_created_datesource_created_dateDATE
observed_atobserved_atDATETIME
source_prioritysource_priorityTINYINT UNSIGNED
revisionrevisionBIGINT UNSIGNED
profile_jsonprofile_jsonJSON
ウッドチップ調教aux_wc_training25 fields
論理名物理名データ型データ種別レコード種別JVData項目名
ウッドチップ調教IDwc_training_idBIGINT
血統登録番号horse_reg_noCHAR(10)WOODWC血統登録番号
トレセン区分training_center_cdCHAR(1)WOODWCトレセン区分
調教日時training_datetimeDATETIMEWOODWC調教日時
コースcourse_cdCHAR(1)WOODWCコース
馬場周りdirection_cdCHAR(1)WOODWC馬場周り
10ハロンタイム合計(2000M~0M)total_10f_secDECIMAL(4,1)WOODWC10ハロンタイム合計(2000M~0M)
ラップタイム(2000M~1800M)lap_2000_1800_secDECIMAL(3,1)WOODWCラップタイム(2000M~1800M)
9ハロンタイム合計(1800M~0M)total_9f_secDECIMAL(4,1)WOODWC9ハロンタイム合計(1800M~0M)
ラップタイム(1800M~1600M)lap_1800_1600_secDECIMAL(3,1)WOODWCラップタイム(1800M~1600M)
8ハロンタイム合計(1600M~0M)total_8f_secDECIMAL(4,1)WOODWC8ハロンタイム合計(1600M~0M)
ラップタイム(1600M~1400M)lap_1600_1400_secDECIMAL(3,1)WOODWCラップタイム(1600M~1400M)
7ハロンタイム合計(1400M~0M)total_7f_secDECIMAL(4,1)WOODWC7ハロンタイム合計(1400M~0M)
ラップタイム(1400M~1200M)lap_1400_1200_secDECIMAL(3,1)WOODWCラップタイム(1400M~1200M)
6ハロンタイム合計(1200M~0M)total_6f_secDECIMAL(4,1)WOODWC6ハロンタイム合計(1200M~0M)
ラップタイム(1200M~1000M)lap_1200_1000_secDECIMAL(3,1)WOODWCラップタイム(1200M~1000M)
5ハロンタイム合計(1000M~0M)total_5f_secDECIMAL(4,1)WOODWC5ハロンタイム合計(1000M~0M)
ラップタイム(1000M~800M)lap_1000_800_secDECIMAL(3,1)WOODWCラップタイム(1000M~800M)
4ハロンタイム合計(800M~0M)total_4f_secDECIMAL(4,1)WOODWC4ハロンタイム合計(800M~0M)
ラップタイム(800M~600M)lap_800_600_secDECIMAL(3,1)WOODWCラップタイム(800M~600M)
3ハロンタイム合計(600M~0M)total_3f_secDECIMAL(4,1)WOODWC3ハロンタイム合計(600M~0M)
ラップタイム(600M~400M)lap_600_400_secDECIMAL(3,1)WOODWCラップタイム(600M~400M)
2ハロンタイム合計(400M~0M)total_2f_secDECIMAL(4,1)WOODWC2ハロンタイム合計(400M~0M)
ラップタイム(400M~200M)lap_400_200_secDECIMAL(3,1)WOODWCラップタイム(400M~200M)
ラップタイム(200M~0M)lap_200_0_secDECIMAL(3,1)WOODWCラップタイム(200M~0M)
速報天候・馬場状態aux_we_prerace_weather_track_condition7 fields
論理名物理名データ型データ種別レコード種別JVData項目名
速報天候馬場IDwe_prerace_weather_track_condition_idBIGINT
レースIDrace_idBIGINT
天候コードweather_cdCHAR(1)0B14WE天候コード
天候発表日時weather_announced_atDATETIME0B14WE発表月日時分
芝馬場状態コードturf_condition_cdCHAR(1)0B14WE芝馬場状態コード
ダート馬場状態コードdirt_condition_cdCHAR(1)0B14WEダート馬場状態コード
馬場発表日時track_condition_announced_atDATETIME0B14WE発表月日時分
速報馬体重aux_wh_prerace_body_weight9 fields
論理名物理名データ型データ種別レコード種別JVData項目名
速報馬体重IDwh_prerace_body_weight_idBIGINT
レースIDrace_idBIGINT0B11WHレースキー
出走馬IDrace_horse_idBIGINT
馬番horse_noTINYINT UNSIGNED0B11WH馬番
発表日時announced_atDATETIME0B11WH発表月日時分
馬体重body_weight_kgSMALLINT UNSIGNED0B11WH馬体重
斤量負担率(百分率、小数第3位以降切り捨て)carried_weight_ratio_pctDECIMAL(4,2)
増減差body_weight_diff_kgSMALLINT0B11WH増減差
馬体重状態コードbody_weight_status_cdTINYINT UNSIGNED

tav

TAV変更検知キューtav_change_queue3 fields
論理名物理名データ型データ種別レコード種別JVData項目名
change_kindchange_kindCHAR(1)
core_race_idcore_race_idBIGINT
change_revisionchange_revisionBIGINT
クラス補正マスタtav_class_factor_master11 fields
論理名物理名データ型データ種別レコード種別JVData項目名
内部IDclass_factor_idBIGINT UNSIGNED
正規化サーフェス T/Dsurface_cdCHAR(1)
距離kyoriINT
年齢帯 2YO/3YO/3UP/4UPage_group_cdVARCHAR(8)
正規化クラス分類normalized_class_cdVARCHAR(16)
クラス補正キー surface_age_classclass_factor_keyVARCHAR(64)
クラス補正 秒class_factor_secDECIMAL(8,3)
採用サンプル数sample_countINT
備考noteVARCHAR(255)
作成日時created_atDATETIME
更新日時updated_atDATETIME
コース補正マスタtav_course_factor_master10 fields
論理名物理名データ型データ種別レコード種別JVData項目名
内部IDcourse_factor_idBIGINT UNSIGNED
競馬場コードjyo_cdCHAR(2)
トラックコードtrack_cdCHAR(2)
正規化サーフェス T/Dsurface_cdCHAR(1)
距離kyoriINT
コース補正 秒course_factor_secDECIMAL(8,3)
採用サンプル数sample_countINT
備考noteVARCHAR(255)
作成日時created_atDATETIME
更新日時updated_atDATETIME
品質監査issuetav_data_quality_issue6 fields
論理名物理名データ型データ種別レコード種別JVData項目名
issue IDissue_idBIGINT UNSIGNED
race単位issueの場合のtav_race.race_idrace_idBIGINT UNSIGNED
issue種別issue_typeVARCHAR(64)
人が読む説明issue_messageVARCHAR(255)
詳細文脈context_jsonJSON
作成日時created_atDATETIME
開催日馬場差tav_day_variant9 fields
論理名物理名データ型データ種別レコード種別JVData項目名
内部IDday_variant_idBIGINT UNSIGNED
開催日yyyymmddkaisai_dateCHAR(8)
競馬場コードjyo_cdCHAR(2)
正規化サーフェス T/Dsurface_cdCHAR(1)
開催日馬場差 秒day_variant_secDECIMAL(8,3)
採用サンプル数sample_countINT
備考noteVARCHAR(255)
作成日時created_atDATETIME
更新日時updated_atDATETIME
ジョブチャンク進捗tav_job_chunk16 fields
論理名物理名データ型データ種別レコード種別JVData項目名
チャンクIDchunk_idBIGINT UNSIGNED
親ジョブIDjob_idBIGINT UNSIGNED
ジョブ内連番chunk_noINT
単一レース対象時target_race_idBIGINT UNSIGNED
範囲開始 yyyymmddtarget_from_dateCHAR(8)
範囲終了 yyyymmddtarget_to_dateCHAR(8)
PENDING/RUNNING/SUCCESS/FAILEDstatusVARCHAR(16)
処理件数processed_countINT
成功件数success_countINT
警告件数warning_countINT
エラー件数error_countINT
最終エラーメッセージerror_messageTEXT
開始日時started_atDATETIME
終了日時finished_atDATETIME
作成日時created_atDATETIME
更新日時updated_atDATETIME
ジョブ実行履歴tav_job_run39 fields
論理名物理名データ型データ種別レコード種別JVData項目名
ジョブIDjob_idBIGINT UNSIGNED
RACE_ID/DATE_RANGE/RETRY_FAILEDrun_modeVARCHAR(16)
TAV計算仕様版calculation_versionVARCHAR(64)
信頼度校正artifact SHA-256calibration_checksumCHAR(64)
SETUP/NORMAL_UPDATE/MANUALtrigger_typeVARCHAR(16)
JV2AI64 setup run identity; SETUP onlysetup_run_idBIGINT
normal import or manual request identitysource_run_identityVARCHAR(64)
race-id指定値target_race_idBIGINT UNSIGNED
from指定値 yyyymmddtarget_from_dateCHAR(8)
to指定値 yyyymmddtarget_to_dateCHAR(8)
retry元job-idretry_source_job_idBIGINT UNSIGNED
effective from yyyymmddeffective_target_from_dateCHAR(8)
effective to yyyymmddeffective_target_to_dateCHAR(8)
source snapshot cutoff yyyymmddsource_cutoff_dateCHAR(8)
PENDING/RUNNING/SUCCESS/PARTIAL_FAILED/FAILEDstatusVARCHAR(16)
総チャンク数total_chunk_countINT
成功チャンク数success_chunk_countINT
失敗チャンク数failed_chunk_countINT
処理レース数processed_countINT
成功レース数success_countINT
警告レース数warning_countINT
エラーレース数error_countINT
ジョブ単位の警告フラグwarning_flagsVARCHAR(255)
master snapshot公開済みmaster_publishedTINYINT(1)
master snapshot公開日時master_published_atDATETIME
TAV source fingerprintsource_fingerprintCHAR(64)
sanitized exception typeerror_typeVARCHAR(128)
sanitized error messageerror_messageVARCHAR(1024)
実行開始日時started_atDATETIME
実行終了日時finished_atDATETIME
作成日時created_atDATETIME
更新日時updated_atDATETIME
planning_versionplanning_versionVARCHAR(64)
target_set_hashtarget_set_hashCHAR(64)
required_race_countrequired_race_countINT
required_group_countrequired_group_countINT
stale_race_countstale_race_countINT
master_requiredmaster_requiredTINYINT
required_plan_jsonrequired_plan_jsonJSON
TAV計算対象グループtav_job_target_group12 fields
論理名物理名データ型データ種別レコード種別JVData項目名
job_idjob_idBIGINT UNSIGNED
race_daterace_dateDATE
racecourse_cdracecourse_cdCHAR(2)
surface_cdsurface_cdCHAR(1)
source_revisionsource_revisionBIGINT
input_hashinput_hashCHAR(64)
member_hashmember_hashCHAR(64)
member_idsmember_idsJSON
target_counttarget_countINT
reasonreasonVARCHAR(64)
statusstatusVARCHAR(16)
completed_atcompleted_atDATETIME(6)
条件別・補完階層別ラップ構造マスタtav_lap_profile_master15 fields
論理名物理名データ型データ種別レコード種別JVData項目名
内部IDlap_profile_idBIGINT UNSIGNED
ラップ基準プロファイル階層profile_levelINT
正規化サーフェス T/Dsurface_cdCHAR(1)
距離。距離カテゴリ平均の場合は0kyoriINT
距離カテゴリdistance_categoryVARCHAR(16)
年齢帯。全年齢はALL_AGEage_group_cdVARCHAR(8)
ラップ用クラス分類lap_class_groupVARCHAR(32)
馬場グループbaba_groupVARCHAR(16)
ラップ区間番号segment_seqINT
平均区間ラップavg_lap_secDECIMAL(8,3)
平均ラップ間差分avg_delta_secDECIMAL(8,3)
参照レース数sample_countINT
基準値信頼度confidence_scoreDECIMAL(5,4)
作成日時created_atDATETIME
更新日時updated_atDATETIME
基準時計マスタtav_par_time_master9 fields
論理名物理名データ型データ種別レコード種別JVData項目名
内部IDpar_time_idBIGINT UNSIGNED
正規化サーフェス T/Dsurface_cdCHAR(1)
距離kyoriINT
基準時計 秒par_time_secDECIMAL(8,3)
採用サンプル数sample_countINT
基準馬場状態 初版は良固定base_baba_cdCHAR(1)
備考noteVARCHAR(255)
作成日時created_atDATETIME
更新日時updated_atDATETIME
TurfAnalyzerTrackVariant レース基盤tav_race32 fields
論理名物理名データ型データ種別レコード種別JVData項目名
TurfAnalyzerTrackVariant内部レースIDrace_idBIGINT UNSIGNED
JV2AI core_ra_race.race_idcore_race_idBIGINT
開催日yyyymmddkaisai_dateCHAR(8)
競馬場コードjyo_cdCHAR(2)
回次kaijiCHAR(2)
日次nichijiCHAR(2)
レース番号race_numCHAR(2)
レース名race_nameVARCHAR(120)
距離kyoriINT
元のトラックコードtrack_cdCHAR(2)
正規化サーフェス T/Dsurface_cdCHAR(1)
元のグレードコードgrade_cdCHAR(1)
元の競走種別コードsyubetu_cdCHAR(2)
年齢帯 2YO/3YO/3UP/4UPage_group_cdVARCHAR(8)
元の競走条件コード 2歳jyoken_cd_2saiCHAR(3)
元の競走条件コード 3歳jyoken_cd_3saiCHAR(3)
元の競走条件コード 4歳jyoken_cd_4saiCHAR(3)
元の競走条件コード 5歳以上jyoken_cd_5sai_ijoCHAR(3)
元の競走条件コード 最若年jyoken_cd_saijakunenCHAR(3)
正式採用する競走条件コードjyoken_cd_usedCHAR(3)
正規化クラス分類normalized_class_cdVARCHAR(16)
クラス補正キー surface_age_classclass_factor_keyVARCHAR(64)
race単位で使用する馬場状態コードbaba_cd_usedCHAR(1)
元の芝馬場状態コードsiba_baba_cdCHAR(1)
元のダート馬場状態コードdirt_baba_cdCHAR(1)
天候コードtenko_cdCHAR(1)
JRA対象レースかis_jra_targetTINYINT(1)
本プロジェクト対象レースかis_supported_raceTINYINT(1)
対象外理由exclusion_reasonVARCHAR(255)
元jv_ra_race.updated_atsource_updated_atDATETIME
作成日時created_atDATETIME
更新日時updated_atDATETIME
レース個別補正最終結果tav_race_adjustment33 fields
論理名物理名データ型データ種別レコード種別JVData項目名
内部IDrace_adjustment_idBIGINT UNSIGNED
tav_race.race_idrace_idBIGINT UNSIGNED
TAV計算仕様版calculation_versionVARCHAR(64)
信頼度校正artifact SHA-256calibration_checksumCHAR(64)
算出入力指紋 SHA-256input_fingerprintCHAR(64)
開催日yyyymmddkaisai_dateCHAR(8)
競馬場コードjyo_cdCHAR(2)
回次kaijiCHAR(2)
日次nichijiCHAR(2)
レース番号race_numCHAR(2)
正規化サーフェス T/Dsurface_cdCHAR(1)
距離kyoriINT
年齢帯age_group_cdVARCHAR(8)
採用した競走条件コードjyoken_cd_usedCHAR(3)
正規化クラスnormalized_class_cdVARCHAR(16)
クラス補正キーclass_factor_keyVARCHAR(64)
使用馬場状態コードbaba_cd_usedCHAR(1)
基準時計par_time_secDECIMAL(8,3)
コース補正course_factor_secDECIMAL(8,3)
クラス補正class_factor_secDECIMAL(8,3)
馬場状態補正track_condition_factor_secDECIMAL(8,3)
開催日馬場差day_variant_secDECIMAL(8,3)
レース個別補正値race_adjustment_secDECIMAL(8,3)
基準時計と補正値の合計expected_race_time_secDECIMAL(8,3)
主状態quality_statusVARCHAR(32)
警告フラグの連結文字列warning_flagsVARCHAR(255)
推定・フォールバックを含むかis_estimatedTINYINT(1)
使用した最大フォールバック階層fallback_levelINT
補正値全体の信頼度confidence_scoreDECIMAL(5,4)
成分別参照件数component_sample_counts_jsonJSON
成分別の算出元とブレンド情報component_source_jsonJSON
作成日時created_atDATETIME
更新日時updated_atDATETIME
レース単位ラップ構造要約tav_race_lap_profile29 fields
論理名物理名データ型データ種別レコード種別JVData項目名
内部IDrace_lap_profile_idBIGINT UNSIGNED
tav_race.race_idrace_idBIGINT UNSIGNED
開催日yyyymmddkaisai_dateCHAR(8)
競馬場コードjyo_cdCHAR(2)
正規化サーフェス T/Dsurface_cdCHAR(1)
距離kyoriINT
距離カテゴリdistance_categoryVARCHAR(16)
年齢帯age_group_cdVARCHAR(8)
正規化クラスnormalized_class_cdVARCHAR(16)
ラップ用クラス分類lap_class_groupVARCHAR(32)
馬場グループbaba_groupVARCHAR(16)
前半圧first_half_pressure_secDECIMAL(8,3)
中盤圧middle_pressure_secDECIMAL(8,3)
終盤圧late_pressure_secDECIMAL(8,3)
前半速度指数early_speed_indexDECIMAL(8,3)
中盤加速指数mid_accel_indexDECIMAL(8,3)
終盤加速指数late_accel_indexDECIMAL(8,3)
持続速度指数sustained_speed_indexDECIMAL(8,3)
ラスト締まり指数closing_speed_indexDECIMAL(8,3)
レース質分類pace_typeVARCHAR(32)
主状態quality_statusVARCHAR(32)
警告フラグの連結文字列warning_flagsVARCHAR(255)
推定・フォールバックを含むかis_estimatedTINYINT(1)
最大フォールバック階層fallback_levelINT
信頼度confidence_scoreDECIMAL(5,4)
参照件数component_sample_counts_jsonJSON
算出元component_source_jsonJSON
作成日時created_atDATETIME
更新日時updated_atDATETIME
レース別ラップ区間差分tav_race_lap_segment19 fields
論理名物理名データ型データ種別レコード種別JVData項目名
内部IDrace_lap_segment_idBIGINT UNSIGNED
tav_race.race_idrace_idBIGINT UNSIGNED
ラップ区間番号segment_seqINT
実測区間ラップlap_secDECIMAL(8,3)
基準区間ラップbase_lap_secDECIMAL(8,3)
実測 - 基準lap_diff_secDECIMAL(8,3)
実測ラップ間差分delta_secDECIMAL(8,3)
基準ラップ間差分base_delta_secDECIMAL(8,3)
実測delta - 基準deltadelta_diff_secDECIMAL(8,3)
ACCEL / DECEL / FLATpace_directionVARCHAR(16)
主状態quality_statusVARCHAR(32)
警告フラグの連結文字列warning_flagsVARCHAR(255)
推定・フォールバックを含むかis_estimatedTINYINT(1)
最大フォールバック階層fallback_levelINT
信頼度confidence_scoreDECIMAL(5,4)
参照件数component_sample_counts_jsonJSON
算出元component_source_jsonJSON
作成日時created_atDATETIME
更新日時updated_atDATETIME
TAV再計算制御tav_recalculation_control15 fields
論理名物理名データ型データ種別レコード種別JVData項目名
control_idcontrol_idTINYINT
source_revisionsource_revisionBIGINT
planning_versionplanning_versionVARCHAR(64)
baseline_readybaseline_readyTINYINT
source_hashsource_hashCHAR(64)
master_input_hashmaster_input_hashCHAR(64)
master_cutoffmaster_cutoffDATE
master_pendingmaster_pendingTINYINT
master_job_idmaster_job_idBIGINT UNSIGNED
updated_atupdated_atDATETIME(6)
master_output_hashmaster_output_hashCHAR(64)
input_epochinput_epochBIGINT
output_epochoutput_epochBIGINT
master_epochmaster_epochBIGINT
incremental_readyincremental_readyTINYINT
TAV再計算グループ状態tav_recalculation_group_state19 fields
論理名物理名データ型データ種別レコード種別JVData項目名
race_daterace_dateDATE
racecourse_cdracecourse_cdCHAR(2)
surface_cdsurface_cdCHAR(1)
requested_revisionrequested_revisionBIGINT
input_hashinput_hashCHAR(64)
member_hashmember_hashCHAR(64)
reasonreasonVARCHAR(64)
statusstatusVARCHAR(16)
successful_input_hashsuccessful_input_hashCHAR(64)
successful_member_hashsuccessful_member_hashCHAR(64)
successful_output_hashsuccessful_output_hashCHAR(64)
calculation_versioncalculation_versionVARCHAR(64)
calibration_checksumcalibration_checksumCHAR(64)
successful_job_idsuccessful_job_idBIGINT UNSIGNED
completed_atcompleted_atDATETIME(6)
updated_atupdated_atDATETIME(6)
verification_statusverification_statusVARCHAR(32)
lap_reference_fromlap_reference_fromDATE
lap_reference_tolap_reference_toDATE
TAV入力レース改訂管理tav_source_race_revision10 fields
論理名物理名データ型データ種別レコード種別JVData項目名
core_race_idcore_race_idBIGINT
race_daterace_dateDATE
racecourse_cdracecourse_cdCHAR(2)
surface_cdsurface_cdCHAR(1)
is_eligibleis_eligibleTINYINT
is_deletedis_deletedTINYINT
input_hashinput_hashCHAR(64)
source_revisionsource_revisionBIGINT
updated_atupdated_atDATETIME(6)
source_summarysource_summaryJSON
馬場状態補正マスタtav_track_condition_factor_master8 fields
論理名物理名データ型データ種別レコード種別JVData項目名
内部IDtrack_condition_factor_idBIGINT UNSIGNED
正規化サーフェス T/Dsurface_cdCHAR(1)
馬場状態コードbaba_cdCHAR(1)
馬場状態補正 秒track_condition_factor_secDECIMAL(8,3)
採用サンプル数sample_countINT
備考noteVARCHAR(255)
作成日時created_atDATETIME
更新日時updated_atDATETIME

taf

TAFデータ品質監査taf_data_quality_issue14 fields
論理名物理名データ型データ種別レコード種別JVData項目名
taf_issue_idtaf_issue_idBIGINT
taf_job_idtaf_job_idBIGINT
issue_levelissue_levelVARCHAR(16)
issue_codeissue_codeVARCHAR(64)
target_table_nametarget_table_nameVARCHAR(64)
race_idrace_idBIGINT
race_horse_idrace_horse_idBIGINT
horse_idhorse_idBIGINT
taf_race_feature_idtaf_race_feature_idBIGINT
taf_race_horse_feature_idtaf_race_horse_feature_idBIGINT
horse_ability_snapshot_idhorse_ability_snapshot_idBIGINT
issue_messageissue_messageVARCHAR(512)
detail_jsondetail_jsonJSON
occurred_atoccurred_atDATETIME
TAF日付別処理チェックポイントtaf_date_checkpoint16 fields
論理名物理名データ型データ種別レコード種別JVData項目名
race_daterace_dateDATE
calc_statuscalc_statusVARCHAR(32)
source_generationsource_generationBIGINT UNSIGNED
source_revisionsource_revisionBIGINT UNSIGNED
source_stagesource_stageVARCHAR(16)
source_fingerprintsource_fingerprintCHAR(64)
algorithm_versionalgorithm_versionVARCHAR(32)
calibration_checksumcalibration_checksumCHAR(64)
target_race_counttarget_race_countINT UNSIGNED
target_race_horse_counttarget_race_horse_countINT UNSIGNED
snapshot_countsnapshot_countINT UNSIGNED
last_taf_job_idlast_taf_job_idBIGINT
started_atstarted_atDATETIME
completed_atcompleted_atDATETIME
error_typeerror_typeVARCHAR(128)
updated_atupdated_atDATETIME
TAF競走馬能力値スナップショットtaf_horse_ability_snapshot64 fields
論理名物理名データ型データ種別レコード種別JVData項目名
horse_ability_snapshot_idhorse_ability_snapshot_idBIGINT
taf_job_idtaf_job_idBIGINT
as_of_race_idas_of_race_idBIGINT
as_of_race_horse_idas_of_race_horse_idBIGINT
horse_idhorse_idBIGINT
as_of_race_dateas_of_race_dateDATE
snapshot_scope_typesnapshot_scope_typeVARCHAR(64)
target_surface_cdtarget_surface_cdCHAR(1)
target_distance_mtarget_distance_mSMALLINT
target_distance_categorytarget_distance_categoryVARCHAR(32)
target_racecourse_cdtarget_racecourse_cdCHAR(2)
tai_indextai_indexDECIMAL(6,3)
tai_latent_ztai_latent_zDECIMAL(7,4)
epi_indexepi_indexDECIMAL(6,3)
lpi_indexlpi_indexDECIMAL(6,3)
spi_indexspi_indexDECIMAL(6,3)
kri_indexkri_indexDECIMAL(6,3)
tai_confidence_scoretai_confidence_scoreDECIMAL(5,4)
epi_confidence_scoreepi_confidence_scoreDECIMAL(5,4)
lpi_confidence_scorelpi_confidence_scoreDECIMAL(5,4)
spi_confidence_scorespi_confidence_scoreDECIMAL(5,4)
kri_confidence_scorekri_confidence_scoreDECIMAL(5,4)
epi_evidence_levelepi_evidence_levelVARCHAR(16)
lpi_evidence_levellpi_evidence_levelVARCHAR(16)
spi_evidence_levelspi_evidence_levelVARCHAR(16)
kri_evidence_levelkri_evidence_levelVARCHAR(16)
tai_evidence_leveltai_evidence_levelVARCHAR(16)
weighted_ability_resid_secweighted_ability_resid_secDECIMAL(8,3)
weighted_time_resid_secweighted_time_resid_secDECIMAL(8,3)
speed_zspeed_zDECIMAL(6,3)
front3_zfront3_zDECIMAL(6,3)
late3_zlate3_zDECIMAL(6,3)
early_position_zearly_position_zDECIMAL(6,3)
mid_position_zmid_position_zDECIMAL(6,3)
front_lead_zfront_lead_zDECIMAL(6,3)
closing_zclosing_zDECIMAL(6,3)
rear_weighted_gain_zrear_weighted_gain_zDECIMAL(6,3)
early_hold_zearly_hold_zDECIMAL(6,3)
early_pressure_load_zearly_pressure_load_zDECIMAL(6,3)
late_context_response_zlate_context_response_zDECIMAL(6,3)
no_fade_zno_fade_zDECIMAL(6,3)
front_survival_zfront_survival_zDECIMAL(6,3)
late3_sustain_zlate3_sustain_zDECIMAL(6,3)
sustained_context_load_zsustained_context_load_zDECIMAL(6,3)
closing_acceleration_zclosing_acceleration_zDECIMAL(6,3)
relative_last3_zrelative_last3_zDECIMAL(6,3)
spi_zspi_zDECIMAL(6,3)
corner_gain_zcorner_gain_zDECIMAL(6,3)
kri_zkri_zDECIMAL(6,3)
source_run_countsource_run_countSMALLINT
valid_source_run_countvalid_source_run_countSMALLINT
selected_run_countselected_run_countSMALLINT
single_extreme_poor_run_excluded_countsingle_extreme_poor_run_excluded_countSMALLINT
source_race_date_minsource_race_date_minDATE
source_race_date_maxsource_race_date_maxDATE
days_since_last_run_countdays_since_last_run_countSMALLINT
avg_source_confidence_scoreavg_source_confidence_scoreDECIMAL(5,4)
snapshot_confidence_scoresnapshot_confidence_scoreDECIMAL(5,4)
quality_statusquality_statusVARCHAR(32)
quality_warning_flagsquality_warning_flagsVARCHAR(512)
created_atcreated_atDATETIME
updated_atupdated_atDATETIME
recent_ability_stat_source_countrecent_ability_stat_source_countSMALLINT
recent_ability_variability_mad_zrecent_ability_variability_mad_zDECIMAL(6,3)
TAF能力値スナップショット参照元taf_horse_ability_snapshot_source61 fields
論理名物理名データ型データ種別レコード種別JVData項目名
horse_ability_snapshot_source_idhorse_ability_snapshot_source_idBIGINT
horse_ability_snapshot_idhorse_ability_snapshot_idBIGINT
source_taf_race_horse_feature_idsource_taf_race_horse_feature_idBIGINT
source_race_idsource_race_idBIGINT
source_race_horse_idsource_race_horse_idBIGINT
source_horse_idsource_horse_idBIGINT
source_race_datesource_race_dateDATE
source_surface_cdsource_surface_cdCHAR(1)
source_distance_msource_distance_mSMALLINT
source_distance_categorysource_distance_categoryVARCHAR(32)
source_racecourse_cdsource_racecourse_cdCHAR(2)
source_pace_typesource_pace_typeVARCHAR(32)
source_lap_confidence_scoresource_lap_confidence_scoreDECIMAL(5,4)
source_class_factor_secsource_class_factor_secDECIMAL(8,3)
source_run_ability_resid_for_score_secsource_run_ability_resid_for_score_secDECIMAL(8,3)
source_run_ability_resid_for_time_secsource_run_ability_resid_for_time_secDECIMAL(8,3)
source_run_tai_absolute_resid_secsource_run_tai_absolute_resid_secDECIMAL(8,3)
source_run_tai_absolute_zsource_run_tai_absolute_zDECIMAL(7,4)
source_run_result_dominance_zsource_run_result_dominance_zDECIMAL(7,4)
source_run_opponent_strength_zsource_run_opponent_strength_zDECIMAL(7,4)
source_run_opponent_valid_countsource_run_opponent_valid_countSMALLINT UNSIGNED
source_run_opponent_weight_sumsource_run_opponent_weight_sumDECIMAL(8,4)
source_run_competition_ability_zsource_run_competition_ability_zDECIMAL(7,4)
source_run_tai_context_zsource_run_tai_context_zDECIMAL(7,4)
source_run_speed_zsource_run_speed_zDECIMAL(6,3)
source_run_front3_z_sourcesource_run_front3_z_sourceDECIMAL(6,3)
source_run_late3_z_sourcesource_run_late3_z_sourceDECIMAL(6,3)
source_run_corner_gain_ratesource_run_corner_gain_rateDECIMAL(6,4)
source_run_straight_hold_ratesource_run_straight_hold_rateDECIMAL(6,4)
source_run_overall_performance_indexsource_run_overall_performance_indexDECIMAL(6,3)
source_run_early_position_indexsource_run_early_position_indexDECIMAL(6,3)
source_run_late_performance_indexsource_run_late_performance_indexDECIMAL(6,3)
source_run_front_sustain_indexsource_run_front_sustain_indexDECIMAL(6,3)
source_run_closing_gain_indexsource_run_closing_gain_indexDECIMAL(6,3)
source_performance_confidence_scoresource_performance_confidence_scoreDECIMAL(5,4)
source_used_flagsource_used_flagTINYINT(1)
source_exclusion_reasonsource_exclusion_reasonVARCHAR(64)
source_exclusion_basis_jsonsource_exclusion_basis_jsonJSON
single_extreme_poor_run_flagsingle_extreme_poor_run_flagTINYINT(1)
ability_select_rankability_select_rankSMALLINT
selected_run_limitselected_run_limitSMALLINT
ability_rank_weightability_rank_weightDECIMAL(5,4)
source_recency_dayssource_recency_daysSMALLINT
recency_weightrecency_weightDECIMAL(5,4)
quality_weightquality_weightDECIMAL(5,4)
source_weightsource_weightDECIMAL(8,5)
source_weight_basis_jsonsource_weight_basis_jsonJSON
created_atcreated_atDATETIME
source_run_early_position_z_sourcesource_run_early_position_z_sourceDECIMAL(6,3)
source_run_mid_position_z_sourcesource_run_mid_position_z_sourceDECIMAL(6,3)
source_run_corner_gain_z_sourcesource_run_corner_gain_z_sourceDECIMAL(6,3)
source_run_rear_weighted_gain_z_sourcesource_run_rear_weighted_gain_z_sourceDECIMAL(6,3)
source_run_early_hold_z_sourcesource_run_early_hold_z_sourceDECIMAL(6,3)
source_run_early_pressure_load_z_sourcesource_run_early_pressure_load_z_sourceDECIMAL(6,3)
source_run_late_context_response_z_sourcesource_run_late_context_response_z_sourceDECIMAL(6,3)
source_run_no_fade_z_sourcesource_run_no_fade_z_sourceDECIMAL(6,3)
source_run_front_survival_z_sourcesource_run_front_survival_z_sourceDECIMAL(6,3)
source_run_sustained_context_load_z_sourcesource_run_sustained_context_load_z_sourceDECIMAL(6,3)
source_run_closing_acceleration_secsource_run_closing_acceleration_secDECIMAL(8,3)
source_run_closing_acceleration_z_sourcesource_run_closing_acceleration_z_sourceDECIMAL(6,3)
source_run_relative_last3_z_sourcesource_run_relative_last3_z_sourceDECIMAL(6,3)
TAF計算ジョブ実行履歴taf_job_run30 fields
論理名物理名データ型データ種別レコード種別JVData項目名
taf_job_idtaf_job_idBIGINT
taf_spec_versiontaf_spec_versionVARCHAR(32)
taf_algorithm_versiontaf_algorithm_versionVARCHAR(32)
index_calibration_versionindex_calibration_versionVARCHAR(32)
index_calibration_checksumindex_calibration_checksumCHAR(64)
tav_spec_versiontav_spec_versionVARCHAR(32)
run_moderun_modeVARCHAR(32)
worker_pidworker_pidBIGINT UNSIGNED
calc_scope_typecalc_scope_typeVARCHAR(32)
target_race_idtarget_race_idBIGINT
target_from_datetarget_from_dateDATE
target_to_datetarget_to_dateDATE
source_tav_job_idsource_tav_job_idBIGINT
source_tav_updated_fromsource_tav_updated_fromDATETIME
source_tav_updated_tosource_tav_updated_toDATETIME
calc_statuscalc_statusVARCHAR(32)
target_race_counttarget_race_countINT
success_race_countsuccess_race_countINT
failed_race_countfailed_race_countINT
target_race_horse_counttarget_race_horse_countINT
success_race_horse_countsuccess_race_horse_countINT
failed_race_horse_countfailed_race_horse_countINT
created_snapshot_countcreated_snapshot_countINT
issue_countissue_countINT
parameter_hashparameter_hashVARCHAR(128)
parameter_jsonparameter_jsonJSON
started_atstarted_atDATETIME
finished_atfinished_atDATETIME
created_atcreated_atDATETIME
updated_atupdated_atDATETIME
TAF計算処理制御taf_processing_control9 fields
論理名物理名データ型データ種別レコード種別JVData項目名
control_idcontrol_idTINYINT UNSIGNED
source_generationsource_generationBIGINT UNSIGNED
ready_generationready_generationBIGINT UNSIGNED
source_fingerprintsource_fingerprintCHAR(64)
dirty_from_datedirty_from_dateDATE
active_taf_job_idactive_taf_job_idBIGINT
algorithm_versionalgorithm_versionVARCHAR(32)
calibration_checksumcalibration_checksumCHAR(64)
updated_atupdated_atDATETIME
TAFレース特徴量taf_race_feature47 fields
論理名物理名データ型データ種別レコード種別JVData項目名
taf_race_feature_idtaf_race_feature_idBIGINT
taf_job_idtaf_job_idBIGINT
race_idrace_idBIGINT
tav_race_idtav_race_idBIGINT
tav_race_adjustment_idtav_race_adjustment_idBIGINT
race_daterace_dateDATE
racecourse_cdracecourse_cdCHAR(2)
race_norace_noTINYINT
surface_cdsurface_cdCHAR(1)
distance_mdistance_mSMALLINT
distance_categorydistance_categoryVARCHAR(32)
track_cdtrack_cdVARCHAR(2)
baba_cdbaba_cdVARCHAR(2)
weather_cdweather_cdVARCHAR(2)
normalized_class_cdnormalized_class_cdVARCHAR(32)
starter_countstarter_countTINYINT
finisher_countfinisher_countTINYINT
straight_course_flagstraight_course_flagTINYINT(1)
expected_race_time_secexpected_race_time_secDECIMAL(8,3)
race_adjustment_secrace_adjustment_secDECIMAL(8,3)
day_variant_secday_variant_secDECIMAL(8,3)
par_time_secpar_time_secDECIMAL(8,3)
class_factor_secclass_factor_secDECIMAL(8,3)
tav_confidence_scoretav_confidence_scoreDECIMAL(5,4)
winner_finish_time_secwinner_finish_time_secDECIMAL(8,3)
winner_time_resid_secwinner_time_resid_secDECIMAL(8,3)
first3_secfirst3_secDECIMAL(6,3)
last3_seclast3_secDECIMAL(6,3)
pace_typepace_typeVARCHAR(32)
first_half_pressure_secfirst_half_pressure_secDECIMAL(8,3)
middle_pressure_secmiddle_pressure_secDECIMAL(8,3)
late_pressure_seclate_pressure_secDECIMAL(8,3)
lap_confidence_scorelap_confidence_scoreDECIMAL(5,4)
valid_taf_race_flagvalid_taf_race_flagTINYINT(1)
valid_tav_adjustment_flagvalid_tav_adjustment_flagTINYINT(1)
valid_lap_flagvalid_lap_flagTINYINT(1)
valid_time_flagvalid_time_flagTINYINT(1)
race_confidence_scorerace_confidence_scoreDECIMAL(5,4)
quality_statusquality_statusVARCHAR(32)
quality_warning_flagsquality_warning_flagsVARCHAR(512)
created_atcreated_atDATETIME
updated_atupdated_atDATETIME
early_speed_indexearly_speed_indexDECIMAL(6,3)
mid_accel_indexmid_accel_indexDECIMAL(6,3)
late_accel_indexlate_accel_indexDECIMAL(6,3)
sustained_speed_indexsustained_speed_indexDECIMAL(6,3)
closing_speed_indexclosing_speed_indexDECIMAL(6,3)
TAF出走馬特徴量taf_race_horse_feature93 fields
論理名物理名データ型データ種別レコード種別JVData項目名
taf_race_horse_feature_idtaf_race_horse_feature_idBIGINT
taf_job_idtaf_job_idBIGINT
taf_race_feature_idtaf_race_feature_idBIGINT
race_idrace_idBIGINT
race_horse_idrace_horse_idBIGINT
horse_idhorse_idBIGINT
tav_race_idtav_race_idBIGINT
tav_race_adjustment_idtav_race_adjustment_idBIGINT
race_daterace_dateDATE
racecourse_cdracecourse_cdCHAR(2)
race_norace_noTINYINT
surface_cdsurface_cdCHAR(1)
distance_mdistance_mSMALLINT
distance_categorydistance_categoryVARCHAR(32)
track_cdtrack_cdVARCHAR(2)
baba_cdbaba_cdVARCHAR(2)
normalized_class_cdnormalized_class_cdVARCHAR(32)
starter_countstarter_countTINYINT
finisher_countfinisher_countTINYINT
straight_course_flagstraight_course_flagTINYINT(1)
horse_nohorse_noTINYINT
finish_orderfinish_orderTINYINT
arrival_orderarrival_orderTINYINT
abnormality_cdabnormality_cdVARCHAR(4)
finish_time_secfinish_time_secDECIMAL(8,3)
winner_finish_time_secwinner_finish_time_secDECIMAL(8,3)
winner_time_diff_secwinner_time_diff_secDECIMAL(8,3)
margin_secmargin_secDECIMAL(8,3)
last3_seclast3_secDECIMAL(6,3)
corner1_ordercorner1_orderTINYINT
corner2_ordercorner2_orderTINYINT
corner3_ordercorner3_orderTINYINT
corner4_ordercorner4_orderTINYINT
expected_race_time_secexpected_race_time_secDECIMAL(8,3)
race_adjustment_secrace_adjustment_secDECIMAL(8,3)
day_variant_secday_variant_secDECIMAL(8,3)
class_factor_secclass_factor_secDECIMAL(8,3)
tav_confidence_scoretav_confidence_scoreDECIMAL(5,4)
run_finish_time_resid_secrun_finish_time_resid_secDECIMAL(8,3)
run_ability_resid_secrun_ability_resid_secDECIMAL(8,3)
run_ability_resid_for_score_secrun_ability_resid_for_score_secDECIMAL(8,3)
run_ability_resid_for_time_secrun_ability_resid_for_time_secDECIMAL(8,3)
run_tai_absolute_resid_secrun_tai_absolute_resid_secDECIMAL(8,3)
run_tai_absolute_zrun_tai_absolute_zDECIMAL(7,4)
run_result_dominance_zrun_result_dominance_zDECIMAL(7,4)
run_opponent_strength_zrun_opponent_strength_zDECIMAL(7,4)
run_opponent_valid_countrun_opponent_valid_countSMALLINT UNSIGNED
run_opponent_weight_sumrun_opponent_weight_sumDECIMAL(8,4)
run_competition_ability_zrun_competition_ability_zDECIMAL(7,4)
run_tai_context_zrun_tai_context_zDECIMAL(7,4)
run_speed_zrun_speed_zDECIMAL(6,3)
run_front3_z_sourcerun_front3_z_sourceDECIMAL(6,3)
run_late3_secrun_late3_secDECIMAL(6,3)
run_late3_z_sourcerun_late3_z_sourceDECIMAL(6,3)
run_early_position_raterun_early_position_rateDECIMAL(6,4)
run_mid_position_raterun_mid_position_rateDECIMAL(6,4)
run_corner4_position_raterun_corner4_position_rateDECIMAL(6,4)
run_finish_position_raterun_finish_position_rateDECIMAL(6,4)
run_corner_gain_raterun_corner_gain_rateDECIMAL(6,4)
run_straight_hold_raterun_straight_hold_rateDECIMAL(6,4)
run_front_late3_support_valuerun_front_late3_support_valueDECIMAL(6,4)
pace_typepace_typeVARCHAR(32)
lap_confidence_scorelap_confidence_scoreDECIMAL(5,4)
run_overall_performance_indexrun_overall_performance_indexDECIMAL(6,3)
run_early_position_indexrun_early_position_indexDECIMAL(6,3)
run_late_performance_indexrun_late_performance_indexDECIMAL(6,3)
run_front_sustain_indexrun_front_sustain_indexDECIMAL(6,3)
run_closing_gain_indexrun_closing_gain_indexDECIMAL(6,3)
valid_taf_run_flagvalid_taf_run_flagTINYINT(1)
valid_tav_adjustment_flagvalid_tav_adjustment_flagTINYINT(1)
valid_time_flagvalid_time_flagTINYINT(1)
valid_last3_flagvalid_last3_flagTINYINT(1)
valid_position_flagvalid_position_flagTINYINT(1)
valid_lap_flagvalid_lap_flagTINYINT(1)
abnormality_exclude_flagabnormality_exclude_flagTINYINT(1)
performance_confidence_scoreperformance_confidence_scoreDECIMAL(5,4)
quality_statusquality_statusVARCHAR(32)
quality_warning_flagsquality_warning_flagsVARCHAR(512)
created_atcreated_atDATETIME
updated_atupdated_atDATETIME
run_early_position_z_sourcerun_early_position_z_sourceDECIMAL(6,3)
run_mid_position_z_sourcerun_mid_position_z_sourceDECIMAL(6,3)
run_corner_gain_z_sourcerun_corner_gain_z_sourceDECIMAL(6,3)
run_rear_weighted_gain_z_sourcerun_rear_weighted_gain_z_sourceDECIMAL(6,3)
run_early_hold_z_sourcerun_early_hold_z_sourceDECIMAL(6,3)
run_early_pressure_load_z_sourcerun_early_pressure_load_z_sourceDECIMAL(6,3)
run_late_context_response_z_sourcerun_late_context_response_z_sourceDECIMAL(6,3)
run_no_fade_z_sourcerun_no_fade_z_sourceDECIMAL(6,3)
run_front_survival_z_sourcerun_front_survival_z_sourceDECIMAL(6,3)
run_sustained_context_load_z_sourcerun_sustained_context_load_z_sourceDECIMAL(6,3)
run_closing_acceleration_secrun_closing_acceleration_secDECIMAL(8,3)
run_closing_acceleration_z_sourcerun_closing_acceleration_z_sourceDECIMAL(6,3)
run_relative_last3_z_sourcerun_relative_last3_z_sourceDECIMAL(6,3)

tfs

TFSデータ品質監査tfs_data_quality_issue11 fields
論理名物理名データ型データ種別レコード種別JVData項目名
tfs_issue_idtfs_issue_idBIGINT
tfs_job_idtfs_job_idBIGINT
tfs_chunk_idtfs_chunk_idBIGINT
issue_levelissue_levelVARCHAR(16)
issue_codeissue_codeVARCHAR(64)
race_idrace_idBIGINT
race_horse_idrace_horse_idBIGINT
horse_idhorse_idBIGINT
issue_messageissue_messageVARCHAR(512)
detail_jsondetail_jsonJSON
occurred_atoccurred_atDATETIME
TFS計算ジョブ分割処理tfs_job_chunk13 fields
論理名物理名データ型データ種別レコード種別JVData項目名
tfs_chunk_idtfs_chunk_idBIGINT
tfs_job_idtfs_job_idBIGINT
chunk_nochunk_noINT
race_idrace_idBIGINT
calc_statuscalc_statusVARCHAR(32)
target_race_horse_counttarget_race_horse_countINT
processed_race_horse_countprocessed_race_horse_countINT
error_codeerror_codeVARCHAR(64)
error_messageerror_messageVARCHAR(512)
started_atstarted_atDATETIME
finished_atfinished_atDATETIME
created_atcreated_atDATETIME
updated_atupdated_atDATETIME
TFS計算ジョブ実行履歴tfs_job_run17 fields
論理名物理名データ型データ種別レコード種別JVData項目名
tfs_job_idtfs_job_idBIGINT
tfs_spec_versiontfs_spec_versionVARCHAR(32)
tfs_algorithm_versiontfs_algorithm_versionVARCHAR(32)
target_from_datetarget_from_dateDATE
target_to_datetarget_to_dateDATE
calc_statuscalc_statusVARCHAR(32)
target_race_counttarget_race_countINT
success_race_countsuccess_race_countINT
failed_race_countfailed_race_countINT
target_race_horse_counttarget_race_horse_countINT
success_race_horse_countsuccess_race_horse_countINT
failed_race_horse_countfailed_race_horse_countINT
issue_countissue_countINT
started_atstarted_atDATETIME
finished_atfinished_atDATETIME
created_atcreated_atDATETIME
updated_atupdated_atDATETIME
TFS計算処理制御tfs_processing_control10 fields
論理名物理名データ型データ種別レコード種別JVData項目名
control_idcontrol_idTINYINT UNSIGNED
source_generationsource_generationBIGINT UNSIGNED
ready_generationready_generationBIGINT UNSIGNED
dirty_from_datedirty_from_dateDATE
active_tfs_job_idactive_tfs_job_idBIGINT
worker_pidworker_pidINT UNSIGNED
tfs_spec_versiontfs_spec_versionVARCHAR(32)
tfs_algorithm_versiontfs_algorithm_versionVARCHAR(32)
last_success_atlast_success_atDATETIME
updated_atupdated_atDATETIME
TFSレース別処理チェックポイントtfs_race_checkpoint16 fields
論理名物理名データ型データ種別レコード種別JVData項目名
race_idrace_idBIGINT
race_daterace_dateDATE
calc_statuscalc_statusVARCHAR(32)
source_generationsource_generationBIGINT UNSIGNED
source_revisionsource_revisionBIGINT UNSIGNED
source_fingerprintsource_fingerprintCHAR(64)
tfs_spec_versiontfs_spec_versionVARCHAR(32)
tfs_algorithm_versiontfs_algorithm_versionVARCHAR(32)
target_race_horse_counttarget_race_horse_countINT UNSIGNED
written_race_horse_countwritten_race_horse_countINT UNSIGNED
last_tfs_job_idlast_tfs_job_idBIGINT
last_tfs_chunk_idlast_tfs_chunk_idBIGINT
started_atstarted_atDATETIME
completed_atcompleted_atDATETIME
error_typeerror_typeVARCHAR(128)
updated_atupdated_atDATETIME
TFSレース特徴量tfs_race_feature60 fields
論理名物理名データ型データ種別レコード種別JVData項目名
tfs_race_feature_idtfs_race_feature_idBIGINT
tfs_job_idtfs_job_idBIGINT
race_idrace_idBIGINT
race_daterace_dateDATE
quality_statusquality_statusVARCHAR(16)
created_atcreated_atDATETIME
updated_atupdated_atDATETIME
member_entry_countmember_entry_countINT
member_surface_distance_low_confidence_countmember_surface_distance_low_confidence_countINT
member_overall_tai_valid_countmember_overall_tai_valid_countINT
member_overall_tai_meanmember_overall_tai_meanDECIMAL(7,3)
member_overall_tai_medianmember_overall_tai_medianDECIMAL(7,3)
member_overall_tai_stddevmember_overall_tai_stddevDECIMAL(7,3)
member_overall_tai_maxmember_overall_tai_maxDECIMAL(7,3)
member_overall_tai_top3_meanmember_overall_tai_top3_meanDECIMAL(7,3)
member_overall_tai_top1_top2_gapmember_overall_tai_top1_top2_gapDECIMAL(7,3)
member_surface_distance_tai_valid_countmember_surface_distance_tai_valid_countINT
member_surface_distance_tai_meanmember_surface_distance_tai_meanDECIMAL(7,3)
member_surface_distance_tai_medianmember_surface_distance_tai_medianDECIMAL(7,3)
member_surface_distance_tai_stddevmember_surface_distance_tai_stddevDECIMAL(7,3)
member_surface_distance_tai_maxmember_surface_distance_tai_maxDECIMAL(7,3)
member_surface_distance_tai_top3_meanmember_surface_distance_tai_top3_meanDECIMAL(7,3)
member_surface_distance_tai_top1_top2_gapmember_surface_distance_tai_top1_top2_gapDECIMAL(7,3)
member_surface_distance_epi_valid_countmember_surface_distance_epi_valid_countINT
member_surface_distance_epi_meanmember_surface_distance_epi_meanDECIMAL(7,3)
member_surface_distance_epi_medianmember_surface_distance_epi_medianDECIMAL(7,3)
member_surface_distance_epi_stddevmember_surface_distance_epi_stddevDECIMAL(7,3)
member_surface_distance_epi_maxmember_surface_distance_epi_maxDECIMAL(7,3)
member_surface_distance_epi_top3_meanmember_surface_distance_epi_top3_meanDECIMAL(7,3)
member_surface_distance_epi_top1_top2_gapmember_surface_distance_epi_top1_top2_gapDECIMAL(7,3)
member_surface_distance_lpi_valid_countmember_surface_distance_lpi_valid_countINT
member_surface_distance_lpi_meanmember_surface_distance_lpi_meanDECIMAL(7,3)
member_surface_distance_lpi_medianmember_surface_distance_lpi_medianDECIMAL(7,3)
member_surface_distance_lpi_stddevmember_surface_distance_lpi_stddevDECIMAL(7,3)
member_surface_distance_lpi_maxmember_surface_distance_lpi_maxDECIMAL(7,3)
member_surface_distance_lpi_top3_meanmember_surface_distance_lpi_top3_meanDECIMAL(7,3)
member_surface_distance_lpi_top1_top2_gapmember_surface_distance_lpi_top1_top2_gapDECIMAL(7,3)
member_surface_distance_spi_valid_countmember_surface_distance_spi_valid_countINT
member_surface_distance_spi_meanmember_surface_distance_spi_meanDECIMAL(7,3)
member_surface_distance_spi_medianmember_surface_distance_spi_medianDECIMAL(7,3)
member_surface_distance_spi_stddevmember_surface_distance_spi_stddevDECIMAL(7,3)
member_surface_distance_spi_maxmember_surface_distance_spi_maxDECIMAL(7,3)
member_surface_distance_spi_top3_meanmember_surface_distance_spi_top3_meanDECIMAL(7,3)
member_surface_distance_spi_top1_top2_gapmember_surface_distance_spi_top1_top2_gapDECIMAL(7,3)
member_surface_distance_kri_valid_countmember_surface_distance_kri_valid_countINT
member_surface_distance_kri_meanmember_surface_distance_kri_meanDECIMAL(7,3)
member_surface_distance_kri_medianmember_surface_distance_kri_medianDECIMAL(7,3)
member_surface_distance_kri_stddevmember_surface_distance_kri_stddevDECIMAL(7,3)
member_surface_distance_kri_maxmember_surface_distance_kri_maxDECIMAL(7,3)
member_surface_distance_kri_top3_meanmember_surface_distance_kri_top3_meanDECIMAL(7,3)
member_surface_distance_kri_top1_top2_gapmember_surface_distance_kri_top1_top2_gapDECIMAL(7,3)
member_ability_variability_valid_countmember_ability_variability_valid_countINT
member_ability_variability_mad_z_meanmember_ability_variability_mad_z_meanDECIMAL(7,3)
member_ability_variability_mad_z_medianmember_ability_variability_mad_z_medianDECIMAL(7,3)
member_style_valid_horse_countmember_style_valid_horse_countINT
member_style_coverage_ratemember_style_coverage_rateDECIMAL(7,6)
member_nige_style_rate_summember_nige_style_rate_sumDECIMAL(8,6)
member_senko_style_rate_summember_senko_style_rate_sumDECIMAL(8,6)
member_sashi_style_rate_summember_sashi_style_rate_sumDECIMAL(8,6)
member_oikomi_style_rate_summember_oikomi_style_rate_sumDECIMAL(8,6)
TFS出走馬特徴量tfs_race_horse_feature172 fields
論理名物理名データ型データ種別レコード種別JVData項目名
tfs_race_horse_feature_idtfs_race_horse_feature_idBIGINT
tfs_job_idtfs_job_idBIGINT
tfs_race_feature_idtfs_race_feature_idBIGINT
race_idrace_idBIGINT
race_horse_idrace_horse_idBIGINT
horse_idhorse_idBIGINT
race_daterace_dateDATE
quality_statusquality_statusVARCHAR(16)
created_atcreated_atDATETIME
updated_atupdated_atDATETIME
previous_race_idprevious_race_idBIGINT
previous_race_horse_idprevious_race_horse_idBIGINT
previous_run_found_flagprevious_run_found_flagTINYINT(1)
previous_run_type_cdprevious_run_type_cdVARCHAR(32)
previous_run_status_cdprevious_run_status_cdVARCHAR(32)
previous_run_interval_daysprevious_run_interval_daysINT
previous_run_calendar_week_diff_countprevious_run_calendar_week_diff_countSMALLINT
rotation_interval_category_cdrotation_interval_category_cdVARCHAR(32)
first_start_flagfirst_start_flagTINYINT(1)
layoff_return_flaglayoff_return_flagTINYINT(1)
run_count_since_layoffrun_count_since_layoffSMALLINT
distance_diff_mdistance_diff_mSMALLINT
distance_change_ratedistance_change_rateDECIMAL(8,5)
distance_change_type_cddistance_change_type_cdVARCHAR(32)
surface_change_type_cdsurface_change_type_cdVARCHAR(32)
racecourse_change_flagracecourse_change_flagTINYINT(1)
class_change_type_cdclass_change_type_cdVARCHAR(32)
class_change_stepclass_change_stepSMALLINT
class_comparable_flagclass_comparable_flagTINYINT(1)
carried_weight_diff_kgcarried_weight_diff_kgDECIMAL(5,1)
jockey_change_flagjockey_change_flagTINYINT(1)
trainer_change_flagtrainer_change_flagTINYINT(1)
blinker_change_type_cdblinker_change_type_cdVARCHAR(32)
apprentice_change_flagapprentice_change_flagTINYINT(1)
training_last_valid_datetimetraining_last_valid_datetimeDATETIME
training_last_valid_type_cdtraining_last_valid_type_cdVARCHAR(16)
training_last_valid_days_before_racetraining_last_valid_days_before_raceINT
training_last_valid_hours_before_racetraining_last_valid_hours_before_raceDECIMAL(10,2)
training_source_status_cdtraining_source_status_cdVARCHAR(32)
hc_training_source_status_cdhc_training_source_status_cdVARCHAR(32)
wc_training_source_status_cdwc_training_source_status_cdVARCHAR(32)
training_source_count_7dtraining_source_count_7dINT
training_valid_source_count_7dtraining_valid_source_count_7dINT
training_valid_distinct_day_count_7dtraining_valid_distinct_day_count_7dINT
hc_training_valid_source_count_7dhc_training_valid_source_count_7dINT
wc_training_valid_source_count_7dwc_training_valid_source_count_7dINT
training_source_count_14dtraining_source_count_14dINT
training_valid_source_count_14dtraining_valid_source_count_14dINT
training_valid_distinct_day_count_14dtraining_valid_distinct_day_count_14dINT
hc_training_valid_source_count_14dhc_training_valid_source_count_14dINT
wc_training_valid_source_count_14dwc_training_valid_source_count_14dINT
training_source_count_28dtraining_source_count_28dINT
training_valid_source_count_28dtraining_valid_source_count_28dINT
training_valid_distinct_day_count_28dtraining_valid_distinct_day_count_28dINT
hc_training_valid_source_count_28dhc_training_valid_source_count_28dINT
wc_training_valid_source_count_28dwc_training_valid_source_count_28dINT
training_valid_source_count_since_previous_runtraining_valid_source_count_since_previous_runINT
training_valid_distinct_day_count_since_previous_runtraining_valid_distinct_day_count_since_previous_runINT
hc_training_valid_source_count_since_previous_runhc_training_valid_source_count_since_previous_runINT
wc_training_valid_source_count_since_previous_runwc_training_valid_source_count_since_previous_runINT
hc_training_last_valid_datetimehc_training_last_valid_datetimeDATETIME
hc_training_last_valid_center_cdhc_training_last_valid_center_cdCHAR(1)
hc_training_last_valid_days_before_racehc_training_last_valid_days_before_raceINT
hc_training_last_valid_4f_sechc_training_last_valid_4f_secDECIMAL(8,3)
hc_training_last_valid_3f_sechc_training_last_valid_3f_secDECIMAL(8,3)
hc_training_last_valid_2f_sechc_training_last_valid_2f_secDECIMAL(8,3)
hc_training_last_valid_1f_sechc_training_last_valid_1f_secDECIMAL(8,3)
hc_training_last_valid_lap_800_600_sechc_training_last_valid_lap_800_600_secDECIMAL(8,3)
hc_training_last_valid_lap_600_400_sechc_training_last_valid_lap_600_400_secDECIMAL(8,3)
hc_training_last_valid_lap_400_200_sechc_training_last_valid_lap_400_200_secDECIMAL(8,3)
hc_training_last_valid_1f_accel_sechc_training_last_valid_1f_accel_secDECIMAL(8,3)
hc_training_last_valid_2f_half_accel_sechc_training_last_valid_2f_half_accel_secDECIMAL(8,3)
wc_training_last_valid_datetimewc_training_last_valid_datetimeDATETIME
wc_training_last_valid_center_cdwc_training_last_valid_center_cdCHAR(1)
wc_training_last_valid_course_cdwc_training_last_valid_course_cdCHAR(1)
wc_training_last_valid_direction_cdwc_training_last_valid_direction_cdCHAR(1)
wc_training_last_valid_days_before_racewc_training_last_valid_days_before_raceINT
wc_training_last_valid_6f_secwc_training_last_valid_6f_secDECIMAL(8,3)
wc_training_last_valid_5f_secwc_training_last_valid_5f_secDECIMAL(8,3)
wc_training_last_valid_4f_secwc_training_last_valid_4f_secDECIMAL(8,3)
wc_training_last_valid_3f_secwc_training_last_valid_3f_secDECIMAL(8,3)
wc_training_last_valid_2f_secwc_training_last_valid_2f_secDECIMAL(8,3)
wc_training_last_valid_1f_secwc_training_last_valid_1f_secDECIMAL(8,3)
wc_training_last_valid_lap_1200_1000_secwc_training_last_valid_lap_1200_1000_secDECIMAL(8,3)
wc_training_last_valid_lap_1000_800_secwc_training_last_valid_lap_1000_800_secDECIMAL(8,3)
wc_training_last_valid_lap_800_600_secwc_training_last_valid_lap_800_600_secDECIMAL(8,3)
wc_training_last_valid_lap_600_400_secwc_training_last_valid_lap_600_400_secDECIMAL(8,3)
wc_training_last_valid_lap_400_200_secwc_training_last_valid_lap_400_200_secDECIMAL(8,3)
wc_training_last_valid_1f_accel_secwc_training_last_valid_1f_accel_secDECIMAL(8,3)
wc_training_last_valid_2f_half_accel_secwc_training_last_valid_2f_half_accel_secDECIMAL(8,3)
hc_training_last_valid_4f_vs_horse_median_sechc_training_last_valid_4f_vs_horse_median_secDECIMAL(8,3)
hc_training_last_valid_1f_vs_horse_median_sechc_training_last_valid_1f_vs_horse_median_secDECIMAL(8,3)
wc_training_last_valid_6f_vs_horse_median_secwc_training_last_valid_6f_vs_horse_median_secDECIMAL(8,3)
wc_training_last_valid_1f_vs_horse_median_secwc_training_last_valid_1f_vs_horse_median_secDECIMAL(8,3)
hc_training_4f_horse_median_source_counthc_training_4f_horse_median_source_countINT
hc_training_1f_horse_median_source_counthc_training_1f_horse_median_source_countINT
wc_training_6f_horse_median_source_countwc_training_6f_horse_median_source_countINT
wc_training_1f_horse_median_source_countwc_training_1f_horse_median_source_countINT
jockey_source_status_cdjockey_source_status_cdVARCHAR(32)
jockey_year_surface_start_countjockey_year_surface_start_countINT
jockey_year_surface_win_ratejockey_year_surface_win_rateDECIMAL(7,6)
jockey_year_surface_top2_ratejockey_year_surface_top2_rateDECIMAL(7,6)
jockey_year_surface_top3_ratejockey_year_surface_top3_rateDECIMAL(7,6)
jockey_year_distance_start_countjockey_year_distance_start_countINT
jockey_year_distance_win_ratejockey_year_distance_win_rateDECIMAL(7,6)
jockey_year_distance_top2_ratejockey_year_distance_top2_rateDECIMAL(7,6)
jockey_year_distance_top3_ratejockey_year_distance_top3_rateDECIMAL(7,6)
jockey_year_racecourse_surface_start_countjockey_year_racecourse_surface_start_countINT
jockey_year_racecourse_surface_win_ratejockey_year_racecourse_surface_win_rateDECIMAL(7,6)
jockey_year_racecourse_surface_top2_ratejockey_year_racecourse_surface_top2_rateDECIMAL(7,6)
jockey_year_racecourse_surface_top3_ratejockey_year_racecourse_surface_top3_rateDECIMAL(7,6)
jockey_career_surface_start_countjockey_career_surface_start_countINT
jockey_career_surface_win_ratejockey_career_surface_win_rateDECIMAL(7,6)
jockey_career_surface_top2_ratejockey_career_surface_top2_rateDECIMAL(7,6)
jockey_career_surface_top3_ratejockey_career_surface_top3_rateDECIMAL(7,6)
jockey_career_distance_start_countjockey_career_distance_start_countINT
jockey_career_distance_win_ratejockey_career_distance_win_rateDECIMAL(7,6)
jockey_career_distance_top2_ratejockey_career_distance_top2_rateDECIMAL(7,6)
jockey_career_distance_top3_ratejockey_career_distance_top3_rateDECIMAL(7,6)
jockey_career_racecourse_surface_start_countjockey_career_racecourse_surface_start_countINT
jockey_career_racecourse_surface_win_ratejockey_career_racecourse_surface_win_rateDECIMAL(7,6)
jockey_career_racecourse_surface_top2_ratejockey_career_racecourse_surface_top2_rateDECIMAL(7,6)
jockey_career_racecourse_surface_top3_ratejockey_career_racecourse_surface_top3_rateDECIMAL(7,6)
trainer_source_status_cdtrainer_source_status_cdVARCHAR(32)
trainer_year_surface_start_counttrainer_year_surface_start_countINT
trainer_year_surface_win_ratetrainer_year_surface_win_rateDECIMAL(7,6)
trainer_year_surface_top2_ratetrainer_year_surface_top2_rateDECIMAL(7,6)
trainer_year_surface_top3_ratetrainer_year_surface_top3_rateDECIMAL(7,6)
trainer_year_distance_start_counttrainer_year_distance_start_countINT
trainer_year_distance_win_ratetrainer_year_distance_win_rateDECIMAL(7,6)
trainer_year_distance_top2_ratetrainer_year_distance_top2_rateDECIMAL(7,6)
trainer_year_distance_top3_ratetrainer_year_distance_top3_rateDECIMAL(7,6)
trainer_year_racecourse_surface_start_counttrainer_year_racecourse_surface_start_countINT
trainer_year_racecourse_surface_win_ratetrainer_year_racecourse_surface_win_rateDECIMAL(7,6)
trainer_year_racecourse_surface_top2_ratetrainer_year_racecourse_surface_top2_rateDECIMAL(7,6)
trainer_year_racecourse_surface_top3_ratetrainer_year_racecourse_surface_top3_rateDECIMAL(7,6)
trainer_career_surface_start_counttrainer_career_surface_start_countINT
trainer_career_surface_win_ratetrainer_career_surface_win_rateDECIMAL(7,6)
trainer_career_surface_top2_ratetrainer_career_surface_top2_rateDECIMAL(7,6)
trainer_career_surface_top3_ratetrainer_career_surface_top3_rateDECIMAL(7,6)
trainer_career_distance_start_counttrainer_career_distance_start_countINT
trainer_career_distance_win_ratetrainer_career_distance_win_rateDECIMAL(7,6)
trainer_career_distance_top2_ratetrainer_career_distance_top2_rateDECIMAL(7,6)
trainer_career_distance_top3_ratetrainer_career_distance_top3_rateDECIMAL(7,6)
trainer_career_racecourse_surface_start_counttrainer_career_racecourse_surface_start_countINT
trainer_career_racecourse_surface_win_ratetrainer_career_racecourse_surface_win_rateDECIMAL(7,6)
trainer_career_racecourse_surface_top2_ratetrainer_career_racecourse_surface_top2_rateDECIMAL(7,6)
trainer_career_racecourse_surface_top3_ratetrainer_career_racecourse_surface_top3_rateDECIMAL(7,6)
horse_style_source_status_cdhorse_style_source_status_cdVARCHAR(32)
horse_style_source_counthorse_style_source_countINT
nige_style_ratenige_style_rateDECIMAL(7,6)
senko_style_ratesenko_style_rateDECIMAL(7,6)
sashi_style_ratesashi_style_rateDECIMAL(7,6)
oikomi_style_rateoikomi_style_rateDECIMAL(7,6)
member_overall_tai_rankmember_overall_tai_rankSMALLINT
member_overall_tai_mean_diffmember_overall_tai_mean_diffDECIMAL(7,3)
member_overall_tai_max_diffmember_overall_tai_max_diffDECIMAL(7,3)
member_surface_distance_tai_rankmember_surface_distance_tai_rankSMALLINT
member_surface_distance_tai_mean_diffmember_surface_distance_tai_mean_diffDECIMAL(7,3)
member_surface_distance_tai_max_diffmember_surface_distance_tai_max_diffDECIMAL(7,3)
member_surface_distance_epi_rankmember_surface_distance_epi_rankSMALLINT
member_surface_distance_epi_mean_diffmember_surface_distance_epi_mean_diffDECIMAL(7,3)
member_surface_distance_epi_max_diffmember_surface_distance_epi_max_diffDECIMAL(7,3)
member_surface_distance_lpi_rankmember_surface_distance_lpi_rankSMALLINT
member_surface_distance_lpi_mean_diffmember_surface_distance_lpi_mean_diffDECIMAL(7,3)
member_surface_distance_lpi_max_diffmember_surface_distance_lpi_max_diffDECIMAL(7,3)
member_surface_distance_spi_rankmember_surface_distance_spi_rankSMALLINT
member_surface_distance_spi_mean_diffmember_surface_distance_spi_mean_diffDECIMAL(7,3)
member_surface_distance_spi_max_diffmember_surface_distance_spi_max_diffDECIMAL(7,3)
member_surface_distance_kri_rankmember_surface_distance_kri_rankSMALLINT
member_surface_distance_kri_mean_diffmember_surface_distance_kri_mean_diffDECIMAL(7,3)
member_surface_distance_kri_max_diffmember_surface_distance_kri_max_diffDECIMAL(7,3)

tai_h

TAI_Hデータ品質監査tai_h_data_quality_issue10 fields
論理名物理名データ型データ種別レコード種別JVData項目名
tai_h_issue_idtai_h_issue_idBIGINT
tai_h_job_idtai_h_job_idBIGINT
tai_h_chunk_idtai_h_chunk_idBIGINT
issue_levelissue_levelVARCHAR(16)
issue_codeissue_codeVARCHAR(64)
race_idrace_idBIGINT
race_horse_idrace_horse_idBIGINT
issue_messageissue_messageVARCHAR(512)
detail_jsondetail_jsonJSON
occurred_atoccurred_atDATETIME
TAI_H計算ジョブ分割処理tai_h_job_chunk13 fields
論理名物理名データ型データ種別レコード種別JVData項目名
tai_h_chunk_idtai_h_chunk_idBIGINT
tai_h_job_idtai_h_job_idBIGINT
chunk_nochunk_noINT UNSIGNED
race_idrace_idBIGINT
calc_statuscalc_statusVARCHAR(32)
target_race_horse_counttarget_race_horse_countINT UNSIGNED
processed_race_horse_countprocessed_race_horse_countINT UNSIGNED
error_typeerror_typeVARCHAR(128)
error_messageerror_messageVARCHAR(512)
started_atstarted_atDATETIME
finished_atfinished_atDATETIME
created_atcreated_atDATETIME
updated_atupdated_atDATETIME
TAI_H計算ジョブ実行履歴tai_h_job_run18 fields
論理名物理名データ型データ種別レコード種別JVData項目名
tai_h_job_idtai_h_job_idBIGINT
formula_spec_versionformula_spec_versionVARCHAR(32)
formula_algorithm_versionformula_algorithm_versionVARCHAR(32)
target_from_datetarget_from_dateDATE
target_to_datetarget_to_dateDATE
calc_statuscalc_statusVARCHAR(32)
target_race_counttarget_race_countINT UNSIGNED
success_race_countsuccess_race_countINT UNSIGNED
target_race_horse_counttarget_race_horse_countINT UNSIGNED
success_race_horse_countsuccess_race_horse_countINT UNSIGNED
issue_countissue_countINT UNSIGNED
worker_pidworker_pidINT UNSIGNED
error_typeerror_typeVARCHAR(128)
error_messageerror_messageVARCHAR(1024)
started_atstarted_atDATETIME
finished_atfinished_atDATETIME
created_atcreated_atDATETIME
updated_atupdated_atDATETIME
TAI_H計算処理制御tai_h_processing_control7 fields
論理名物理名データ型データ種別レコード種別JVData項目名
control_idcontrol_idTINYINT UNSIGNED
formula_spec_versionformula_spec_versionVARCHAR(32)
formula_algorithm_versionformula_algorithm_versionVARCHAR(32)
active_tai_h_job_idactive_tai_h_job_idBIGINT
worker_pidworker_pidINT UNSIGNED
last_success_atlast_success_atDATETIME
updated_atupdated_atDATETIME
TAI_Hレース別処理チェックポイントtai_h_race_checkpoint18 fields
論理名物理名データ型データ種別レコード種別JVData項目名
race_idrace_idBIGINT
race_daterace_dateDATE
calc_statuscalc_statusVARCHAR(32)
source_taf_job_idsource_taf_job_idBIGINT
source_tfs_job_idsource_tfs_job_idBIGINT
source_revisionsource_revisionBIGINT UNSIGNED
source_stagesource_stageVARCHAR(16)
source_fingerprintsource_fingerprintCHAR(64)
formula_spec_versionformula_spec_versionVARCHAR(32)
formula_algorithm_versionformula_algorithm_versionVARCHAR(32)
target_race_horse_counttarget_race_horse_countINT UNSIGNED
written_race_horse_countwritten_race_horse_countINT UNSIGNED
last_tai_h_job_idlast_tai_h_job_idBIGINT
last_tai_h_chunk_idlast_tai_h_chunk_idBIGINT
started_atstarted_atDATETIME
completed_atcompleted_atDATETIME
error_typeerror_typeVARCHAR(128)
updated_atupdated_atDATETIME
TAI_H出走馬特徴量tai_h_race_horse_feature25 fields
論理名物理名データ型データ種別レコード種別JVData項目名
tai_h_race_horse_feature_idtai_h_race_horse_feature_idBIGINT
tai_h_job_idtai_h_job_idBIGINT
race_idrace_idBIGINT
race_horse_idrace_horse_idBIGINT
horse_idhorse_idBIGINT
race_daterace_dateDATE
source_taf_snapshot_idsource_taf_snapshot_idBIGINT
source_tfs_race_horse_feature_idsource_tfs_race_horse_feature_idBIGINT
tai_basetai_baseDECIMAL(12,9)
training_form_ztraining_form_zDECIMAL(12,9)
training_adjustmenttraining_adjustmentDECIMAL(12,9)
jockey_raw_scorejockey_raw_scoreDECIMAL(12,9)
jockey_score_zjockey_score_zDECIMAL(12,9)
jockey_adjustmentjockey_adjustmentDECIMAL(12,9)
trainer_raw_scoretrainer_raw_scoreDECIMAL(12,9)
trainer_score_ztrainer_score_zDECIMAL(12,9)
trainer_adjustmenttrainer_adjustmentDECIMAL(12,9)
raw_adjustmentraw_adjustmentDECIMAL(12,9)
tai_h_adjustmenttai_h_adjustmentDECIMAL(12,9)
tai_h_indextai_h_indexDECIMAL(12,9)
tai_h_ztai_h_zDECIMAL(12,9)
tai_h_ranktai_h_rankSMALLINT UNSIGNED
risk_codes_jsonrisk_codes_jsonJSON
created_atcreated_atDATETIME
updated_atupdated_atDATETIME

ability

能力値バンドル日付別取込チェックポイントability_bundle_date_checkpoint13 fields
論理名物理名データ型データ種別レコード種別JVData項目名
ability_bundle_install_idability_bundle_install_idBIGINT
race_daterace_dateDATE
checkpoint_statuscheckpoint_statusVARCHAR(32)
business_value_sha256business_value_sha256CHAR(64)
taf_race_counttaf_race_countINT UNSIGNED
taf_race_horse_counttaf_race_horse_countINT UNSIGNED
taf_snapshot_counttaf_snapshot_countINT UNSIGNED
tfs_race_counttfs_race_countINT UNSIGNED
tfs_race_horse_counttfs_race_horse_countINT UNSIGNED
tai_h_race_counttai_h_race_countINT UNSIGNED
tai_h_race_horse_counttai_h_race_horse_countINT UNSIGNED
committed_atcommitted_atDATETIME
updated_atupdated_atDATETIME
能力値バンドル取込履歴ability_bundle_install23 fields
論理名物理名データ型データ種別レコード種別JVData項目名
ability_bundle_install_idability_bundle_install_idBIGINT
setup_run_idsetup_run_idBIGINT
bundle_idbundle_idVARCHAR(96)
manifest_sha256manifest_sha256CHAR(64)
target_from_datetarget_from_dateDATE
target_to_datetarget_to_dateDATE
bundle_data_from_datebundle_data_from_dateDATE
bundle_data_to_datebundle_data_to_dateDATE
install_stageinstall_stageVARCHAR(32)
install_statusinstall_statusVARCHAR(32)
last_completed_datelast_completed_dateDATE
taf_job_idtaf_job_idBIGINT
tfs_job_idtfs_job_idBIGINT
tai_h_job_idtai_h_job_idBIGINT
imported_race_countimported_race_countINT UNSIGNED
imported_race_horse_countimported_race_horse_countINT UNSIGNED
imported_snapshot_countimported_snapshot_countINT UNSIGNED
imported_tai_h_race_countimported_tai_h_race_countINT UNSIGNED
imported_tai_h_race_horse_countimported_tai_h_race_horse_countINT UNSIGNED
failure_codefailure_codeVARCHAR(128)
started_atstarted_atDATETIME
completed_atcompleted_atDATETIME
updated_atupdated_atDATETIME
能力値バンドルレース取得元ability_bundle_race_origin11 fields
論理名物理名データ型データ種別レコード種別JVData項目名
race_idrace_idBIGINT
ability_bundle_install_idability_bundle_install_idBIGINT
bundle_idbundle_idVARCHAR(96)
portable_identity_sha256portable_identity_sha256CHAR(64)
origin_typeorigin_typeVARCHAR(32)
taf_job_idtaf_job_idBIGINT
tfs_job_idtfs_job_idBIGINT
tai_h_job_idtai_h_job_idBIGINT
publish_readypublish_readyTINYINT(1)
created_atcreated_atDATETIME
updated_atupdated_atDATETIME
能力値入力データ日付別改訂管理ability_source_date_revision5 fields
論理名物理名データ型データ種別レコード種別JVData項目名
race_daterace_dateDATE
source_revisionsource_revisionBIGINT UNSIGNED
source_stagesource_stageVARCHAR(16)
revision_fingerprintrevision_fingerprintCHAR(64)
updated_atupdated_atDATETIME

audit

config

出走別着度数の旧データ復旧状態config_ck_legacy_recovery_state9 fields
論理名物理名データ型データ種別レコード種別JVData項目名
recovery_versionrecovery_versionINT
statestateVARCHAR(24)
from_timefrom_timeCHAR(14)
to_timeto_timeCHAR(14)
target_counttarget_countINT
missing_countmissing_countINT
last_errorlast_errorVARCHAR(512)
started_atstarted_atDATETIME(6)
completed_atcompleted_atDATETIME(6)
出走別着度数の反映待ち着度数config_ck_pending_finish12 fields
論理名物理名データ型データ種別レコード種別JVData項目名
pending_finish_idpending_finish_idBIGINT
payload_idpayload_idBIGINT
target_cdtarget_cdCHAR(1)
stats_scope_cdstats_scope_cdINT
category_cdcategory_cdVARCHAR(32)
condition_cdcondition_cdVARCHAR(40)
first_countfirst_countINT
second_countsecond_countINT
third_countthird_countINT
fourth_countfourth_countINT
fifth_countfifth_countINT
other_countother_countINT
出走別着度数の反映待ちデータconfig_ck_pending_payload26 fields
論理名物理名データ型データ種別レコード種別JVData項目名
payload_idpayload_idBIGINT
receipt_idreceipt_idBIGINT
payload_versionpayload_versionINT
source_created_datesource_created_dateDATE
source_file_timestampsource_file_timestampCHAR(14)
source_file_namesource_file_nameVARCHAR(255)
source_file_record_nosource_file_record_noBIGINT
data_kubun_cddata_kubun_cdCHAR(1)
payload_hashpayload_hashBINARY(32)
import_job_idimport_job_idBIGINT
import_execution_idimport_execution_idBIGINT
legacy_recovery_versionlegacy_recovery_versionINT
warning_textwarning_textTEXT
jockey_cdjockey_cdVARCHAR(5)
trainer_cdtrainer_cdVARCHAR(5)
flat_main_prize_yenflat_main_prize_yenBIGINT
jump_main_prize_yenjump_main_prize_yenBIGINT
flat_added_prize_yenflat_added_prize_yenBIGINT
jump_added_prize_yenjump_added_prize_yenBIGINT
flat_earned_prize_yenflat_earned_prize_yenBIGINT
jump_earned_prize_yenjump_earned_prize_yenBIGINT
registered_race_countregistered_race_countINT
nige_countnige_countINT
senko_countsenko_countINT
sashi_countsashi_countINT
oikomi_countoikomi_countINT
出走別着度数の反映待ち関係者成績config_ck_pending_person9 fields
論理名物理名データ型データ種別レコード種別JVData項目名
pending_person_idpending_person_idBIGINT
payload_idpayload_idBIGINT
role_cdrole_cdCHAR(1)
stats_scope_cdstats_scope_cdINT
stats_yearstats_yearINT
flat_main_prize_yenflat_main_prize_yenBIGINT
jump_main_prize_yenjump_main_prize_yenBIGINT
flat_added_prize_yenflat_added_prize_yenBIGINT
jump_added_prize_yenjump_added_prize_yenBIGINT
出走別着度数の受信状態config_ck_receipt_state24 fields
論理名物理名データ型データ種別レコード種別JVData項目名
receipt_idreceipt_idBIGINT
race_scope_cdrace_scope_cdINT
race_daterace_dateDATE
racecourse_cdracecourse_cdCHAR(2)
meeting_nomeeting_noINT
schedule_day_noschedule_day_noINT
race_norace_noINT
horse_reg_nohorse_reg_noCHAR(10)
statestateVARCHAR(32)
source_created_datesource_created_dateDATE
source_file_timestampsource_file_timestampCHAR(14)
source_file_namesource_file_nameVARCHAR(255)
source_file_record_nosource_file_record_noBIGINT
data_kubun_cddata_kubun_cdCHAR(1)
payload_versionpayload_versionINT
payload_hashpayload_hashBINARY(32)
import_job_idimport_job_idBIGINT
import_execution_idimport_execution_idBIGINT
evidence_import_issue_idevidence_import_issue_idBIGINT
legacy_recovery_versionlegacy_recovery_versionINT
reasonreasonVARCHAR(512)
received_atreceived_atDATETIME(6)
updated_atupdated_atDATETIME(6)
applied_atapplied_atDATETIME(6)
レースペース判定の処理待ち管理config_ra_race_pace_pending7 fields
論理名物理名データ型データ種別レコード種別JVData項目名
race_idrace_idBIGINT
source_fingerprintsource_fingerprintCHAR(64)
pending_reason_cdpending_reason_cdVARCHAR(40)
retry_countretry_countINT UNSIGNED
last_error_typelast_error_typeVARCHAR(128)
first_pending_atfirst_pending_atDATETIME(6)
last_pending_atlast_pending_atDATETIME(6)
レースレコード反映状態config_race_record_state10 fields
論理名物理名データ型データ種別レコード種別JVData項目名
race_scope_cdrace_scope_cdINT
schedule_yearschedule_yearINT
racecourse_cdracecourse_cdVARCHAR(4)
meeting_nomeeting_noINT
schedule_day_noschedule_day_noINT
race_norace_noINT
effective_source_race_dateeffective_source_race_dateDATE
effective_state_cdeffective_state_cdTINYINT
source_record_specsource_record_specVARCHAR(2)
updated_atupdated_atDATETIME(6)
速報レース結果の反映待ち管理config_realtime_postrace_pending6 fields
論理名物理名データ型データ種別レコード種別JVData項目名
race_idrace_idBIGINT
first_pending_atfirst_pending_atDATETIME
last_pending_atlast_pending_atDATETIME
retry_countretry_countINT UNSIGNED
last_import_job_idlast_import_job_idBIGINT
last_issue_codelast_issue_codeVARCHAR(64)
開催日程レコード反映状態config_schedule_record_state7 fields
論理名物理名データ型データ種別レコード種別JVData項目名
schedule_yearschedule_yearINT
racecourse_cdracecourse_cdVARCHAR(4)
meeting_nomeeting_noINT
schedule_day_noschedule_day_noINT
effective_source_schedule_dateeffective_source_schedule_dateDATE
effective_state_cdeffective_state_cdTINYINT
updated_atupdated_atDATETIME(6)
スキーママイグレーション管理config_schema_migration4 fields
論理名物理名データ型データ種別レコード種別JVData項目名
マイグレーションIDmigration_idVARCHAR(64)
適用日時applied_atDATETIME
SQLチェックサムchecksum_sha256CHAR(64)
アプリケーションバージョンapp_versionVARCHAR(32)
セットアップ再開完了単位config_setup_resume_completed_unit15 fields
論理名物理名データ型データ種別レコード種別JVData項目名
セットアップ再開完了単位IDsetup_resume_completed_unit_idBIGINT
セットアップ実行IDsetup_run_idBIGINT
セットアップ開始FromTimesetup_from_timeVARCHAR(14)
DataSpecdata_specVARCHAR(16)
取込Passimport_pass_cdVARCHAR(32)
期間チャンク番号period_chunk_noINT UNSIGNED
JVOpen FromTimejvopen_from_timeVARCHAR(29)
ログ表示用Fromlog_from_timeVARCHAR(14)
ログ表示用Tolog_to_timeVARCHAR(14)
成功後lastfiletimestamplastfiletimestamp_afterVARCHAR(14)
実行結果コードexecution_status_cdTINYINT UNSIGNED
警告件数warning_countINT UNSIGNED
エラー件数error_countINT UNSIGNED
取込実行IDimport_execution_idBIGINT
完了日時completed_atDATETIME
セットアップ再開実行config_setup_resume_run9 fields
論理名物理名データ型データ種別レコード種別JVData項目名
セットアップ実行IDsetup_run_idBIGINT
セットアップ年数setup_yearsTINYINT UNSIGNED
セットアップ開始FromTimesetup_from_timeVARCHAR(14)
対象期間開始target_period_fromDATETIME
対象期間終了target_period_toDATETIME
実行状態コードrun_status_cdTINYINT UNSIGNED
開始日時started_atDATETIME
完了日時completed_atDATETIME
クリア日時cleared_atDATETIME
セットアップ再開状態config_setup_resume_state13 fields
論理名物理名データ型データ種別レコード種別JVData項目名
セットアップ再開状態IDsetup_resume_state_idTINYINT UNSIGNED
セットアップ実行IDsetup_run_idBIGINT
再開状態コードresume_status_cdTINYINT UNSIGNED
セットアップ年数setup_yearsTINYINT UNSIGNED
セットアップ開始FromTimesetup_from_timeVARCHAR(14)
対象期間開始target_period_fromDATETIME
対象期間終了target_period_toDATETIME
現在DataSpeccurrent_data_specVARCHAR(16)
現在取込Passcurrent_import_pass_cdVARCHAR(32)
現在期間チャンク番号current_period_chunk_noINT UNSIGNED
中断要求日時requested_stop_atDATETIME
中断完了日時paused_atDATETIME
更新日時updated_atDATETIME

user

ユーザフリーメモuser_free_note7 fields
論理名物理名データ型データ種別レコード種別JVData項目名
note_idnote_idCHAR(32)
titletitleVARCHAR(100)
bodybodyMEDIUMTEXT
deleteddeletedTINYINT(1)
revisionrevisionBIGINT
created_atcreated_atDATETIME(6)
updated_atupdated_atDATETIME(6)
ユーザレース別馬メモuser_horse_memo12 fields
論理名物理名データ型データ種別レコード種別JVData項目名
race_scope_cdrace_scope_cdTINYINT UNSIGNED
schedule_yearschedule_yearSMALLINT UNSIGNED
racecourse_cdracecourse_cdCHAR(2)
meeting_nomeeting_noTINYINT UNSIGNED
schedule_day_noschedule_day_noTINYINT UNSIGNED
race_norace_noTINYINT UNSIGNED
horse_reg_nohorse_reg_noCHAR(10)
memo_textmemo_textTEXT
race_date_at_saverace_date_at_saveDATE
created_atcreated_atDATETIME(6)
updated_atupdated_atDATETIME(6)
ユーザ馬メモ旧形式user_horse_memo_legacy4 fields
論理名物理名データ型データ種別レコード種別JVData項目名
horse_reg_nohorse_reg_noCHAR(10)
memo_textmemo_textTEXT
created_atcreated_atDATETIME(6)
updated_atupdated_atDATETIME(6)
ユーザノート参照情報user_note_reference11 fields
論理名物理名データ型データ種別レコード種別JVData項目名
race_scope_cdrace_scope_cdTINYINT UNSIGNED
schedule_yearschedule_yearSMALLINT UNSIGNED
racecourse_cdracecourse_cdCHAR(2)
meeting_nomeeting_noTINYINT UNSIGNED
schedule_day_noschedule_day_noTINYINT UNSIGNED
race_norace_noTINYINT UNSIGNED
horse_reg_nohorse_reg_noVARCHAR(10)
race_daterace_dateDATE
race_namerace_nameVARCHAR(200)
grade_cdgrade_cdVARCHAR(1)
horse_namehorse_nameVARCHAR(100)
ユーザ購入記録user_purchase21 fields
論理名物理名データ型データ種別レコード種別JVData項目名
purchase_idpurchase_idCHAR(32)
revisionrevisionBIGINT
race_scope_cdrace_scope_cdTINYINT UNSIGNED
schedule_yearschedule_yearSMALLINT UNSIGNED
racecourse_cdracecourse_cdCHAR(2)
meeting_nomeeting_noTINYINT UNSIGNED
schedule_day_noschedule_day_noTINYINT UNSIGNED
race_norace_noTINYINT UNSIGNED
race_date_at_saverace_date_at_saveDATE
race_name_at_saverace_name_at_saveVARCHAR(200)
track_cd_at_savetrack_cd_at_saveCHAR(2)
class_at_saveclass_at_saveVARCHAR(30)
selectionselectionVARCHAR(12)
amount_yenamount_yenBIGINT
memo_textmemo_textTEXT
manual_statusmanual_statusVARCHAR(8)
manual_payout_yenmanual_payout_yenBIGINT
manual_refund_yenmanual_refund_yenBIGINT
created_atcreated_atDATETIME(6)
updated_atupdated_atDATETIME(6)
ユーザ購入記録リクエスト管理user_purchase_request3 fields
論理名物理名データ型データ種別レコード種別JVData項目名
request_idrequest_idCHAR(32)
payload_hashpayload_hashCHAR(64)
created_atcreated_atDATETIME(6)
ユーザレースメモuser_race_memo9 fields
論理名物理名データ型データ種別レコード種別JVData項目名
race_scope_cdrace_scope_cdTINYINT UNSIGNED
schedule_yearschedule_yearSMALLINT UNSIGNED
racecourse_cdracecourse_cdCHAR(2)
meeting_nomeeting_noTINYINT UNSIGNED
schedule_day_noschedule_day_noTINYINT UNSIGNED
race_norace_noTINYINT UNSIGNED
memo_textmemo_textTEXT
created_atcreated_atDATETIME(6)
updated_atupdated_atDATETIME(6)
ユーザ注目馬user_watch_horse4 fields
論理名物理名データ型データ種別レコード種別JVData項目名
horse_reg_nohorse_reg_noCHAR(10)
created_atcreated_atDATETIME(6)
updated_atupdated_atDATETIME(6)

maintenance

ペース計算ジョブ分割処理pace_job_chunk18 fields
論理名物理名データ型データ種別レコード種別JVData項目名
pace_chunk_idpace_chunk_idBIGINT
pace_job_idpace_job_idBIGINT
chunk_nochunk_noINT UNSIGNED
target_race_ids_jsontarget_race_ids_jsonJSON
target_race_ids_sha256target_race_ids_sha256CHAR(64)
calc_statuscalc_statusVARCHAR(20)
target_counttarget_countINT UNSIGNED
classified_countclassified_countINT UNSIGNED
not_classifiable_countnot_classifiable_countINT UNSIGNED
excluded_countexcluded_countINT UNSIGNED
failed_countfailed_countINT UNSIGNED
reason_counts_jsonreason_counts_jsonJSON
error_typeerror_typeVARCHAR(128)
error_messageerror_messageVARCHAR(512)
started_atstarted_atDATETIME(6)
finished_atfinished_atDATETIME(6)
created_atcreated_atDATETIME(6)
updated_atupdated_atDATETIME(6)
ペース計算ジョブ実行履歴pace_job_run21 fields
論理名物理名データ型データ種別レコード種別JVData項目名
pace_job_idpace_job_idBIGINT
trigger_typetrigger_typeVARCHAR(20)
setup_run_idsetup_run_idBIGINT
source_run_identitysource_run_identityVARCHAR(64)
target_from_datetarget_from_dateDATE
target_to_datetarget_to_dateDATE
model_idmodel_idCHAR(64)
manifest_sha256manifest_sha256CHAR(64)
calc_statuscalc_statusVARCHAR(20)
target_counttarget_countINT UNSIGNED
classified_countclassified_countINT UNSIGNED
not_classifiable_countnot_classifiable_countINT UNSIGNED
excluded_countexcluded_countINT UNSIGNED
failed_countfailed_countINT UNSIGNED
reason_counts_jsonreason_counts_jsonJSON
error_typeerror_typeVARCHAR(128)
error_messageerror_messageVARCHAR(512)
started_atstarted_atDATETIME(6)
finished_atfinished_atDATETIME(6)
created_atcreated_atDATETIME(6)
updated_atupdated_atDATETIME(6)
競走馬詳細情報の補完処理状態um_profile_backfill4 fields
論理名物理名データ型データ種別レコード種別JVData項目名
job_keyjob_keyVARCHAR(32)
statestateVARCHAR(16)
started_atstarted_atDATETIME
completed_atcompleted_atDATETIME

Views

予測用の事前情報と結果情報を分けたML用ビューと、公開済み能力値のビューです。予測では対象レースの結果列や計算時点に注意してください。

学習時の目的変数に使うレース結果・出走馬結果vw_ml_race_horse_label27 fields

参照元:core_ra_race、core_se_race_horse

カラム名データ型説明
race_idBIGINTレースを一意に識別するID
race_horse_idBIGINT1レース内の出走馬を一意に識別するID
horse_idBIGINT競走馬を識別するJV2AI内のID
race_dateDATEレースの施行日
race_scope_cdTINYINT UNSIGNEDレースの取得・管理範囲を表す区分コード
body_weight_kgSMALLINT UNSIGNED馬体重。単位はkg
body_weight_diff_kgSMALLINT前走からの馬体重増減。単位はkg
abnormality_cdCHAR(1)競走中止、除外などの異常区分コード
arrival_orderTINYINT UNSIGNED入線順位。失格・降着確定前の順位を扱います
finish_orderTINYINT UNSIGNED確定着順。目的変数として利用する基本列です
is_dead_heatTINYINT(1)同着かどうかを表すフラグ
dead_heat_count_otherTINYINT UNSIGNED同着となった他馬の頭数
finish_time_secDECIMAL(5,1)走破時計。単位は秒
margin_cdCHAR(3)着差コード
margin_secDECIMAL(5,2)定義済みの着差コードを秒換算した値。未定義形式はNULL
margin_plus_cdCHAR(3)補助的な着差コード
margin_plus_secDECIMAL(5,2)補助的な着差コードを同じ規則で秒換算した値。未定義形式はNULL
margin_plus_plus_cdCHAR(3)追加の補助的な着差コード
margin_plus_plus_secDECIMAL(5,2)追加の補助的な着差コードを同じ規則で秒換算した値。未定義形式はNULL
corner1_orderTINYINT UNSIGNED第1コーナー通過順位
corner2_orderTINYINT UNSIGNED第2コーナー通過順位
corner3_orderTINYINT UNSIGNED第3コーナー通過順位
corner4_orderTINYINT UNSIGNED第4コーナー通過順位
last_4f_secDECIMAL(4,1)上がり4ハロン時計。単位は秒
last_3f_secDECIMAL(4,1)上がり3ハロン時計。単位は秒
time_diff_secDECIMAL(5,1)基準馬または勝ち馬との差を秒換算した値
running_style_cdCHAR(1)脚質コード
参照・計算条件のSQLを確認する
select `r`.`race_id` AS `race_id`,`se`.`race_horse_id` AS `race_horse_id`,`se`.`horse_id` AS `horse_id`,`r`.`race_date` AS `race_date`,`r`.`race_scope_cd` AS `race_scope_cd`,`ser`.`body_weight_kg` AS `body_weight_kg`,`ser`.`body_weight_diff_kg` AS `body_weight_diff_kg`,`ser`.`abnormality_cd` AS `abnormality_cd`,`ser`.`arrival_order` AS `arrival_order`,`ser`.`finish_order` AS `finish_order`,`ser`.`is_dead_heat` AS `is_dead_heat`,`ser`.`dead_heat_count_other` AS `dead_heat_count_other`,`ser`.`finish_time_sec` AS `finish_time_sec`,`ser`.`margin_cd` AS `margin_cd`,`ser`.`margin_sec` AS `margin_sec`,`ser`.`margin_plus_cd` AS `margin_plus_cd`,`ser`.`margin_plus_sec` AS `margin_plus_sec`,`ser`.`margin_plus_plus_cd` AS `margin_plus_plus_cd`,`ser`.`margin_plus_plus_sec` AS `margin_plus_plus_sec`,`ser`.`corner1_order` AS `corner1_order`,`ser`.`corner2_order` AS `corner2_order`,`ser`.`corner3_order` AS `corner3_order`,`ser`.`corner4_order` AS `corner4_order`,`ser`.`last_4f_sec` AS `last_4f_sec`,`ser`.`last_3f_sec` AS `last_3f_sec`,`ser`.`time_diff_sec` AS `time_diff_sec`,`ser`.`running_style_cd` AS `running_style_cd`
FROM ((`core_se_race_horse_result` `ser`
JOIN `core_se_race_horse` `se` on((`se`.`race_horse_id` = `ser`.`race_horse_id`)))
JOIN `core_ra_race` `r` on((`r`.`race_id` = `se`.`race_id`)))
予測・分析用のレースと出走馬の事前情報vw_ml_race_horse_prerace_base41 fields

参照元:core_se_race_horse、dim_um_horse

カラム名データ型説明
race_idBIGINTレースを一意に識別するID
race_horse_idBIGINT1レース内の出走馬を一意に識別するID
race_scope_cdTINYINT UNSIGNEDレースの取得・管理範囲を表す区分コード
race_dateDATEレースの施行日
racecourse_cdCHAR(2)競馬場コード
meeting_noTINYINT UNSIGNED開催回次
schedule_day_noTINYINT UNSIGNED開催日次
race_noTINYINT UNSIGNEDレース番号
race_name_mainVARCHAR(60)レース名
grade_cdCHAR(1)グレード区分コード
race_type_cdCHAR(2)競走種別コード
race_symbol_cdCHAR(3)レース記号コード
weight_type_cdCHAR(1)重量種別コード
condition_cd_2yoCHAR(3)2歳条件コード
condition_cd_3yoCHAR(3)3歳条件コード
condition_cd_4yoCHAR(3)4歳条件コード
condition_cd_5upCHAR(3)5歳以上条件コード
condition_cd_youngestCHAR(3)出走条件の最少年齢側を表すコード
distance_mSMALLINT UNSIGNED距離。単位はメートル
track_cdCHAR(2)トラックコード
course_cdCHAR(2)コースコード
scheduled_start_timeTIME発走予定時刻
is_cancelledTINYINT(1)レースが中止扱いかどうかを表すフラグ
horse_idBIGINT競走馬を識別するJV2AI内のID
horse_reg_noCHAR(10)血統登録番号
horse_nameVARCHAR(36)競走馬名
frame_noTINYINT UNSIGNED枠番
horse_noTINYINT UNSIGNED馬番
horse_symbol_cdCHAR(2)馬記号コード
sex_cdCHAR(1)性別コード
breed_cdCHAR(1)品種コード
coat_color_cdCHAR(2)毛色コード
horse_ageTINYINT UNSIGNEDレース時点の馬齢
affiliation_cdCHAR(1)所属コード
trainer_cdCHAR(5)調教師コード
owner_cdCHAR(6)馬主コード
carried_weight_kgDECIMAL(4,1)負担重量。単位はkg
is_blinkerTINYINT(1)ブリンカー着用有無を表すフラグ
jockey_cdCHAR(5)騎手コード
apprentice_cdCHAR(1)見習騎手区分コード
is_horse_identity_resolvedINT血統登録番号が有効に解決できているかを表すフラグ。未解決海外馬などは0になります
参照・計算条件のSQLを確認する
select `r`.`race_id` AS `race_id`,`se`.`race_horse_id` AS `race_horse_id`,`r`.`race_scope_cd` AS `race_scope_cd`,`r`.`race_date` AS `race_date`,`r`.`racecourse_cd` AS `racecourse_cd`,`r`.`meeting_no` AS `meeting_no`,`r`.`schedule_day_no` AS `schedule_day_no`,`r`.`race_no` AS `race_no`,`r`.`race_name_main` AS `race_name_main`,`r`.`grade_cd` AS `grade_cd`,`r`.`race_type_cd` AS `race_type_cd`,`r`.`race_symbol_cd` AS `race_symbol_cd`,`r`.`weight_type_cd` AS `weight_type_cd`,`r`.`condition_cd_2yo` AS `condition_cd_2yo`,`r`.`condition_cd_3yo` AS `condition_cd_3yo`,`r`.`condition_cd_4yo` AS `condition_cd_4yo`,`r`.`condition_cd_5up` AS `condition_cd_5up`,`r`.`condition_cd_youngest` AS `condition_cd_youngest`,`r`.`distance_m` AS `distance_m`,`r`.`track_cd` AS `track_cd`,`r`.`course_cd` AS `course_cd`,`r`.`scheduled_start_time` AS `scheduled_start_time`,`r`.`is_cancelled` AS `is_cancelled`,`se`.`horse_id` AS `horse_id`,`um`.`horse_reg_no` AS `horse_reg_no`,`um`.`horse_name` AS `horse_name`,`se`.`frame_no` AS `frame_no`,`se`.`horse_no` AS `horse_no`,`se`.`horse_symbol_cd` AS `horse_symbol_cd`,`se`.`sex_cd` AS `sex_cd`,`se`.`breed_cd` AS `breed_cd`,`se`.`coat_color_cd` AS `coat_color_cd`,`se`.`horse_age` AS `horse_age`,`se`.`affiliation_cd` AS `affiliation_cd`,`se`.`trainer_cd` AS `trainer_cd`,`se`.`owner_cd` AS `owner_cd`,`se`.`carried_weight_kg` AS `carried_weight_kg`,`se`.`is_blinker` AS `is_blinker`,`se`.`jockey_cd` AS `jockey_cd`,`se`.`apprentice_cd` AS `apprentice_cd`,(case when (`um`.`horse_reg_no` is null) then 0 when (`um`.`horse_reg_no` = '0000000000') then 0 else 1 end) AS `is_horse_identity_resolved`
FROM ((`core_ra_race` `r`
JOIN `core_se_race_horse` `se` on((`se`.`race_id` = `r`.`race_id`)))
JOIN `dim_um_horse` `um` on((`um`.`horse_id` = `se`.`horse_id`)))
坂路・ウッドチップ調教の履歴を共通形式で参照vw_ml_training_history26 fields

参照元:aux_hc_training、aux_wc_training

カラム名データ型説明
training_type_cdVARCHAR(2)調教種別。坂路調教はHC、ウッドチップ調教はWC
training_idBIGINT元テーブル上の調教ID
horse_reg_noCHAR(10)血統登録番号
training_center_cdCHAR(1)調教場コード
training_datetimeDATETIME調教日時
course_cdVARCHAR(1)調教コースコード。坂路調教行ではNULL
direction_cdVARCHAR(1)調教の回り方向コード。坂路調教行ではNULL
total_10f_secDECIMAL(4,1)10ハロンタイム合計。単位は秒。坂路調教行ではNULL
lap_2000_1800_secDECIMAL(3,1)2000m〜1800mのラップタイム。単位は秒。坂路調教行ではNULL
total_9f_secDECIMAL(4,1)9ハロンタイム合計。単位は秒。坂路調教行ではNULL
lap_1800_1600_secDECIMAL(3,1)1800m〜1600mのラップタイム。単位は秒。坂路調教行ではNULL
total_8f_secDECIMAL(4,1)8ハロンタイム合計。単位は秒。坂路調教行ではNULL
lap_1600_1400_secDECIMAL(3,1)1600m〜1400mのラップタイム。単位は秒。坂路調教行ではNULL
total_7f_secDECIMAL(4,1)7ハロンタイム合計。単位は秒。坂路調教行ではNULL
lap_1400_1200_secDECIMAL(3,1)1400m〜1200mのラップタイム。単位は秒。坂路調教行ではNULL
total_6f_secDECIMAL(4,1)6ハロンタイム合計。単位は秒。坂路調教行ではNULL
lap_1200_1000_secDECIMAL(3,1)1200m〜1000mのラップタイム。単位は秒。坂路調教行ではNULL
total_5f_secDECIMAL(4,1)5ハロンタイム合計。単位は秒。坂路調教行ではNULL
lap_1000_800_secDECIMAL(3,1)1000m〜800mのラップタイム。単位は秒。坂路調教行ではNULL
total_4f_secDECIMAL(4,1)4ハロンタイム合計。単位は秒
lap_800_600_secDECIMAL(3,1)800m〜600mのラップタイム。単位は秒
total_3f_secDECIMAL(4,1)3ハロンタイム合計。単位は秒
lap_600_400_secDECIMAL(3,1)600m〜400mのラップタイム。単位は秒
total_2f_secDECIMAL(4,1)2ハロンタイム合計。単位は秒
lap_400_200_secDECIMAL(3,1)400m〜200mのラップタイム。単位は秒
lap_200_0_secDECIMAL(3,1)200m〜ゴールまでのラップタイム。単位は秒
参照・計算条件のSQLを確認する
select 'HC' AS `training_type_cd`,`hc`.`hc_training_id` AS `training_id`,`hc`.`horse_reg_no` AS `horse_reg_no`,`hc`.`training_center_cd` AS `training_center_cd`,`hc`.`training_datetime` AS `training_datetime`,cast(NULL as char(1) charset utf8mb4) AS `course_cd`,cast(NULL as char(1) charset utf8mb4) AS `direction_cd`,cast(NULL as decimal(4,1)) AS `total_10f_sec`,cast(NULL as decimal(3,1)) AS `lap_2000_1800_sec`,cast(NULL as decimal(4,1)) AS `total_9f_sec`,cast(NULL as decimal(3,1)) AS `lap_1800_1600_sec`,cast(NULL as decimal(4,1)) AS `total_8f_sec`,cast(NULL as decimal(3,1)) AS `lap_1600_1400_sec`,cast(NULL as decimal(4,1)) AS `total_7f_sec`,cast(NULL as decimal(3,1)) AS `lap_1400_1200_sec`,cast(NULL as decimal(4,1)) AS `total_6f_sec`,cast(NULL as decimal(3,1)) AS `lap_1200_1000_sec`,cast(NULL as decimal(4,1)) AS `total_5f_sec`,cast(NULL as decimal(3,1)) AS `lap_1000_800_sec`,`hc`.`total_4f_sec` AS `total_4f_sec`,`hc`.`lap_800_600_sec` AS `lap_800_600_sec`,`hc`.`total_3f_sec` AS `total_3f_sec`,`hc`.`lap_600_400_sec` AS `lap_600_400_sec`,`hc`.`total_2f_sec` AS `total_2f_sec`,`hc`.`lap_400_200_sec` AS `lap_400_200_sec`,`hc`.`lap_200_0_sec` AS `lap_200_0_sec`
FROM `aux_hc_training` `hc`
UNION ALL select 'WC' AS `training_type_cd`,`wc`.`wc_training_id` AS `training_id`,`wc`.`horse_reg_no` AS `horse_reg_no`,`wc`.`training_center_cd` AS `training_center_cd`,`wc`.`training_datetime` AS `training_datetime`,`wc`.`course_cd` AS `course_cd`,`wc`.`direction_cd` AS `direction_cd`,`wc`.`total_10f_sec` AS `total_10f_sec`,`wc`.`lap_2000_1800_sec` AS `lap_2000_1800_sec`,`wc`.`total_9f_sec` AS `total_9f_sec`,`wc`.`lap_1800_1600_sec` AS `lap_1800_1600_sec`,`wc`.`total_8f_sec` AS `total_8f_sec`,`wc`.`lap_1600_1400_sec` AS `lap_1600_1400_sec`,`wc`.`total_7f_sec` AS `total_7f_sec`,`wc`.`lap_1400_1200_sec` AS `lap_1400_1200_sec`,`wc`.`total_6f_sec` AS `total_6f_sec`,`wc`.`lap_1200_1000_sec` AS `lap_1200_1000_sec`,`wc`.`total_5f_sec` AS `total_5f_sec`,`wc`.`lap_1000_800_sec` AS `lap_1000_800_sec`,`wc`.`total_4f_sec` AS `total_4f_sec`,`wc`.`lap_800_600_sec` AS `lap_800_600_sec`,`wc`.`total_3f_sec` AS `total_3f_sec`,`wc`.`lap_600_400_sec` AS `lap_600_400_sec`,`wc`.`total_2f_sec` AS `total_2f_sec`,`wc`.`lap_400_200_sec` AS `lap_400_200_sec`,`wc`.`lap_200_0_sec` AS `lap_200_0_sec`
FROM `aux_wc_training` `wc`
公開済みの馬能力スナップショットvw_taf_published_horse_ability_snapshot64 fields

参照元:ability_bundle_install、ability_bundle_race_origin、taf_date_checkpoint、taf_processing_control

カラム名データ型説明
horse_ability_snapshot_idBIGINT定義SQLを参照
taf_job_idBIGINT定義SQLを参照
as_of_race_idBIGINT定義SQLを参照
as_of_race_horse_idBIGINT定義SQLを参照
horse_idBIGINT競走馬ID
as_of_race_dateDATE定義SQLを参照
snapshot_scope_typeVARCHAR(64)定義SQLを参照
target_surface_cdCHAR(1)定義SQLを参照
target_distance_mSMALLINT定義SQLを参照
target_distance_categoryVARCHAR(32)定義SQLを参照
target_racecourse_cdCHAR(2)定義SQLを参照
tai_indexDECIMAL(6,3)定義SQLを参照
tai_latent_zDECIMAL(7,4)定義SQLを参照
epi_indexDECIMAL(6,3)定義SQLを参照
lpi_indexDECIMAL(6,3)定義SQLを参照
spi_indexDECIMAL(6,3)定義SQLを参照
kri_indexDECIMAL(6,3)定義SQLを参照
tai_confidence_scoreDECIMAL(5,4)定義SQLを参照
epi_confidence_scoreDECIMAL(5,4)定義SQLを参照
lpi_confidence_scoreDECIMAL(5,4)定義SQLを参照
spi_confidence_scoreDECIMAL(5,4)定義SQLを参照
kri_confidence_scoreDECIMAL(5,4)定義SQLを参照
epi_evidence_levelVARCHAR(16)定義SQLを参照
lpi_evidence_levelVARCHAR(16)定義SQLを参照
spi_evidence_levelVARCHAR(16)定義SQLを参照
kri_evidence_levelVARCHAR(16)定義SQLを参照
tai_evidence_levelVARCHAR(16)定義SQLを参照
weighted_ability_resid_secDECIMAL(8,3)定義SQLを参照
weighted_time_resid_secDECIMAL(8,3)定義SQLを参照
speed_zDECIMAL(6,3)定義SQLを参照
front3_zDECIMAL(6,3)定義SQLを参照
late3_zDECIMAL(6,3)定義SQLを参照
early_position_zDECIMAL(6,3)定義SQLを参照
mid_position_zDECIMAL(6,3)定義SQLを参照
front_lead_zDECIMAL(6,3)定義SQLを参照
closing_zDECIMAL(6,3)定義SQLを参照
rear_weighted_gain_zDECIMAL(6,3)定義SQLを参照
early_hold_zDECIMAL(6,3)定義SQLを参照
early_pressure_load_zDECIMAL(6,3)定義SQLを参照
late_context_response_zDECIMAL(6,3)定義SQLを参照
no_fade_zDECIMAL(6,3)定義SQLを参照
front_survival_zDECIMAL(6,3)定義SQLを参照
late3_sustain_zDECIMAL(6,3)定義SQLを参照
sustained_context_load_zDECIMAL(6,3)定義SQLを参照
closing_acceleration_zDECIMAL(6,3)定義SQLを参照
relative_last3_zDECIMAL(6,3)定義SQLを参照
spi_zDECIMAL(6,3)定義SQLを参照
corner_gain_zDECIMAL(6,3)定義SQLを参照
kri_zDECIMAL(6,3)定義SQLを参照
source_run_countSMALLINT定義SQLを参照
valid_source_run_countSMALLINT定義SQLを参照
selected_run_countSMALLINT定義SQLを参照
single_extreme_poor_run_excluded_countSMALLINT定義SQLを参照
source_race_date_minDATE定義SQLを参照
source_race_date_maxDATE定義SQLを参照
days_since_last_run_countSMALLINT定義SQLを参照
avg_source_confidence_scoreDECIMAL(5,4)定義SQLを参照
snapshot_confidence_scoreDECIMAL(5,4)定義SQLを参照
quality_statusVARCHAR(32)定義SQLを参照
quality_warning_flagsVARCHAR(512)定義SQLを参照
created_atDATETIME定義SQLを参照
updated_atDATETIME更新日時
recent_ability_stat_source_countSMALLINT定義SQLを参照
recent_ability_variability_mad_zDECIMAL(6,3)定義SQLを参照
参照・計算条件のSQLを確認する
select `snapshot`.`horse_ability_snapshot_id` AS `horse_ability_snapshot_id`,`snapshot`.`taf_job_id` AS `taf_job_id`,`snapshot`.`as_of_race_id` AS `as_of_race_id`,`snapshot`.`as_of_race_horse_id` AS `as_of_race_horse_id`,`snapshot`.`horse_id` AS `horse_id`,`snapshot`.`as_of_race_date` AS `as_of_race_date`,`snapshot`.`snapshot_scope_type` AS `snapshot_scope_type`,`snapshot`.`target_surface_cd` AS `target_surface_cd`,`snapshot`.`target_distance_m` AS `target_distance_m`,`snapshot`.`target_distance_category` AS `target_distance_category`,`snapshot`.`target_racecourse_cd` AS `target_racecourse_cd`,`snapshot`.`tai_index` AS `tai_index`,`snapshot`.`tai_latent_z` AS `tai_latent_z`,`snapshot`.`epi_index` AS `epi_index`,`snapshot`.`lpi_index` AS `lpi_index`,`snapshot`.`spi_index` AS `spi_index`,`snapshot`.`kri_index` AS `kri_index`,`snapshot`.`tai_confidence_score` AS `tai_confidence_score`,`snapshot`.`epi_confidence_score` AS `epi_confidence_score`,`snapshot`.`lpi_confidence_score` AS `lpi_confidence_score`,`snapshot`.`spi_confidence_score` AS `spi_confidence_score`,`snapshot`.`kri_confidence_score` AS `kri_confidence_score`,`snapshot`.`epi_evidence_level` AS `epi_evidence_level`,`snapshot`.`lpi_evidence_level` AS `lpi_evidence_level`,`snapshot`.`spi_evidence_level` AS `spi_evidence_level`,`snapshot`.`kri_evidence_level` AS `kri_evidence_level`,`snapshot`.`tai_evidence_level` AS `tai_evidence_level`,`snapshot`.`weighted_ability_resid_sec` AS `weighted_ability_resid_sec`,`snapshot`.`weighted_time_resid_sec` AS `weighted_time_resid_sec`,`snapshot`.`speed_z` AS `speed_z`,`snapshot`.`front3_z` AS `front3_z`,`snapshot`.`late3_z` AS `late3_z`,`snapshot`.`early_position_z` AS `early_position_z`,`snapshot`.`mid_position_z` AS `mid_position_z`,`snapshot`.`front_lead_z` AS `front_lead_z`,`snapshot`.`closing_z` AS `closing_z`,`snapshot`.`rear_weighted_gain_z` AS `rear_weighted_gain_z`,`snapshot`.`early_hold_z` AS `early_hold_z`,`snapshot`.`early_pressure_load_z` AS `early_pressure_load_z`,`snapshot`.`late_context_response_z` AS `late_context_response_z`,`snapshot`.`no_fade_z` AS `no_fade_z`,`snapshot`.`front_survival_z` AS `front_survival_z`,`snapshot`.`late3_sustain_z` AS `late3_sustain_z`,`snapshot`.`sustained_context_load_z` AS `sustained_context_load_z`,`snapshot`.`closing_acceleration_z` AS `closing_acceleration_z`,`snapshot`.`relative_last3_z` AS `relative_last3_z`,`snapshot`.`spi_z` AS `spi_z`,`snapshot`.`corner_gain_z` AS `corner_gain_z`,`snapshot`.`kri_z` AS `kri_z`,`snapshot`.`source_run_count` AS `source_run_count`,`snapshot`.`valid_source_run_count` AS `valid_source_run_count`,`snapshot`.`selected_run_count` AS `selected_run_count`,`snapshot`.`single_extreme_poor_run_excluded_count` AS `single_extreme_poor_run_excluded_count`,`snapshot`.`source_race_date_min` AS `source_race_date_min`,`snapshot`.`source_race_date_max` AS `source_race_date_max`,`snapshot`.`days_since_last_run_count` AS `days_since_last_run_count`,`snapshot`.`avg_source_confidence_score` AS `avg_source_confidence_score`,`snapshot`.`snapshot_confidence_score` AS `snapshot_confidence_score`,`snapshot`.`quality_status` AS `quality_status`,`snapshot`.`quality_warning_flags` AS `quality_warning_flags`,`snapshot`.`created_at` AS `created_at`,`snapshot`.`updated_at` AS `updated_at`,`snapshot`.`recent_ability_stat_source_count` AS `recent_ability_stat_source_count`,`snapshot`.`recent_ability_variability_mad_z` AS `recent_ability_variability_mad_z`
FROM ((((`taf_horse_ability_snapshot` `snapshot`
JOIN `taf_date_checkpoint` `checkpoint` on((`checkpoint`.`race_date` = `snapshot`.`as_of_race_date`)))
JOIN `taf_processing_control` `control` on((`control`.`control_id` = 1)))
LEFT JOIN `ability_bundle_race_origin` `origin` on((`origin`.`race_id` = `snapshot`.`as_of_race_id`)))
LEFT JOIN `ability_bundle_install` `bundle` on((`bundle`.`ability_bundle_install_id` = `origin`.`ability_bundle_install_id`)))
WHERE (((`origin`.`origin_type` = 'FROZEN_BUNDLE') and (`origin`.`publish_ready` = 1) and (`origin`.`taf_job_id` = `snapshot`.`taf_job_id`) and (`bundle`.`install_status` = 'SUCCESS')) or ((`origin`.`race_id` is null) and (`checkpoint`.`calc_status` = 'SUCCESS') and (`checkpoint`.`source_generation` = `control`.`source_generation`) and (`control`.`ready_generation` = `control`.`source_generation`) and (`checkpoint`.`algorithm_version` = `control`.`algorithm_version`) and (`checkpoint`.`calibration_checksum` = `control`.`calibration_checksum`)))
公開済み能力スナップショットに使った過去走vw_taf_published_horse_ability_snapshot_source61 fields

参照元:ability_bundle_race_origin、taf_date_checkpoint、taf_horse_ability_snapshot、taf_processing_control

カラム名データ型説明
horse_ability_snapshot_source_idBIGINT定義SQLを参照
horse_ability_snapshot_idBIGINT定義SQLを参照
source_taf_race_horse_feature_idBIGINT定義SQLを参照
source_race_idBIGINT定義SQLを参照
source_race_horse_idBIGINT取得元出走馬ID
source_horse_idBIGINT定義SQLを参照
source_race_dateDATE定義SQLを参照
source_surface_cdCHAR(1)定義SQLを参照
source_distance_mSMALLINT定義SQLを参照
source_distance_categoryVARCHAR(32)定義SQLを参照
source_racecourse_cdCHAR(2)定義SQLを参照
source_pace_typeVARCHAR(32)定義SQLを参照
source_lap_confidence_scoreDECIMAL(5,4)定義SQLを参照
source_class_factor_secDECIMAL(8,3)定義SQLを参照
source_run_ability_resid_for_score_secDECIMAL(8,3)定義SQLを参照
source_run_ability_resid_for_time_secDECIMAL(8,3)定義SQLを参照
source_run_tai_absolute_resid_secDECIMAL(8,3)定義SQLを参照
source_run_tai_absolute_zDECIMAL(7,4)定義SQLを参照
source_run_result_dominance_zDECIMAL(7,4)定義SQLを参照
source_run_opponent_strength_zDECIMAL(7,4)定義SQLを参照
source_run_opponent_valid_countSMALLINT UNSIGNED定義SQLを参照
source_run_opponent_weight_sumDECIMAL(8,4)定義SQLを参照
source_run_competition_ability_zDECIMAL(7,4)定義SQLを参照
source_run_tai_context_zDECIMAL(7,4)定義SQLを参照
source_run_speed_zDECIMAL(6,3)定義SQLを参照
source_run_front3_z_sourceDECIMAL(6,3)定義SQLを参照
source_run_late3_z_sourceDECIMAL(6,3)定義SQLを参照
source_run_corner_gain_rateDECIMAL(6,4)定義SQLを参照
source_run_straight_hold_rateDECIMAL(6,4)定義SQLを参照
source_run_overall_performance_indexDECIMAL(6,3)定義SQLを参照
source_run_early_position_indexDECIMAL(6,3)定義SQLを参照
source_run_late_performance_indexDECIMAL(6,3)定義SQLを参照
source_run_front_sustain_indexDECIMAL(6,3)定義SQLを参照
source_run_closing_gain_indexDECIMAL(6,3)定義SQLを参照
source_performance_confidence_scoreDECIMAL(5,4)定義SQLを参照
source_used_flagTINYINT(1)定義SQLを参照
source_exclusion_reasonVARCHAR(64)定義SQLを参照
source_exclusion_basis_jsonJSON定義SQLを参照
single_extreme_poor_run_flagTINYINT(1)定義SQLを参照
ability_select_rankSMALLINT定義SQLを参照
selected_run_limitSMALLINT定義SQLを参照
ability_rank_weightDECIMAL(5,4)定義SQLを参照
source_recency_daysSMALLINT定義SQLを参照
recency_weightDECIMAL(5,4)定義SQLを参照
quality_weightDECIMAL(5,4)定義SQLを参照
source_weightDECIMAL(8,5)定義SQLを参照
source_weight_basis_jsonJSON定義SQLを参照
created_atDATETIME定義SQLを参照
source_run_early_position_z_sourceDECIMAL(6,3)定義SQLを参照
source_run_mid_position_z_sourceDECIMAL(6,3)定義SQLを参照
source_run_corner_gain_z_sourceDECIMAL(6,3)定義SQLを参照
source_run_rear_weighted_gain_z_sourceDECIMAL(6,3)定義SQLを参照
source_run_early_hold_z_sourceDECIMAL(6,3)定義SQLを参照
source_run_early_pressure_load_z_sourceDECIMAL(6,3)定義SQLを参照
source_run_late_context_response_z_sourceDECIMAL(6,3)定義SQLを参照
source_run_no_fade_z_sourceDECIMAL(6,3)定義SQLを参照
source_run_front_survival_z_sourceDECIMAL(6,3)定義SQLを参照
source_run_sustained_context_load_z_sourceDECIMAL(6,3)定義SQLを参照
source_run_closing_acceleration_secDECIMAL(8,3)定義SQLを参照
source_run_closing_acceleration_z_sourceDECIMAL(6,3)定義SQLを参照
source_run_relative_last3_z_sourceDECIMAL(6,3)定義SQLを参照
参照・計算条件のSQLを確認する
select `source`.`horse_ability_snapshot_source_id` AS `horse_ability_snapshot_source_id`,`source`.`horse_ability_snapshot_id` AS `horse_ability_snapshot_id`,`source`.`source_taf_race_horse_feature_id` AS `source_taf_race_horse_feature_id`,`source`.`source_race_id` AS `source_race_id`,`source`.`source_race_horse_id` AS `source_race_horse_id`,`source`.`source_horse_id` AS `source_horse_id`,`source`.`source_race_date` AS `source_race_date`,`source`.`source_surface_cd` AS `source_surface_cd`,`source`.`source_distance_m` AS `source_distance_m`,`source`.`source_distance_category` AS `source_distance_category`,`source`.`source_racecourse_cd` AS `source_racecourse_cd`,`source`.`source_pace_type` AS `source_pace_type`,`source`.`source_lap_confidence_score` AS `source_lap_confidence_score`,`source`.`source_class_factor_sec` AS `source_class_factor_sec`,`source`.`source_run_ability_resid_for_score_sec` AS `source_run_ability_resid_for_score_sec`,`source`.`source_run_ability_resid_for_time_sec` AS `source_run_ability_resid_for_time_sec`,`source`.`source_run_tai_absolute_resid_sec` AS `source_run_tai_absolute_resid_sec`,`source`.`source_run_tai_absolute_z` AS `source_run_tai_absolute_z`,`source`.`source_run_result_dominance_z` AS `source_run_result_dominance_z`,`source`.`source_run_opponent_strength_z` AS `source_run_opponent_strength_z`,`source`.`source_run_opponent_valid_count` AS `source_run_opponent_valid_count`,`source`.`source_run_opponent_weight_sum` AS `source_run_opponent_weight_sum`,`source`.`source_run_competition_ability_z` AS `source_run_competition_ability_z`,`source`.`source_run_tai_context_z` AS `source_run_tai_context_z`,`source`.`source_run_speed_z` AS `source_run_speed_z`,`source`.`source_run_front3_z_source` AS `source_run_front3_z_source`,`source`.`source_run_late3_z_source` AS `source_run_late3_z_source`,`source`.`source_run_corner_gain_rate` AS `source_run_corner_gain_rate`,`source`.`source_run_straight_hold_rate` AS `source_run_straight_hold_rate`,`source`.`source_run_overall_performance_index` AS `source_run_overall_performance_index`,`source`.`source_run_early_position_index` AS `source_run_early_position_index`,`source`.`source_run_late_performance_index` AS `source_run_late_performance_index`,`source`.`source_run_front_sustain_index` AS `source_run_front_sustain_index`,`source`.`source_run_closing_gain_index` AS `source_run_closing_gain_index`,`source`.`source_performance_confidence_score` AS `source_performance_confidence_score`,`source`.`source_used_flag` AS `source_used_flag`,`source`.`source_exclusion_reason` AS `source_exclusion_reason`,`source`.`source_exclusion_basis_json` AS `source_exclusion_basis_json`,`source`.`single_extreme_poor_run_flag` AS `single_extreme_poor_run_flag`,`source`.`ability_select_rank` AS `ability_select_rank`,`source`.`selected_run_limit` AS `selected_run_limit`,`source`.`ability_rank_weight` AS `ability_rank_weight`,`source`.`source_recency_days` AS `source_recency_days`,`source`.`recency_weight` AS `recency_weight`,`source`.`quality_weight` AS `quality_weight`,`source`.`source_weight` AS `source_weight`,`source`.`source_weight_basis_json` AS `source_weight_basis_json`,`source`.`created_at` AS `created_at`,`source`.`source_run_early_position_z_source` AS `source_run_early_position_z_source`,`source`.`source_run_mid_position_z_source` AS `source_run_mid_position_z_source`,`source`.`source_run_corner_gain_z_source` AS `source_run_corner_gain_z_source`,`source`.`source_run_rear_weighted_gain_z_source` AS `source_run_rear_weighted_gain_z_source`,`source`.`source_run_early_hold_z_source` AS `source_run_early_hold_z_source`,`source`.`source_run_early_pressure_load_z_source` AS `source_run_early_pressure_load_z_source`,`source`.`source_run_late_context_response_z_source` AS `source_run_late_context_response_z_source`,`source`.`source_run_no_fade_z_source` AS `source_run_no_fade_z_source`,`source`.`source_run_front_survival_z_source` AS `source_run_front_survival_z_source`,`source`.`source_run_sustained_context_load_z_source` AS `source_run_sustained_context_load_z_source`,`source`.`source_run_closing_acceleration_sec` AS `source_run_closing_acceleration_sec`,`source`.`source_run_closing_acceleration_z_source` AS `source_run_closing_acceleration_z_source`,`source`.`source_run_relative_last3_z_source` AS `source_run_relative_last3_z_source`
FROM ((((`taf_horse_ability_snapshot_source` `source`
JOIN `taf_horse_ability_snapshot` `snapshot` on((`snapshot`.`horse_ability_snapshot_id` = `source`.`horse_ability_snapshot_id`)))
JOIN `taf_date_checkpoint` `checkpoint` on((`checkpoint`.`race_date` = `snapshot`.`as_of_race_date`)))
JOIN `taf_processing_control` `control` on((`control`.`control_id` = 1)))
LEFT JOIN `ability_bundle_race_origin` `origin` on((`origin`.`race_id` = `snapshot`.`as_of_race_id`)))
WHERE ((`origin`.`race_id` is null) and (`checkpoint`.`calc_status` = 'SUCCESS') and (`checkpoint`.`source_generation` = `control`.`source_generation`) and (`control`.`ready_generation` = `control`.`source_generation`) and (`checkpoint`.`algorithm_version` = `control`.`algorithm_version`) and (`checkpoint`.`calibration_checksum` = `control`.`calibration_checksum`))
公開済みTAFのレース単位特徴量vw_taf_published_race_feature47 fields

参照元:ability_bundle_install、ability_bundle_race_origin、taf_date_checkpoint、taf_processing_control

カラム名データ型説明
taf_race_feature_idBIGINT定義SQLを参照
taf_job_idBIGINT定義SQLを参照
race_idBIGINTレースID
tav_race_idBIGINT定義SQLを参照
tav_race_adjustment_idBIGINT定義SQLを参照
race_dateDATE開催日
racecourse_cdCHAR(2)競馬場コード
race_noTINYINTレース番号
surface_cdCHAR(1)定義SQLを参照
distance_mSMALLINT定義SQLを参照
distance_categoryVARCHAR(32)定義SQLを参照
track_cdVARCHAR(2)定義SQLを参照
baba_cdVARCHAR(2)定義SQLを参照
weather_cdVARCHAR(2)天候コード
normalized_class_cdVARCHAR(32)定義SQLを参照
starter_countTINYINT出走頭数
finisher_countTINYINT入線頭数
straight_course_flagTINYINT(1)定義SQLを参照
expected_race_time_secDECIMAL(8,3)定義SQLを参照
race_adjustment_secDECIMAL(8,3)定義SQLを参照
day_variant_secDECIMAL(8,3)定義SQLを参照
par_time_secDECIMAL(8,3)定義SQLを参照
class_factor_secDECIMAL(8,3)定義SQLを参照
tav_confidence_scoreDECIMAL(5,4)定義SQLを参照
winner_finish_time_secDECIMAL(8,3)定義SQLを参照
winner_time_resid_secDECIMAL(8,3)定義SQLを参照
first3_secDECIMAL(6,3)定義SQLを参照
last3_secDECIMAL(6,3)定義SQLを参照
pace_typeVARCHAR(32)定義SQLを参照
first_half_pressure_secDECIMAL(8,3)定義SQLを参照
middle_pressure_secDECIMAL(8,3)定義SQLを参照
late_pressure_secDECIMAL(8,3)定義SQLを参照
lap_confidence_scoreDECIMAL(5,4)定義SQLを参照
valid_taf_race_flagTINYINT(1)定義SQLを参照
valid_tav_adjustment_flagTINYINT(1)定義SQLを参照
valid_lap_flagTINYINT(1)定義SQLを参照
valid_time_flagTINYINT(1)定義SQLを参照
race_confidence_scoreDECIMAL(5,4)定義SQLを参照
quality_statusVARCHAR(32)定義SQLを参照
quality_warning_flagsVARCHAR(512)定義SQLを参照
created_atDATETIME定義SQLを参照
updated_atDATETIME更新日時
early_speed_indexDECIMAL(6,3)定義SQLを参照
mid_accel_indexDECIMAL(6,3)定義SQLを参照
late_accel_indexDECIMAL(6,3)定義SQLを参照
sustained_speed_indexDECIMAL(6,3)定義SQLを参照
closing_speed_indexDECIMAL(6,3)定義SQLを参照
参照・計算条件のSQLを確認する
select `feature`.`taf_race_feature_id` AS `taf_race_feature_id`,`feature`.`taf_job_id` AS `taf_job_id`,`feature`.`race_id` AS `race_id`,`feature`.`tav_race_id` AS `tav_race_id`,`feature`.`tav_race_adjustment_id` AS `tav_race_adjustment_id`,`feature`.`race_date` AS `race_date`,`feature`.`racecourse_cd` AS `racecourse_cd`,`feature`.`race_no` AS `race_no`,`feature`.`surface_cd` AS `surface_cd`,`feature`.`distance_m` AS `distance_m`,`feature`.`distance_category` AS `distance_category`,`feature`.`track_cd` AS `track_cd`,`feature`.`baba_cd` AS `baba_cd`,`feature`.`weather_cd` AS `weather_cd`,`feature`.`normalized_class_cd` AS `normalized_class_cd`,`feature`.`starter_count` AS `starter_count`,`feature`.`finisher_count` AS `finisher_count`,`feature`.`straight_course_flag` AS `straight_course_flag`,`feature`.`expected_race_time_sec` AS `expected_race_time_sec`,`feature`.`race_adjustment_sec` AS `race_adjustment_sec`,`feature`.`day_variant_sec` AS `day_variant_sec`,`feature`.`par_time_sec` AS `par_time_sec`,`feature`.`class_factor_sec` AS `class_factor_sec`,`feature`.`tav_confidence_score` AS `tav_confidence_score`,`feature`.`winner_finish_time_sec` AS `winner_finish_time_sec`,`feature`.`winner_time_resid_sec` AS `winner_time_resid_sec`,`feature`.`first3_sec` AS `first3_sec`,`feature`.`last3_sec` AS `last3_sec`,`feature`.`pace_type` AS `pace_type`,`feature`.`first_half_pressure_sec` AS `first_half_pressure_sec`,`feature`.`middle_pressure_sec` AS `middle_pressure_sec`,`feature`.`late_pressure_sec` AS `late_pressure_sec`,`feature`.`lap_confidence_score` AS `lap_confidence_score`,`feature`.`valid_taf_race_flag` AS `valid_taf_race_flag`,`feature`.`valid_tav_adjustment_flag` AS `valid_tav_adjustment_flag`,`feature`.`valid_lap_flag` AS `valid_lap_flag`,`feature`.`valid_time_flag` AS `valid_time_flag`,`feature`.`race_confidence_score` AS `race_confidence_score`,`feature`.`quality_status` AS `quality_status`,`feature`.`quality_warning_flags` AS `quality_warning_flags`,`feature`.`created_at` AS `created_at`,`feature`.`updated_at` AS `updated_at`,`feature`.`early_speed_index` AS `early_speed_index`,`feature`.`mid_accel_index` AS `mid_accel_index`,`feature`.`late_accel_index` AS `late_accel_index`,`feature`.`sustained_speed_index` AS `sustained_speed_index`,`feature`.`closing_speed_index` AS `closing_speed_index`
FROM ((((`taf_race_feature` `feature`
JOIN `taf_date_checkpoint` `checkpoint` on((`checkpoint`.`race_date` = `feature`.`race_date`)))
JOIN `taf_processing_control` `control` on((`control`.`control_id` = 1)))
LEFT JOIN `ability_bundle_race_origin` `origin` on((`origin`.`race_id` = `feature`.`race_id`)))
LEFT JOIN `ability_bundle_install` `bundle` on((`bundle`.`ability_bundle_install_id` = `origin`.`ability_bundle_install_id`)))
WHERE (((`origin`.`origin_type` = 'FROZEN_BUNDLE') and (`origin`.`publish_ready` = 1) and (`origin`.`taf_job_id` = `feature`.`taf_job_id`) and (`bundle`.`install_status` = 'SUCCESS') and (`bundle`.`manifest_sha256` is not null)) or ((`origin`.`race_id` is null) and (`checkpoint`.`calc_status` = 'SUCCESS') and (`checkpoint`.`source_generation` = `control`.`source_generation`) and (`control`.`ready_generation` = `control`.`source_generation`) and (`checkpoint`.`algorithm_version` = `control`.`algorithm_version`) and (`checkpoint`.`calibration_checksum` = `control`.`calibration_checksum`)))
公開済みTAFの出走馬単位特徴量vw_taf_published_race_horse_feature93 fields

参照元:ability_bundle_install、ability_bundle_race_origin、taf_date_checkpoint、taf_processing_control

カラム名データ型説明
taf_race_horse_feature_idBIGINT定義SQLを参照
taf_job_idBIGINT定義SQLを参照
taf_race_feature_idBIGINT定義SQLを参照
race_idBIGINTレースID
race_horse_idBIGINT出走馬ID
horse_idBIGINT競走馬ID
tav_race_idBIGINT定義SQLを参照
tav_race_adjustment_idBIGINT定義SQLを参照
race_dateDATE開催日
racecourse_cdCHAR(2)競馬場コード
race_noTINYINTレース番号
surface_cdCHAR(1)定義SQLを参照
distance_mSMALLINT定義SQLを参照
distance_categoryVARCHAR(32)定義SQLを参照
track_cdVARCHAR(2)定義SQLを参照
baba_cdVARCHAR(2)定義SQLを参照
normalized_class_cdVARCHAR(32)定義SQLを参照
starter_countTINYINT出走頭数
finisher_countTINYINT入線頭数
straight_course_flagTINYINT(1)定義SQLを参照
horse_noTINYINT馬番
finish_orderTINYINT確定着順
arrival_orderTINYINT入線順位
abnormality_cdVARCHAR(4)異常区分コード
finish_time_secDECIMAL(8,3)走破タイム
winner_finish_time_secDECIMAL(8,3)定義SQLを参照
winner_time_diff_secDECIMAL(8,3)定義SQLを参照
margin_secDECIMAL(8,3)着差コード秒換算
last3_secDECIMAL(6,3)定義SQLを参照
corner1_orderTINYINT1コーナー順位
corner2_orderTINYINT2コーナー順位
corner3_orderTINYINT3コーナー順位
corner4_orderTINYINT4コーナー順位
expected_race_time_secDECIMAL(8,3)定義SQLを参照
race_adjustment_secDECIMAL(8,3)定義SQLを参照
day_variant_secDECIMAL(8,3)定義SQLを参照
class_factor_secDECIMAL(8,3)定義SQLを参照
tav_confidence_scoreDECIMAL(5,4)定義SQLを参照
run_finish_time_resid_secDECIMAL(8,3)定義SQLを参照
run_ability_resid_secDECIMAL(8,3)定義SQLを参照
run_ability_resid_for_score_secDECIMAL(8,3)定義SQLを参照
run_ability_resid_for_time_secDECIMAL(8,3)定義SQLを参照
run_tai_absolute_resid_secDECIMAL(8,3)定義SQLを参照
run_tai_absolute_zDECIMAL(7,4)定義SQLを参照
run_result_dominance_zDECIMAL(7,4)定義SQLを参照
run_opponent_strength_zDECIMAL(7,4)定義SQLを参照
run_opponent_valid_countSMALLINT UNSIGNED定義SQLを参照
run_opponent_weight_sumDECIMAL(8,4)定義SQLを参照
run_competition_ability_zDECIMAL(7,4)定義SQLを参照
run_tai_context_zDECIMAL(7,4)定義SQLを参照
run_speed_zDECIMAL(6,3)定義SQLを参照
run_front3_z_sourceDECIMAL(6,3)定義SQLを参照
run_late3_secDECIMAL(6,3)定義SQLを参照
run_late3_z_sourceDECIMAL(6,3)定義SQLを参照
run_early_position_rateDECIMAL(6,4)定義SQLを参照
run_mid_position_rateDECIMAL(6,4)定義SQLを参照
run_corner4_position_rateDECIMAL(6,4)定義SQLを参照
run_finish_position_rateDECIMAL(6,4)定義SQLを参照
run_corner_gain_rateDECIMAL(6,4)定義SQLを参照
run_straight_hold_rateDECIMAL(6,4)定義SQLを参照
run_front_late3_support_valueDECIMAL(6,4)定義SQLを参照
pace_typeVARCHAR(32)定義SQLを参照
lap_confidence_scoreDECIMAL(5,4)定義SQLを参照
run_overall_performance_indexDECIMAL(6,3)定義SQLを参照
run_early_position_indexDECIMAL(6,3)定義SQLを参照
run_late_performance_indexDECIMAL(6,3)定義SQLを参照
run_front_sustain_indexDECIMAL(6,3)定義SQLを参照
run_closing_gain_indexDECIMAL(6,3)定義SQLを参照
valid_taf_run_flagTINYINT(1)定義SQLを参照
valid_tav_adjustment_flagTINYINT(1)定義SQLを参照
valid_time_flagTINYINT(1)定義SQLを参照
valid_last3_flagTINYINT(1)定義SQLを参照
valid_position_flagTINYINT(1)定義SQLを参照
valid_lap_flagTINYINT(1)定義SQLを参照
abnormality_exclude_flagTINYINT(1)定義SQLを参照
performance_confidence_scoreDECIMAL(5,4)定義SQLを参照
quality_statusVARCHAR(32)定義SQLを参照
quality_warning_flagsVARCHAR(512)定義SQLを参照
created_atDATETIME定義SQLを参照
updated_atDATETIME更新日時
run_early_position_z_sourceDECIMAL(6,3)定義SQLを参照
run_mid_position_z_sourceDECIMAL(6,3)定義SQLを参照
run_corner_gain_z_sourceDECIMAL(6,3)定義SQLを参照
run_rear_weighted_gain_z_sourceDECIMAL(6,3)定義SQLを参照
run_early_hold_z_sourceDECIMAL(6,3)定義SQLを参照
run_early_pressure_load_z_sourceDECIMAL(6,3)定義SQLを参照
run_late_context_response_z_sourceDECIMAL(6,3)定義SQLを参照
run_no_fade_z_sourceDECIMAL(6,3)定義SQLを参照
run_front_survival_z_sourceDECIMAL(6,3)定義SQLを参照
run_sustained_context_load_z_sourceDECIMAL(6,3)定義SQLを参照
run_closing_acceleration_secDECIMAL(8,3)定義SQLを参照
run_closing_acceleration_z_sourceDECIMAL(6,3)定義SQLを参照
run_relative_last3_z_sourceDECIMAL(6,3)定義SQLを参照
参照・計算条件のSQLを確認する
select `feature`.`taf_race_horse_feature_id` AS `taf_race_horse_feature_id`,`feature`.`taf_job_id` AS `taf_job_id`,`feature`.`taf_race_feature_id` AS `taf_race_feature_id`,`feature`.`race_id` AS `race_id`,`feature`.`race_horse_id` AS `race_horse_id`,`feature`.`horse_id` AS `horse_id`,`feature`.`tav_race_id` AS `tav_race_id`,`feature`.`tav_race_adjustment_id` AS `tav_race_adjustment_id`,`feature`.`race_date` AS `race_date`,`feature`.`racecourse_cd` AS `racecourse_cd`,`feature`.`race_no` AS `race_no`,`feature`.`surface_cd` AS `surface_cd`,`feature`.`distance_m` AS `distance_m`,`feature`.`distance_category` AS `distance_category`,`feature`.`track_cd` AS `track_cd`,`feature`.`baba_cd` AS `baba_cd`,`feature`.`normalized_class_cd` AS `normalized_class_cd`,`feature`.`starter_count` AS `starter_count`,`feature`.`finisher_count` AS `finisher_count`,`feature`.`straight_course_flag` AS `straight_course_flag`,`feature`.`horse_no` AS `horse_no`,`feature`.`finish_order` AS `finish_order`,`feature`.`arrival_order` AS `arrival_order`,`feature`.`abnormality_cd` AS `abnormality_cd`,`feature`.`finish_time_sec` AS `finish_time_sec`,`feature`.`winner_finish_time_sec` AS `winner_finish_time_sec`,`feature`.`winner_time_diff_sec` AS `winner_time_diff_sec`,`feature`.`margin_sec` AS `margin_sec`,`feature`.`last3_sec` AS `last3_sec`,`feature`.`corner1_order` AS `corner1_order`,`feature`.`corner2_order` AS `corner2_order`,`feature`.`corner3_order` AS `corner3_order`,`feature`.`corner4_order` AS `corner4_order`,`feature`.`expected_race_time_sec` AS `expected_race_time_sec`,`feature`.`race_adjustment_sec` AS `race_adjustment_sec`,`feature`.`day_variant_sec` AS `day_variant_sec`,`feature`.`class_factor_sec` AS `class_factor_sec`,`feature`.`tav_confidence_score` AS `tav_confidence_score`,`feature`.`run_finish_time_resid_sec` AS `run_finish_time_resid_sec`,`feature`.`run_ability_resid_sec` AS `run_ability_resid_sec`,`feature`.`run_ability_resid_for_score_sec` AS `run_ability_resid_for_score_sec`,`feature`.`run_ability_resid_for_time_sec` AS `run_ability_resid_for_time_sec`,`feature`.`run_tai_absolute_resid_sec` AS `run_tai_absolute_resid_sec`,`feature`.`run_tai_absolute_z` AS `run_tai_absolute_z`,`feature`.`run_result_dominance_z` AS `run_result_dominance_z`,`feature`.`run_opponent_strength_z` AS `run_opponent_strength_z`,`feature`.`run_opponent_valid_count` AS `run_opponent_valid_count`,`feature`.`run_opponent_weight_sum` AS `run_opponent_weight_sum`,`feature`.`run_competition_ability_z` AS `run_competition_ability_z`,`feature`.`run_tai_context_z` AS `run_tai_context_z`,`feature`.`run_speed_z` AS `run_speed_z`,`feature`.`run_front3_z_source` AS `run_front3_z_source`,`feature`.`run_late3_sec` AS `run_late3_sec`,`feature`.`run_late3_z_source` AS `run_late3_z_source`,`feature`.`run_early_position_rate` AS `run_early_position_rate`,`feature`.`run_mid_position_rate` AS `run_mid_position_rate`,`feature`.`run_corner4_position_rate` AS `run_corner4_position_rate`,`feature`.`run_finish_position_rate` AS `run_finish_position_rate`,`feature`.`run_corner_gain_rate` AS `run_corner_gain_rate`,`feature`.`run_straight_hold_rate` AS `run_straight_hold_rate`,`feature`.`run_front_late3_support_value` AS `run_front_late3_support_value`,`feature`.`pace_type` AS `pace_type`,`feature`.`lap_confidence_score` AS `lap_confidence_score`,`feature`.`run_overall_performance_index` AS `run_overall_performance_index`,`feature`.`run_early_position_index` AS `run_early_position_index`,`feature`.`run_late_performance_index` AS `run_late_performance_index`,`feature`.`run_front_sustain_index` AS `run_front_sustain_index`,`feature`.`run_closing_gain_index` AS `run_closing_gain_index`,`feature`.`valid_taf_run_flag` AS `valid_taf_run_flag`,`feature`.`valid_tav_adjustment_flag` AS `valid_tav_adjustment_flag`,`feature`.`valid_time_flag` AS `valid_time_flag`,`feature`.`valid_last3_flag` AS `valid_last3_flag`,`feature`.`valid_position_flag` AS `valid_position_flag`,`feature`.`valid_lap_flag` AS `valid_lap_flag`,`feature`.`abnormality_exclude_flag` AS `abnormality_exclude_flag`,`feature`.`performance_confidence_score` AS `performance_confidence_score`,`feature`.`quality_status` AS `quality_status`,`feature`.`quality_warning_flags` AS `quality_warning_flags`,`feature`.`created_at` AS `created_at`,`feature`.`updated_at` AS `updated_at`,`feature`.`run_early_position_z_source` AS `run_early_position_z_source`,`feature`.`run_mid_position_z_source` AS `run_mid_position_z_source`,`feature`.`run_corner_gain_z_source` AS `run_corner_gain_z_source`,`feature`.`run_rear_weighted_gain_z_source` AS `run_rear_weighted_gain_z_source`,`feature`.`run_early_hold_z_source` AS `run_early_hold_z_source`,`feature`.`run_early_pressure_load_z_source` AS `run_early_pressure_load_z_source`,`feature`.`run_late_context_response_z_source` AS `run_late_context_response_z_source`,`feature`.`run_no_fade_z_source` AS `run_no_fade_z_source`,`feature`.`run_front_survival_z_source` AS `run_front_survival_z_source`,`feature`.`run_sustained_context_load_z_source` AS `run_sustained_context_load_z_source`,`feature`.`run_closing_acceleration_sec` AS `run_closing_acceleration_sec`,`feature`.`run_closing_acceleration_z_source` AS `run_closing_acceleration_z_source`,`feature`.`run_relative_last3_z_source` AS `run_relative_last3_z_source`
FROM ((((`taf_race_horse_feature` `feature`
JOIN `taf_date_checkpoint` `checkpoint` on((`checkpoint`.`race_date` = `feature`.`race_date`)))
JOIN `taf_processing_control` `control` on((`control`.`control_id` = 1)))
LEFT JOIN `ability_bundle_race_origin` `origin` on((`origin`.`race_id` = `feature`.`race_id`)))
LEFT JOIN `ability_bundle_install` `bundle` on((`bundle`.`ability_bundle_install_id` = `origin`.`ability_bundle_install_id`)))
WHERE (((`origin`.`origin_type` = 'FROZEN_BUNDLE') and (`origin`.`publish_ready` = 1) and (`origin`.`taf_job_id` = `feature`.`taf_job_id`) and (`bundle`.`install_status` = 'SUCCESS')) or ((`origin`.`race_id` is null) and (`checkpoint`.`calc_status` = 'SUCCESS') and (`checkpoint`.`source_generation` = `control`.`source_generation`) and (`control`.`ready_generation` = `control`.`source_generation`) and (`checkpoint`.`algorithm_version` = `control`.`algorithm_version`) and (`checkpoint`.`calibration_checksum` = `control`.`calibration_checksum`)))
公開済みの総合能力値TAI_Hを出走馬ごとに参照vw_tai_h_published_race_horse_feature25 fields

参照元:ability_bundle_install、ability_bundle_race_origin、ability_source_date_revision、core_ra_race、tai_h_race_checkpoint、vw_taf_published_horse_ability_snapshot、vw_tfs_published_race_horse_feature

カラム名データ型説明
tai_h_race_horse_feature_idBIGINT定義SQLを参照
tai_h_job_idBIGINT定義SQLを参照
race_idBIGINTレースID
race_horse_idBIGINT出走馬ID
horse_idBIGINT競走馬ID
race_dateDATE開催日
source_taf_snapshot_idBIGINT定義SQLを参照
source_tfs_race_horse_feature_idBIGINT定義SQLを参照
tai_baseDECIMAL(12,9)定義SQLを参照
training_form_zDECIMAL(12,9)定義SQLを参照
training_adjustmentDECIMAL(12,9)定義SQLを参照
jockey_raw_scoreDECIMAL(12,9)定義SQLを参照
jockey_score_zDECIMAL(12,9)定義SQLを参照
jockey_adjustmentDECIMAL(12,9)定義SQLを参照
trainer_raw_scoreDECIMAL(12,9)定義SQLを参照
trainer_score_zDECIMAL(12,9)定義SQLを参照
trainer_adjustmentDECIMAL(12,9)定義SQLを参照
raw_adjustmentDECIMAL(12,9)定義SQLを参照
tai_h_adjustmentDECIMAL(12,9)定義SQLを参照
tai_h_indexDECIMAL(12,9)定義SQLを参照
tai_h_zDECIMAL(12,9)定義SQLを参照
tai_h_rankSMALLINT UNSIGNED定義SQLを参照
risk_codes_jsonJSON定義SQLを参照
created_atDATETIME定義SQLを参照
updated_atDATETIME更新日時
参照・計算条件のSQLを確認する
select `feature`.`tai_h_race_horse_feature_id` AS `tai_h_race_horse_feature_id`,`feature`.`tai_h_job_id` AS `tai_h_job_id`,`feature`.`race_id` AS `race_id`,`feature`.`race_horse_id` AS `race_horse_id`,`feature`.`horse_id` AS `horse_id`,`feature`.`race_date` AS `race_date`,`feature`.`source_taf_snapshot_id` AS `source_taf_snapshot_id`,`feature`.`source_tfs_race_horse_feature_id` AS `source_tfs_race_horse_feature_id`,`feature`.`tai_base` AS `tai_base`,`feature`.`training_form_z` AS `training_form_z`,`feature`.`training_adjustment` AS `training_adjustment`,`feature`.`jockey_raw_score` AS `jockey_raw_score`,`feature`.`jockey_score_z` AS `jockey_score_z`,`feature`.`jockey_adjustment` AS `jockey_adjustment`,`feature`.`trainer_raw_score` AS `trainer_raw_score`,`feature`.`trainer_score_z` AS `trainer_score_z`,`feature`.`trainer_adjustment` AS `trainer_adjustment`,`feature`.`raw_adjustment` AS `raw_adjustment`,`feature`.`tai_h_adjustment` AS `tai_h_adjustment`,`feature`.`tai_h_index` AS `tai_h_index`,`feature`.`tai_h_z` AS `tai_h_z`,`feature`.`tai_h_rank` AS `tai_h_rank`,`feature`.`risk_codes_json` AS `risk_codes_json`,`feature`.`created_at` AS `created_at`,`feature`.`updated_at` AS `updated_at`
FROM (((((((`tai_h_race_horse_feature` `feature`
JOIN `tai_h_race_checkpoint` `checkpoint` on((`checkpoint`.`race_id` = `feature`.`race_id`)))
JOIN `core_ra_race` `race` on(((`race`.`race_id` = `feature`.`race_id`) and (`race`.`is_cancelled` = 0))))
JOIN `vw_taf_published_horse_ability_snapshot` `taf` on(((`taf`.`horse_ability_snapshot_id` = `feature`.`source_taf_snapshot_id`) and (`taf`.`as_of_race_id` = `feature`.`race_id`) and (`taf`.`as_of_race_horse_id` = `feature`.`race_horse_id`) and (`taf`.`snapshot_scope_type` = 'OVERALL'))))
JOIN `vw_tfs_published_race_horse_feature` `tfs` on(((`tfs`.`tfs_race_horse_feature_id` = `feature`.`source_tfs_race_horse_feature_id`) and (`tfs`.`race_id` = `feature`.`race_id`) and (`tfs`.`race_horse_id` = `feature`.`race_horse_id`))))
LEFT JOIN `ability_bundle_race_origin` `origin` on((`origin`.`race_id` = `feature`.`race_id`)))
LEFT JOIN `ability_bundle_install` `bundle` on((`bundle`.`ability_bundle_install_id` = `origin`.`ability_bundle_install_id`)))
LEFT JOIN `ability_source_date_revision` `revision` on((`revision`.`race_date` = `checkpoint`.`race_date`)))
WHERE ((`checkpoint`.`calc_status` = 'SUCCESS') and (`checkpoint`.`last_tai_h_job_id` = `feature`.`tai_h_job_id`) and (((`origin`.`origin_type` = 'FROZEN_BUNDLE') and (`origin`.`publish_ready` = 1) and (`origin`.`tai_h_job_id` = `feature`.`tai_h_job_id`) and (`bundle`.`install_status` = 'SUCCESS')) or ((`origin`.`race_id` is null) and (`revision`.`source_revision` = `checkpoint`.`source_revision`) and (`revision`.`source_stage` = `checkpoint`.`source_stage`))))
TAVのレース補正・期待時計などを参照vw_tav_race_feature_core33 fields

参照元:tav_race_adjustment、tav_race_lap_profile

カラム名データ型説明
race_idBIGINTレースID
tav_race_idBIGINT UNSIGNED定義SQLを参照
kaisai_dateCHAR(8)定義SQLを参照
jyo_cdCHAR(2)定義SQLを参照
kaijiCHAR(2)定義SQLを参照
nichijiCHAR(2)定義SQLを参照
race_numCHAR(2)定義SQLを参照
surface_cdCHAR(1)定義SQLを参照
kyoriINT定義SQLを参照
par_time_secDECIMAL(8,3)定義SQLを参照
course_factor_secDECIMAL(8,3)定義SQLを参照
class_factor_secDECIMAL(8,3)定義SQLを参照
track_condition_factor_secDECIMAL(8,3)定義SQLを参照
day_variant_secDECIMAL(8,3)定義SQLを参照
race_adjustment_secDECIMAL(8,3)定義SQLを参照
expected_race_time_secDECIMAL(8,3)定義SQLを参照
adjustment_quality_statusVARCHAR(32)定義SQLを参照
adjustment_warning_flagsVARCHAR(255)定義SQLを参照
adjustment_is_estimatedTINYINT(1)定義SQLを参照
adjustment_fallback_levelINT定義SQLを参照
adjustment_confidence_scoreDECIMAL(5,4)定義SQLを参照
pace_typeVARCHAR(32)定義SQLを参照
first_half_pressure_secDECIMAL(8,3)定義SQLを参照
middle_pressure_secDECIMAL(8,3)定義SQLを参照
late_pressure_secDECIMAL(8,3)定義SQLを参照
early_speed_indexDECIMAL(8,3)定義SQLを参照
sustained_speed_indexDECIMAL(8,3)定義SQLを参照
closing_speed_indexDECIMAL(8,3)定義SQLを参照
lap_quality_statusVARCHAR(32)定義SQLを参照
lap_warning_flagsVARCHAR(255)定義SQLを参照
lap_is_estimatedTINYINT(1)定義SQLを参照
lap_fallback_levelINT定義SQLを参照
lap_confidence_scoreDECIMAL(5,4)定義SQLを参照
参照・計算条件のSQLを確認する
select `tr`.`core_race_id` AS `race_id`,`tr`.`race_id` AS `tav_race_id`,`tr`.`kaisai_date` AS `kaisai_date`,`tr`.`jyo_cd` AS `jyo_cd`,`tr`.`kaiji` AS `kaiji`,`tr`.`nichiji` AS `nichiji`,`tr`.`race_num` AS `race_num`,`tr`.`surface_cd` AS `surface_cd`,`tr`.`kyori` AS `kyori`,`tra`.`par_time_sec` AS `par_time_sec`,`tra`.`course_factor_sec` AS `course_factor_sec`,`tra`.`class_factor_sec` AS `class_factor_sec`,`tra`.`track_condition_factor_sec` AS `track_condition_factor_sec`,`tra`.`day_variant_sec` AS `day_variant_sec`,`tra`.`race_adjustment_sec` AS `race_adjustment_sec`,`tra`.`expected_race_time_sec` AS `expected_race_time_sec`,`tra`.`quality_status` AS `adjustment_quality_status`,`tra`.`warning_flags` AS `adjustment_warning_flags`,`tra`.`is_estimated` AS `adjustment_is_estimated`,`tra`.`fallback_level` AS `adjustment_fallback_level`,`tra`.`confidence_score` AS `adjustment_confidence_score`,`tlp`.`pace_type` AS `pace_type`,`tlp`.`first_half_pressure_sec` AS `first_half_pressure_sec`,`tlp`.`middle_pressure_sec` AS `middle_pressure_sec`,`tlp`.`late_pressure_sec` AS `late_pressure_sec`,`tlp`.`early_speed_index` AS `early_speed_index`,`tlp`.`sustained_speed_index` AS `sustained_speed_index`,`tlp`.`closing_speed_index` AS `closing_speed_index`,`tlp`.`quality_status` AS `lap_quality_status`,`tlp`.`warning_flags` AS `lap_warning_flags`,`tlp`.`is_estimated` AS `lap_is_estimated`,`tlp`.`fallback_level` AS `lap_fallback_level`,`tlp`.`confidence_score` AS `lap_confidence_score`
FROM ((`tav_race` `tr`
LEFT JOIN `tav_race_adjustment` `tra` on((`tra`.`race_id` = `tr`.`race_id`)))
LEFT JOIN `tav_race_lap_profile` `tlp` on((`tlp`.`race_id` = `tr`.`race_id`)))
WHERE (`tr`.`core_race_id` is not null)
公開済みTFSのレース単位特徴量vw_tfs_published_race_feature60 fields

参照元:ability_bundle_install、ability_bundle_race_origin、core_ra_race、tfs_processing_control、tfs_race_checkpoint

カラム名データ型説明
tfs_race_feature_idBIGINT定義SQLを参照
tfs_job_idBIGINT定義SQLを参照
race_idBIGINTレースID
race_dateDATE開催日
quality_statusVARCHAR(16)定義SQLを参照
created_atDATETIME定義SQLを参照
updated_atDATETIME更新日時
member_entry_countINT定義SQLを参照
member_surface_distance_low_confidence_countINT定義SQLを参照
member_overall_tai_valid_countINT定義SQLを参照
member_overall_tai_meanDECIMAL(7,3)定義SQLを参照
member_overall_tai_medianDECIMAL(7,3)定義SQLを参照
member_overall_tai_stddevDECIMAL(7,3)定義SQLを参照
member_overall_tai_maxDECIMAL(7,3)定義SQLを参照
member_overall_tai_top3_meanDECIMAL(7,3)定義SQLを参照
member_overall_tai_top1_top2_gapDECIMAL(7,3)定義SQLを参照
member_surface_distance_tai_valid_countINT定義SQLを参照
member_surface_distance_tai_meanDECIMAL(7,3)定義SQLを参照
member_surface_distance_tai_medianDECIMAL(7,3)定義SQLを参照
member_surface_distance_tai_stddevDECIMAL(7,3)定義SQLを参照
member_surface_distance_tai_maxDECIMAL(7,3)定義SQLを参照
member_surface_distance_tai_top3_meanDECIMAL(7,3)定義SQLを参照
member_surface_distance_tai_top1_top2_gapDECIMAL(7,3)定義SQLを参照
member_surface_distance_epi_valid_countINT定義SQLを参照
member_surface_distance_epi_meanDECIMAL(7,3)定義SQLを参照
member_surface_distance_epi_medianDECIMAL(7,3)定義SQLを参照
member_surface_distance_epi_stddevDECIMAL(7,3)定義SQLを参照
member_surface_distance_epi_maxDECIMAL(7,3)定義SQLを参照
member_surface_distance_epi_top3_meanDECIMAL(7,3)定義SQLを参照
member_surface_distance_epi_top1_top2_gapDECIMAL(7,3)定義SQLを参照
member_surface_distance_lpi_valid_countINT定義SQLを参照
member_surface_distance_lpi_meanDECIMAL(7,3)定義SQLを参照
member_surface_distance_lpi_medianDECIMAL(7,3)定義SQLを参照
member_surface_distance_lpi_stddevDECIMAL(7,3)定義SQLを参照
member_surface_distance_lpi_maxDECIMAL(7,3)定義SQLを参照
member_surface_distance_lpi_top3_meanDECIMAL(7,3)定義SQLを参照
member_surface_distance_lpi_top1_top2_gapDECIMAL(7,3)定義SQLを参照
member_surface_distance_spi_valid_countINT定義SQLを参照
member_surface_distance_spi_meanDECIMAL(7,3)定義SQLを参照
member_surface_distance_spi_medianDECIMAL(7,3)定義SQLを参照
member_surface_distance_spi_stddevDECIMAL(7,3)定義SQLを参照
member_surface_distance_spi_maxDECIMAL(7,3)定義SQLを参照
member_surface_distance_spi_top3_meanDECIMAL(7,3)定義SQLを参照
member_surface_distance_spi_top1_top2_gapDECIMAL(7,3)定義SQLを参照
member_surface_distance_kri_valid_countINT定義SQLを参照
member_surface_distance_kri_meanDECIMAL(7,3)定義SQLを参照
member_surface_distance_kri_medianDECIMAL(7,3)定義SQLを参照
member_surface_distance_kri_stddevDECIMAL(7,3)定義SQLを参照
member_surface_distance_kri_maxDECIMAL(7,3)定義SQLを参照
member_surface_distance_kri_top3_meanDECIMAL(7,3)定義SQLを参照
member_surface_distance_kri_top1_top2_gapDECIMAL(7,3)定義SQLを参照
member_ability_variability_valid_countINT定義SQLを参照
member_ability_variability_mad_z_meanDECIMAL(7,3)定義SQLを参照
member_ability_variability_mad_z_medianDECIMAL(7,3)定義SQLを参照
member_style_valid_horse_countINT定義SQLを参照
member_style_coverage_rateDECIMAL(7,6)定義SQLを参照
member_nige_style_rate_sumDECIMAL(8,6)定義SQLを参照
member_senko_style_rate_sumDECIMAL(8,6)定義SQLを参照
member_sashi_style_rate_sumDECIMAL(8,6)定義SQLを参照
member_oikomi_style_rate_sumDECIMAL(8,6)定義SQLを参照
参照・計算条件のSQLを確認する
select `feature`.`tfs_race_feature_id` AS `tfs_race_feature_id`,`feature`.`tfs_job_id` AS `tfs_job_id`,`feature`.`race_id` AS `race_id`,`feature`.`race_date` AS `race_date`,`feature`.`quality_status` AS `quality_status`,`feature`.`created_at` AS `created_at`,`feature`.`updated_at` AS `updated_at`,`feature`.`member_entry_count` AS `member_entry_count`,`feature`.`member_surface_distance_low_confidence_count` AS `member_surface_distance_low_confidence_count`,`feature`.`member_overall_tai_valid_count` AS `member_overall_tai_valid_count`,`feature`.`member_overall_tai_mean` AS `member_overall_tai_mean`,`feature`.`member_overall_tai_median` AS `member_overall_tai_median`,`feature`.`member_overall_tai_stddev` AS `member_overall_tai_stddev`,`feature`.`member_overall_tai_max` AS `member_overall_tai_max`,`feature`.`member_overall_tai_top3_mean` AS `member_overall_tai_top3_mean`,`feature`.`member_overall_tai_top1_top2_gap` AS `member_overall_tai_top1_top2_gap`,`feature`.`member_surface_distance_tai_valid_count` AS `member_surface_distance_tai_valid_count`,`feature`.`member_surface_distance_tai_mean` AS `member_surface_distance_tai_mean`,`feature`.`member_surface_distance_tai_median` AS `member_surface_distance_tai_median`,`feature`.`member_surface_distance_tai_stddev` AS `member_surface_distance_tai_stddev`,`feature`.`member_surface_distance_tai_max` AS `member_surface_distance_tai_max`,`feature`.`member_surface_distance_tai_top3_mean` AS `member_surface_distance_tai_top3_mean`,`feature`.`member_surface_distance_tai_top1_top2_gap` AS `member_surface_distance_tai_top1_top2_gap`,`feature`.`member_surface_distance_epi_valid_count` AS `member_surface_distance_epi_valid_count`,`feature`.`member_surface_distance_epi_mean` AS `member_surface_distance_epi_mean`,`feature`.`member_surface_distance_epi_median` AS `member_surface_distance_epi_median`,`feature`.`member_surface_distance_epi_stddev` AS `member_surface_distance_epi_stddev`,`feature`.`member_surface_distance_epi_max` AS `member_surface_distance_epi_max`,`feature`.`member_surface_distance_epi_top3_mean` AS `member_surface_distance_epi_top3_mean`,`feature`.`member_surface_distance_epi_top1_top2_gap` AS `member_surface_distance_epi_top1_top2_gap`,`feature`.`member_surface_distance_lpi_valid_count` AS `member_surface_distance_lpi_valid_count`,`feature`.`member_surface_distance_lpi_mean` AS `member_surface_distance_lpi_mean`,`feature`.`member_surface_distance_lpi_median` AS `member_surface_distance_lpi_median`,`feature`.`member_surface_distance_lpi_stddev` AS `member_surface_distance_lpi_stddev`,`feature`.`member_surface_distance_lpi_max` AS `member_surface_distance_lpi_max`,`feature`.`member_surface_distance_lpi_top3_mean` AS `member_surface_distance_lpi_top3_mean`,`feature`.`member_surface_distance_lpi_top1_top2_gap` AS `member_surface_distance_lpi_top1_top2_gap`,`feature`.`member_surface_distance_spi_valid_count` AS `member_surface_distance_spi_valid_count`,`feature`.`member_surface_distance_spi_mean` AS `member_surface_distance_spi_mean`,`feature`.`member_surface_distance_spi_median` AS `member_surface_distance_spi_median`,`feature`.`member_surface_distance_spi_stddev` AS `member_surface_distance_spi_stddev`,`feature`.`member_surface_distance_spi_max` AS `member_surface_distance_spi_max`,`feature`.`member_surface_distance_spi_top3_mean` AS `member_surface_distance_spi_top3_mean`,`feature`.`member_surface_distance_spi_top1_top2_gap` AS `member_surface_distance_spi_top1_top2_gap`,`feature`.`member_surface_distance_kri_valid_count` AS `member_surface_distance_kri_valid_count`,`feature`.`member_surface_distance_kri_mean` AS `member_surface_distance_kri_mean`,`feature`.`member_surface_distance_kri_median` AS `member_surface_distance_kri_median`,`feature`.`member_surface_distance_kri_stddev` AS `member_surface_distance_kri_stddev`,`feature`.`member_surface_distance_kri_max` AS `member_surface_distance_kri_max`,`feature`.`member_surface_distance_kri_top3_mean` AS `member_surface_distance_kri_top3_mean`,`feature`.`member_surface_distance_kri_top1_top2_gap` AS `member_surface_distance_kri_top1_top2_gap`,`feature`.`member_ability_variability_valid_count` AS `member_ability_variability_valid_count`,`feature`.`member_ability_variability_mad_z_mean` AS `member_ability_variability_mad_z_mean`,`feature`.`member_ability_variability_mad_z_median` AS `member_ability_variability_mad_z_median`,`feature`.`member_style_valid_horse_count` AS `member_style_valid_horse_count`,`feature`.`member_style_coverage_rate` AS `member_style_coverage_rate`,`feature`.`member_nige_style_rate_sum` AS `member_nige_style_rate_sum`,`feature`.`member_senko_style_rate_sum` AS `member_senko_style_rate_sum`,`feature`.`member_sashi_style_rate_sum` AS `member_sashi_style_rate_sum`,`feature`.`member_oikomi_style_rate_sum` AS `member_oikomi_style_rate_sum`
FROM (((((`tfs_race_feature` `feature`
JOIN `tfs_race_checkpoint` `checkpoint` on((`checkpoint`.`race_id` = `feature`.`race_id`)))
JOIN `tfs_processing_control` `control` on((`control`.`control_id` = 1)))
JOIN `core_ra_race` `race` on(((`race`.`race_id` = `feature`.`race_id`) and (`race`.`is_cancelled` = 0))))
LEFT JOIN `ability_bundle_race_origin` `origin` on((`origin`.`race_id` = `feature`.`race_id`)))
LEFT JOIN `ability_bundle_install` `bundle` on((`bundle`.`ability_bundle_install_id` = `origin`.`ability_bundle_install_id`)))
WHERE (((`origin`.`origin_type` = 'FROZEN_BUNDLE') and (`origin`.`publish_ready` = 1) and (`origin`.`tfs_job_id` = `feature`.`tfs_job_id`) and (`bundle`.`install_status` = 'SUCCESS')) or ((`origin`.`race_id` is null) and (`checkpoint`.`calc_status` = 'SUCCESS') and (`checkpoint`.`last_tfs_job_id` = `feature`.`tfs_job_id`) and (`checkpoint`.`tfs_spec_version` = `control`.`tfs_spec_version`) and (`checkpoint`.`tfs_algorithm_version` = `control`.`tfs_algorithm_version`)))
公開済みTFSの出走馬単位特徴量vw_tfs_published_race_horse_feature172 fields

参照元:ability_bundle_install、ability_bundle_race_origin、core_ra_race、tfs_processing_control、tfs_race_checkpoint

カラム名データ型説明
tfs_race_horse_feature_idBIGINT定義SQLを参照
tfs_job_idBIGINT定義SQLを参照
tfs_race_feature_idBIGINT定義SQLを参照
race_idBIGINTレースID
race_horse_idBIGINT出走馬ID
horse_idBIGINT競走馬ID
race_dateDATE開催日
quality_statusVARCHAR(16)定義SQLを参照
created_atDATETIME定義SQLを参照
updated_atDATETIME更新日時
previous_race_idBIGINT定義SQLを参照
previous_race_horse_idBIGINT定義SQLを参照
previous_run_found_flagTINYINT(1)定義SQLを参照
previous_run_type_cdVARCHAR(32)定義SQLを参照
previous_run_status_cdVARCHAR(32)定義SQLを参照
previous_run_interval_daysINT定義SQLを参照
previous_run_calendar_week_diff_countSMALLINT定義SQLを参照
rotation_interval_category_cdVARCHAR(32)定義SQLを参照
first_start_flagTINYINT(1)定義SQLを参照
layoff_return_flagTINYINT(1)定義SQLを参照
run_count_since_layoffSMALLINT定義SQLを参照
distance_diff_mSMALLINT定義SQLを参照
distance_change_rateDECIMAL(8,5)定義SQLを参照
distance_change_type_cdVARCHAR(32)定義SQLを参照
surface_change_type_cdVARCHAR(32)定義SQLを参照
racecourse_change_flagTINYINT(1)定義SQLを参照
class_change_type_cdVARCHAR(32)定義SQLを参照
class_change_stepSMALLINT定義SQLを参照
class_comparable_flagTINYINT(1)定義SQLを参照
carried_weight_diff_kgDECIMAL(5,1)定義SQLを参照
jockey_change_flagTINYINT(1)定義SQLを参照
trainer_change_flagTINYINT(1)定義SQLを参照
blinker_change_type_cdVARCHAR(32)定義SQLを参照
apprentice_change_flagTINYINT(1)定義SQLを参照
training_last_valid_datetimeDATETIME定義SQLを参照
training_last_valid_type_cdVARCHAR(16)定義SQLを参照
training_last_valid_days_before_raceINT定義SQLを参照
training_last_valid_hours_before_raceDECIMAL(10,2)定義SQLを参照
training_source_status_cdVARCHAR(32)定義SQLを参照
hc_training_source_status_cdVARCHAR(32)定義SQLを参照
wc_training_source_status_cdVARCHAR(32)定義SQLを参照
training_source_count_7dINT定義SQLを参照
training_valid_source_count_7dINT定義SQLを参照
training_valid_distinct_day_count_7dINT定義SQLを参照
hc_training_valid_source_count_7dINT定義SQLを参照
wc_training_valid_source_count_7dINT定義SQLを参照
training_source_count_14dINT定義SQLを参照
training_valid_source_count_14dINT定義SQLを参照
training_valid_distinct_day_count_14dINT定義SQLを参照
hc_training_valid_source_count_14dINT定義SQLを参照
wc_training_valid_source_count_14dINT定義SQLを参照
training_source_count_28dINT定義SQLを参照
training_valid_source_count_28dINT定義SQLを参照
training_valid_distinct_day_count_28dINT定義SQLを参照
hc_training_valid_source_count_28dINT定義SQLを参照
wc_training_valid_source_count_28dINT定義SQLを参照
training_valid_source_count_since_previous_runINT定義SQLを参照
training_valid_distinct_day_count_since_previous_runINT定義SQLを参照
hc_training_valid_source_count_since_previous_runINT定義SQLを参照
wc_training_valid_source_count_since_previous_runINT定義SQLを参照
hc_training_last_valid_datetimeDATETIME定義SQLを参照
hc_training_last_valid_center_cdCHAR(1)定義SQLを参照
hc_training_last_valid_days_before_raceINT定義SQLを参照
hc_training_last_valid_4f_secDECIMAL(8,3)定義SQLを参照
hc_training_last_valid_3f_secDECIMAL(8,3)定義SQLを参照
hc_training_last_valid_2f_secDECIMAL(8,3)定義SQLを参照
hc_training_last_valid_1f_secDECIMAL(8,3)定義SQLを参照
hc_training_last_valid_lap_800_600_secDECIMAL(8,3)定義SQLを参照
hc_training_last_valid_lap_600_400_secDECIMAL(8,3)定義SQLを参照
hc_training_last_valid_lap_400_200_secDECIMAL(8,3)定義SQLを参照
hc_training_last_valid_1f_accel_secDECIMAL(8,3)定義SQLを参照
hc_training_last_valid_2f_half_accel_secDECIMAL(8,3)定義SQLを参照
wc_training_last_valid_datetimeDATETIME定義SQLを参照
wc_training_last_valid_center_cdCHAR(1)定義SQLを参照
wc_training_last_valid_course_cdCHAR(1)定義SQLを参照
wc_training_last_valid_direction_cdCHAR(1)定義SQLを参照
wc_training_last_valid_days_before_raceINT定義SQLを参照
wc_training_last_valid_6f_secDECIMAL(8,3)定義SQLを参照
wc_training_last_valid_5f_secDECIMAL(8,3)定義SQLを参照
wc_training_last_valid_4f_secDECIMAL(8,3)定義SQLを参照
wc_training_last_valid_3f_secDECIMAL(8,3)定義SQLを参照
wc_training_last_valid_2f_secDECIMAL(8,3)定義SQLを参照
wc_training_last_valid_1f_secDECIMAL(8,3)定義SQLを参照
wc_training_last_valid_lap_1200_1000_secDECIMAL(8,3)定義SQLを参照
wc_training_last_valid_lap_1000_800_secDECIMAL(8,3)定義SQLを参照
wc_training_last_valid_lap_800_600_secDECIMAL(8,3)定義SQLを参照
wc_training_last_valid_lap_600_400_secDECIMAL(8,3)定義SQLを参照
wc_training_last_valid_lap_400_200_secDECIMAL(8,3)定義SQLを参照
wc_training_last_valid_1f_accel_secDECIMAL(8,3)定義SQLを参照
wc_training_last_valid_2f_half_accel_secDECIMAL(8,3)定義SQLを参照
hc_training_last_valid_4f_vs_horse_median_secDECIMAL(8,3)定義SQLを参照
hc_training_last_valid_1f_vs_horse_median_secDECIMAL(8,3)定義SQLを参照
wc_training_last_valid_6f_vs_horse_median_secDECIMAL(8,3)定義SQLを参照
wc_training_last_valid_1f_vs_horse_median_secDECIMAL(8,3)定義SQLを参照
hc_training_4f_horse_median_source_countINT定義SQLを参照
hc_training_1f_horse_median_source_countINT定義SQLを参照
wc_training_6f_horse_median_source_countINT定義SQLを参照
wc_training_1f_horse_median_source_countINT定義SQLを参照
jockey_source_status_cdVARCHAR(32)定義SQLを参照
jockey_year_surface_start_countINT定義SQLを参照
jockey_year_surface_win_rateDECIMAL(7,6)定義SQLを参照
jockey_year_surface_top2_rateDECIMAL(7,6)定義SQLを参照
jockey_year_surface_top3_rateDECIMAL(7,6)定義SQLを参照
jockey_year_distance_start_countINT定義SQLを参照
jockey_year_distance_win_rateDECIMAL(7,6)定義SQLを参照
jockey_year_distance_top2_rateDECIMAL(7,6)定義SQLを参照
jockey_year_distance_top3_rateDECIMAL(7,6)定義SQLを参照
jockey_year_racecourse_surface_start_countINT定義SQLを参照
jockey_year_racecourse_surface_win_rateDECIMAL(7,6)定義SQLを参照
jockey_year_racecourse_surface_top2_rateDECIMAL(7,6)定義SQLを参照
jockey_year_racecourse_surface_top3_rateDECIMAL(7,6)定義SQLを参照
jockey_career_surface_start_countINT定義SQLを参照
jockey_career_surface_win_rateDECIMAL(7,6)定義SQLを参照
jockey_career_surface_top2_rateDECIMAL(7,6)定義SQLを参照
jockey_career_surface_top3_rateDECIMAL(7,6)定義SQLを参照
jockey_career_distance_start_countINT定義SQLを参照
jockey_career_distance_win_rateDECIMAL(7,6)定義SQLを参照
jockey_career_distance_top2_rateDECIMAL(7,6)定義SQLを参照
jockey_career_distance_top3_rateDECIMAL(7,6)定義SQLを参照
jockey_career_racecourse_surface_start_countINT定義SQLを参照
jockey_career_racecourse_surface_win_rateDECIMAL(7,6)定義SQLを参照
jockey_career_racecourse_surface_top2_rateDECIMAL(7,6)定義SQLを参照
jockey_career_racecourse_surface_top3_rateDECIMAL(7,6)定義SQLを参照
trainer_source_status_cdVARCHAR(32)定義SQLを参照
trainer_year_surface_start_countINT定義SQLを参照
trainer_year_surface_win_rateDECIMAL(7,6)定義SQLを参照
trainer_year_surface_top2_rateDECIMAL(7,6)定義SQLを参照
trainer_year_surface_top3_rateDECIMAL(7,6)定義SQLを参照
trainer_year_distance_start_countINT定義SQLを参照
trainer_year_distance_win_rateDECIMAL(7,6)定義SQLを参照
trainer_year_distance_top2_rateDECIMAL(7,6)定義SQLを参照
trainer_year_distance_top3_rateDECIMAL(7,6)定義SQLを参照
trainer_year_racecourse_surface_start_countINT定義SQLを参照
trainer_year_racecourse_surface_win_rateDECIMAL(7,6)定義SQLを参照
trainer_year_racecourse_surface_top2_rateDECIMAL(7,6)定義SQLを参照
trainer_year_racecourse_surface_top3_rateDECIMAL(7,6)定義SQLを参照
trainer_career_surface_start_countINT定義SQLを参照
trainer_career_surface_win_rateDECIMAL(7,6)定義SQLを参照
trainer_career_surface_top2_rateDECIMAL(7,6)定義SQLを参照
trainer_career_surface_top3_rateDECIMAL(7,6)定義SQLを参照
trainer_career_distance_start_countINT定義SQLを参照
trainer_career_distance_win_rateDECIMAL(7,6)定義SQLを参照
trainer_career_distance_top2_rateDECIMAL(7,6)定義SQLを参照
trainer_career_distance_top3_rateDECIMAL(7,6)定義SQLを参照
trainer_career_racecourse_surface_start_countINT定義SQLを参照
trainer_career_racecourse_surface_win_rateDECIMAL(7,6)定義SQLを参照
trainer_career_racecourse_surface_top2_rateDECIMAL(7,6)定義SQLを参照
trainer_career_racecourse_surface_top3_rateDECIMAL(7,6)定義SQLを参照
horse_style_source_status_cdVARCHAR(32)定義SQLを参照
horse_style_source_countINT定義SQLを参照
nige_style_rateDECIMAL(7,6)定義SQLを参照
senko_style_rateDECIMAL(7,6)定義SQLを参照
sashi_style_rateDECIMAL(7,6)定義SQLを参照
oikomi_style_rateDECIMAL(7,6)定義SQLを参照
member_overall_tai_rankSMALLINT定義SQLを参照
member_overall_tai_mean_diffDECIMAL(7,3)定義SQLを参照
member_overall_tai_max_diffDECIMAL(7,3)定義SQLを参照
member_surface_distance_tai_rankSMALLINT定義SQLを参照
member_surface_distance_tai_mean_diffDECIMAL(7,3)定義SQLを参照
member_surface_distance_tai_max_diffDECIMAL(7,3)定義SQLを参照
member_surface_distance_epi_rankSMALLINT定義SQLを参照
member_surface_distance_epi_mean_diffDECIMAL(7,3)定義SQLを参照
member_surface_distance_epi_max_diffDECIMAL(7,3)定義SQLを参照
member_surface_distance_lpi_rankSMALLINT定義SQLを参照
member_surface_distance_lpi_mean_diffDECIMAL(7,3)定義SQLを参照
member_surface_distance_lpi_max_diffDECIMAL(7,3)定義SQLを参照
member_surface_distance_spi_rankSMALLINT定義SQLを参照
member_surface_distance_spi_mean_diffDECIMAL(7,3)定義SQLを参照
member_surface_distance_spi_max_diffDECIMAL(7,3)定義SQLを参照
member_surface_distance_kri_rankSMALLINT定義SQLを参照
member_surface_distance_kri_mean_diffDECIMAL(7,3)定義SQLを参照
member_surface_distance_kri_max_diffDECIMAL(7,3)定義SQLを参照
参照・計算条件のSQLを確認する
select `feature`.`tfs_race_horse_feature_id` AS `tfs_race_horse_feature_id`,`feature`.`tfs_job_id` AS `tfs_job_id`,`feature`.`tfs_race_feature_id` AS `tfs_race_feature_id`,`feature`.`race_id` AS `race_id`,`feature`.`race_horse_id` AS `race_horse_id`,`feature`.`horse_id` AS `horse_id`,`feature`.`race_date` AS `race_date`,`feature`.`quality_status` AS `quality_status`,`feature`.`created_at` AS `created_at`,`feature`.`updated_at` AS `updated_at`,`feature`.`previous_race_id` AS `previous_race_id`,`feature`.`previous_race_horse_id` AS `previous_race_horse_id`,`feature`.`previous_run_found_flag` AS `previous_run_found_flag`,`feature`.`previous_run_type_cd` AS `previous_run_type_cd`,`feature`.`previous_run_status_cd` AS `previous_run_status_cd`,`feature`.`previous_run_interval_days` AS `previous_run_interval_days`,`feature`.`previous_run_calendar_week_diff_count` AS `previous_run_calendar_week_diff_count`,`feature`.`rotation_interval_category_cd` AS `rotation_interval_category_cd`,`feature`.`first_start_flag` AS `first_start_flag`,`feature`.`layoff_return_flag` AS `layoff_return_flag`,`feature`.`run_count_since_layoff` AS `run_count_since_layoff`,`feature`.`distance_diff_m` AS `distance_diff_m`,`feature`.`distance_change_rate` AS `distance_change_rate`,`feature`.`distance_change_type_cd` AS `distance_change_type_cd`,`feature`.`surface_change_type_cd` AS `surface_change_type_cd`,`feature`.`racecourse_change_flag` AS `racecourse_change_flag`,`feature`.`class_change_type_cd` AS `class_change_type_cd`,`feature`.`class_change_step` AS `class_change_step`,`feature`.`class_comparable_flag` AS `class_comparable_flag`,`feature`.`carried_weight_diff_kg` AS `carried_weight_diff_kg`,`feature`.`jockey_change_flag` AS `jockey_change_flag`,`feature`.`trainer_change_flag` AS `trainer_change_flag`,`feature`.`blinker_change_type_cd` AS `blinker_change_type_cd`,`feature`.`apprentice_change_flag` AS `apprentice_change_flag`,`feature`.`training_last_valid_datetime` AS `training_last_valid_datetime`,`feature`.`training_last_valid_type_cd` AS `training_last_valid_type_cd`,`feature`.`training_last_valid_days_before_race` AS `training_last_valid_days_before_race`,`feature`.`training_last_valid_hours_before_race` AS `training_last_valid_hours_before_race`,`feature`.`training_source_status_cd` AS `training_source_status_cd`,`feature`.`hc_training_source_status_cd` AS `hc_training_source_status_cd`,`feature`.`wc_training_source_status_cd` AS `wc_training_source_status_cd`,`feature`.`training_source_count_7d` AS `training_source_count_7d`,`feature`.`training_valid_source_count_7d` AS `training_valid_source_count_7d`,`feature`.`training_valid_distinct_day_count_7d` AS `training_valid_distinct_day_count_7d`,`feature`.`hc_training_valid_source_count_7d` AS `hc_training_valid_source_count_7d`,`feature`.`wc_training_valid_source_count_7d` AS `wc_training_valid_source_count_7d`,`feature`.`training_source_count_14d` AS `training_source_count_14d`,`feature`.`training_valid_source_count_14d` AS `training_valid_source_count_14d`,`feature`.`training_valid_distinct_day_count_14d` AS `training_valid_distinct_day_count_14d`,`feature`.`hc_training_valid_source_count_14d` AS `hc_training_valid_source_count_14d`,`feature`.`wc_training_valid_source_count_14d` AS `wc_training_valid_source_count_14d`,`feature`.`training_source_count_28d` AS `training_source_count_28d`,`feature`.`training_valid_source_count_28d` AS `training_valid_source_count_28d`,`feature`.`training_valid_distinct_day_count_28d` AS `training_valid_distinct_day_count_28d`,`feature`.`hc_training_valid_source_count_28d` AS `hc_training_valid_source_count_28d`,`feature`.`wc_training_valid_source_count_28d` AS `wc_training_valid_source_count_28d`,`feature`.`training_valid_source_count_since_previous_run` AS `training_valid_source_count_since_previous_run`,`feature`.`training_valid_distinct_day_count_since_previous_run` AS `training_valid_distinct_day_count_since_previous_run`,`feature`.`hc_training_valid_source_count_since_previous_run` AS `hc_training_valid_source_count_since_previous_run`,`feature`.`wc_training_valid_source_count_since_previous_run` AS `wc_training_valid_source_count_since_previous_run`,`feature`.`hc_training_last_valid_datetime` AS `hc_training_last_valid_datetime`,`feature`.`hc_training_last_valid_center_cd` AS `hc_training_last_valid_center_cd`,`feature`.`hc_training_last_valid_days_before_race` AS `hc_training_last_valid_days_before_race`,`feature`.`hc_training_last_valid_4f_sec` AS `hc_training_last_valid_4f_sec`,`feature`.`hc_training_last_valid_3f_sec` AS `hc_training_last_valid_3f_sec`,`feature`.`hc_training_last_valid_2f_sec` AS `hc_training_last_valid_2f_sec`,`feature`.`hc_training_last_valid_1f_sec` AS `hc_training_last_valid_1f_sec`,`feature`.`hc_training_last_valid_lap_800_600_sec` AS `hc_training_last_valid_lap_800_600_sec`,`feature`.`hc_training_last_valid_lap_600_400_sec` AS `hc_training_last_valid_lap_600_400_sec`,`feature`.`hc_training_last_valid_lap_400_200_sec` AS `hc_training_last_valid_lap_400_200_sec`,`feature`.`hc_training_last_valid_1f_accel_sec` AS `hc_training_last_valid_1f_accel_sec`,`feature`.`hc_training_last_valid_2f_half_accel_sec` AS `hc_training_last_valid_2f_half_accel_sec`,`feature`.`wc_training_last_valid_datetime` AS `wc_training_last_valid_datetime`,`feature`.`wc_training_last_valid_center_cd` AS `wc_training_last_valid_center_cd`,`feature`.`wc_training_last_valid_course_cd` AS `wc_training_last_valid_course_cd`,`feature`.`wc_training_last_valid_direction_cd` AS `wc_training_last_valid_direction_cd`,`feature`.`wc_training_last_valid_days_before_race` AS `wc_training_last_valid_days_before_race`,`feature`.`wc_training_last_valid_6f_sec` AS `wc_training_last_valid_6f_sec`,`feature`.`wc_training_last_valid_5f_sec` AS `wc_training_last_valid_5f_sec`,`feature`.`wc_training_last_valid_4f_sec` AS `wc_training_last_valid_4f_sec`,`feature`.`wc_training_last_valid_3f_sec` AS `wc_training_last_valid_3f_sec`,`feature`.`wc_training_last_valid_2f_sec` AS `wc_training_last_valid_2f_sec`,`feature`.`wc_training_last_valid_1f_sec` AS `wc_training_last_valid_1f_sec`,`feature`.`wc_training_last_valid_lap_1200_1000_sec` AS `wc_training_last_valid_lap_1200_1000_sec`,`feature`.`wc_training_last_valid_lap_1000_800_sec` AS `wc_training_last_valid_lap_1000_800_sec`,`feature`.`wc_training_last_valid_lap_800_600_sec` AS `wc_training_last_valid_lap_800_600_sec`,`feature`.`wc_training_last_valid_lap_600_400_sec` AS `wc_training_last_valid_lap_600_400_sec`,`feature`.`wc_training_last_valid_lap_400_200_sec` AS `wc_training_last_valid_lap_400_200_sec`,`feature`.`wc_training_last_valid_1f_accel_sec` AS `wc_training_last_valid_1f_accel_sec`,`feature`.`wc_training_last_valid_2f_half_accel_sec` AS `wc_training_last_valid_2f_half_accel_sec`,`feature`.`hc_training_last_valid_4f_vs_horse_median_sec` AS `hc_training_last_valid_4f_vs_horse_median_sec`,`feature`.`hc_training_last_valid_1f_vs_horse_median_sec` AS `hc_training_last_valid_1f_vs_horse_median_sec`,`feature`.`wc_training_last_valid_6f_vs_horse_median_sec` AS `wc_training_last_valid_6f_vs_horse_median_sec`,`feature`.`wc_training_last_valid_1f_vs_horse_median_sec` AS `wc_training_last_valid_1f_vs_horse_median_sec`,`feature`.`hc_training_4f_horse_median_source_count` AS `hc_training_4f_horse_median_source_count`,`feature`.`hc_training_1f_horse_median_source_count` AS `hc_training_1f_horse_median_source_count`,`feature`.`wc_training_6f_horse_median_source_count` AS `wc_training_6f_horse_median_source_count`,`feature`.`wc_training_1f_horse_median_source_count` AS `wc_training_1f_horse_median_source_count`,`feature`.`jockey_source_status_cd` AS `jockey_source_status_cd`,`feature`.`jockey_year_surface_start_count` AS `jockey_year_surface_start_count`,`feature`.`jockey_year_surface_win_rate` AS `jockey_year_surface_win_rate`,`feature`.`jockey_year_surface_top2_rate` AS `jockey_year_surface_top2_rate`,`feature`.`jockey_year_surface_top3_rate` AS `jockey_year_surface_top3_rate`,`feature`.`jockey_year_distance_start_count` AS `jockey_year_distance_start_count`,`feature`.`jockey_year_distance_win_rate` AS `jockey_year_distance_win_rate`,`feature`.`jockey_year_distance_top2_rate` AS `jockey_year_distance_top2_rate`,`feature`.`jockey_year_distance_top3_rate` AS `jockey_year_distance_top3_rate`,`feature`.`jockey_year_racecourse_surface_start_count` AS `jockey_year_racecourse_surface_start_count`,`feature`.`jockey_year_racecourse_surface_win_rate` AS `jockey_year_racecourse_surface_win_rate`,`feature`.`jockey_year_racecourse_surface_top2_rate` AS `jockey_year_racecourse_surface_top2_rate`,`feature`.`jockey_year_racecourse_surface_top3_rate` AS `jockey_year_racecourse_surface_top3_rate`,`feature`.`jockey_career_surface_start_count` AS `jockey_career_surface_start_count`,`feature`.`jockey_career_surface_win_rate` AS `jockey_career_surface_win_rate`,`feature`.`jockey_career_surface_top2_rate` AS `jockey_career_surface_top2_rate`,`feature`.`jockey_career_surface_top3_rate` AS `jockey_career_surface_top3_rate`,`feature`.`jockey_career_distance_start_count` AS `jockey_career_distance_start_count`,`feature`.`jockey_career_distance_win_rate` AS `jockey_career_distance_win_rate`,`feature`.`jockey_career_distance_top2_rate` AS `jockey_career_distance_top2_rate`,`feature`.`jockey_career_distance_top3_rate` AS `jockey_career_distance_top3_rate`,`feature`.`jockey_career_racecourse_surface_start_count` AS `jockey_career_racecourse_surface_start_count`,`feature`.`jockey_career_racecourse_surface_win_rate` AS `jockey_career_racecourse_surface_win_rate`,`feature`.`jockey_career_racecourse_surface_top2_rate` AS `jockey_career_racecourse_surface_top2_rate`,`feature`.`jockey_career_racecourse_surface_top3_rate` AS `jockey_career_racecourse_surface_top3_rate`,`feature`.`trainer_source_status_cd` AS `trainer_source_status_cd`,`feature`.`trainer_year_surface_start_count` AS `trainer_year_surface_start_count`,`feature`.`trainer_year_surface_win_rate` AS `trainer_year_surface_win_rate`,`feature`.`trainer_year_surface_top2_rate` AS `trainer_year_surface_top2_rate`,`feature`.`trainer_year_surface_top3_rate` AS `trainer_year_surface_top3_rate`,`feature`.`trainer_year_distance_start_count` AS `trainer_year_distance_start_count`,`feature`.`trainer_year_distance_win_rate` AS `trainer_year_distance_win_rate`,`feature`.`trainer_year_distance_top2_rate` AS `trainer_year_distance_top2_rate`,`feature`.`trainer_year_distance_top3_rate` AS `trainer_year_distance_top3_rate`,`feature`.`trainer_year_racecourse_surface_start_count` AS `trainer_year_racecourse_surface_start_count`,`feature`.`trainer_year_racecourse_surface_win_rate` AS `trainer_year_racecourse_surface_win_rate`,`feature`.`trainer_year_racecourse_surface_top2_rate` AS `trainer_year_racecourse_surface_top2_rate`,`feature`.`trainer_year_racecourse_surface_top3_rate` AS `trainer_year_racecourse_surface_top3_rate`,`feature`.`trainer_career_surface_start_count` AS `trainer_career_surface_start_count`,`feature`.`trainer_career_surface_win_rate` AS `trainer_career_surface_win_rate`,`feature`.`trainer_career_surface_top2_rate` AS `trainer_career_surface_top2_rate`,`feature`.`trainer_career_surface_top3_rate` AS `trainer_career_surface_top3_rate`,`feature`.`trainer_career_distance_start_count` AS `trainer_career_distance_start_count`,`feature`.`trainer_career_distance_win_rate` AS `trainer_career_distance_win_rate`,`feature`.`trainer_career_distance_top2_rate` AS `trainer_career_distance_top2_rate`,`feature`.`trainer_career_distance_top3_rate` AS `trainer_career_distance_top3_rate`,`feature`.`trainer_career_racecourse_surface_start_count` AS `trainer_career_racecourse_surface_start_count`,`feature`.`trainer_career_racecourse_surface_win_rate` AS `trainer_career_racecourse_surface_win_rate`,`feature`.`trainer_career_racecourse_surface_top2_rate` AS `trainer_career_racecourse_surface_top2_rate`,`feature`.`trainer_career_racecourse_surface_top3_rate` AS `trainer_career_racecourse_surface_top3_rate`,`feature`.`horse_style_source_status_cd` AS `horse_style_source_status_cd`,`feature`.`horse_style_source_count` AS `horse_style_source_count`,`feature`.`nige_style_rate` AS `nige_style_rate`,`feature`.`senko_style_rate` AS `senko_style_rate`,`feature`.`sashi_style_rate` AS `sashi_style_rate`,`feature`.`oikomi_style_rate` AS `oikomi_style_rate`,`feature`.`member_overall_tai_rank` AS `member_overall_tai_rank`,`feature`.`member_overall_tai_mean_diff` AS `member_overall_tai_mean_diff`,`feature`.`member_overall_tai_max_diff` AS `member_overall_tai_max_diff`,`feature`.`member_surface_distance_tai_rank` AS `member_surface_distance_tai_rank`,`feature`.`member_surface_distance_tai_mean_diff` AS `member_surface_distance_tai_mean_diff`,`feature`.`member_surface_distance_tai_max_diff` AS `member_surface_distance_tai_max_diff`,`feature`.`member_surface_distance_epi_rank` AS `member_surface_distance_epi_rank`,`feature`.`member_surface_distance_epi_mean_diff` AS `member_surface_distance_epi_mean_diff`,`feature`.`member_surface_distance_epi_max_diff` AS `member_surface_distance_epi_max_diff`,`feature`.`member_surface_distance_lpi_rank` AS `member_surface_distance_lpi_rank`,`feature`.`member_surface_distance_lpi_mean_diff` AS `member_surface_distance_lpi_mean_diff`,`feature`.`member_surface_distance_lpi_max_diff` AS `member_surface_distance_lpi_max_diff`,`feature`.`member_surface_distance_spi_rank` AS `member_surface_distance_spi_rank`,`feature`.`member_surface_distance_spi_mean_diff` AS `member_surface_distance_spi_mean_diff`,`feature`.`member_surface_distance_spi_max_diff` AS `member_surface_distance_spi_max_diff`,`feature`.`member_surface_distance_kri_rank` AS `member_surface_distance_kri_rank`,`feature`.`member_surface_distance_kri_mean_diff` AS `member_surface_distance_kri_mean_diff`,`feature`.`member_surface_distance_kri_max_diff` AS `member_surface_distance_kri_max_diff`
FROM (((((`tfs_race_horse_feature` `feature`
JOIN `tfs_race_checkpoint` `checkpoint` on((`checkpoint`.`race_id` = `feature`.`race_id`)))
JOIN `tfs_processing_control` `control` on((`control`.`control_id` = 1)))
JOIN `core_ra_race` `race` on(((`race`.`race_id` = `feature`.`race_id`) and (`race`.`is_cancelled` = 0))))
LEFT JOIN `ability_bundle_race_origin` `origin` on((`origin`.`race_id` = `feature`.`race_id`)))
LEFT JOIN `ability_bundle_install` `bundle` on((`bundle`.`ability_bundle_install_id` = `origin`.`ability_bundle_install_id`)))
WHERE (((`origin`.`origin_type` = 'FROZEN_BUNDLE') and (`origin`.`publish_ready` = 1) and (`origin`.`tfs_job_id` = `feature`.`tfs_job_id`) and (`bundle`.`install_status` = 'SUCCESS')) or ((`origin`.`race_id` is null) and (`checkpoint`.`calc_status` = 'SUCCESS') and (`checkpoint`.`last_tfs_job_id` = `feature`.`tfs_job_id`) and (`checkpoint`.`tfs_spec_version` = `control`.`tfs_spec_version`) and (`checkpoint`.`tfs_algorithm_version` = `control`.`tfs_algorithm_version`)))

Tazuna Link Code list

利用・分析時に参照する主な独自コード・区分です。JRA-VANの公式コードと混同しないよう、対象テーブル・項目を確認してください。

賭式コードbet_type_cd8 values

購入記録の対象は通常8券種です。WIN5は別のcore_wf_win5系テーブルで管理します。

使用テーブル:aux_hr_payout_header、aux_hr_realtime_payout_header、aux_o1o6_odds_header、aux_o1o6_prerace_odds_header、user_purchase

値意味
01単勝
02複勝
03枠連
04馬連
05ワイド
06馬単
073連複
083連単
マイニング区分mining_bunrui_cd2 values

同じDM・TMテーブルでも、速報と確定を区別して参照します。

使用テーブル:aux_dm_mining、aux_tm_mining

値意味
1速報
2確定
予想印prediction_mark_cd6 values

保存値の〇は漢数字のゼロです。印はuser_horse_memoでレースごとに保存します。各印の呼び方は一般的な目安です。

使用テーブル:user_horse_memo

値意味
◎本命
〇対抗
▲単穴
△連下
☆注目
NULL印なし
注目馬の色color_cd5 values

user_watch_horseの色コードです。未選択は別の色値ではなく、注目馬の登録がない状態です。

使用テーブル:user_watch_horse

値意味
red赤
blue青
green緑
yellow黄
purple紫