Mappings — AUTO SYNC RUN - Titan Command

AUTO SYNC RUN — Mappings & FK

RS TO QDB

1 tblfeatureraces → feature_race 15 cols

#	Source Column	Destination Column
1	`FRID`	`id` ↔ renamed
2	`FRDate`	`race_date` ↔ renamed
3	`CrsUniqueID`	`course_id` ↔ renamed
4	`FeatureDiscipline`	`discipline` ↔ renamed
5	`FRName`	`feature_name` ↔ renamed
6	`OfficialName`	`official_name` ↔ renamed
7	`FRGroup`	`group` ↔ renamed
8	`FRSex`	`sex` ↔ renamed
9	`FRAge`	`age` ↔ renamed
10	`FRType`	`type` ↔ renamed
11	`FRDist`	`distance` ↔ renamed
12	`AusRaceCode`	`code` ↔ renamed
13	`Description`	`description`
14	`History`	`history`
15	`NextFeatureDate`	`next_race_date` ↔ renamed

No foreign key relationships detected involving this table.

2 tblmeetings → meeting 16 cols

#	Source Column	Destination Column
1	`MUniqueID`	`id` ↔ renamed
2	`MDate`	`race_date` ↔ renamed
3	`McourseID`	`course_id` ↔ renamed
4	`MDiscipline`	`discipline` ↔ renamed
5	`MCountryID`	`country_id` ↔ renamed
6	`MMCP`	`mpc` ↔ renamed
7	`MRails`	`rails` ↔ renamed
8	`MWeather`	`weather` ↔ renamed
9	`MPent`	`penetrometer` ↔ renamed
10	`MTemp`	`temperature` ↔ renamed
11	`MLastUpdate`	`last_update` ↔ renamed
12	`MLock`	`is_locked` ↔ renamed
13	`PreLock`	`is_prelocked` ↔ renamed
14	`MTab`	`is_tab` ↔ renamed
15	`MOfficialResults`	`is_official_results` ↔ renamed
16	`MAdminComments`	`admin_comments` ↔ renamed

No foreign key relationships detected involving this table.

3 tblraces → race 75 cols

