大屏机

1. 迁移数据 report相关表 -> result相关表 `http://42.193.138.43:7072/meridian-big-logic/test/refresh/report` 2. tb_count_report_type表里的type_one = 1的type_two改成实际的体质id `http://42.193.138.43:7072/meridian-big-logic/test/refresh/habtius/id` 3. HPushPlan里增加 typeModule,给这个字段赋值,从报告中获取 `http://42.193.138.43:7072/meridian-big-logic/test/refresh/push/plan` ```sql USE meridian_big_logic; ALTER TABLE tb_push_plan ADD COLUMN `type_module` VARCHAR DEFAULT NULL COMMENT '报告类型' AFTER patient_name; ``` 4. tb_illness_risk_report,归并到result,新加一种类型 `http://42.193.138.43:7072/meridian-big-logic/test/refresh/merge/result` 5. tb_customer,report_type 换成 报告中的type_module,添加新字段,result_temp_id中,将risk_level字段写入type_module,不等于12的从result获取result_temp_id 此接口最后执行:`http://42.193.138.43:7072/meridian-big-logic/test/refresh/customer` ```sql USE meridian_big_logic; ALTER TABLE tb_customer ADD COLUMN `result_temp_id` int DEFAULT NULL COMMENT '报告中的分型id' AFTER report_name; ALTER TABLE meridian_big_logic.tb_customer CHANGE report_type type_module INT; ALTER TABLE tb_customer CHANGE report_id result_id BIGINT; ALTER TABLE tb_customer CHANGE report_name result_name VARCHAR(255); ```` /habtius/id /transfer /customer /push/plan