| 1234567891011121314151617181920212223 |
- "id" "patient_user_id" "bound_user_id" "binding_type" "status" "create_user" "create_time" "update_user" "update_time" "version" "remark"
- "1990104700034510849" "1988147181088956418" "1988172854356631553" "DOCTOR" "1" "1" "17/11/2025 01:08:30" "1" "17/11/2025 01:08:30" "0"
- "1990322533418975234" "1988147181088956418" "1988196438584090626" "FAMILY" "1" "1" "17/11/2025 15:34:05" "1" "17/11/2025 15:34:05" "0"
- CREATE TABLE `t_user_binding` (
- `id` bigint(20) NOT NULL COMMENT '主键ID',
- `patient_user_id` bigint(20) NOT NULL COMMENT '患者用户ID',
- `bound_user_id` bigint(20) NOT NULL COMMENT '被绑定用户ID（医生或家属）',
- `binding_type` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '绑定类型（DOCTOR-医生, FAMILY-家属）',
- `status` tinyint(4) DEFAULT '1' COMMENT '绑定状态（1-有效，0-无效）',
- `create_user` bigint(20) DEFAULT NULL COMMENT '创建者ID',
- `create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
- `update_user` bigint(20) DEFAULT NULL COMMENT '更新者ID',
- `update_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
- `version` int(11) DEFAULT '0' COMMENT '乐观锁版本号',
- `remark` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL 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_bound` FOREIGN KEY (`bound_user_id`) REFERENCES `t_user_info` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
- CONSTRAINT `fk_binding_patient` FOREIGN KEY (`patient_user_id`) REFERENCES `t_user_info` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='用户绑定关系表';
|