#	Source Column	Destination Column
1	`RUniqueID`	`id` ↔ renamed
2	`RDate`	`race_date` ↔ renamed
3	`RRaceNo`	`race_number` ↔ renamed
4	`RCourseID`	`course_id` ↔ renamed
5	`RMeetingID`	`rmeeting_id` ↔ renamed
6	`RCountryID`	`country_id` ↔ renamed
7	`RTrack`	`track` ↔ renamed
8	`RSurface`	`surface` ↔ renamed
9	`RPostTime`	`scheduled_post_time` ↔ renamed
10	`RDist`	`distance` ↔ renamed
11	`RDistVal`	`distance_val` ↔ renamed
12	`RDistImp`	`distance_imp` ↔ renamed
13	`RGroup`	`group_status` ↔ renamed
14	`RSOT`	`sot` ↔ renamed
15	`RSOTRating`	`sot_rating` ↔ renamed
16	`RClass`	`class_level` ↔ renamed
17	`RClassCode`	`class_code` ↔ renamed
18	`RClassDesc`	`race_description` ↔ renamed
19	`RRaceName`	`race_name` ↔ renamed
20	`RRaceNameOrig`	`race_name_orig` ↔ renamed
21	`RRaceNameShort`	`race_name_short` ↔ renamed
22	`RFeatureCode`	`feature_race_id` ↔ renamed
23	`RAge`	`race_age_restriction` ↔ renamed
24	`RSex`	`race_sex_restriction` ↔ renamed
25	`RType`	`race_type` ↔ renamed
26	`RTypeRating`	`race_type_rating` ↔ renamed
27	`ROffType`	`race_off_type` ↔ renamed
28	`RDiscipline`	`race_discipline` ↔ renamed
29	`RDisciplineType`	`race_harness_type` ↔ renamed
30	`RStartType`	`race_start_type` ↔ renamed
31	`RLimWT`	`limit_wt` ↔ renamed
32	`RLimWTOrig`	`limit_wt_orig` ↔ renamed
33	`RRunners`	`number_runners` ↔ renamed
34	`RTab`	`tab_status` ↔ renamed
35	`RPrizemoney`	`prize_money` ↔ renamed
36	`RPrizemoneyVal`	`prize_money_val` ↔ renamed
37	`ROrigPrizemoney`	`prize_money_orig` ↔ renamed
38	`RStandard`	`race_standard` ↔ renamed
39	`RavClubRat`	`average_club_rat` ↔ renamed
40	`RTime`	`time_winner` ↔ renamed
41	`RMileRate`	`mile_rate` ↔ renamed
42	`RBellLapTime`	`bell_lap_time` ↔ renamed
43	`RTimeSeconds`	`time_winner_sec` ↔ renamed
44	`RAdjTime`	`adjusted_time` ↔ renamed
45	`RTimeRecord`	`time_record` ↔ renamed
46	`RTimeAdj`	`time_adj` ↔ renamed
47	`RSecDist`	`sectional_dist` ↔ renamed
48	`RSecTime`	`sectional_time1` ↔ renamed
49	`RSecTime2`	`sectional_time2` ↔ renamed
50	`RAdjSecTime`	`sectional_adj_time` ↔ renamed
51	`RSecTimedMethod`	`sectional_timing_method` ↔ renamed
52	`RFCFOrig`	`fcf_orig` ↔ renamed
53	`RFCF`	`fcf` ↔ renamed
54	`RFCFWT`	`fcf_wt` ↔ renamed
55	`RLastUpdate`	`last_update` ↔ renamed
56	`RTimeQ`	`time_q` ↔ renamed
57	`RTimeFCF`	`time_fcf` ↔ renamed
58	`TVNFilename`	`file_name` ↔ renamed
59	`RCheck`	`is_checked` ↔ renamed
60	`RJumps`	`is_jump` ↔ renamed
61	`RRaceStandardAdj`	`race_standard_adj` ↔ renamed
62	`RRaceClassAdj`	`race_class_adj` ↔ renamed
63	`RRaceSecAdj`	`race_sec_adj` ↔ renamed
64	`rnote`	`note` ↔ renamed
65	`RPicnicRace`	`is_picnic_race` ↔ renamed
66	`RAutoQFCF`	`auto_qfcf` ↔ renamed
67	`RCondition`	`race_conditions` ↔ renamed
68	`RRSSynopsis`	`synopsis` ↔ renamed
69	`rVideoStart`	`race_video_start` ↔ renamed
70	`rVideoEnd`	`race_video_end` ↔ renamed
71	`TwitterVideo`	`twitter_video` ↔ renamed
72	`RAdminComments`	`admin_comments` ↔ renamed
73	`RClaimPrice`	`claiming_price` ↔ renamed
74	`RIsStraight`	`is_straight` ↔ renamed
75	`ROngoingW`	`winners_30days` ↔ renamed

No foreign key relationships detected involving this table.

4 tblruns → run 98 cols

