java-insagent-pc/sql/Online.sql

--  add by hxl   2024-04-27 添加 后线人员关联区域表
DROP TABLE IF EXISTS `sys_user_link_area`;
CREATE TABLE `sys_user_link_area`  (
                                       `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键/自增',
                                       `user_id` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '用户id',
                                       `area_code` int(11) NULL DEFAULT NULL COMMENT '区域编码',
                                       `create_id` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '创建人ID',
                                       `create_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '创建人名称',
                                       `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
                                       `update_id` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '修改人ID',
                                       `update_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '修改人名称',
                                       `update_time` datetime NULL DEFAULT NULL COMMENT '修改时间',
                                       PRIMARY KEY (`id`) USING BTREE,
                                       INDEX `user_id_index`(`user_id`) USING BTREE COMMENT '用户id索引',
                                       INDEX `area_code_index`(`area_code`) USING BTREE COMMENT '部门code索引'
) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '后线人员关联区域表' ROW_FORMAT = Dynamic;