/*
|
Navicat Premium Data Transfer
|
|
Source Server : 虚拟机80-mysql8.0
|
Source Server Type : MySQL
|
Source Server Version : 80036
|
Source Host : 192.168.110.169:3306
|
Source Schema : charging_pile_account
|
|
Target Server Type : MySQL
|
Target Server Version : 80036
|
File Encoding : 65001
|
|
Date: 05/08/2024 18:42:48
|
*/
|
|
SET NAMES utf8mb4;
|
SET FOREIGN_KEY_CHECKS = 0;
|
|
-- ----------------------------
|
-- Table structure for t_app_coupon
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_app_coupon`;
|
CREATE TABLE `t_app_coupon` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`coupon_id` int NULL DEFAULT NULL COMMENT '优惠券id',
|
`end_time` datetime(0) NULL DEFAULT NULL COMMENT '结束时间',
|
`ways_to_obtain` int NULL DEFAULT NULL COMMENT '获得方式（1=积分兑换，2=现金购买）',
|
`redeem_points` int NULL DEFAULT NULL COMMENT '兑换积分',
|
`payment_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '支付金额',
|
`payment_type` int NULL DEFAULT NULL COMMENT '支付方式（1=微信，2=支付宝）',
|
`serial_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '第三方支付流水号',
|
`payment_time` datetime(0) NULL DEFAULT NULL COMMENT '支付完成时间',
|
`status` int NULL DEFAULT NULL COMMENT '状态（1=未使用，2=已使用）',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
|
`del_flag` int NULL DEFAULT NULL COMMENT '删除（0=否，1=是）',
|
PRIMARY KEY (`id`) USING BTREE,
|
INDEX `app_user_id`(`app_user_id`) USING BTREE COMMENT '用户id',
|
INDEX `coupon_id`(`coupon_id`) USING BTREE COMMENT '优惠券id'
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '用户优惠券记录' ROW_FORMAT = DYNAMIC;
|
|
-- ----------------------------
|
-- Records of t_app_coupon
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_app_coupon_0
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_app_coupon_0`;
|
CREATE TABLE `t_app_coupon_0` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`coupon_id` int NULL DEFAULT NULL COMMENT '优惠券id',
|
`end_time` datetime(0) NULL DEFAULT NULL COMMENT '结束时间',
|
`ways_to_obtain` int NULL DEFAULT NULL COMMENT '获得方式（1=积分兑换，2=现金购买）',
|
`redeem_points` int NULL DEFAULT NULL COMMENT '兑换积分',
|
`payment_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '支付金额',
|
`payment_type` int NULL DEFAULT NULL COMMENT '支付方式（1=微信，2=支付宝）',
|
`serial_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '第三方支付流水号',
|
`payment_time` datetime(0) NULL DEFAULT NULL COMMENT '支付完成时间',
|
`status` int NULL DEFAULT NULL COMMENT '状态（1=未使用，2=已使用）',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
|
`del_flag` int NULL DEFAULT NULL COMMENT '删除（0=否，1=是）',
|
PRIMARY KEY (`id`) USING BTREE,
|
INDEX `app_user_id`(`app_user_id`) USING BTREE COMMENT '用户id',
|
INDEX `coupon_id`(`coupon_id`) USING BTREE COMMENT '优惠券id'
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '用户优惠券记录' ROW_FORMAT = DYNAMIC;
|
|
-- ----------------------------
|
-- Records of t_app_coupon_0
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_app_coupon_1
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_app_coupon_1`;
|
CREATE TABLE `t_app_coupon_1` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`coupon_id` int NULL DEFAULT NULL COMMENT '优惠券id',
|
`end_time` datetime(0) NULL DEFAULT NULL COMMENT '结束时间',
|
`ways_to_obtain` int NULL DEFAULT NULL COMMENT '获得方式（1=积分兑换，2=现金购买）',
|
`redeem_points` int NULL DEFAULT NULL COMMENT '兑换积分',
|
`payment_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '支付金额',
|
`payment_type` int NULL DEFAULT NULL COMMENT '支付方式（1=微信，2=支付宝）',
|
`serial_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '第三方支付流水号',
|
`payment_time` datetime(0) NULL DEFAULT NULL COMMENT '支付完成时间',
|
`status` int NULL DEFAULT NULL COMMENT '状态（1=未使用，2=已使用）',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
|
`del_flag` int NULL DEFAULT NULL COMMENT '删除（0=否，1=是）',
|
PRIMARY KEY (`id`) USING BTREE,
|
INDEX `app_user_id`(`app_user_id`) USING BTREE COMMENT '用户id',
|
INDEX `coupon_id`(`coupon_id`) USING BTREE COMMENT '优惠券id'
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '用户优惠券记录' ROW_FORMAT = DYNAMIC;
|
|
-- ----------------------------
|
-- Records of t_app_coupon_1
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_app_coupon_2
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_app_coupon_2`;
|
CREATE TABLE `t_app_coupon_2` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`coupon_id` int NULL DEFAULT NULL COMMENT '优惠券id',
|
`end_time` datetime(0) NULL DEFAULT NULL COMMENT '结束时间',
|
`ways_to_obtain` int NULL DEFAULT NULL COMMENT '获得方式（1=积分兑换，2=现金购买）',
|
`redeem_points` int NULL DEFAULT NULL COMMENT '兑换积分',
|
`payment_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '支付金额',
|
`payment_type` int NULL DEFAULT NULL COMMENT '支付方式（1=微信，2=支付宝）',
|
`serial_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '第三方支付流水号',
|
`payment_time` datetime(0) NULL DEFAULT NULL COMMENT '支付完成时间',
|
`status` int NULL DEFAULT NULL COMMENT '状态（1=未使用，2=已使用）',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
|
`del_flag` int NULL DEFAULT NULL COMMENT '删除（0=否，1=是）',
|
PRIMARY KEY (`id`) USING BTREE,
|
INDEX `app_user_id`(`app_user_id`) USING BTREE COMMENT '用户id',
|
INDEX `coupon_id`(`coupon_id`) USING BTREE COMMENT '优惠券id'
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '用户优惠券记录' ROW_FORMAT = DYNAMIC;
|
|
-- ----------------------------
|
-- Records of t_app_coupon_2
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_app_coupon_3
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_app_coupon_3`;
|
CREATE TABLE `t_app_coupon_3` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`coupon_id` int NULL DEFAULT NULL COMMENT '优惠券id',
|
`end_time` datetime(0) NULL DEFAULT NULL COMMENT '结束时间',
|
`ways_to_obtain` int NULL DEFAULT NULL COMMENT '获得方式（1=积分兑换，2=现金购买）',
|
`redeem_points` int NULL DEFAULT NULL COMMENT '兑换积分',
|
`payment_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '支付金额',
|
`payment_type` int NULL DEFAULT NULL COMMENT '支付方式（1=微信，2=支付宝）',
|
`serial_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '第三方支付流水号',
|
`payment_time` datetime(0) NULL DEFAULT NULL COMMENT '支付完成时间',
|
`status` int NULL DEFAULT NULL COMMENT '状态（1=未使用，2=已使用）',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
|
`del_flag` int NULL DEFAULT NULL COMMENT '删除（0=否，1=是）',
|
PRIMARY KEY (`id`) USING BTREE,
|
INDEX `app_user_id`(`app_user_id`) USING BTREE COMMENT '用户id',
|
INDEX `coupon_id`(`coupon_id`) USING BTREE COMMENT '优惠券id'
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '用户优惠券记录' ROW_FORMAT = DYNAMIC;
|
|
-- ----------------------------
|
-- Records of t_app_coupon_3
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_app_coupon_4
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_app_coupon_4`;
|
CREATE TABLE `t_app_coupon_4` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`coupon_id` int NULL DEFAULT NULL COMMENT '优惠券id',
|
`end_time` datetime(0) NULL DEFAULT NULL COMMENT '结束时间',
|
`ways_to_obtain` int NULL DEFAULT NULL COMMENT '获得方式（1=积分兑换，2=现金购买）',
|
`redeem_points` int NULL DEFAULT NULL COMMENT '兑换积分',
|
`payment_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '支付金额',
|
`payment_type` int NULL DEFAULT NULL COMMENT '支付方式（1=微信，2=支付宝）',
|
`serial_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '第三方支付流水号',
|
`payment_time` datetime(0) NULL DEFAULT NULL COMMENT '支付完成时间',
|
`status` int NULL DEFAULT NULL COMMENT '状态（1=未使用，2=已使用）',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
|
`del_flag` int NULL DEFAULT NULL COMMENT '删除（0=否，1=是）',
|
PRIMARY KEY (`id`) USING BTREE,
|
INDEX `app_user_id`(`app_user_id`) USING BTREE COMMENT '用户id',
|
INDEX `coupon_id`(`coupon_id`) USING BTREE COMMENT '优惠券id'
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '用户优惠券记录' ROW_FORMAT = DYNAMIC;
|
|
-- ----------------------------
|
-- Records of t_app_coupon_4
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_app_coupon_5
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_app_coupon_5`;
|
CREATE TABLE `t_app_coupon_5` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`coupon_id` int NULL DEFAULT NULL COMMENT '优惠券id',
|
`end_time` datetime(0) NULL DEFAULT NULL COMMENT '结束时间',
|
`ways_to_obtain` int NULL DEFAULT NULL COMMENT '获得方式（1=积分兑换，2=现金购买）',
|
`redeem_points` int NULL DEFAULT NULL COMMENT '兑换积分',
|
`payment_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '支付金额',
|
`payment_type` int NULL DEFAULT NULL COMMENT '支付方式（1=微信，2=支付宝）',
|
`serial_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '第三方支付流水号',
|
`payment_time` datetime(0) NULL DEFAULT NULL COMMENT '支付完成时间',
|
`status` int NULL DEFAULT NULL COMMENT '状态（1=未使用，2=已使用）',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
|
`del_flag` int NULL DEFAULT NULL COMMENT '删除（0=否，1=是）',
|
PRIMARY KEY (`id`) USING BTREE,
|
INDEX `app_user_id`(`app_user_id`) USING BTREE COMMENT '用户id',
|
INDEX `coupon_id`(`coupon_id`) USING BTREE COMMENT '优惠券id'
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '用户优惠券记录' ROW_FORMAT = DYNAMIC;
|
|
-- ----------------------------
|
-- Records of t_app_coupon_5
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_app_coupon_6
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_app_coupon_6`;
|
CREATE TABLE `t_app_coupon_6` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`coupon_id` int NULL DEFAULT NULL COMMENT '优惠券id',
|
`end_time` datetime(0) NULL DEFAULT NULL COMMENT '结束时间',
|
`ways_to_obtain` int NULL DEFAULT NULL COMMENT '获得方式（1=积分兑换，2=现金购买）',
|
`redeem_points` int NULL DEFAULT NULL COMMENT '兑换积分',
|
`payment_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '支付金额',
|
`payment_type` int NULL DEFAULT NULL COMMENT '支付方式（1=微信，2=支付宝）',
|
`serial_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '第三方支付流水号',
|
`payment_time` datetime(0) NULL DEFAULT NULL COMMENT '支付完成时间',
|
`status` int NULL DEFAULT NULL COMMENT '状态（1=未使用，2=已使用）',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
|
`del_flag` int NULL DEFAULT NULL COMMENT '删除（0=否，1=是）',
|
PRIMARY KEY (`id`) USING BTREE,
|
INDEX `app_user_id`(`app_user_id`) USING BTREE COMMENT '用户id',
|
INDEX `coupon_id`(`coupon_id`) USING BTREE COMMENT '优惠券id'
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '用户优惠券记录' ROW_FORMAT = DYNAMIC;
|
|
-- ----------------------------
|
-- Records of t_app_coupon_6
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_app_coupon_7
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_app_coupon_7`;
|
CREATE TABLE `t_app_coupon_7` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`coupon_id` int NULL DEFAULT NULL COMMENT '优惠券id',
|
`end_time` datetime(0) NULL DEFAULT NULL COMMENT '结束时间',
|
`ways_to_obtain` int NULL DEFAULT NULL COMMENT '获得方式（1=积分兑换，2=现金购买）',
|
`redeem_points` int NULL DEFAULT NULL COMMENT '兑换积分',
|
`payment_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '支付金额',
|
`payment_type` int NULL DEFAULT NULL COMMENT '支付方式（1=微信，2=支付宝）',
|
`serial_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '第三方支付流水号',
|
`payment_time` datetime(0) NULL DEFAULT NULL COMMENT '支付完成时间',
|
`status` int NULL DEFAULT NULL COMMENT '状态（1=未使用，2=已使用）',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
|
`del_flag` int NULL DEFAULT NULL COMMENT '删除（0=否，1=是）',
|
PRIMARY KEY (`id`) USING BTREE,
|
INDEX `app_user_id`(`app_user_id`) USING BTREE COMMENT '用户id',
|
INDEX `coupon_id`(`coupon_id`) USING BTREE COMMENT '优惠券id'
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '用户优惠券记录' ROW_FORMAT = DYNAMIC;
|
|
-- ----------------------------
|
-- Records of t_app_coupon_7
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_app_coupon_8
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_app_coupon_8`;
|
CREATE TABLE `t_app_coupon_8` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`coupon_id` int NULL DEFAULT NULL COMMENT '优惠券id',
|
`end_time` datetime(0) NULL DEFAULT NULL COMMENT '结束时间',
|
`ways_to_obtain` int NULL DEFAULT NULL COMMENT '获得方式（1=积分兑换，2=现金购买）',
|
`redeem_points` int NULL DEFAULT NULL COMMENT '兑换积分',
|
`payment_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '支付金额',
|
`payment_type` int NULL DEFAULT NULL COMMENT '支付方式（1=微信，2=支付宝）',
|
`serial_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '第三方支付流水号',
|
`payment_time` datetime(0) NULL DEFAULT NULL COMMENT '支付完成时间',
|
`status` int NULL DEFAULT NULL COMMENT '状态（1=未使用，2=已使用）',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
|
`del_flag` int NULL DEFAULT NULL COMMENT '删除（0=否，1=是）',
|
PRIMARY KEY (`id`) USING BTREE,
|
INDEX `app_user_id`(`app_user_id`) USING BTREE COMMENT '用户id',
|
INDEX `coupon_id`(`coupon_id`) USING BTREE COMMENT '优惠券id'
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '用户优惠券记录' ROW_FORMAT = DYNAMIC;
|
|
-- ----------------------------
|
-- Records of t_app_coupon_8
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_app_coupon_9
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_app_coupon_9`;
|
CREATE TABLE `t_app_coupon_9` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`coupon_id` int NULL DEFAULT NULL COMMENT '优惠券id',
|
`end_time` datetime(0) NULL DEFAULT NULL COMMENT '结束时间',
|
`ways_to_obtain` int NULL DEFAULT NULL COMMENT '获得方式（1=积分兑换，2=现金购买）',
|
`redeem_points` int NULL DEFAULT NULL COMMENT '兑换积分',
|
`payment_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '支付金额',
|
`payment_type` int NULL DEFAULT NULL COMMENT '支付方式（1=微信，2=支付宝）',
|
`serial_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '第三方支付流水号',
|
`payment_time` datetime(0) NULL DEFAULT NULL COMMENT '支付完成时间',
|
`status` int NULL DEFAULT NULL COMMENT '状态（1=未使用，2=已使用）',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
|
`del_flag` int NULL DEFAULT NULL COMMENT '删除（0=否，1=是）',
|
PRIMARY KEY (`id`) USING BTREE,
|
INDEX `app_user_id`(`app_user_id`) USING BTREE COMMENT '用户id',
|
INDEX `coupon_id`(`coupon_id`) USING BTREE COMMENT '优惠券id'
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '用户优惠券记录' ROW_FORMAT = DYNAMIC;
|
|
-- ----------------------------
|
-- Records of t_app_coupon_9
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_app_user
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_app_user`;
|
CREATE TABLE `t_app_user` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '用户',
|
`phone` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '手机号',
|
`avatar` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '头像',
|
`vip_id` int NULL DEFAULT NULL COMMENT '会员id',
|
`vip_end_time` datetime(0) NULL DEFAULT NULL COMMENT '会员到期时间',
|
`company_id` int NULL DEFAULT NULL COMMENT '单位id',
|
`id_card` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '身份证号',
|
`auth_status` int NULL DEFAULT NULL COMMENT '认证状态（0=否，1=是）',
|
`wx_openid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '微信openid',
|
`ali_openid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '支付宝openid',
|
`points` int NULL DEFAULT NULL COMMENT '积分',
|
`province` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '省名称',
|
`province_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '省区划代码',
|
`city` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '市名称',
|
`city_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '市区划代码',
|
`status` int NULL DEFAULT NULL COMMENT '状态（1=正常，2=冻结，3=注销）',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
|
`del_flag` int NULL DEFAULT NULL COMMENT '删除（0=否，1=是）',
|
`last_login_time` datetime(0) NULL DEFAULT NULL COMMENT '最后一次登录时间',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '用户' ROW_FORMAT = DYNAMIC;
|
|
-- ----------------------------
|
-- Records of t_app_user
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_app_user_0
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_app_user_0`;
|
CREATE TABLE `t_app_user_0` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '用户',
|
`phone` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '手机号',
|
`avatar` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '头像',
|
`vip_id` int NULL DEFAULT NULL COMMENT '会员id',
|
`vip_end_time` datetime(0) NULL DEFAULT NULL COMMENT '会员到期时间',
|
`company_id` int NULL DEFAULT NULL COMMENT '单位id',
|
`id_card` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '身份证号',
|
`auth_status` int NULL DEFAULT NULL COMMENT '认证状态（0=否，1=是）',
|
`wx_openid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '微信openid',
|
`ali_openid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '支付宝openid',
|
`points` int NULL DEFAULT NULL COMMENT '积分',
|
`province` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '省名称',
|
`province_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '省区划代码',
|
`city` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '市名称',
|
`city_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '市区划代码',
|
`status` int NULL DEFAULT NULL COMMENT '状态（1=正常，2=冻结，3=注销）',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
|
`del_flag` int NULL DEFAULT NULL COMMENT '删除（0=否，1=是）',
|
`last_login_time` datetime(0) NULL DEFAULT NULL COMMENT '最后一次登录时间',
|
PRIMARY KEY (`id`) USING BTREE,
|
INDEX `phone`(`phone`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '用户' ROW_FORMAT = DYNAMIC;
|
|
-- ----------------------------
|
-- Records of t_app_user_0
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_app_user_1
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_app_user_1`;
|
CREATE TABLE `t_app_user_1` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '用户',
|
`phone` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '手机号',
|
`avatar` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '头像',
|
`vip_id` int NULL DEFAULT NULL COMMENT '会员id',
|
`vip_end_time` datetime(0) NULL DEFAULT NULL COMMENT '会员到期时间',
|
`company_id` int NULL DEFAULT NULL COMMENT '单位id',
|
`id_card` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '身份证号',
|
`auth_status` int NULL DEFAULT NULL COMMENT '认证状态（0=否，1=是）',
|
`wx_openid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '微信openid',
|
`ali_openid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '支付宝openid',
|
`points` int NULL DEFAULT NULL COMMENT '积分',
|
`province` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '省名称',
|
`province_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '省区划代码',
|
`city` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '市名称',
|
`city_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '市区划代码',
|
`status` int NULL DEFAULT NULL COMMENT '状态（1=正常，2=冻结，3=注销）',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
|
`del_flag` int NULL DEFAULT NULL COMMENT '删除（0=否，1=是）',
|
`last_login_time` datetime(0) NULL DEFAULT NULL COMMENT '最后一次登录时间',
|
PRIMARY KEY (`id`) USING BTREE,
|
INDEX `phone`(`phone`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '用户' ROW_FORMAT = DYNAMIC;
|
|
-- ----------------------------
|
-- Records of t_app_user_1
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_app_user_2
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_app_user_2`;
|
CREATE TABLE `t_app_user_2` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '用户',
|
`phone` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '手机号',
|
`avatar` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '头像',
|
`vip_id` int NULL DEFAULT NULL COMMENT '会员id',
|
`vip_end_time` datetime(0) NULL DEFAULT NULL COMMENT '会员到期时间',
|
`company_id` int NULL DEFAULT NULL COMMENT '单位id',
|
`id_card` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '身份证号',
|
`auth_status` int NULL DEFAULT NULL COMMENT '认证状态（0=否，1=是）',
|
`wx_openid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '微信openid',
|
`ali_openid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '支付宝openid',
|
`points` int NULL DEFAULT NULL COMMENT '积分',
|
`province` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '省名称',
|
`province_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '省区划代码',
|
`city` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '市名称',
|
`city_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '市区划代码',
|
`status` int NULL DEFAULT NULL COMMENT '状态（1=正常，2=冻结，3=注销）',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
|
`del_flag` int NULL DEFAULT NULL COMMENT '删除（0=否，1=是）',
|
`last_login_time` datetime(0) NULL DEFAULT NULL COMMENT '最后一次登录时间',
|
PRIMARY KEY (`id`) USING BTREE,
|
INDEX `phone`(`phone`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '用户' ROW_FORMAT = DYNAMIC;
|
|
-- ----------------------------
|
-- Records of t_app_user_2
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_app_user_3
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_app_user_3`;
|
CREATE TABLE `t_app_user_3` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '用户',
|
`phone` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '手机号',
|
`avatar` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '头像',
|
`vip_id` int NULL DEFAULT NULL COMMENT '会员id',
|
`vip_end_time` datetime(0) NULL DEFAULT NULL COMMENT '会员到期时间',
|
`company_id` int NULL DEFAULT NULL COMMENT '单位id',
|
`id_card` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '身份证号',
|
`auth_status` int NULL DEFAULT NULL COMMENT '认证状态（0=否，1=是）',
|
`wx_openid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '微信openid',
|
`ali_openid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '支付宝openid',
|
`points` int NULL DEFAULT NULL COMMENT '积分',
|
`province` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '省名称',
|
`province_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '省区划代码',
|
`city` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '市名称',
|
`city_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '市区划代码',
|
`status` int NULL DEFAULT NULL COMMENT '状态（1=正常，2=冻结，3=注销）',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
|
`del_flag` int NULL DEFAULT NULL COMMENT '删除（0=否，1=是）',
|
`last_login_time` datetime(0) NULL DEFAULT NULL COMMENT '最后一次登录时间',
|
PRIMARY KEY (`id`) USING BTREE,
|
INDEX `phone`(`phone`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '用户' ROW_FORMAT = DYNAMIC;
|
|
-- ----------------------------
|
-- Records of t_app_user_3
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_app_user_4
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_app_user_4`;
|
CREATE TABLE `t_app_user_4` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '用户',
|
`phone` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '手机号',
|
`avatar` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '头像',
|
`vip_id` int NULL DEFAULT NULL COMMENT '会员id',
|
`vip_end_time` datetime(0) NULL DEFAULT NULL COMMENT '会员到期时间',
|
`company_id` int NULL DEFAULT NULL COMMENT '单位id',
|
`id_card` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '身份证号',
|
`auth_status` int NULL DEFAULT NULL COMMENT '认证状态（0=否，1=是）',
|
`wx_openid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '微信openid',
|
`ali_openid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '支付宝openid',
|
`points` int NULL DEFAULT NULL COMMENT '积分',
|
`province` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '省名称',
|
`province_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '省区划代码',
|
`city` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '市名称',
|
`city_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '市区划代码',
|
`status` int NULL DEFAULT NULL COMMENT '状态（1=正常，2=冻结，3=注销）',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
|
`del_flag` int NULL DEFAULT NULL COMMENT '删除（0=否，1=是）',
|
`last_login_time` datetime(0) NULL DEFAULT NULL COMMENT '最后一次登录时间',
|
PRIMARY KEY (`id`) USING BTREE,
|
INDEX `phone`(`phone`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '用户' ROW_FORMAT = DYNAMIC;
|
|
-- ----------------------------
|
-- Records of t_app_user_4
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_app_user_5
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_app_user_5`;
|
CREATE TABLE `t_app_user_5` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '用户',
|
`phone` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '手机号',
|
`avatar` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '头像',
|
`vip_id` int NULL DEFAULT NULL COMMENT '会员id',
|
`vip_end_time` datetime(0) NULL DEFAULT NULL COMMENT '会员到期时间',
|
`company_id` int NULL DEFAULT NULL COMMENT '单位id',
|
`id_card` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '身份证号',
|
`auth_status` int NULL DEFAULT NULL COMMENT '认证状态（0=否，1=是）',
|
`wx_openid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '微信openid',
|
`ali_openid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '支付宝openid',
|
`points` int NULL DEFAULT NULL COMMENT '积分',
|
`province` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '省名称',
|
`province_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '省区划代码',
|
`city` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '市名称',
|
`city_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '市区划代码',
|
`status` int NULL DEFAULT NULL COMMENT '状态（1=正常，2=冻结，3=注销）',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
|
`del_flag` int NULL DEFAULT NULL COMMENT '删除（0=否，1=是）',
|
`last_login_time` datetime(0) NULL DEFAULT NULL COMMENT '最后一次登录时间',
|
PRIMARY KEY (`id`) USING BTREE,
|
INDEX `phone`(`phone`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '用户' ROW_FORMAT = DYNAMIC;
|
|
-- ----------------------------
|
-- Records of t_app_user_5
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_app_user_6
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_app_user_6`;
|
CREATE TABLE `t_app_user_6` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '用户',
|
`phone` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '手机号',
|
`avatar` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '头像',
|
`vip_id` int NULL DEFAULT NULL COMMENT '会员id',
|
`vip_end_time` datetime(0) NULL DEFAULT NULL COMMENT '会员到期时间',
|
`company_id` int NULL DEFAULT NULL COMMENT '单位id',
|
`id_card` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '身份证号',
|
`auth_status` int NULL DEFAULT NULL COMMENT '认证状态（0=否，1=是）',
|
`wx_openid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '微信openid',
|
`ali_openid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '支付宝openid',
|
`points` int NULL DEFAULT NULL COMMENT '积分',
|
`province` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '省名称',
|
`province_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '省区划代码',
|
`city` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '市名称',
|
`city_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '市区划代码',
|
`status` int NULL DEFAULT NULL COMMENT '状态（1=正常，2=冻结，3=注销）',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
|
`del_flag` int NULL DEFAULT NULL COMMENT '删除（0=否，1=是）',
|
`last_login_time` datetime(0) NULL DEFAULT NULL COMMENT '最后一次登录时间',
|
PRIMARY KEY (`id`) USING BTREE,
|
INDEX `phone`(`phone`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '用户' ROW_FORMAT = DYNAMIC;
|
|
-- ----------------------------
|
-- Records of t_app_user_6
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_app_user_7
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_app_user_7`;
|
CREATE TABLE `t_app_user_7` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '用户',
|
`phone` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '手机号',
|
`avatar` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '头像',
|
`vip_id` int NULL DEFAULT NULL COMMENT '会员id',
|
`vip_end_time` datetime(0) NULL DEFAULT NULL COMMENT '会员到期时间',
|
`company_id` int NULL DEFAULT NULL COMMENT '单位id',
|
`id_card` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '身份证号',
|
`auth_status` int NULL DEFAULT NULL COMMENT '认证状态（0=否，1=是）',
|
`wx_openid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '微信openid',
|
`ali_openid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '支付宝openid',
|
`points` int NULL DEFAULT NULL COMMENT '积分',
|
`province` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '省名称',
|
`province_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '省区划代码',
|
`city` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '市名称',
|
`city_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '市区划代码',
|
`status` int NULL DEFAULT NULL COMMENT '状态（1=正常，2=冻结，3=注销）',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
|
`del_flag` int NULL DEFAULT NULL COMMENT '删除（0=否，1=是）',
|
`last_login_time` datetime(0) NULL DEFAULT NULL COMMENT '最后一次登录时间',
|
PRIMARY KEY (`id`) USING BTREE,
|
INDEX `phone`(`phone`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '用户' ROW_FORMAT = DYNAMIC;
|
|
-- ----------------------------
|
-- Records of t_app_user_7
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_app_user_8
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_app_user_8`;
|
CREATE TABLE `t_app_user_8` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '用户',
|
`phone` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '手机号',
|
`avatar` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '头像',
|
`vip_id` int NULL DEFAULT NULL COMMENT '会员id',
|
`vip_end_time` datetime(0) NULL DEFAULT NULL COMMENT '会员到期时间',
|
`company_id` int NULL DEFAULT NULL COMMENT '单位id',
|
`id_card` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '身份证号',
|
`auth_status` int NULL DEFAULT NULL COMMENT '认证状态（0=否，1=是）',
|
`wx_openid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '微信openid',
|
`ali_openid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '支付宝openid',
|
`points` int NULL DEFAULT NULL COMMENT '积分',
|
`province` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '省名称',
|
`province_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '省区划代码',
|
`city` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '市名称',
|
`city_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '市区划代码',
|
`status` int NULL DEFAULT NULL COMMENT '状态（1=正常，2=冻结，3=注销）',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
|
`del_flag` int NULL DEFAULT NULL COMMENT '删除（0=否，1=是）',
|
`last_login_time` datetime(0) NULL DEFAULT NULL COMMENT '最后一次登录时间',
|
PRIMARY KEY (`id`) USING BTREE,
|
INDEX `phone`(`phone`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '用户' ROW_FORMAT = DYNAMIC;
|
|
-- ----------------------------
|
-- Records of t_app_user_8
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_app_user_9
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_app_user_9`;
|
CREATE TABLE `t_app_user_9` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '用户',
|
`phone` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '手机号',
|
`avatar` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '头像',
|
`vip_id` int NULL DEFAULT NULL COMMENT '会员id',
|
`vip_end_time` datetime(0) NULL DEFAULT NULL COMMENT '会员到期时间',
|
`company_id` int NULL DEFAULT NULL COMMENT '单位id',
|
`id_card` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '身份证号',
|
`auth_status` int NULL DEFAULT NULL COMMENT '认证状态（0=否，1=是）',
|
`wx_openid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '微信openid',
|
`ali_openid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '支付宝openid',
|
`points` int NULL DEFAULT NULL COMMENT '积分',
|
`province` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '省名称',
|
`province_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '省区划代码',
|
`city` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '市名称',
|
`city_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '市区划代码',
|
`status` int NULL DEFAULT NULL COMMENT '状态（1=正常，2=冻结，3=注销）',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
|
`del_flag` int NULL DEFAULT NULL COMMENT '删除（0=否，1=是）',
|
`last_login_time` datetime(0) NULL DEFAULT NULL COMMENT '最后一次登录时间',
|
PRIMARY KEY (`id`) USING BTREE,
|
INDEX `phone`(`phone`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '用户' ROW_FORMAT = DYNAMIC;
|
|
-- ----------------------------
|
-- Records of t_app_user_9
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_app_user_address
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_app_user_address`;
|
CREATE TABLE `t_app_user_address` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '收货人',
|
`phone` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '手机号码',
|
`city` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '市名称',
|
`city_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '市编号',
|
`address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '详细地址',
|
`lon` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '经度',
|
`lat` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '纬度',
|
`default_address` int NULL DEFAULT NULL COMMENT '默认地址（0=否，1=是）',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
|
`del_flag` int NULL DEFAULT NULL COMMENT '删除（0=否，1=是）',
|
PRIMARY KEY (`id`) USING BTREE,
|
INDEX `app_user_id`(`app_user_id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '用户收货地址' ROW_FORMAT = DYNAMIC;
|
|
-- ----------------------------
|
-- Records of t_app_user_address
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_app_user_address_0
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_app_user_address_0`;
|
CREATE TABLE `t_app_user_address_0` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '收货人',
|
`phone` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '手机号码',
|
`city` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '市名称',
|
`city_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '市编号',
|
`address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '详细地址',
|
`lon` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '经度',
|
`lat` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '纬度',
|
`default_address` int NULL DEFAULT NULL COMMENT '默认地址（0=否，1=是）',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
|
`del_flag` int NULL DEFAULT NULL COMMENT '删除（0=否，1=是）',
|
PRIMARY KEY (`id`) USING BTREE,
|
INDEX `app_user_id`(`app_user_id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '用户收货地址' ROW_FORMAT = DYNAMIC;
|
|
-- ----------------------------
|
-- Records of t_app_user_address_0
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_app_user_address_1
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_app_user_address_1`;
|
CREATE TABLE `t_app_user_address_1` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '收货人',
|
`phone` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '手机号码',
|
`city` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '市名称',
|
`city_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '市编号',
|
`address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '详细地址',
|
`lon` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '经度',
|
`lat` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '纬度',
|
`default_address` int NULL DEFAULT NULL COMMENT '默认地址（0=否，1=是）',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
|
`del_flag` int NULL DEFAULT NULL COMMENT '删除（0=否，1=是）',
|
PRIMARY KEY (`id`) USING BTREE,
|
INDEX `app_user_id`(`app_user_id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '用户收货地址' ROW_FORMAT = DYNAMIC;
|
|
-- ----------------------------
|
-- Records of t_app_user_address_1
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_app_user_address_2
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_app_user_address_2`;
|
CREATE TABLE `t_app_user_address_2` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '收货人',
|
`phone` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '手机号码',
|
`city` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '市名称',
|
`city_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '市编号',
|
`address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '详细地址',
|
`lon` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '经度',
|
`lat` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '纬度',
|
`default_address` int NULL DEFAULT NULL COMMENT '默认地址（0=否，1=是）',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
|
`del_flag` int NULL DEFAULT NULL COMMENT '删除（0=否，1=是）',
|
PRIMARY KEY (`id`) USING BTREE,
|
INDEX `app_user_id`(`app_user_id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '用户收货地址' ROW_FORMAT = DYNAMIC;
|
|
-- ----------------------------
|
-- Records of t_app_user_address_2
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_app_user_address_3
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_app_user_address_3`;
|
CREATE TABLE `t_app_user_address_3` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '收货人',
|
`phone` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '手机号码',
|
`city` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '市名称',
|
`city_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '市编号',
|
`address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '详细地址',
|
`lon` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '经度',
|
`lat` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '纬度',
|
`default_address` int NULL DEFAULT NULL COMMENT '默认地址（0=否，1=是）',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
|
`del_flag` int NULL DEFAULT NULL COMMENT '删除（0=否，1=是）',
|
PRIMARY KEY (`id`) USING BTREE,
|
INDEX `app_user_id`(`app_user_id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '用户收货地址' ROW_FORMAT = DYNAMIC;
|
|
-- ----------------------------
|
-- Records of t_app_user_address_3
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_app_user_address_4
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_app_user_address_4`;
|
CREATE TABLE `t_app_user_address_4` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '收货人',
|
`phone` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '手机号码',
|
`city` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '市名称',
|
`city_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '市编号',
|
`address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '详细地址',
|
`lon` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '经度',
|
`lat` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '纬度',
|
`default_address` int NULL DEFAULT NULL COMMENT '默认地址（0=否，1=是）',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
|
`del_flag` int NULL DEFAULT NULL COMMENT '删除（0=否，1=是）',
|
PRIMARY KEY (`id`) USING BTREE,
|
INDEX `app_user_id`(`app_user_id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '用户收货地址' ROW_FORMAT = DYNAMIC;
|
|
-- ----------------------------
|
-- Records of t_app_user_address_4
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_app_user_address_5
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_app_user_address_5`;
|
CREATE TABLE `t_app_user_address_5` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '收货人',
|
`phone` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '手机号码',
|
`city` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '市名称',
|
`city_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '市编号',
|
`address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '详细地址',
|
`lon` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '经度',
|
`lat` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '纬度',
|
`default_address` int NULL DEFAULT NULL COMMENT '默认地址（0=否，1=是）',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
|
`del_flag` int NULL DEFAULT NULL COMMENT '删除（0=否，1=是）',
|
PRIMARY KEY (`id`) USING BTREE,
|
INDEX `app_user_id`(`app_user_id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '用户收货地址' ROW_FORMAT = DYNAMIC;
|
|
-- ----------------------------
|
-- Records of t_app_user_address_5
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_app_user_address_6
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_app_user_address_6`;
|
CREATE TABLE `t_app_user_address_6` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '收货人',
|
`phone` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '手机号码',
|
`city` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '市名称',
|
`city_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '市编号',
|
`address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '详细地址',
|
`lon` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '经度',
|
`lat` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '纬度',
|
`default_address` int NULL DEFAULT NULL COMMENT '默认地址（0=否，1=是）',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
|
`del_flag` int NULL DEFAULT NULL COMMENT '删除（0=否，1=是）',
|
PRIMARY KEY (`id`) USING BTREE,
|
INDEX `app_user_id`(`app_user_id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '用户收货地址' ROW_FORMAT = DYNAMIC;
|
|
-- ----------------------------
|
-- Records of t_app_user_address_6
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_app_user_address_7
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_app_user_address_7`;
|
CREATE TABLE `t_app_user_address_7` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '收货人',
|
`phone` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '手机号码',
|
`city` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '市名称',
|
`city_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '市编号',
|
`address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '详细地址',
|
`lon` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '经度',
|
`lat` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '纬度',
|
`default_address` int NULL DEFAULT NULL COMMENT '默认地址（0=否，1=是）',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
|
`del_flag` int NULL DEFAULT NULL COMMENT '删除（0=否，1=是）',
|
PRIMARY KEY (`id`) USING BTREE,
|
INDEX `app_user_id`(`app_user_id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '用户收货地址' ROW_FORMAT = DYNAMIC;
|
|
-- ----------------------------
|
-- Records of t_app_user_address_7
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_app_user_address_8
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_app_user_address_8`;
|
CREATE TABLE `t_app_user_address_8` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '收货人',
|
`phone` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '手机号码',
|
`city` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '市名称',
|
`city_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '市编号',
|
`address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '详细地址',
|
`lon` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '经度',
|
`lat` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '纬度',
|
`default_address` int NULL DEFAULT NULL COMMENT '默认地址（0=否，1=是）',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
|
`del_flag` int NULL DEFAULT NULL COMMENT '删除（0=否，1=是）',
|
PRIMARY KEY (`id`) USING BTREE,
|
INDEX `app_user_id`(`app_user_id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '用户收货地址' ROW_FORMAT = DYNAMIC;
|
|
-- ----------------------------
|
-- Records of t_app_user_address_8
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_app_user_address_9
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_app_user_address_9`;
|
CREATE TABLE `t_app_user_address_9` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '收货人',
|
`phone` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '手机号码',
|
`city` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '市名称',
|
`city_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '市编号',
|
`address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '详细地址',
|
`lon` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '经度',
|
`lat` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '纬度',
|
`default_address` int NULL DEFAULT NULL COMMENT '默认地址（0=否，1=是）',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
|
`del_flag` int NULL DEFAULT NULL COMMENT '删除（0=否，1=是）',
|
PRIMARY KEY (`id`) USING BTREE,
|
INDEX `app_user_id`(`app_user_id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '用户收货地址' ROW_FORMAT = DYNAMIC;
|
|
-- ----------------------------
|
-- Records of t_app_user_address_9
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_app_user_car
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_app_user_car`;
|
CREATE TABLE `t_app_user_car` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT 'app用户id',
|
`license_plate` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '车牌',
|
`vehicle_brand` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '车辆品牌',
|
`vehicle_model` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '车型',
|
`vehicle_use` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '车辆用途',
|
`endurance` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '续航',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
|
`del_flag` int NULL DEFAULT NULL COMMENT '删除（0=否，1=是）',
|
PRIMARY KEY (`id`) USING BTREE,
|
INDEX `app_user_id`(`app_user_id`) USING BTREE,
|
INDEX `license_plate`(`license_plate`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '用户车辆信息' ROW_FORMAT = DYNAMIC;
|
|
-- ----------------------------
|
-- Records of t_app_user_car
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_app_user_car_0
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_app_user_car_0`;
|
CREATE TABLE `t_app_user_car_0` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT 'app用户id',
|
`license_plate` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '车牌',
|
`vehicle_brand` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '车辆品牌',
|
`vehicle_model` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '车型',
|
`vehicle_use` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '车辆用途',
|
`endurance` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '续航',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
|
`del_flag` int NULL DEFAULT NULL COMMENT '删除（0=否，1=是）',
|
PRIMARY KEY (`id`) USING BTREE,
|
INDEX `app_user_id`(`app_user_id`) USING BTREE,
|
INDEX `license_plate`(`license_plate`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '用户车辆信息' ROW_FORMAT = DYNAMIC;
|
|
-- ----------------------------
|
-- Records of t_app_user_car_0
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_app_user_car_1
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_app_user_car_1`;
|
CREATE TABLE `t_app_user_car_1` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT 'app用户id',
|
`license_plate` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '车牌',
|
`vehicle_brand` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '车辆品牌',
|
`vehicle_model` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '车型',
|
`vehicle_use` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '车辆用途',
|
`endurance` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '续航',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
|
`del_flag` int NULL DEFAULT NULL COMMENT '删除（0=否，1=是）',
|
PRIMARY KEY (`id`) USING BTREE,
|
INDEX `app_user_id`(`app_user_id`) USING BTREE,
|
INDEX `license_plate`(`license_plate`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '用户车辆信息' ROW_FORMAT = DYNAMIC;
|
|
-- ----------------------------
|
-- Records of t_app_user_car_1
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_app_user_car_2
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_app_user_car_2`;
|
CREATE TABLE `t_app_user_car_2` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT 'app用户id',
|
`license_plate` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '车牌',
|
`vehicle_brand` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '车辆品牌',
|
`vehicle_model` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '车型',
|
`vehicle_use` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '车辆用途',
|
`endurance` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '续航',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
|
`del_flag` int NULL DEFAULT NULL COMMENT '删除（0=否，1=是）',
|
PRIMARY KEY (`id`) USING BTREE,
|
INDEX `app_user_id`(`app_user_id`) USING BTREE,
|
INDEX `license_plate`(`license_plate`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '用户车辆信息' ROW_FORMAT = DYNAMIC;
|
|
-- ----------------------------
|
-- Records of t_app_user_car_2
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_app_user_car_3
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_app_user_car_3`;
|
CREATE TABLE `t_app_user_car_3` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT 'app用户id',
|
`license_plate` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '车牌',
|
`vehicle_brand` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '车辆品牌',
|
`vehicle_model` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '车型',
|
`vehicle_use` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '车辆用途',
|
`endurance` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '续航',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
|
`del_flag` int NULL DEFAULT NULL COMMENT '删除（0=否，1=是）',
|
PRIMARY KEY (`id`) USING BTREE,
|
INDEX `app_user_id`(`app_user_id`) USING BTREE,
|
INDEX `license_plate`(`license_plate`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '用户车辆信息' ROW_FORMAT = DYNAMIC;
|
|
-- ----------------------------
|
-- Records of t_app_user_car_3
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_app_user_car_4
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_app_user_car_4`;
|
CREATE TABLE `t_app_user_car_4` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT 'app用户id',
|
`license_plate` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '车牌',
|
`vehicle_brand` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '车辆品牌',
|
`vehicle_model` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '车型',
|
`vehicle_use` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '车辆用途',
|
`endurance` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '续航',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
|
`del_flag` int NULL DEFAULT NULL COMMENT '删除（0=否，1=是）',
|
PRIMARY KEY (`id`) USING BTREE,
|
INDEX `app_user_id`(`app_user_id`) USING BTREE,
|
INDEX `license_plate`(`license_plate`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '用户车辆信息' ROW_FORMAT = DYNAMIC;
|
|
-- ----------------------------
|
-- Records of t_app_user_car_4
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_app_user_car_5
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_app_user_car_5`;
|
CREATE TABLE `t_app_user_car_5` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT 'app用户id',
|
`license_plate` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '车牌',
|
`vehicle_brand` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '车辆品牌',
|
`vehicle_model` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '车型',
|
`vehicle_use` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '车辆用途',
|
`endurance` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '续航',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
|
`del_flag` int NULL DEFAULT NULL COMMENT '删除（0=否，1=是）',
|
PRIMARY KEY (`id`) USING BTREE,
|
INDEX `app_user_id`(`app_user_id`) USING BTREE,
|
INDEX `license_plate`(`license_plate`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '用户车辆信息' ROW_FORMAT = DYNAMIC;
|
|
-- ----------------------------
|
-- Records of t_app_user_car_5
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_app_user_car_6
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_app_user_car_6`;
|
CREATE TABLE `t_app_user_car_6` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT 'app用户id',
|
`license_plate` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '车牌',
|
`vehicle_brand` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '车辆品牌',
|
`vehicle_model` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '车型',
|
`vehicle_use` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '车辆用途',
|
`endurance` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '续航',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
|
`del_flag` int NULL DEFAULT NULL COMMENT '删除（0=否，1=是）',
|
PRIMARY KEY (`id`) USING BTREE,
|
INDEX `app_user_id`(`app_user_id`) USING BTREE,
|
INDEX `license_plate`(`license_plate`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '用户车辆信息' ROW_FORMAT = DYNAMIC;
|
|
-- ----------------------------
|
-- Records of t_app_user_car_6
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_app_user_car_7
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_app_user_car_7`;
|
CREATE TABLE `t_app_user_car_7` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT 'app用户id',
|
`license_plate` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '车牌',
|
`vehicle_brand` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '车辆品牌',
|
`vehicle_model` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '车型',
|
`vehicle_use` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '车辆用途',
|
`endurance` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '续航',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
|
`del_flag` int NULL DEFAULT NULL COMMENT '删除（0=否，1=是）',
|
PRIMARY KEY (`id`) USING BTREE,
|
INDEX `app_user_id`(`app_user_id`) USING BTREE,
|
INDEX `license_plate`(`license_plate`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '用户车辆信息' ROW_FORMAT = DYNAMIC;
|
|
-- ----------------------------
|
-- Records of t_app_user_car_7
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_app_user_car_8
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_app_user_car_8`;
|
CREATE TABLE `t_app_user_car_8` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT 'app用户id',
|
`license_plate` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '车牌',
|
`vehicle_brand` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '车辆品牌',
|
`vehicle_model` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '车型',
|
`vehicle_use` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '车辆用途',
|
`endurance` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '续航',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
|
`del_flag` int NULL DEFAULT NULL COMMENT '删除（0=否，1=是）',
|
PRIMARY KEY (`id`) USING BTREE,
|
INDEX `app_user_id`(`app_user_id`) USING BTREE,
|
INDEX `license_plate`(`license_plate`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '用户车辆信息' ROW_FORMAT = DYNAMIC;
|
|
-- ----------------------------
|
-- Records of t_app_user_car_8
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_app_user_car_9
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_app_user_car_9`;
|
CREATE TABLE `t_app_user_car_9` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT 'app用户id',
|
`license_plate` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '车牌',
|
`vehicle_brand` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '车辆品牌',
|
`vehicle_model` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '车型',
|
`vehicle_use` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '车辆用途',
|
`endurance` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '续航',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
|
`del_flag` int NULL DEFAULT NULL COMMENT '删除（0=否，1=是）',
|
PRIMARY KEY (`id`) USING BTREE,
|
INDEX `app_user_id`(`app_user_id`) USING BTREE,
|
INDEX `license_plate`(`license_plate`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '用户车辆信息' ROW_FORMAT = DYNAMIC;
|
|
-- ----------------------------
|
-- Records of t_app_user_car_9
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_app_user_integral_change
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_app_user_integral_change`;
|
CREATE TABLE `t_app_user_integral_change` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '流水号',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`change_type` int NULL DEFAULT NULL COMMENT '变化类型（1=签到得，2=充电得，3=好评得，4=邀请好友得，5=添加车辆得，6=兑换商品减）',
|
`historical_integral` int NULL DEFAULT NULL COMMENT '历史积分',
|
`current_integral` int NULL DEFAULT NULL COMMENT '当前积分',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
|
`extension` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '扩展字段',
|
PRIMARY KEY (`id`) USING BTREE,
|
INDEX `app_user_id`(`app_user_id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '用户积分变化记录表' ROW_FORMAT = DYNAMIC;
|
|
-- ----------------------------
|
-- Records of t_app_user_integral_change
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_app_user_integral_change_0
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_app_user_integral_change_0`;
|
CREATE TABLE `t_app_user_integral_change_0` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '流水号',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`change_type` int NULL DEFAULT NULL COMMENT '变化类型（1=签到得，2=充电得，3=好评得，4=邀请好友得，5=添加车辆得，6=兑换商品减）',
|
`historical_integral` int NULL DEFAULT NULL COMMENT '历史积分',
|
`current_integral` int NULL DEFAULT NULL COMMENT '当前积分',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
|
`extension` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '扩展字段',
|
PRIMARY KEY (`id`) USING BTREE,
|
INDEX `app_user_id`(`app_user_id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '用户积分变化记录表' ROW_FORMAT = DYNAMIC;
|
|
-- ----------------------------
|
-- Records of t_app_user_integral_change_0
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_app_user_integral_change_1
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_app_user_integral_change_1`;
|
CREATE TABLE `t_app_user_integral_change_1` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '流水号',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`change_type` int NULL DEFAULT NULL COMMENT '变化类型（1=签到得，2=充电得，3=好评得，4=邀请好友得，5=添加车辆得，6=兑换商品减）',
|
`historical_integral` int NULL DEFAULT NULL COMMENT '历史积分',
|
`current_integral` int NULL DEFAULT NULL COMMENT '当前积分',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
|
`extension` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '扩展字段',
|
PRIMARY KEY (`id`) USING BTREE,
|
INDEX `app_user_id`(`app_user_id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '用户积分变化记录表' ROW_FORMAT = DYNAMIC;
|
|
-- ----------------------------
|
-- Records of t_app_user_integral_change_1
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_app_user_integral_change_10
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_app_user_integral_change_10`;
|
CREATE TABLE `t_app_user_integral_change_10` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '流水号',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`change_type` int NULL DEFAULT NULL COMMENT '变化类型（1=签到得，2=充电得，3=好评得，4=邀请好友得，5=添加车辆得，6=兑换商品减）',
|
`historical_integral` int NULL DEFAULT NULL COMMENT '历史积分',
|
`current_integral` int NULL DEFAULT NULL COMMENT '当前积分',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
|
`extension` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '扩展字段',
|
PRIMARY KEY (`id`) USING BTREE,
|
INDEX `app_user_id`(`app_user_id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '用户积分变化记录表' ROW_FORMAT = DYNAMIC;
|
|
-- ----------------------------
|
-- Records of t_app_user_integral_change_10
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_app_user_integral_change_11
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_app_user_integral_change_11`;
|
CREATE TABLE `t_app_user_integral_change_11` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '流水号',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`change_type` int NULL DEFAULT NULL COMMENT '变化类型（1=签到得，2=充电得，3=好评得，4=邀请好友得，5=添加车辆得，6=兑换商品减）',
|
`historical_integral` int NULL DEFAULT NULL COMMENT '历史积分',
|
`current_integral` int NULL DEFAULT NULL COMMENT '当前积分',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
|
`extension` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '扩展字段',
|
PRIMARY KEY (`id`) USING BTREE,
|
INDEX `app_user_id`(`app_user_id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '用户积分变化记录表' ROW_FORMAT = DYNAMIC;
|
|
-- ----------------------------
|
-- Records of t_app_user_integral_change_11
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_app_user_integral_change_12
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_app_user_integral_change_12`;
|
CREATE TABLE `t_app_user_integral_change_12` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '流水号',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`change_type` int NULL DEFAULT NULL COMMENT '变化类型（1=签到得，2=充电得，3=好评得，4=邀请好友得，5=添加车辆得，6=兑换商品减）',
|
`historical_integral` int NULL DEFAULT NULL COMMENT '历史积分',
|
`current_integral` int NULL DEFAULT NULL COMMENT '当前积分',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
|
`extension` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '扩展字段',
|
PRIMARY KEY (`id`) USING BTREE,
|
INDEX `app_user_id`(`app_user_id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '用户积分变化记录表' ROW_FORMAT = DYNAMIC;
|
|
-- ----------------------------
|
-- Records of t_app_user_integral_change_12
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_app_user_integral_change_13
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_app_user_integral_change_13`;
|
CREATE TABLE `t_app_user_integral_change_13` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '流水号',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`change_type` int NULL DEFAULT NULL COMMENT '变化类型（1=签到得，2=充电得，3=好评得，4=邀请好友得，5=添加车辆得，6=兑换商品减）',
|
`historical_integral` int NULL DEFAULT NULL COMMENT '历史积分',
|
`current_integral` int NULL DEFAULT NULL COMMENT '当前积分',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
|
`extension` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '扩展字段',
|
PRIMARY KEY (`id`) USING BTREE,
|
INDEX `app_user_id`(`app_user_id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '用户积分变化记录表' ROW_FORMAT = DYNAMIC;
|
|
-- ----------------------------
|
-- Records of t_app_user_integral_change_13
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_app_user_integral_change_14
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_app_user_integral_change_14`;
|
CREATE TABLE `t_app_user_integral_change_14` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '流水号',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`change_type` int NULL DEFAULT NULL COMMENT '变化类型（1=签到得，2=充电得，3=好评得，4=邀请好友得，5=添加车辆得，6=兑换商品减）',
|
`historical_integral` int NULL DEFAULT NULL COMMENT '历史积分',
|
`current_integral` int NULL DEFAULT NULL COMMENT '当前积分',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
|
`extension` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '扩展字段',
|
PRIMARY KEY (`id`) USING BTREE,
|
INDEX `app_user_id`(`app_user_id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '用户积分变化记录表' ROW_FORMAT = DYNAMIC;
|
|
-- ----------------------------
|
-- Records of t_app_user_integral_change_14
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_app_user_integral_change_15
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_app_user_integral_change_15`;
|
CREATE TABLE `t_app_user_integral_change_15` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '流水号',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`change_type` int NULL DEFAULT NULL COMMENT '变化类型（1=签到得，2=充电得，3=好评得，4=邀请好友得，5=添加车辆得，6=兑换商品减）',
|
`historical_integral` int NULL DEFAULT NULL COMMENT '历史积分',
|
`current_integral` int NULL DEFAULT NULL COMMENT '当前积分',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
|
`extension` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '扩展字段',
|
PRIMARY KEY (`id`) USING BTREE,
|
INDEX `app_user_id`(`app_user_id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '用户积分变化记录表' ROW_FORMAT = DYNAMIC;
|
|
-- ----------------------------
|
-- Records of t_app_user_integral_change_15
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_app_user_integral_change_16
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_app_user_integral_change_16`;
|
CREATE TABLE `t_app_user_integral_change_16` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '流水号',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`change_type` int NULL DEFAULT NULL COMMENT '变化类型（1=签到得，2=充电得，3=好评得，4=邀请好友得，5=添加车辆得，6=兑换商品减）',
|
`historical_integral` int NULL DEFAULT NULL COMMENT '历史积分',
|
`current_integral` int NULL DEFAULT NULL COMMENT '当前积分',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
|
`extension` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '扩展字段',
|
PRIMARY KEY (`id`) USING BTREE,
|
INDEX `app_user_id`(`app_user_id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '用户积分变化记录表' ROW_FORMAT = DYNAMIC;
|
|
-- ----------------------------
|
-- Records of t_app_user_integral_change_16
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_app_user_integral_change_17
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_app_user_integral_change_17`;
|
CREATE TABLE `t_app_user_integral_change_17` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '流水号',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`change_type` int NULL DEFAULT NULL COMMENT '变化类型（1=签到得，2=充电得，3=好评得，4=邀请好友得，5=添加车辆得，6=兑换商品减）',
|
`historical_integral` int NULL DEFAULT NULL COMMENT '历史积分',
|
`current_integral` int NULL DEFAULT NULL COMMENT '当前积分',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
|
`extension` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '扩展字段',
|
PRIMARY KEY (`id`) USING BTREE,
|
INDEX `app_user_id`(`app_user_id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '用户积分变化记录表' ROW_FORMAT = DYNAMIC;
|
|
-- ----------------------------
|
-- Records of t_app_user_integral_change_17
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_app_user_integral_change_18
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_app_user_integral_change_18`;
|
CREATE TABLE `t_app_user_integral_change_18` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '流水号',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`change_type` int NULL DEFAULT NULL COMMENT '变化类型（1=签到得，2=充电得，3=好评得，4=邀请好友得，5=添加车辆得，6=兑换商品减）',
|
`historical_integral` int NULL DEFAULT NULL COMMENT '历史积分',
|
`current_integral` int NULL DEFAULT NULL COMMENT '当前积分',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
|
`extension` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '扩展字段',
|
PRIMARY KEY (`id`) USING BTREE,
|
INDEX `app_user_id`(`app_user_id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '用户积分变化记录表' ROW_FORMAT = DYNAMIC;
|
|
-- ----------------------------
|
-- Records of t_app_user_integral_change_18
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_app_user_integral_change_19
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_app_user_integral_change_19`;
|
CREATE TABLE `t_app_user_integral_change_19` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '流水号',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`change_type` int NULL DEFAULT NULL COMMENT '变化类型（1=签到得，2=充电得，3=好评得，4=邀请好友得，5=添加车辆得，6=兑换商品减）',
|
`historical_integral` int NULL DEFAULT NULL COMMENT '历史积分',
|
`current_integral` int NULL DEFAULT NULL COMMENT '当前积分',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
|
`extension` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '扩展字段',
|
PRIMARY KEY (`id`) USING BTREE,
|
INDEX `app_user_id`(`app_user_id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '用户积分变化记录表' ROW_FORMAT = DYNAMIC;
|
|
-- ----------------------------
|
-- Records of t_app_user_integral_change_19
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_app_user_integral_change_2
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_app_user_integral_change_2`;
|
CREATE TABLE `t_app_user_integral_change_2` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '流水号',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`change_type` int NULL DEFAULT NULL COMMENT '变化类型（1=签到得，2=充电得，3=好评得，4=邀请好友得，5=添加车辆得，6=兑换商品减）',
|
`historical_integral` int NULL DEFAULT NULL COMMENT '历史积分',
|
`current_integral` int NULL DEFAULT NULL COMMENT '当前积分',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
|
`extension` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '扩展字段',
|
PRIMARY KEY (`id`) USING BTREE,
|
INDEX `app_user_id`(`app_user_id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '用户积分变化记录表' ROW_FORMAT = DYNAMIC;
|
|
-- ----------------------------
|
-- Records of t_app_user_integral_change_2
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_app_user_integral_change_20
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_app_user_integral_change_20`;
|
CREATE TABLE `t_app_user_integral_change_20` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '流水号',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`change_type` int NULL DEFAULT NULL COMMENT '变化类型（1=签到得，2=充电得，3=好评得，4=邀请好友得，5=添加车辆得，6=兑换商品减）',
|
`historical_integral` int NULL DEFAULT NULL COMMENT '历史积分',
|
`current_integral` int NULL DEFAULT NULL COMMENT '当前积分',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
|
`extension` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '扩展字段',
|
PRIMARY KEY (`id`) USING BTREE,
|
INDEX `app_user_id`(`app_user_id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '用户积分变化记录表' ROW_FORMAT = DYNAMIC;
|
|
-- ----------------------------
|
-- Records of t_app_user_integral_change_20
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_app_user_integral_change_21
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_app_user_integral_change_21`;
|
CREATE TABLE `t_app_user_integral_change_21` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '流水号',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`change_type` int NULL DEFAULT NULL COMMENT '变化类型（1=签到得，2=充电得，3=好评得，4=邀请好友得，5=添加车辆得，6=兑换商品减）',
|
`historical_integral` int NULL DEFAULT NULL COMMENT '历史积分',
|
`current_integral` int NULL DEFAULT NULL COMMENT '当前积分',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
|
`extension` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '扩展字段',
|
PRIMARY KEY (`id`) USING BTREE,
|
INDEX `app_user_id`(`app_user_id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '用户积分变化记录表' ROW_FORMAT = DYNAMIC;
|
|
-- ----------------------------
|
-- Records of t_app_user_integral_change_21
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_app_user_integral_change_22
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_app_user_integral_change_22`;
|
CREATE TABLE `t_app_user_integral_change_22` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '流水号',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`change_type` int NULL DEFAULT NULL COMMENT '变化类型（1=签到得，2=充电得，3=好评得，4=邀请好友得，5=添加车辆得，6=兑换商品减）',
|
`historical_integral` int NULL DEFAULT NULL COMMENT '历史积分',
|
`current_integral` int NULL DEFAULT NULL COMMENT '当前积分',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
|
`extension` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '扩展字段',
|
PRIMARY KEY (`id`) USING BTREE,
|
INDEX `app_user_id`(`app_user_id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '用户积分变化记录表' ROW_FORMAT = DYNAMIC;
|
|
-- ----------------------------
|
-- Records of t_app_user_integral_change_22
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_app_user_integral_change_23
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_app_user_integral_change_23`;
|
CREATE TABLE `t_app_user_integral_change_23` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '流水号',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`change_type` int NULL DEFAULT NULL COMMENT '变化类型（1=签到得，2=充电得，3=好评得，4=邀请好友得，5=添加车辆得，6=兑换商品减）',
|
`historical_integral` int NULL DEFAULT NULL COMMENT '历史积分',
|
`current_integral` int NULL DEFAULT NULL COMMENT '当前积分',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
|
`extension` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '扩展字段',
|
PRIMARY KEY (`id`) USING BTREE,
|
INDEX `app_user_id`(`app_user_id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '用户积分变化记录表' ROW_FORMAT = DYNAMIC;
|
|
-- ----------------------------
|
-- Records of t_app_user_integral_change_23
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_app_user_integral_change_24
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_app_user_integral_change_24`;
|
CREATE TABLE `t_app_user_integral_change_24` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '流水号',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`change_type` int NULL DEFAULT NULL COMMENT '变化类型（1=签到得，2=充电得，3=好评得，4=邀请好友得，5=添加车辆得，6=兑换商品减）',
|
`historical_integral` int NULL DEFAULT NULL COMMENT '历史积分',
|
`current_integral` int NULL DEFAULT NULL COMMENT '当前积分',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
|
`extension` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '扩展字段',
|
PRIMARY KEY (`id`) USING BTREE,
|
INDEX `app_user_id`(`app_user_id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '用户积分变化记录表' ROW_FORMAT = DYNAMIC;
|
|
-- ----------------------------
|
-- Records of t_app_user_integral_change_24
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_app_user_integral_change_25
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_app_user_integral_change_25`;
|
CREATE TABLE `t_app_user_integral_change_25` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '流水号',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`change_type` int NULL DEFAULT NULL COMMENT '变化类型（1=签到得，2=充电得，3=好评得，4=邀请好友得，5=添加车辆得，6=兑换商品减）',
|
`historical_integral` int NULL DEFAULT NULL COMMENT '历史积分',
|
`current_integral` int NULL DEFAULT NULL COMMENT '当前积分',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
|
`extension` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '扩展字段',
|
PRIMARY KEY (`id`) USING BTREE,
|
INDEX `app_user_id`(`app_user_id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '用户积分变化记录表' ROW_FORMAT = DYNAMIC;
|
|
-- ----------------------------
|
-- Records of t_app_user_integral_change_25
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_app_user_integral_change_26
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_app_user_integral_change_26`;
|
CREATE TABLE `t_app_user_integral_change_26` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '流水号',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`change_type` int NULL DEFAULT NULL COMMENT '变化类型（1=签到得，2=充电得，3=好评得，4=邀请好友得，5=添加车辆得，6=兑换商品减）',
|
`historical_integral` int NULL DEFAULT NULL COMMENT '历史积分',
|
`current_integral` int NULL DEFAULT NULL COMMENT '当前积分',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
|
`extension` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '扩展字段',
|
PRIMARY KEY (`id`) USING BTREE,
|
INDEX `app_user_id`(`app_user_id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '用户积分变化记录表' ROW_FORMAT = DYNAMIC;
|
|
-- ----------------------------
|
-- Records of t_app_user_integral_change_26
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_app_user_integral_change_27
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_app_user_integral_change_27`;
|
CREATE TABLE `t_app_user_integral_change_27` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '流水号',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`change_type` int NULL DEFAULT NULL COMMENT '变化类型（1=签到得，2=充电得，3=好评得，4=邀请好友得，5=添加车辆得，6=兑换商品减）',
|
`historical_integral` int NULL DEFAULT NULL COMMENT '历史积分',
|
`current_integral` int NULL DEFAULT NULL COMMENT '当前积分',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
|
`extension` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '扩展字段',
|
PRIMARY KEY (`id`) USING BTREE,
|
INDEX `app_user_id`(`app_user_id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '用户积分变化记录表' ROW_FORMAT = DYNAMIC;
|
|
-- ----------------------------
|
-- Records of t_app_user_integral_change_27
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_app_user_integral_change_28
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_app_user_integral_change_28`;
|
CREATE TABLE `t_app_user_integral_change_28` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '流水号',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`change_type` int NULL DEFAULT NULL COMMENT '变化类型（1=签到得，2=充电得，3=好评得，4=邀请好友得，5=添加车辆得，6=兑换商品减）',
|
`historical_integral` int NULL DEFAULT NULL COMMENT '历史积分',
|
`current_integral` int NULL DEFAULT NULL COMMENT '当前积分',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
|
`extension` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '扩展字段',
|
PRIMARY KEY (`id`) USING BTREE,
|
INDEX `app_user_id`(`app_user_id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '用户积分变化记录表' ROW_FORMAT = DYNAMIC;
|
|
-- ----------------------------
|
-- Records of t_app_user_integral_change_28
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_app_user_integral_change_29
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_app_user_integral_change_29`;
|
CREATE TABLE `t_app_user_integral_change_29` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '流水号',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`change_type` int NULL DEFAULT NULL COMMENT '变化类型（1=签到得，2=充电得，3=好评得，4=邀请好友得，5=添加车辆得，6=兑换商品减）',
|
`historical_integral` int NULL DEFAULT NULL COMMENT '历史积分',
|
`current_integral` int NULL DEFAULT NULL COMMENT '当前积分',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
|
`extension` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '扩展字段',
|
PRIMARY KEY (`id`) USING BTREE,
|
INDEX `app_user_id`(`app_user_id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '用户积分变化记录表' ROW_FORMAT = DYNAMIC;
|
|
-- ----------------------------
|
-- Records of t_app_user_integral_change_29
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_app_user_integral_change_3
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_app_user_integral_change_3`;
|
CREATE TABLE `t_app_user_integral_change_3` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '流水号',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`change_type` int NULL DEFAULT NULL COMMENT '变化类型（1=签到得，2=充电得，3=好评得，4=邀请好友得，5=添加车辆得，6=兑换商品减）',
|
`historical_integral` int NULL DEFAULT NULL COMMENT '历史积分',
|
`current_integral` int NULL DEFAULT NULL COMMENT '当前积分',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
|
`extension` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '扩展字段',
|
PRIMARY KEY (`id`) USING BTREE,
|
INDEX `app_user_id`(`app_user_id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '用户积分变化记录表' ROW_FORMAT = DYNAMIC;
|
|
-- ----------------------------
|
-- Records of t_app_user_integral_change_3
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_app_user_integral_change_30
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_app_user_integral_change_30`;
|
CREATE TABLE `t_app_user_integral_change_30` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '流水号',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`change_type` int NULL DEFAULT NULL COMMENT '变化类型（1=签到得，2=充电得，3=好评得，4=邀请好友得，5=添加车辆得，6=兑换商品减）',
|
`historical_integral` int NULL DEFAULT NULL COMMENT '历史积分',
|
`current_integral` int NULL DEFAULT NULL COMMENT '当前积分',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
|
`extension` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '扩展字段',
|
PRIMARY KEY (`id`) USING BTREE,
|
INDEX `app_user_id`(`app_user_id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '用户积分变化记录表' ROW_FORMAT = DYNAMIC;
|
|
-- ----------------------------
|
-- Records of t_app_user_integral_change_30
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_app_user_integral_change_31
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_app_user_integral_change_31`;
|
CREATE TABLE `t_app_user_integral_change_31` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '流水号',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`change_type` int NULL DEFAULT NULL COMMENT '变化类型（1=签到得，2=充电得，3=好评得，4=邀请好友得，5=添加车辆得，6=兑换商品减）',
|
`historical_integral` int NULL DEFAULT NULL COMMENT '历史积分',
|
`current_integral` int NULL DEFAULT NULL COMMENT '当前积分',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
|
`extension` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '扩展字段',
|
PRIMARY KEY (`id`) USING BTREE,
|
INDEX `app_user_id`(`app_user_id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '用户积分变化记录表' ROW_FORMAT = DYNAMIC;
|
|
-- ----------------------------
|
-- Records of t_app_user_integral_change_31
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_app_user_integral_change_32
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_app_user_integral_change_32`;
|
CREATE TABLE `t_app_user_integral_change_32` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '流水号',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`change_type` int NULL DEFAULT NULL COMMENT '变化类型（1=签到得，2=充电得，3=好评得，4=邀请好友得，5=添加车辆得，6=兑换商品减）',
|
`historical_integral` int NULL DEFAULT NULL COMMENT '历史积分',
|
`current_integral` int NULL DEFAULT NULL COMMENT '当前积分',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
|
`extension` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '扩展字段',
|
PRIMARY KEY (`id`) USING BTREE,
|
INDEX `app_user_id`(`app_user_id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '用户积分变化记录表' ROW_FORMAT = DYNAMIC;
|
|
-- ----------------------------
|
-- Records of t_app_user_integral_change_32
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_app_user_integral_change_33
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_app_user_integral_change_33`;
|
CREATE TABLE `t_app_user_integral_change_33` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '流水号',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`change_type` int NULL DEFAULT NULL COMMENT '变化类型（1=签到得，2=充电得，3=好评得，4=邀请好友得，5=添加车辆得，6=兑换商品减）',
|
`historical_integral` int NULL DEFAULT NULL COMMENT '历史积分',
|
`current_integral` int NULL DEFAULT NULL COMMENT '当前积分',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
|
`extension` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '扩展字段',
|
PRIMARY KEY (`id`) USING BTREE,
|
INDEX `app_user_id`(`app_user_id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '用户积分变化记录表' ROW_FORMAT = DYNAMIC;
|
|
-- ----------------------------
|
-- Records of t_app_user_integral_change_33
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_app_user_integral_change_34
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_app_user_integral_change_34`;
|
CREATE TABLE `t_app_user_integral_change_34` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '流水号',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`change_type` int NULL DEFAULT NULL COMMENT '变化类型（1=签到得，2=充电得，3=好评得，4=邀请好友得，5=添加车辆得，6=兑换商品减）',
|
`historical_integral` int NULL DEFAULT NULL COMMENT '历史积分',
|
`current_integral` int NULL DEFAULT NULL COMMENT '当前积分',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
|
`extension` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '扩展字段',
|
PRIMARY KEY (`id`) USING BTREE,
|
INDEX `app_user_id`(`app_user_id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '用户积分变化记录表' ROW_FORMAT = DYNAMIC;
|
|
-- ----------------------------
|
-- Records of t_app_user_integral_change_34
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_app_user_integral_change_35
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_app_user_integral_change_35`;
|
CREATE TABLE `t_app_user_integral_change_35` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '流水号',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`change_type` int NULL DEFAULT NULL COMMENT '变化类型（1=签到得，2=充电得，3=好评得，4=邀请好友得，5=添加车辆得，6=兑换商品减）',
|
`historical_integral` int NULL DEFAULT NULL COMMENT '历史积分',
|
`current_integral` int NULL DEFAULT NULL COMMENT '当前积分',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
|
`extension` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '扩展字段',
|
PRIMARY KEY (`id`) USING BTREE,
|
INDEX `app_user_id`(`app_user_id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '用户积分变化记录表' ROW_FORMAT = DYNAMIC;
|
|
-- ----------------------------
|
-- Records of t_app_user_integral_change_35
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_app_user_integral_change_36
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_app_user_integral_change_36`;
|
CREATE TABLE `t_app_user_integral_change_36` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '流水号',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`change_type` int NULL DEFAULT NULL COMMENT '变化类型（1=签到得，2=充电得，3=好评得，4=邀请好友得，5=添加车辆得，6=兑换商品减）',
|
`historical_integral` int NULL DEFAULT NULL COMMENT '历史积分',
|
`current_integral` int NULL DEFAULT NULL COMMENT '当前积分',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
|
`extension` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '扩展字段',
|
PRIMARY KEY (`id`) USING BTREE,
|
INDEX `app_user_id`(`app_user_id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '用户积分变化记录表' ROW_FORMAT = DYNAMIC;
|
|
-- ----------------------------
|
-- Records of t_app_user_integral_change_36
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_app_user_integral_change_37
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_app_user_integral_change_37`;
|
CREATE TABLE `t_app_user_integral_change_37` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '流水号',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`change_type` int NULL DEFAULT NULL COMMENT '变化类型（1=签到得，2=充电得，3=好评得，4=邀请好友得，5=添加车辆得，6=兑换商品减）',
|
`historical_integral` int NULL DEFAULT NULL COMMENT '历史积分',
|
`current_integral` int NULL DEFAULT NULL COMMENT '当前积分',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
|
`extension` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '扩展字段',
|
PRIMARY KEY (`id`) USING BTREE,
|
INDEX `app_user_id`(`app_user_id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '用户积分变化记录表' ROW_FORMAT = DYNAMIC;
|
|
-- ----------------------------
|
-- Records of t_app_user_integral_change_37
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_app_user_integral_change_38
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_app_user_integral_change_38`;
|
CREATE TABLE `t_app_user_integral_change_38` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '流水号',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`change_type` int NULL DEFAULT NULL COMMENT '变化类型（1=签到得，2=充电得，3=好评得，4=邀请好友得，5=添加车辆得，6=兑换商品减）',
|
`historical_integral` int NULL DEFAULT NULL COMMENT '历史积分',
|
`current_integral` int NULL DEFAULT NULL COMMENT '当前积分',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
|
`extension` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '扩展字段',
|
PRIMARY KEY (`id`) USING BTREE,
|
INDEX `app_user_id`(`app_user_id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '用户积分变化记录表' ROW_FORMAT = DYNAMIC;
|
|
-- ----------------------------
|
-- Records of t_app_user_integral_change_38
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_app_user_integral_change_39
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_app_user_integral_change_39`;
|
CREATE TABLE `t_app_user_integral_change_39` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '流水号',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`change_type` int NULL DEFAULT NULL COMMENT '变化类型（1=签到得，2=充电得，3=好评得，4=邀请好友得，5=添加车辆得，6=兑换商品减）',
|
`historical_integral` int NULL DEFAULT NULL COMMENT '历史积分',
|
`current_integral` int NULL DEFAULT NULL COMMENT '当前积分',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
|
`extension` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '扩展字段',
|
PRIMARY KEY (`id`) USING BTREE,
|
INDEX `app_user_id`(`app_user_id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '用户积分变化记录表' ROW_FORMAT = DYNAMIC;
|
|
-- ----------------------------
|
-- Records of t_app_user_integral_change_39
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_app_user_integral_change_4
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_app_user_integral_change_4`;
|
CREATE TABLE `t_app_user_integral_change_4` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '流水号',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`change_type` int NULL DEFAULT NULL COMMENT '变化类型（1=签到得，2=充电得，3=好评得，4=邀请好友得，5=添加车辆得，6=兑换商品减）',
|
`historical_integral` int NULL DEFAULT NULL COMMENT '历史积分',
|
`current_integral` int NULL DEFAULT NULL COMMENT '当前积分',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
|
`extension` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '扩展字段',
|
PRIMARY KEY (`id`) USING BTREE,
|
INDEX `app_user_id`(`app_user_id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '用户积分变化记录表' ROW_FORMAT = DYNAMIC;
|
|
-- ----------------------------
|
-- Records of t_app_user_integral_change_4
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_app_user_integral_change_40
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_app_user_integral_change_40`;
|
CREATE TABLE `t_app_user_integral_change_40` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '流水号',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`change_type` int NULL DEFAULT NULL COMMENT '变化类型（1=签到得，2=充电得，3=好评得，4=邀请好友得，5=添加车辆得，6=兑换商品减）',
|
`historical_integral` int NULL DEFAULT NULL COMMENT '历史积分',
|
`current_integral` int NULL DEFAULT NULL COMMENT '当前积分',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
|
`extension` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '扩展字段',
|
PRIMARY KEY (`id`) USING BTREE,
|
INDEX `app_user_id`(`app_user_id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '用户积分变化记录表' ROW_FORMAT = DYNAMIC;
|
|
-- ----------------------------
|
-- Records of t_app_user_integral_change_40
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_app_user_integral_change_41
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_app_user_integral_change_41`;
|
CREATE TABLE `t_app_user_integral_change_41` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '流水号',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`change_type` int NULL DEFAULT NULL COMMENT '变化类型（1=签到得，2=充电得，3=好评得，4=邀请好友得，5=添加车辆得，6=兑换商品减）',
|
`historical_integral` int NULL DEFAULT NULL COMMENT '历史积分',
|
`current_integral` int NULL DEFAULT NULL COMMENT '当前积分',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
|
`extension` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '扩展字段',
|
PRIMARY KEY (`id`) USING BTREE,
|
INDEX `app_user_id`(`app_user_id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '用户积分变化记录表' ROW_FORMAT = DYNAMIC;
|
|
-- ----------------------------
|
-- Records of t_app_user_integral_change_41
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_app_user_integral_change_42
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_app_user_integral_change_42`;
|
CREATE TABLE `t_app_user_integral_change_42` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '流水号',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`change_type` int NULL DEFAULT NULL COMMENT '变化类型（1=签到得，2=充电得，3=好评得，4=邀请好友得，5=添加车辆得，6=兑换商品减）',
|
`historical_integral` int NULL DEFAULT NULL COMMENT '历史积分',
|
`current_integral` int NULL DEFAULT NULL COMMENT '当前积分',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
|
`extension` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '扩展字段',
|
PRIMARY KEY (`id`) USING BTREE,
|
INDEX `app_user_id`(`app_user_id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '用户积分变化记录表' ROW_FORMAT = DYNAMIC;
|
|
-- ----------------------------
|
-- Records of t_app_user_integral_change_42
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_app_user_integral_change_43
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_app_user_integral_change_43`;
|
CREATE TABLE `t_app_user_integral_change_43` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '流水号',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`change_type` int NULL DEFAULT NULL COMMENT '变化类型（1=签到得，2=充电得，3=好评得，4=邀请好友得，5=添加车辆得，6=兑换商品减）',
|
`historical_integral` int NULL DEFAULT NULL COMMENT '历史积分',
|
`current_integral` int NULL DEFAULT NULL COMMENT '当前积分',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
|
`extension` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '扩展字段',
|
PRIMARY KEY (`id`) USING BTREE,
|
INDEX `app_user_id`(`app_user_id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '用户积分变化记录表' ROW_FORMAT = DYNAMIC;
|
|
-- ----------------------------
|
-- Records of t_app_user_integral_change_43
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_app_user_integral_change_44
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_app_user_integral_change_44`;
|
CREATE TABLE `t_app_user_integral_change_44` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '流水号',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`change_type` int NULL DEFAULT NULL COMMENT '变化类型（1=签到得，2=充电得，3=好评得，4=邀请好友得，5=添加车辆得，6=兑换商品减）',
|
`historical_integral` int NULL DEFAULT NULL COMMENT '历史积分',
|
`current_integral` int NULL DEFAULT NULL COMMENT '当前积分',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
|
`extension` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '扩展字段',
|
PRIMARY KEY (`id`) USING BTREE,
|
INDEX `app_user_id`(`app_user_id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '用户积分变化记录表' ROW_FORMAT = DYNAMIC;
|
|
-- ----------------------------
|
-- Records of t_app_user_integral_change_44
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_app_user_integral_change_45
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_app_user_integral_change_45`;
|
CREATE TABLE `t_app_user_integral_change_45` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '流水号',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`change_type` int NULL DEFAULT NULL COMMENT '变化类型（1=签到得，2=充电得，3=好评得，4=邀请好友得，5=添加车辆得，6=兑换商品减）',
|
`historical_integral` int NULL DEFAULT NULL COMMENT '历史积分',
|
`current_integral` int NULL DEFAULT NULL COMMENT '当前积分',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
|
`extension` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '扩展字段',
|
PRIMARY KEY (`id`) USING BTREE,
|
INDEX `app_user_id`(`app_user_id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '用户积分变化记录表' ROW_FORMAT = DYNAMIC;
|
|
-- ----------------------------
|
-- Records of t_app_user_integral_change_45
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_app_user_integral_change_46
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_app_user_integral_change_46`;
|
CREATE TABLE `t_app_user_integral_change_46` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '流水号',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`change_type` int NULL DEFAULT NULL COMMENT '变化类型（1=签到得，2=充电得，3=好评得，4=邀请好友得，5=添加车辆得，6=兑换商品减）',
|
`historical_integral` int NULL DEFAULT NULL COMMENT '历史积分',
|
`current_integral` int NULL DEFAULT NULL COMMENT '当前积分',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
|
`extension` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '扩展字段',
|
PRIMARY KEY (`id`) USING BTREE,
|
INDEX `app_user_id`(`app_user_id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '用户积分变化记录表' ROW_FORMAT = DYNAMIC;
|
|
-- ----------------------------
|
-- Records of t_app_user_integral_change_46
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_app_user_integral_change_47
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_app_user_integral_change_47`;
|
CREATE TABLE `t_app_user_integral_change_47` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '流水号',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`change_type` int NULL DEFAULT NULL COMMENT '变化类型（1=签到得，2=充电得，3=好评得，4=邀请好友得，5=添加车辆得，6=兑换商品减）',
|
`historical_integral` int NULL DEFAULT NULL COMMENT '历史积分',
|
`current_integral` int NULL DEFAULT NULL COMMENT '当前积分',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
|
`extension` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '扩展字段',
|
PRIMARY KEY (`id`) USING BTREE,
|
INDEX `app_user_id`(`app_user_id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '用户积分变化记录表' ROW_FORMAT = DYNAMIC;
|
|
-- ----------------------------
|
-- Records of t_app_user_integral_change_47
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_app_user_integral_change_48
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_app_user_integral_change_48`;
|
CREATE TABLE `t_app_user_integral_change_48` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '流水号',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`change_type` int NULL DEFAULT NULL COMMENT '变化类型（1=签到得，2=充电得，3=好评得，4=邀请好友得，5=添加车辆得，6=兑换商品减）',
|
`historical_integral` int NULL DEFAULT NULL COMMENT '历史积分',
|
`current_integral` int NULL DEFAULT NULL COMMENT '当前积分',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
|
`extension` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '扩展字段',
|
PRIMARY KEY (`id`) USING BTREE,
|
INDEX `app_user_id`(`app_user_id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '用户积分变化记录表' ROW_FORMAT = DYNAMIC;
|
|
-- ----------------------------
|
-- Records of t_app_user_integral_change_48
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_app_user_integral_change_49
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_app_user_integral_change_49`;
|
CREATE TABLE `t_app_user_integral_change_49` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '流水号',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`change_type` int NULL DEFAULT NULL COMMENT '变化类型（1=签到得，2=充电得，3=好评得，4=邀请好友得，5=添加车辆得，6=兑换商品减）',
|
`historical_integral` int NULL DEFAULT NULL COMMENT '历史积分',
|
`current_integral` int NULL DEFAULT NULL COMMENT '当前积分',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
|
`extension` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '扩展字段',
|
PRIMARY KEY (`id`) USING BTREE,
|
INDEX `app_user_id`(`app_user_id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '用户积分变化记录表' ROW_FORMAT = DYNAMIC;
|
|
-- ----------------------------
|
-- Records of t_app_user_integral_change_49
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_app_user_integral_change_5
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_app_user_integral_change_5`;
|
CREATE TABLE `t_app_user_integral_change_5` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '流水号',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`change_type` int NULL DEFAULT NULL COMMENT '变化类型（1=签到得，2=充电得，3=好评得，4=邀请好友得，5=添加车辆得，6=兑换商品减）',
|
`historical_integral` int NULL DEFAULT NULL COMMENT '历史积分',
|
`current_integral` int NULL DEFAULT NULL COMMENT '当前积分',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
|
`extension` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '扩展字段',
|
PRIMARY KEY (`id`) USING BTREE,
|
INDEX `app_user_id`(`app_user_id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '用户积分变化记录表' ROW_FORMAT = DYNAMIC;
|
|
-- ----------------------------
|
-- Records of t_app_user_integral_change_5
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_app_user_integral_change_6
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_app_user_integral_change_6`;
|
CREATE TABLE `t_app_user_integral_change_6` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '流水号',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`change_type` int NULL DEFAULT NULL COMMENT '变化类型（1=签到得，2=充电得，3=好评得，4=邀请好友得，5=添加车辆得，6=兑换商品减）',
|
`historical_integral` int NULL DEFAULT NULL COMMENT '历史积分',
|
`current_integral` int NULL DEFAULT NULL COMMENT '当前积分',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
|
`extension` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '扩展字段',
|
PRIMARY KEY (`id`) USING BTREE,
|
INDEX `app_user_id`(`app_user_id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '用户积分变化记录表' ROW_FORMAT = DYNAMIC;
|
|
-- ----------------------------
|
-- Records of t_app_user_integral_change_6
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_app_user_integral_change_7
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_app_user_integral_change_7`;
|
CREATE TABLE `t_app_user_integral_change_7` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '流水号',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`change_type` int NULL DEFAULT NULL COMMENT '变化类型（1=签到得，2=充电得，3=好评得，4=邀请好友得，5=添加车辆得，6=兑换商品减）',
|
`historical_integral` int NULL DEFAULT NULL COMMENT '历史积分',
|
`current_integral` int NULL DEFAULT NULL COMMENT '当前积分',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
|
`extension` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '扩展字段',
|
PRIMARY KEY (`id`) USING BTREE,
|
INDEX `app_user_id`(`app_user_id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '用户积分变化记录表' ROW_FORMAT = DYNAMIC;
|
|
-- ----------------------------
|
-- Records of t_app_user_integral_change_7
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_app_user_integral_change_8
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_app_user_integral_change_8`;
|
CREATE TABLE `t_app_user_integral_change_8` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '流水号',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`change_type` int NULL DEFAULT NULL COMMENT '变化类型（1=签到得，2=充电得，3=好评得，4=邀请好友得，5=添加车辆得，6=兑换商品减）',
|
`historical_integral` int NULL DEFAULT NULL COMMENT '历史积分',
|
`current_integral` int NULL DEFAULT NULL COMMENT '当前积分',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
|
`extension` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '扩展字段',
|
PRIMARY KEY (`id`) USING BTREE,
|
INDEX `app_user_id`(`app_user_id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '用户积分变化记录表' ROW_FORMAT = DYNAMIC;
|
|
-- ----------------------------
|
-- Records of t_app_user_integral_change_8
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_app_user_integral_change_9
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_app_user_integral_change_9`;
|
CREATE TABLE `t_app_user_integral_change_9` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '流水号',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`change_type` int NULL DEFAULT NULL COMMENT '变化类型（1=签到得，2=充电得，3=好评得，4=邀请好友得，5=添加车辆得，6=兑换商品减）',
|
`historical_integral` int NULL DEFAULT NULL COMMENT '历史积分',
|
`current_integral` int NULL DEFAULT NULL COMMENT '当前积分',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
|
`extension` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '扩展字段',
|
PRIMARY KEY (`id`) USING BTREE,
|
INDEX `app_user_id`(`app_user_id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '用户积分变化记录表' ROW_FORMAT = DYNAMIC;
|
|
-- ----------------------------
|
-- Records of t_app_user_integral_change_9
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_app_user_sign
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_app_user_sign`;
|
CREATE TABLE `t_app_user_sign` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`sign_day` date NULL DEFAULT NULL COMMENT '签到天',
|
`reward_points` int NULL DEFAULT NULL COMMENT '奖励积分',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
|
PRIMARY KEY (`id`) USING BTREE,
|
INDEX `app_user_id`(`app_user_id`) USING BTREE,
|
INDEX `sign_day`(`sign_day`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '用户签到记录' ROW_FORMAT = DYNAMIC;
|
|
-- ----------------------------
|
-- Records of t_app_user_sign
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_app_user_sign_0
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_app_user_sign_0`;
|
CREATE TABLE `t_app_user_sign_0` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`sign_day` date NULL DEFAULT NULL COMMENT '签到天',
|
`reward_points` int NULL DEFAULT NULL COMMENT '奖励积分',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
|
PRIMARY KEY (`id`) USING BTREE,
|
INDEX `app_user_id`(`app_user_id`) USING BTREE,
|
INDEX `sign_day`(`sign_day`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '用户签到记录' ROW_FORMAT = DYNAMIC;
|
|
-- ----------------------------
|
-- Records of t_app_user_sign_0
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_app_user_sign_1
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_app_user_sign_1`;
|
CREATE TABLE `t_app_user_sign_1` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`sign_day` date NULL DEFAULT NULL COMMENT '签到天',
|
`reward_points` int NULL DEFAULT NULL COMMENT '奖励积分',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
|
PRIMARY KEY (`id`) USING BTREE,
|
INDEX `app_user_id`(`app_user_id`) USING BTREE,
|
INDEX `sign_day`(`sign_day`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '用户签到记录' ROW_FORMAT = DYNAMIC;
|
|
-- ----------------------------
|
-- Records of t_app_user_sign_1
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_app_user_sign_2
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_app_user_sign_2`;
|
CREATE TABLE `t_app_user_sign_2` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`sign_day` date NULL DEFAULT NULL COMMENT '签到天',
|
`reward_points` int NULL DEFAULT NULL COMMENT '奖励积分',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
|
PRIMARY KEY (`id`) USING BTREE,
|
INDEX `app_user_id`(`app_user_id`) USING BTREE,
|
INDEX `sign_day`(`sign_day`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '用户签到记录' ROW_FORMAT = DYNAMIC;
|
|
-- ----------------------------
|
-- Records of t_app_user_sign_2
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_app_user_sign_3
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_app_user_sign_3`;
|
CREATE TABLE `t_app_user_sign_3` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`sign_day` date NULL DEFAULT NULL COMMENT '签到天',
|
`reward_points` int NULL DEFAULT NULL COMMENT '奖励积分',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
|
PRIMARY KEY (`id`) USING BTREE,
|
INDEX `app_user_id`(`app_user_id`) USING BTREE,
|
INDEX `sign_day`(`sign_day`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '用户签到记录' ROW_FORMAT = DYNAMIC;
|
|
-- ----------------------------
|
-- Records of t_app_user_sign_3
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_app_user_sign_4
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_app_user_sign_4`;
|
CREATE TABLE `t_app_user_sign_4` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`sign_day` date NULL DEFAULT NULL COMMENT '签到天',
|
`reward_points` int NULL DEFAULT NULL COMMENT '奖励积分',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
|
PRIMARY KEY (`id`) USING BTREE,
|
INDEX `app_user_id`(`app_user_id`) USING BTREE,
|
INDEX `sign_day`(`sign_day`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '用户签到记录' ROW_FORMAT = DYNAMIC;
|
|
-- ----------------------------
|
-- Records of t_app_user_sign_4
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_app_user_sign_5
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_app_user_sign_5`;
|
CREATE TABLE `t_app_user_sign_5` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`sign_day` date NULL DEFAULT NULL COMMENT '签到天',
|
`reward_points` int NULL DEFAULT NULL COMMENT '奖励积分',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
|
PRIMARY KEY (`id`) USING BTREE,
|
INDEX `app_user_id`(`app_user_id`) USING BTREE,
|
INDEX `sign_day`(`sign_day`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '用户签到记录' ROW_FORMAT = DYNAMIC;
|
|
-- ----------------------------
|
-- Records of t_app_user_sign_5
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_app_user_sign_6
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_app_user_sign_6`;
|
CREATE TABLE `t_app_user_sign_6` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`sign_day` date NULL DEFAULT NULL COMMENT '签到天',
|
`reward_points` int NULL DEFAULT NULL COMMENT '奖励积分',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
|
PRIMARY KEY (`id`) USING BTREE,
|
INDEX `app_user_id`(`app_user_id`) USING BTREE,
|
INDEX `sign_day`(`sign_day`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '用户签到记录' ROW_FORMAT = DYNAMIC;
|
|
-- ----------------------------
|
-- Records of t_app_user_sign_6
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_app_user_sign_7
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_app_user_sign_7`;
|
CREATE TABLE `t_app_user_sign_7` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`sign_day` date NULL DEFAULT NULL COMMENT '签到天',
|
`reward_points` int NULL DEFAULT NULL COMMENT '奖励积分',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
|
PRIMARY KEY (`id`) USING BTREE,
|
INDEX `app_user_id`(`app_user_id`) USING BTREE,
|
INDEX `sign_day`(`sign_day`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '用户签到记录' ROW_FORMAT = DYNAMIC;
|
|
-- ----------------------------
|
-- Records of t_app_user_sign_7
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_app_user_sign_8
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_app_user_sign_8`;
|
CREATE TABLE `t_app_user_sign_8` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`sign_day` date NULL DEFAULT NULL COMMENT '签到天',
|
`reward_points` int NULL DEFAULT NULL COMMENT '奖励积分',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
|
PRIMARY KEY (`id`) USING BTREE,
|
INDEX `app_user_id`(`app_user_id`) USING BTREE,
|
INDEX `sign_day`(`sign_day`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '用户签到记录' ROW_FORMAT = DYNAMIC;
|
|
-- ----------------------------
|
-- Records of t_app_user_sign_8
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_app_user_sign_9
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_app_user_sign_9`;
|
CREATE TABLE `t_app_user_sign_9` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`sign_day` date NULL DEFAULT NULL COMMENT '签到天',
|
`reward_points` int NULL DEFAULT NULL COMMENT '奖励积分',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
|
PRIMARY KEY (`id`) USING BTREE,
|
INDEX `app_user_id`(`app_user_id`) USING BTREE,
|
INDEX `sign_day`(`sign_day`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '用户签到记录' ROW_FORMAT = DYNAMIC;
|
|
-- ----------------------------
|
-- Records of t_app_user_sign_9
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_app_user_tag
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_app_user_tag`;
|
CREATE TABLE `t_app_user_tag` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT 'app用户id',
|
`user_tag_id` int NULL DEFAULT NULL COMMENT '用户标签id',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
|
PRIMARY KEY (`id`) USING BTREE,
|
INDEX `app_user_id`(`app_user_id`) USING BTREE,
|
INDEX `user_tag_id`(`user_tag_id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '用户标签关系表' ROW_FORMAT = DYNAMIC;
|
|
-- ----------------------------
|
-- Records of t_app_user_tag
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_app_user_tag_0
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_app_user_tag_0`;
|
CREATE TABLE `t_app_user_tag_0` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT 'app用户id',
|
`user_tag_id` int NULL DEFAULT NULL COMMENT '用户标签id',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
|
PRIMARY KEY (`id`) USING BTREE,
|
INDEX `app_user_id`(`app_user_id`) USING BTREE,
|
INDEX `user_tag_id`(`user_tag_id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '用户标签关系表' ROW_FORMAT = DYNAMIC;
|
|
-- ----------------------------
|
-- Records of t_app_user_tag_0
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_app_user_tag_1
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_app_user_tag_1`;
|
CREATE TABLE `t_app_user_tag_1` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT 'app用户id',
|
`user_tag_id` int NULL DEFAULT NULL COMMENT '用户标签id',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
|
PRIMARY KEY (`id`) USING BTREE,
|
INDEX `app_user_id`(`app_user_id`) USING BTREE,
|
INDEX `user_tag_id`(`user_tag_id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '用户标签关系表' ROW_FORMAT = DYNAMIC;
|
|
-- ----------------------------
|
-- Records of t_app_user_tag_1
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_app_user_tag_10
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_app_user_tag_10`;
|
CREATE TABLE `t_app_user_tag_10` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT 'app用户id',
|
`user_tag_id` int NULL DEFAULT NULL COMMENT '用户标签id',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
|
PRIMARY KEY (`id`) USING BTREE,
|
INDEX `app_user_id`(`app_user_id`) USING BTREE,
|
INDEX `user_tag_id`(`user_tag_id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '用户标签关系表' ROW_FORMAT = DYNAMIC;
|
|
-- ----------------------------
|
-- Records of t_app_user_tag_10
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_app_user_tag_11
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_app_user_tag_11`;
|
CREATE TABLE `t_app_user_tag_11` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT 'app用户id',
|
`user_tag_id` int NULL DEFAULT NULL COMMENT '用户标签id',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
|
PRIMARY KEY (`id`) USING BTREE,
|
INDEX `app_user_id`(`app_user_id`) USING BTREE,
|
INDEX `user_tag_id`(`user_tag_id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '用户标签关系表' ROW_FORMAT = DYNAMIC;
|
|
-- ----------------------------
|
-- Records of t_app_user_tag_11
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_app_user_tag_12
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_app_user_tag_12`;
|
CREATE TABLE `t_app_user_tag_12` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT 'app用户id',
|
`user_tag_id` int NULL DEFAULT NULL COMMENT '用户标签id',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
|
PRIMARY KEY (`id`) USING BTREE,
|
INDEX `app_user_id`(`app_user_id`) USING BTREE,
|
INDEX `user_tag_id`(`user_tag_id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '用户标签关系表' ROW_FORMAT = DYNAMIC;
|
|
-- ----------------------------
|
-- Records of t_app_user_tag_12
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_app_user_tag_13
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_app_user_tag_13`;
|
CREATE TABLE `t_app_user_tag_13` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT 'app用户id',
|
`user_tag_id` int NULL DEFAULT NULL COMMENT '用户标签id',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
|
PRIMARY KEY (`id`) USING BTREE,
|
INDEX `app_user_id`(`app_user_id`) USING BTREE,
|
INDEX `user_tag_id`(`user_tag_id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '用户标签关系表' ROW_FORMAT = DYNAMIC;
|
|
-- ----------------------------
|
-- Records of t_app_user_tag_13
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_app_user_tag_14
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_app_user_tag_14`;
|
CREATE TABLE `t_app_user_tag_14` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT 'app用户id',
|
`user_tag_id` int NULL DEFAULT NULL COMMENT '用户标签id',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
|
PRIMARY KEY (`id`) USING BTREE,
|
INDEX `app_user_id`(`app_user_id`) USING BTREE,
|
INDEX `user_tag_id`(`user_tag_id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '用户标签关系表' ROW_FORMAT = DYNAMIC;
|
|
-- ----------------------------
|
-- Records of t_app_user_tag_14
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_app_user_tag_15
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_app_user_tag_15`;
|
CREATE TABLE `t_app_user_tag_15` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT 'app用户id',
|
`user_tag_id` int NULL DEFAULT NULL COMMENT '用户标签id',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
|
PRIMARY KEY (`id`) USING BTREE,
|
INDEX `app_user_id`(`app_user_id`) USING BTREE,
|
INDEX `user_tag_id`(`user_tag_id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '用户标签关系表' ROW_FORMAT = DYNAMIC;
|
|
-- ----------------------------
|
-- Records of t_app_user_tag_15
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_app_user_tag_16
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_app_user_tag_16`;
|
CREATE TABLE `t_app_user_tag_16` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT 'app用户id',
|
`user_tag_id` int NULL DEFAULT NULL COMMENT '用户标签id',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
|
PRIMARY KEY (`id`) USING BTREE,
|
INDEX `app_user_id`(`app_user_id`) USING BTREE,
|
INDEX `user_tag_id`(`user_tag_id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '用户标签关系表' ROW_FORMAT = DYNAMIC;
|
|
-- ----------------------------
|
-- Records of t_app_user_tag_16
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_app_user_tag_17
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_app_user_tag_17`;
|
CREATE TABLE `t_app_user_tag_17` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT 'app用户id',
|
`user_tag_id` int NULL DEFAULT NULL COMMENT '用户标签id',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
|
PRIMARY KEY (`id`) USING BTREE,
|
INDEX `app_user_id`(`app_user_id`) USING BTREE,
|
INDEX `user_tag_id`(`user_tag_id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '用户标签关系表' ROW_FORMAT = DYNAMIC;
|
|
-- ----------------------------
|
-- Records of t_app_user_tag_17
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_app_user_tag_18
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_app_user_tag_18`;
|
CREATE TABLE `t_app_user_tag_18` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT 'app用户id',
|
`user_tag_id` int NULL DEFAULT NULL COMMENT '用户标签id',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
|
PRIMARY KEY (`id`) USING BTREE,
|
INDEX `app_user_id`(`app_user_id`) USING BTREE,
|
INDEX `user_tag_id`(`user_tag_id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '用户标签关系表' ROW_FORMAT = DYNAMIC;
|
|
-- ----------------------------
|
-- Records of t_app_user_tag_18
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_app_user_tag_19
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_app_user_tag_19`;
|
CREATE TABLE `t_app_user_tag_19` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT 'app用户id',
|
`user_tag_id` int NULL DEFAULT NULL COMMENT '用户标签id',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
|
PRIMARY KEY (`id`) USING BTREE,
|
INDEX `app_user_id`(`app_user_id`) USING BTREE,
|
INDEX `user_tag_id`(`user_tag_id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '用户标签关系表' ROW_FORMAT = DYNAMIC;
|
|
-- ----------------------------
|
-- Records of t_app_user_tag_19
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_app_user_tag_2
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_app_user_tag_2`;
|
CREATE TABLE `t_app_user_tag_2` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT 'app用户id',
|
`user_tag_id` int NULL DEFAULT NULL COMMENT '用户标签id',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
|
PRIMARY KEY (`id`) USING BTREE,
|
INDEX `app_user_id`(`app_user_id`) USING BTREE,
|
INDEX `user_tag_id`(`user_tag_id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '用户标签关系表' ROW_FORMAT = DYNAMIC;
|
|
-- ----------------------------
|
-- Records of t_app_user_tag_2
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_app_user_tag_3
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_app_user_tag_3`;
|
CREATE TABLE `t_app_user_tag_3` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT 'app用户id',
|
`user_tag_id` int NULL DEFAULT NULL COMMENT '用户标签id',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
|
PRIMARY KEY (`id`) USING BTREE,
|
INDEX `app_user_id`(`app_user_id`) USING BTREE,
|
INDEX `user_tag_id`(`user_tag_id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '用户标签关系表' ROW_FORMAT = DYNAMIC;
|
|
-- ----------------------------
|
-- Records of t_app_user_tag_3
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_app_user_tag_4
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_app_user_tag_4`;
|
CREATE TABLE `t_app_user_tag_4` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT 'app用户id',
|
`user_tag_id` int NULL DEFAULT NULL COMMENT '用户标签id',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
|
PRIMARY KEY (`id`) USING BTREE,
|
INDEX `app_user_id`(`app_user_id`) USING BTREE,
|
INDEX `user_tag_id`(`user_tag_id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '用户标签关系表' ROW_FORMAT = DYNAMIC;
|
|
-- ----------------------------
|
-- Records of t_app_user_tag_4
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_app_user_tag_5
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_app_user_tag_5`;
|
CREATE TABLE `t_app_user_tag_5` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT 'app用户id',
|
`user_tag_id` int NULL DEFAULT NULL COMMENT '用户标签id',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
|
PRIMARY KEY (`id`) USING BTREE,
|
INDEX `app_user_id`(`app_user_id`) USING BTREE,
|
INDEX `user_tag_id`(`user_tag_id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '用户标签关系表' ROW_FORMAT = DYNAMIC;
|
|
-- ----------------------------
|
-- Records of t_app_user_tag_5
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_app_user_tag_6
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_app_user_tag_6`;
|
CREATE TABLE `t_app_user_tag_6` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT 'app用户id',
|
`user_tag_id` int NULL DEFAULT NULL COMMENT '用户标签id',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
|
PRIMARY KEY (`id`) USING BTREE,
|
INDEX `app_user_id`(`app_user_id`) USING BTREE,
|
INDEX `user_tag_id`(`user_tag_id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '用户标签关系表' ROW_FORMAT = DYNAMIC;
|
|
-- ----------------------------
|
-- Records of t_app_user_tag_6
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_app_user_tag_7
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_app_user_tag_7`;
|
CREATE TABLE `t_app_user_tag_7` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT 'app用户id',
|
`user_tag_id` int NULL DEFAULT NULL COMMENT '用户标签id',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
|
PRIMARY KEY (`id`) USING BTREE,
|
INDEX `app_user_id`(`app_user_id`) USING BTREE,
|
INDEX `user_tag_id`(`user_tag_id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '用户标签关系表' ROW_FORMAT = DYNAMIC;
|
|
-- ----------------------------
|
-- Records of t_app_user_tag_7
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_app_user_tag_8
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_app_user_tag_8`;
|
CREATE TABLE `t_app_user_tag_8` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT 'app用户id',
|
`user_tag_id` int NULL DEFAULT NULL COMMENT '用户标签id',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
|
PRIMARY KEY (`id`) USING BTREE,
|
INDEX `app_user_id`(`app_user_id`) USING BTREE,
|
INDEX `user_tag_id`(`user_tag_id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '用户标签关系表' ROW_FORMAT = DYNAMIC;
|
|
-- ----------------------------
|
-- Records of t_app_user_tag_8
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_app_user_tag_9
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_app_user_tag_9`;
|
CREATE TABLE `t_app_user_tag_9` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT 'app用户id',
|
`user_tag_id` int NULL DEFAULT NULL COMMENT '用户标签id',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
|
PRIMARY KEY (`id`) USING BTREE,
|
INDEX `app_user_id`(`app_user_id`) USING BTREE,
|
INDEX `user_tag_id`(`user_tag_id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '用户标签关系表' ROW_FORMAT = DYNAMIC;
|
|
-- ----------------------------
|
-- Records of t_app_user_tag_9
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_invite_user
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_invite_user`;
|
CREATE TABLE `t_invite_user` (
|
`id` int NOT NULL AUTO_INCREMENT COMMENT '主键',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`be_invited_app_user_id` bigint NULL DEFAULT NULL COMMENT '被邀请用户id',
|
`award` int NULL DEFAULT NULL COMMENT '奖励积分',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
|
PRIMARY KEY (`id`) USING BTREE,
|
INDEX `app_user_id`(`app_user_id`) USING BTREE,
|
INDEX `be_invited_app_user_id`(`be_invited_app_user_id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '邀请用户' ROW_FORMAT = DYNAMIC;
|
|
-- ----------------------------
|
-- Records of t_invite_user
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_invite_user_0
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_invite_user_0`;
|
CREATE TABLE `t_invite_user_0` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`be_invited_app_user_id` bigint NULL DEFAULT NULL COMMENT '被邀请用户id',
|
`award` int NULL DEFAULT NULL COMMENT '奖励积分',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
|
PRIMARY KEY (`id`) USING BTREE,
|
INDEX `app_user_id`(`app_user_id`) USING BTREE,
|
INDEX `be_invited_app_user_id`(`be_invited_app_user_id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '邀请用户' ROW_FORMAT = DYNAMIC;
|
|
-- ----------------------------
|
-- Records of t_invite_user_0
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_invite_user_1
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_invite_user_1`;
|
CREATE TABLE `t_invite_user_1` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`be_invited_app_user_id` bigint NULL DEFAULT NULL COMMENT '被邀请用户id',
|
`award` int NULL DEFAULT NULL COMMENT '奖励积分',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
|
PRIMARY KEY (`id`) USING BTREE,
|
INDEX `app_user_id`(`app_user_id`) USING BTREE,
|
INDEX `be_invited_app_user_id`(`be_invited_app_user_id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '邀请用户' ROW_FORMAT = DYNAMIC;
|
|
-- ----------------------------
|
-- Records of t_invite_user_1
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_invite_user_2
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_invite_user_2`;
|
CREATE TABLE `t_invite_user_2` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`be_invited_app_user_id` bigint NULL DEFAULT NULL COMMENT '被邀请用户id',
|
`award` int NULL DEFAULT NULL COMMENT '奖励积分',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
|
PRIMARY KEY (`id`) USING BTREE,
|
INDEX `app_user_id`(`app_user_id`) USING BTREE,
|
INDEX `be_invited_app_user_id`(`be_invited_app_user_id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '邀请用户' ROW_FORMAT = DYNAMIC;
|
|
-- ----------------------------
|
-- Records of t_invite_user_2
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_invite_user_3
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_invite_user_3`;
|
CREATE TABLE `t_invite_user_3` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`be_invited_app_user_id` bigint NULL DEFAULT NULL COMMENT '被邀请用户id',
|
`award` int NULL DEFAULT NULL COMMENT '奖励积分',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
|
PRIMARY KEY (`id`) USING BTREE,
|
INDEX `app_user_id`(`app_user_id`) USING BTREE,
|
INDEX `be_invited_app_user_id`(`be_invited_app_user_id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '邀请用户' ROW_FORMAT = DYNAMIC;
|
|
-- ----------------------------
|
-- Records of t_invite_user_3
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_invite_user_4
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_invite_user_4`;
|
CREATE TABLE `t_invite_user_4` (
|
`id` bigint NOT NULL COMMENT '主键',
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`be_invited_app_user_id` bigint NULL DEFAULT NULL COMMENT '被邀请用户id',
|
`award` int NULL DEFAULT NULL COMMENT '奖励积分',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
|
PRIMARY KEY (`id`) USING BTREE,
|
INDEX `app_user_id`(`app_user_id`) USING BTREE,
|
INDEX `be_invited_app_user_id`(`be_invited_app_user_id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '邀请用户' ROW_FORMAT = DYNAMIC;
|
|
-- ----------------------------
|
-- Records of t_invite_user_4
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_invoice_information
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_invoice_information`;
|
CREATE TABLE `t_invoice_information` (
|
`id` bigint NOT NULL,
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`invoice_type` int NULL DEFAULT NULL COMMENT '发票类型（1=增值税普通发票，2=增值税专用发票）',
|
`invoicing_object_type` int NULL DEFAULT NULL COMMENT '抬头类型（1=个人，2=企业）',
|
`name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '名称',
|
`tax_identification_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '纳税识别号',
|
`company_address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '公司地址',
|
`company_phone` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '公司电话',
|
`deposit_bank` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '开户银行',
|
`bank_account` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '银行账户',
|
`default` int NULL DEFAULT NULL COMMENT '设置默认（0=否，1=是）',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
|
`del_flag` int NULL DEFAULT NULL COMMENT '删除（0=否，1=是）',
|
PRIMARY KEY (`id`) USING BTREE,
|
INDEX `app_user_id`(`app_user_id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '发票抬头信息' ROW_FORMAT = DYNAMIC;
|
|
-- ----------------------------
|
-- Records of t_invoice_information
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_invoice_information_0
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_invoice_information_0`;
|
CREATE TABLE `t_invoice_information_0` (
|
`id` bigint NOT NULL,
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`invoice_type` int NULL DEFAULT NULL COMMENT '发票类型（1=增值税普通发票，2=增值税专用发票）',
|
`invoicing_object_type` int NULL DEFAULT NULL COMMENT '抬头类型（1=个人，2=企业）',
|
`name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '名称',
|
`tax_identification_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '纳税识别号',
|
`company_address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '公司地址',
|
`company_phone` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '公司电话',
|
`deposit_bank` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '开户银行',
|
`bank_account` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '银行账户',
|
`default` int NULL DEFAULT NULL COMMENT '设置默认（0=否，1=是）',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
|
`del_flag` int NULL DEFAULT NULL COMMENT '删除（0=否，1=是）',
|
PRIMARY KEY (`id`) USING BTREE,
|
INDEX `app_user_id`(`app_user_id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '发票抬头信息' ROW_FORMAT = DYNAMIC;
|
|
-- ----------------------------
|
-- Records of t_invoice_information_0
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_invoice_information_1
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_invoice_information_1`;
|
CREATE TABLE `t_invoice_information_1` (
|
`id` bigint NOT NULL,
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`invoice_type` int NULL DEFAULT NULL COMMENT '发票类型（1=增值税普通发票，2=增值税专用发票）',
|
`invoicing_object_type` int NULL DEFAULT NULL COMMENT '抬头类型（1=个人，2=企业）',
|
`name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '名称',
|
`tax_identification_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '纳税识别号',
|
`company_address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '公司地址',
|
`company_phone` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '公司电话',
|
`deposit_bank` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '开户银行',
|
`bank_account` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '银行账户',
|
`default` int NULL DEFAULT NULL COMMENT '设置默认（0=否，1=是）',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
|
`del_flag` int NULL DEFAULT NULL COMMENT '删除（0=否，1=是）',
|
PRIMARY KEY (`id`) USING BTREE,
|
INDEX `app_user_id`(`app_user_id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '发票抬头信息' ROW_FORMAT = DYNAMIC;
|
|
-- ----------------------------
|
-- Records of t_invoice_information_1
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_invoice_information_2
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_invoice_information_2`;
|
CREATE TABLE `t_invoice_information_2` (
|
`id` bigint NOT NULL,
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`invoice_type` int NULL DEFAULT NULL COMMENT '发票类型（1=增值税普通发票，2=增值税专用发票）',
|
`invoicing_object_type` int NULL DEFAULT NULL COMMENT '抬头类型（1=个人，2=企业）',
|
`name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '名称',
|
`tax_identification_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '纳税识别号',
|
`company_address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '公司地址',
|
`company_phone` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '公司电话',
|
`deposit_bank` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '开户银行',
|
`bank_account` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '银行账户',
|
`default` int NULL DEFAULT NULL COMMENT '设置默认（0=否，1=是）',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
|
`del_flag` int NULL DEFAULT NULL COMMENT '删除（0=否，1=是）',
|
PRIMARY KEY (`id`) USING BTREE,
|
INDEX `app_user_id`(`app_user_id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '发票抬头信息' ROW_FORMAT = DYNAMIC;
|
|
-- ----------------------------
|
-- Records of t_invoice_information_2
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_invoice_information_3
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_invoice_information_3`;
|
CREATE TABLE `t_invoice_information_3` (
|
`id` bigint NOT NULL,
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`invoice_type` int NULL DEFAULT NULL COMMENT '发票类型（1=增值税普通发票，2=增值税专用发票）',
|
`invoicing_object_type` int NULL DEFAULT NULL COMMENT '抬头类型（1=个人，2=企业）',
|
`name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '名称',
|
`tax_identification_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '纳税识别号',
|
`company_address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '公司地址',
|
`company_phone` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '公司电话',
|
`deposit_bank` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '开户银行',
|
`bank_account` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '银行账户',
|
`default` int NULL DEFAULT NULL COMMENT '设置默认（0=否，1=是）',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
|
`del_flag` int NULL DEFAULT NULL COMMENT '删除（0=否，1=是）',
|
PRIMARY KEY (`id`) USING BTREE,
|
INDEX `app_user_id`(`app_user_id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '发票抬头信息' ROW_FORMAT = DYNAMIC;
|
|
-- ----------------------------
|
-- Records of t_invoice_information_3
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_invoice_information_4
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_invoice_information_4`;
|
CREATE TABLE `t_invoice_information_4` (
|
`id` bigint NOT NULL,
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`invoice_type` int NULL DEFAULT NULL COMMENT '发票类型（1=增值税普通发票，2=增值税专用发票）',
|
`invoicing_object_type` int NULL DEFAULT NULL COMMENT '抬头类型（1=个人，2=企业）',
|
`name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '名称',
|
`tax_identification_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '纳税识别号',
|
`company_address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '公司地址',
|
`company_phone` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '公司电话',
|
`deposit_bank` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '开户银行',
|
`bank_account` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '银行账户',
|
`default` int NULL DEFAULT NULL COMMENT '设置默认（0=否，1=是）',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
|
`del_flag` int NULL DEFAULT NULL COMMENT '删除（0=否，1=是）',
|
PRIMARY KEY (`id`) USING BTREE,
|
INDEX `app_user_id`(`app_user_id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '发票抬头信息' ROW_FORMAT = DYNAMIC;
|
|
-- ----------------------------
|
-- Records of t_invoice_information_4
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_invoice_information_5
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_invoice_information_5`;
|
CREATE TABLE `t_invoice_information_5` (
|
`id` bigint NOT NULL,
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`invoice_type` int NULL DEFAULT NULL COMMENT '发票类型（1=增值税普通发票，2=增值税专用发票）',
|
`invoicing_object_type` int NULL DEFAULT NULL COMMENT '抬头类型（1=个人，2=企业）',
|
`name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '名称',
|
`tax_identification_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '纳税识别号',
|
`company_address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '公司地址',
|
`company_phone` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '公司电话',
|
`deposit_bank` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '开户银行',
|
`bank_account` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '银行账户',
|
`default` int NULL DEFAULT NULL COMMENT '设置默认（0=否，1=是）',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
|
`del_flag` int NULL DEFAULT NULL COMMENT '删除（0=否，1=是）',
|
PRIMARY KEY (`id`) USING BTREE,
|
INDEX `app_user_id`(`app_user_id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '发票抬头信息' ROW_FORMAT = DYNAMIC;
|
|
-- ----------------------------
|
-- Records of t_invoice_information_5
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_invoice_information_6
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_invoice_information_6`;
|
CREATE TABLE `t_invoice_information_6` (
|
`id` bigint NOT NULL,
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`invoice_type` int NULL DEFAULT NULL COMMENT '发票类型（1=增值税普通发票，2=增值税专用发票）',
|
`invoicing_object_type` int NULL DEFAULT NULL COMMENT '抬头类型（1=个人，2=企业）',
|
`name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '名称',
|
`tax_identification_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '纳税识别号',
|
`company_address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '公司地址',
|
`company_phone` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '公司电话',
|
`deposit_bank` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '开户银行',
|
`bank_account` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '银行账户',
|
`default` int NULL DEFAULT NULL COMMENT '设置默认（0=否，1=是）',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
|
`del_flag` int NULL DEFAULT NULL COMMENT '删除（0=否，1=是）',
|
PRIMARY KEY (`id`) USING BTREE,
|
INDEX `app_user_id`(`app_user_id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '发票抬头信息' ROW_FORMAT = DYNAMIC;
|
|
-- ----------------------------
|
-- Records of t_invoice_information_6
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_invoice_information_7
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_invoice_information_7`;
|
CREATE TABLE `t_invoice_information_7` (
|
`id` bigint NOT NULL,
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`invoice_type` int NULL DEFAULT NULL COMMENT '发票类型（1=增值税普通发票，2=增值税专用发票）',
|
`invoicing_object_type` int NULL DEFAULT NULL COMMENT '抬头类型（1=个人，2=企业）',
|
`name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '名称',
|
`tax_identification_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '纳税识别号',
|
`company_address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '公司地址',
|
`company_phone` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '公司电话',
|
`deposit_bank` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '开户银行',
|
`bank_account` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '银行账户',
|
`default` int NULL DEFAULT NULL COMMENT '设置默认（0=否，1=是）',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
|
`del_flag` int NULL DEFAULT NULL COMMENT '删除（0=否，1=是）',
|
PRIMARY KEY (`id`) USING BTREE,
|
INDEX `app_user_id`(`app_user_id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '发票抬头信息' ROW_FORMAT = DYNAMIC;
|
|
-- ----------------------------
|
-- Records of t_invoice_information_7
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_invoice_information_8
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_invoice_information_8`;
|
CREATE TABLE `t_invoice_information_8` (
|
`id` bigint NOT NULL,
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`invoice_type` int NULL DEFAULT NULL COMMENT '发票类型（1=增值税普通发票，2=增值税专用发票）',
|
`invoicing_object_type` int NULL DEFAULT NULL COMMENT '抬头类型（1=个人，2=企业）',
|
`name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '名称',
|
`tax_identification_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '纳税识别号',
|
`company_address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '公司地址',
|
`company_phone` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '公司电话',
|
`deposit_bank` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '开户银行',
|
`bank_account` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '银行账户',
|
`default` int NULL DEFAULT NULL COMMENT '设置默认（0=否，1=是）',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
|
`del_flag` int NULL DEFAULT NULL COMMENT '删除（0=否，1=是）',
|
PRIMARY KEY (`id`) USING BTREE,
|
INDEX `app_user_id`(`app_user_id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '发票抬头信息' ROW_FORMAT = DYNAMIC;
|
|
-- ----------------------------
|
-- Records of t_invoice_information_8
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for t_invoice_information_9
|
-- ----------------------------
|
DROP TABLE IF EXISTS `t_invoice_information_9`;
|
CREATE TABLE `t_invoice_information_9` (
|
`id` bigint NOT NULL,
|
`app_user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
|
`invoice_type` int NULL DEFAULT NULL COMMENT '发票类型（1=增值税普通发票，2=增值税专用发票）',
|
`invoicing_object_type` int NULL DEFAULT NULL COMMENT '抬头类型（1=个人，2=企业）',
|
`name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '名称',
|
`tax_identification_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '纳税识别号',
|
`company_address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '公司地址',
|
`company_phone` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '公司电话',
|
`deposit_bank` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '开户银行',
|
`bank_account` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '银行账户',
|
`default` int NULL DEFAULT NULL COMMENT '设置默认（0=否，1=是）',
|
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '添加时间',
|
`del_flag` int NULL DEFAULT NULL COMMENT '删除（0=否，1=是）',
|
PRIMARY KEY (`id`) USING BTREE,
|
INDEX `app_user_id`(`app_user_id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '发票抬头信息' ROW_FORMAT = DYNAMIC;
|
|
-- ----------------------------
|
-- Records of t_invoice_information_9
|
-- ----------------------------
|
|
SET FOREIGN_KEY_CHECKS = 1;
|