#	Source Column	Destination Column
1	`WUniqueID`	`id` ↔ renamed
2	`WRaceID`	`race_id` ↔ renamed
3	`WDate`	`race_date` ↔ renamed
4	`wraceno`	`race_number` ↔ renamed
5	`WTabNo`	`tab_number` ↔ renamed
6	`WBracket`	`bracket` ↔ renamed
7	`WBracketTAB`	`bracket_tab` ↔ renamed
8	`WHorse`	`runner_name` ↔ renamed
9	`WHorseID`	`runner_id` ↔ renamed
10	`WSex`	`sex` ↔ renamed
11	`WAgeAt`	`age_at` ↔ renamed
12	`WHorWT`	`runner_wt` ↔ renamed
13	`WCourseID`	`course_id` ↔ renamed
14	`WDiscipline`	`discipline` ↔ renamed
15	`WClubRat`	`official_rating` ↔ renamed
16	`WWT`	`weight` ↔ renamed
17	`WWTImp`	`weight_alt` ↔ renamed
18	`WClaim`	`jockey_claim` ↔ renamed
19	`wIsApprentice`	`is_apprentice` ↔ renamed
20	`WClaimOrig`	`claim_alt` ↔ renamed
21	`BeatenMargin`	`beaten_margin` ↔ renamed
22	`WMarginOff`	`beaten_marg_to_runner` ↔ renamed
23	`wDNF`	`did_not_finish` ↔ renamed
24	`WJockey`	`jockey_name` ↔ renamed
25	`WJockeyID`	`jockey_id` ↔ renamed
26	`WPrizeWon`	`prize_aud` ↔ renamed
27	`wPrizeWonVal`	`prize_aud_val` ↔ renamed
28	`WPrizeWonOrig`	`prize_won_orig` ↔ renamed
29	`wPrizeOwner`	`prize_won_owner` ↔ renamed
30	`wPrizeOwnerOrig`	`prize_owner_orig` ↔ renamed
31	`wPrizeBreeder`	`prize_breeder` ↔ renamed
32	`wPrizeBreederOrig`	`prize_breeder_orig` ↔ renamed
33	`WBP`	`barrier_position` ↔ renamed
34	`WHCPDraw`	`handicap_draw` ↔ renamed
35	`WFP`	`finish_position` ↔ renamed
36	`WDeadHeat`	`is_dead_heat` ↔ renamed
37	`WDisqualified`	`is_disqualified` ↔ renamed
38	`WOpenOdds`	`opening_odds` ↔ renamed
39	`WSP`	`starting_price` ↔ renamed
40	`WSPVal`	`starting_price_value` ↔ renamed
41	`WPosTurn`	`pos_at_turn` ↔ renamed
42	`WSettle`	`pos_settling` ↔ renamed
43	`WSettleMarg`	`marg_settling` ↔ renamed
44	`W1200`	`pos_1200` ↔ renamed
45	`W1200Marg`	`marg_1200` ↔ renamed
46	`W800`	`pos_800` ↔ renamed
47	`W800Marg`	`marg_800` ↔ renamed
48	`WTurn`	`pos_turn` ↔ renamed
49	`wVP1200`	`vp_1200` ↔ renamed
50	`wVP1000`	`vp_1000` ↔ renamed
51	`wVP800`	`vp_800` ↔ renamed
52	`wVP600`	`vp_600` ↔ renamed
53	`wVP400`	`vp_400` ↔ renamed
54	`wVP200`	`vp_200` ↔ renamed
55	`wVST1200`	`vtime_1200` ↔ renamed
56	`wVST1000`	`vtime_1000` ↔ renamed
57	`wVST800`	`vtime_800` ↔ renamed
58	`wVST600`	`vtime_600` ↔ renamed
59	`wVST400`	`vtime_400` ↔ renamed
60	`wVST200`	`vtime_200` ↔ renamed
61	`WTrainerID`	`trainer_id` ↔ renamed
62	`WTrainer`	`trainer_name` ↔ renamed
63	`WTrainerAt`	`trainer_at` ↔ renamed
64	`WLastUpdate`	`last_update` ↔ renamed
65	`WHFA`	`rating` ↔ renamed
66	`WHFAAdj`	`rating_adj` ↔ renamed
67	`WHFAStewAdj`	`stewards_adj` ↔ renamed
68	`WTimeForm`	`timeform_rating` ↔ renamed
69	`WTimeFormSymbol`	`timeform_symbol` ↔ renamed
70	`WFixedTimeForm`	`is_timeform_fixed` ↔ renamed
71	`wRSTimeformTimeRat`	`timeform_time_rating` ↔ renamed
72	`WTimeRat`	`time_rating` ↔ renamed
73	`WTimeRatp`	`time_ratingp` ↔ renamed
74	`WTimeformAdj`	`timeform_adj` ↔ renamed
75	`WTimeformComment`	`timeform_comment` ↔ renamed
76	`WUKTF`	`uk_timeform_rating` ↔ renamed
77	`WUKTFSymbol`	`uk_timeform_symbol` ↔ renamed
78	`WFavRank`	`fav_win_place_rank` ↔ renamed
79	`WTurnMarg`	`marg_turn` ↔ renamed
80	`WSPFav`	`favourite_symbol` ↔ renamed
81	`WGEARCHANGE`	`gear_change` ↔ renamed
82	`WBlinkersOn`	`is_blinkers_on` ↔ renamed
83	`WOFFINRUNNING`	`official_inrunning` ↔ renamed
84	`WOffInRunningShort`	`official_inrunning_short` ↔ renamed
85	`wRunsCamp`	`runs_this_camp` ↔ renamed
86	`wWinFavRank`	`win_fav_rank` ↔ renamed
87	`WRunnerSectional`	`runner_sectional` ↔ renamed
88	`wStewardsLong`	`stewards_long` ↔ renamed
89	`wStewardsShort`	`stewards_short` ↔ renamed
90	`wOZSpeed`	`beyer_rating` ↔ renamed
91	`WRunnerTime`	`runner_time` ↔ renamed
92	`WRunnerTimeSec`	`runner_time_sec` ↔ renamed
93	`WDistRun`	`dist_run` ↔ renamed
94	`WMileRate`	`mile_rate` ↔ renamed
95	`WInRunningForiegn`	`running_foreign` ↔ renamed
96	`WSpeedFigure`	`speed_figure` ↔ renamed
97	`WUncoupled`	`uncoupled` ↔ renamed
98	`WBonusSchemeId`	`bonus_scheme_id` ↔ renamed

