Source: tblbarriertrials → Destination: trial_meeting
| Source Column |
Destination Column |
Renamed? |
BDate |
race_date
← BDate
|
Yes
|
BCourseID |
course_id
← BCourseID
|
Yes
|
BDiscipline |
discipline
← BDiscipline
|
Yes
|
BTrackName |
track
← BTrackName
|
Yes
|
Bupdated |
last_update
← Bupdated
|
Yes
|
BTrialType |
trial_type
← BTrialType
|
Yes
|
Source: tblbarriertrials → Destination: trial_race
| Source Column |
Destination Column |
Renamed? |
BDate |
race_date
← BDate
|
Yes
|
BRaceNo |
race_number
← BRaceNo
|
Yes
|
BCourseID |
course_id
← BCourseID
|
Yes
|
BTrackName |
track
← BTrackName
|
Yes
|
BTrackSurface |
surface
← BTrackSurface
|
Yes
|
BDistance |
distance
← BDistance
|
Yes
|
BDistance |
distance_val
← BDistance
|
Yes
|
BDiscipline |
race_discipline
← BDiscipline
|
Yes
|
BTime |
time_winner
← BTime
|
Yes
|
BMileRate |
mile_rate
← BMileRate
|
Yes
|
BTime1 |
sectional_time1
← BTime1
|
Yes
|
BTime2 |
sectional_time2
← BTime2
|
Yes
|
Bupdated |
last_update
← Bupdated
|
Yes
|
Source: tblbarriertrials → Destination: trial_run
| Source Column |
Destination Column |
Renamed? |
BDate |
race_date
← BDate
|
Yes
|
BRaceNo |
race_number
← BRaceNo
|
Yes
|
BTabNo |
tab_number
← BTabNo
|
Yes
|
BHorse |
runner_name
← BHorse
|
Yes
|
BHorseID |
runner_id
← BHorseID
|
Yes
|
BAgeAt |
age_at
← BAgeAt
|
Yes
|
BCourseID |
course_id
← BCourseID
|
Yes
|
BDiscipline |
discipline
← BDiscipline
|
Yes
|
BWT |
weight
← BWT
|
Yes
|
BMarg |
margin
← BMarg
|
Yes
|
BJockey |
jockey_name
← BJockey
|
Yes
|
BJockeyID |
jockey_id
← BJockeyID
|
Yes
|
BFP |
finish_position
← BFP
|
Yes
|
BDisqualified |
is_disqualified
← BDisqualified
|
Yes
|
BSettle |
settling_position
← BSettle
|
Yes
|
B1200 |
pos_1200
← B1200
|
Yes
|
B800 |
pos_800
← B800
|
Yes
|
BTurn |
turn
← BTurn
|
Yes
|
BTrainerID |
trainer_id
← BTrainerID
|
Yes
|
BTrainerCode |
trainer_name
← BTrainerCode
|
Yes
|
BUpdated |
last_update
← BUpdated
|
Yes
|
BGear |
gear_change
← BGear
|
Yes
|
BOffComment |
official_inrunning
← BOffComment
|
Yes
|
BOffCommentShort |
official_inrunning_short
← BOffCommentShort
|
Yes
|
BTPComment |
video_comment
← BTPComment
|
Yes
|
BComment |
video_short_comment
← BComment
|
Yes
|
BRunnerTime |
runner_time
← BRunnerTime
|
Yes
|
BRunnerTimeSec |
runner_time_sec
← BRunnerTimeSec
|
Yes
|
Click a source mapping table for any editable FK column below.
These links determine which config_id_mappings entries are used to translate source IDs → destination IDs on every scheduled run.
course.course_id
No mappings found for the selected source table. FK values will be NULL unless you select a different table.
runner.runner_id
No mappings found for the selected source table. FK values will be NULL unless you select a different table.
jockey.jockey_id
No mappings found for the selected source table. FK values will be NULL unless you select a different table.
trainer.trainer_id
No mappings found for the selected source table. FK values will be NULL unless you select a different table.
| Column |
How resolved |
Notes |
country_id |
(derived) → country |
Looked up from course.country_id after course_id resolves |
meeting_id |
(generated) → trial_meeting |
New ID inserted in Pass 1 |
race_id |
(generated) → trial_race |
New ID inserted in Pass 2 |