TazunaLinkDB.zip
タヅナリンクのデータベース仕様をまとめたファイルです。
Database
タヅナリンクで構築されるMySQLのテーブルとビュー、各カラムの仕様をまとめています。
生成AIにSQL作成を相談する際は、DB仕様ZIPを添付してください。実際のテーブル名やカラム名を確認しながら、分析に必要なSQLを作成するための資料として使えます。
タヅナリンクのデータベース仕様をまとめたファイルです。
タヅナリンクが使用する全テーブル・ビューのカラム定義です。テーブルは論理名・物理名・データ型と、共通項目のJVDataとの対応を掲載しています。ビューはカラム名・データ型・説明で構成しています。
core
レース・出走馬の事前情報と結果、WIN5の対象レース・払戻を保存します。
dim
開催、競走馬、騎手、調教師、血統、コースなどのマスタ情報です。
aux
調教、オッズ、払戻、マイニング、速報、出走時点情報、独自のペース情報を保存します。
tav
基準時計とコース・クラス・馬場状態・開催日馬場差などの補正値、レース補正を管理します。
taf
補正した時計を基にした馬ごとの能力スナップショットと公開状態を管理します。
tfs
出走メンバー内の相対比較など、レース単位・出走馬単位の特徴量を保存します。
tai_h
総合的な独自能力値の計算・公開に関するデータを保存します。
ability
計算済み能力値の取り込み元、対象範囲、公開状態などを管理します。
audit
データ取得の処理件数、警告、エラーなどの監査記録です。
config
取得位置、セットアップ・再開、補完待ち、スキーマ適用状態などを管理します。
user
予想印、レース・馬メモ、注目馬、フリーメモ、購入記録を保存します。
maintenance
ペース計算の実行管理や競走馬プロフィールの補完管理などを保存します。
127テーブルを表示
テーブル名を選ぶと全カラムを開きます。コード一覧のある行は、行全体を選択できます。幅が足りない表だけ横スクロールできます。
core_ra_race23 fields| 論理名 | 物理名 | データ型 | データ種別 | レコード種別 | JVData項目名 |
|---|---|---|---|---|---|
| レースID | race_id | BIGINT | |||
| スケジュールID | schedule_id | BIGINT | |||
| レース範囲区分 | race_scope_cd | TINYINT UNSIGNED | DIFN/RACE | RA | データ区分から派生 |
| 開催日 | race_date | DATE | DIFN/RACE | RA | 受け入れたRAレコードの開催年 + 開催月日(代替開催時は実開催日) |
| 競馬場コード | racecourse_cd | CHAR(2) | DIFN/RACE | RA | 競馬場コード |
| 開催回 | meeting_no | TINYINT UNSIGNED | DIFN/RACE | RA | 開催回 |
| 開催日目 | schedule_day_no | TINYINT UNSIGNED | DIFN/RACE | RA | 開催日目 |
| レース番号 | race_no | TINYINT UNSIGNED | DIFN/RACE | RA | レース番号 |
| レース中止フラグ | is_cancelled | TINYINT(1) | DIFN/RACE | RA | 同一開催日のデータ区分9から派生。代替開催日の通常データは旧開催日の中止情報より優先 |
| 競走名本題 | race_name_main | VARCHAR(60) | DIFN/RACE | RA | 競走名本題 |
| グレードコード | grade_cd | CHAR(1) | DIFN/RACE | RA | グレードコード |
| 競走種別コード | race_type_cd | CHAR(2) | DIFN/RACE | RA | 競走種別コード |
| 競走記号コード | race_symbol_cd | CHAR(3) | DIFN/RACE | RA | 競走記号コード |
| 重量種別コード | weight_type_cd | CHAR(1) | DIFN/RACE | RA | 重量種別コード |
| 競走条件コード 2歳 | condition_cd_2yo | CHAR(3) | DIFN/RACE | RA | 競走条件コード 2歳 |
| 競走条件コード 3歳 | condition_cd_3yo | CHAR(3) | DIFN/RACE | RA | 競走条件コード 3歳 |
| 競走条件コード 4歳 | condition_cd_4yo | CHAR(3) | DIFN/RACE | RA | 競走条件コード 4歳 |
| 競走条件コード 5歳以上 | condition_cd_5up | CHAR(3) | DIFN/RACE | RA | 競走条件コード 5歳以上 |
| 競走条件コード 最若年 | condition_cd_youngest | CHAR(3) | DIFN/RACE | RA | 競走条件コード 最若年 |
| 距離 | distance_m | SMALLINT UNSIGNED | DIFN/RACE | RA | 距離 |
| トラックコード | track_cd | CHAR(2) | DIFN/RACE | RA | トラックコード |
| コース区分 | course_cd | CHAR(2) | DIFN/RACE | RA | コース区分 |
| 発走予定時刻 | scheduled_start_time | TIME | DIFN/RACE | RA | 発走予定時刻 |
core_ra_race_corner5 fields| 論理名 | 物理名 | データ型 | データ種別 | レコード種別 | JVData項目名 |
|---|---|---|---|---|---|
| レースID | race_id | BIGINT | |||
| 配列順 | corner_seq_no | TINYINT UNSIGNED | DIFN/RACE | RA | 配列順 |
| コーナー | corner_no | TINYINT UNSIGNED | DIFN/RACE | RA | コーナー |
| 周回数 | lap_count | TINYINT UNSIGNED | DIFN/RACE | RA | 周回数 |
| 各通過順位 | passing_order_raw | VARCHAR(70) | DIFN/RACE | RA | 各通過順位 |
core_ra_race_lap4 fields| 論理名 | 物理名 | データ型 | データ種別 | レコード種別 | JVData項目名 |
|---|---|---|---|---|---|
| レースID | race_id | BIGINT | |||
| ラップ連番 | lap_no | TINYINT UNSIGNED | DIFN/RACE | RA | ラップ連番 |
| 区間距離 | lap_distance_m | SMALLINT UNSIGNED | DIFN/RACE | RA | 区間距離 |
| 先頭馬ラップタイム | lap_time_sec | DECIMAL(4,1) | DIFN/RACE | RA | 先頭馬ラップタイム |
core_ra_race_result10 fields| 論理名 | 物理名 | データ型 | データ種別 | レコード種別 | JVData項目名 |
|---|---|---|---|---|---|
| レースID | race_id | BIGINT | |||
| 出走頭数 | starter_count | TINYINT UNSIGNED | DIFN/RACE | RA | 出走頭数 |
| 入線頭数 | finisher_count | TINYINT UNSIGNED | DIFN/RACE | RA | 入線頭数 |
| 天候コード | weather_cd | CHAR(1) | DIFN/RACE | RA | 天候コード |
| 芝馬場状態コード | turf_condition_cd | CHAR(1) | DIFN/RACE | RA | 芝馬場状態コード |
| ダート馬場状態コード | dirt_condition_cd | CHAR(1) | DIFN/RACE | RA | ダート馬場状態コード |
| 前3ハロン | first_3f_sec | DECIMAL(4,1) | DIFN/RACE | RA | 前3ハロン |
| 前4ハロン | first_4f_sec | DECIMAL(4,1) | DIFN/RACE | RA | 前4ハロン |
| 後3ハロン | last_3f_sec | DECIMAL(4,1) | DIFN/RACE | RA | 後3ハロン |
| 後4ハロン | last_4f_sec | DECIMAL(4,1) | DIFN/RACE | RA | 後4ハロン |
core_se_race_horse17 fields| 論理名 | 物理名 | データ型 | データ種別 | レコード種別 | JVData項目名 |
|---|---|---|---|---|---|
| 出走馬ID | race_horse_id | BIGINT | |||
| レースID | race_id | BIGINT | |||
| 競走馬ID | horse_id | BIGINT | |||
| 枠番 | frame_no | TINYINT UNSIGNED | DIFN/RACE | SE | 枠番 |
| 馬番 | horse_no | TINYINT UNSIGNED | DIFN/RACE | SE | 馬番 |
| 馬記号コード | horse_symbol_cd | CHAR(2) | DIFN/RACE | SE | 馬記号コード |
| 性別コード | sex_cd | CHAR(1) | DIFN/RACE | SE | 性別コード |
| 品種コード | breed_cd | CHAR(1) | DIFN/RACE | SE | 品種コード |
| 毛色コード | coat_color_cd | CHAR(2) | DIFN/RACE | SE | 毛色コード |
| 馬齢 | horse_age | TINYINT UNSIGNED | DIFN/RACE | SE | 馬齢 |
| 東西所属コード | affiliation_cd | CHAR(1) | DIFN/RACE | SE | 東西所属コード |
| 調教師コード | trainer_cd | CHAR(5) | DIFN/RACE | SE | 調教師コード |
| 馬主コード | owner_cd | CHAR(6) | DIFN/RACE | SE | 馬主コード |
| 負担重量 | carried_weight_kg | DECIMAL(4,1) | DIFN/RACE | SE | 負担重量 |
| ブリンカー使用区分 | is_blinker | TINYINT(1) | DIFN/RACE | SE | ブリンカー使用区分 |
| 騎手コード | jockey_cd | CHAR(5) | DIFN/RACE | SE | 騎手コード |
| 騎手見習コード | apprentice_cd | CHAR(1) | DIFN/RACE | SE | 騎手見習コード |
core_se_race_horse_result25 fields| 論理名 | 物理名 | データ型 | データ種別 | レコード種別 | JVData項目名 |
|---|---|---|---|---|---|
| 出走馬ID | race_horse_id | BIGINT | |||
| 馬体重 | body_weight_kg | SMALLINT UNSIGNED | DIFN/RACE | SE | 馬体重 |
| 斤量負担率(百分率、小数第3位以降切り捨て) | carried_weight_ratio_pct | DECIMAL(4,2) | |||
| 馬体重増減 | body_weight_diff_kg | SMALLINT | DIFN/RACE | SE | 増減符号 + 増減差 |
| 異常区分コード | abnormality_cd | CHAR(1) | DIFN/RACE | SE | 異常区分コード |
| 入線順位 | arrival_order | TINYINT UNSIGNED | DIFN/RACE | SE | 入線順位 |
| 確定着順 | finish_order | TINYINT UNSIGNED | DIFN/RACE | SE | 確定着順 |
| 同着区分 | is_dead_heat | TINYINT(1) | DIFN/RACE | SE | 同着区分 |
| 同着頭数 | dead_heat_count_other | TINYINT UNSIGNED | DIFN/RACE | SE | 同着頭数 |
| 走破タイム | finish_time_sec | DECIMAL(5,1) | DIFN/RACE | SE | 走破タイム |
| 着差コード | margin_cd | CHAR(3) | DIFN/RACE | SE | 着差コード |
| 着差コード秒換算 | margin_sec | DECIMAL(5,2) | DIFN/RACE | SE | 定義済みの着差コードを秒換算。未定義形式はNULL |
| +着差コード | margin_plus_cd | CHAR(3) | DIFN/RACE | SE | +着差コード |
| +着差コード秒換算 | margin_plus_sec | DECIMAL(5,2) | DIFN/RACE | SE | 着差コードと同じ規則で秒換算。未定義形式はNULL |
| ++着差コード | margin_plus_plus_cd | CHAR(3) | DIFN/RACE | SE | ++着差コード |
| ++着差コード秒換算 | margin_plus_plus_sec | DECIMAL(5,2) | DIFN/RACE | SE | 着差コードと同じ規則で秒換算。未定義形式はNULL |
| 1コーナー順位 | corner1_order | TINYINT UNSIGNED | DIFN/RACE | SE | 1コーナー順位 |
| 2コーナー順位 | corner2_order | TINYINT UNSIGNED | DIFN/RACE | SE | 2コーナー順位 |
| 3コーナー順位 | corner3_order | TINYINT UNSIGNED | DIFN/RACE | SE | 3コーナー順位 |
| 4コーナー順位 | corner4_order | TINYINT UNSIGNED | DIFN/RACE | SE | 4コーナー順位 |
| 後4ハロンタイム | last_4f_sec | DECIMAL(4,1) | DIFN/RACE | SE | 後4ハロンタイム |
| 後3ハロンタイム | last_3f_sec | DECIMAL(4,1) | DIFN/RACE | SE | 後3ハロンタイム |
| 同一平地レース内の後3ハロン競技順位 | last_3f_rank | TINYINT UNSIGNED | |||
| タイム差 | time_diff_sec | DECIMAL(5,1) | DIFN/RACE | SE | タイム差 |
| 今回レース脚質判定 | running_style_cd | CHAR(1) | DIFN/RACE | SE | 今回レース脚質判定 |
core_wf_win511 fields| 論理名 | 物理名 | データ型 | データ種別 | レコード種別 | JVData項目名 |
|---|---|---|---|---|---|
| meeting_date | meeting_date | DATE | |||
| data_kubun_cd | data_kubun_cd | CHAR(1) | |||
| source_data_spec_cd | source_data_spec_cd | VARCHAR(4) | |||
| source_created_date | source_created_date | DATE | |||
| source_sha256 | source_sha256 | CHAR(64) | |||
| sales_ticket_count | sales_ticket_count | BIGINT UNSIGNED | |||
| refund_flag | refund_flag | CHAR(1) | |||
| invalid_flag | invalid_flag | CHAR(1) | |||
| no_winner_flag | no_winner_flag | CHAR(1) | |||
| initial_carryover_yen | initial_carryover_yen | BIGINT UNSIGNED | |||
| next_carryover_yen | next_carryover_yen | BIGINT UNSIGNED |
core_wf_win5_leg7 fields| 論理名 | 物理名 | データ型 | データ種別 | レコード種別 | JVData項目名 |
|---|---|---|---|---|---|
| meeting_date | meeting_date | DATE | |||
| leg_no | leg_no | TINYINT UNSIGNED | |||
| venue_cd | venue_cd | CHAR(2) | |||
| meeting_no | meeting_no | TINYINT UNSIGNED | |||
| meeting_day_no | meeting_day_no | TINYINT UNSIGNED | |||
| race_no | race_no | TINYINT UNSIGNED | |||
| valid_ticket_count | valid_ticket_count | BIGINT UNSIGNED |
core_wf_win5_payout5 fields| 論理名 | 物理名 | データ型 | データ種別 | レコード種別 | JVData項目名 |
|---|---|---|---|---|---|
| meeting_date | meeting_date | DATE | |||
| payout_slot_no | payout_slot_no | SMALLINT UNSIGNED | |||
| selection_key | selection_key | CHAR(10) | |||
| payout_yen | payout_yen | BIGINT UNSIGNED | |||
| winning_ticket_count | winning_ticket_count | BIGINT UNSIGNED |
dim_bn_owner3 fields| 論理名 | 物理名 | データ型 | データ種別 | レコード種別 | JVData項目名 |
|---|---|---|---|---|---|
| 馬主ID | owner_id | BIGINT | |||
| 馬主コード | owner_cd | CHAR(6) | DIFN | BN | 馬主コード |
| 馬主名(法人格有) | owner_name | VARCHAR(64) | DIFN | BN | 馬主名(法人格有) |
dim_br_breeder3 fields| 論理名 | 物理名 | データ型 | データ種別 | レコード種別 | JVData項目名 |
|---|---|---|---|---|---|
| 生産者ID | breeder_id | BIGINT | |||
| 生産者コード | breeder_cd | CHAR(8) | DIFN | BR | 生産者コード |
| 生産者名(法人格有) | breeder_name | VARCHAR(72) | DIFN | BR | 生産者名(法人格有) |
dim_bt_lineage5 fields| 論理名 | 物理名 | データ型 | データ種別 | レコード種別 | JVData項目名 |
|---|---|---|---|---|---|
| breeding_reg_no | breeding_reg_no | CHAR(10) | |||
| lineage_id | lineage_id | CHAR(30) | |||
| lineage_name | lineage_name | VARCHAR(36) | |||
| lineage_description | lineage_description | TEXT | |||
| source_created_date | source_created_date | DATE |
dim_ch_trainer7 fields| 論理名 | 物理名 | データ型 | データ種別 | レコード種別 | JVData項目名 |
|---|---|---|---|---|---|
| 調教師ID | trainer_id | BIGINT | |||
| 調教師コード | trainer_cd | CHAR(5) | DIFN | CH | 調教師コード |
| 調教師名 | trainer_name | VARCHAR(34) | DIFN | CH | 調教師名 |
| 生年月日 | birth_date | DATE | DIFN | CH | 生年月日 |
| 調教師免許交付年月日 | license_issued_date | DATE | DIFN | CH | 調教師免許交付年月日 |
| 性別区分 | sex_cd | CHAR(1) | DIFN | CH | 性別区分 |
| affiliation_cd | affiliation_cd | CHAR(1) |
dim_cs_course_layout5 fields| 論理名 | 物理名 | データ型 | データ種別 | レコード種別 | JVData項目名 |
|---|---|---|---|---|---|
| コース構成ID | course_layout_id | BIGINT | |||
| 競馬場コード | racecourse_cd | CHAR(2) | COMM | CS | 競馬場コード |
| 距離 | distance_m | SMALLINT UNSIGNED | COMM | CS | 距離 |
| トラックコード | track_cd | CHAR(2) | COMM | CS | トラックコード |
| コース改修年月日 | renovated_date | DATE | COMM | CS | コース改修年月日 |
dim_hn_breeding_horse13 fields| 論理名 | 物理名 | データ型 | データ種別 | レコード種別 | JVData項目名 |
|---|---|---|---|---|---|
| 繁殖馬ID | breeding_horse_id | BIGINT | |||
| 繁殖登録番号 | breeding_reg_no | CHAR(10) | BLDN | HN | 繁殖登録番号 |
| 血統登録番号 | horse_reg_no | CHAR(10) | BLDN | HN | 血統登録番号 |
| 馬名 | breeding_horse_name | VARCHAR(36) | BLDN | HN | 馬名 |
| 生年 | birth_year | SMALLINT UNSIGNED | BLDN | HN | 生年 |
| 性別コード | sex_cd | CHAR(1) | BLDN | HN | 性別コード |
| 品種コード | breed_cd | CHAR(1) | BLDN | HN | 品種コード |
| 毛色コード | coat_color_cd | CHAR(2) | BLDN | HN | 毛色コード |
| 繁殖馬持込区分 | import_type_cd | CHAR(1) | BLDN | HN | 繁殖馬持込区分 |
| 輸入年 | import_year | SMALLINT UNSIGNED | BLDN | HN | 輸入年 |
| 産地名 | origin_name | VARCHAR(20) | BLDN | HN | 産地名 |
| 父馬繁殖登録番号 | sire_breeding_reg_no | CHAR(10) | BLDN | HN | 父馬繁殖登録番号 |
| 母馬繁殖登録番号 | dam_breeding_reg_no | CHAR(10) | BLDN | HN | 母馬繁殖登録番号 |
dim_ks_jockey7 fields| 論理名 | 物理名 | データ型 | データ種別 | レコード種別 | JVData項目名 |
|---|---|---|---|---|---|
| 騎手ID | jockey_id | BIGINT | |||
| 騎手コード | jockey_cd | CHAR(5) | DIFN | KS | 騎手コード |
| 騎手名 | jockey_name | VARCHAR(34) | DIFN | KS | 騎手名 |
| 生年月日 | birth_date | DATE | DIFN | KS | 生年月日 |
| 騎手免許交付年月日 | license_issued_date | DATE | DIFN | KS | 騎手免許交付年月日 |
| 性別区分 | sex_cd | CHAR(1) | DIFN | KS | 性別区分 |
| affiliation_cd | affiliation_cd | CHAR(1) |
dim_sk_offspring10 fields| 論理名 | 物理名 | データ型 | データ種別 | レコード種別 | JVData項目名 |
|---|---|---|---|---|---|
| horse_reg_no | horse_reg_no | CHAR(10) | |||
| birth_date | birth_date | DATE | |||
| sex_cd | sex_cd | CHAR(1) | |||
| breed_cd | breed_cd | CHAR(1) | |||
| coat_color_cd | coat_color_cd | CHAR(2) | |||
| import_type_cd | import_type_cd | CHAR(1) | |||
| import_year | import_year | SMALLINT UNSIGNED | |||
| breeder_cd | breeder_cd | CHAR(8) | |||
| origin_name | origin_name | VARCHAR(20) | |||
| source_created_date | source_created_date | DATE |
dim_sk_offspring_ancestor3 fields| 論理名 | 物理名 | データ型 | データ種別 | レコード種別 | JVData項目名 |
|---|---|---|---|---|---|
| horse_reg_no | horse_reg_no | CHAR(10) | |||
| ancestor_slot | ancestor_slot | TINYINT UNSIGNED | |||
| breeding_reg_no | breeding_reg_no | CHAR(10) |
dim_um_horse4 fields| 論理名 | 物理名 | データ型 | データ種別 | レコード種別 | JVData項目名 |
|---|---|---|---|---|---|
| 競走馬ID | horse_id | BIGINT | |||
| 血統登録番号 | horse_reg_no | CHAR(10) | DIFN | UM | 血統登録番号 |
| 馬名 | horse_name | VARCHAR(36) | DIFN | UM | 馬名 |
| 生年月日 | birth_date | DATE | DIFN | UM | 生年月日 |
dim_ys_schedule8 fields| 論理名 | 物理名 | データ型 | データ種別 | レコード種別 | JVData項目名 |
|---|---|---|---|---|---|
| スケジュールID | schedule_id | BIGINT | |||
| 開催年 | schedule_year | SMALLINT UNSIGNED | YSCH | YS | 開催年 |
| 開催日 | race_date | DATE | YSCH | YS | 受け入れたYSレコードの開催年 + 開催月日(代替開催時は新しい開催日) |
| 競馬場コード | racecourse_cd | CHAR(2) | YSCH | YS | 競馬場コード |
| 開催回 | meeting_no | TINYINT UNSIGNED | YSCH | YS | 開催回 |
| 開催日目 | schedule_day_no | TINYINT UNSIGNED | YSCH | YS | 開催日目 |
| 開催状態コード | schedule_status_cd | TINYINT UNSIGNED | YSCH | YS | データ区分から派生 |
| 開催中止フラグ | is_cancelled | TINYINT(1) | YSCH | YS | 同一開催日のデータ区分9から派生。代替開催日の通常データは旧開催日の中止情報より優先 |
aux_av_prerace_race_horse_status7 fields| 論理名 | 物理名 | データ型 | データ種別 | レコード種別 | JVData項目名 |
|---|---|---|---|---|---|
| 速報出走状態ID | av_prerace_race_horse_status_id | BIGINT | |||
| レースID | race_id | BIGINT | |||
| 出走馬ID | race_horse_id | BIGINT | |||
| 馬番 | horse_no | TINYINT UNSIGNED | 0B14 | AV | 馬番 |
| 発表日時 | announced_at | DATETIME | 0B14 | AV | 発表月日時分 |
| 異常区分コード | abnormality_cd | CHAR(1) | 0B14 | AV | データ区分 |
| 異常事由コード | abnormality_reason_cd | CHAR(3) | 0B14 | AV | 事由区分 |
aux_cc_prerace_course_change5 fields| 論理名 | 物理名 | データ型 | データ種別 | レコード種別 | JVData項目名 |
|---|---|---|---|---|---|
| 速報コース変更ID | cc_prerace_course_change_id | BIGINT | |||
| レースID | race_id | BIGINT | |||
| 発表日時 | announced_at | DATETIME | 0B14 | CC | 発表月日時分 |
| 変更後距離 | distance_m | SMALLINT UNSIGNED | 0B14 | CC | 変更後情報の距離 |
| 変更後トラックコード | track_cd | CHAR(2) | 0B14 | CC | 変更後情報のトラックコード |
aux_ck_horse9 fields| 論理名 | 物理名 | データ型 | データ種別 | レコード種別 | JVData項目名 |
|---|---|---|---|---|---|
| 競走馬CK ID | ck_horse_id | BIGINT | |||
| 出走馬ID | race_horse_id | BIGINT | |||
| 平地本賞金累計 | flat_main_prize_yen | BIGINT UNSIGNED | SNPN | CK | 平地本賞金累計 |
| 障害本賞金累計 | jump_main_prize_yen | BIGINT UNSIGNED | SNPN | CK | 障害本賞金累計 |
| 平地付加賞金累計 | flat_added_prize_yen | BIGINT UNSIGNED | SNPN | CK | 平地付加賞金累計 |
| 障害付加賞金累計 | jump_added_prize_yen | BIGINT UNSIGNED | SNPN | CK | 障害付加賞金累計 |
| 平地収得賞金累計 | flat_earned_prize_yen | BIGINT UNSIGNED | SNPN | CK | 平地収得賞金累計 |
| 障害収得賞金累計 | jump_earned_prize_yen | BIGINT UNSIGNED | SNPN | CK | 障害収得賞金累計 |
| 登録レース数 | registered_race_count | SMALLINT UNSIGNED | SNPN | CK | 登録レース数 |
aux_ck_horse_finish10 fields| 論理名 | 物理名 | データ型 | データ種別 | レコード種別 | JVData項目名 |
|---|---|---|---|---|---|
| 競走馬着度数ID | ck_horse_finish_count_id | BIGINT | |||
| 競走馬CK ID | ck_horse_id | BIGINT | |||
| 着度数分類コード | finish_count_category_cd | VARCHAR(32) | |||
| 着度数条件コード | finish_count_condition_cd | VARCHAR(32) | |||
| 1着回数 | first_count | SMALLINT UNSIGNED | SNPN | CK | 1着回数 |
| 2着回数 | second_count | SMALLINT UNSIGNED | SNPN | CK | 2着回数 |
| 3着回数 | third_count | SMALLINT UNSIGNED | SNPN | CK | 3着回数 |
| 4着回数 | fourth_count | SMALLINT UNSIGNED | SNPN | CK | 4着回数 |
| 5着回数 | fifth_count | SMALLINT UNSIGNED | SNPN | CK | 5着回数 |
| 着外回数 | other_count | SMALLINT UNSIGNED | SNPN | CK | 着外回数 |
aux_ck_horse_style6 fields| 論理名 | 物理名 | データ型 | データ種別 | レコード種別 | JVData項目名 |
|---|---|---|---|---|---|
| 競走馬脚質傾向ID | ck_horse_running_style_id | BIGINT | |||
| 競走馬CK ID | ck_horse_id | BIGINT | |||
| 逃げ回数 | nige_count | SMALLINT UNSIGNED | SNPN | CK | 逃げ回数 |
| 先行回数 | senko_count | SMALLINT UNSIGNED | SNPN | CK | 先行回数 |
| 差し回数 | sashi_count | SMALLINT UNSIGNED | SNPN | CK | 差し回数 |
| 追込回数 | oikomi_count | SMALLINT UNSIGNED | SNPN | CK | 追込回数 |
aux_ck_jockey9 fields| 論理名 | 物理名 | データ型 | データ種別 | レコード種別 | JVData項目名 |
|---|---|---|---|---|---|
| 騎手CK ID | ck_jockey_id | BIGINT | |||
| 騎手ID | jockey_id | BIGINT | |||
| 取得元出走馬ID | source_race_horse_id | BIGINT | |||
| 集計範囲コード | stats_scope_cd | TINYINT UNSIGNED | |||
| 設定年 | stats_year | SMALLINT UNSIGNED | SNPN | CK | 設定年 |
| 平地本賞金合計 | flat_main_prize_yen | BIGINT UNSIGNED | SNPN | CK | 平地本賞金合計 |
| 障害本賞金合計 | jump_main_prize_yen | BIGINT UNSIGNED | SNPN | CK | 障害本賞金合計 |
| 平地付加賞金合計 | flat_added_prize_yen | BIGINT UNSIGNED | SNPN | CK | 平地付加賞金合計 |
| 障害付加賞金合計 | jump_added_prize_yen | BIGINT UNSIGNED | SNPN | CK | 障害付加賞金合計 |
aux_ck_jockey_finish10 fields| 論理名 | 物理名 | データ型 | データ種別 | レコード種別 | JVData項目名 |
|---|---|---|---|---|---|
| 騎手着度数ID | ck_jockey_finish_count_id | BIGINT | |||
| 騎手CK ID | ck_jockey_id | BIGINT | |||
| 着度数分類コード | finish_count_category_cd | VARCHAR(32) | |||
| 着度数条件コード | finish_count_condition_cd | VARCHAR(32) | |||
| 1着回数 | first_count | MEDIUMINT UNSIGNED | SNPN | CK | 1着回数 |
| 2着回数 | second_count | MEDIUMINT UNSIGNED | SNPN | CK | 2着回数 |
| 3着回数 | third_count | MEDIUMINT UNSIGNED | SNPN | CK | 3着回数 |
| 4着回数 | fourth_count | MEDIUMINT UNSIGNED | SNPN | CK | 4着回数 |
| 5着回数 | fifth_count | MEDIUMINT UNSIGNED | SNPN | CK | 5着回数 |
| 着外回数 | other_count | MEDIUMINT UNSIGNED | SNPN | CK | 着外回数 |
aux_ck_trainer9 fields| 論理名 | 物理名 | データ型 | データ種別 | レコード種別 | JVData項目名 |
|---|---|---|---|---|---|
| 調教師CK ID | ck_trainer_id | BIGINT | |||
| 調教師ID | trainer_id | BIGINT | |||
| 取得元出走馬ID | source_race_horse_id | BIGINT | |||
| 集計範囲コード | stats_scope_cd | TINYINT UNSIGNED | |||
| 設定年 | stats_year | SMALLINT UNSIGNED | SNPN | CK | 設定年 |
| 平地本賞金合計 | flat_main_prize_yen | BIGINT UNSIGNED | SNPN | CK | 平地本賞金合計 |
| 障害本賞金合計 | jump_main_prize_yen | BIGINT UNSIGNED | SNPN | CK | 障害本賞金合計 |
| 平地付加賞金合計 | flat_added_prize_yen | BIGINT UNSIGNED | SNPN | CK | 平地付加賞金合計 |
| 障害付加賞金合計 | jump_added_prize_yen | BIGINT UNSIGNED | SNPN | CK | 障害付加賞金合計 |
aux_ck_trainer_finish10 fields| 論理名 | 物理名 | データ型 | データ種別 | レコード種別 | JVData項目名 |
|---|---|---|---|---|---|
| 調教師着度数ID | ck_trainer_finish_count_id | BIGINT | |||
| 調教師CK ID | ck_trainer_id | BIGINT | |||
| 着度数分類コード | finish_count_category_cd | VARCHAR(32) | |||
| 着度数条件コード | finish_count_condition_cd | VARCHAR(32) | |||
| 1着回数 | first_count | MEDIUMINT UNSIGNED | SNPN | CK | 1着回数 |
| 2着回数 | second_count | MEDIUMINT UNSIGNED | SNPN | CK | 2着回数 |
| 3着回数 | third_count | MEDIUMINT UNSIGNED | SNPN | CK | 3着回数 |
| 4着回数 | fourth_count | MEDIUMINT UNSIGNED | SNPN | CK | 4着回数 |
| 5着回数 | fifth_count | MEDIUMINT UNSIGNED | SNPN | CK | 5着回数 |
| 着外回数 | other_count | MEDIUMINT UNSIGNED | SNPN | CK | 着外回数 |
aux_dm_mining9 fields| 論理名 | 物理名 | データ型 | データ種別 | レコード種別 | JVData項目名 |
|---|---|---|---|---|---|
| 予想タイム指数ID | dm_mining_id | BIGINT | |||
| レースID | race_id | BIGINT | |||
| 馬番 | horse_no | TINYINT UNSIGNED | MING/0B13 | DM | 馬番 |
| 出走馬ID | race_horse_id | BIGINT | |||
| マイニング区分 | mining_bunrui_cd | TINYINT UNSIGNED | |||
| データ作成時分 | data_creation_time | TIME | MING/0B13 | DM | データ作成時分 |
| 予想走破タイム | predicted_finish_time_sec | DECIMAL(5,2) | MING/0B13 | DM | 予想走破タイム |
| 予想誤差(信頼度)+ | predicted_error_plus_sec | DECIMAL(4,2) | MING/0B13 | DM | 予想誤差(信頼度)+ |
| 予想誤差(信頼度)- | predicted_error_minus_sec | DECIMAL(4,2) | MING/0B13 | DM | 予想誤差(信頼度)- |
aux_hc_training11 fields| 論理名 | 物理名 | データ型 | データ種別 | レコード種別 | JVData項目名 |
|---|---|---|---|---|---|
| 坂路調教ID | hc_training_id | BIGINT | |||
| 血統登録番号 | horse_reg_no | CHAR(10) | SLOP | HC | 血統登録番号 |
| トレセン区分 | training_center_cd | CHAR(1) | SLOP | HC | トレセン区分 |
| 調教日時 | training_datetime | DATETIME | SLOP | HC | 調教日時 |
| 4ハロンタイム合計(800M~0M) | total_4f_sec | DECIMAL(4,1) | SLOP | HC | 4ハロンタイム合計(800M~0M) |
| ラップタイム(800M~600M) | lap_800_600_sec | DECIMAL(3,1) | SLOP | HC | ラップタイム(800M~600M) |
| 3ハロンタイム合計(600M~0M) | total_3f_sec | DECIMAL(4,1) | SLOP | HC | 3ハロンタイム合計(600M~0M) |
| ラップタイム(600M~400M) | lap_600_400_sec | DECIMAL(3,1) | SLOP | HC | ラップタイム(600M~400M) |
| 2ハロンタイム合計(400M~0M) | total_2f_sec | DECIMAL(4,1) | SLOP | HC | 2ハロンタイム合計(400M~0M) |
| ラップタイム(400M~200M) | lap_400_200_sec | DECIMAL(3,1) | SLOP | HC | ラップタイム(400M~200M) |
| ラップタイム(200M~0M) | lap_200_0_sec | DECIMAL(3,1) | SLOP | HC | ラップタイム(200M~0M) |
aux_hr_payout_detail9 fields| 論理名 | 物理名 | データ型 | データ種別 | レコード種別 | JVData項目名 |
|---|---|---|---|---|---|
| 払戻明細ID | hr_payout_detail_id | BIGINT | |||
| 払戻ヘッダID | hr_payout_header_id | BIGINT | |||
| 払戻配列内連番 | payout_seq_no | TINYINT UNSIGNED | RACE | HR | 払戻配列内連番 |
| 組番 | selection_key | CHAR(6) | RACE | HR | 組番 |
| 選択番号1 | selection_no_1 | TINYINT UNSIGNED | RACE | HR | 選択番号1 |
| 選択番号2 | selection_no_2 | TINYINT UNSIGNED | RACE | HR | 選択番号2 |
| 選択番号3 | selection_no_3 | TINYINT UNSIGNED | RACE | HR | 選択番号3 |
| 払戻金 | payout_amount_yen | BIGINT UNSIGNED | RACE | HR | 払戻金 |
| 人気順 | popularity_rank | SMALLINT UNSIGNED | RACE | HR | 人気順 |
aux_hr_payout_header6 fields| 論理名 | 物理名 | データ型 | データ種別 | レコード種別 | JVData項目名 |
|---|---|---|---|---|---|
| 払戻ヘッダID | hr_payout_header_id | BIGINT | |||
| レースID | race_id | BIGINT | |||
| 賭式コード | bet_type_cd | CHAR(2) | |||
| 不成立フラグ | is_invalid | TINYINT(1) | RACE | HR | 不成立フラグ |
| 特払フラグ | is_special_payout | TINYINT(1) | RACE | HR | 特払フラグ |
| 返還フラグ | has_refund | TINYINT(1) | RACE | HR | 返還フラグ |
aux_hr_realtime_payout_detail9 fields| 論理名 | 物理名 | データ型 | データ種別 | レコード種別 | JVData項目名 |
|---|---|---|---|---|---|
| 速報払戻明細ID | hr_realtime_payout_detail_id | BIGINT | |||
| 速報払戻ヘッダID | hr_realtime_payout_header_id | BIGINT | |||
| 払戻配列内連番 | payout_seq_no | TINYINT UNSIGNED | 0B12 | HR | 払戻配列内連番 |
| 組番 | selection_key | CHAR(6) | 0B12 | HR | 組番 |
| 選択番号1 | selection_no_1 | TINYINT UNSIGNED | 0B12 | HR | 選択番号1 |
| 選択番号2 | selection_no_2 | TINYINT UNSIGNED | 0B12 | HR | 選択番号2 |
| 選択番号3 | selection_no_3 | TINYINT UNSIGNED | 0B12 | HR | 選択番号3 |
| 払戻金 | payout_amount_yen | BIGINT UNSIGNED | 0B12 | HR | 払戻金 |
| 人気順 | popularity_rank | SMALLINT UNSIGNED | 0B12 | HR | 人気順 |
aux_hr_realtime_payout_header8 fields| 論理名 | 物理名 | データ型 | データ種別 | レコード種別 | JVData項目名 |
|---|---|---|---|---|---|
| 速報払戻ヘッダID | hr_realtime_payout_header_id | BIGINT | |||
| レースID | race_id | BIGINT | |||
| 賭式コード | bet_type_cd | CHAR(2) | 0B12 | HR | 賭式 |
| データ区分 | data_kubun_cd | CHAR(1) | 0B12 | HR | データ区分 |
| 観測日時 | observed_at | DATETIME | |||
| 不成立フラグ | is_invalid | TINYINT(1) | 0B12 | HR | 不成立フラグ |
| 特払フラグ | is_special_payout | TINYINT(1) | 0B12 | HR | 特払フラグ |
| 返還フラグ | has_refund | TINYINT(1) | 0B12 | HR | 返還フラグ |
aux_jc_prerace_jockey_change8 fields| 論理名 | 物理名 | データ型 | データ種別 | レコード種別 | JVData項目名 |
|---|---|---|---|---|---|
| 速報騎手変更ID | jc_prerace_jockey_change_id | BIGINT | |||
| レースID | race_id | BIGINT | |||
| 出走馬ID | race_horse_id | BIGINT | |||
| 馬番 | horse_no | TINYINT UNSIGNED | 0B14 | JC | 馬番 |
| 発表日時 | announced_at | DATETIME | 0B14 | JC | 発表月日時分 |
| 変更後負担重量 | carried_weight_kg | DECIMAL(4,1) | 0B14 | JC | 変更後情報の負担重量 |
| 変更後騎手コード | jockey_cd | CHAR(5) | 0B14 | JC | 変更後情報の騎手コード |
| 変更後見習コード | apprentice_cd | CHAR(1) | 0B14 | JC | 変更後情報の騎手見習コード |
aux_o1o6_odds_detail11 fields| 論理名 | 物理名 | データ型 | データ種別 | レコード種別 | JVData項目名 |
|---|---|---|---|---|---|
| 確定オッズ明細ID | o1o6_odds_detail_id | BIGINT | |||
| 確定オッズヘッダID | o1o6_odds_header_id | BIGINT | |||
| 組番 | selection_key | CHAR(6) | RACE | O1-O6 | 組番 |
| 選択番号1 | selection_no_1 | TINYINT UNSIGNED | RACE | O1-O6 | 選択番号1 |
| 選択番号2 | selection_no_2 | TINYINT UNSIGNED | RACE | O1-O6 | 選択番号2 |
| 選択番号3 | selection_no_3 | TINYINT UNSIGNED | RACE | O1-O6 | 選択番号3 |
| 通常オッズ | odds_value | DECIMAL(7,1) | RACE | O1-O6 | 通常オッズ |
| 最低オッズ | odds_min | DECIMAL(7,1) | RACE | O1/O3 | 最低オッズ |
| 最高オッズ | odds_max | DECIMAL(7,1) | RACE | O1/O3 | 最高オッズ |
| 人気順 | popularity_rank | SMALLINT UNSIGNED | RACE | O1-O6 | 人気順 |
| オッズ状態コード | odds_status_cd | CHAR(1) |
aux_o1o6_odds_header3 fields| 論理名 | 物理名 | データ型 | データ種別 | レコード種別 | JVData項目名 |
|---|---|---|---|---|---|
| 確定オッズヘッダID | o1o6_odds_header_id | BIGINT | |||
| レースID | race_id | BIGINT | |||
| 賭式コード | bet_type_cd | CHAR(2) |
aux_o1o6_prerace_odds_detail11 fields| 論理名 | 物理名 | データ型 | データ種別 | レコード種別 | JVData項目名 |
|---|---|---|---|---|---|
| 速報オッズ明細ID | o1o6_prerace_odds_detail_id | BIGINT | |||
| 速報オッズヘッダID | o1o6_prerace_odds_header_id | BIGINT | |||
| 組番 | selection_key | CHAR(6) | 0B30 | O1-O6 | 組番 |
| 選択番号1 | selection_no_1 | TINYINT UNSIGNED | 0B30 | O1-O6 | 選択番号1 |
| 選択番号2 | selection_no_2 | TINYINT UNSIGNED | 0B30 | O1-O6 | 選択番号2 |
| 選択番号3 | selection_no_3 | TINYINT UNSIGNED | 0B30 | O1-O6 | 選択番号3 |
| 通常オッズ | odds_value | DECIMAL(7,1) | 0B30 | O1-O6 | 通常オッズ |
| 最低オッズ | odds_min | DECIMAL(7,1) | 0B30 | O1/O3 | 最低オッズ |
| 最高オッズ | odds_max | DECIMAL(7,1) | 0B30 | O1/O3 | 最高オッズ |
| 人気順 | popularity_rank | SMALLINT UNSIGNED | 0B30 | O1-O6 | 人気順 |
| オッズ状態コード | odds_status_cd | CHAR(1) |
aux_o1o6_prerace_odds_header5 fields| 論理名 | 物理名 | データ型 | データ種別 | レコード種別 | JVData項目名 |
|---|---|---|---|---|---|
| 速報オッズヘッダID | o1o6_prerace_odds_header_id | BIGINT | |||
| レースID | race_id | BIGINT | 0B30 | O1-O6 | レースキー |
| 賭式コード | bet_type_cd | CHAR(2) | |||
| データ区分 | data_kubun_cd | CHAR(1) | 0B30 | O1-O6 | データ区分 |
| 発表日時 | announced_at | DATETIME | 0B30 | O1-O6 | 発表月日時分 |
aux_ra_race_pace23 fields| 論理名 | 物理名 | データ型 | データ種別 | レコード種別 | JVData項目名 |
|---|---|---|---|---|---|
| race_id | race_id | BIGINT | |||
| classification_status_cd | classification_status_cd | VARCHAR(20) | |||
| pace_label | pace_label | VARCHAR(12) | |||
| feature_id | feature_id | VARCHAR(64) | |||
| feature_value_sec | feature_value_sec | DECIMAL(38,28) | |||
| feature_value_text | feature_value_text | VARCHAR(80) | |||
| interpolated_flag | interpolated_flag | TINYINT(1) | |||
| applied_rule_id | applied_rule_id | VARCHAR(80) | |||
| fallback_route_json | fallback_route_json | JSON | |||
| lower_threshold_sec | lower_threshold_sec | DECIMAL(38,28) | |||
| upper_threshold_sec | upper_threshold_sec | DECIMAL(38,28) | |||
| not_classifiable_reason_cd | not_classifiable_reason_cd | VARCHAR(64) | |||
| diagnostic_json | diagnostic_json | JSON | |||
| model_id | model_id | CHAR(64) | |||
| model_sha256 | model_sha256 | CHAR(64) | |||
| manifest_sha256 | manifest_sha256 | CHAR(64) | |||
| code_tables_sha256 | code_tables_sha256 | CHAR(64) | |||
| source_fingerprint | source_fingerprint | CHAR(64) | |||
| business_value_sha256 | business_value_sha256 | CHAR(64) | |||
| pace_job_id | pace_job_id | BIGINT | |||
| calculated_at | calculated_at | DATETIME(6) | |||
| created_at | created_at | DATETIME(6) | |||
| updated_at | updated_at | DATETIME(6) |
aux_ra_race_pace_prediction20 fields| 論理名 | 物理名 | データ型 | データ種別 | レコード種別 | JVData項目名 |
|---|---|---|---|---|---|
| race_id | race_id | BIGINT | |||
| status | status | VARCHAR(20) | |||
| pace_label | pace_label | VARCHAR(12) | |||
| confidence_label | confidence_label | VARCHAR(4) | |||
| base_confidence_label | base_confidence_label | VARCHAR(4) | |||
| rule_id | rule_id | VARCHAR(40) | |||
| model_id | model_id | CHAR(64) | |||
| feature_id | feature_id | CHAR(64) | |||
| confidence_id | confidence_id | CHAR(64) | |||
| manifest_sha256 | manifest_sha256 | CHAR(64) | |||
| source_fingerprint | source_fingerprint | CHAR(64) | |||
| scores_json | scores_json | JSON | |||
| evidence_json | evidence_json | JSON | |||
| feature_snapshot_json | feature_snapshot_json | JSON | |||
| race_date | race_date | DATE | |||
| scheduled_start_time | scheduled_start_time | TIME | |||
| predicted_at | predicted_at | DATETIME(6) | |||
| reason_cd | reason_cd | VARCHAR(128) | |||
| created_at | created_at | DATETIME(6) | |||
| updated_at | updated_at | DATETIME(6) |
aux_ra_realtime_race_corner5 fields| 論理名 | 物理名 | データ型 | データ種別 | レコード種別 | JVData項目名 |
|---|---|---|---|---|---|
| レースID | race_id | BIGINT | |||
| コーナー連番 | corner_seq_no | TINYINT UNSIGNED | 0B12 | RA | 配列順 |
| コーナー番号 | corner_no | TINYINT UNSIGNED | 0B12 | RA | コーナー |
| 周回数 | lap_count | TINYINT UNSIGNED | 0B12 | RA | 周回数 |
| 通過順raw | passing_order_raw | VARCHAR(70) | 0B12 | RA | 各通過順位 |
aux_ra_realtime_race_lap4 fields| 論理名 | 物理名 | データ型 | データ種別 | レコード種別 | JVData項目名 |
|---|---|---|---|---|---|
| レースID | race_id | BIGINT | |||
| ラップ連番 | lap_no | TINYINT UNSIGNED | 0B12 | RA | 配列順 |
| 区間距離 | lap_distance_m | SMALLINT UNSIGNED | 0B12 | RA | 区間距離 |
| ラップタイム | lap_time_sec | DECIMAL(4,1) | 0B12 | RA | ラップタイム |
aux_ra_realtime_race_result12 fields| 論理名 | 物理名 | データ型 | データ種別 | レコード種別 | JVData項目名 |
|---|---|---|---|---|---|
| レースID | race_id | BIGINT | |||
| データ区分 | data_kubun_cd | CHAR(1) | 0B12 | RA | データ区分 |
| 観測日時 | observed_at | DATETIME | |||
| 出走頭数 | starter_count | TINYINT UNSIGNED | 0B12 | RA | 出走頭数 |
| 入線頭数 | finisher_count | TINYINT UNSIGNED | 0B12 | RA | 入線頭数 |
| 天候コード | weather_cd | CHAR(1) | 0B12 | RA | 天候コード |
| 芝馬場状態コード | turf_condition_cd | CHAR(1) | 0B12 | RA | 芝馬場状態コード |
| ダート馬場状態コード | dirt_condition_cd | CHAR(1) | 0B12 | RA | ダート馬場状態コード |
| 前3ハロン | first_3f_sec | DECIMAL(4,1) | 0B12 | RA | 前3ハロン |
| 前4ハロン | first_4f_sec | DECIMAL(4,1) | 0B12 | RA | 前4ハロン |
| 後3ハロン | last_3f_sec | DECIMAL(4,1) | 0B12 | RA | 後3ハロン |
| 後4ハロン | last_4f_sec | DECIMAL(4,1) | 0B12 | RA | 後4ハロン |
aux_se_realtime_race_horse_result29 fields| 論理名 | 物理名 | データ型 | データ種別 | レコード種別 | JVData項目名 |
|---|---|---|---|---|---|
| 出走馬ID | race_horse_id | BIGINT | |||
| レースID | race_id | BIGINT | |||
| 馬番 | horse_no | TINYINT UNSIGNED | 0B12 | SE | 馬番 |
| データ区分 | data_kubun_cd | CHAR(1) | 0B12 | SE | データ区分 |
| 観測日時 | observed_at | DATETIME | |||
| 馬体重 | body_weight_kg | SMALLINT UNSIGNED | 0B12 | SE | 馬体重 |
| 斤量負担率(百分率、小数第3位以降切り捨て) | carried_weight_ratio_pct | DECIMAL(4,2) | |||
| 馬体重増減 | body_weight_diff_kg | SMALLINT | 0B12 | SE | 増減符号 + 増減差 |
| 異常区分コード | abnormality_cd | CHAR(1) | 0B12 | SE | 異常区分コード |
| 入線順位 | arrival_order | TINYINT UNSIGNED | 0B12 | SE | 入線順位 |
| 確定着順 | finish_order | TINYINT UNSIGNED | 0B12 | SE | 確定着順 |
| 同着区分 | is_dead_heat | TINYINT(1) | 0B12 | SE | 同着区分 |
| 同着頭数 | dead_heat_count_other | TINYINT UNSIGNED | 0B12 | SE | 同着頭数 |
| 走破タイム | finish_time_sec | DECIMAL(5,1) | 0B12 | SE | 走破タイム |
| 着差コード | margin_cd | CHAR(3) | 0B12 | SE | 着差コード |
| 着差コード秒換算 | margin_sec | DECIMAL(5,2) | 0B12 | SE | 定義済みの着差コードを秒換算。未定義形式はNULL |
| +着差コード | margin_plus_cd | CHAR(3) | 0B12 | SE | +着差コード |
| +着差コード秒換算 | margin_plus_sec | DECIMAL(5,2) | 0B12 | SE | 着差コードと同じ規則で秒換算。未定義形式はNULL |
| ++着差コード | margin_plus_plus_cd | CHAR(3) | 0B12 | SE | ++着差コード |
| ++着差コード秒換算 | margin_plus_plus_sec | DECIMAL(5,2) | 0B12 | SE | 着差コードと同じ規則で秒換算。未定義形式はNULL |
| 1コーナー順位 | corner1_order | TINYINT UNSIGNED | 0B12 | SE | 1コーナー順位 |
| 2コーナー順位 | corner2_order | TINYINT UNSIGNED | 0B12 | SE | 2コーナー順位 |
| 3コーナー順位 | corner3_order | TINYINT UNSIGNED | 0B12 | SE | 3コーナー順位 |
| 4コーナー順位 | corner4_order | TINYINT UNSIGNED | 0B12 | SE | 4コーナー順位 |
| 後4ハロンタイム | last_4f_sec | DECIMAL(4,1) | 0B12 | SE | 後4ハロンタイム |
| 後3ハロンタイム | last_3f_sec | DECIMAL(4,1) | 0B12 | SE | 後3ハロンタイム |
| 同一平地レース内の後3ハロン競技順位 | last_3f_rank | TINYINT UNSIGNED | |||
| タイム差 | time_diff_sec | DECIMAL(5,1) | 0B12 | SE | タイム差 |
| 脚質判定コード | running_style_cd | CHAR(1) | 0B12 | SE | 脚質判定コード |
aux_tc_prerace_start_time_change4 fields| 論理名 | 物理名 | データ型 | データ種別 | レコード種別 | JVData項目名 |
|---|---|---|---|---|---|
| 速報発走時刻変更ID | tc_prerace_start_time_change_id | BIGINT | |||
| レースID | race_id | BIGINT | |||
| 発表日時 | announced_at | DATETIME | 0B14 | TC | 発表月日時分 |
| 変更後発走時刻 | scheduled_start_time | TIME | 0B14 | TC | 変更後情報の発走時刻 |
aux_tm_mining7 fields| 論理名 | 物理名 | データ型 | データ種別 | レコード種別 | JVData項目名 |
|---|---|---|---|---|---|
| 対戦型マイニングID | tm_mining_id | BIGINT | |||
| レースID | race_id | BIGINT | |||
| 馬番 | horse_no | TINYINT UNSIGNED | MING/0B17 | TM | 馬番 |
| 出走馬ID | race_horse_id | BIGINT | |||
| マイニング区分 | mining_bunrui_cd | TINYINT UNSIGNED | |||
| データ作成時分 | data_creation_time | TIME | MING/0B17 | TM | データ作成時分 |
| 予測スコア | predicted_score | DECIMAL(4,1) | MING/0B17 | TM | 予測スコア |
aux_um_horse_finish8 fields| 論理名 | 物理名 | データ型 | データ種別 | レコード種別 | JVData項目名 |
|---|---|---|---|---|---|
| horse_reg_no | horse_reg_no | CHAR(10) | |||
| condition_cd | condition_cd | VARCHAR(32) | |||
| first_count | first_count | SMALLINT UNSIGNED | |||
| second_count | second_count | SMALLINT UNSIGNED | |||
| third_count | third_count | SMALLINT UNSIGNED | |||
| fourth_count | fourth_count | SMALLINT UNSIGNED | |||
| fifth_count | fifth_count | SMALLINT UNSIGNED | |||
| other_count | other_count | SMALLINT UNSIGNED |
aux_um_horse_profile6 fields| 論理名 | 物理名 | データ型 | データ種別 | レコード種別 | JVData項目名 |
|---|---|---|---|---|---|
| horse_reg_no | horse_reg_no | CHAR(10) | |||
| source_created_date | source_created_date | DATE | |||
| observed_at | observed_at | DATETIME | |||
| source_priority | source_priority | TINYINT UNSIGNED | |||
| revision | revision | BIGINT UNSIGNED | |||
| profile_json | profile_json | JSON |
aux_wc_training25 fields| 論理名 | 物理名 | データ型 | データ種別 | レコード種別 | JVData項目名 |
|---|---|---|---|---|---|
| ウッドチップ調教ID | wc_training_id | BIGINT | |||
| 血統登録番号 | horse_reg_no | CHAR(10) | WOOD | WC | 血統登録番号 |
| トレセン区分 | training_center_cd | CHAR(1) | WOOD | WC | トレセン区分 |
| 調教日時 | training_datetime | DATETIME | WOOD | WC | 調教日時 |
| コース | course_cd | CHAR(1) | WOOD | WC | コース |
| 馬場周り | direction_cd | CHAR(1) | WOOD | WC | 馬場周り |
| 10ハロンタイム合計(2000M~0M) | total_10f_sec | DECIMAL(4,1) | WOOD | WC | 10ハロンタイム合計(2000M~0M) |
| ラップタイム(2000M~1800M) | lap_2000_1800_sec | DECIMAL(3,1) | WOOD | WC | ラップタイム(2000M~1800M) |
| 9ハロンタイム合計(1800M~0M) | total_9f_sec | DECIMAL(4,1) | WOOD | WC | 9ハロンタイム合計(1800M~0M) |
| ラップタイム(1800M~1600M) | lap_1800_1600_sec | DECIMAL(3,1) | WOOD | WC | ラップタイム(1800M~1600M) |
| 8ハロンタイム合計(1600M~0M) | total_8f_sec | DECIMAL(4,1) | WOOD | WC | 8ハロンタイム合計(1600M~0M) |
| ラップタイム(1600M~1400M) | lap_1600_1400_sec | DECIMAL(3,1) | WOOD | WC | ラップタイム(1600M~1400M) |
| 7ハロンタイム合計(1400M~0M) | total_7f_sec | DECIMAL(4,1) | WOOD | WC | 7ハロンタイム合計(1400M~0M) |
| ラップタイム(1400M~1200M) | lap_1400_1200_sec | DECIMAL(3,1) | WOOD | WC | ラップタイム(1400M~1200M) |
| 6ハロンタイム合計(1200M~0M) | total_6f_sec | DECIMAL(4,1) | WOOD | WC | 6ハロンタイム合計(1200M~0M) |
| ラップタイム(1200M~1000M) | lap_1200_1000_sec | DECIMAL(3,1) | WOOD | WC | ラップタイム(1200M~1000M) |
| 5ハロンタイム合計(1000M~0M) | total_5f_sec | DECIMAL(4,1) | WOOD | WC | 5ハロンタイム合計(1000M~0M) |
| ラップタイム(1000M~800M) | lap_1000_800_sec | DECIMAL(3,1) | WOOD | WC | ラップタイム(1000M~800M) |
| 4ハロンタイム合計(800M~0M) | total_4f_sec | DECIMAL(4,1) | WOOD | WC | 4ハロンタイム合計(800M~0M) |
| ラップタイム(800M~600M) | lap_800_600_sec | DECIMAL(3,1) | WOOD | WC | ラップタイム(800M~600M) |
| 3ハロンタイム合計(600M~0M) | total_3f_sec | DECIMAL(4,1) | WOOD | WC | 3ハロンタイム合計(600M~0M) |
| ラップタイム(600M~400M) | lap_600_400_sec | DECIMAL(3,1) | WOOD | WC | ラップタイム(600M~400M) |
| 2ハロンタイム合計(400M~0M) | total_2f_sec | DECIMAL(4,1) | WOOD | WC | 2ハロンタイム合計(400M~0M) |
| ラップタイム(400M~200M) | lap_400_200_sec | DECIMAL(3,1) | WOOD | WC | ラップタイム(400M~200M) |
| ラップタイム(200M~0M) | lap_200_0_sec | DECIMAL(3,1) | WOOD | WC | ラップタイム(200M~0M) |
aux_we_prerace_weather_track_condition7 fields| 論理名 | 物理名 | データ型 | データ種別 | レコード種別 | JVData項目名 |
|---|---|---|---|---|---|
| 速報天候馬場ID | we_prerace_weather_track_condition_id | BIGINT | |||
| レースID | race_id | BIGINT | |||
| 天候コード | weather_cd | CHAR(1) | 0B14 | WE | 天候コード |
| 天候発表日時 | weather_announced_at | DATETIME | 0B14 | WE | 発表月日時分 |
| 芝馬場状態コード | turf_condition_cd | CHAR(1) | 0B14 | WE | 芝馬場状態コード |
| ダート馬場状態コード | dirt_condition_cd | CHAR(1) | 0B14 | WE | ダート馬場状態コード |
| 馬場発表日時 | track_condition_announced_at | DATETIME | 0B14 | WE | 発表月日時分 |
aux_wh_prerace_body_weight9 fields| 論理名 | 物理名 | データ型 | データ種別 | レコード種別 | JVData項目名 |
|---|---|---|---|---|---|
| 速報馬体重ID | wh_prerace_body_weight_id | BIGINT | |||
| レースID | race_id | BIGINT | 0B11 | WH | レースキー |
| 出走馬ID | race_horse_id | BIGINT | |||
| 馬番 | horse_no | TINYINT UNSIGNED | 0B11 | WH | 馬番 |
| 発表日時 | announced_at | DATETIME | 0B11 | WH | 発表月日時分 |
| 馬体重 | body_weight_kg | SMALLINT UNSIGNED | 0B11 | WH | 馬体重 |
| 斤量負担率(百分率、小数第3位以降切り捨て) | carried_weight_ratio_pct | DECIMAL(4,2) | |||
| 増減差 | body_weight_diff_kg | SMALLINT | 0B11 | WH | 増減差 |
| 馬体重状態コード | body_weight_status_cd | TINYINT UNSIGNED |
tav_change_queue3 fields| 論理名 | 物理名 | データ型 | データ種別 | レコード種別 | JVData項目名 |
|---|---|---|---|---|---|
| change_kind | change_kind | CHAR(1) | |||
| core_race_id | core_race_id | BIGINT | |||
| change_revision | change_revision | BIGINT |
tav_class_factor_master11 fields| 論理名 | 物理名 | データ型 | データ種別 | レコード種別 | JVData項目名 |
|---|---|---|---|---|---|
| 内部ID | class_factor_id | BIGINT UNSIGNED | |||
| 正規化サーフェス T/D | surface_cd | CHAR(1) | |||
| 距離 | kyori | INT | |||
| 年齢帯 2YO/3YO/3UP/4UP | age_group_cd | VARCHAR(8) | |||
| 正規化クラス分類 | normalized_class_cd | VARCHAR(16) | |||
| クラス補正キー surface_age_class | class_factor_key | VARCHAR(64) | |||
| クラス補正 秒 | class_factor_sec | DECIMAL(8,3) | |||
| 採用サンプル数 | sample_count | INT | |||
| 備考 | note | VARCHAR(255) | |||
| 作成日時 | created_at | DATETIME | |||
| 更新日時 | updated_at | DATETIME |
tav_course_factor_master10 fields| 論理名 | 物理名 | データ型 | データ種別 | レコード種別 | JVData項目名 |
|---|---|---|---|---|---|
| 内部ID | course_factor_id | BIGINT UNSIGNED | |||
| 競馬場コード | jyo_cd | CHAR(2) | |||
| トラックコード | track_cd | CHAR(2) | |||
| 正規化サーフェス T/D | surface_cd | CHAR(1) | |||
| 距離 | kyori | INT | |||
| コース補正 秒 | course_factor_sec | DECIMAL(8,3) | |||
| 採用サンプル数 | sample_count | INT | |||
| 備考 | note | VARCHAR(255) | |||
| 作成日時 | created_at | DATETIME | |||
| 更新日時 | updated_at | DATETIME |
tav_data_quality_issue6 fields| 論理名 | 物理名 | データ型 | データ種別 | レコード種別 | JVData項目名 |
|---|---|---|---|---|---|
| issue ID | issue_id | BIGINT UNSIGNED | |||
| race単位issueの場合のtav_race.race_id | race_id | BIGINT UNSIGNED | |||
| issue種別 | issue_type | VARCHAR(64) | |||
| 人が読む説明 | issue_message | VARCHAR(255) | |||
| 詳細文脈 | context_json | JSON | |||
| 作成日時 | created_at | DATETIME |
tav_day_variant9 fields| 論理名 | 物理名 | データ型 | データ種別 | レコード種別 | JVData項目名 |
|---|---|---|---|---|---|
| 内部ID | day_variant_id | BIGINT UNSIGNED | |||
| 開催日yyyymmdd | kaisai_date | CHAR(8) | |||
| 競馬場コード | jyo_cd | CHAR(2) | |||
| 正規化サーフェス T/D | surface_cd | CHAR(1) | |||
| 開催日馬場差 秒 | day_variant_sec | DECIMAL(8,3) | |||
| 採用サンプル数 | sample_count | INT | |||
| 備考 | note | VARCHAR(255) | |||
| 作成日時 | created_at | DATETIME | |||
| 更新日時 | updated_at | DATETIME |
tav_job_chunk16 fields| 論理名 | 物理名 | データ型 | データ種別 | レコード種別 | JVData項目名 |
|---|---|---|---|---|---|
| チャンクID | chunk_id | BIGINT UNSIGNED | |||
| 親ジョブID | job_id | BIGINT UNSIGNED | |||
| ジョブ内連番 | chunk_no | INT | |||
| 単一レース対象時 | target_race_id | BIGINT UNSIGNED | |||
| 範囲開始 yyyymmdd | target_from_date | CHAR(8) | |||
| 範囲終了 yyyymmdd | target_to_date | CHAR(8) | |||
| PENDING/RUNNING/SUCCESS/FAILED | status | VARCHAR(16) | |||
| 処理件数 | processed_count | INT | |||
| 成功件数 | success_count | INT | |||
| 警告件数 | warning_count | INT | |||
| エラー件数 | error_count | INT | |||
| 最終エラーメッセージ | error_message | TEXT | |||
| 開始日時 | started_at | DATETIME | |||
| 終了日時 | finished_at | DATETIME | |||
| 作成日時 | created_at | DATETIME | |||
| 更新日時 | updated_at | DATETIME |
tav_job_run39 fields| 論理名 | 物理名 | データ型 | データ種別 | レコード種別 | JVData項目名 |
|---|---|---|---|---|---|
| ジョブID | job_id | BIGINT UNSIGNED | |||
| RACE_ID/DATE_RANGE/RETRY_FAILED | run_mode | VARCHAR(16) | |||
| TAV計算仕様版 | calculation_version | VARCHAR(64) | |||
| 信頼度校正artifact SHA-256 | calibration_checksum | CHAR(64) | |||
| SETUP/NORMAL_UPDATE/MANUAL | trigger_type | VARCHAR(16) | |||
| JV2AI64 setup run identity; SETUP only | setup_run_id | BIGINT | |||
| normal import or manual request identity | source_run_identity | VARCHAR(64) | |||
| race-id指定値 | target_race_id | BIGINT UNSIGNED | |||
| from指定値 yyyymmdd | target_from_date | CHAR(8) | |||
| to指定値 yyyymmdd | target_to_date | CHAR(8) | |||
| retry元job-id | retry_source_job_id | BIGINT UNSIGNED | |||
| effective from yyyymmdd | effective_target_from_date | CHAR(8) | |||
| effective to yyyymmdd | effective_target_to_date | CHAR(8) | |||
| source snapshot cutoff yyyymmdd | source_cutoff_date | CHAR(8) | |||
| PENDING/RUNNING/SUCCESS/PARTIAL_FAILED/FAILED | status | VARCHAR(16) | |||
| 総チャンク数 | total_chunk_count | INT | |||
| 成功チャンク数 | success_chunk_count | INT | |||
| 失敗チャンク数 | failed_chunk_count | INT | |||
| 処理レース数 | processed_count | INT | |||
| 成功レース数 | success_count | INT | |||
| 警告レース数 | warning_count | INT | |||
| エラーレース数 | error_count | INT | |||
| ジョブ単位の警告フラグ | warning_flags | VARCHAR(255) | |||
| master snapshot公開済み | master_published | TINYINT(1) | |||
| master snapshot公開日時 | master_published_at | DATETIME | |||
| TAV source fingerprint | source_fingerprint | CHAR(64) | |||
| sanitized exception type | error_type | VARCHAR(128) | |||
| sanitized error message | error_message | VARCHAR(1024) | |||
| 実行開始日時 | started_at | DATETIME | |||
| 実行終了日時 | finished_at | DATETIME | |||
| 作成日時 | created_at | DATETIME | |||
| 更新日時 | updated_at | DATETIME | |||
| planning_version | planning_version | VARCHAR(64) | |||
| target_set_hash | target_set_hash | CHAR(64) | |||
| required_race_count | required_race_count | INT | |||
| required_group_count | required_group_count | INT | |||
| stale_race_count | stale_race_count | INT | |||
| master_required | master_required | TINYINT | |||
| required_plan_json | required_plan_json | JSON |
tav_job_target_group12 fields| 論理名 | 物理名 | データ型 | データ種別 | レコード種別 | JVData項目名 |
|---|---|---|---|---|---|
| job_id | job_id | BIGINT UNSIGNED | |||
| race_date | race_date | DATE | |||
| racecourse_cd | racecourse_cd | CHAR(2) | |||
| surface_cd | surface_cd | CHAR(1) | |||
| source_revision | source_revision | BIGINT | |||
| input_hash | input_hash | CHAR(64) | |||
| member_hash | member_hash | CHAR(64) | |||
| member_ids | member_ids | JSON | |||
| target_count | target_count | INT | |||
| reason | reason | VARCHAR(64) | |||
| status | status | VARCHAR(16) | |||
| completed_at | completed_at | DATETIME(6) |
tav_lap_profile_master15 fields| 論理名 | 物理名 | データ型 | データ種別 | レコード種別 | JVData項目名 |
|---|---|---|---|---|---|
| 内部ID | lap_profile_id | BIGINT UNSIGNED | |||
| ラップ基準プロファイル階層 | profile_level | INT | |||
| 正規化サーフェス T/D | surface_cd | CHAR(1) | |||
| 距離。距離カテゴリ平均の場合は0 | kyori | INT | |||
| 距離カテゴリ | distance_category | VARCHAR(16) | |||
| 年齢帯。全年齢はALL_AGE | age_group_cd | VARCHAR(8) | |||
| ラップ用クラス分類 | lap_class_group | VARCHAR(32) | |||
| 馬場グループ | baba_group | VARCHAR(16) | |||
| ラップ区間番号 | segment_seq | INT | |||
| 平均区間ラップ | avg_lap_sec | DECIMAL(8,3) | |||
| 平均ラップ間差分 | avg_delta_sec | DECIMAL(8,3) | |||
| 参照レース数 | sample_count | INT | |||
| 基準値信頼度 | confidence_score | DECIMAL(5,4) | |||
| 作成日時 | created_at | DATETIME | |||
| 更新日時 | updated_at | DATETIME |
tav_par_time_master9 fields| 論理名 | 物理名 | データ型 | データ種別 | レコード種別 | JVData項目名 |
|---|---|---|---|---|---|
| 内部ID | par_time_id | BIGINT UNSIGNED | |||
| 正規化サーフェス T/D | surface_cd | CHAR(1) | |||
| 距離 | kyori | INT | |||
| 基準時計 秒 | par_time_sec | DECIMAL(8,3) | |||
| 採用サンプル数 | sample_count | INT | |||
| 基準馬場状態 初版は良固定 | base_baba_cd | CHAR(1) | |||
| 備考 | note | VARCHAR(255) | |||
| 作成日時 | created_at | DATETIME | |||
| 更新日時 | updated_at | DATETIME |
tav_race32 fields| 論理名 | 物理名 | データ型 | データ種別 | レコード種別 | JVData項目名 |
|---|---|---|---|---|---|
| TurfAnalyzerTrackVariant内部レースID | race_id | BIGINT UNSIGNED | |||
| JV2AI core_ra_race.race_id | core_race_id | BIGINT | |||
| 開催日yyyymmdd | kaisai_date | CHAR(8) | |||
| 競馬場コード | jyo_cd | CHAR(2) | |||
| 回次 | kaiji | CHAR(2) | |||
| 日次 | nichiji | CHAR(2) | |||
| レース番号 | race_num | CHAR(2) | |||
| レース名 | race_name | VARCHAR(120) | |||
| 距離 | kyori | INT | |||
| 元のトラックコード | track_cd | CHAR(2) | |||
| 正規化サーフェス T/D | surface_cd | CHAR(1) | |||
| 元のグレードコード | grade_cd | CHAR(1) | |||
| 元の競走種別コード | syubetu_cd | CHAR(2) | |||
| 年齢帯 2YO/3YO/3UP/4UP | age_group_cd | VARCHAR(8) | |||
| 元の競走条件コード 2歳 | jyoken_cd_2sai | CHAR(3) | |||
| 元の競走条件コード 3歳 | jyoken_cd_3sai | CHAR(3) | |||
| 元の競走条件コード 4歳 | jyoken_cd_4sai | CHAR(3) | |||
| 元の競走条件コード 5歳以上 | jyoken_cd_5sai_ijo | CHAR(3) | |||
| 元の競走条件コード 最若年 | jyoken_cd_saijakunen | CHAR(3) | |||
| 正式採用する競走条件コード | jyoken_cd_used | CHAR(3) | |||
| 正規化クラス分類 | normalized_class_cd | VARCHAR(16) | |||
| クラス補正キー surface_age_class | class_factor_key | VARCHAR(64) | |||
| race単位で使用する馬場状態コード | baba_cd_used | CHAR(1) | |||
| 元の芝馬場状態コード | siba_baba_cd | CHAR(1) | |||
| 元のダート馬場状態コード | dirt_baba_cd | CHAR(1) | |||
| 天候コード | tenko_cd | CHAR(1) | |||
| JRA対象レースか | is_jra_target | TINYINT(1) | |||
| 本プロジェクト対象レースか | is_supported_race | TINYINT(1) | |||
| 対象外理由 | exclusion_reason | VARCHAR(255) | |||
| 元jv_ra_race.updated_at | source_updated_at | DATETIME | |||
| 作成日時 | created_at | DATETIME | |||
| 更新日時 | updated_at | DATETIME |
tav_race_adjustment33 fields| 論理名 | 物理名 | データ型 | データ種別 | レコード種別 | JVData項目名 |
|---|---|---|---|---|---|
| 内部ID | race_adjustment_id | BIGINT UNSIGNED | |||
| tav_race.race_id | race_id | BIGINT UNSIGNED | |||
| TAV計算仕様版 | calculation_version | VARCHAR(64) | |||
| 信頼度校正artifact SHA-256 | calibration_checksum | CHAR(64) | |||
| 算出入力指紋 SHA-256 | input_fingerprint | CHAR(64) | |||
| 開催日yyyymmdd | kaisai_date | CHAR(8) | |||
| 競馬場コード | jyo_cd | CHAR(2) | |||
| 回次 | kaiji | CHAR(2) | |||
| 日次 | nichiji | CHAR(2) | |||
| レース番号 | race_num | CHAR(2) | |||
| 正規化サーフェス T/D | surface_cd | CHAR(1) | |||
| 距離 | kyori | INT | |||
| 年齢帯 | age_group_cd | VARCHAR(8) | |||
| 採用した競走条件コード | jyoken_cd_used | CHAR(3) | |||
| 正規化クラス | normalized_class_cd | VARCHAR(16) | |||
| クラス補正キー | class_factor_key | VARCHAR(64) | |||
| 使用馬場状態コード | baba_cd_used | CHAR(1) | |||
| 基準時計 | par_time_sec | DECIMAL(8,3) | |||
| コース補正 | course_factor_sec | DECIMAL(8,3) | |||
| クラス補正 | class_factor_sec | DECIMAL(8,3) | |||
| 馬場状態補正 | track_condition_factor_sec | DECIMAL(8,3) | |||
| 開催日馬場差 | day_variant_sec | DECIMAL(8,3) | |||
| レース個別補正値 | race_adjustment_sec | DECIMAL(8,3) | |||
| 基準時計と補正値の合計 | expected_race_time_sec | DECIMAL(8,3) | |||
| 主状態 | quality_status | VARCHAR(32) | |||
| 警告フラグの連結文字列 | warning_flags | VARCHAR(255) | |||
| 推定・フォールバックを含むか | is_estimated | TINYINT(1) | |||
| 使用した最大フォールバック階層 | fallback_level | INT | |||
| 補正値全体の信頼度 | confidence_score | DECIMAL(5,4) | |||
| 成分別参照件数 | component_sample_counts_json | JSON | |||
| 成分別の算出元とブレンド情報 | component_source_json | JSON | |||
| 作成日時 | created_at | DATETIME | |||
| 更新日時 | updated_at | DATETIME |
tav_race_lap_profile29 fields| 論理名 | 物理名 | データ型 | データ種別 | レコード種別 | JVData項目名 |
|---|---|---|---|---|---|
| 内部ID | race_lap_profile_id | BIGINT UNSIGNED | |||
| tav_race.race_id | race_id | BIGINT UNSIGNED | |||
| 開催日yyyymmdd | kaisai_date | CHAR(8) | |||
| 競馬場コード | jyo_cd | CHAR(2) | |||
| 正規化サーフェス T/D | surface_cd | CHAR(1) | |||
| 距離 | kyori | INT | |||
| 距離カテゴリ | distance_category | VARCHAR(16) | |||
| 年齢帯 | age_group_cd | VARCHAR(8) | |||
| 正規化クラス | normalized_class_cd | VARCHAR(16) | |||
| ラップ用クラス分類 | lap_class_group | VARCHAR(32) | |||
| 馬場グループ | baba_group | VARCHAR(16) | |||
| 前半圧 | first_half_pressure_sec | DECIMAL(8,3) | |||
| 中盤圧 | middle_pressure_sec | DECIMAL(8,3) | |||
| 終盤圧 | late_pressure_sec | DECIMAL(8,3) | |||
| 前半速度指数 | early_speed_index | DECIMAL(8,3) | |||
| 中盤加速指数 | mid_accel_index | DECIMAL(8,3) | |||
| 終盤加速指数 | late_accel_index | DECIMAL(8,3) | |||
| 持続速度指数 | sustained_speed_index | DECIMAL(8,3) | |||
| ラスト締まり指数 | closing_speed_index | DECIMAL(8,3) | |||
| レース質分類 | pace_type | VARCHAR(32) | |||
| 主状態 | quality_status | VARCHAR(32) | |||
| 警告フラグの連結文字列 | warning_flags | VARCHAR(255) | |||
| 推定・フォールバックを含むか | is_estimated | TINYINT(1) | |||
| 最大フォールバック階層 | fallback_level | INT | |||
| 信頼度 | confidence_score | DECIMAL(5,4) | |||
| 参照件数 | component_sample_counts_json | JSON | |||
| 算出元 | component_source_json | JSON | |||
| 作成日時 | created_at | DATETIME | |||
| 更新日時 | updated_at | DATETIME |
tav_race_lap_segment19 fields| 論理名 | 物理名 | データ型 | データ種別 | レコード種別 | JVData項目名 |
|---|---|---|---|---|---|
| 内部ID | race_lap_segment_id | BIGINT UNSIGNED | |||
| tav_race.race_id | race_id | BIGINT UNSIGNED | |||
| ラップ区間番号 | segment_seq | INT | |||
| 実測区間ラップ | lap_sec | DECIMAL(8,3) | |||
| 基準区間ラップ | base_lap_sec | DECIMAL(8,3) | |||
| 実測 - 基準 | lap_diff_sec | DECIMAL(8,3) | |||
| 実測ラップ間差分 | delta_sec | DECIMAL(8,3) | |||
| 基準ラップ間差分 | base_delta_sec | DECIMAL(8,3) | |||
| 実測delta - 基準delta | delta_diff_sec | DECIMAL(8,3) | |||
| ACCEL / DECEL / FLAT | pace_direction | VARCHAR(16) | |||
| 主状態 | quality_status | VARCHAR(32) | |||
| 警告フラグの連結文字列 | warning_flags | VARCHAR(255) | |||
| 推定・フォールバックを含むか | is_estimated | TINYINT(1) | |||
| 最大フォールバック階層 | fallback_level | INT | |||
| 信頼度 | confidence_score | DECIMAL(5,4) | |||
| 参照件数 | component_sample_counts_json | JSON | |||
| 算出元 | component_source_json | JSON | |||
| 作成日時 | created_at | DATETIME | |||
| 更新日時 | updated_at | DATETIME |
tav_recalculation_control15 fields| 論理名 | 物理名 | データ型 | データ種別 | レコード種別 | JVData項目名 |
|---|---|---|---|---|---|
| control_id | control_id | TINYINT | |||
| source_revision | source_revision | BIGINT | |||
| planning_version | planning_version | VARCHAR(64) | |||
| baseline_ready | baseline_ready | TINYINT | |||
| source_hash | source_hash | CHAR(64) | |||
| master_input_hash | master_input_hash | CHAR(64) | |||
| master_cutoff | master_cutoff | DATE | |||
| master_pending | master_pending | TINYINT | |||
| master_job_id | master_job_id | BIGINT UNSIGNED | |||
| updated_at | updated_at | DATETIME(6) | |||
| master_output_hash | master_output_hash | CHAR(64) | |||
| input_epoch | input_epoch | BIGINT | |||
| output_epoch | output_epoch | BIGINT | |||
| master_epoch | master_epoch | BIGINT | |||
| incremental_ready | incremental_ready | TINYINT |
tav_recalculation_group_state19 fields| 論理名 | 物理名 | データ型 | データ種別 | レコード種別 | JVData項目名 |
|---|---|---|---|---|---|
| race_date | race_date | DATE | |||
| racecourse_cd | racecourse_cd | CHAR(2) | |||
| surface_cd | surface_cd | CHAR(1) | |||
| requested_revision | requested_revision | BIGINT | |||
| input_hash | input_hash | CHAR(64) | |||
| member_hash | member_hash | CHAR(64) | |||
| reason | reason | VARCHAR(64) | |||
| status | status | VARCHAR(16) | |||
| successful_input_hash | successful_input_hash | CHAR(64) | |||
| successful_member_hash | successful_member_hash | CHAR(64) | |||
| successful_output_hash | successful_output_hash | CHAR(64) | |||
| calculation_version | calculation_version | VARCHAR(64) | |||
| calibration_checksum | calibration_checksum | CHAR(64) | |||
| successful_job_id | successful_job_id | BIGINT UNSIGNED | |||
| completed_at | completed_at | DATETIME(6) | |||
| updated_at | updated_at | DATETIME(6) | |||
| verification_status | verification_status | VARCHAR(32) | |||
| lap_reference_from | lap_reference_from | DATE | |||
| lap_reference_to | lap_reference_to | DATE |
tav_source_race_revision10 fields| 論理名 | 物理名 | データ型 | データ種別 | レコード種別 | JVData項目名 |
|---|---|---|---|---|---|
| core_race_id | core_race_id | BIGINT | |||
| race_date | race_date | DATE | |||
| racecourse_cd | racecourse_cd | CHAR(2) | |||
| surface_cd | surface_cd | CHAR(1) | |||
| is_eligible | is_eligible | TINYINT | |||
| is_deleted | is_deleted | TINYINT | |||
| input_hash | input_hash | CHAR(64) | |||
| source_revision | source_revision | BIGINT | |||
| updated_at | updated_at | DATETIME(6) | |||
| source_summary | source_summary | JSON |
tav_track_condition_factor_master8 fields| 論理名 | 物理名 | データ型 | データ種別 | レコード種別 | JVData項目名 |
|---|---|---|---|---|---|
| 内部ID | track_condition_factor_id | BIGINT UNSIGNED | |||
| 正規化サーフェス T/D | surface_cd | CHAR(1) | |||
| 馬場状態コード | baba_cd | CHAR(1) | |||
| 馬場状態補正 秒 | track_condition_factor_sec | DECIMAL(8,3) | |||
| 採用サンプル数 | sample_count | INT | |||
| 備考 | note | VARCHAR(255) | |||
| 作成日時 | created_at | DATETIME | |||
| 更新日時 | updated_at | DATETIME |
taf_data_quality_issue14 fields| 論理名 | 物理名 | データ型 | データ種別 | レコード種別 | JVData項目名 |
|---|---|---|---|---|---|
| taf_issue_id | taf_issue_id | BIGINT | |||
| taf_job_id | taf_job_id | BIGINT | |||
| issue_level | issue_level | VARCHAR(16) | |||
| issue_code | issue_code | VARCHAR(64) | |||
| target_table_name | target_table_name | VARCHAR(64) | |||
| race_id | race_id | BIGINT | |||
| race_horse_id | race_horse_id | BIGINT | |||
| horse_id | horse_id | BIGINT | |||
| taf_race_feature_id | taf_race_feature_id | BIGINT | |||
| taf_race_horse_feature_id | taf_race_horse_feature_id | BIGINT | |||
| horse_ability_snapshot_id | horse_ability_snapshot_id | BIGINT | |||
| issue_message | issue_message | VARCHAR(512) | |||
| detail_json | detail_json | JSON | |||
| occurred_at | occurred_at | DATETIME |
taf_date_checkpoint16 fields| 論理名 | 物理名 | データ型 | データ種別 | レコード種別 | JVData項目名 |
|---|---|---|---|---|---|
| race_date | race_date | DATE | |||
| calc_status | calc_status | VARCHAR(32) | |||
| source_generation | source_generation | BIGINT UNSIGNED | |||
| source_revision | source_revision | BIGINT UNSIGNED | |||
| source_stage | source_stage | VARCHAR(16) | |||
| source_fingerprint | source_fingerprint | CHAR(64) | |||
| algorithm_version | algorithm_version | VARCHAR(32) | |||
| calibration_checksum | calibration_checksum | CHAR(64) | |||
| target_race_count | target_race_count | INT UNSIGNED | |||
| target_race_horse_count | target_race_horse_count | INT UNSIGNED | |||
| snapshot_count | snapshot_count | INT UNSIGNED | |||
| last_taf_job_id | last_taf_job_id | BIGINT | |||
| started_at | started_at | DATETIME | |||
| completed_at | completed_at | DATETIME | |||
| error_type | error_type | VARCHAR(128) | |||
| updated_at | updated_at | DATETIME |
taf_horse_ability_snapshot64 fields| 論理名 | 物理名 | データ型 | データ種別 | レコード種別 | JVData項目名 |
|---|---|---|---|---|---|
| horse_ability_snapshot_id | horse_ability_snapshot_id | BIGINT | |||
| taf_job_id | taf_job_id | BIGINT | |||
| as_of_race_id | as_of_race_id | BIGINT | |||
| as_of_race_horse_id | as_of_race_horse_id | BIGINT | |||
| horse_id | horse_id | BIGINT | |||
| as_of_race_date | as_of_race_date | DATE | |||
| snapshot_scope_type | snapshot_scope_type | VARCHAR(64) | |||
| target_surface_cd | target_surface_cd | CHAR(1) | |||
| target_distance_m | target_distance_m | SMALLINT | |||
| target_distance_category | target_distance_category | VARCHAR(32) | |||
| target_racecourse_cd | target_racecourse_cd | CHAR(2) | |||
| tai_index | tai_index | DECIMAL(6,3) | |||
| tai_latent_z | tai_latent_z | DECIMAL(7,4) | |||
| epi_index | epi_index | DECIMAL(6,3) | |||
| lpi_index | lpi_index | DECIMAL(6,3) | |||
| spi_index | spi_index | DECIMAL(6,3) | |||
| kri_index | kri_index | DECIMAL(6,3) | |||
| tai_confidence_score | tai_confidence_score | DECIMAL(5,4) | |||
| epi_confidence_score | epi_confidence_score | DECIMAL(5,4) | |||
| lpi_confidence_score | lpi_confidence_score | DECIMAL(5,4) | |||
| spi_confidence_score | spi_confidence_score | DECIMAL(5,4) | |||
| kri_confidence_score | kri_confidence_score | DECIMAL(5,4) | |||
| epi_evidence_level | epi_evidence_level | VARCHAR(16) | |||
| lpi_evidence_level | lpi_evidence_level | VARCHAR(16) | |||
| spi_evidence_level | spi_evidence_level | VARCHAR(16) | |||
| kri_evidence_level | kri_evidence_level | VARCHAR(16) | |||
| tai_evidence_level | tai_evidence_level | VARCHAR(16) | |||
| weighted_ability_resid_sec | weighted_ability_resid_sec | DECIMAL(8,3) | |||
| weighted_time_resid_sec | weighted_time_resid_sec | DECIMAL(8,3) | |||
| speed_z | speed_z | DECIMAL(6,3) | |||
| front3_z | front3_z | DECIMAL(6,3) | |||
| late3_z | late3_z | DECIMAL(6,3) | |||
| early_position_z | early_position_z | DECIMAL(6,3) | |||
| mid_position_z | mid_position_z | DECIMAL(6,3) | |||
| front_lead_z | front_lead_z | DECIMAL(6,3) | |||
| closing_z | closing_z | DECIMAL(6,3) | |||
| rear_weighted_gain_z | rear_weighted_gain_z | DECIMAL(6,3) | |||
| early_hold_z | early_hold_z | DECIMAL(6,3) | |||
| early_pressure_load_z | early_pressure_load_z | DECIMAL(6,3) | |||
| late_context_response_z | late_context_response_z | DECIMAL(6,3) | |||
| no_fade_z | no_fade_z | DECIMAL(6,3) | |||
| front_survival_z | front_survival_z | DECIMAL(6,3) | |||
| late3_sustain_z | late3_sustain_z | DECIMAL(6,3) | |||
| sustained_context_load_z | sustained_context_load_z | DECIMAL(6,3) | |||
| closing_acceleration_z | closing_acceleration_z | DECIMAL(6,3) | |||
| relative_last3_z | relative_last3_z | DECIMAL(6,3) | |||
| spi_z | spi_z | DECIMAL(6,3) | |||
| corner_gain_z | corner_gain_z | DECIMAL(6,3) | |||
| kri_z | kri_z | DECIMAL(6,3) | |||
| source_run_count | source_run_count | SMALLINT | |||
| valid_source_run_count | valid_source_run_count | SMALLINT | |||
| selected_run_count | selected_run_count | SMALLINT | |||
| single_extreme_poor_run_excluded_count | single_extreme_poor_run_excluded_count | SMALLINT | |||
| source_race_date_min | source_race_date_min | DATE | |||
| source_race_date_max | source_race_date_max | DATE | |||
| days_since_last_run_count | days_since_last_run_count | SMALLINT | |||
| avg_source_confidence_score | avg_source_confidence_score | DECIMAL(5,4) | |||
| snapshot_confidence_score | snapshot_confidence_score | DECIMAL(5,4) | |||
| quality_status | quality_status | VARCHAR(32) | |||
| quality_warning_flags | quality_warning_flags | VARCHAR(512) | |||
| created_at | created_at | DATETIME | |||
| updated_at | updated_at | DATETIME | |||
| recent_ability_stat_source_count | recent_ability_stat_source_count | SMALLINT | |||
| recent_ability_variability_mad_z | recent_ability_variability_mad_z | DECIMAL(6,3) |
taf_horse_ability_snapshot_source61 fields| 論理名 | 物理名 | データ型 | データ種別 | レコード種別 | JVData項目名 |
|---|---|---|---|---|---|
| horse_ability_snapshot_source_id | horse_ability_snapshot_source_id | BIGINT | |||
| horse_ability_snapshot_id | horse_ability_snapshot_id | BIGINT | |||
| source_taf_race_horse_feature_id | source_taf_race_horse_feature_id | BIGINT | |||
| source_race_id | source_race_id | BIGINT | |||
| source_race_horse_id | source_race_horse_id | BIGINT | |||
| source_horse_id | source_horse_id | BIGINT | |||
| source_race_date | source_race_date | DATE | |||
| source_surface_cd | source_surface_cd | CHAR(1) | |||
| source_distance_m | source_distance_m | SMALLINT | |||
| source_distance_category | source_distance_category | VARCHAR(32) | |||
| source_racecourse_cd | source_racecourse_cd | CHAR(2) | |||
| source_pace_type | source_pace_type | VARCHAR(32) | |||
| source_lap_confidence_score | source_lap_confidence_score | DECIMAL(5,4) | |||
| source_class_factor_sec | source_class_factor_sec | DECIMAL(8,3) | |||
| source_run_ability_resid_for_score_sec | source_run_ability_resid_for_score_sec | DECIMAL(8,3) | |||
| source_run_ability_resid_for_time_sec | source_run_ability_resid_for_time_sec | DECIMAL(8,3) | |||
| source_run_tai_absolute_resid_sec | source_run_tai_absolute_resid_sec | DECIMAL(8,3) | |||
| source_run_tai_absolute_z | source_run_tai_absolute_z | DECIMAL(7,4) | |||
| source_run_result_dominance_z | source_run_result_dominance_z | DECIMAL(7,4) | |||
| source_run_opponent_strength_z | source_run_opponent_strength_z | DECIMAL(7,4) | |||
| source_run_opponent_valid_count | source_run_opponent_valid_count | SMALLINT UNSIGNED | |||
| source_run_opponent_weight_sum | source_run_opponent_weight_sum | DECIMAL(8,4) | |||
| source_run_competition_ability_z | source_run_competition_ability_z | DECIMAL(7,4) | |||
| source_run_tai_context_z | source_run_tai_context_z | DECIMAL(7,4) | |||
| source_run_speed_z | source_run_speed_z | DECIMAL(6,3) | |||
| source_run_front3_z_source | source_run_front3_z_source | DECIMAL(6,3) | |||
| source_run_late3_z_source | source_run_late3_z_source | DECIMAL(6,3) | |||
| source_run_corner_gain_rate | source_run_corner_gain_rate | DECIMAL(6,4) | |||
| source_run_straight_hold_rate | source_run_straight_hold_rate | DECIMAL(6,4) | |||
| source_run_overall_performance_index | source_run_overall_performance_index | DECIMAL(6,3) | |||
| source_run_early_position_index | source_run_early_position_index | DECIMAL(6,3) | |||
| source_run_late_performance_index | source_run_late_performance_index | DECIMAL(6,3) | |||
| source_run_front_sustain_index | source_run_front_sustain_index | DECIMAL(6,3) | |||
| source_run_closing_gain_index | source_run_closing_gain_index | DECIMAL(6,3) | |||
| source_performance_confidence_score | source_performance_confidence_score | DECIMAL(5,4) | |||
| source_used_flag | source_used_flag | TINYINT(1) | |||
| source_exclusion_reason | source_exclusion_reason | VARCHAR(64) | |||
| source_exclusion_basis_json | source_exclusion_basis_json | JSON | |||
| single_extreme_poor_run_flag | single_extreme_poor_run_flag | TINYINT(1) | |||
| ability_select_rank | ability_select_rank | SMALLINT | |||
| selected_run_limit | selected_run_limit | SMALLINT | |||
| ability_rank_weight | ability_rank_weight | DECIMAL(5,4) | |||
| source_recency_days | source_recency_days | SMALLINT | |||
| recency_weight | recency_weight | DECIMAL(5,4) | |||
| quality_weight | quality_weight | DECIMAL(5,4) | |||
| source_weight | source_weight | DECIMAL(8,5) | |||
| source_weight_basis_json | source_weight_basis_json | JSON | |||
| created_at | created_at | DATETIME | |||
| source_run_early_position_z_source | source_run_early_position_z_source | DECIMAL(6,3) | |||
| source_run_mid_position_z_source | source_run_mid_position_z_source | DECIMAL(6,3) | |||
| source_run_corner_gain_z_source | source_run_corner_gain_z_source | DECIMAL(6,3) | |||
| source_run_rear_weighted_gain_z_source | source_run_rear_weighted_gain_z_source | DECIMAL(6,3) | |||
| source_run_early_hold_z_source | source_run_early_hold_z_source | DECIMAL(6,3) | |||
| source_run_early_pressure_load_z_source | source_run_early_pressure_load_z_source | DECIMAL(6,3) | |||
| source_run_late_context_response_z_source | source_run_late_context_response_z_source | DECIMAL(6,3) | |||
| source_run_no_fade_z_source | source_run_no_fade_z_source | DECIMAL(6,3) | |||
| source_run_front_survival_z_source | source_run_front_survival_z_source | DECIMAL(6,3) | |||
| source_run_sustained_context_load_z_source | source_run_sustained_context_load_z_source | DECIMAL(6,3) | |||
| source_run_closing_acceleration_sec | source_run_closing_acceleration_sec | DECIMAL(8,3) | |||
| source_run_closing_acceleration_z_source | source_run_closing_acceleration_z_source | DECIMAL(6,3) | |||
| source_run_relative_last3_z_source | source_run_relative_last3_z_source | DECIMAL(6,3) |
taf_job_run30 fields| 論理名 | 物理名 | データ型 | データ種別 | レコード種別 | JVData項目名 |
|---|---|---|---|---|---|
| taf_job_id | taf_job_id | BIGINT | |||
| taf_spec_version | taf_spec_version | VARCHAR(32) | |||
| taf_algorithm_version | taf_algorithm_version | VARCHAR(32) | |||
| index_calibration_version | index_calibration_version | VARCHAR(32) | |||
| index_calibration_checksum | index_calibration_checksum | CHAR(64) | |||
| tav_spec_version | tav_spec_version | VARCHAR(32) | |||
| run_mode | run_mode | VARCHAR(32) | |||
| worker_pid | worker_pid | BIGINT UNSIGNED | |||
| calc_scope_type | calc_scope_type | VARCHAR(32) | |||
| target_race_id | target_race_id | BIGINT | |||
| target_from_date | target_from_date | DATE | |||
| target_to_date | target_to_date | DATE | |||
| source_tav_job_id | source_tav_job_id | BIGINT | |||
| source_tav_updated_from | source_tav_updated_from | DATETIME | |||
| source_tav_updated_to | source_tav_updated_to | DATETIME | |||
| calc_status | calc_status | VARCHAR(32) | |||
| target_race_count | target_race_count | INT | |||
| success_race_count | success_race_count | INT | |||
| failed_race_count | failed_race_count | INT | |||
| target_race_horse_count | target_race_horse_count | INT | |||
| success_race_horse_count | success_race_horse_count | INT | |||
| failed_race_horse_count | failed_race_horse_count | INT | |||
| created_snapshot_count | created_snapshot_count | INT | |||
| issue_count | issue_count | INT | |||
| parameter_hash | parameter_hash | VARCHAR(128) | |||
| parameter_json | parameter_json | JSON | |||
| started_at | started_at | DATETIME | |||
| finished_at | finished_at | DATETIME | |||
| created_at | created_at | DATETIME | |||
| updated_at | updated_at | DATETIME |
taf_processing_control9 fields| 論理名 | 物理名 | データ型 | データ種別 | レコード種別 | JVData項目名 |
|---|---|---|---|---|---|
| control_id | control_id | TINYINT UNSIGNED | |||
| source_generation | source_generation | BIGINT UNSIGNED | |||
| ready_generation | ready_generation | BIGINT UNSIGNED | |||
| source_fingerprint | source_fingerprint | CHAR(64) | |||
| dirty_from_date | dirty_from_date | DATE | |||
| active_taf_job_id | active_taf_job_id | BIGINT | |||
| algorithm_version | algorithm_version | VARCHAR(32) | |||
| calibration_checksum | calibration_checksum | CHAR(64) | |||
| updated_at | updated_at | DATETIME |
taf_race_feature47 fields| 論理名 | 物理名 | データ型 | データ種別 | レコード種別 | JVData項目名 |
|---|---|---|---|---|---|
| taf_race_feature_id | taf_race_feature_id | BIGINT | |||
| taf_job_id | taf_job_id | BIGINT | |||
| race_id | race_id | BIGINT | |||
| tav_race_id | tav_race_id | BIGINT | |||
| tav_race_adjustment_id | tav_race_adjustment_id | BIGINT | |||
| race_date | race_date | DATE | |||
| racecourse_cd | racecourse_cd | CHAR(2) | |||
| race_no | race_no | TINYINT | |||
| surface_cd | surface_cd | CHAR(1) | |||
| distance_m | distance_m | SMALLINT | |||
| distance_category | distance_category | VARCHAR(32) | |||
| track_cd | track_cd | VARCHAR(2) | |||
| baba_cd | baba_cd | VARCHAR(2) | |||
| weather_cd | weather_cd | VARCHAR(2) | |||
| normalized_class_cd | normalized_class_cd | VARCHAR(32) | |||
| starter_count | starter_count | TINYINT | |||
| finisher_count | finisher_count | TINYINT | |||
| straight_course_flag | straight_course_flag | TINYINT(1) | |||
| expected_race_time_sec | expected_race_time_sec | DECIMAL(8,3) | |||
| race_adjustment_sec | race_adjustment_sec | DECIMAL(8,3) | |||
| day_variant_sec | day_variant_sec | DECIMAL(8,3) | |||
| par_time_sec | par_time_sec | DECIMAL(8,3) | |||
| class_factor_sec | class_factor_sec | DECIMAL(8,3) | |||
| tav_confidence_score | tav_confidence_score | DECIMAL(5,4) | |||
| winner_finish_time_sec | winner_finish_time_sec | DECIMAL(8,3) | |||
| winner_time_resid_sec | winner_time_resid_sec | DECIMAL(8,3) | |||
| first3_sec | first3_sec | DECIMAL(6,3) | |||
| last3_sec | last3_sec | DECIMAL(6,3) | |||
| pace_type | pace_type | VARCHAR(32) | |||
| first_half_pressure_sec | first_half_pressure_sec | DECIMAL(8,3) | |||
| middle_pressure_sec | middle_pressure_sec | DECIMAL(8,3) | |||
| late_pressure_sec | late_pressure_sec | DECIMAL(8,3) | |||
| lap_confidence_score | lap_confidence_score | DECIMAL(5,4) | |||
| valid_taf_race_flag | valid_taf_race_flag | TINYINT(1) | |||
| valid_tav_adjustment_flag | valid_tav_adjustment_flag | TINYINT(1) | |||
| valid_lap_flag | valid_lap_flag | TINYINT(1) | |||
| valid_time_flag | valid_time_flag | TINYINT(1) | |||
| race_confidence_score | race_confidence_score | DECIMAL(5,4) | |||
| quality_status | quality_status | VARCHAR(32) | |||
| quality_warning_flags | quality_warning_flags | VARCHAR(512) | |||
| created_at | created_at | DATETIME | |||
| updated_at | updated_at | DATETIME | |||
| early_speed_index | early_speed_index | DECIMAL(6,3) | |||
| mid_accel_index | mid_accel_index | DECIMAL(6,3) | |||
| late_accel_index | late_accel_index | DECIMAL(6,3) | |||
| sustained_speed_index | sustained_speed_index | DECIMAL(6,3) | |||
| closing_speed_index | closing_speed_index | DECIMAL(6,3) |
taf_race_horse_feature93 fields| 論理名 | 物理名 | データ型 | データ種別 | レコード種別 | JVData項目名 |
|---|---|---|---|---|---|
| taf_race_horse_feature_id | taf_race_horse_feature_id | BIGINT | |||
| taf_job_id | taf_job_id | BIGINT | |||
| taf_race_feature_id | taf_race_feature_id | BIGINT | |||
| race_id | race_id | BIGINT | |||
| race_horse_id | race_horse_id | BIGINT | |||
| horse_id | horse_id | BIGINT | |||
| tav_race_id | tav_race_id | BIGINT | |||
| tav_race_adjustment_id | tav_race_adjustment_id | BIGINT | |||
| race_date | race_date | DATE | |||
| racecourse_cd | racecourse_cd | CHAR(2) | |||
| race_no | race_no | TINYINT | |||
| surface_cd | surface_cd | CHAR(1) | |||
| distance_m | distance_m | SMALLINT | |||
| distance_category | distance_category | VARCHAR(32) | |||
| track_cd | track_cd | VARCHAR(2) | |||
| baba_cd | baba_cd | VARCHAR(2) | |||
| normalized_class_cd | normalized_class_cd | VARCHAR(32) | |||
| starter_count | starter_count | TINYINT | |||
| finisher_count | finisher_count | TINYINT | |||
| straight_course_flag | straight_course_flag | TINYINT(1) | |||
| horse_no | horse_no | TINYINT | |||
| finish_order | finish_order | TINYINT | |||
| arrival_order | arrival_order | TINYINT | |||
| abnormality_cd | abnormality_cd | VARCHAR(4) | |||
| finish_time_sec | finish_time_sec | DECIMAL(8,3) | |||
| winner_finish_time_sec | winner_finish_time_sec | DECIMAL(8,3) | |||
| winner_time_diff_sec | winner_time_diff_sec | DECIMAL(8,3) | |||
| margin_sec | margin_sec | DECIMAL(8,3) | |||
| last3_sec | last3_sec | DECIMAL(6,3) | |||
| corner1_order | corner1_order | TINYINT | |||
| corner2_order | corner2_order | TINYINT | |||
| corner3_order | corner3_order | TINYINT | |||
| corner4_order | corner4_order | TINYINT | |||
| expected_race_time_sec | expected_race_time_sec | DECIMAL(8,3) | |||
| race_adjustment_sec | race_adjustment_sec | DECIMAL(8,3) | |||
| day_variant_sec | day_variant_sec | DECIMAL(8,3) | |||
| class_factor_sec | class_factor_sec | DECIMAL(8,3) | |||
| tav_confidence_score | tav_confidence_score | DECIMAL(5,4) | |||
| run_finish_time_resid_sec | run_finish_time_resid_sec | DECIMAL(8,3) | |||
| run_ability_resid_sec | run_ability_resid_sec | DECIMAL(8,3) | |||
| run_ability_resid_for_score_sec | run_ability_resid_for_score_sec | DECIMAL(8,3) | |||
| run_ability_resid_for_time_sec | run_ability_resid_for_time_sec | DECIMAL(8,3) | |||
| run_tai_absolute_resid_sec | run_tai_absolute_resid_sec | DECIMAL(8,3) | |||
| run_tai_absolute_z | run_tai_absolute_z | DECIMAL(7,4) | |||
| run_result_dominance_z | run_result_dominance_z | DECIMAL(7,4) | |||
| run_opponent_strength_z | run_opponent_strength_z | DECIMAL(7,4) | |||
| run_opponent_valid_count | run_opponent_valid_count | SMALLINT UNSIGNED | |||
| run_opponent_weight_sum | run_opponent_weight_sum | DECIMAL(8,4) | |||
| run_competition_ability_z | run_competition_ability_z | DECIMAL(7,4) | |||
| run_tai_context_z | run_tai_context_z | DECIMAL(7,4) | |||
| run_speed_z | run_speed_z | DECIMAL(6,3) | |||
| run_front3_z_source | run_front3_z_source | DECIMAL(6,3) | |||
| run_late3_sec | run_late3_sec | DECIMAL(6,3) | |||
| run_late3_z_source | run_late3_z_source | DECIMAL(6,3) | |||
| run_early_position_rate | run_early_position_rate | DECIMAL(6,4) | |||
| run_mid_position_rate | run_mid_position_rate | DECIMAL(6,4) | |||
| run_corner4_position_rate | run_corner4_position_rate | DECIMAL(6,4) | |||
| run_finish_position_rate | run_finish_position_rate | DECIMAL(6,4) | |||
| run_corner_gain_rate | run_corner_gain_rate | DECIMAL(6,4) | |||
| run_straight_hold_rate | run_straight_hold_rate | DECIMAL(6,4) | |||
| run_front_late3_support_value | run_front_late3_support_value | DECIMAL(6,4) | |||
| pace_type | pace_type | VARCHAR(32) | |||
| lap_confidence_score | lap_confidence_score | DECIMAL(5,4) | |||
| run_overall_performance_index | run_overall_performance_index | DECIMAL(6,3) | |||
| run_early_position_index | run_early_position_index | DECIMAL(6,3) | |||
| run_late_performance_index | run_late_performance_index | DECIMAL(6,3) | |||
| run_front_sustain_index | run_front_sustain_index | DECIMAL(6,3) | |||
| run_closing_gain_index | run_closing_gain_index | DECIMAL(6,3) | |||
| valid_taf_run_flag | valid_taf_run_flag | TINYINT(1) | |||
| valid_tav_adjustment_flag | valid_tav_adjustment_flag | TINYINT(1) | |||
| valid_time_flag | valid_time_flag | TINYINT(1) | |||
| valid_last3_flag | valid_last3_flag | TINYINT(1) | |||
| valid_position_flag | valid_position_flag | TINYINT(1) | |||
| valid_lap_flag | valid_lap_flag | TINYINT(1) | |||
| abnormality_exclude_flag | abnormality_exclude_flag | TINYINT(1) | |||
| performance_confidence_score | performance_confidence_score | DECIMAL(5,4) | |||
| quality_status | quality_status | VARCHAR(32) | |||
| quality_warning_flags | quality_warning_flags | VARCHAR(512) | |||
| created_at | created_at | DATETIME | |||
| updated_at | updated_at | DATETIME | |||
| run_early_position_z_source | run_early_position_z_source | DECIMAL(6,3) | |||
| run_mid_position_z_source | run_mid_position_z_source | DECIMAL(6,3) | |||
| run_corner_gain_z_source | run_corner_gain_z_source | DECIMAL(6,3) | |||
| run_rear_weighted_gain_z_source | run_rear_weighted_gain_z_source | DECIMAL(6,3) | |||
| run_early_hold_z_source | run_early_hold_z_source | DECIMAL(6,3) | |||
| run_early_pressure_load_z_source | run_early_pressure_load_z_source | DECIMAL(6,3) | |||
| run_late_context_response_z_source | run_late_context_response_z_source | DECIMAL(6,3) | |||
| run_no_fade_z_source | run_no_fade_z_source | DECIMAL(6,3) | |||
| run_front_survival_z_source | run_front_survival_z_source | DECIMAL(6,3) | |||
| run_sustained_context_load_z_source | run_sustained_context_load_z_source | DECIMAL(6,3) | |||
| run_closing_acceleration_sec | run_closing_acceleration_sec | DECIMAL(8,3) | |||
| run_closing_acceleration_z_source | run_closing_acceleration_z_source | DECIMAL(6,3) | |||
| run_relative_last3_z_source | run_relative_last3_z_source | DECIMAL(6,3) |
tfs_data_quality_issue11 fields| 論理名 | 物理名 | データ型 | データ種別 | レコード種別 | JVData項目名 |
|---|---|---|---|---|---|
| tfs_issue_id | tfs_issue_id | BIGINT | |||
| tfs_job_id | tfs_job_id | BIGINT | |||
| tfs_chunk_id | tfs_chunk_id | BIGINT | |||
| issue_level | issue_level | VARCHAR(16) | |||
| issue_code | issue_code | VARCHAR(64) | |||
| race_id | race_id | BIGINT | |||
| race_horse_id | race_horse_id | BIGINT | |||
| horse_id | horse_id | BIGINT | |||
| issue_message | issue_message | VARCHAR(512) | |||
| detail_json | detail_json | JSON | |||
| occurred_at | occurred_at | DATETIME |
tfs_job_chunk13 fields| 論理名 | 物理名 | データ型 | データ種別 | レコード種別 | JVData項目名 |
|---|---|---|---|---|---|
| tfs_chunk_id | tfs_chunk_id | BIGINT | |||
| tfs_job_id | tfs_job_id | BIGINT | |||
| chunk_no | chunk_no | INT | |||
| race_id | race_id | BIGINT | |||
| calc_status | calc_status | VARCHAR(32) | |||
| target_race_horse_count | target_race_horse_count | INT | |||
| processed_race_horse_count | processed_race_horse_count | INT | |||
| error_code | error_code | VARCHAR(64) | |||
| error_message | error_message | VARCHAR(512) | |||
| started_at | started_at | DATETIME | |||
| finished_at | finished_at | DATETIME | |||
| created_at | created_at | DATETIME | |||
| updated_at | updated_at | DATETIME |
tfs_job_run17 fields| 論理名 | 物理名 | データ型 | データ種別 | レコード種別 | JVData項目名 |
|---|---|---|---|---|---|
| tfs_job_id | tfs_job_id | BIGINT | |||
| tfs_spec_version | tfs_spec_version | VARCHAR(32) | |||
| tfs_algorithm_version | tfs_algorithm_version | VARCHAR(32) | |||
| target_from_date | target_from_date | DATE | |||
| target_to_date | target_to_date | DATE | |||
| calc_status | calc_status | VARCHAR(32) | |||
| target_race_count | target_race_count | INT | |||
| success_race_count | success_race_count | INT | |||
| failed_race_count | failed_race_count | INT | |||
| target_race_horse_count | target_race_horse_count | INT | |||
| success_race_horse_count | success_race_horse_count | INT | |||
| failed_race_horse_count | failed_race_horse_count | INT | |||
| issue_count | issue_count | INT | |||
| started_at | started_at | DATETIME | |||
| finished_at | finished_at | DATETIME | |||
| created_at | created_at | DATETIME | |||
| updated_at | updated_at | DATETIME |
tfs_processing_control10 fields| 論理名 | 物理名 | データ型 | データ種別 | レコード種別 | JVData項目名 |
|---|---|---|---|---|---|
| control_id | control_id | TINYINT UNSIGNED | |||
| source_generation | source_generation | BIGINT UNSIGNED | |||
| ready_generation | ready_generation | BIGINT UNSIGNED | |||
| dirty_from_date | dirty_from_date | DATE | |||
| active_tfs_job_id | active_tfs_job_id | BIGINT | |||
| worker_pid | worker_pid | INT UNSIGNED | |||
| tfs_spec_version | tfs_spec_version | VARCHAR(32) | |||
| tfs_algorithm_version | tfs_algorithm_version | VARCHAR(32) | |||
| last_success_at | last_success_at | DATETIME | |||
| updated_at | updated_at | DATETIME |
tfs_race_checkpoint16 fields| 論理名 | 物理名 | データ型 | データ種別 | レコード種別 | JVData項目名 |
|---|---|---|---|---|---|
| race_id | race_id | BIGINT | |||
| race_date | race_date | DATE | |||
| calc_status | calc_status | VARCHAR(32) | |||
| source_generation | source_generation | BIGINT UNSIGNED | |||
| source_revision | source_revision | BIGINT UNSIGNED | |||
| source_fingerprint | source_fingerprint | CHAR(64) | |||
| tfs_spec_version | tfs_spec_version | VARCHAR(32) | |||
| tfs_algorithm_version | tfs_algorithm_version | VARCHAR(32) | |||
| target_race_horse_count | target_race_horse_count | INT UNSIGNED | |||
| written_race_horse_count | written_race_horse_count | INT UNSIGNED | |||
| last_tfs_job_id | last_tfs_job_id | BIGINT | |||
| last_tfs_chunk_id | last_tfs_chunk_id | BIGINT | |||
| started_at | started_at | DATETIME | |||
| completed_at | completed_at | DATETIME | |||
| error_type | error_type | VARCHAR(128) | |||
| updated_at | updated_at | DATETIME |
tfs_race_feature60 fields| 論理名 | 物理名 | データ型 | データ種別 | レコード種別 | JVData項目名 |
|---|---|---|---|---|---|
| tfs_race_feature_id | tfs_race_feature_id | BIGINT | |||
| tfs_job_id | tfs_job_id | BIGINT | |||
| race_id | race_id | BIGINT | |||
| race_date | race_date | DATE | |||
| quality_status | quality_status | VARCHAR(16) | |||
| created_at | created_at | DATETIME | |||
| updated_at | updated_at | DATETIME | |||
| member_entry_count | member_entry_count | INT | |||
| member_surface_distance_low_confidence_count | member_surface_distance_low_confidence_count | INT | |||
| member_overall_tai_valid_count | member_overall_tai_valid_count | INT | |||
| member_overall_tai_mean | member_overall_tai_mean | DECIMAL(7,3) | |||
| member_overall_tai_median | member_overall_tai_median | DECIMAL(7,3) | |||
| member_overall_tai_stddev | member_overall_tai_stddev | DECIMAL(7,3) | |||
| member_overall_tai_max | member_overall_tai_max | DECIMAL(7,3) | |||
| member_overall_tai_top3_mean | member_overall_tai_top3_mean | DECIMAL(7,3) | |||
| member_overall_tai_top1_top2_gap | member_overall_tai_top1_top2_gap | DECIMAL(7,3) | |||
| member_surface_distance_tai_valid_count | member_surface_distance_tai_valid_count | INT | |||
| member_surface_distance_tai_mean | member_surface_distance_tai_mean | DECIMAL(7,3) | |||
| member_surface_distance_tai_median | member_surface_distance_tai_median | DECIMAL(7,3) | |||
| member_surface_distance_tai_stddev | member_surface_distance_tai_stddev | DECIMAL(7,3) | |||
| member_surface_distance_tai_max | member_surface_distance_tai_max | DECIMAL(7,3) | |||
| member_surface_distance_tai_top3_mean | member_surface_distance_tai_top3_mean | DECIMAL(7,3) | |||
| member_surface_distance_tai_top1_top2_gap | member_surface_distance_tai_top1_top2_gap | DECIMAL(7,3) | |||
| member_surface_distance_epi_valid_count | member_surface_distance_epi_valid_count | INT | |||
| member_surface_distance_epi_mean | member_surface_distance_epi_mean | DECIMAL(7,3) | |||
| member_surface_distance_epi_median | member_surface_distance_epi_median | DECIMAL(7,3) | |||
| member_surface_distance_epi_stddev | member_surface_distance_epi_stddev | DECIMAL(7,3) | |||
| member_surface_distance_epi_max | member_surface_distance_epi_max | DECIMAL(7,3) | |||
| member_surface_distance_epi_top3_mean | member_surface_distance_epi_top3_mean | DECIMAL(7,3) | |||
| member_surface_distance_epi_top1_top2_gap | member_surface_distance_epi_top1_top2_gap | DECIMAL(7,3) | |||
| member_surface_distance_lpi_valid_count | member_surface_distance_lpi_valid_count | INT | |||
| member_surface_distance_lpi_mean | member_surface_distance_lpi_mean | DECIMAL(7,3) | |||
| member_surface_distance_lpi_median | member_surface_distance_lpi_median | DECIMAL(7,3) | |||
| member_surface_distance_lpi_stddev | member_surface_distance_lpi_stddev | DECIMAL(7,3) | |||
| member_surface_distance_lpi_max | member_surface_distance_lpi_max | DECIMAL(7,3) | |||
| member_surface_distance_lpi_top3_mean | member_surface_distance_lpi_top3_mean | DECIMAL(7,3) | |||
| member_surface_distance_lpi_top1_top2_gap | member_surface_distance_lpi_top1_top2_gap | DECIMAL(7,3) | |||
| member_surface_distance_spi_valid_count | member_surface_distance_spi_valid_count | INT | |||
| member_surface_distance_spi_mean | member_surface_distance_spi_mean | DECIMAL(7,3) | |||
| member_surface_distance_spi_median | member_surface_distance_spi_median | DECIMAL(7,3) | |||
| member_surface_distance_spi_stddev | member_surface_distance_spi_stddev | DECIMAL(7,3) | |||
| member_surface_distance_spi_max | member_surface_distance_spi_max | DECIMAL(7,3) | |||
| member_surface_distance_spi_top3_mean | member_surface_distance_spi_top3_mean | DECIMAL(7,3) | |||
| member_surface_distance_spi_top1_top2_gap | member_surface_distance_spi_top1_top2_gap | DECIMAL(7,3) | |||
| member_surface_distance_kri_valid_count | member_surface_distance_kri_valid_count | INT | |||
| member_surface_distance_kri_mean | member_surface_distance_kri_mean | DECIMAL(7,3) | |||
| member_surface_distance_kri_median | member_surface_distance_kri_median | DECIMAL(7,3) | |||
| member_surface_distance_kri_stddev | member_surface_distance_kri_stddev | DECIMAL(7,3) | |||
| member_surface_distance_kri_max | member_surface_distance_kri_max | DECIMAL(7,3) | |||
| member_surface_distance_kri_top3_mean | member_surface_distance_kri_top3_mean | DECIMAL(7,3) | |||
| member_surface_distance_kri_top1_top2_gap | member_surface_distance_kri_top1_top2_gap | DECIMAL(7,3) | |||
| member_ability_variability_valid_count | member_ability_variability_valid_count | INT | |||
| member_ability_variability_mad_z_mean | member_ability_variability_mad_z_mean | DECIMAL(7,3) | |||
| member_ability_variability_mad_z_median | member_ability_variability_mad_z_median | DECIMAL(7,3) | |||
| member_style_valid_horse_count | member_style_valid_horse_count | INT | |||
| member_style_coverage_rate | member_style_coverage_rate | DECIMAL(7,6) | |||
| member_nige_style_rate_sum | member_nige_style_rate_sum | DECIMAL(8,6) | |||
| member_senko_style_rate_sum | member_senko_style_rate_sum | DECIMAL(8,6) | |||
| member_sashi_style_rate_sum | member_sashi_style_rate_sum | DECIMAL(8,6) | |||
| member_oikomi_style_rate_sum | member_oikomi_style_rate_sum | DECIMAL(8,6) |
tfs_race_horse_feature172 fields| 論理名 | 物理名 | データ型 | データ種別 | レコード種別 | JVData項目名 |
|---|---|---|---|---|---|
| tfs_race_horse_feature_id | tfs_race_horse_feature_id | BIGINT | |||
| tfs_job_id | tfs_job_id | BIGINT | |||
| tfs_race_feature_id | tfs_race_feature_id | BIGINT | |||
| race_id | race_id | BIGINT | |||
| race_horse_id | race_horse_id | BIGINT | |||
| horse_id | horse_id | BIGINT | |||
| race_date | race_date | DATE | |||
| quality_status | quality_status | VARCHAR(16) | |||
| created_at | created_at | DATETIME | |||
| updated_at | updated_at | DATETIME | |||
| previous_race_id | previous_race_id | BIGINT | |||
| previous_race_horse_id | previous_race_horse_id | BIGINT | |||
| previous_run_found_flag | previous_run_found_flag | TINYINT(1) | |||
| previous_run_type_cd | previous_run_type_cd | VARCHAR(32) | |||
| previous_run_status_cd | previous_run_status_cd | VARCHAR(32) | |||
| previous_run_interval_days | previous_run_interval_days | INT | |||
| previous_run_calendar_week_diff_count | previous_run_calendar_week_diff_count | SMALLINT | |||
| rotation_interval_category_cd | rotation_interval_category_cd | VARCHAR(32) | |||
| first_start_flag | first_start_flag | TINYINT(1) | |||
| layoff_return_flag | layoff_return_flag | TINYINT(1) | |||
| run_count_since_layoff | run_count_since_layoff | SMALLINT | |||
| distance_diff_m | distance_diff_m | SMALLINT | |||
| distance_change_rate | distance_change_rate | DECIMAL(8,5) | |||
| distance_change_type_cd | distance_change_type_cd | VARCHAR(32) | |||
| surface_change_type_cd | surface_change_type_cd | VARCHAR(32) | |||
| racecourse_change_flag | racecourse_change_flag | TINYINT(1) | |||
| class_change_type_cd | class_change_type_cd | VARCHAR(32) | |||
| class_change_step | class_change_step | SMALLINT | |||
| class_comparable_flag | class_comparable_flag | TINYINT(1) | |||
| carried_weight_diff_kg | carried_weight_diff_kg | DECIMAL(5,1) | |||
| jockey_change_flag | jockey_change_flag | TINYINT(1) | |||
| trainer_change_flag | trainer_change_flag | TINYINT(1) | |||
| blinker_change_type_cd | blinker_change_type_cd | VARCHAR(32) | |||
| apprentice_change_flag | apprentice_change_flag | TINYINT(1) | |||
| training_last_valid_datetime | training_last_valid_datetime | DATETIME | |||
| training_last_valid_type_cd | training_last_valid_type_cd | VARCHAR(16) | |||
| training_last_valid_days_before_race | training_last_valid_days_before_race | INT | |||
| training_last_valid_hours_before_race | training_last_valid_hours_before_race | DECIMAL(10,2) | |||
| training_source_status_cd | training_source_status_cd | VARCHAR(32) | |||
| hc_training_source_status_cd | hc_training_source_status_cd | VARCHAR(32) | |||
| wc_training_source_status_cd | wc_training_source_status_cd | VARCHAR(32) | |||
| training_source_count_7d | training_source_count_7d | INT | |||
| training_valid_source_count_7d | training_valid_source_count_7d | INT | |||
| training_valid_distinct_day_count_7d | training_valid_distinct_day_count_7d | INT | |||
| hc_training_valid_source_count_7d | hc_training_valid_source_count_7d | INT | |||
| wc_training_valid_source_count_7d | wc_training_valid_source_count_7d | INT | |||
| training_source_count_14d | training_source_count_14d | INT | |||
| training_valid_source_count_14d | training_valid_source_count_14d | INT | |||
| training_valid_distinct_day_count_14d | training_valid_distinct_day_count_14d | INT | |||
| hc_training_valid_source_count_14d | hc_training_valid_source_count_14d | INT | |||
| wc_training_valid_source_count_14d | wc_training_valid_source_count_14d | INT | |||
| training_source_count_28d | training_source_count_28d | INT | |||
| training_valid_source_count_28d | training_valid_source_count_28d | INT | |||
| training_valid_distinct_day_count_28d | training_valid_distinct_day_count_28d | INT | |||
| hc_training_valid_source_count_28d | hc_training_valid_source_count_28d | INT | |||
| wc_training_valid_source_count_28d | wc_training_valid_source_count_28d | INT | |||
| training_valid_source_count_since_previous_run | training_valid_source_count_since_previous_run | INT | |||
| training_valid_distinct_day_count_since_previous_run | training_valid_distinct_day_count_since_previous_run | INT | |||
| hc_training_valid_source_count_since_previous_run | hc_training_valid_source_count_since_previous_run | INT | |||
| wc_training_valid_source_count_since_previous_run | wc_training_valid_source_count_since_previous_run | INT | |||
| hc_training_last_valid_datetime | hc_training_last_valid_datetime | DATETIME | |||
| hc_training_last_valid_center_cd | hc_training_last_valid_center_cd | CHAR(1) | |||
| hc_training_last_valid_days_before_race | hc_training_last_valid_days_before_race | INT | |||
| hc_training_last_valid_4f_sec | hc_training_last_valid_4f_sec | DECIMAL(8,3) | |||
| hc_training_last_valid_3f_sec | hc_training_last_valid_3f_sec | DECIMAL(8,3) | |||
| hc_training_last_valid_2f_sec | hc_training_last_valid_2f_sec | DECIMAL(8,3) | |||
| hc_training_last_valid_1f_sec | hc_training_last_valid_1f_sec | DECIMAL(8,3) | |||
| hc_training_last_valid_lap_800_600_sec | hc_training_last_valid_lap_800_600_sec | DECIMAL(8,3) | |||
| hc_training_last_valid_lap_600_400_sec | hc_training_last_valid_lap_600_400_sec | DECIMAL(8,3) | |||
| hc_training_last_valid_lap_400_200_sec | hc_training_last_valid_lap_400_200_sec | DECIMAL(8,3) | |||
| hc_training_last_valid_1f_accel_sec | hc_training_last_valid_1f_accel_sec | DECIMAL(8,3) | |||
| hc_training_last_valid_2f_half_accel_sec | hc_training_last_valid_2f_half_accel_sec | DECIMAL(8,3) | |||
| wc_training_last_valid_datetime | wc_training_last_valid_datetime | DATETIME | |||
| wc_training_last_valid_center_cd | wc_training_last_valid_center_cd | CHAR(1) | |||
| wc_training_last_valid_course_cd | wc_training_last_valid_course_cd | CHAR(1) | |||
| wc_training_last_valid_direction_cd | wc_training_last_valid_direction_cd | CHAR(1) | |||
| wc_training_last_valid_days_before_race | wc_training_last_valid_days_before_race | INT | |||
| wc_training_last_valid_6f_sec | wc_training_last_valid_6f_sec | DECIMAL(8,3) | |||
| wc_training_last_valid_5f_sec | wc_training_last_valid_5f_sec | DECIMAL(8,3) | |||
| wc_training_last_valid_4f_sec | wc_training_last_valid_4f_sec | DECIMAL(8,3) | |||
| wc_training_last_valid_3f_sec | wc_training_last_valid_3f_sec | DECIMAL(8,3) | |||
| wc_training_last_valid_2f_sec | wc_training_last_valid_2f_sec | DECIMAL(8,3) | |||
| wc_training_last_valid_1f_sec | wc_training_last_valid_1f_sec | DECIMAL(8,3) | |||
| wc_training_last_valid_lap_1200_1000_sec | wc_training_last_valid_lap_1200_1000_sec | DECIMAL(8,3) | |||
| wc_training_last_valid_lap_1000_800_sec | wc_training_last_valid_lap_1000_800_sec | DECIMAL(8,3) | |||
| wc_training_last_valid_lap_800_600_sec | wc_training_last_valid_lap_800_600_sec | DECIMAL(8,3) | |||
| wc_training_last_valid_lap_600_400_sec | wc_training_last_valid_lap_600_400_sec | DECIMAL(8,3) | |||
| wc_training_last_valid_lap_400_200_sec | wc_training_last_valid_lap_400_200_sec | DECIMAL(8,3) | |||
| wc_training_last_valid_1f_accel_sec | wc_training_last_valid_1f_accel_sec | DECIMAL(8,3) | |||
| wc_training_last_valid_2f_half_accel_sec | wc_training_last_valid_2f_half_accel_sec | DECIMAL(8,3) | |||
| hc_training_last_valid_4f_vs_horse_median_sec | hc_training_last_valid_4f_vs_horse_median_sec | DECIMAL(8,3) | |||
| hc_training_last_valid_1f_vs_horse_median_sec | hc_training_last_valid_1f_vs_horse_median_sec | DECIMAL(8,3) | |||
| wc_training_last_valid_6f_vs_horse_median_sec | wc_training_last_valid_6f_vs_horse_median_sec | DECIMAL(8,3) | |||
| wc_training_last_valid_1f_vs_horse_median_sec | wc_training_last_valid_1f_vs_horse_median_sec | DECIMAL(8,3) | |||
| hc_training_4f_horse_median_source_count | hc_training_4f_horse_median_source_count | INT | |||
| hc_training_1f_horse_median_source_count | hc_training_1f_horse_median_source_count | INT | |||
| wc_training_6f_horse_median_source_count | wc_training_6f_horse_median_source_count | INT | |||
| wc_training_1f_horse_median_source_count | wc_training_1f_horse_median_source_count | INT | |||
| jockey_source_status_cd | jockey_source_status_cd | VARCHAR(32) | |||
| jockey_year_surface_start_count | jockey_year_surface_start_count | INT | |||
| jockey_year_surface_win_rate | jockey_year_surface_win_rate | DECIMAL(7,6) | |||
| jockey_year_surface_top2_rate | jockey_year_surface_top2_rate | DECIMAL(7,6) | |||
| jockey_year_surface_top3_rate | jockey_year_surface_top3_rate | DECIMAL(7,6) | |||
| jockey_year_distance_start_count | jockey_year_distance_start_count | INT | |||
| jockey_year_distance_win_rate | jockey_year_distance_win_rate | DECIMAL(7,6) | |||
| jockey_year_distance_top2_rate | jockey_year_distance_top2_rate | DECIMAL(7,6) | |||
| jockey_year_distance_top3_rate | jockey_year_distance_top3_rate | DECIMAL(7,6) | |||
| jockey_year_racecourse_surface_start_count | jockey_year_racecourse_surface_start_count | INT | |||
| jockey_year_racecourse_surface_win_rate | jockey_year_racecourse_surface_win_rate | DECIMAL(7,6) | |||
| jockey_year_racecourse_surface_top2_rate | jockey_year_racecourse_surface_top2_rate | DECIMAL(7,6) | |||
| jockey_year_racecourse_surface_top3_rate | jockey_year_racecourse_surface_top3_rate | DECIMAL(7,6) | |||
| jockey_career_surface_start_count | jockey_career_surface_start_count | INT | |||
| jockey_career_surface_win_rate | jockey_career_surface_win_rate | DECIMAL(7,6) | |||
| jockey_career_surface_top2_rate | jockey_career_surface_top2_rate | DECIMAL(7,6) | |||
| jockey_career_surface_top3_rate | jockey_career_surface_top3_rate | DECIMAL(7,6) | |||
| jockey_career_distance_start_count | jockey_career_distance_start_count | INT | |||
| jockey_career_distance_win_rate | jockey_career_distance_win_rate | DECIMAL(7,6) | |||
| jockey_career_distance_top2_rate | jockey_career_distance_top2_rate | DECIMAL(7,6) | |||
| jockey_career_distance_top3_rate | jockey_career_distance_top3_rate | DECIMAL(7,6) | |||
| jockey_career_racecourse_surface_start_count | jockey_career_racecourse_surface_start_count | INT | |||
| jockey_career_racecourse_surface_win_rate | jockey_career_racecourse_surface_win_rate | DECIMAL(7,6) | |||
| jockey_career_racecourse_surface_top2_rate | jockey_career_racecourse_surface_top2_rate | DECIMAL(7,6) | |||
| jockey_career_racecourse_surface_top3_rate | jockey_career_racecourse_surface_top3_rate | DECIMAL(7,6) | |||
| trainer_source_status_cd | trainer_source_status_cd | VARCHAR(32) | |||
| trainer_year_surface_start_count | trainer_year_surface_start_count | INT | |||
| trainer_year_surface_win_rate | trainer_year_surface_win_rate | DECIMAL(7,6) | |||
| trainer_year_surface_top2_rate | trainer_year_surface_top2_rate | DECIMAL(7,6) | |||
| trainer_year_surface_top3_rate | trainer_year_surface_top3_rate | DECIMAL(7,6) | |||
| trainer_year_distance_start_count | trainer_year_distance_start_count | INT | |||
| trainer_year_distance_win_rate | trainer_year_distance_win_rate | DECIMAL(7,6) | |||
| trainer_year_distance_top2_rate | trainer_year_distance_top2_rate | DECIMAL(7,6) | |||
| trainer_year_distance_top3_rate | trainer_year_distance_top3_rate | DECIMAL(7,6) | |||
| trainer_year_racecourse_surface_start_count | trainer_year_racecourse_surface_start_count | INT | |||
| trainer_year_racecourse_surface_win_rate | trainer_year_racecourse_surface_win_rate | DECIMAL(7,6) | |||
| trainer_year_racecourse_surface_top2_rate | trainer_year_racecourse_surface_top2_rate | DECIMAL(7,6) | |||
| trainer_year_racecourse_surface_top3_rate | trainer_year_racecourse_surface_top3_rate | DECIMAL(7,6) | |||
| trainer_career_surface_start_count | trainer_career_surface_start_count | INT | |||
| trainer_career_surface_win_rate | trainer_career_surface_win_rate | DECIMAL(7,6) | |||
| trainer_career_surface_top2_rate | trainer_career_surface_top2_rate | DECIMAL(7,6) | |||
| trainer_career_surface_top3_rate | trainer_career_surface_top3_rate | DECIMAL(7,6) | |||
| trainer_career_distance_start_count | trainer_career_distance_start_count | INT | |||
| trainer_career_distance_win_rate | trainer_career_distance_win_rate | DECIMAL(7,6) | |||
| trainer_career_distance_top2_rate | trainer_career_distance_top2_rate | DECIMAL(7,6) | |||
| trainer_career_distance_top3_rate | trainer_career_distance_top3_rate | DECIMAL(7,6) | |||
| trainer_career_racecourse_surface_start_count | trainer_career_racecourse_surface_start_count | INT | |||
| trainer_career_racecourse_surface_win_rate | trainer_career_racecourse_surface_win_rate | DECIMAL(7,6) | |||
| trainer_career_racecourse_surface_top2_rate | trainer_career_racecourse_surface_top2_rate | DECIMAL(7,6) | |||
| trainer_career_racecourse_surface_top3_rate | trainer_career_racecourse_surface_top3_rate | DECIMAL(7,6) | |||
| horse_style_source_status_cd | horse_style_source_status_cd | VARCHAR(32) | |||
| horse_style_source_count | horse_style_source_count | INT | |||
| nige_style_rate | nige_style_rate | DECIMAL(7,6) | |||
| senko_style_rate | senko_style_rate | DECIMAL(7,6) | |||
| sashi_style_rate | sashi_style_rate | DECIMAL(7,6) | |||
| oikomi_style_rate | oikomi_style_rate | DECIMAL(7,6) | |||
| member_overall_tai_rank | member_overall_tai_rank | SMALLINT | |||
| member_overall_tai_mean_diff | member_overall_tai_mean_diff | DECIMAL(7,3) | |||
| member_overall_tai_max_diff | member_overall_tai_max_diff | DECIMAL(7,3) | |||
| member_surface_distance_tai_rank | member_surface_distance_tai_rank | SMALLINT | |||
| member_surface_distance_tai_mean_diff | member_surface_distance_tai_mean_diff | DECIMAL(7,3) | |||
| member_surface_distance_tai_max_diff | member_surface_distance_tai_max_diff | DECIMAL(7,3) | |||
| member_surface_distance_epi_rank | member_surface_distance_epi_rank | SMALLINT | |||
| member_surface_distance_epi_mean_diff | member_surface_distance_epi_mean_diff | DECIMAL(7,3) | |||
| member_surface_distance_epi_max_diff | member_surface_distance_epi_max_diff | DECIMAL(7,3) | |||
| member_surface_distance_lpi_rank | member_surface_distance_lpi_rank | SMALLINT | |||
| member_surface_distance_lpi_mean_diff | member_surface_distance_lpi_mean_diff | DECIMAL(7,3) | |||
| member_surface_distance_lpi_max_diff | member_surface_distance_lpi_max_diff | DECIMAL(7,3) | |||
| member_surface_distance_spi_rank | member_surface_distance_spi_rank | SMALLINT | |||
| member_surface_distance_spi_mean_diff | member_surface_distance_spi_mean_diff | DECIMAL(7,3) | |||
| member_surface_distance_spi_max_diff | member_surface_distance_spi_max_diff | DECIMAL(7,3) | |||
| member_surface_distance_kri_rank | member_surface_distance_kri_rank | SMALLINT | |||
| member_surface_distance_kri_mean_diff | member_surface_distance_kri_mean_diff | DECIMAL(7,3) | |||
| member_surface_distance_kri_max_diff | member_surface_distance_kri_max_diff | DECIMAL(7,3) |
tai_h_data_quality_issue10 fields| 論理名 | 物理名 | データ型 | データ種別 | レコード種別 | JVData項目名 |
|---|---|---|---|---|---|
| tai_h_issue_id | tai_h_issue_id | BIGINT | |||
| tai_h_job_id | tai_h_job_id | BIGINT | |||
| tai_h_chunk_id | tai_h_chunk_id | BIGINT | |||
| issue_level | issue_level | VARCHAR(16) | |||
| issue_code | issue_code | VARCHAR(64) | |||
| race_id | race_id | BIGINT | |||
| race_horse_id | race_horse_id | BIGINT | |||
| issue_message | issue_message | VARCHAR(512) | |||
| detail_json | detail_json | JSON | |||
| occurred_at | occurred_at | DATETIME |
tai_h_job_chunk13 fields| 論理名 | 物理名 | データ型 | データ種別 | レコード種別 | JVData項目名 |
|---|---|---|---|---|---|
| tai_h_chunk_id | tai_h_chunk_id | BIGINT | |||
| tai_h_job_id | tai_h_job_id | BIGINT | |||
| chunk_no | chunk_no | INT UNSIGNED | |||
| race_id | race_id | BIGINT | |||
| calc_status | calc_status | VARCHAR(32) | |||
| target_race_horse_count | target_race_horse_count | INT UNSIGNED | |||
| processed_race_horse_count | processed_race_horse_count | INT UNSIGNED | |||
| error_type | error_type | VARCHAR(128) | |||
| error_message | error_message | VARCHAR(512) | |||
| started_at | started_at | DATETIME | |||
| finished_at | finished_at | DATETIME | |||
| created_at | created_at | DATETIME | |||
| updated_at | updated_at | DATETIME |
tai_h_job_run18 fields| 論理名 | 物理名 | データ型 | データ種別 | レコード種別 | JVData項目名 |
|---|---|---|---|---|---|
| tai_h_job_id | tai_h_job_id | BIGINT | |||
| formula_spec_version | formula_spec_version | VARCHAR(32) | |||
| formula_algorithm_version | formula_algorithm_version | VARCHAR(32) | |||
| target_from_date | target_from_date | DATE | |||
| target_to_date | target_to_date | DATE | |||
| calc_status | calc_status | VARCHAR(32) | |||
| target_race_count | target_race_count | INT UNSIGNED | |||
| success_race_count | success_race_count | INT UNSIGNED | |||
| target_race_horse_count | target_race_horse_count | INT UNSIGNED | |||
| success_race_horse_count | success_race_horse_count | INT UNSIGNED | |||
| issue_count | issue_count | INT UNSIGNED | |||
| worker_pid | worker_pid | INT UNSIGNED | |||
| error_type | error_type | VARCHAR(128) | |||
| error_message | error_message | VARCHAR(1024) | |||
| started_at | started_at | DATETIME | |||
| finished_at | finished_at | DATETIME | |||
| created_at | created_at | DATETIME | |||
| updated_at | updated_at | DATETIME |
tai_h_processing_control7 fields| 論理名 | 物理名 | データ型 | データ種別 | レコード種別 | JVData項目名 |
|---|---|---|---|---|---|
| control_id | control_id | TINYINT UNSIGNED | |||
| formula_spec_version | formula_spec_version | VARCHAR(32) | |||
| formula_algorithm_version | formula_algorithm_version | VARCHAR(32) | |||
| active_tai_h_job_id | active_tai_h_job_id | BIGINT | |||
| worker_pid | worker_pid | INT UNSIGNED | |||
| last_success_at | last_success_at | DATETIME | |||
| updated_at | updated_at | DATETIME |
tai_h_race_checkpoint18 fields| 論理名 | 物理名 | データ型 | データ種別 | レコード種別 | JVData項目名 |
|---|---|---|---|---|---|
| race_id | race_id | BIGINT | |||
| race_date | race_date | DATE | |||
| calc_status | calc_status | VARCHAR(32) | |||
| source_taf_job_id | source_taf_job_id | BIGINT | |||
| source_tfs_job_id | source_tfs_job_id | BIGINT | |||
| source_revision | source_revision | BIGINT UNSIGNED | |||
| source_stage | source_stage | VARCHAR(16) | |||
| source_fingerprint | source_fingerprint | CHAR(64) | |||
| formula_spec_version | formula_spec_version | VARCHAR(32) | |||
| formula_algorithm_version | formula_algorithm_version | VARCHAR(32) | |||
| target_race_horse_count | target_race_horse_count | INT UNSIGNED | |||
| written_race_horse_count | written_race_horse_count | INT UNSIGNED | |||
| last_tai_h_job_id | last_tai_h_job_id | BIGINT | |||
| last_tai_h_chunk_id | last_tai_h_chunk_id | BIGINT | |||
| started_at | started_at | DATETIME | |||
| completed_at | completed_at | DATETIME | |||
| error_type | error_type | VARCHAR(128) | |||
| updated_at | updated_at | DATETIME |
tai_h_race_horse_feature25 fields| 論理名 | 物理名 | データ型 | データ種別 | レコード種別 | JVData項目名 |
|---|---|---|---|---|---|
| tai_h_race_horse_feature_id | tai_h_race_horse_feature_id | BIGINT | |||
| tai_h_job_id | tai_h_job_id | BIGINT | |||
| race_id | race_id | BIGINT | |||
| race_horse_id | race_horse_id | BIGINT | |||
| horse_id | horse_id | BIGINT | |||
| race_date | race_date | DATE | |||
| source_taf_snapshot_id | source_taf_snapshot_id | BIGINT | |||
| source_tfs_race_horse_feature_id | source_tfs_race_horse_feature_id | BIGINT | |||
| tai_base | tai_base | DECIMAL(12,9) | |||
| training_form_z | training_form_z | DECIMAL(12,9) | |||
| training_adjustment | training_adjustment | DECIMAL(12,9) | |||
| jockey_raw_score | jockey_raw_score | DECIMAL(12,9) | |||
| jockey_score_z | jockey_score_z | DECIMAL(12,9) | |||
| jockey_adjustment | jockey_adjustment | DECIMAL(12,9) | |||
| trainer_raw_score | trainer_raw_score | DECIMAL(12,9) | |||
| trainer_score_z | trainer_score_z | DECIMAL(12,9) | |||
| trainer_adjustment | trainer_adjustment | DECIMAL(12,9) | |||
| raw_adjustment | raw_adjustment | DECIMAL(12,9) | |||
| tai_h_adjustment | tai_h_adjustment | DECIMAL(12,9) | |||
| tai_h_index | tai_h_index | DECIMAL(12,9) | |||
| tai_h_z | tai_h_z | DECIMAL(12,9) | |||
| tai_h_rank | tai_h_rank | SMALLINT UNSIGNED | |||
| risk_codes_json | risk_codes_json | JSON | |||
| created_at | created_at | DATETIME | |||
| updated_at | updated_at | DATETIME |
ability_bundle_date_checkpoint13 fields| 論理名 | 物理名 | データ型 | データ種別 | レコード種別 | JVData項目名 |
|---|---|---|---|---|---|
| ability_bundle_install_id | ability_bundle_install_id | BIGINT | |||
| race_date | race_date | DATE | |||
| checkpoint_status | checkpoint_status | VARCHAR(32) | |||
| business_value_sha256 | business_value_sha256 | CHAR(64) | |||
| taf_race_count | taf_race_count | INT UNSIGNED | |||
| taf_race_horse_count | taf_race_horse_count | INT UNSIGNED | |||
| taf_snapshot_count | taf_snapshot_count | INT UNSIGNED | |||
| tfs_race_count | tfs_race_count | INT UNSIGNED | |||
| tfs_race_horse_count | tfs_race_horse_count | INT UNSIGNED | |||
| tai_h_race_count | tai_h_race_count | INT UNSIGNED | |||
| tai_h_race_horse_count | tai_h_race_horse_count | INT UNSIGNED | |||
| committed_at | committed_at | DATETIME | |||
| updated_at | updated_at | DATETIME |
ability_bundle_install23 fields| 論理名 | 物理名 | データ型 | データ種別 | レコード種別 | JVData項目名 |
|---|---|---|---|---|---|
| ability_bundle_install_id | ability_bundle_install_id | BIGINT | |||
| setup_run_id | setup_run_id | BIGINT | |||
| bundle_id | bundle_id | VARCHAR(96) | |||
| manifest_sha256 | manifest_sha256 | CHAR(64) | |||
| target_from_date | target_from_date | DATE | |||
| target_to_date | target_to_date | DATE | |||
| bundle_data_from_date | bundle_data_from_date | DATE | |||
| bundle_data_to_date | bundle_data_to_date | DATE | |||
| install_stage | install_stage | VARCHAR(32) | |||
| install_status | install_status | VARCHAR(32) | |||
| last_completed_date | last_completed_date | DATE | |||
| taf_job_id | taf_job_id | BIGINT | |||
| tfs_job_id | tfs_job_id | BIGINT | |||
| tai_h_job_id | tai_h_job_id | BIGINT | |||
| imported_race_count | imported_race_count | INT UNSIGNED | |||
| imported_race_horse_count | imported_race_horse_count | INT UNSIGNED | |||
| imported_snapshot_count | imported_snapshot_count | INT UNSIGNED | |||
| imported_tai_h_race_count | imported_tai_h_race_count | INT UNSIGNED | |||
| imported_tai_h_race_horse_count | imported_tai_h_race_horse_count | INT UNSIGNED | |||
| failure_code | failure_code | VARCHAR(128) | |||
| started_at | started_at | DATETIME | |||
| completed_at | completed_at | DATETIME | |||
| updated_at | updated_at | DATETIME |
ability_bundle_race_origin11 fields| 論理名 | 物理名 | データ型 | データ種別 | レコード種別 | JVData項目名 |
|---|---|---|---|---|---|
| race_id | race_id | BIGINT | |||
| ability_bundle_install_id | ability_bundle_install_id | BIGINT | |||
| bundle_id | bundle_id | VARCHAR(96) | |||
| portable_identity_sha256 | portable_identity_sha256 | CHAR(64) | |||
| origin_type | origin_type | VARCHAR(32) | |||
| taf_job_id | taf_job_id | BIGINT | |||
| tfs_job_id | tfs_job_id | BIGINT | |||
| tai_h_job_id | tai_h_job_id | BIGINT | |||
| publish_ready | publish_ready | TINYINT(1) | |||
| created_at | created_at | DATETIME | |||
| updated_at | updated_at | DATETIME |
ability_source_date_revision5 fields| 論理名 | 物理名 | データ型 | データ種別 | レコード種別 | JVData項目名 |
|---|---|---|---|---|---|
| race_date | race_date | DATE | |||
| source_revision | source_revision | BIGINT UNSIGNED | |||
| source_stage | source_stage | VARCHAR(16) | |||
| revision_fingerprint | revision_fingerprint | CHAR(64) | |||
| updated_at | updated_at | DATETIME |
audit_jvlink_import_batch9 fields| 論理名 | 物理名 | データ型 | データ種別 | レコード種別 | JVData項目名 |
|---|---|---|---|---|---|
| 取込バッチID | import_batch_id | BIGINT | |||
| 取込モード | import_mode_cd | TINYINT UNSIGNED | |||
| 対象期間開始 | target_period_from | DATETIME | |||
| 対象期間終了 | target_period_to | DATETIME | |||
| 開始日時 | started_at | DATETIME | |||
| 終了日時 | ended_at | DATETIME | |||
| 取込状態 | import_status_cd | TINYINT UNSIGNED | |||
| Error件数 | error_count | INT UNSIGNED | |||
| Warning件数 | warning_count | INT UNSIGNED |
audit_jvlink_import_execution19 fields| 論理名 | 物理名 | データ型 | データ種別 | レコード種別 | JVData項目名 |
|---|---|---|---|---|---|
| 物理実行ID | import_execution_id | BIGINT | |||
| 取込ジョブID | import_job_id | BIGINT | |||
| 実行順序 | execution_seq_no | INT UNSIGNED | |||
| 処理Passコード | import_pass_cd | VARCHAR(32) | |||
| 期間チャンク番号 | period_chunk_no | INT UNSIGNED | |||
| JVOpen option | jvopen_option | TINYINT UNSIGNED | |||
| fromtime | fromtime_value | VARCHAR(29) | |||
| 実行前lastfiletimestamp | lastfiletimestamp_before | VARCHAR(14) | |||
| 実行後lastfiletimestamp | lastfiletimestamp_after | VARCHAR(14) | |||
| 開始日時 | started_at | DATETIME | |||
| 終了日時 | ended_at | DATETIME | |||
| 実行状態 | execution_status_cd | TINYINT UNSIGNED | |||
| 読込ファイル数 | read_file_count | INT UNSIGNED | |||
| ダウンロードファイル数 | download_file_count | INT UNSIGNED | |||
| 読込レコード数 | read_record_count | INT UNSIGNED | |||
| JVSkip件数 | jvskip_count | INT UNSIGNED | |||
| Warning件数 | warning_count | INT UNSIGNED | |||
| Error件数 | error_count | INT UNSIGNED | |||
| JV-Link戻り値 | jvlink_return_code | INT |
audit_jvlink_import_issue12 fields| 論理名 | 物理名 | データ型 | データ種別 | レコード種別 | JVData項目名 |
|---|---|---|---|---|---|
| 取込Issue ID | import_issue_id | BIGINT | |||
| 取込ジョブID | import_job_id | BIGINT | |||
| 物理実行ID | import_execution_id | BIGINT | |||
| issueレベル | issue_level_cd | TINYINT UNSIGNED | |||
| issueコード | issue_code | VARCHAR(64) | |||
| RecordSpecコード | recordspec_cd | VARCHAR(2) | |||
| データ区分raw値 | data_kubun_cd | CHAR(1) | |||
| 読込順序 | source_record_seq_no | INT UNSIGNED | |||
| ソース業務キー | source_key_text | VARCHAR(512) | |||
| 反映先テーブル名 | target_table_name | VARCHAR(128) | |||
| issueメッセージ | issue_message | TEXT | |||
| 発生日時 | occurred_at | DATETIME |
audit_jvlink_import_job17 fields| 論理名 | 物理名 | データ型 | データ種別 | レコード種別 | JVData項目名 |
|---|---|---|---|---|---|
| 取込ジョブID | import_job_id | BIGINT | |||
| 取込バッチID | import_batch_id | BIGINT | |||
| DataSpecコード | dataspec_cd | VARCHAR(4) | |||
| JVOpen option | jvopen_option | TINYINT UNSIGNED | |||
| fromtime | fromtime_value | VARCHAR(29) | |||
| 実行前lastfiletimestamp | lastfiletimestamp_before | VARCHAR(14) | |||
| 実行後lastfiletimestamp | lastfiletimestamp_after | VARCHAR(14) | |||
| 開始日時 | started_at | DATETIME | |||
| 終了日時 | ended_at | DATETIME | |||
| 取込状態 | import_status_cd | TINYINT UNSIGNED | |||
| 読込レコード数 | read_record_count | INT UNSIGNED | |||
| INSERT件数 | insert_count | INT UNSIGNED | |||
| UPDATE件数 | update_count | INT UNSIGNED | |||
| DELETE件数 | delete_count | INT UNSIGNED | |||
| SKIP件数 | skip_count | INT UNSIGNED | |||
| Warning件数 | warning_count | INT UNSIGNED | |||
| Error件数 | error_count | INT UNSIGNED |
audit_jvlink_import_record_count12 fields| 論理名 | 物理名 | データ型 | データ種別 | レコード種別 | JVData項目名 |
|---|---|---|---|---|---|
| レコード件数監査ID | import_record_count_id | BIGINT | |||
| 取込ジョブID | import_job_id | BIGINT | |||
| RecordSpecコード | recordspec_cd | VARCHAR(2) | |||
| データ区分raw値 | data_kubun_cd | CHAR(1) | |||
| READ件数 | read_count | INT UNSIGNED | |||
| INSERT件数 | insert_count | INT UNSIGNED | |||
| UPDATE件数 | update_count | INT UNSIGNED | |||
| DELETE件数 | delete_count | INT UNSIGNED | |||
| SKIP件数 | skip_count | INT UNSIGNED | |||
| Warning件数 | warning_count | INT UNSIGNED | |||
| Error件数 | error_count | INT UNSIGNED | |||
| deferred_count | deferred_count | INT |
config_ck_legacy_recovery_state9 fields| 論理名 | 物理名 | データ型 | データ種別 | レコード種別 | JVData項目名 |
|---|---|---|---|---|---|
| recovery_version | recovery_version | INT | |||
| state | state | VARCHAR(24) | |||
| from_time | from_time | CHAR(14) | |||
| to_time | to_time | CHAR(14) | |||
| target_count | target_count | INT | |||
| missing_count | missing_count | INT | |||
| last_error | last_error | VARCHAR(512) | |||
| started_at | started_at | DATETIME(6) | |||
| completed_at | completed_at | DATETIME(6) |
config_ck_pending_finish12 fields| 論理名 | 物理名 | データ型 | データ種別 | レコード種別 | JVData項目名 |
|---|---|---|---|---|---|
| pending_finish_id | pending_finish_id | BIGINT | |||
| payload_id | payload_id | BIGINT | |||
| target_cd | target_cd | CHAR(1) | |||
| stats_scope_cd | stats_scope_cd | INT | |||
| category_cd | category_cd | VARCHAR(32) | |||
| condition_cd | condition_cd | VARCHAR(40) | |||
| first_count | first_count | INT | |||
| second_count | second_count | INT | |||
| third_count | third_count | INT | |||
| fourth_count | fourth_count | INT | |||
| fifth_count | fifth_count | INT | |||
| other_count | other_count | INT |
config_ck_pending_payload26 fields| 論理名 | 物理名 | データ型 | データ種別 | レコード種別 | JVData項目名 |
|---|---|---|---|---|---|
| payload_id | payload_id | BIGINT | |||
| receipt_id | receipt_id | BIGINT | |||
| payload_version | payload_version | INT | |||
| source_created_date | source_created_date | DATE | |||
| source_file_timestamp | source_file_timestamp | CHAR(14) | |||
| source_file_name | source_file_name | VARCHAR(255) | |||
| source_file_record_no | source_file_record_no | BIGINT | |||
| data_kubun_cd | data_kubun_cd | CHAR(1) | |||
| payload_hash | payload_hash | BINARY(32) | |||
| import_job_id | import_job_id | BIGINT | |||
| import_execution_id | import_execution_id | BIGINT | |||
| legacy_recovery_version | legacy_recovery_version | INT | |||
| warning_text | warning_text | TEXT | |||
| jockey_cd | jockey_cd | VARCHAR(5) | |||
| trainer_cd | trainer_cd | VARCHAR(5) | |||
| flat_main_prize_yen | flat_main_prize_yen | BIGINT | |||
| jump_main_prize_yen | jump_main_prize_yen | BIGINT | |||
| flat_added_prize_yen | flat_added_prize_yen | BIGINT | |||
| jump_added_prize_yen | jump_added_prize_yen | BIGINT | |||
| flat_earned_prize_yen | flat_earned_prize_yen | BIGINT | |||
| jump_earned_prize_yen | jump_earned_prize_yen | BIGINT | |||
| registered_race_count | registered_race_count | INT | |||
| nige_count | nige_count | INT | |||
| senko_count | senko_count | INT | |||
| sashi_count | sashi_count | INT | |||
| oikomi_count | oikomi_count | INT |
config_ck_pending_person9 fields| 論理名 | 物理名 | データ型 | データ種別 | レコード種別 | JVData項目名 |
|---|---|---|---|---|---|
| pending_person_id | pending_person_id | BIGINT | |||
| payload_id | payload_id | BIGINT | |||
| role_cd | role_cd | CHAR(1) | |||
| stats_scope_cd | stats_scope_cd | INT | |||
| stats_year | stats_year | INT | |||
| flat_main_prize_yen | flat_main_prize_yen | BIGINT | |||
| jump_main_prize_yen | jump_main_prize_yen | BIGINT | |||
| flat_added_prize_yen | flat_added_prize_yen | BIGINT | |||
| jump_added_prize_yen | jump_added_prize_yen | BIGINT |
config_ck_receipt_state24 fields| 論理名 | 物理名 | データ型 | データ種別 | レコード種別 | JVData項目名 |
|---|---|---|---|---|---|
| receipt_id | receipt_id | BIGINT | |||
| race_scope_cd | race_scope_cd | INT | |||
| race_date | race_date | DATE | |||
| racecourse_cd | racecourse_cd | CHAR(2) | |||
| meeting_no | meeting_no | INT | |||
| schedule_day_no | schedule_day_no | INT | |||
| race_no | race_no | INT | |||
| horse_reg_no | horse_reg_no | CHAR(10) | |||
| state | state | VARCHAR(32) | |||
| source_created_date | source_created_date | DATE | |||
| source_file_timestamp | source_file_timestamp | CHAR(14) | |||
| source_file_name | source_file_name | VARCHAR(255) | |||
| source_file_record_no | source_file_record_no | BIGINT | |||
| data_kubun_cd | data_kubun_cd | CHAR(1) | |||
| payload_version | payload_version | INT | |||
| payload_hash | payload_hash | BINARY(32) | |||
| import_job_id | import_job_id | BIGINT | |||
| import_execution_id | import_execution_id | BIGINT | |||
| evidence_import_issue_id | evidence_import_issue_id | BIGINT | |||
| legacy_recovery_version | legacy_recovery_version | INT | |||
| reason | reason | VARCHAR(512) | |||
| received_at | received_at | DATETIME(6) | |||
| updated_at | updated_at | DATETIME(6) | |||
| applied_at | applied_at | DATETIME(6) |
config_jvlink_import_cursor5 fields| 論理名 | 物理名 | データ型 | データ種別 | レコード種別 | JVData項目名 |
|---|---|---|---|---|---|
| DataSpecカーソルID | jvlink_import_cursor_id | BIGINT | |||
| DataSpecコード | dataspec_cd | VARCHAR(4) | |||
| 差分取得現在位置 | lastfiletimestamp | VARCHAR(14) | |||
| 最終正常終了ジョブID | last_success_import_job_id | BIGINT | |||
| 更新日時 | updated_at | DATETIME |
config_jvlink_import_state4 fields| 論理名 | 物理名 | データ型 | データ種別 | レコード種別 | JVData項目名 |
|---|---|---|---|---|---|
| 取込状態ID | jvlink_import_state_id | BIGINT | |||
| セットアップ完了フラグ | is_setup_completed | TINYINT(1) | |||
| セットアップ完了日時 | setup_completed_at | DATETIME | |||
| 更新日時 | updated_at | DATETIME |
config_ra_race_pace_pending7 fields| 論理名 | 物理名 | データ型 | データ種別 | レコード種別 | JVData項目名 |
|---|---|---|---|---|---|
| race_id | race_id | BIGINT | |||
| source_fingerprint | source_fingerprint | CHAR(64) | |||
| pending_reason_cd | pending_reason_cd | VARCHAR(40) | |||
| retry_count | retry_count | INT UNSIGNED | |||
| last_error_type | last_error_type | VARCHAR(128) | |||
| first_pending_at | first_pending_at | DATETIME(6) | |||
| last_pending_at | last_pending_at | DATETIME(6) |
config_race_record_state10 fields| 論理名 | 物理名 | データ型 | データ種別 | レコード種別 | JVData項目名 |
|---|---|---|---|---|---|
| race_scope_cd | race_scope_cd | INT | |||
| schedule_year | schedule_year | INT | |||
| racecourse_cd | racecourse_cd | VARCHAR(4) | |||
| meeting_no | meeting_no | INT | |||
| schedule_day_no | schedule_day_no | INT | |||
| race_no | race_no | INT | |||
| effective_source_race_date | effective_source_race_date | DATE | |||
| effective_state_cd | effective_state_cd | TINYINT | |||
| source_record_spec | source_record_spec | VARCHAR(2) | |||
| updated_at | updated_at | DATETIME(6) |
config_realtime_postrace_pending6 fields| 論理名 | 物理名 | データ型 | データ種別 | レコード種別 | JVData項目名 |
|---|---|---|---|---|---|
| race_id | race_id | BIGINT | |||
| first_pending_at | first_pending_at | DATETIME | |||
| last_pending_at | last_pending_at | DATETIME | |||
| retry_count | retry_count | INT UNSIGNED | |||
| last_import_job_id | last_import_job_id | BIGINT | |||
| last_issue_code | last_issue_code | VARCHAR(64) |
config_schedule_record_state7 fields| 論理名 | 物理名 | データ型 | データ種別 | レコード種別 | JVData項目名 |
|---|---|---|---|---|---|
| schedule_year | schedule_year | INT | |||
| racecourse_cd | racecourse_cd | VARCHAR(4) | |||
| meeting_no | meeting_no | INT | |||
| schedule_day_no | schedule_day_no | INT | |||
| effective_source_schedule_date | effective_source_schedule_date | DATE | |||
| effective_state_cd | effective_state_cd | TINYINT | |||
| updated_at | updated_at | DATETIME(6) |
config_schema_migration4 fields| 論理名 | 物理名 | データ型 | データ種別 | レコード種別 | JVData項目名 |
|---|---|---|---|---|---|
| マイグレーションID | migration_id | VARCHAR(64) | |||
| 適用日時 | applied_at | DATETIME | |||
| SQLチェックサム | checksum_sha256 | CHAR(64) | |||
| アプリケーションバージョン | app_version | VARCHAR(32) |
config_setup_resume_completed_unit15 fields| 論理名 | 物理名 | データ型 | データ種別 | レコード種別 | JVData項目名 |
|---|---|---|---|---|---|
| セットアップ再開完了単位ID | setup_resume_completed_unit_id | BIGINT | |||
| セットアップ実行ID | setup_run_id | BIGINT | |||
| セットアップ開始FromTime | setup_from_time | VARCHAR(14) | |||
| DataSpec | data_spec | VARCHAR(16) | |||
| 取込Pass | import_pass_cd | VARCHAR(32) | |||
| 期間チャンク番号 | period_chunk_no | INT UNSIGNED | |||
| JVOpen FromTime | jvopen_from_time | VARCHAR(29) | |||
| ログ表示用From | log_from_time | VARCHAR(14) | |||
| ログ表示用To | log_to_time | VARCHAR(14) | |||
| 成功後lastfiletimestamp | lastfiletimestamp_after | VARCHAR(14) | |||
| 実行結果コード | execution_status_cd | TINYINT UNSIGNED | |||
| 警告件数 | warning_count | INT UNSIGNED | |||
| エラー件数 | error_count | INT UNSIGNED | |||
| 取込実行ID | import_execution_id | BIGINT | |||
| 完了日時 | completed_at | DATETIME |
config_setup_resume_run9 fields| 論理名 | 物理名 | データ型 | データ種別 | レコード種別 | JVData項目名 |
|---|---|---|---|---|---|
| セットアップ実行ID | setup_run_id | BIGINT | |||
| セットアップ年数 | setup_years | TINYINT UNSIGNED | |||
| セットアップ開始FromTime | setup_from_time | VARCHAR(14) | |||
| 対象期間開始 | target_period_from | DATETIME | |||
| 対象期間終了 | target_period_to | DATETIME | |||
| 実行状態コード | run_status_cd | TINYINT UNSIGNED | |||
| 開始日時 | started_at | DATETIME | |||
| 完了日時 | completed_at | DATETIME | |||
| クリア日時 | cleared_at | DATETIME |
config_setup_resume_state13 fields| 論理名 | 物理名 | データ型 | データ種別 | レコード種別 | JVData項目名 |
|---|---|---|---|---|---|
| セットアップ再開状態ID | setup_resume_state_id | TINYINT UNSIGNED | |||
| セットアップ実行ID | setup_run_id | BIGINT | |||
| 再開状態コード | resume_status_cd | TINYINT UNSIGNED | |||
| セットアップ年数 | setup_years | TINYINT UNSIGNED | |||
| セットアップ開始FromTime | setup_from_time | VARCHAR(14) | |||
| 対象期間開始 | target_period_from | DATETIME | |||
| 対象期間終了 | target_period_to | DATETIME | |||
| 現在DataSpec | current_data_spec | VARCHAR(16) | |||
| 現在取込Pass | current_import_pass_cd | VARCHAR(32) | |||
| 現在期間チャンク番号 | current_period_chunk_no | INT UNSIGNED | |||
| 中断要求日時 | requested_stop_at | DATETIME | |||
| 中断完了日時 | paused_at | DATETIME | |||
| 更新日時 | updated_at | DATETIME |
user_free_note7 fields| 論理名 | 物理名 | データ型 | データ種別 | レコード種別 | JVData項目名 |
|---|---|---|---|---|---|
| note_id | note_id | CHAR(32) | |||
| title | title | VARCHAR(100) | |||
| body | body | MEDIUMTEXT | |||
| deleted | deleted | TINYINT(1) | |||
| revision | revision | BIGINT | |||
| created_at | created_at | DATETIME(6) | |||
| updated_at | updated_at | DATETIME(6) |
user_horse_memo12 fields| 論理名 | 物理名 | データ型 | データ種別 | レコード種別 | JVData項目名 |
|---|---|---|---|---|---|
| race_scope_cd | race_scope_cd | TINYINT UNSIGNED | |||
| schedule_year | schedule_year | SMALLINT UNSIGNED | |||
| racecourse_cd | racecourse_cd | CHAR(2) | |||
| meeting_no | meeting_no | TINYINT UNSIGNED | |||
| schedule_day_no | schedule_day_no | TINYINT UNSIGNED | |||
| race_no | race_no | TINYINT UNSIGNED | |||
| horse_reg_no | horse_reg_no | CHAR(10) | |||
| memo_text | memo_text | TEXT | |||
| prediction_mark_cd | prediction_mark_cd | VARCHAR(1) | |||
| race_date_at_save | race_date_at_save | DATE | |||
| created_at | created_at | DATETIME(6) | |||
| updated_at | updated_at | DATETIME(6) |
user_horse_memo_legacy4 fields| 論理名 | 物理名 | データ型 | データ種別 | レコード種別 | JVData項目名 |
|---|---|---|---|---|---|
| horse_reg_no | horse_reg_no | CHAR(10) | |||
| memo_text | memo_text | TEXT | |||
| created_at | created_at | DATETIME(6) | |||
| updated_at | updated_at | DATETIME(6) |
user_note_reference11 fields| 論理名 | 物理名 | データ型 | データ種別 | レコード種別 | JVData項目名 |
|---|---|---|---|---|---|
| race_scope_cd | race_scope_cd | TINYINT UNSIGNED | |||
| schedule_year | schedule_year | SMALLINT UNSIGNED | |||
| racecourse_cd | racecourse_cd | CHAR(2) | |||
| meeting_no | meeting_no | TINYINT UNSIGNED | |||
| schedule_day_no | schedule_day_no | TINYINT UNSIGNED | |||
| race_no | race_no | TINYINT UNSIGNED | |||
| horse_reg_no | horse_reg_no | VARCHAR(10) | |||
| race_date | race_date | DATE | |||
| race_name | race_name | VARCHAR(200) | |||
| grade_cd | grade_cd | VARCHAR(1) | |||
| horse_name | horse_name | VARCHAR(100) |
user_purchase21 fields| 論理名 | 物理名 | データ型 | データ種別 | レコード種別 | JVData項目名 |
|---|---|---|---|---|---|
| purchase_id | purchase_id | CHAR(32) | |||
| revision | revision | BIGINT | |||
| race_scope_cd | race_scope_cd | TINYINT UNSIGNED | |||
| schedule_year | schedule_year | SMALLINT UNSIGNED | |||
| racecourse_cd | racecourse_cd | CHAR(2) | |||
| meeting_no | meeting_no | TINYINT UNSIGNED | |||
| schedule_day_no | schedule_day_no | TINYINT UNSIGNED | |||
| race_no | race_no | TINYINT UNSIGNED | |||
| race_date_at_save | race_date_at_save | DATE | |||
| race_name_at_save | race_name_at_save | VARCHAR(200) | |||
| track_cd_at_save | track_cd_at_save | CHAR(2) | |||
| class_at_save | class_at_save | VARCHAR(30) | |||
| bet_type_cd | bet_type_cd | CHAR(2) | |||
| selection | selection | VARCHAR(12) | |||
| amount_yen | amount_yen | BIGINT | |||
| memo_text | memo_text | TEXT | |||
| manual_status | manual_status | VARCHAR(8) | |||
| manual_payout_yen | manual_payout_yen | BIGINT | |||
| manual_refund_yen | manual_refund_yen | BIGINT | |||
| created_at | created_at | DATETIME(6) | |||
| updated_at | updated_at | DATETIME(6) |
user_purchase_request3 fields| 論理名 | 物理名 | データ型 | データ種別 | レコード種別 | JVData項目名 |
|---|---|---|---|---|---|
| request_id | request_id | CHAR(32) | |||
| payload_hash | payload_hash | CHAR(64) | |||
| created_at | created_at | DATETIME(6) |
user_race_memo9 fields| 論理名 | 物理名 | データ型 | データ種別 | レコード種別 | JVData項目名 |
|---|---|---|---|---|---|
| race_scope_cd | race_scope_cd | TINYINT UNSIGNED | |||
| schedule_year | schedule_year | SMALLINT UNSIGNED | |||
| racecourse_cd | racecourse_cd | CHAR(2) | |||
| meeting_no | meeting_no | TINYINT UNSIGNED | |||
| schedule_day_no | schedule_day_no | TINYINT UNSIGNED | |||
| race_no | race_no | TINYINT UNSIGNED | |||
| memo_text | memo_text | TEXT | |||
| created_at | created_at | DATETIME(6) | |||
| updated_at | updated_at | DATETIME(6) |
user_watch_horse4 fields| 論理名 | 物理名 | データ型 | データ種別 | レコード種別 | JVData項目名 |
|---|---|---|---|---|---|
| horse_reg_no | horse_reg_no | CHAR(10) | |||
| color_cd | color_cd | VARCHAR(6) | |||
| created_at | created_at | DATETIME(6) | |||
| updated_at | updated_at | DATETIME(6) |
pace_job_chunk18 fields| 論理名 | 物理名 | データ型 | データ種別 | レコード種別 | JVData項目名 |
|---|---|---|---|---|---|
| pace_chunk_id | pace_chunk_id | BIGINT | |||
| pace_job_id | pace_job_id | BIGINT | |||
| chunk_no | chunk_no | INT UNSIGNED | |||
| target_race_ids_json | target_race_ids_json | JSON | |||
| target_race_ids_sha256 | target_race_ids_sha256 | CHAR(64) | |||
| calc_status | calc_status | VARCHAR(20) | |||
| target_count | target_count | INT UNSIGNED | |||
| classified_count | classified_count | INT UNSIGNED | |||
| not_classifiable_count | not_classifiable_count | INT UNSIGNED | |||
| excluded_count | excluded_count | INT UNSIGNED | |||
| failed_count | failed_count | INT UNSIGNED | |||
| reason_counts_json | reason_counts_json | JSON | |||
| error_type | error_type | VARCHAR(128) | |||
| error_message | error_message | VARCHAR(512) | |||
| started_at | started_at | DATETIME(6) | |||
| finished_at | finished_at | DATETIME(6) | |||
| created_at | created_at | DATETIME(6) | |||
| updated_at | updated_at | DATETIME(6) |
pace_job_run21 fields| 論理名 | 物理名 | データ型 | データ種別 | レコード種別 | JVData項目名 |
|---|---|---|---|---|---|
| pace_job_id | pace_job_id | BIGINT | |||
| trigger_type | trigger_type | VARCHAR(20) | |||
| setup_run_id | setup_run_id | BIGINT | |||
| source_run_identity | source_run_identity | VARCHAR(64) | |||
| target_from_date | target_from_date | DATE | |||
| target_to_date | target_to_date | DATE | |||
| model_id | model_id | CHAR(64) | |||
| manifest_sha256 | manifest_sha256 | CHAR(64) | |||
| calc_status | calc_status | VARCHAR(20) | |||
| target_count | target_count | INT UNSIGNED | |||
| classified_count | classified_count | INT UNSIGNED | |||
| not_classifiable_count | not_classifiable_count | INT UNSIGNED | |||
| excluded_count | excluded_count | INT UNSIGNED | |||
| failed_count | failed_count | INT UNSIGNED | |||
| reason_counts_json | reason_counts_json | JSON | |||
| error_type | error_type | VARCHAR(128) | |||
| error_message | error_message | VARCHAR(512) | |||
| started_at | started_at | DATETIME(6) | |||
| finished_at | finished_at | DATETIME(6) | |||
| created_at | created_at | DATETIME(6) | |||
| updated_at | updated_at | DATETIME(6) |
um_profile_backfill4 fields| 論理名 | 物理名 | データ型 | データ種別 | レコード種別 | JVData項目名 |
|---|---|---|---|---|---|
| job_key | job_key | VARCHAR(32) | |||
| state | state | VARCHAR(16) | |||
| started_at | started_at | DATETIME | |||
| completed_at | completed_at | DATETIME |
予測用の事前情報と結果情報を分けたML用ビューと、公開済み能力値のビューです。予測では対象レースの結果列や計算時点に注意してください。
vw_ml_race_horse_label27 fields参照元:core_ra_race、core_se_race_horse
| カラム名 | データ型 | 説明 |
|---|---|---|
race_id | BIGINT | レースを一意に識別するID |
race_horse_id | BIGINT | 1レース内の出走馬を一意に識別するID |
horse_id | BIGINT | 競走馬を識別するJV2AI内のID |
race_date | DATE | レースの施行日 |
race_scope_cd | TINYINT UNSIGNED | レースの取得・管理範囲を表す区分コード |
body_weight_kg | SMALLINT UNSIGNED | 馬体重。単位はkg |
body_weight_diff_kg | SMALLINT | 前走からの馬体重増減。単位はkg |
abnormality_cd | CHAR(1) | 競走中止、除外などの異常区分コード |
arrival_order | TINYINT UNSIGNED | 入線順位。失格・降着確定前の順位を扱います |
finish_order | TINYINT UNSIGNED | 確定着順。目的変数として利用する基本列です |
is_dead_heat | TINYINT(1) | 同着かどうかを表すフラグ |
dead_heat_count_other | TINYINT UNSIGNED | 同着となった他馬の頭数 |
finish_time_sec | DECIMAL(5,1) | 走破時計。単位は秒 |
margin_cd | CHAR(3) | 着差コード |
margin_sec | DECIMAL(5,2) | 定義済みの着差コードを秒換算した値。未定義形式はNULL |
margin_plus_cd | CHAR(3) | 補助的な着差コード |
margin_plus_sec | DECIMAL(5,2) | 補助的な着差コードを同じ規則で秒換算した値。未定義形式はNULL |
margin_plus_plus_cd | CHAR(3) | 追加の補助的な着差コード |
margin_plus_plus_sec | DECIMAL(5,2) | 追加の補助的な着差コードを同じ規則で秒換算した値。未定義形式はNULL |
corner1_order | TINYINT UNSIGNED | 第1コーナー通過順位 |
corner2_order | TINYINT UNSIGNED | 第2コーナー通過順位 |
corner3_order | TINYINT UNSIGNED | 第3コーナー通過順位 |
corner4_order | TINYINT UNSIGNED | 第4コーナー通過順位 |
last_4f_sec | DECIMAL(4,1) | 上がり4ハロン時計。単位は秒 |
last_3f_sec | DECIMAL(4,1) | 上がり3ハロン時計。単位は秒 |
time_diff_sec | DECIMAL(5,1) | 基準馬または勝ち馬との差を秒換算した値 |
running_style_cd | CHAR(1) | 脚質コード |
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_id | BIGINT | レースを一意に識別するID |
race_horse_id | BIGINT | 1レース内の出走馬を一意に識別するID |
race_scope_cd | TINYINT UNSIGNED | レースの取得・管理範囲を表す区分コード |
race_date | DATE | レースの施行日 |
racecourse_cd | CHAR(2) | 競馬場コード |
meeting_no | TINYINT UNSIGNED | 開催回次 |
schedule_day_no | TINYINT UNSIGNED | 開催日次 |
race_no | TINYINT UNSIGNED | レース番号 |
race_name_main | VARCHAR(60) | レース名 |
grade_cd | CHAR(1) | グレード区分コード |
race_type_cd | CHAR(2) | 競走種別コード |
race_symbol_cd | CHAR(3) | レース記号コード |
weight_type_cd | CHAR(1) | 重量種別コード |
condition_cd_2yo | CHAR(3) | 2歳条件コード |
condition_cd_3yo | CHAR(3) | 3歳条件コード |
condition_cd_4yo | CHAR(3) | 4歳条件コード |
condition_cd_5up | CHAR(3) | 5歳以上条件コード |
condition_cd_youngest | CHAR(3) | 出走条件の最少年齢側を表すコード |
distance_m | SMALLINT UNSIGNED | 距離。単位はメートル |
track_cd | CHAR(2) | トラックコード |
course_cd | CHAR(2) | コースコード |
scheduled_start_time | TIME | 発走予定時刻 |
is_cancelled | TINYINT(1) | レースが中止扱いかどうかを表すフラグ |
horse_id | BIGINT | 競走馬を識別するJV2AI内のID |
horse_reg_no | CHAR(10) | 血統登録番号 |
horse_name | VARCHAR(36) | 競走馬名 |
frame_no | TINYINT UNSIGNED | 枠番 |
horse_no | TINYINT UNSIGNED | 馬番 |
horse_symbol_cd | CHAR(2) | 馬記号コード |
sex_cd | CHAR(1) | 性別コード |
breed_cd | CHAR(1) | 品種コード |
coat_color_cd | CHAR(2) | 毛色コード |
horse_age | TINYINT UNSIGNED | レース時点の馬齢 |
affiliation_cd | CHAR(1) | 所属コード |
trainer_cd | CHAR(5) | 調教師コード |
owner_cd | CHAR(6) | 馬主コード |
carried_weight_kg | DECIMAL(4,1) | 負担重量。単位はkg |
is_blinker | TINYINT(1) | ブリンカー着用有無を表すフラグ |
jockey_cd | CHAR(5) | 騎手コード |
apprentice_cd | CHAR(1) | 見習騎手区分コード |
is_horse_identity_resolved | INT | 血統登録番号が有効に解決できているかを表すフラグ。未解決海外馬などは0になります |
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_cd | VARCHAR(2) | 調教種別。坂路調教はHC、ウッドチップ調教はWC |
training_id | BIGINT | 元テーブル上の調教ID |
horse_reg_no | CHAR(10) | 血統登録番号 |
training_center_cd | CHAR(1) | 調教場コード |
training_datetime | DATETIME | 調教日時 |
course_cd | VARCHAR(1) | 調教コースコード。坂路調教行ではNULL |
direction_cd | VARCHAR(1) | 調教の回り方向コード。坂路調教行ではNULL |
total_10f_sec | DECIMAL(4,1) | 10ハロンタイム合計。単位は秒。坂路調教行ではNULL |
lap_2000_1800_sec | DECIMAL(3,1) | 2000m〜1800mのラップタイム。単位は秒。坂路調教行ではNULL |
total_9f_sec | DECIMAL(4,1) | 9ハロンタイム合計。単位は秒。坂路調教行ではNULL |
lap_1800_1600_sec | DECIMAL(3,1) | 1800m〜1600mのラップタイム。単位は秒。坂路調教行ではNULL |
total_8f_sec | DECIMAL(4,1) | 8ハロンタイム合計。単位は秒。坂路調教行ではNULL |
lap_1600_1400_sec | DECIMAL(3,1) | 1600m〜1400mのラップタイム。単位は秒。坂路調教行ではNULL |
total_7f_sec | DECIMAL(4,1) | 7ハロンタイム合計。単位は秒。坂路調教行ではNULL |
lap_1400_1200_sec | DECIMAL(3,1) | 1400m〜1200mのラップタイム。単位は秒。坂路調教行ではNULL |
total_6f_sec | DECIMAL(4,1) | 6ハロンタイム合計。単位は秒。坂路調教行ではNULL |
lap_1200_1000_sec | DECIMAL(3,1) | 1200m〜1000mのラップタイム。単位は秒。坂路調教行ではNULL |
total_5f_sec | DECIMAL(4,1) | 5ハロンタイム合計。単位は秒。坂路調教行ではNULL |
lap_1000_800_sec | DECIMAL(3,1) | 1000m〜800mのラップタイム。単位は秒。坂路調教行ではNULL |
total_4f_sec | DECIMAL(4,1) | 4ハロンタイム合計。単位は秒 |
lap_800_600_sec | DECIMAL(3,1) | 800m〜600mのラップタイム。単位は秒 |
total_3f_sec | DECIMAL(4,1) | 3ハロンタイム合計。単位は秒 |
lap_600_400_sec | DECIMAL(3,1) | 600m〜400mのラップタイム。単位は秒 |
total_2f_sec | DECIMAL(4,1) | 2ハロンタイム合計。単位は秒 |
lap_400_200_sec | DECIMAL(3,1) | 400m〜200mのラップタイム。単位は秒 |
lap_200_0_sec | DECIMAL(3,1) | 200m〜ゴールまでのラップタイム。単位は秒 |
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_id | BIGINT | 定義SQLを参照 |
taf_job_id | BIGINT | 定義SQLを参照 |
as_of_race_id | BIGINT | 定義SQLを参照 |
as_of_race_horse_id | BIGINT | 定義SQLを参照 |
horse_id | BIGINT | 競走馬ID |
as_of_race_date | DATE | 定義SQLを参照 |
snapshot_scope_type | VARCHAR(64) | 定義SQLを参照 |
target_surface_cd | CHAR(1) | 定義SQLを参照 |
target_distance_m | SMALLINT | 定義SQLを参照 |
target_distance_category | VARCHAR(32) | 定義SQLを参照 |
target_racecourse_cd | CHAR(2) | 定義SQLを参照 |
tai_index | DECIMAL(6,3) | 定義SQLを参照 |
tai_latent_z | DECIMAL(7,4) | 定義SQLを参照 |
epi_index | DECIMAL(6,3) | 定義SQLを参照 |
lpi_index | DECIMAL(6,3) | 定義SQLを参照 |
spi_index | DECIMAL(6,3) | 定義SQLを参照 |
kri_index | DECIMAL(6,3) | 定義SQLを参照 |
tai_confidence_score | DECIMAL(5,4) | 定義SQLを参照 |
epi_confidence_score | DECIMAL(5,4) | 定義SQLを参照 |
lpi_confidence_score | DECIMAL(5,4) | 定義SQLを参照 |
spi_confidence_score | DECIMAL(5,4) | 定義SQLを参照 |
kri_confidence_score | DECIMAL(5,4) | 定義SQLを参照 |
epi_evidence_level | VARCHAR(16) | 定義SQLを参照 |
lpi_evidence_level | VARCHAR(16) | 定義SQLを参照 |
spi_evidence_level | VARCHAR(16) | 定義SQLを参照 |
kri_evidence_level | VARCHAR(16) | 定義SQLを参照 |
tai_evidence_level | VARCHAR(16) | 定義SQLを参照 |
weighted_ability_resid_sec | DECIMAL(8,3) | 定義SQLを参照 |
weighted_time_resid_sec | DECIMAL(8,3) | 定義SQLを参照 |
speed_z | DECIMAL(6,3) | 定義SQLを参照 |
front3_z | DECIMAL(6,3) | 定義SQLを参照 |
late3_z | DECIMAL(6,3) | 定義SQLを参照 |
early_position_z | DECIMAL(6,3) | 定義SQLを参照 |
mid_position_z | DECIMAL(6,3) | 定義SQLを参照 |
front_lead_z | DECIMAL(6,3) | 定義SQLを参照 |
closing_z | DECIMAL(6,3) | 定義SQLを参照 |
rear_weighted_gain_z | DECIMAL(6,3) | 定義SQLを参照 |
early_hold_z | DECIMAL(6,3) | 定義SQLを参照 |
early_pressure_load_z | DECIMAL(6,3) | 定義SQLを参照 |
late_context_response_z | DECIMAL(6,3) | 定義SQLを参照 |
no_fade_z | DECIMAL(6,3) | 定義SQLを参照 |
front_survival_z | DECIMAL(6,3) | 定義SQLを参照 |
late3_sustain_z | DECIMAL(6,3) | 定義SQLを参照 |
sustained_context_load_z | DECIMAL(6,3) | 定義SQLを参照 |
closing_acceleration_z | DECIMAL(6,3) | 定義SQLを参照 |
relative_last3_z | DECIMAL(6,3) | 定義SQLを参照 |
spi_z | DECIMAL(6,3) | 定義SQLを参照 |
corner_gain_z | DECIMAL(6,3) | 定義SQLを参照 |
kri_z | DECIMAL(6,3) | 定義SQLを参照 |
source_run_count | SMALLINT | 定義SQLを参照 |
valid_source_run_count | SMALLINT | 定義SQLを参照 |
selected_run_count | SMALLINT | 定義SQLを参照 |
single_extreme_poor_run_excluded_count | SMALLINT | 定義SQLを参照 |
source_race_date_min | DATE | 定義SQLを参照 |
source_race_date_max | DATE | 定義SQLを参照 |
days_since_last_run_count | SMALLINT | 定義SQLを参照 |
avg_source_confidence_score | DECIMAL(5,4) | 定義SQLを参照 |
snapshot_confidence_score | DECIMAL(5,4) | 定義SQLを参照 |
quality_status | VARCHAR(32) | 定義SQLを参照 |
quality_warning_flags | VARCHAR(512) | 定義SQLを参照 |
created_at | DATETIME | 定義SQLを参照 |
updated_at | DATETIME | 更新日時 |
recent_ability_stat_source_count | SMALLINT | 定義SQLを参照 |
recent_ability_variability_mad_z | DECIMAL(6,3) | 定義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_id | BIGINT | 定義SQLを参照 |
horse_ability_snapshot_id | BIGINT | 定義SQLを参照 |
source_taf_race_horse_feature_id | BIGINT | 定義SQLを参照 |
source_race_id | BIGINT | 定義SQLを参照 |
source_race_horse_id | BIGINT | 取得元出走馬ID |
source_horse_id | BIGINT | 定義SQLを参照 |
source_race_date | DATE | 定義SQLを参照 |
source_surface_cd | CHAR(1) | 定義SQLを参照 |
source_distance_m | SMALLINT | 定義SQLを参照 |
source_distance_category | VARCHAR(32) | 定義SQLを参照 |
source_racecourse_cd | CHAR(2) | 定義SQLを参照 |
source_pace_type | VARCHAR(32) | 定義SQLを参照 |
source_lap_confidence_score | DECIMAL(5,4) | 定義SQLを参照 |
source_class_factor_sec | DECIMAL(8,3) | 定義SQLを参照 |
source_run_ability_resid_for_score_sec | DECIMAL(8,3) | 定義SQLを参照 |
source_run_ability_resid_for_time_sec | DECIMAL(8,3) | 定義SQLを参照 |
source_run_tai_absolute_resid_sec | DECIMAL(8,3) | 定義SQLを参照 |
source_run_tai_absolute_z | DECIMAL(7,4) | 定義SQLを参照 |
source_run_result_dominance_z | DECIMAL(7,4) | 定義SQLを参照 |
source_run_opponent_strength_z | DECIMAL(7,4) | 定義SQLを参照 |
source_run_opponent_valid_count | SMALLINT UNSIGNED | 定義SQLを参照 |
source_run_opponent_weight_sum | DECIMAL(8,4) | 定義SQLを参照 |
source_run_competition_ability_z | DECIMAL(7,4) | 定義SQLを参照 |
source_run_tai_context_z | DECIMAL(7,4) | 定義SQLを参照 |
source_run_speed_z | DECIMAL(6,3) | 定義SQLを参照 |
source_run_front3_z_source | DECIMAL(6,3) | 定義SQLを参照 |
source_run_late3_z_source | DECIMAL(6,3) | 定義SQLを参照 |
source_run_corner_gain_rate | DECIMAL(6,4) | 定義SQLを参照 |
source_run_straight_hold_rate | DECIMAL(6,4) | 定義SQLを参照 |
source_run_overall_performance_index | DECIMAL(6,3) | 定義SQLを参照 |
source_run_early_position_index | DECIMAL(6,3) | 定義SQLを参照 |
source_run_late_performance_index | DECIMAL(6,3) | 定義SQLを参照 |
source_run_front_sustain_index | DECIMAL(6,3) | 定義SQLを参照 |
source_run_closing_gain_index | DECIMAL(6,3) | 定義SQLを参照 |
source_performance_confidence_score | DECIMAL(5,4) | 定義SQLを参照 |
source_used_flag | TINYINT(1) | 定義SQLを参照 |
source_exclusion_reason | VARCHAR(64) | 定義SQLを参照 |
source_exclusion_basis_json | JSON | 定義SQLを参照 |
single_extreme_poor_run_flag | TINYINT(1) | 定義SQLを参照 |
ability_select_rank | SMALLINT | 定義SQLを参照 |
selected_run_limit | SMALLINT | 定義SQLを参照 |
ability_rank_weight | DECIMAL(5,4) | 定義SQLを参照 |
source_recency_days | SMALLINT | 定義SQLを参照 |
recency_weight | DECIMAL(5,4) | 定義SQLを参照 |
quality_weight | DECIMAL(5,4) | 定義SQLを参照 |
source_weight | DECIMAL(8,5) | 定義SQLを参照 |
source_weight_basis_json | JSON | 定義SQLを参照 |
created_at | DATETIME | 定義SQLを参照 |
source_run_early_position_z_source | DECIMAL(6,3) | 定義SQLを参照 |
source_run_mid_position_z_source | DECIMAL(6,3) | 定義SQLを参照 |
source_run_corner_gain_z_source | DECIMAL(6,3) | 定義SQLを参照 |
source_run_rear_weighted_gain_z_source | DECIMAL(6,3) | 定義SQLを参照 |
source_run_early_hold_z_source | DECIMAL(6,3) | 定義SQLを参照 |
source_run_early_pressure_load_z_source | DECIMAL(6,3) | 定義SQLを参照 |
source_run_late_context_response_z_source | DECIMAL(6,3) | 定義SQLを参照 |
source_run_no_fade_z_source | DECIMAL(6,3) | 定義SQLを参照 |
source_run_front_survival_z_source | DECIMAL(6,3) | 定義SQLを参照 |
source_run_sustained_context_load_z_source | DECIMAL(6,3) | 定義SQLを参照 |
source_run_closing_acceleration_sec | DECIMAL(8,3) | 定義SQLを参照 |
source_run_closing_acceleration_z_source | DECIMAL(6,3) | 定義SQLを参照 |
source_run_relative_last3_z_source | DECIMAL(6,3) | 定義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`))
vw_taf_published_race_feature47 fields参照元:ability_bundle_install、ability_bundle_race_origin、taf_date_checkpoint、taf_processing_control
| カラム名 | データ型 | 説明 |
|---|---|---|
taf_race_feature_id | BIGINT | 定義SQLを参照 |
taf_job_id | BIGINT | 定義SQLを参照 |
race_id | BIGINT | レースID |
tav_race_id | BIGINT | 定義SQLを参照 |
tav_race_adjustment_id | BIGINT | 定義SQLを参照 |
race_date | DATE | 開催日 |
racecourse_cd | CHAR(2) | 競馬場コード |
race_no | TINYINT | レース番号 |
surface_cd | CHAR(1) | 定義SQLを参照 |
distance_m | SMALLINT | 定義SQLを参照 |
distance_category | VARCHAR(32) | 定義SQLを参照 |
track_cd | VARCHAR(2) | 定義SQLを参照 |
baba_cd | VARCHAR(2) | 定義SQLを参照 |
weather_cd | VARCHAR(2) | 天候コード |
normalized_class_cd | VARCHAR(32) | 定義SQLを参照 |
starter_count | TINYINT | 出走頭数 |
finisher_count | TINYINT | 入線頭数 |
straight_course_flag | TINYINT(1) | 定義SQLを参照 |
expected_race_time_sec | DECIMAL(8,3) | 定義SQLを参照 |
race_adjustment_sec | DECIMAL(8,3) | 定義SQLを参照 |
day_variant_sec | DECIMAL(8,3) | 定義SQLを参照 |
par_time_sec | DECIMAL(8,3) | 定義SQLを参照 |
class_factor_sec | DECIMAL(8,3) | 定義SQLを参照 |
tav_confidence_score | DECIMAL(5,4) | 定義SQLを参照 |
winner_finish_time_sec | DECIMAL(8,3) | 定義SQLを参照 |
winner_time_resid_sec | DECIMAL(8,3) | 定義SQLを参照 |
first3_sec | DECIMAL(6,3) | 定義SQLを参照 |
last3_sec | DECIMAL(6,3) | 定義SQLを参照 |
pace_type | VARCHAR(32) | 定義SQLを参照 |
first_half_pressure_sec | DECIMAL(8,3) | 定義SQLを参照 |
middle_pressure_sec | DECIMAL(8,3) | 定義SQLを参照 |
late_pressure_sec | DECIMAL(8,3) | 定義SQLを参照 |
lap_confidence_score | DECIMAL(5,4) | 定義SQLを参照 |
valid_taf_race_flag | TINYINT(1) | 定義SQLを参照 |
valid_tav_adjustment_flag | TINYINT(1) | 定義SQLを参照 |
valid_lap_flag | TINYINT(1) | 定義SQLを参照 |
valid_time_flag | TINYINT(1) | 定義SQLを参照 |
race_confidence_score | DECIMAL(5,4) | 定義SQLを参照 |
quality_status | VARCHAR(32) | 定義SQLを参照 |
quality_warning_flags | VARCHAR(512) | 定義SQLを参照 |
created_at | DATETIME | 定義SQLを参照 |
updated_at | DATETIME | 更新日時 |
early_speed_index | DECIMAL(6,3) | 定義SQLを参照 |
mid_accel_index | DECIMAL(6,3) | 定義SQLを参照 |
late_accel_index | DECIMAL(6,3) | 定義SQLを参照 |
sustained_speed_index | DECIMAL(6,3) | 定義SQLを参照 |
closing_speed_index | DECIMAL(6,3) | 定義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`)))
vw_taf_published_race_horse_feature93 fields参照元:ability_bundle_install、ability_bundle_race_origin、taf_date_checkpoint、taf_processing_control
| カラム名 | データ型 | 説明 |
|---|---|---|
taf_race_horse_feature_id | BIGINT | 定義SQLを参照 |
taf_job_id | BIGINT | 定義SQLを参照 |
taf_race_feature_id | BIGINT | 定義SQLを参照 |
race_id | BIGINT | レースID |
race_horse_id | BIGINT | 出走馬ID |
horse_id | BIGINT | 競走馬ID |
tav_race_id | BIGINT | 定義SQLを参照 |
tav_race_adjustment_id | BIGINT | 定義SQLを参照 |
race_date | DATE | 開催日 |
racecourse_cd | CHAR(2) | 競馬場コード |
race_no | TINYINT | レース番号 |
surface_cd | CHAR(1) | 定義SQLを参照 |
distance_m | SMALLINT | 定義SQLを参照 |
distance_category | VARCHAR(32) | 定義SQLを参照 |
track_cd | VARCHAR(2) | 定義SQLを参照 |
baba_cd | VARCHAR(2) | 定義SQLを参照 |
normalized_class_cd | VARCHAR(32) | 定義SQLを参照 |
starter_count | TINYINT | 出走頭数 |
finisher_count | TINYINT | 入線頭数 |
straight_course_flag | TINYINT(1) | 定義SQLを参照 |
horse_no | TINYINT | 馬番 |
finish_order | TINYINT | 確定着順 |
arrival_order | TINYINT | 入線順位 |
abnormality_cd | VARCHAR(4) | 異常区分コード |
finish_time_sec | DECIMAL(8,3) | 走破タイム |
winner_finish_time_sec | DECIMAL(8,3) | 定義SQLを参照 |
winner_time_diff_sec | DECIMAL(8,3) | 定義SQLを参照 |
margin_sec | DECIMAL(8,3) | 着差コード秒換算 |
last3_sec | DECIMAL(6,3) | 定義SQLを参照 |
corner1_order | TINYINT | 1コーナー順位 |
corner2_order | TINYINT | 2コーナー順位 |
corner3_order | TINYINT | 3コーナー順位 |
corner4_order | TINYINT | 4コーナー順位 |
expected_race_time_sec | DECIMAL(8,3) | 定義SQLを参照 |
race_adjustment_sec | DECIMAL(8,3) | 定義SQLを参照 |
day_variant_sec | DECIMAL(8,3) | 定義SQLを参照 |
class_factor_sec | DECIMAL(8,3) | 定義SQLを参照 |
tav_confidence_score | DECIMAL(5,4) | 定義SQLを参照 |
run_finish_time_resid_sec | DECIMAL(8,3) | 定義SQLを参照 |
run_ability_resid_sec | DECIMAL(8,3) | 定義SQLを参照 |
run_ability_resid_for_score_sec | DECIMAL(8,3) | 定義SQLを参照 |
run_ability_resid_for_time_sec | DECIMAL(8,3) | 定義SQLを参照 |
run_tai_absolute_resid_sec | DECIMAL(8,3) | 定義SQLを参照 |
run_tai_absolute_z | DECIMAL(7,4) | 定義SQLを参照 |
run_result_dominance_z | DECIMAL(7,4) | 定義SQLを参照 |
run_opponent_strength_z | DECIMAL(7,4) | 定義SQLを参照 |
run_opponent_valid_count | SMALLINT UNSIGNED | 定義SQLを参照 |
run_opponent_weight_sum | DECIMAL(8,4) | 定義SQLを参照 |
run_competition_ability_z | DECIMAL(7,4) | 定義SQLを参照 |
run_tai_context_z | DECIMAL(7,4) | 定義SQLを参照 |
run_speed_z | DECIMAL(6,3) | 定義SQLを参照 |
run_front3_z_source | DECIMAL(6,3) | 定義SQLを参照 |
run_late3_sec | DECIMAL(6,3) | 定義SQLを参照 |
run_late3_z_source | DECIMAL(6,3) | 定義SQLを参照 |
run_early_position_rate | DECIMAL(6,4) | 定義SQLを参照 |
run_mid_position_rate | DECIMAL(6,4) | 定義SQLを参照 |
run_corner4_position_rate | DECIMAL(6,4) | 定義SQLを参照 |
run_finish_position_rate | DECIMAL(6,4) | 定義SQLを参照 |
run_corner_gain_rate | DECIMAL(6,4) | 定義SQLを参照 |
run_straight_hold_rate | DECIMAL(6,4) | 定義SQLを参照 |
run_front_late3_support_value | DECIMAL(6,4) | 定義SQLを参照 |
pace_type | VARCHAR(32) | 定義SQLを参照 |
lap_confidence_score | DECIMAL(5,4) | 定義SQLを参照 |
run_overall_performance_index | DECIMAL(6,3) | 定義SQLを参照 |
run_early_position_index | DECIMAL(6,3) | 定義SQLを参照 |
run_late_performance_index | DECIMAL(6,3) | 定義SQLを参照 |
run_front_sustain_index | DECIMAL(6,3) | 定義SQLを参照 |
run_closing_gain_index | DECIMAL(6,3) | 定義SQLを参照 |
valid_taf_run_flag | TINYINT(1) | 定義SQLを参照 |
valid_tav_adjustment_flag | TINYINT(1) | 定義SQLを参照 |
valid_time_flag | TINYINT(1) | 定義SQLを参照 |
valid_last3_flag | TINYINT(1) | 定義SQLを参照 |
valid_position_flag | TINYINT(1) | 定義SQLを参照 |
valid_lap_flag | TINYINT(1) | 定義SQLを参照 |
abnormality_exclude_flag | TINYINT(1) | 定義SQLを参照 |
performance_confidence_score | DECIMAL(5,4) | 定義SQLを参照 |
quality_status | VARCHAR(32) | 定義SQLを参照 |
quality_warning_flags | VARCHAR(512) | 定義SQLを参照 |
created_at | DATETIME | 定義SQLを参照 |
updated_at | DATETIME | 更新日時 |
run_early_position_z_source | DECIMAL(6,3) | 定義SQLを参照 |
run_mid_position_z_source | DECIMAL(6,3) | 定義SQLを参照 |
run_corner_gain_z_source | DECIMAL(6,3) | 定義SQLを参照 |
run_rear_weighted_gain_z_source | DECIMAL(6,3) | 定義SQLを参照 |
run_early_hold_z_source | DECIMAL(6,3) | 定義SQLを参照 |
run_early_pressure_load_z_source | DECIMAL(6,3) | 定義SQLを参照 |
run_late_context_response_z_source | DECIMAL(6,3) | 定義SQLを参照 |
run_no_fade_z_source | DECIMAL(6,3) | 定義SQLを参照 |
run_front_survival_z_source | DECIMAL(6,3) | 定義SQLを参照 |
run_sustained_context_load_z_source | DECIMAL(6,3) | 定義SQLを参照 |
run_closing_acceleration_sec | DECIMAL(8,3) | 定義SQLを参照 |
run_closing_acceleration_z_source | DECIMAL(6,3) | 定義SQLを参照 |
run_relative_last3_z_source | DECIMAL(6,3) | 定義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`)))
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_id | BIGINT | 定義SQLを参照 |
tai_h_job_id | BIGINT | 定義SQLを参照 |
race_id | BIGINT | レースID |
race_horse_id | BIGINT | 出走馬ID |
horse_id | BIGINT | 競走馬ID |
race_date | DATE | 開催日 |
source_taf_snapshot_id | BIGINT | 定義SQLを参照 |
source_tfs_race_horse_feature_id | BIGINT | 定義SQLを参照 |
tai_base | DECIMAL(12,9) | 定義SQLを参照 |
training_form_z | DECIMAL(12,9) | 定義SQLを参照 |
training_adjustment | DECIMAL(12,9) | 定義SQLを参照 |
jockey_raw_score | DECIMAL(12,9) | 定義SQLを参照 |
jockey_score_z | DECIMAL(12,9) | 定義SQLを参照 |
jockey_adjustment | DECIMAL(12,9) | 定義SQLを参照 |
trainer_raw_score | DECIMAL(12,9) | 定義SQLを参照 |
trainer_score_z | DECIMAL(12,9) | 定義SQLを参照 |
trainer_adjustment | DECIMAL(12,9) | 定義SQLを参照 |
raw_adjustment | DECIMAL(12,9) | 定義SQLを参照 |
tai_h_adjustment | DECIMAL(12,9) | 定義SQLを参照 |
tai_h_index | DECIMAL(12,9) | 定義SQLを参照 |
tai_h_z | DECIMAL(12,9) | 定義SQLを参照 |
tai_h_rank | SMALLINT UNSIGNED | 定義SQLを参照 |
risk_codes_json | JSON | 定義SQLを参照 |
created_at | DATETIME | 定義SQLを参照 |
updated_at | DATETIME | 更新日時 |
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`))))
vw_tav_race_feature_core33 fields参照元:tav_race_adjustment、tav_race_lap_profile
| カラム名 | データ型 | 説明 |
|---|---|---|
race_id | BIGINT | レースID |
tav_race_id | BIGINT UNSIGNED | 定義SQLを参照 |
kaisai_date | CHAR(8) | 定義SQLを参照 |
jyo_cd | CHAR(2) | 定義SQLを参照 |
kaiji | CHAR(2) | 定義SQLを参照 |
nichiji | CHAR(2) | 定義SQLを参照 |
race_num | CHAR(2) | 定義SQLを参照 |
surface_cd | CHAR(1) | 定義SQLを参照 |
kyori | INT | 定義SQLを参照 |
par_time_sec | DECIMAL(8,3) | 定義SQLを参照 |
course_factor_sec | DECIMAL(8,3) | 定義SQLを参照 |
class_factor_sec | DECIMAL(8,3) | 定義SQLを参照 |
track_condition_factor_sec | DECIMAL(8,3) | 定義SQLを参照 |
day_variant_sec | DECIMAL(8,3) | 定義SQLを参照 |
race_adjustment_sec | DECIMAL(8,3) | 定義SQLを参照 |
expected_race_time_sec | DECIMAL(8,3) | 定義SQLを参照 |
adjustment_quality_status | VARCHAR(32) | 定義SQLを参照 |
adjustment_warning_flags | VARCHAR(255) | 定義SQLを参照 |
adjustment_is_estimated | TINYINT(1) | 定義SQLを参照 |
adjustment_fallback_level | INT | 定義SQLを参照 |
adjustment_confidence_score | DECIMAL(5,4) | 定義SQLを参照 |
pace_type | VARCHAR(32) | 定義SQLを参照 |
first_half_pressure_sec | DECIMAL(8,3) | 定義SQLを参照 |
middle_pressure_sec | DECIMAL(8,3) | 定義SQLを参照 |
late_pressure_sec | DECIMAL(8,3) | 定義SQLを参照 |
early_speed_index | DECIMAL(8,3) | 定義SQLを参照 |
sustained_speed_index | DECIMAL(8,3) | 定義SQLを参照 |
closing_speed_index | DECIMAL(8,3) | 定義SQLを参照 |
lap_quality_status | VARCHAR(32) | 定義SQLを参照 |
lap_warning_flags | VARCHAR(255) | 定義SQLを参照 |
lap_is_estimated | TINYINT(1) | 定義SQLを参照 |
lap_fallback_level | INT | 定義SQLを参照 |
lap_confidence_score | DECIMAL(5,4) | 定義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)
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_id | BIGINT | 定義SQLを参照 |
tfs_job_id | BIGINT | 定義SQLを参照 |
race_id | BIGINT | レースID |
race_date | DATE | 開催日 |
quality_status | VARCHAR(16) | 定義SQLを参照 |
created_at | DATETIME | 定義SQLを参照 |
updated_at | DATETIME | 更新日時 |
member_entry_count | INT | 定義SQLを参照 |
member_surface_distance_low_confidence_count | INT | 定義SQLを参照 |
member_overall_tai_valid_count | INT | 定義SQLを参照 |
member_overall_tai_mean | DECIMAL(7,3) | 定義SQLを参照 |
member_overall_tai_median | DECIMAL(7,3) | 定義SQLを参照 |
member_overall_tai_stddev | DECIMAL(7,3) | 定義SQLを参照 |
member_overall_tai_max | DECIMAL(7,3) | 定義SQLを参照 |
member_overall_tai_top3_mean | DECIMAL(7,3) | 定義SQLを参照 |
member_overall_tai_top1_top2_gap | DECIMAL(7,3) | 定義SQLを参照 |
member_surface_distance_tai_valid_count | INT | 定義SQLを参照 |
member_surface_distance_tai_mean | DECIMAL(7,3) | 定義SQLを参照 |
member_surface_distance_tai_median | DECIMAL(7,3) | 定義SQLを参照 |
member_surface_distance_tai_stddev | DECIMAL(7,3) | 定義SQLを参照 |
member_surface_distance_tai_max | DECIMAL(7,3) | 定義SQLを参照 |
member_surface_distance_tai_top3_mean | DECIMAL(7,3) | 定義SQLを参照 |
member_surface_distance_tai_top1_top2_gap | DECIMAL(7,3) | 定義SQLを参照 |
member_surface_distance_epi_valid_count | INT | 定義SQLを参照 |
member_surface_distance_epi_mean | DECIMAL(7,3) | 定義SQLを参照 |
member_surface_distance_epi_median | DECIMAL(7,3) | 定義SQLを参照 |
member_surface_distance_epi_stddev | DECIMAL(7,3) | 定義SQLを参照 |
member_surface_distance_epi_max | DECIMAL(7,3) | 定義SQLを参照 |
member_surface_distance_epi_top3_mean | DECIMAL(7,3) | 定義SQLを参照 |
member_surface_distance_epi_top1_top2_gap | DECIMAL(7,3) | 定義SQLを参照 |
member_surface_distance_lpi_valid_count | INT | 定義SQLを参照 |
member_surface_distance_lpi_mean | DECIMAL(7,3) | 定義SQLを参照 |
member_surface_distance_lpi_median | DECIMAL(7,3) | 定義SQLを参照 |
member_surface_distance_lpi_stddev | DECIMAL(7,3) | 定義SQLを参照 |
member_surface_distance_lpi_max | DECIMAL(7,3) | 定義SQLを参照 |
member_surface_distance_lpi_top3_mean | DECIMAL(7,3) | 定義SQLを参照 |
member_surface_distance_lpi_top1_top2_gap | DECIMAL(7,3) | 定義SQLを参照 |
member_surface_distance_spi_valid_count | INT | 定義SQLを参照 |
member_surface_distance_spi_mean | DECIMAL(7,3) | 定義SQLを参照 |
member_surface_distance_spi_median | DECIMAL(7,3) | 定義SQLを参照 |
member_surface_distance_spi_stddev | DECIMAL(7,3) | 定義SQLを参照 |
member_surface_distance_spi_max | DECIMAL(7,3) | 定義SQLを参照 |
member_surface_distance_spi_top3_mean | DECIMAL(7,3) | 定義SQLを参照 |
member_surface_distance_spi_top1_top2_gap | DECIMAL(7,3) | 定義SQLを参照 |
member_surface_distance_kri_valid_count | INT | 定義SQLを参照 |
member_surface_distance_kri_mean | DECIMAL(7,3) | 定義SQLを参照 |
member_surface_distance_kri_median | DECIMAL(7,3) | 定義SQLを参照 |
member_surface_distance_kri_stddev | DECIMAL(7,3) | 定義SQLを参照 |
member_surface_distance_kri_max | DECIMAL(7,3) | 定義SQLを参照 |
member_surface_distance_kri_top3_mean | DECIMAL(7,3) | 定義SQLを参照 |
member_surface_distance_kri_top1_top2_gap | DECIMAL(7,3) | 定義SQLを参照 |
member_ability_variability_valid_count | INT | 定義SQLを参照 |
member_ability_variability_mad_z_mean | DECIMAL(7,3) | 定義SQLを参照 |
member_ability_variability_mad_z_median | DECIMAL(7,3) | 定義SQLを参照 |
member_style_valid_horse_count | INT | 定義SQLを参照 |
member_style_coverage_rate | DECIMAL(7,6) | 定義SQLを参照 |
member_nige_style_rate_sum | DECIMAL(8,6) | 定義SQLを参照 |
member_senko_style_rate_sum | DECIMAL(8,6) | 定義SQLを参照 |
member_sashi_style_rate_sum | DECIMAL(8,6) | 定義SQLを参照 |
member_oikomi_style_rate_sum | DECIMAL(8,6) | 定義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`)))
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_id | BIGINT | 定義SQLを参照 |
tfs_job_id | BIGINT | 定義SQLを参照 |
tfs_race_feature_id | BIGINT | 定義SQLを参照 |
race_id | BIGINT | レースID |
race_horse_id | BIGINT | 出走馬ID |
horse_id | BIGINT | 競走馬ID |
race_date | DATE | 開催日 |
quality_status | VARCHAR(16) | 定義SQLを参照 |
created_at | DATETIME | 定義SQLを参照 |
updated_at | DATETIME | 更新日時 |
previous_race_id | BIGINT | 定義SQLを参照 |
previous_race_horse_id | BIGINT | 定義SQLを参照 |
previous_run_found_flag | TINYINT(1) | 定義SQLを参照 |
previous_run_type_cd | VARCHAR(32) | 定義SQLを参照 |
previous_run_status_cd | VARCHAR(32) | 定義SQLを参照 |
previous_run_interval_days | INT | 定義SQLを参照 |
previous_run_calendar_week_diff_count | SMALLINT | 定義SQLを参照 |
rotation_interval_category_cd | VARCHAR(32) | 定義SQLを参照 |
first_start_flag | TINYINT(1) | 定義SQLを参照 |
layoff_return_flag | TINYINT(1) | 定義SQLを参照 |
run_count_since_layoff | SMALLINT | 定義SQLを参照 |
distance_diff_m | SMALLINT | 定義SQLを参照 |
distance_change_rate | DECIMAL(8,5) | 定義SQLを参照 |
distance_change_type_cd | VARCHAR(32) | 定義SQLを参照 |
surface_change_type_cd | VARCHAR(32) | 定義SQLを参照 |
racecourse_change_flag | TINYINT(1) | 定義SQLを参照 |
class_change_type_cd | VARCHAR(32) | 定義SQLを参照 |
class_change_step | SMALLINT | 定義SQLを参照 |
class_comparable_flag | TINYINT(1) | 定義SQLを参照 |
carried_weight_diff_kg | DECIMAL(5,1) | 定義SQLを参照 |
jockey_change_flag | TINYINT(1) | 定義SQLを参照 |
trainer_change_flag | TINYINT(1) | 定義SQLを参照 |
blinker_change_type_cd | VARCHAR(32) | 定義SQLを参照 |
apprentice_change_flag | TINYINT(1) | 定義SQLを参照 |
training_last_valid_datetime | DATETIME | 定義SQLを参照 |
training_last_valid_type_cd | VARCHAR(16) | 定義SQLを参照 |
training_last_valid_days_before_race | INT | 定義SQLを参照 |
training_last_valid_hours_before_race | DECIMAL(10,2) | 定義SQLを参照 |
training_source_status_cd | VARCHAR(32) | 定義SQLを参照 |
hc_training_source_status_cd | VARCHAR(32) | 定義SQLを参照 |
wc_training_source_status_cd | VARCHAR(32) | 定義SQLを参照 |
training_source_count_7d | INT | 定義SQLを参照 |
training_valid_source_count_7d | INT | 定義SQLを参照 |
training_valid_distinct_day_count_7d | INT | 定義SQLを参照 |
hc_training_valid_source_count_7d | INT | 定義SQLを参照 |
wc_training_valid_source_count_7d | INT | 定義SQLを参照 |
training_source_count_14d | INT | 定義SQLを参照 |
training_valid_source_count_14d | INT | 定義SQLを参照 |
training_valid_distinct_day_count_14d | INT | 定義SQLを参照 |
hc_training_valid_source_count_14d | INT | 定義SQLを参照 |
wc_training_valid_source_count_14d | INT | 定義SQLを参照 |
training_source_count_28d | INT | 定義SQLを参照 |
training_valid_source_count_28d | INT | 定義SQLを参照 |
training_valid_distinct_day_count_28d | INT | 定義SQLを参照 |
hc_training_valid_source_count_28d | INT | 定義SQLを参照 |
wc_training_valid_source_count_28d | INT | 定義SQLを参照 |
training_valid_source_count_since_previous_run | INT | 定義SQLを参照 |
training_valid_distinct_day_count_since_previous_run | INT | 定義SQLを参照 |
hc_training_valid_source_count_since_previous_run | INT | 定義SQLを参照 |
wc_training_valid_source_count_since_previous_run | INT | 定義SQLを参照 |
hc_training_last_valid_datetime | DATETIME | 定義SQLを参照 |
hc_training_last_valid_center_cd | CHAR(1) | 定義SQLを参照 |
hc_training_last_valid_days_before_race | INT | 定義SQLを参照 |
hc_training_last_valid_4f_sec | DECIMAL(8,3) | 定義SQLを参照 |
hc_training_last_valid_3f_sec | DECIMAL(8,3) | 定義SQLを参照 |
hc_training_last_valid_2f_sec | DECIMAL(8,3) | 定義SQLを参照 |
hc_training_last_valid_1f_sec | DECIMAL(8,3) | 定義SQLを参照 |
hc_training_last_valid_lap_800_600_sec | DECIMAL(8,3) | 定義SQLを参照 |
hc_training_last_valid_lap_600_400_sec | DECIMAL(8,3) | 定義SQLを参照 |
hc_training_last_valid_lap_400_200_sec | DECIMAL(8,3) | 定義SQLを参照 |
hc_training_last_valid_1f_accel_sec | DECIMAL(8,3) | 定義SQLを参照 |
hc_training_last_valid_2f_half_accel_sec | DECIMAL(8,3) | 定義SQLを参照 |
wc_training_last_valid_datetime | DATETIME | 定義SQLを参照 |
wc_training_last_valid_center_cd | CHAR(1) | 定義SQLを参照 |
wc_training_last_valid_course_cd | CHAR(1) | 定義SQLを参照 |
wc_training_last_valid_direction_cd | CHAR(1) | 定義SQLを参照 |
wc_training_last_valid_days_before_race | INT | 定義SQLを参照 |
wc_training_last_valid_6f_sec | DECIMAL(8,3) | 定義SQLを参照 |
wc_training_last_valid_5f_sec | DECIMAL(8,3) | 定義SQLを参照 |
wc_training_last_valid_4f_sec | DECIMAL(8,3) | 定義SQLを参照 |
wc_training_last_valid_3f_sec | DECIMAL(8,3) | 定義SQLを参照 |
wc_training_last_valid_2f_sec | DECIMAL(8,3) | 定義SQLを参照 |
wc_training_last_valid_1f_sec | DECIMAL(8,3) | 定義SQLを参照 |
wc_training_last_valid_lap_1200_1000_sec | DECIMAL(8,3) | 定義SQLを参照 |
wc_training_last_valid_lap_1000_800_sec | DECIMAL(8,3) | 定義SQLを参照 |
wc_training_last_valid_lap_800_600_sec | DECIMAL(8,3) | 定義SQLを参照 |
wc_training_last_valid_lap_600_400_sec | DECIMAL(8,3) | 定義SQLを参照 |
wc_training_last_valid_lap_400_200_sec | DECIMAL(8,3) | 定義SQLを参照 |
wc_training_last_valid_1f_accel_sec | DECIMAL(8,3) | 定義SQLを参照 |
wc_training_last_valid_2f_half_accel_sec | DECIMAL(8,3) | 定義SQLを参照 |
hc_training_last_valid_4f_vs_horse_median_sec | DECIMAL(8,3) | 定義SQLを参照 |
hc_training_last_valid_1f_vs_horse_median_sec | DECIMAL(8,3) | 定義SQLを参照 |
wc_training_last_valid_6f_vs_horse_median_sec | DECIMAL(8,3) | 定義SQLを参照 |
wc_training_last_valid_1f_vs_horse_median_sec | DECIMAL(8,3) | 定義SQLを参照 |
hc_training_4f_horse_median_source_count | INT | 定義SQLを参照 |
hc_training_1f_horse_median_source_count | INT | 定義SQLを参照 |
wc_training_6f_horse_median_source_count | INT | 定義SQLを参照 |
wc_training_1f_horse_median_source_count | INT | 定義SQLを参照 |
jockey_source_status_cd | VARCHAR(32) | 定義SQLを参照 |
jockey_year_surface_start_count | INT | 定義SQLを参照 |
jockey_year_surface_win_rate | DECIMAL(7,6) | 定義SQLを参照 |
jockey_year_surface_top2_rate | DECIMAL(7,6) | 定義SQLを参照 |
jockey_year_surface_top3_rate | DECIMAL(7,6) | 定義SQLを参照 |
jockey_year_distance_start_count | INT | 定義SQLを参照 |
jockey_year_distance_win_rate | DECIMAL(7,6) | 定義SQLを参照 |
jockey_year_distance_top2_rate | DECIMAL(7,6) | 定義SQLを参照 |
jockey_year_distance_top3_rate | DECIMAL(7,6) | 定義SQLを参照 |
jockey_year_racecourse_surface_start_count | INT | 定義SQLを参照 |
jockey_year_racecourse_surface_win_rate | DECIMAL(7,6) | 定義SQLを参照 |
jockey_year_racecourse_surface_top2_rate | DECIMAL(7,6) | 定義SQLを参照 |
jockey_year_racecourse_surface_top3_rate | DECIMAL(7,6) | 定義SQLを参照 |
jockey_career_surface_start_count | INT | 定義SQLを参照 |
jockey_career_surface_win_rate | DECIMAL(7,6) | 定義SQLを参照 |
jockey_career_surface_top2_rate | DECIMAL(7,6) | 定義SQLを参照 |
jockey_career_surface_top3_rate | DECIMAL(7,6) | 定義SQLを参照 |
jockey_career_distance_start_count | INT | 定義SQLを参照 |
jockey_career_distance_win_rate | DECIMAL(7,6) | 定義SQLを参照 |
jockey_career_distance_top2_rate | DECIMAL(7,6) | 定義SQLを参照 |
jockey_career_distance_top3_rate | DECIMAL(7,6) | 定義SQLを参照 |
jockey_career_racecourse_surface_start_count | INT | 定義SQLを参照 |
jockey_career_racecourse_surface_win_rate | DECIMAL(7,6) | 定義SQLを参照 |
jockey_career_racecourse_surface_top2_rate | DECIMAL(7,6) | 定義SQLを参照 |
jockey_career_racecourse_surface_top3_rate | DECIMAL(7,6) | 定義SQLを参照 |
trainer_source_status_cd | VARCHAR(32) | 定義SQLを参照 |
trainer_year_surface_start_count | INT | 定義SQLを参照 |
trainer_year_surface_win_rate | DECIMAL(7,6) | 定義SQLを参照 |
trainer_year_surface_top2_rate | DECIMAL(7,6) | 定義SQLを参照 |
trainer_year_surface_top3_rate | DECIMAL(7,6) | 定義SQLを参照 |
trainer_year_distance_start_count | INT | 定義SQLを参照 |
trainer_year_distance_win_rate | DECIMAL(7,6) | 定義SQLを参照 |
trainer_year_distance_top2_rate | DECIMAL(7,6) | 定義SQLを参照 |
trainer_year_distance_top3_rate | DECIMAL(7,6) | 定義SQLを参照 |
trainer_year_racecourse_surface_start_count | INT | 定義SQLを参照 |
trainer_year_racecourse_surface_win_rate | DECIMAL(7,6) | 定義SQLを参照 |
trainer_year_racecourse_surface_top2_rate | DECIMAL(7,6) | 定義SQLを参照 |
trainer_year_racecourse_surface_top3_rate | DECIMAL(7,6) | 定義SQLを参照 |
trainer_career_surface_start_count | INT | 定義SQLを参照 |
trainer_career_surface_win_rate | DECIMAL(7,6) | 定義SQLを参照 |
trainer_career_surface_top2_rate | DECIMAL(7,6) | 定義SQLを参照 |
trainer_career_surface_top3_rate | DECIMAL(7,6) | 定義SQLを参照 |
trainer_career_distance_start_count | INT | 定義SQLを参照 |
trainer_career_distance_win_rate | DECIMAL(7,6) | 定義SQLを参照 |
trainer_career_distance_top2_rate | DECIMAL(7,6) | 定義SQLを参照 |
trainer_career_distance_top3_rate | DECIMAL(7,6) | 定義SQLを参照 |
trainer_career_racecourse_surface_start_count | INT | 定義SQLを参照 |
trainer_career_racecourse_surface_win_rate | DECIMAL(7,6) | 定義SQLを参照 |
trainer_career_racecourse_surface_top2_rate | DECIMAL(7,6) | 定義SQLを参照 |
trainer_career_racecourse_surface_top3_rate | DECIMAL(7,6) | 定義SQLを参照 |
horse_style_source_status_cd | VARCHAR(32) | 定義SQLを参照 |
horse_style_source_count | INT | 定義SQLを参照 |
nige_style_rate | DECIMAL(7,6) | 定義SQLを参照 |
senko_style_rate | DECIMAL(7,6) | 定義SQLを参照 |
sashi_style_rate | DECIMAL(7,6) | 定義SQLを参照 |
oikomi_style_rate | DECIMAL(7,6) | 定義SQLを参照 |
member_overall_tai_rank | SMALLINT | 定義SQLを参照 |
member_overall_tai_mean_diff | DECIMAL(7,3) | 定義SQLを参照 |
member_overall_tai_max_diff | DECIMAL(7,3) | 定義SQLを参照 |
member_surface_distance_tai_rank | SMALLINT | 定義SQLを参照 |
member_surface_distance_tai_mean_diff | DECIMAL(7,3) | 定義SQLを参照 |
member_surface_distance_tai_max_diff | DECIMAL(7,3) | 定義SQLを参照 |
member_surface_distance_epi_rank | SMALLINT | 定義SQLを参照 |
member_surface_distance_epi_mean_diff | DECIMAL(7,3) | 定義SQLを参照 |
member_surface_distance_epi_max_diff | DECIMAL(7,3) | 定義SQLを参照 |
member_surface_distance_lpi_rank | SMALLINT | 定義SQLを参照 |
member_surface_distance_lpi_mean_diff | DECIMAL(7,3) | 定義SQLを参照 |
member_surface_distance_lpi_max_diff | DECIMAL(7,3) | 定義SQLを参照 |
member_surface_distance_spi_rank | SMALLINT | 定義SQLを参照 |
member_surface_distance_spi_mean_diff | DECIMAL(7,3) | 定義SQLを参照 |
member_surface_distance_spi_max_diff | DECIMAL(7,3) | 定義SQLを参照 |
member_surface_distance_kri_rank | SMALLINT | 定義SQLを参照 |
member_surface_distance_kri_mean_diff | DECIMAL(7,3) | 定義SQLを参照 |
member_surface_distance_kri_max_diff | DECIMAL(7,3) | 定義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`)))
利用・分析時に参照する主な独自コード・区分です。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 | 馬単 |
07 | 3連複 |
08 | 3連単 |
mining_bunrui_cd2 valuesprediction_mark_cd6 values保存値の〇は漢数字のゼロです。印はuser_horse_memoでレースごとに保存します。各印の呼び方は一般的な目安です。
使用テーブル:user_horse_memo
| 値 | 意味 |
|---|---|
◎ | 本命 |
〇 | 対抗 |
▲ | 単穴 |
△ | 連下 |
☆ | 注目 |
NULL | 印なし |
color_cd5 valuesuser_watch_horseの色コードです。未選択は別の色値ではなく、注目馬の登録がない状態です。
使用テーブル:user_watch_horse
| 値 | 意味 |
|---|---|
red | 赤 |
blue | 青 |
green | 緑 |
yellow | 黄 |
purple | 紫 |