No foreign key relationships detected involving this table.

5 tblprerace_meetings → racecard_meeting 25 cols

#	Source Column	Destination Column
1	`MeetingID`	`id` ↔ renamed
2	`MDate`	`race_date` ↔ renamed
3	`MRefID`	`race_reference` ↔ renamed
4	`MCrsID`	`course_id` ↔ renamed
5	`MDiscipline`	`discipline` ↔ renamed
6	`MLastUpdated`	`last_update` ↔ renamed
7	`MRSMeetingID`	`meeting_index_id` ↔ renamed
8	`weatherForecast`	`weather_forecast` ↔ renamed
9	`rail`	`rail`
10	`penetrometer`	`penetrometer`
11	`going`	`going`
12	`stalls`	`stalls`
13	`weather`	`weather`
14	`track`	`track`
15	`MStage`	`acceptance_stage` ↔ renamed
16	`NSWTabCode`	`nsw_sellcode` ↔ renamed
17	`VICTabCode`	`vic_sellcode` ↔ renamed
18	`QLDTabCode`	`qld_sellcode` ↔ renamed
19	`TabITSP`	`itsp_code` ↔ renamed
20	`MTabWeather`	`tab_weather` ↔ renamed
21	`MTabSOT`	`tab_sot` ↔ renamed
22	`RSKey`	`rs_key` ↔ renamed
23	`RSId`	`rs_id` ↔ renamed
24	`MTABDayNight`	`day_night` ↔ renamed
25	`MMPCType`	`mpc` ↔ renamed

No foreign key relationships detected involving this table.

6 tblprerace_races → racecard_race 74 cols

