school_ecology_houtai/target/classes/sql/alumni_manage.sql

/*
 Navicat Premium Data Transfer

 Source Server         : 校友生态
 Source Server Type    : MySQL
 Source Server Version : 80022
 Source Host           : 172.16.40.122:3306
 Source Schema         : alumni_manage

 Target Server Type    : MySQL
 Target Server Version : 80022
 File Encoding         : 65001

 Date: 16/01/2025 10:29:46
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for activity_image
-- ----------------------------
DROP TABLE IF EXISTS `activity_image`;
CREATE TABLE `activity_image`  (
  `id` int(0) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `activity_id` int(0) NULL DEFAULT NULL COMMENT '活动ID',
  `image` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '图片',
  `apply_user` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '审核员ID 多个审核员用逗号隔开  这个审核员是设定的管理员',
  `apply_user_name` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '审核员名称 多个管理员用逗号隔开',
  `is_pass` int(0) NULL DEFAULT NULL COMMENT '是否审核通过    待审核：1   通过：2  拒绝：3',
  `pass_time` datetime(0) NULL DEFAULT NULL COMMENT '审核时间',
  `pass_value` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '审批意见',
  `create_time` datetime(0) NOT NULL COMMENT '创建时间',
  `update_time` datetime(0) NOT NULL COMMENT '更新时间',
  `create_user` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '创建人员',
  `update_user` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '更新人员',
  `deleted` int(0) NOT NULL COMMENT '逻辑删除 未删除：0；删除：1',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 5 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for activity_report
-- ----------------------------
DROP TABLE IF EXISTS `activity_report`;
CREATE TABLE `activity_report`  (
  `id` int(0) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `activity_id` int(0) NOT NULL COMMENT '活动ID',
  `user_id` int(0) NOT NULL COMMENT '用户ID',
  `create_time` datetime(0) NOT NULL COMMENT '创建时间',
  `update_time` datetime(0) NOT NULL COMMENT '更新时间',
  `create_user` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '创建人员',
  `update_user` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '更新人员',
  `deleted` int(0) NOT NULL COMMENT '逻辑删除 未删除：0；删除：1',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 21 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for activity_signin
-- ----------------------------
DROP TABLE IF EXISTS `activity_signin`;
CREATE TABLE `activity_signin`  (
  `id` int(0) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `activity_id` int(0) NOT NULL COMMENT '活动ID',
  `user_id` int(0) NOT NULL COMMENT '用户ID',
  `create_time` datetime(0) NOT NULL COMMENT '创建时间',
  `update_time` datetime(0) NOT NULL COMMENT '更新时间',
  `create_user` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '创建人员',
  `update_user` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '更新人员',
  `deleted` int(0) NOT NULL COMMENT '逻辑删除 未删除：0；删除：1',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for alumni_activity
-- ----------------------------
DROP TABLE IF EXISTS `alumni_activity`;
CREATE TABLE `alumni_activity`  (
  `id` int(0) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `org_id` int(0) NULL DEFAULT NULL COMMENT '组织ID',
  `org_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '组织名称',
  `theme` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '活动主题',
  `theme_detail` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '活动详情',
  `start_time` datetime(0) NULL DEFAULT NULL COMMENT '活动开始时间',
  `end_time` datetime(0) NULL DEFAULT NULL COMMENT '活动结束时间',
  `poster` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '活动海报',
  `address` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '活动地址',
  `lng` double(20, 10) NULL DEFAULT NULL COMMENT '经度',
  `lat` double(20, 10) NULL DEFAULT NULL COMMENT '维度',
  `describes` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '参与说明',
  `signs_time` datetime(0) NULL DEFAULT NULL COMMENT '报名开始时间',
  `signe_time` datetime(0) NULL DEFAULT NULL COMMENT '报名结束时间',
  `total_number` int(0) NULL DEFAULT NULL COMMENT '报名总人数',
  `scope` int(0) NULL DEFAULT NULL COMMENT '报名范围   全部：1    组织成员：2  ',
  `phone` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '咨询方式 如果未填代入活动发起人电话',
  `is_image` int(0) NULL DEFAULT NULL COMMENT '是否可上传照片 是：1 否：2',
  `apply_user` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '审核员ID 多个审核员用逗号隔开  这个审核员是设定的管理员',
  `apply_user_admin` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '审核员名称 多个管理员用逗号隔开',
  `is_pass` int(0) NULL DEFAULT NULL COMMENT '是否审核通过  待审核：1  通过：2  拒绝：3',
  `pass_time` datetime(0) NULL DEFAULT NULL COMMENT '审核时间',
  `pass_value` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '审核意见',
  `create_time` datetime(0) NOT NULL COMMENT '创建时间',
  `update_time` datetime(0) NOT NULL COMMENT '更新时间',
  `create_user` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '创建人员',
  `update_user` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '更新人员',
  `deleted` int(0) NOT NULL COMMENT '逻辑删除 未删除：0；删除：1',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 42 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for alumni_admin_apply
-- ----------------------------
DROP TABLE IF EXISTS `alumni_admin_apply`;
CREATE TABLE `alumni_admin_apply`  (
  `id` int(0) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `admin` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '管理员 多个管理员用逗号隔开',
  `admin_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '管理员名称 多个管理员用逗号隔开',
  `model_id` int(0) NULL DEFAULT NULL COMMENT '模块ID   校友相册：1 活动管理：2   母校代言：3',
  `create_time` datetime(0) NOT NULL COMMENT '创建时间',
  `update_time` datetime(0) NOT NULL COMMENT '更新时间',
  `create_user` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '创建人员',
  `update_user` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '更新人员',
  `deleted` int(0) NOT NULL COMMENT '逻辑删除 未删除：0；删除：1',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for alumni_category
-- ----------------------------
DROP TABLE IF EXISTS `alumni_category`;
CREATE TABLE `alumni_category`  (
  `id` int(0) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '分类名称',
  `create_time` datetime(0) NOT NULL COMMENT '创建时间',
  `update_time` datetime(0) NOT NULL COMMENT '更新时间',
  `create_user` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '创建人员',
  `update_user` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '更新人员',
  `deleted` int(0) NOT NULL COMMENT '逻辑删除 未删除：0；删除：1',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 18 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for alumni_category_image
-- ----------------------------
DROP TABLE IF EXISTS `alumni_category_image`;
CREATE TABLE `alumni_category_image`  (
  `id` int(0) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '分类名称',
  `create_time` datetime(0) NOT NULL COMMENT '创建时间',
  `update_time` datetime(0) NOT NULL COMMENT '更新时间',
  `create_user` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '创建人员',
  `update_user` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '更新人员',
  `deleted` int(0) NOT NULL COMMENT '逻辑删除 未删除：0；删除：1',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 5 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for alumni_category_news
-- ----------------------------
DROP TABLE IF EXISTS `alumni_category_news`;
CREATE TABLE `alumni_category_news`  (
  `id` int(0) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '分类名称',
  `create_time` datetime(0) NOT NULL COMMENT '创建时间',
  `update_time` datetime(0) NOT NULL COMMENT '更新时间',
  `create_user` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '创建人员',
  `update_user` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '更新人员',
  `deleted` int(0) NOT NULL COMMENT '逻辑删除 未删除：0；删除：1',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for alumni_club
-- ----------------------------
DROP TABLE IF EXISTS `alumni_club`;
CREATE TABLE `alumni_club`  (
  `id` int(0) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '组织名称',
  `category_id` int(0) NULL DEFAULT NULL COMMENT '分类ID',
  `category_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '分类名称',
  `admin` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '管理员ID 多个管理员用逗号隔开',
  `admin_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '管理员名称 多个管理员用逗号隔开',
  `is_top` int(0) NULL DEFAULT NULL COMMENT '是否置顶  是：1  否：2',
  `description` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '本会简介',
  `contact` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '联系我们',
  `contacts` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '联系人',
  `phone` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '电话',
  `email` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '邮箱',
  `address` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '地址',
  `number` int(0) NULL DEFAULT NULL COMMENT '人数',
  `create_time` datetime(0) NOT NULL COMMENT '创建时间',
  `update_time` datetime(0) NOT NULL COMMENT '更新时间',
  `create_user` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '创建人员',
  `update_user` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '更新人员',
  `deleted` int(0) NOT NULL COMMENT '逻辑删除 未删除：0；删除：1',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 38 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for alumni_club_apply
-- ----------------------------
DROP TABLE IF EXISTS `alumni_club_apply`;
CREATE TABLE `alumni_club_apply`  (
  `id` int(0) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '组织名称',
  `club_id` int(0) NULL DEFAULT NULL COMMENT '组织ID',
  `apply_user` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '审核员ID 多个审核员用逗号隔开  这个审核员是设定的管理员',
  `apply_user_name` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '审核员名称 多个管理员用逗号隔开',
  `is_pass` int(0) NULL DEFAULT NULL COMMENT '是否审核通过    待审核：1   通过：2  拒绝：3',
  `pass_value` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '审批意见',
  `create_time` datetime(0) NOT NULL COMMENT '创建时间',
  `update_time` datetime(0) NOT NULL COMMENT '更新时间',
  `create_user` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '创建人员',
  `update_user` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '更新人员',
  `deleted` int(0) NOT NULL COMMENT '逻辑删除 未删除：0；删除：1',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 10 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for alumni_endorse
-- ----------------------------
DROP TABLE IF EXISTS `alumni_endorse`;
CREATE TABLE `alumni_endorse`  (
  `id` int(0) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `data_no` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '编号',
  `card_number` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '微校卡号',
  `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '姓名',
  `user_id` int(0) NULL DEFAULT NULL COMMENT '用户ID',
  `image` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '照片',
  `descript` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '个人简介',
  `is_pass` int(0) NULL DEFAULT NULL COMMENT '是否审核通过 待审核：1  通过：2 拒绝：3',
  `pass_time` datetime(0) NULL DEFAULT NULL COMMENT '审核时间',
  `pass_value` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '审批意见',
  `apply_user` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '审核人',
  `apply_user_name` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '审核人名称',
  `preferred_method` int(0) NULL DEFAULT NULL COMMENT '推荐方式  自荐：1  分院推荐：2',
  `create_time` datetime(0) NOT NULL COMMENT '创建时间',
  `update_time` datetime(0) NOT NULL COMMENT '更新时间',
  `create_user` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '创建人员',
  `update_user` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '更新人员',
  `deleted` int(0) NOT NULL COMMENT '逻辑删除 未删除：0；删除：1',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 32 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for alumni_heart
-- ----------------------------
DROP TABLE IF EXISTS `alumni_heart`;
CREATE TABLE `alumni_heart`  (
  `id` int(0) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `equity_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '权益名称',
  `cover_image` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '封面图',
  `content` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '权益内容',
  `is_top` int(0) NULL DEFAULT NULL COMMENT '是否置顶  是：1  否：2',
  `create_time` datetime(0) NOT NULL COMMENT '创建时间',
  `update_time` datetime(0) NOT NULL COMMENT '更新时间',
  `create_user` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '创建人员',
  `update_user` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '更新人员',
  `deleted` int(0) NOT NULL COMMENT '逻辑删除 未删除：0；删除：1',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 13 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for alumni_image
-- ----------------------------
DROP TABLE IF EXISTS `alumni_image`;
CREATE TABLE `alumni_image`  (
  `id` int(0) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `image` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '图片 多个图片用逗号隔开',
  `category_id` int(0) NULL DEFAULT NULL COMMENT '图片分类ID',
  `category_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '分类名称',
  `is_pass` int(0) NULL DEFAULT NULL COMMENT '是否审核通过    待审核：1   通过：2  拒绝：3',
  `apply_user` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '审核员ID 多个审核员用逗号隔开  这个审核员是设定的管理员',
  `apply_user_name` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '审核员名称 多个管理员用逗号隔开',
  `pass_time` datetime(0) NULL DEFAULT NULL COMMENT '审核时间',
  `pass_value` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '审批意见',
  `create_time` datetime(0) NOT NULL COMMENT '创建时间',
  `update_time` datetime(0) NOT NULL COMMENT '更新时间',
  `create_user` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '创建人员',
  `update_user` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '更新人员',
  `deleted` int(0) NOT NULL COMMENT '逻辑删除 未删除：0；删除：1',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 18 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for alumni_news
-- ----------------------------
DROP TABLE IF EXISTS `alumni_news`;
CREATE TABLE `alumni_news`  (
  `id` int(0) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `theme` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '标题',
  `content` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '内容',
  `category_id` int(0) NULL DEFAULT NULL COMMENT '分类ID',
  `category_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '分类名称',
  `user_id` int(0) NULL DEFAULT NULL COMMENT '发件人ID',
  `user_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '发件人名称',
  `create_time` datetime(0) NOT NULL COMMENT '创建时间',
  `update_time` datetime(0) NOT NULL COMMENT '更新时间',
  `create_user` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '创建人员',
  `update_user` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '更新人员',
  `deleted` int(0) NOT NULL COMMENT '逻辑删除 未删除：0；删除：1',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 11 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for alumni_org
-- ----------------------------
DROP TABLE IF EXISTS `alumni_org`;
CREATE TABLE `alumni_org`  (
  `id` int(0) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `parent_id` int(0) NULL DEFAULT NULL COMMENT '父级ID',
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '名称',
  `type_id` int(0) NULL DEFAULT NULL COMMENT '类型  学院:1 学段:2 专业:3\r\n班级:4 ',
  `create_time` datetime(0) NOT NULL COMMENT '创建时间',
  `update_time` datetime(0) NOT NULL COMMENT '更新时间',
  `create_user` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '创建人员',
  `update_user` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '更新人员',
  `deleted` int(0) NOT NULL COMMENT '逻辑删除 未删除：0；删除：1',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 58 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for alumni_org_备份
-- ----------------------------
DROP TABLE IF EXISTS `alumni_org_备份`;
CREATE TABLE `alumni_org_备份`  (
  `id` int(0) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `parent_id` int(0) NULL DEFAULT NULL COMMENT '父级ID',
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '名称',
  `type_id` int(0) NULL DEFAULT NULL COMMENT '类型  学院:1 学段:2 专业:3\r\n班级:4 ',
  `create_time` datetime(0) NOT NULL COMMENT '创建时间',
  `update_time` datetime(0) NOT NULL COMMENT '更新时间',
  `create_user` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '创建人员',
  `update_user` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '更新人员',
  `deleted` int(0) NOT NULL COMMENT '逻辑删除 未删除：0；删除：1',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 803507 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for alumni_return
-- ----------------------------
DROP TABLE IF EXISTS `alumni_return`;
CREATE TABLE `alumni_return`  (
  `id` int(0) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `school_id` int(0) NULL DEFAULT NULL COMMENT '校区ID  黄家湖校区：1  墨轩湖校区：2',
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '校友姓名',
  `card_number` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '微校卡号',
  `user_id` int(0) NULL DEFAULT NULL COMMENT '返校人ID',
  `phone` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '手机号',
  `returns_time` datetime(0) NULL DEFAULT NULL COMMENT '返校开始时间',
  `returne_time` datetime(0) NULL DEFAULT NULL COMMENT '返校结束时间',
  `is_pass` int(0) NULL DEFAULT NULL COMMENT '是否审核通过    待审核：1   通过：2  拒绝：3',
  `remark` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '返校事由',
  `create_time` datetime(0) NOT NULL COMMENT '创建时间',
  `update_time` datetime(0) NOT NULL COMMENT '更新时间',
  `create_user` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '创建人员',
  `update_user` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '更新人员',
  `deleted` int(0) NOT NULL COMMENT '逻辑删除 未删除：0；删除：1',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 6 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for alumni_user
-- ----------------------------
DROP TABLE IF EXISTS `alumni_user`;
CREATE TABLE `alumni_user`  (
  `id` int(0) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '姓名',
  `card_number` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '微校卡号',
  `college_id` int(0) NULL DEFAULT NULL COMMENT '学院ID',
  `college_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '学院',
  `period_id` int(0) NULL DEFAULT NULL COMMENT '学段ID  年级',
  `period_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '学段  年级',
  `major_id` int(0) NULL DEFAULT NULL COMMENT '专业ID',
  `major_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '专业',
  `class_id` int(0) NULL DEFAULT NULL COMMENT '班级ID',
  `class_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '班级',
  `org_id` int(0) NULL DEFAULT NULL COMMENT '所属组织ID',
  `org_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '所属组织',
  `phone` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '联系方式',
  `account` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '账号',
  `password` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '密码',
  `role_id` int(0) NULL DEFAULT NULL COMMENT '角色ID    超级管理员：1   普通管理员：2',
  `type_id` int(0) NULL DEFAULT NULL COMMENT '类型   账号：1   用户：2',
  `create_account_time` datetime(0) NULL DEFAULT NULL COMMENT '创建账号时间',
  `create_time` datetime(0) NOT NULL COMMENT '创建时间',
  `update_time` datetime(0) NOT NULL COMMENT '更新时间',
  `create_user` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '创建人员',
  `update_user` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '更新人员',
  `deleted` int(0) NOT NULL COMMENT '逻辑删除 未删除：0；删除：1',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 23 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for wx_access_token
-- ----------------------------
DROP TABLE IF EXISTS `wx_access_token`;
CREATE TABLE `wx_access_token`  (
  `id` int(0) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `access_token` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT 'access_token',
  `expires_time` datetime(0) NOT NULL COMMENT '过期时间',
  `create_time` datetime(0) NOT NULL COMMENT '创建时间',
  `update_time` datetime(0) NOT NULL COMMENT '更新时间',
  `create_user` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '创建人员',
  `update_user` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '更新人员',
  `deleted` int(0) NOT NULL COMMENT '逻辑删除 未删除：0；删除：1',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 26 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

SET FOREIGN_KEY_CHECKS = 1;