| 1234567891011121314151617181920212223242526272829 |
- "id" "version" "create_user" "create_time" "update_user" "update_time" "remark" "username" "password" "role" "wx_openid" "avatar" "nickname" "sex" "phone" "age" "address"
- "1988147181088956418" "23" "1" "11/11/2025 15:30:01" "1" "17/11/2025 15:13:57" "3" "oMrLJ4upWlkcM8ngNnj849sF_sZg" "1988147181088956418/1763179829156.jpeg" "患者test" "1" "19792741433" "22" "重庆市 重庆市"
- "1988172854356631553" "17" "1" "11/11/2025 17:12:02" "1" "17/11/2025 15:13:51" "2" "oMrLJ4upWlkcM8ngNnj849sF_sZg" "1988172854356631553/1763182966320.jpeg" "医生test" "1" "21"
- "1988196438584090626" "4" "1" "11/11/2025 18:45:45" "1" "17/11/2025 15:14:01" "4" "oMrLJ4upWlkcM8ngNnj849sF_sZg" "1988196438584090626/1763181495049.jpeg" "家属test" "1" "19723123111" "22" "重庆市 重庆市"
- "1988218156098805762" "0" "1" "11/11/2025 20:12:02" "1" "11/11/2025 20:12:02" "3" "oMrLJ4tt491gE-__o36x3SrJ0kVg"
- "1989589966487068673" "0" "1" "15/11/2025 15:03:07" "1" "15/11/2025 15:03:07" "2" "oMrLJ4tt491gE-__o36x3SrJ0kVg"
- CREATE TABLE `t_user_info` (
- `id` bigint(20) NOT NULL COMMENT '主键ID',
- `version` int(11) DEFAULT '0' COMMENT '乐观锁版本',
- `create_user` bigint(20) DEFAULT NULL COMMENT '创建者',
- `create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
- `update_user` bigint(20) DEFAULT NULL COMMENT '更新者',
- `update_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
- `remark` varchar(500) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '备注',
- `username` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '用户名（可选）',
- `password` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '密码（可选）',
- `role` tinyint(3) NOT NULL COMMENT '角色（枚举 PermissionGroup）',
- `wx_openid` varchar(128) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '微信ID（可选）',
- `avatar` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '头像（可选）',
- `nickname` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '昵称（可选）',
- `sex` tinyint(20) DEFAULT NULL COMMENT '性别（可选） 1（男）或 2（女）',
- `phone` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '手机号（可选）',
- `age` int(11) DEFAULT NULL COMMENT '年龄（可选）',
- `address` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '地址（可选）',
- PRIMARY KEY (`id`),
- KEY `idx_username` (`username`),
- KEY `idx_phone` (`phone`),
- KEY `idx_wx_openid` (`wx_openid`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='用户信息表';
|
