Inicio Explorar Ayuda
Registro Iniciar sesión
xuyiping
/
docker-compose
1
0
Fork 0
Archivos Incidencias 0 Pull Requests 0 Wiki
Rama: master
Ramas Etiquetas
docker-compose
/
mysql5.7
/
mysql
/
data
/
heatwatch
/
cowandbar.frm

cowandbar.frm 13 KB
Permalink Histórico Raw

123456789101112131415 
  1. TYPE=VIEW
    2. 

  2. query=select `c`.`intCowId` AS `evtCowId`,`c`.`intPastureId` AS `intPastureId`,`c`.`varCowCode` AS `varCowCode`,`c`.`dateBirthDate` AS `dateBirthDate`,`c`.`decBirWeight` AS `decBirWeight`,`c`.`decQuotiety` AS `decQuotiety`,`c`.`intCurBar` AS `intCurBar`,`c`.`intCurFetal` AS `intCurFetal`,`c`.`intDryEvtId` AS `intDryEvtId`,`c`.`intBreed` AS `intBreed`,`c`.`cSex` AS `cSex`,`c`.`dateCurDn` AS `dateCurDn`,`c`.`dateCurPz` AS `dateCurPz`,`c`.`intBull` AS `intBull`,`c`.`intPzCount` AS `intPzCount`,`c`.`varProvider` AS `varProvider`,`c`.`intPzPerson` AS `intPzPerson`,`c`.`dateCurYt` AS `dateCurYt`,`c`.`intYtPerson` AS `intYtPerson`,`c`.`dateCurFj` AS `dateCurFj`,`c`.`intFjResult` AS `intFjResult`,`c`.`intFjPerson` AS `intFjPerson`,`c`.`dateCurGn` AS `dateCurGn`,`c`.`dateCurCd` AS `dateCurCd`,`c`.`intCdClass` AS `intCdClass`,`c`.`dateLeave` AS `dateLeave`,`c`.`EID1` AS `EID1`,`c`.`EID2` AS `EID2`,`c`.`EID3` AS `EID3`,`c`.`LeftPic` AS `LeftPic`,`c`.`CenterPic` AS `CenterPic`,`c`.`RightPic` AS `RightPic`,`c`.`sireClass` AS `sireClass`,`c`.`belongState` AS `belongState`,`c`.`varMother` AS `varMother`,`c`.`wGrandFather` AS `wGrandFather`,`c`.`varFather` AS `varFather`,`c`.`grandFather` AS `grandFather`,`c`.`begats1` AS `begats1`,`c`.`begats2` AS `begats2`,`c`.`begats3` AS `begats3`,`c`.`zFYNDate` AS `zFYNDate`,`c`.`zYCNDate` AS `zYCNDate`,`c`.`zCLNDate` AS `zCLNDate`,`c`.`intLeaveClass` AS `intLeaveClass`,`c`.`intReason` AS `intReason`,`c`.`varGoWhere` AS `varGoWhere`,`c`.`calvingMonth` AS `calvingMonth`,`c`.`abortionDate` AS `abortionDate`,`c`.`21DateHYL` AS `21DateHYL`,`c`.`recentIllDate` AS `recentIllDate`,`c`.`recentIllName` AS `recentIllName`,`c`.`recentFootDate` AS `recentFootDate`,`c`.`ecentQuarantineDate` AS `ecentQuarantineDate`,`c`.`ecentQuarantineName` AS `ecentQuarantineName`,`c`.`ecentWeight` AS `ecentWeight`,`c`.`ecentWeightDate` AS `ecentWeightDate`,`c`.`ecentGrade` AS `ecentGrade`,`c`.`ecentGradeDate` AS `ecentGradeDate`,`c`.`intProduceDay` AS `intProduceDay`,`c`.`gaugeProduce` AS `gaugeProduce`,`c`.`intBodyCell` AS `intBodyCell`,`c`.`decFat` AS `decFat`,`c`.`decPro` AS `decPro`,`c`.`fatProRatio` AS `fatProRatio`,`c`.`intCurFetalProduce` AS `intCurFetalProduce`,`c`.`decP305F` AS `decP305F`,`c`.`decP305P` AS `decP305P`,`c`.`fatProRatio305` AS `fatProRatio305`,`c`.`decP305M` AS `decP305M`,`c`.`TimesDate` AS `TimesDate`,`c`.`TimesBeginDate` AS `TimesBeginDate`,`c`.`TimesProduce` AS `TimesProduce`,`c`.`MilkingStation` AS `MilkingStation`,`c`.`MilkingStationPlace` AS `MilkingStationPlace`,`c`.`avg7diversity` AS `avg7diversity`,`c`.`msProduceDay` AS `msProduceDay`,`c`.`produce7diversity` AS `produce7diversity`,`c`.`S15FlowRate` AS `S15FlowRate`,`c`.`S30FlowRate` AS `S30FlowRate`,`c`.`S60FlowRate` AS `S60FlowRate`,`c`.`M2FlowRate` AS `M2FlowRate`,`c`.`timeConsuming` AS `timeConsuming`,`c`.`conductivity` AS `conductivity`,`c`.`relativeActivity` AS `relativeActivity`,`c`.`intCurBarName` AS `intCurBarName`,`c`.`monthAge` AS `monthAge`,`c`.`firstMonthAge` AS `firstMonthAge`,`c`.`firstDate` AS `firstDate`,`c`.`firstDayAge` AS `firstDayAge`,`c`.`daughterCount` AS `daughterCount`,`c`.`childCount` AS `childCount`,`c`.`daughterProportion` AS `daughterProportion`,`c`.`calvingDays` AS `calvingDays`,`c`.`emptyDays` AS `emptyDays`,`c`.`lactationDays` AS `lactationDays`,`c`.`gravidityDays` AS `gravidityDays`,`c`.`estrusDays` AS `estrusDays`,`c`.`drymilkDays` AS `drymilkDays`,`c`.`pgCount` AS `pgCount`,`c`.`gnrhCount` AS `gnrhCount`,`c`.`productionDate` AS `productionDate`,`c`.`intHyCount` AS `intHyCount`,`c`.`isSexed` AS `isSexed`,`c`.`footdiseaseDays` AS `footdiseaseDays`,`c`.`IsJointInjury` AS `IsJointInjury`,`c`.`IsStepDown` AS `IsStepDown`,`c`.`IsfootdiseaseRepaired` AS `IsfootdiseaseRepaired`,`c`.`IsFootDisease` AS `IsFootDisease`,`c`.`footCount` AS `footCount`,`c`.`footDays` AS `footDays`,`c`.`bubbyDays` AS `bubbyDays`,`c`.`IsBubby` AS `IsBubby`,`c`.`IsbubbyRepaired` AS `IsbubbyRepaired`,`c`.`bubbyCount` AS `bubbyCount`,`c`.`bubbyRepairedDays` AS `bubbyRepairedDays`,`c`.`BlindBubbyCount` AS `BlindBubbyCount`,`c`.`lastTQ` AS `lastTQ`,`c`.`lastTQDays` AS `lastTQDays`,`c`.`hybriDays` AS `hybriDays`,`c`.`isTQ` AS `isTQ`,`c`.`hightActivity` AS `hightActivity`,`c`.`Activity` AS `Activity`,`c`.`lastTQDate` AS `lastTQDate`,`c`.`isEstrus` AS `isEstrus`,`c`.`addSource` AS `addSource`,`b`.`cowType` AS `cowType` from (`heatwatch`.`bar` `b` join `heatwatch`.`cow` `c` on(((`b`.`varBarCode` = `c`.`intCurBar`) and (`b`.`intPastureId` = `c`.`intPastureId`))))
    3. 

  3. md5=04489bb0a6b4b5c1069996e644bec60f
    4. 

  4. updatable=1
    5. 

  5. algorithm=0
    6. 

  6. definer_user=roo
    7. 

  7. definer_host=%
    8. 

  8. suid=1
    9. 

  9. with_check_option=0
    10. 

  10. timestamp=2022-12-14 10:07:38
    11. 

  11. create-version=1
    12. 

  12. source=select `c`.`intCowId` AS `evtCowId`,`c`.`intPastureId` AS `intPastureId`,`c`.`varCowCode` AS `varCowCode`,`c`.`dateBirthDate` AS `dateBirthDate`,`c`.`decBirWeight` AS `decBirWeight`,`c`.`decQuotiety` AS `decQuotiety`,`c`.`intCurBar` AS `intCurBar`,`c`.`intCurFetal` AS `intCurFetal`,`c`.`intDryEvtId` AS `intDryEvtId`,`c`.`intBreed` AS `intBreed`,`c`.`cSex` AS `cSex`,`c`.`dateCurDn` AS `dateCurDn`,`c`.`dateCurPz` AS `dateCurPz`,`c`.`intBull` AS `intBull`,`c`.`intPzCount` AS `intPzCount`,`c`.`varProvider` AS `varProvider`,`c`.`intPzPerson` AS `intPzPerson`,`c`.`dateCurYt` AS `dateCurYt`,`c`.`intYtPerson` AS `intYtPerson`,`c`.`dateCurFj` AS `dateCurFj`,`c`.`intFjResult` AS `intFjResult`,`c`.`intFjPerson` AS `intFjPerson`,`c`.`dateCurGn` AS `dateCurGn`,`c`.`dateCurCd` AS `dateCurCd`,`c`.`intCdClass` AS `intCdClass`,`c`.`dateLeave` AS `dateLeave`,`c`.`EID1` AS `EID1`,`c`.`EID2` AS `EID2`,`c`.`EID3` AS `EID3`,`c`.`LeftPic` AS `LeftPic`,`c`.`CenterPic` AS `CenterPic`,`c`.`RightPic` AS `RightPic`,`c`.`sireClass` AS `sireClass`,`c`.`belongState` AS `belongState`,`c`.`varMother` AS `varMother`,`c`.`wGrandFather` AS `wGrandFather`,`c`.`varFather` AS `varFather`,`c`.`grandFather` AS `grandFather`,`c`.`begats1` AS `begats1`,`c`.`begats2` AS `begats2`,`c`.`begats3` AS `begats3`,`c`.`zFYNDate` AS `zFYNDate`,`c`.`zYCNDate` AS `zYCNDate`,`c`.`zCLNDate` AS `zCLNDate`,`c`.`intLeaveClass` AS `intLeaveClass`,`c`.`intReason` AS `intReason`,`c`.`varGoWhere` AS `varGoWhere`,`c`.`calvingMonth` AS `calvingMonth`,`c`.`abortionDate` AS `abortionDate`,`c`.`21DateHYL` AS `21DateHYL`,`c`.`recentIllDate` AS `recentIllDate`,`c`.`recentIllName` AS `recentIllName`,`c`.`recentFootDate` AS `recentFootDate`,`c`.`ecentQuarantineDate` AS `ecentQuarantineDate`,`c`.`ecentQuarantineName` AS `ecentQuarantineName`,`c`.`ecentWeight` AS `ecentWeight`,`c`.`ecentWeightDate` AS `ecentWeightDate`,`c`.`ecentGrade` AS `ecentGrade`,`c`.`ecentGradeDate` AS `ecentGradeDate`,`c`.`intProduceDay` AS `intProduceDay`,`c`.`gaugeProduce` AS `gaugeProduce`,`c`.`intBodyCell` AS `intBodyCell`,`c`.`decFat` AS `decFat`,`c`.`decPro` AS `decPro`,`c`.`fatProRatio` AS `fatProRatio`,`c`.`intCurFetalProduce` AS `intCurFetalProduce`,`c`.`decP305F` AS `decP305F`,`c`.`decP305P` AS `decP305P`,`c`.`fatProRatio305` AS `fatProRatio305`,`c`.`decP305M` AS `decP305M`,`c`.`TimesDate` AS `TimesDate`,`c`.`TimesBeginDate` AS `TimesBeginDate`,`c`.`TimesProduce` AS `TimesProduce`,`c`.`MilkingStation` AS `MilkingStation`,`c`.`MilkingStationPlace` AS `MilkingStationPlace`,`c`.`avg7diversity` AS `avg7diversity`,`c`.`msProduceDay` AS `msProduceDay`,`c`.`produce7diversity` AS `produce7diversity`,`c`.`S15FlowRate` AS `S15FlowRate`,`c`.`S30FlowRate` AS `S30FlowRate`,`c`.`S60FlowRate` AS `S60FlowRate`,`c`.`M2FlowRate` AS `M2FlowRate`,`c`.`timeConsuming` AS `timeConsuming`,`c`.`conductivity` AS `conductivity`,`c`.`relativeActivity` AS `relativeActivity`,`c`.`intCurBarName` AS `intCurBarName`,`c`.`monthAge` AS `monthAge`,`c`.`firstMonthAge` AS `firstMonthAge`,`c`.`firstDate` AS `firstDate`,`c`.`firstDayAge` AS `firstDayAge`,`c`.`daughterCount` AS `daughterCount`,`c`.`childCount` AS `childCount`,`c`.`daughterProportion` AS `daughterProportion`,`c`.`calvingDays` AS `calvingDays`,`c`.`emptyDays` AS `emptyDays`,`c`.`lactationDays` AS `lactationDays`,`c`.`gravidityDays` AS `gravidityDays`,`c`.`estrusDays` AS `estrusDays`,`c`.`drymilkDays` AS `drymilkDays`,`c`.`pgCount` AS `pgCount`,`c`.`gnrhCount` AS `gnrhCount`,`c`.`productionDate` AS `productionDate`,`c`.`intHyCount` AS `intHyCount`,`c`.`isSexed` AS `isSexed`,`c`.`footdiseaseDays` AS `footdiseaseDays`,`c`.`IsJointInjury` AS `IsJointInjury`,`c`.`IsStepDown` AS `IsStepDown`,`c`.`IsfootdiseaseRepaired` AS `IsfootdiseaseRepaired`,`c`.`IsFootDisease` AS `IsFootDisease`,`c`.`footCount` AS `footCount`,`c`.`footDays` AS `footDays`,`c`.`bubbyDays` AS `bubbyDays`,`c`.`IsBubby` AS `IsBubby`,`c`.`IsbubbyRepaired` AS `IsbubbyRepaired`,`c`.`bubbyCount` AS `bubbyCount`,`c`.`bubbyRepairedDays` AS `bubbyRepairedDays`,`c`.`BlindBubbyCount` AS `BlindBubbyCount`,`c`.`lastTQ` AS `lastTQ`,`c`.`lastTQDays` AS `lastTQDays`,`c`.`hybriDays` AS `hybriDays`,`c`.`isTQ` AS `isTQ`,`c`.`hightActivity` AS `hightActivity`,`c`.`Activity` AS `Activity`,`c`.`lastTQDate` AS `lastTQDate`,`c`.`isEstrus` AS `isEstrus`,`c`.`addSource` AS `addSource`,`b`.`cowType` AS `cowType` from (`bar` `b` join `cow` `c` on(`b`.`varBarCode` = `c`.`intCurBar` and `b`.`intPastureId` = `c`.`intPastureId`))
    13. 

  13. client_cs_name=utf8
    14. 

  14. connection_cl_name=utf8_general_ci
    15. 

  15. view_body_utf8=select `c`.`intCowId` AS `evtCowId`,`c`.`intPastureId` AS `intPastureId`,`c`.`varCowCode` AS `varCowCode`,`c`.`dateBirthDate` AS `dateBirthDate`,`c`.`decBirWeight` AS `decBirWeight`,`c`.`decQuotiety` AS `decQuotiety`,`c`.`intCurBar` AS `intCurBar`,`c`.`intCurFetal` AS `intCurFetal`,`c`.`intDryEvtId` AS `intDryEvtId`,`c`.`intBreed` AS `intBreed`,`c`.`cSex` AS `cSex`,`c`.`dateCurDn` AS `dateCurDn`,`c`.`dateCurPz` AS `dateCurPz`,`c`.`intBull` AS `intBull`,`c`.`intPzCount` AS `intPzCount`,`c`.`varProvider` AS `varProvider`,`c`.`intPzPerson` AS `intPzPerson`,`c`.`dateCurYt` AS `dateCurYt`,`c`.`intYtPerson` AS `intYtPerson`,`c`.`dateCurFj` AS `dateCurFj`,`c`.`intFjResult` AS `intFjResult`,`c`.`intFjPerson` AS `intFjPerson`,`c`.`dateCurGn` AS `dateCurGn`,`c`.`dateCurCd` AS `dateCurCd`,`c`.`intCdClass` AS `intCdClass`,`c`.`dateLeave` AS `dateLeave`,`c`.`EID1` AS `EID1`,`c`.`EID2` AS `EID2`,`c`.`EID3` AS `EID3`,`c`.`LeftPic` AS `LeftPic`,`c`.`CenterPic` AS `CenterPic`,`c`.`RightPic` AS `RightPic`,`c`.`sireClass` AS `sireClass`,`c`.`belongState` AS `belongState`,`c`.`varMother` AS `varMother`,`c`.`wGrandFather` AS `wGrandFather`,`c`.`varFather` AS `varFather`,`c`.`grandFather` AS `grandFather`,`c`.`begats1` AS `begats1`,`c`.`begats2` AS `begats2`,`c`.`begats3` AS `begats3`,`c`.`zFYNDate` AS `zFYNDate`,`c`.`zYCNDate` AS `zYCNDate`,`c`.`zCLNDate` AS `zCLNDate`,`c`.`intLeaveClass` AS `intLeaveClass`,`c`.`intReason` AS `intReason`,`c`.`varGoWhere` AS `varGoWhere`,`c`.`calvingMonth` AS `calvingMonth`,`c`.`abortionDate` AS `abortionDate`,`c`.`21DateHYL` AS `21DateHYL`,`c`.`recentIllDate` AS `recentIllDate`,`c`.`recentIllName` AS `recentIllName`,`c`.`recentFootDate` AS `recentFootDate`,`c`.`ecentQuarantineDate` AS `ecentQuarantineDate`,`c`.`ecentQuarantineName` AS `ecentQuarantineName`,`c`.`ecentWeight` AS `ecentWeight`,`c`.`ecentWeightDate` AS `ecentWeightDate`,`c`.`ecentGrade` AS `ecentGrade`,`c`.`ecentGradeDate` AS `ecentGradeDate`,`c`.`intProduceDay` AS `intProduceDay`,`c`.`gaugeProduce` AS `gaugeProduce`,`c`.`intBodyCell` AS `intBodyCell`,`c`.`decFat` AS `decFat`,`c`.`decPro` AS `decPro`,`c`.`fatProRatio` AS `fatProRatio`,`c`.`intCurFetalProduce` AS `intCurFetalProduce`,`c`.`decP305F` AS `decP305F`,`c`.`decP305P` AS `decP305P`,`c`.`fatProRatio305` AS `fatProRatio305`,`c`.`decP305M` AS `decP305M`,`c`.`TimesDate` AS `TimesDate`,`c`.`TimesBeginDate` AS `TimesBeginDate`,`c`.`TimesProduce` AS `TimesProduce`,`c`.`MilkingStation` AS `MilkingStation`,`c`.`MilkingStationPlace` AS `MilkingStationPlace`,`c`.`avg7diversity` AS `avg7diversity`,`c`.`msProduceDay` AS `msProduceDay`,`c`.`produce7diversity` AS `produce7diversity`,`c`.`S15FlowRate` AS `S15FlowRate`,`c`.`S30FlowRate` AS `S30FlowRate`,`c`.`S60FlowRate` AS `S60FlowRate`,`c`.`M2FlowRate` AS `M2FlowRate`,`c`.`timeConsuming` AS `timeConsuming`,`c`.`conductivity` AS `conductivity`,`c`.`relativeActivity` AS `relativeActivity`,`c`.`intCurBarName` AS `intCurBarName`,`c`.`monthAge` AS `monthAge`,`c`.`firstMonthAge` AS `firstMonthAge`,`c`.`firstDate` AS `firstDate`,`c`.`firstDayAge` AS `firstDayAge`,`c`.`daughterCount` AS `daughterCount`,`c`.`childCount` AS `childCount`,`c`.`daughterProportion` AS `daughterProportion`,`c`.`calvingDays` AS `calvingDays`,`c`.`emptyDays` AS `emptyDays`,`c`.`lactationDays` AS `lactationDays`,`c`.`gravidityDays` AS `gravidityDays`,`c`.`estrusDays` AS `estrusDays`,`c`.`drymilkDays` AS `drymilkDays`,`c`.`pgCount` AS `pgCount`,`c`.`gnrhCount` AS `gnrhCount`,`c`.`productionDate` AS `productionDate`,`c`.`intHyCount` AS `intHyCount`,`c`.`isSexed` AS `isSexed`,`c`.`footdiseaseDays` AS `footdiseaseDays`,`c`.`IsJointInjury` AS `IsJointInjury`,`c`.`IsStepDown` AS `IsStepDown`,`c`.`IsfootdiseaseRepaired` AS `IsfootdiseaseRepaired`,`c`.`IsFootDisease` AS `IsFootDisease`,`c`.`footCount` AS `footCount`,`c`.`footDays` AS `footDays`,`c`.`bubbyDays` AS `bubbyDays`,`c`.`IsBubby` AS `IsBubby`,`c`.`IsbubbyRepaired` AS `IsbubbyRepaired`,`c`.`bubbyCount` AS `bubbyCount`,`c`.`bubbyRepairedDays` AS `bubbyRepairedDays`,`c`.`BlindBubbyCount` AS `BlindBubbyCount`,`c`.`lastTQ` AS `lastTQ`,`c`.`lastTQDays` AS `lastTQDays`,`c`.`hybriDays` AS `hybriDays`,`c`.`isTQ` AS `isTQ`,`c`.`hightActivity` AS `hightActivity`,`c`.`Activity` AS `Activity`,`c`.`lastTQDate` AS `lastTQDate`,`c`.`isEstrus` AS `isEstrus`,`c`.`addSource` AS `addSource`,`b`.`cowType` AS `cowType` from (`heatwatch`.`bar` `b` join `heatwatch`.`cow` `c` on(((`b`.`varBarCode` = `c`.`intCurBar`) and (`b`.`intPastureId` = `c`.`intPastureId`))))
    16.