kyj-yanglao-end-new/sql/mysql/elderly_discharge_abstract.sql

-- ============================================================
-- 出院小结（主表：elderly_discharge_abstract / 子表：elderly_discharge_use_medicine）
-- ============================================================

DROP TABLE IF EXISTS `elderly_discharge_abstract`;
CREATE TABLE `elderly_discharge_abstract`  (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `elder_id` bigint(20) NULL DEFAULT NULL COMMENT '长者id',
  `discharge_date` date NULL DEFAULT NULL COMMENT '出院日期',
  `anamnesis` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '既往病史',
  `recent_health_issues` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '近期健康问题',
  `physical_activity_ability` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '身体活动能力',
  `cognition_mental_state` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '认知与精神状态',
  `disease_treatment_control` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '疾病治疗与控制',
  `recent_medical_treatment_situation` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '近期就医情况',
  `reason_discharge` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '出院原因',
  `vital_signs` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '生命体征',
  `physical_functions` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '身体功能',
  `key_issues` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '重点关注问题',
  `safety_protection` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '安全防护',
  `diet_medical_treatment` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '饮食与就医',
  `doctor_sign` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '医生签名',
  `sign_date` date NULL DEFAULT NULL COMMENT '签名日期',
  `tenant_id` bigint(20) NULL DEFAULT NULL COMMENT '机构id',
  `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间',
  `updater` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '更新人',
  `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
  `creator` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '创建人',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '出院小结' ROW_FORMAT = Dynamic;

DROP TABLE IF EXISTS `elderly_discharge_use_medicine`;
CREATE TABLE `elderly_discharge_use_medicine`  (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `elder_id` int(11) NULL DEFAULT NULL COMMENT '长者id',
  `discharge_abstract_id` int(11) NULL DEFAULT NULL COMMENT '出院小结id',
  `medicine_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '药品',
  `dose` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '剂量',
  `usage` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用法',
  `frequency` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '频次',
  `tenant_id` bigint(20) NULL DEFAULT NULL COMMENT '机构id',
  `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间',
  `updater` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '更新人',
  `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
  `creator` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '创建人',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '出院小结用药' ROW_FORMAT = Dynamic;