ChronicDisease_SpringBoot/docs/DataBase/t_user_binding.txt

CREATE TABLE `t_user_binding` (
  `id` BIGINT NOT NULL COMMENT '主键ID',
  `patient_user_id` BIGINT NOT NULL COMMENT '患者用户ID',
  `bound_user_id` BIGINT NOT NULL COMMENT '被绑定用户ID（医生或家属）',
  `binding_type` VARCHAR(20) NOT NULL COMMENT '绑定类型（DOCTOR-医生, FAMILY-家属）',
  `status` TINYINT DEFAULT 1 COMMENT '绑定状态（1-有效，0-无效）',
  `create_user` BIGINT COMMENT '创建者ID',
  `create_time` DATETIME DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_user` BIGINT COMMENT '更新者ID',
  `update_time` DATETIME DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  `version` INT DEFAULT 0 COMMENT '乐观锁版本号',
  `remark` VARCHAR(255) COMMENT '备注',
  PRIMARY KEY (`id`),
  KEY `idx_patient_bound` (`patient_user_id`, `bound_user_id`),
  KEY `idx_patient_user` (`patient_user_id`),
  KEY `idx_bound_user` (`bound_user_id`),
  KEY `idx_binding_type` (`binding_type`),
  CONSTRAINT `fk_binding_patient` FOREIGN KEY (`patient_user_id`) REFERENCES `t_user_info` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `fk_binding_bound` FOREIGN KEY (`bound_user_id`) REFERENCES `t_user_info` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='用户绑定关系表';