med2021_init.sql 3.9 KB

12345678910111213141516
  1. USE `med_2021`;
  2. INSERT INTO `kl_lexicon` (`id`, `is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `name`, `code`, `is_has_common`, `only_one`, `can_change`, `remark`) VALUES ('73', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '给药途径集合', '329', '0', '0', '0', '');
  3. INSERT INTO `kl_dictionary_info` (`id`, `is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `group_type`, `name`, `val`, `return_type`, `order_no`, `remark`) VALUES ('365', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '61', '给药途径集合', '329-600-121', '1', '0', '术语集合相关子类');
  4. INSERT INTO `kl_dictionary_info` (`id`, `is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `group_type`, `name`, `val`, `return_type`, `order_no`, `remark`) VALUES ('366', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '62', '给药途径集合', '329', '1', '22', '术语集合类型');
  5. INSERT INTO `kl_dictionary_info` (`id`, `is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `group_type`, `name`, `val`, `return_type`, `order_no`, `remark`) VALUES ('367', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', '63', '给药途径集合', '329', '1', '21', '术语集合类型(添加)');
  6. INSERT INTO `kl_rule_plan` (`id`, `is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `plan_code`, `rule_type`, `parent_id`, `name`, `type`, `number`, `code`, `order_no`, `remark`) VALUES ('17090', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 'rule', '1', '100', '剂型', NULL, NULL, '102', '17', NULL);
  7. INSERT INTO `kl_rule_plan` (`id`, `is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `plan_code`, `rule_type`, `parent_id`, `name`, `type`, `number`, `code`, `order_no`, `remark`) VALUES ('17091', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 'rule', '1', '100', '剂型集合', NULL, NULL, '310', '18', NULL);
  8. INSERT INTO `kl_rule_plan` (`id`, `is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `plan_code`, `rule_type`, `parent_id`, `name`, `type`, `number`, `code`, `order_no`, `remark`) VALUES ('17092', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 'rule', '1', '100', '给药途径', NULL, NULL, '121', '19', NULL);
  9. INSERT INTO `kl_rule_plan` (`id`, `is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `plan_code`, `rule_type`, `parent_id`, `name`, `type`, `number`, `code`, `order_no`, `remark`) VALUES ('17093', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 'rule', '1', '100', '给药途径集合', NULL, NULL, '329', '20', NULL);
  10. INSERT INTO `kl_rule_plan` (`id`, `is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `plan_code`, `rule_type`, `parent_id`, `name`, `type`, `number`, `code`, `order_no`, `remark`) VALUES ('27090', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 'rule', '1', '200', '剂型', NULL, NULL, '102', '17', NULL);
  11. INSERT INTO `kl_rule_plan` (`id`, `is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `plan_code`, `rule_type`, `parent_id`, `name`, `type`, `number`, `code`, `order_no`, `remark`) VALUES ('27091', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 'rule', '1', '200', '剂型集合', NULL, NULL, '310', '18', NULL);
  12. INSERT INTO `kl_rule_plan` (`id`, `is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `plan_code`, `rule_type`, `parent_id`, `name`, `type`, `number`, `code`, `order_no`, `remark`) VALUES ('27092', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 'rule', '1', '200', '给药途径', NULL, NULL, '121', '19', NULL);
  13. INSERT INTO `kl_rule_plan` (`id`, `is_deleted`, `gmt_create`, `gmt_modified`, `creator`, `modifier`, `plan_code`, `rule_type`, `parent_id`, `name`, `type`, `number`, `code`, `order_no`, `remark`) VALUES ('27093', 'N', '1970-01-01 12:00:00', '1970-01-01 12:00:00', '0', '0', 'rule', '1', '200', '给药途径集合', NULL, NULL, '329', '20', NULL);