docker-compose/mysql5.7/mysql/data/heatwatch/rfyview.frm

TYPE=VIEW
query=select `evtbubby`.`intPastureId` AS `intPastureId`,`evtbubby`.`intEvtId` AS `intEvtId`,`evtbubby`.`intCowId` AS `evtCowId`,`evtbubby`.`dateEvtDate` AS `evtbDate`,(case when (`heatwatch`.`bubby`.`IsRepaired` = 0) then \'否\' else \'是\' end) AS `bIsRepaired`,(case when (`heatwatch`.`bubby`.`IsBubby` = 0) then \'否\' else \'是\' end) AS `bIsBubby`,`bemployee`.`varEmployeeName` AS `bPersoner`,`evtbubby`.`varNotes` AS `varbNotes`,`heatwatch`.`bubbycure`.`CureDate` AS `bCureDate`,`heatwatch`.`bubbycure`.`footCount` AS `bCount`,`heatwatch`.`bubbycure`.`IntervalDays` AS `IntervalDays`,`bcemployee`.`varEmployeeName` AS `bcPersoner`,`evtbubbycure`.`varNotes` AS `varbcNotes` from (((((`heatwatch`.`events` `evtbubby` join `heatwatch`.`bubby` on(((`heatwatch`.`bubby`.`intEvtId` = `evtbubby`.`intEvtId`) and (`heatwatch`.`bubby`.`intPastureId` = `evtbubby`.`intPastureId`)))) left join `heatwatch`.`employee` `bemployee` on(((`evtbubby`.`intPersoner` = `bemployee`.`intEmployeeId`) and (`evtbubby`.`intPastureId` = `bemployee`.`intPastureId`)))) left join `heatwatch`.`bubbycure` on(((`heatwatch`.`bubby`.`intBubbyId` = `heatwatch`.`bubbycure`.`intBubbyId`) and (`heatwatch`.`bubby`.`intPastureId` = `heatwatch`.`bubbycure`.`intPastureId`)))) left join `heatwatch`.`events` `evtbubbycure` on(((`heatwatch`.`bubbycure`.`intEvtId` = `evtbubbycure`.`intEvtId`) and (`heatwatch`.`bubbycure`.`intPastureId` = `evtbubbycure`.`intPastureId`)))) left join `heatwatch`.`employee` `bcemployee` on(((`evtbubbycure`.`intPersoner` = `bcemployee`.`intEmployeeId`) and (`evtbubbycure`.`intPastureId` = `bcemployee`.`intPastureId`))))
md5=6a6e27993b43f0d9ac14e04439395f1a
updatable=0
algorithm=0
definer_user=root
definer_host=localhost
suid=1
with_check_option=0
timestamp=2022-12-14 10:07:38
create-version=1
source=select `evtbubby`.`intPastureId` AS `intPastureId`,`evtbubby`.`intEvtId` AS `intEvtId`,`evtbubby`.`intCowId` AS `evtCowId`,`evtbubby`.`dateEvtDate` AS `evtbDate`,case when `bubby`.`IsRepaired` = 0 then \'否\' else \'是\' end AS `bIsRepaired`,case when `bubby`.`IsBubby` = 0 then \'否\' else \'是\' end AS `bIsBubby`,`bemployee`.`varEmployeeName` AS `bPersoner`,`evtbubby`.`varNotes` AS `varbNotes`,`bubbycure`.`CureDate` AS `bCureDate`,`bubbycure`.`footCount` AS `bCount`,`bubbycure`.`IntervalDays` AS `IntervalDays`,`bcemployee`.`varEmployeeName` AS `bcPersoner`,`evtbubbycure`.`varNotes` AS `varbcNotes` from (((((`events` `evtbubby` join `bubby` on(`bubby`.`intEvtId` = `evtbubby`.`intEvtId` and `bubby`.`intPastureId` = `evtbubby`.`intPastureId`)) left join `employee` `bemployee` on(`evtbubby`.`intPersoner` = `bemployee`.`intEmployeeId` and `evtbubby`.`intPastureId` = `bemployee`.`intPastureId`)) left join `bubbycure` on(`bubby`.`intBubbyId` = `bubbycure`.`intBubbyId` and `bubby`.`intPastureId` = `bubbycure`.`intPastureId`)) left join `events` `evtbubbycure` on(`bubbycure`.`intEvtId` = `evtbubbycure`.`intEvtId` and `bubbycure`.`intPastureId` = `evtbubbycure`.`intPastureId`)) left join `employee` `bcemployee` on(`evtbubbycure`.`intPersoner` = `bcemployee`.`intEmployeeId` and `evtbubbycure`.`intPastureId` = `bcemployee`.`intPastureId`))
client_cs_name=utf8
connection_cl_name=utf8_general_ci
view_body_utf8=select `evtbubby`.`intPastureId` AS `intPastureId`,`evtbubby`.`intEvtId` AS `intEvtId`,`evtbubby`.`intCowId` AS `evtCowId`,`evtbubby`.`dateEvtDate` AS `evtbDate`,(case when (`heatwatch`.`bubby`.`IsRepaired` = 0) then \'否\' else \'是\' end) AS `bIsRepaired`,(case when (`heatwatch`.`bubby`.`IsBubby` = 0) then \'否\' else \'是\' end) AS `bIsBubby`,`bemployee`.`varEmployeeName` AS `bPersoner`,`evtbubby`.`varNotes` AS `varbNotes`,`heatwatch`.`bubbycure`.`CureDate` AS `bCureDate`,`heatwatch`.`bubbycure`.`footCount` AS `bCount`,`heatwatch`.`bubbycure`.`IntervalDays` AS `IntervalDays`,`bcemployee`.`varEmployeeName` AS `bcPersoner`,`evtbubbycure`.`varNotes` AS `varbcNotes` from (((((`heatwatch`.`events` `evtbubby` join `heatwatch`.`bubby` on(((`heatwatch`.`bubby`.`intEvtId` = `evtbubby`.`intEvtId`) and (`heatwatch`.`bubby`.`intPastureId` = `evtbubby`.`intPastureId`)))) left join `heatwatch`.`employee` `bemployee` on(((`evtbubby`.`intPersoner` = `bemployee`.`intEmployeeId`) and (`evtbubby`.`intPastureId` = `bemployee`.`intPastureId`)))) left join `heatwatch`.`bubbycure` on(((`heatwatch`.`bubby`.`intBubbyId` = `heatwatch`.`bubbycure`.`intBubbyId`) and (`heatwatch`.`bubby`.`intPastureId` = `heatwatch`.`bubbycure`.`intPastureId`)))) left join `heatwatch`.`events` `evtbubbycure` on(((`heatwatch`.`bubbycure`.`intEvtId` = `evtbubbycure`.`intEvtId`) and (`heatwatch`.`bubbycure`.`intPastureId` = `evtbubbycure`.`intPastureId`)))) left join `heatwatch`.`employee` `bcemployee` on(((`evtbubbycure`.`intPersoner` = `bcemployee`.`intEmployeeId`) and (`evtbubbycure`.`intPastureId` = `bcemployee`.`intPastureId`))))