| 12345678910111213141516171819202122 |
- "id" "version" "create_user" "create_time" "update_user" "update_time" "remark" "user_id" "token" "expire_time"
- "1988147181156065282" "37" "1" "11/11/2025 15:30:01" "1" "11/11/2025 15:30:01" "1988147181088956418" "7deed423fcc94515b74ab603ab237c00" "20/11/2025 15:33:51"
- "1988172854419546114" "14" "1" "11/11/2025 17:12:02" "1" "11/11/2025 17:12:02" "1988172854356631553" "eb49edc2a2464871a0f51604bc4e10e2" "20/11/2025 17:43:26"
- "1988196438584090627" "9" "1" "11/11/2025 18:45:45" "1" "11/11/2025 18:45:45" "1988196438584090626" "56ba488c953f42549fb1e6cbe1f12450" "20/11/2025 15:32:19"
- "1988218156098805763" "0" "1" "11/11/2025 20:12:02" "1" "11/11/2025 20:12:02" "1988218156098805762" "9cde389298664619aaae9c65cf7ab325" "14/11/2025 20:12:02"
- "1989589966487068674" "0" "1" "15/11/2025 15:03:07" "1" "15/11/2025 15:03:07" "1989589966487068673" "3b34609dac4548b0a1d66f057a6fee2c" "18/11/2025 15:03:07"
- CREATE TABLE `t_user_token` (
- `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 '备注',
- `user_id` bigint(20) NOT NULL COMMENT '用户ID',
- `token` varchar(128) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Token（UUID 或自定义）',
- `expire_time` datetime NOT NULL COMMENT '过期时间',
- PRIMARY KEY (`id`),
- UNIQUE KEY `uk_user_id` (`user_id`),
- KEY `idx_token` (`token`),
- CONSTRAINT `fk_user_token_user` FOREIGN KEY (`user_id`) REFERENCES `t_user_info` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='用户认证表';
|
