/* 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;