医百顺-推荐相关.pdfVIP

curlhttp://localhost:8081/etl/es7/living-dev.yml-XPOST

表sql

推荐医生相关ES

推荐医生sql

推荐医生mapping

模板

有问诊记录

省内

省外

推荐视频相关ES

推荐视频sql

推荐视频mapping

模板

直播中有问诊记录模板

直播中省内

直播中省外

预播有问诊记录

预播省内

预播省外

回放有问诊记录

回放省内

回放省外

表sql

1updatebiz_doctor_infosetis_del=0whereis_delisnull;

2updatebiz_living_recordsetis_del=0whereis_delisnull;

3updatedoctordepartmentsetisdel=0whereisdelisnull;

4updatehospitalsetisdel=0whereisdelisnull;

5updatelivebroadcastsetisdel=0whereisdelisnull;

6updaterel_doctor_depart_hospitalsetis_del=0whereis_delisnull;

7

8ALTERTABLE`biz_doctor_info`MODIFYCOLUMN`is_del`int(1)NULLDEFAULT0COMMENT删除状

9ALTERTABLE`biz_living_record`MODIFYCOLUMN`is_del`int(1)NULLDEFAULT0COMMENT是否

10ALTERTABLE`doctordepartment`MODIFYCOLUMN`isdel`int(11)NULLDEFAULT0COMMENT是否

11ALTERTABLE`hospital`MODIFYCOLUMN`isdel`int(11)NULLDEFAULT0COMMENT是否删除AF

12ALTERTABLE`livebroadcast`MODIFYCOLUMN`isdel`int(11)NULLDEFAULT0COMMENT是否删除

13ALTERTABLE`rel_doctor_depart_hospital`MODIFYCOLUMN`is_del`int(1)NULLDEFAULT0COM

14ALTERTABLE`usercollect`MODIFYCOLUMN`vaildflag`int(11)NULLDEFAULT0COMMENT是否删

15

推荐医生相关ES

推荐医生sql

1SELECT

2d.user_idas_id,

3d.user_idasdoctorId,

4d.doctor_auth_typeasdoctorAuthType,

5r.hospital_idAShospitalId,

6r.depart_idASdepartId,

7h.longitudeASlongitude,

8h.latitudeASlatitude,

9vincecodeASprovinceId,

10h.citycodeAScityId,

11h.areacodeASareaId,

12h.locationaslocation,

13l.watchNumASwatchNum,

14d.is_delasdis