#	Source Column	Destination Column
1	`RaceID`	`id` ↔ renamed
2	`RMeetingID`	`racecard_meeting_id` ↔ renamed
3	`RNumber`	`race_number` ↔ renamed
4	`RVenue`	`course_code` ↔ renamed
5	`RCrsID`	`course_id` ↔ renamed
6	`RCountryID`	`country_id` ↔ renamed
7	`RName`	`name` ↔ renamed
8	`RFeatureCode`	`feature_race_id` ↔ renamed
9	`RDate`	`race_date` ↔ renamed
10	`RRefID`	`race_reference` ↔ renamed
11	`RDistance`	`distance` ↔ renamed
12	`RDistanceImp`	`distance_imp` ↔ renamed
13	`RTime`	`time` ↔ renamed
14	`RClass`	`class_level` ↔ renamed
15	`RPMUType`	`type` ↔ renamed
16	`RClassDesc`	`class_desc` ↔ renamed
17	`RClassDescEN`	`class_desc_en` ↔ renamed
18	`RClassDescENBrief`	`class_desc_enbrief` ↔ renamed
19	`RDiscipline`	`discipline` ↔ renamed
20	`RHorseType`	`horse_type` ↔ renamed
21	`RDisciplineType`	`harness_type` ↔ renamed
22	`RStartType`	`harness_start_type` ↔ renamed
23	`RGroup`	`group` ↔ renamed
24	`RHCP`	`hcp` ↔ renamed
25	`RTypeRating`	`type_rating` ↔ renamed
26	`RAge`	`age` ↔ renamed
27	`RSex`	`sex` ↔ renamed
28	`RWT`	`wt` ↔ renamed
29	`RPrizemoney`	`prizemoney` ↔ renamed
30	`RPrizemoneyOrig`	`prizemoney_orig` ↔ renamed
31	`RApp`	`apprentice_details` ↔ renamed
32	`RTrack`	`track` ↔ renamed
33	`RSurface`	`surface` ↔ renamed
34	`RCondition`	`condition` ↔ renamed
35	`RPrizemoney1`	`prizemoney1` ↔ renamed
36	`RPrizemoney1Orig`	`prizemoney1_orig` ↔ renamed
37	`RPrizemoney2`	`prizemoney2` ↔ renamed
38	`RPrizemoney2Orig`	`prizemoney2_orig` ↔ renamed
39	`RPrizemoney3`	`prizemoney3` ↔ renamed
40	`RPrizemoney3Orig`	`prizemoney3_orig` ↔ renamed
41	`RPrizemoney4`	`prizemoney4` ↔ renamed
42	`RPrizemoney4Orig`	`prizemoney4_orig` ↔ renamed
43	`RPrizemoney5`	`prizemoney5` ↔ renamed
44	`RPrizemoney5Orig`	`prizemoney5_orig` ↔ renamed
45	`RPrizemoney6`	`prizemoney6` ↔ renamed
46	`RPrizemoney6Orig`	`prizemoney6_orig` ↔ renamed
47	`RPrizemoney7`	`prizemoney7` ↔ renamed
48	`RPrizemoney7Orig`	`prizemoney7_orig` ↔ renamed
49	`RPrizemoney8`	`prizemoney8` ↔ renamed
50	`RPrizemoney8Orig`	`prizemoney8_orig` ↔ renamed
51	`RPrizemoney9`	`prizemoney9` ↔ renamed
52	`RPrizemoney9Orig`	`prizemoney9_orig` ↔ renamed
53	`RPrizemoney10`	`prizemoney10` ↔ renamed
54	`RPrizemoney10Orig`	`prizemoney10_orig` ↔ renamed
55	`SOT`	`sot`
56	`SOTOfficial`	`sotofficial`
57	`raceCompleteTime`	`race_complete_time` ↔ renamed
58	`last600`	`last600`
59	`RGMTTime`	`gmttime` ↔ renamed
60	`RTimeChanged`	`time_changed` ↔ renamed
61	`rThisFS`	`field_strength` ↔ renamed
62	`RDOD`	`dod` ↔ renamed
63	`RJumpTime`	`jump_time` ↔ renamed
64	`RFormChecked`	`form_checked` ↔ renamed
65	`AvgWinsPerRunner`	`avg_wins_per_runner` ↔ renamed
66	`RResultID`	`result_id` ↔ renamed
67	`RStage`	`acceptance_stage` ↔ renamed
68	`YoutubeKey`	`youtube_key` ↔ renamed
69	`RJumps`	`jumps` ↔ renamed
70	`RClaimPrice`	`claiming_price` ↔ renamed
71	`RIsStraight`	`is_straight` ↔ renamed
72	`ROriginalPostTime`	`original_post_time` ↔ renamed
73	`ROriginalPostTimeUTC`	`original_post_time_utc` ↔ renamed
74	`RCloseTime`	`close_time` ↔ renamed

No foreign key relationships detected involving this table.

7 tblprerace_runners → racecard_runner 60 cols

