-- Database schema for ryc
|
-- Generated at: 2025/9/27 19:34:25
|
|
-- Table: t_activity
|
CREATE TABLE `t_activity` (
|
`id` bigint NOT NULL AUTO_INCREMENT,
|
`pid` bigint NOT NULL DEFAULT '0',
|
`path` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
|
`name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
|
`description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci,
|
`signup_deadline` datetime NOT NULL,
|
`match_time` datetime DEFAULT NULL,
|
`address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
|
`rating_scheme_id` bigint NOT NULL,
|
`player_max` int DEFAULT NULL COMMENT '人数上限',
|
`state` int NOT NULL DEFAULT '1' COMMENT '0:未发布， 1：发布：2：关闭',
|
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
`create_user_id` bigint DEFAULT NULL,
|
`update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
|
`update_user_id` bigint DEFAULT NULL,
|
`version` bigint NOT NULL DEFAULT '0',
|
PRIMARY KEY (`id`) USING BTREE,
|
KEY `fk_t_activity_rating_scheme` (`rating_scheme_id`) USING BTREE,
|
KEY `idx_t_activity_deadline` (`signup_deadline`) USING BTREE,
|
CONSTRAINT `fk_t_activity_rating_scheme` FOREIGN KEY (`rating_scheme_id`) REFERENCES `t_rating_scheme` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
|
) ENGINE=InnoDB AUTO_INCREMENT=62 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
|
|
-- Table: t_activity_judge
|
CREATE TABLE `t_activity_judge` (
|
`id` bigint NOT NULL AUTO_INCREMENT,
|
`activity_id` bigint NOT NULL,
|
`stage_id` bigint NOT NULL,
|
`judge_id` bigint NOT NULL,
|
`description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
|
`state` int DEFAULT NULL,
|
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
`create_user_id` bigint DEFAULT NULL,
|
`update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
|
`update_user_id` bigint DEFAULT NULL,
|
`version` bigint NOT NULL DEFAULT '0',
|
PRIMARY KEY (`id`) USING BTREE,
|
UNIQUE KEY `uq_stage_judge` (`stage_id`,`judge_id`) USING BTREE
|
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
|
|
-- Table: t_activity_player
|
CREATE TABLE `t_activity_player` (
|
`id` bigint NOT NULL AUTO_INCREMENT,
|
`activity_id` bigint NOT NULL,
|
`stage_id` bigint NOT NULL COMMENT '比赛阶段，逻辑和t_activity_judge 保持一致。',
|
`player_id` bigint NOT NULL,
|
`region_id` bigint DEFAULT NULL COMMENT '区域id',
|
`project_name` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '参赛项目标题',
|
`description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
|
`reject_reason` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
|
`judge_id` bigint DEFAULT NULL COMMENT '评委',
|
`feedback` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci,
|
`total_score` decimal(19,4) DEFAULT NULL COMMENT '低分',
|
`rank` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '名次',
|
`state` int NOT NULL DEFAULT '0' COMMENT '0等待审核，1：审核通过，2：不通过',
|
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
`create_user_id` bigint DEFAULT NULL,
|
`update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
|
`update_user_id` bigint DEFAULT NULL,
|
`version` bigint NOT NULL DEFAULT '0',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
|
|
-- Table: t_activity_player_rating
|
CREATE TABLE `t_activity_player_rating` (
|
`id` bigint NOT NULL AUTO_INCREMENT,
|
`activity_id` bigint NOT NULL,
|
`activity_player_id` bigint DEFAULT NULL,
|
`rating_scheme_id` bigint DEFAULT NULL COMMENT '评分方案ID',
|
`stage_id` bigint NOT NULL,
|
`player_id` bigint NOT NULL COMMENT '冗余字段',
|
`judge_id` bigint DEFAULT NULL,
|
`total_score` decimal(19,2) DEFAULT NULL,
|
`feedback` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci COMMENT '评价内容',
|
`state` int NOT NULL,
|
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
`create_user_id` bigint DEFAULT NULL,
|
`update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
|
`update_user_id` bigint DEFAULT NULL,
|
`version` bigint NOT NULL DEFAULT '0',
|
PRIMARY KEY (`id`)
|
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
|
|
-- Table: t_activity_player_rating_item
|
CREATE TABLE `t_activity_player_rating_item` (
|
`id` bigint NOT NULL AUTO_INCREMENT,
|
`activity_id` bigint NOT NULL,
|
`activity_player_id` bigint NOT NULL,
|
`activity_player_rating_id` bigint NOT NULL,
|
`stage_id` bigint NOT NULL,
|
`player_id` bigint NOT NULL,
|
`judge_id` bigint NOT NULL,
|
`rating_scheme_id` bigint NOT NULL,
|
`rating_item_id` bigint NOT NULL,
|
`score` decimal(10,2) NOT NULL,
|
`feedback` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci,
|
`state` int NOT NULL DEFAULT '1',
|
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
`create_user_id` bigint DEFAULT NULL,
|
`update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
|
`update_user_id` bigint DEFAULT NULL,
|
`version` bigint NOT NULL DEFAULT '0',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
|
|
-- Table: t_carousel
|
CREATE TABLE `t_carousel` (
|
`id` bigint NOT NULL AUTO_INCREMENT,
|
`title` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
|
`description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
|
`sort_order` int DEFAULT NULL,
|
`state` int NOT NULL DEFAULT '1' COMMENT '0:关闭，1：使用',
|
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
`create_user_id` bigint DEFAULT NULL,
|
`update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
|
`update_user_id` bigint DEFAULT NULL,
|
`version` bigint NOT NULL DEFAULT '0',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='轮播图';
|
|
-- Table: t_employee
|
CREATE TABLE `t_employee` (
|
`id` bigint NOT NULL AUTO_INCREMENT,
|
`name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
|
`phone` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
|
`role_id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
|
`user_id` bigint NOT NULL,
|
`state` int NOT NULL,
|
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
`create_user_id` bigint DEFAULT NULL,
|
`update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
|
`update_user_id` bigint DEFAULT NULL,
|
`version` bigint NOT NULL DEFAULT '0',
|
`description` varchar(255) DEFAULT NULL,
|
PRIMARY KEY (`id`) USING BTREE,
|
UNIQUE KEY `phone` (`phone`) USING BTREE
|
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
|
|
-- Table: t_employee_role
|
CREATE TABLE `t_employee_role` (
|
`id` bigint NOT NULL AUTO_INCREMENT,
|
`employee_id` bigint NOT NULL,
|
`role_id` bigint NOT NULL,
|
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
`create_user_id` bigint DEFAULT NULL,
|
`update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
|
`update_user_id` bigint DEFAULT NULL,
|
`version` bigint NOT NULL DEFAULT '0',
|
PRIMARY KEY (`id`) USING BTREE,
|
KEY `fk_t_user_role_role` (`role_id`) USING BTREE
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
|
|
-- Table: t_judge
|
CREATE TABLE `t_judge` (
|
`id` bigint NOT NULL AUTO_INCREMENT,
|
`name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
|
`user_id` bigint DEFAULT NULL,
|
`phone` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
|
`gender` int DEFAULT NULL,
|
`state` int NOT NULL DEFAULT '1',
|
`role_id` bigint DEFAULT NULL,
|
`description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
|
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
`create_user_id` bigint DEFAULT NULL,
|
`update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
|
`update_user_id` bigint DEFAULT NULL,
|
`version` bigint NOT NULL DEFAULT '0',
|
`title` varchar(128) DEFAULT NULL COMMENT '职位/头衔',
|
`company` varchar(128) DEFAULT NULL COMMENT '公司/机构',
|
`introduction` text COMMENT '个人介绍',
|
PRIMARY KEY (`id`) USING BTREE,
|
UNIQUE KEY `phone` (`phone`) USING BTREE
|
) ENGINE=InnoDB AUTO_INCREMENT=53 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
|
|
-- Table: t_judge_tag
|
CREATE TABLE `t_judge_tag` (
|
`id` bigint NOT NULL AUTO_INCREMENT,
|
`judge_id` bigint NOT NULL,
|
`tag_id` bigint NOT NULL,
|
`state` int NOT NULL DEFAULT '1',
|
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
`create_user_id` bigint DEFAULT NULL,
|
`update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
|
`update_user_id` bigint DEFAULT NULL,
|
`version` bigint NOT NULL DEFAULT '0',
|
PRIMARY KEY (`id`) USING BTREE,
|
KEY `fk_t_judge_major_tag` (`tag_id`) USING BTREE
|
) ENGINE=InnoDB AUTO_INCREMENT=76 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
|
|
-- Table: t_media
|
CREATE TABLE `t_media` (
|
`id` int NOT NULL AUTO_INCREMENT,
|
`name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
|
`target_type` int NOT NULL,
|
`target_id` bigint NOT NULL,
|
`media_type` int NOT NULL,
|
`path` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '腾讯云的存储桶地址',
|
`thumb_path` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
|
`file_ext` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
|
`file_size` int NOT NULL,
|
`duration` int DEFAULT NULL COMMENT '视频的长度秒',
|
`description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
|
`state` int NOT NULL DEFAULT '1',
|
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
`create_user_id` bigint DEFAULT NULL,
|
`update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
|
`update_user_id` bigint DEFAULT NULL,
|
`version` bigint NOT NULL DEFAULT '0',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE=InnoDB AUTO_INCREMENT=37 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
|
|
-- Table: t_notification_task
|
CREATE TABLE `t_notification_task` (
|
`id` bigint NOT NULL AUTO_INCREMENT,
|
`type` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
|
`channel` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
|
`target_type` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '1:学员，2：评委，3：工作人员',
|
`target_id` bigint NOT NULL,
|
`payload` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci COMMENT '消息内容',
|
`error_message` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
|
`retry_count` int NOT NULL,
|
`next_retry_at` datetime DEFAULT NULL,
|
`state` tinyint(1) NOT NULL DEFAULT '1',
|
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
`create_user_id` bigint DEFAULT NULL,
|
`update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
|
`update_user_id` bigint DEFAULT NULL,
|
`version` bigint NOT NULL DEFAULT '0',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
|
|
-- Table: t_permission
|
CREATE TABLE `t_permission` (
|
`id` bigint NOT NULL AUTO_INCREMENT,
|
`code` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
|
`name` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
|
`category` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
|
`description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
|
`state` tinyint(1) NOT NULL DEFAULT '1',
|
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
`create_user_id` bigint DEFAULT NULL,
|
`update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
|
`update_user_id` bigint DEFAULT NULL,
|
`version` bigint NOT NULL DEFAULT '0',
|
PRIMARY KEY (`id`) USING BTREE,
|
UNIQUE KEY `code` (`code`) USING BTREE,
|
KEY `idx_t_permission_code` (`code`) USING BTREE
|
) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
|
|
-- Table: t_player
|
CREATE TABLE `t_player` (
|
`id` bigint NOT NULL AUTO_INCREMENT,
|
`name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
|
`phone` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
|
`role_id` bigint NOT NULL,
|
`description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
|
`gender` int DEFAULT NULL COMMENT '0:女，1：男',
|
`education` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
|
`introduction` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci,
|
`reject_reason` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
|
`final_score` decimal(10,2) DEFAULT NULL,
|
`state` int NOT NULL,
|
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
`create_user_id` bigint DEFAULT NULL,
|
`update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
|
`update_user_id` bigint DEFAULT NULL,
|
`version` bigint NOT NULL DEFAULT '0',
|
`user_id` bigint NOT NULL,
|
PRIMARY KEY (`id`) USING BTREE,
|
UNIQUE KEY `phone` (`phone`) USING BTREE
|
) ENGINE=InnoDB AUTO_INCREMENT=35 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
|
|
-- Table: t_rating_item
|
CREATE TABLE `t_rating_item` (
|
`id` bigint NOT NULL AUTO_INCREMENT,
|
`scheme_id` bigint NOT NULL,
|
`name` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
|
`max_score` int NOT NULL,
|
`order_no` int NOT NULL,
|
`state` int NOT NULL,
|
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
`create_user_id` bigint DEFAULT NULL,
|
`update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
|
`update_user_id` bigint DEFAULT NULL,
|
`version` bigint NOT NULL DEFAULT '0',
|
PRIMARY KEY (`id`) USING BTREE,
|
KEY `idx_t_rating_item_scheme` (`scheme_id`) USING BTREE,
|
CONSTRAINT `fk_t_rating_item_scheme` FOREIGN KEY (`scheme_id`) REFERENCES `t_rating_scheme` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
|
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
|
|
-- Table: t_rating_scheme
|
CREATE TABLE `t_rating_scheme` (
|
`id` bigint NOT NULL AUTO_INCREMENT,
|
`name` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
|
`description` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
|
`state` int NOT NULL,
|
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
`create_user_id` bigint DEFAULT NULL,
|
`update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
|
`update_user_id` bigint DEFAULT NULL,
|
`version` bigint NOT NULL DEFAULT '0',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
|
|
-- Table: t_region
|
CREATE TABLE `t_region` (
|
`id` bigint NOT NULL AUTO_INCREMENT,
|
`pid` bigint NOT NULL COMMENT '自关联',
|
`name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
|
`code` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
|
`level` int NOT NULL,
|
`leaf_flag` tinyint(1) NOT NULL DEFAULT '0',
|
`full_path` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
|
`state` int NOT NULL,
|
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
`create_user_id` bigint DEFAULT NULL,
|
`update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
|
`update_user_id` bigint DEFAULT NULL,
|
`version` bigint NOT NULL DEFAULT '0',
|
PRIMARY KEY (`id`) USING BTREE,
|
UNIQUE KEY `code` (`code`) USING BTREE
|
) ENGINE=InnoDB AUTO_INCREMENT=30 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
|
|
-- Table: t_role
|
CREATE TABLE `t_role` (
|
`id` bigint NOT NULL AUTO_INCREMENT,
|
`code` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
|
`name` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
|
`description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
|
`state` int NOT NULL,
|
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
`create_user_id` bigint DEFAULT NULL,
|
`update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
|
`update_user_id` bigint DEFAULT NULL,
|
`version` bigint NOT NULL DEFAULT '0',
|
PRIMARY KEY (`id`) USING BTREE,
|
UNIQUE KEY `code` (`code`) USING BTREE,
|
KEY `idx_t_role_code` (`code`) USING BTREE
|
) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
|
|
-- Table: t_role_permission
|
CREATE TABLE `t_role_permission` (
|
`id` int NOT NULL AUTO_INCREMENT,
|
`role_id` bigint NOT NULL,
|
`permission_id` bigint NOT NULL,
|
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
`create_user_id` bigint DEFAULT NULL,
|
`update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
|
`update_user_id` bigint DEFAULT NULL,
|
`version` bigint NOT NULL DEFAULT '0',
|
PRIMARY KEY (`id`) USING BTREE,
|
KEY `fk_t_role_permission_perm` (`permission_id`) USING BTREE
|
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
|
|
-- Table: t_tag
|
CREATE TABLE `t_tag` (
|
`id` bigint NOT NULL AUTO_INCREMENT,
|
`name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
|
`code` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
|
`category` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
|
`description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
|
`state` int NOT NULL,
|
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
`create_user_id` bigint DEFAULT NULL,
|
`update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
|
`update_user_id` bigint DEFAULT NULL,
|
`version` bigint NOT NULL DEFAULT '0',
|
PRIMARY KEY (`id`) USING BTREE,
|
UNIQUE KEY `code` (`code`) USING BTREE,
|
KEY `idx_t_tag_category` (`category`) USING BTREE
|
) ENGINE=InnoDB AUTO_INCREMENT=32 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
|
|
-- Table: t_user
|
CREATE TABLE `t_user` (
|
`id` bigint NOT NULL AUTO_INCREMENT,
|
`name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
|
`gender` int DEFAULT NULL,
|
`phone` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
|
`birthday` date DEFAULT NULL,
|
`wx_openid` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
|
`wx_unionid` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
|
`wx_oa_openid` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
|
`password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
|
`state` int NOT NULL,
|
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
`create_user_id` bigint DEFAULT NULL,
|
`update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
|
`update_user_id` bigint DEFAULT NULL,
|
`version` bigint NOT NULL DEFAULT '0',
|
`mobile` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
|
PRIMARY KEY (`id`) USING BTREE,
|
UNIQUE KEY `uq_wx_open_id` (`wx_openid`) USING BTREE,
|
UNIQUE KEY `uq_phone` (`phone`)
|
) ENGINE=InnoDB AUTO_INCREMENT=62 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
|
|
-- Table: t_wx_login_record
|
CREATE TABLE `t_wx_login_record` (
|
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键ID',
|
`wx_openid` varchar(64) COLLATE utf8mb4_general_ci NOT NULL COMMENT '微信openid',
|
`wx_unionid` varchar(64) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '微信unionid',
|
`user_id` bigint DEFAULT NULL COMMENT '关联的用户ID',
|
`login_time` datetime NOT NULL COMMENT '登录时间',
|
`login_ip` varchar(64) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '登录IP地址',
|
`device_info` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '设备信息',
|
`session_key` varchar(128) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '微信session_key',
|
`phone_authorized` tinyint(1) DEFAULT '0' COMMENT '是否已授权手机号：0-未授权，1-已授权',
|
`phone_auth_time` datetime DEFAULT NULL COMMENT '手机号授权时间',
|
`create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
|
`update_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
|
`state` tinyint(1) DEFAULT '1' COMMENT '状态：0-禁用，1-启用',
|
PRIMARY KEY (`id`),
|
KEY `idx_wx_openid` (`wx_openid`),
|
KEY `idx_wx_unionid` (`wx_unionid`),
|
KEY `idx_user_id` (`user_id`),
|
KEY `idx_login_time` (`login_time`),
|
KEY `idx_phone_authorized` (`phone_authorized`)
|
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='微信登录记录表';
|
