qc_initv1.5.0.sql 4.0 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768
  1. use `qc`;
  2. DROP TABLE IF EXISTS `med_abnormal_info`;
  3. CREATE TABLE `med_abnormal_info` (
  4. `abnormal_id` bigint(20) NOT NULL AUTO_INCREMENT,
  5. `module_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '模块名称',
  6. `param_in` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '入参',
  7. `param_out` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '出参',
  8. `ramark` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '异常描述',
  9. `is_deleted` char(3) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT 'N' COMMENT '是否删除,N:未删除,Y:删除',
  10. `gmt_create` datetime(0) NULL DEFAULT '1970-01-01 12:00:00' COMMENT '记录创建时间',
  11. `gmt_modified` datetime(0) NULL DEFAULT '1970-01-01 12:00:00' COMMENT '记录修改时间,如果时间是1970年则表示纪录未修改',
  12. `creator` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '0' COMMENT '创建人,0表示无创建人值',
  13. `modifier` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '0' COMMENT '修改人,如果为0则表示纪录未修改',
  14. PRIMARY KEY (`abnormal_id`) USING BTREE
  15. ) ENGINE = InnoDB AUTO_INCREMENT = 106 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
  16. SET FOREIGN_KEY_CHECKS = 1;
  17. alter table med_consultation_note alter column is_deleted set default 'N';
  18. update med_consultation_note set is_deleted = 'N';
  19. alter table med_consultation_apply alter column is_deleted set default 'N';
  20. update med_consultation_apply set is_deleted = 'N';
  21. alter table med_consultation_result alter column is_deleted set default 'N';
  22. update med_consultation_result set is_deleted = 'N';
  23. alter table med_admission_note alter column is_deleted set default 'N';
  24. update med_admission_note set is_deleted = 'N';
  25. alter table med_leave_hospital alter column is_deleted set default 'N';
  26. update med_leave_hospital set is_deleted = 'N';
  27. alter table med_crisis_note alter column is_deleted set default 'N';
  28. update med_crisis_note set is_deleted = 'N';
  29. alter table med_operative_note alter column is_deleted set default 'N';
  30. update med_operative_note set is_deleted = 'N';
  31. alter table med_rescue_note alter column is_deleted set default 'N';
  32. update med_rescue_note set is_deleted = 'N';
  33. alter table med_preoperative_discussion alter column is_deleted set default 'N';
  34. update med_preoperative_discussion set is_deleted = 'N';
  35. alter table med_operative_first_record alter column is_deleted set default 'N';
  36. update med_operative_first_record set is_deleted = 'N';
  37. alter table med_ward_record alter column is_deleted set default 'N';
  38. update med_ward_record set is_deleted = 'N';
  39. alter table med_death_discussion alter column is_deleted set default 'N';
  40. update med_death_discussion set is_deleted = 'N';
  41. alter table med_death_note alter column is_deleted set default 'N';
  42. update med_death_note set is_deleted = 'N';
  43. alter table med_difficult_case alter column is_deleted set default 'N';
  44. update med_difficult_case set is_deleted = 'N';
  45. alter table med_ill_critically alter column is_deleted set default 'N';
  46. update med_ill_critically set is_deleted = 'N';
  47. alter table med_ill_seriousl alter column is_deleted set default 'N';
  48. update med_ill_seriousl set is_deleted = 'N';
  49. alter table med_transfer_in_note alter column is_deleted set default 'N';
  50. update med_transfer_in_note set is_deleted = 'N';
  51. alter table med_transfer_out_note alter column is_deleted set default 'N';
  52. update med_transfer_out_note set is_deleted = 'N';
  53. alter table med_blood_result alter column is_deleted set default 'N';
  54. update med_blood_result set is_deleted = 'N';
  55. alter table med_blood_transfusion alter column is_deleted set default 'N';
  56. update med_blood_transfusion set is_deleted = 'N';
  57. alter table med_period_conclusion alter column is_deleted set default 'N';
  58. update med_period_conclusion set is_deleted = 'N';
  59. alter table med_first_record alter column is_deleted set default 'N';
  60. update med_first_record set is_deleted = 'N';