/*
|
Navicat Premium Data Transfer
|
|
Source Server : 118.145.136.116
|
Source Server Type : MySQL
|
Source Server Version : 80041
|
Source Host : 118.145.136.116:3306
|
Source Schema : oying
|
|
Target Server Type : MySQL
|
Target Server Version : 80041
|
File Encoding : 65001
|
|
Date: 22/10/2025 16:46:07
|
*/
|
|
SET NAMES utf8mb4;
|
SET FOREIGN_KEY_CHECKS = 0;
|
|
-- ----------------------------
|
-- Table structure for sys_invitations
|
-- ----------------------------
|
DROP TABLE IF EXISTS `sys_invitations`;
|
CREATE TABLE `sys_invitations` (
|
`invitations_id` bigint(0) NOT NULL AUTO_INCREMENT COMMENT 'ID',
|
`inviter_id` bigint(0) NULL DEFAULT NULL COMMENT '邀请人ID',
|
`inviter_phone` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '邀请人电话',
|
`inviter_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '邀请人姓名',
|
`inviter_open_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '邀请人openid',
|
`new_user_open_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '新用户openid',
|
`new_user_id` bigint(0) NULL DEFAULT 0 COMMENT '新用户ID',
|
`new_user_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '新用户姓名',
|
`new_user_phone` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '新用户电话',
|
`type` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '记录类型',
|
`user_type` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '用户类型',
|
`status` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '1success 0pending 2failed',
|
`reward_value` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '奖励数值',
|
`reward_type` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '奖励类型',
|
`create_by` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '创建者',
|
`update_by` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '更新者',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建日期',
|
`update_time` datetime(0) NULL DEFAULT NULL COMMENT '更新时间',
|
PRIMARY KEY (`invitations_id`) USING BTREE
|
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '邀请新用户记录' ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of sys_invitations
|
-- ----------------------------
|
|
SET FOREIGN_KEY_CHECKS = 1;
|