#	Source Column	Destination Column
1	`RunnerID`	`id` ↔ renamed
2	`RaceID`	`race_id` ↔ renamed
3	`HRDate`	`race_date` ↔ renamed
4	`HRCourse`	`course_code` ↔ renamed
5	`HRCourseID`	`course_id` ↔ renamed
6	`HRDiscipline`	`discipline` ↔ renamed
7	`HRNumber`	`rnumber` ↔ renamed
8	`HName`	`runner_name` ↔ renamed
9	`HCountryOrig`	`country` ↔ renamed
10	`HID`	`runner_id` ↔ renamed
11	`HTab`	`tab_number` ↔ renamed
12	`HBracket`	`bracket` ↔ renamed
13	`HBracketTAB`	`bracket_tab` ↔ renamed
14	`HHorseYear`	`year_of_foal` ↔ renamed
15	`HWeight`	`weight` ↔ renamed
16	`HWeightImp`	`weight_imp` ↔ renamed
17	`HJockey`	`jockey_name` ↔ renamed
18	`HJockeyID`	`jockey_id` ↔ renamed
19	`HJockeyApprentice`	`jockey_apprentice` ↔ renamed
20	`HJockeyClaim`	`jockey_claim` ↔ renamed
21	`HConcessionDriver`	`concession_driver` ↔ renamed
22	`HTrainer`	`trainer` ↔ renamed
23	`HTrainerID`	`trainer_id` ↔ renamed
24	`HTrainerLocation`	`trainer_location` ↔ renamed
25	`HTrainerLocatioinID`	`trainer_location_id` ↔ renamed
26	`HBP`	`barrier_position` ↔ renamed
27	`HHCPDraw`	`handicap_draw` ↔ renamed
28	`HJockeyRate`	`jockey_rate` ↔ renamed
29	`HPaceRatio`	`pace_ratio` ↔ renamed
30	`HPaceRatioE`	`pace_ratio_early` ↔ renamed
31	`HGSpeed`	`gate_speed` ↔ renamed
32	`HClassWin`	`class_win` ↔ renamed
33	`HBestWin`	`best_win` ↔ renamed
34	`HTrainRate`	`trainer_rating` ↔ renamed
35	`HJockeyCourseFlag`	`jockey_course_flag` ↔ renamed
36	`hEmergency`	`is_emergency` ↔ renamed
37	`FinishingPosition`	`finish_position` ↔ renamed
38	`DNF`	`did_not_finish` ↔ renamed
39	`RSSR`	`rssr`
40	`beatenMargin`	`beaten_margin` ↔ renamed
41	`HMarginOff`	`margin_off` ↔ renamed
42	`prepost`	`prepost`
43	`startingPrice`	`starting_price` ↔ renamed
44	`scratching`	`is_scratched` ↔ renamed
45	`LateScr`	`is_late_scratching` ↔ renamed
46	`HJockeyOrg`	`jockey_org` ↔ renamed
47	`displayBP`	`display_barrier_position` ↔ renamed
48	`HJockeyOrgId`	`jockey_org_id` ↔ renamed
49	`SGPSelection`	`sgpselection`
50	`HGearChange`	`gear_change` ↔ renamed
51	`HRStage`	`acceptance_stage` ↔ renamed
52	`HOffRat`	`off_rat` ↔ renamed
53	`HBlinkers`	`has_blinkers` ↔ renamed
54	`BestTime`	`best_time` ↔ renamed
55	`BestMileRate`	`best_mile_rate` ↔ renamed
56	`HClass`	`class` ↔ renamed
57	`SkyPaceE`	`sky_pace_e` ↔ renamed
58	`SkyPaceL`	`sky_pace_l` ↔ renamed
59	`HClaimAmount`	`claim_amount` ↔ renamed
60	`HUncoupled`	`uncoupled` ↔ renamed

No foreign key relationships detected involving this table.

8 tbltsales_company → sales_company 4 cols

#	Source Column	Destination Column
1	`salesCompanyId`	`id` ↔ renamed
2	`salesCompany`	`company_name` ↔ renamed
3	`companyCountryId`	`country_id` ↔ renamed
4	`CompanyLogo`	`logo_url` ↔ renamed

No foreign key relationships detected involving this table.

9 tbltsales → sales_sale 7 cols

#	Source Column	Destination Column
1	`saleId`	`id` ↔ renamed
2	`salesCompanyId`	`company_id` ↔ renamed
3	`saleName`	`sale_name` ↔ renamed
4	`startDate`	`start_date` ↔ renamed
5	`endDate`	`end_date` ↔ renamed
6	`saleCode`	`sale_code` ↔ renamed
7	`salesCountryId`	`country_id` ↔ renamed

No foreign key relationships detected involving this table.

10 tbltsales_sessions → sales_session 7 cols

#	Source Column	Destination Column
1	`sessionId`	`id` ↔ renamed
2	`saleId`	`sale_id` ↔ renamed
3	`sessionName`	`session_name` ↔ renamed
4	`sessionNo`	`session_no` ↔ renamed
5	`sessionDate`	`session_date` ↔ renamed
6	`startLot`	`start_lot` ↔ renamed
7	`endLot`	`end_lot` ↔ renamed

No foreign key relationships detected involving this table.

11 tbltsales_lots → sales_lot 28 cols

#	Source Column	Destination Column
1	`lotId`	`id` ↔ renamed
2	`saleId`	`sale_id` ↔ renamed
3	`sessionId`	`session_id` ↔ renamed
4	`SL_Lot`	`lot_number` ↔ renamed
5	`SL_Horse`	`runner_name` ↔ renamed
6	`SL_HorseId`	`runner_id` ↔ renamed
7	`SL_DOB`	`foal_date` ↔ renamed
8	`SL_Sex`	`sex` ↔ renamed
9	`SL_Color`	`colour` ↔ renamed
10	`SL_Sire`	`sire_name` ↔ renamed
11	`SL_SireId`	`sire_id` ↔ renamed
12	`SL_Dam`	`dam_name` ↔ renamed
13	`SL_DamId`	`dam_id` ↔ renamed
14	`SL_CoveringSire`	`covering_sire_name` ↔ renamed
15	`SL_CoveringSireId`	`covering_sire_id` ↔ renamed
16	`SL_Vendor`	`vendor_name` ↔ renamed
17	`SL_VendorId`	`vendor_id` ↔ renamed
18	`SL_Purchaser`	`purchaser_name` ↔ renamed
19	`SL_PurchaserId`	`purchaser_id` ↔ renamed
20	`SL_Reserve`	`reserve_price` ↔ renamed
21	`SL_Result`	`result_notes` ↔ renamed
22	`SL_Status`	`status` ↔ renamed
23	`SL_Price`	`sale_price` ↔ renamed
24	`SL_Location`	`location` ↔ renamed
25	`SL_Product`	`product_type` ↔ renamed
26	`SL_Confirmed`	`is_confirmed` ↔ renamed
27	`SL_PdfLink`	`pdf_link` ↔ renamed
28	`SL_ImgLink`	`img_link` ↔ renamed

No foreign key relationships detected involving this table.

12 tblstewards → stewards 6 cols

#	Source Column	Destination Column
1	`ID`	`id`
2	`StewHID`	`stew_runner_id` ↔ renamed
3	`StewDate`	`stew_date` ↔ renamed
4	`StewCourse`	`stew_course` ↔ renamed
5	`StewType`	`type` ↔ renamed
6	`StewInfo`	`stew_info` ↔ renamed

No foreign key relationships detected involving this table.

13 tbldividends → dividends 14 cols

#	Source Column	Destination Column
1	`ID`	`id`
2	`CountryID`	`country_id` ↔ renamed
3	`MeetingID`	`meeting_id` ↔ renamed
4	`RaceID`	`race_id` ↔ renamed
5	`PreRaceID`	`racecard_race_id` ↔ renamed
6	`Originator`	`originator`
7	`RaceLegs`	`race_legs` ↔ renamed
8	`DivType`	`type` ↔ renamed
9	`DivComb`	`div_comb` ↔ renamed
10	`Dividend`	`dividend`
11	`Pool`	`pool`
12	`DivNote`	`div_note` ↔ renamed
13	`Unit`	`unit`
14	`UpdatedTime`	`last_update` ↔ renamed

No foreign key relationships detected involving this table.