zianxin/Friendship-and-chat-api
1
0 Fork 0
Code Issues Pull Requests Actions Packages Projects Releases Wiki Activity
Files
main
Friendship-and-chat-api/sql/mysql/recent/member_recent.sql
T
dzc f55561c98d feat:上传到阿里云oss 
feat:把以前的图片迁移到阿里云oss
2026-11-05 15:22:55 +08:00

335 lines
23 KiB
SQL
Raw Permalink Blame History

-- ----------------------------
-- Table structure for member_recent
-- ----------------------------
DROP TABLE IF EXISTS `member_recent`;
CREATE TABLE `member_recent`
(
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '收件地址编号',
`member_id` bigint NOT NULL COMMENT '用户编号',
`cover_pic` varchar(2048) DEFAULT NULL COMMENT '主图',
`cover_video` varchar(2048) DEFAULT NULL COMMENT '视频',
`description` varchar(1000) NOT NULL COMMENT '描述',
`issue_long` decimal(10, 8) NOT NULL COMMENT '发布-经度',
`issue_lat` decimal(10, 8) NOT NULL COMMENT '发布-纬度',
`issue_province` varchar(64) DEFAULT NULL COMMENT '发布-省',
`issue_city` varchar(64) DEFAULT NULL COMMENT '发布-市',
`issue_district` varchar(64) DEFAULT NULL COMMENT '发布-区',
`issue_address` varchar(256) DEFAULT NULL COMMENT '发布-详细地址',
`visible` tinyint(1) NOT NULL DEFAULT 1 COMMENT '是否展示：0-隐藏，1-显示',
`audit_status` tinyint NOT NULL DEFAULT 0 COMMENT '审核状态：0-审核中，1-审核通过，2-审核不通过',
`audit_source` varchar(16) DEFAULT NULL COMMENT '审核来源：THIRD_PARTY-第三方，MANUAL-人工，HISTORY-历史数据',
`audit_reason` varchar(512) DEFAULT NULL COMMENT '审核原因',
`audit_time` datetime DEFAULT NULL COMMENT '审核时间',
`audit_user_id` bigint DEFAULT NULL COMMENT '人工审核用户编号',
`creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '创建者',
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '更新者',
`update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
`deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否删除',
`tenant_id` bigint NOT NULL DEFAULT 0 COMMENT '租户编号',
PRIMARY KEY (`id`) USING BTREE,
KEY `idx_member_recent_audit_status_create_time` (`audit_status`, `create_time`),
KEY `idx_member_recent_visible_audit_create_time` (`visible`, `audit_status`, `create_time`)
) ENGINE = InnoDB AUTO_INCREMENT = 32 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '朋友圈';
-- ----------------------------
-- Table structure for member_operation
-- ----------------------------
DROP TABLE IF EXISTS `member_operation`;
CREATE TABLE `member_operation`
(
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '收件地址编号',
`member_id` bigint NOT NULL COMMENT '用户编号',
`member_recent_id` bigint DEFAULT NULL COMMENT '朋友圈编号',
`biz_type` varchar(32) NOT NULL COMMENT '点赞、屏蔽、举报',
`tap_time` datetime NOT NULL COMMENT '点击时间',
`cancel_time` datetime DEFAULT NULL COMMENT '取消时间',
`report_type` varchar(32) DEFAULT NULL COMMENT '举报类型',
`score_sc` int DEFAULT NULL COMMENT '身材评分',
`score_nx` int DEFAULT NULL COMMENT '耐心评分',
`score_sk` int DEFAULT NULL COMMENT '爽快评分',
`score_yq` int DEFAULT NULL COMMENT '有趣评分',
`creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '创建者',
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '更新者',
`update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
`deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否删除',
`tenant_id` bigint NOT NULL DEFAULT 0 COMMENT '租户编号',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 32 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '朋友圈操作';
-- ----------------------------
-- Table structure for member_view_record
-- ----------------------------
DROP TABLE IF EXISTS `member_view_record`;
CREATE TABLE `member_view_record`
(
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '收件地址编号',
`member_id` bigint NOT NULL COMMENT '用户编号',
`biz_type` varchar(32) NOT NULL COMMENT '查询分类、查看朋友圈',
`biz_id` bigint DEFAULT NULL COMMENT '查询分类、查看朋友圈',
`title` varchar(32) DEFAULT NULL COMMENT '查看的标题',
`view_start_time` datetime DEFAULT NULL COMMENT '开始查看时间',
`view_end_time` datetime DEFAULT NULL COMMENT '结束查看时间',
`view_second` int DEFAULT NULL COMMENT '查看时间(秒)',
`creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '创建者',
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '更新者',
`update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
`deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否删除',
`tenant_id` bigint NOT NULL DEFAULT 0 COMMENT '租户编号',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 32 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '用户查看记录表';
-- ----------------------------
-- Table structure for member_com_auth
-- ----------------------------
DROP TABLE IF EXISTS `member_com_auth`;
CREATE TABLE `member_com_auth`
(
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '认证编号',
`biz_type` varchar(32) NOT NULL COMMENT '认证类型',
`biz_id` bigint NOT NULL COMMENT '认证类型编号',
`auth_pic` bigint NOT NULL COMMENT '认证图片或视频',
`auth_extra_json` varchar(1024) NOT NULL COMMENT '认证额外信息(json)',
`auth_time` datetime NOT NULL COMMENT '认证时间',
`auth_member_id` bigint NOT NULL COMMENT '认证人编号(-1为系统认证)',
`auth_status` varchar(32) NOT NULL COMMENT '认证状态',
`creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '创建者',
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '更新者',
`update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
`deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否删除',
`tenant_id` bigint NOT NULL DEFAULT 0 COMMENT '租户编号',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 32 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '用户通用认证';
-- ----------------------------
-- Table structure for member_photo
-- ----------------------------
DROP TABLE IF EXISTS `member_photo`;
CREATE TABLE `member_photo`
(
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '用户相册id',
`biz_type` varchar(32) NOT NULL COMMENT '上传途径',
`address` bigint NOT NULL COMMENT '资源地址',
`tag_json` varchar(512) DEFAULT NULL COMMENT 'tag_json',
`issue_long` double precision DEFAULT NULL COMMENT '发布-经度',
`issue_lat` double precision DEFAULT NULL COMMENT '发布-纬度',
`issue_province` varchar(64) DEFAULT NULL COMMENT '发布-省',
`issue_city` varchar(64) DEFAULT NULL COMMENT '发布-市',
`issue_district` varchar(64) DEFAULT NULL COMMENT '发布-区',
`issue_address` varchar(256) DEFAULT NULL COMMENT '发布-详细地址',
`creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '创建者',
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '更新者',
`update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
`deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否删除',
`tenant_id` bigint NOT NULL DEFAULT 0 COMMENT '租户编号',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 32 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '用户相册';
-- ----------------------------
-- Table structure for member_location
-- ----------------------------
DROP TABLE IF EXISTS `member_location`;
CREATE TABLE `member_location`
(
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '用户位置id',
`member_id` bigint NOT NULL COMMENT '人员id',
`long` double precision DEFAULT NULL COMMENT '经度',
`lat` double precision DEFAULT NULL COMMENT '纬度',
`province` varchar(64) DEFAULT NULL COMMENT '省',
`city` varchar(64) DEFAULT NULL COMMENT '市',
`district` varchar(64) DEFAULT NULL COMMENT '区',
`address` varchar(256) DEFAULT NULL COMMENT '详细地址',
`creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '创建者',
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '更新者',
`update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
`deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否删除',
`tenant_id` bigint NOT NULL DEFAULT 0 COMMENT '租户编号',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 32 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '用户位置记录';
-- ----------------------------
-- Table structure for member_recent_tag
-- ----------------------------
DROP TABLE IF EXISTS `member_recent_tag`;
CREATE TABLE `member_recent_tag`
(
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '用户tagid',
`member_id` bigint NOT NULL COMMENT '人员id',
`tag_title` varchar(64) NOT NULL COMMENT 'tag标题',
`tag_biz_id` bigint DEFAULT NULL COMMENT 'tag获取的对应id',
`tag_biz_type` char(32) DEFAULT NULL COMMENT 'tag获取的对应type',
`creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '创建者',
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '更新者',
`update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
`deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否删除',
`tenant_id` bigint NOT NULL DEFAULT 0 COMMENT '租户编号',
`active_unique_flag` tinyint GENERATED ALWAYS AS (CASE WHEN `deleted` = 0 THEN 1 ELSE NULL END) STORED COMMENT '有效标签唯一标记，删除记录为NULL',
PRIMARY KEY (`id`) USING BTREE,
UNIQUE KEY `uk_member_recent_tag_active` (`member_id`, `tag_biz_type`, `active_unique_flag`)
) ENGINE = InnoDB AUTO_INCREMENT = 32 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '朋友圈用户tag';
-- ----------------------------
-- Table structure for member_recent_cfg
-- ----------------------------
DROP TABLE IF EXISTS `member_recent_cfg`;
CREATE TABLE `member_recent_cfg`
(
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '用户朋友圈相关配置id',
`member_id` bigint NOT NULL COMMENT '人员id',
`home_hide` bit(1) NOT NULL DEFAULT b'0' COMMENT '首页隐身',
`privacy_secure` bit(1) NOT NULL DEFAULT b'0' COMMENT '隐私保护',
`short_note` bit(1) NOT NULL DEFAULT b'0' COMMENT '短信通知',
`creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '创建者',
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '更新者',
`update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
`deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否删除',
`tenant_id` bigint NOT NULL DEFAULT 0 COMMENT '租户编号',
`active_unique_flag` tinyint GENERATED ALWAYS AS (CASE WHEN `deleted` = 0 THEN 1 ELSE NULL END) STORED COMMENT '有效配置唯一标记，删除记录为NULL',
PRIMARY KEY (`id`) USING BTREE,
UNIQUE KEY `uk_member_recent_cfg_active` (`member_id`, `active_unique_flag`)
) ENGINE = InnoDB AUTO_INCREMENT = 32 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '用户朋友圈相关配置';
-- ----------------------------
-- Table structure for member_open_type
-- ----------------------------
DROP TABLE IF EXISTS `member_open_type`;
CREATE TABLE `member_open_type`
(
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '会员开通类型',
`title` varchar(128) NOT NULL COMMENT '会员开通分类标题',
`icon` varchar(256) DEFAULT NULL COMMENT '图标',
`preferential_price` int NOT NULL COMMENT '价格(优惠价)',
`original_price` int NOT NULL COMMENT '价格(原价)',
`duration` int NOT NULL COMMENT '时长(天)',
`status` char(32) NOT NULL COMMENT '状态',
`is_hot` bit(1) NOT NULL COMMENT '是否热门',
`sort` int DEFAULT 0 NOT NULL COMMENT '排序',
`creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '创建者',
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '更新者',
`update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
`deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否删除',
`tenant_id` bigint NOT NULL DEFAULT 0 COMMENT '租户编号',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 32 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '会员开通类型';
-- ----------------------------
-- Table structure for member_open_type_user
-- ----------------------------
DROP TABLE IF EXISTS `member_open_type_user`;
CREATE TABLE `member_open_type_user`
(
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '会员开通类型与用户关联表',
`open_type_id` bigint NOT NULL COMMENT '会员开通类型编号',
`member_id` bigint NOT NULL COMMENT '用户编号',
`pay_price` int NOT NULL COMMENT '购买价格',
`start_time` datetime NOT NULL COMMENT '开始时间',
`end_time` datetime NOT NULL COMMENT '结束时间',
`status` char(32) NOT NULL COMMENT '状态',
`creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '创建者',
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '更新者',
`update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
`deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否删除',
`tenant_id` bigint NOT NULL DEFAULT 0 COMMENT '租户编号',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 32 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '会员开通类型与用户关联表';
-- ----------------------------
-- Table structure for member_feedback
-- ----------------------------
DROP TABLE IF EXISTS `member_feedback`;
CREATE TABLE `member_feedback`
(
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '用户反馈id',
`member_id` bigint NOT NULL COMMENT '用户编号',
`content` varchar(256) DEFAULT NULL COMMENT '反馈内容',
`pic` varchar(1024) DEFAULT NULL COMMENT '反馈图片',
`creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '创建者',
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '更新者',
`update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
`deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否删除',
`tenant_id` bigint NOT NULL DEFAULT 0 COMMENT '租户编号',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 32 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '用户反馈表';
-- ----------------------------
-- Table structure for product_gift
-- ----------------------------
DROP TABLE IF EXISTS `product_gift`;
CREATE TABLE `product_gift`
(
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '礼物商品id',
`title` varchar(256) NOT NULL COMMENT '礼物标题',
`price` int NOT NULL COMMENT '礼物价格(分)',
`image` varchar(256) NOT NULL COMMENT '礼物图片',
`status` char(32) NOT NULL COMMENT '礼物状态',
`sort` int DEFAULT 0 NOT NULL COMMENT '礼物排序',
`creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '创建者',
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '更新者',
`update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
`deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否删除',
`tenant_id` bigint NOT NULL DEFAULT 0 COMMENT '租户编号',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 32 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '礼物商品';
-- ----------------------------
-- Table structure for pay_wallet_user_transition
-- ----------------------------
DROP TABLE IF EXISTS `pay_wallet_user_transition`;
CREATE TABLE `pay_wallet_user_transition`
(
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '礼物商品id',
`biz_type` varchar(32) NOT NULL COMMENT '转账类型',
`biz_id` bigint DEFAULT NULL COMMENT '转账id',
`send_user_id` bigint NOT NULL COMMENT '赠送人id',
`send_before_balance` int NOT NULL COMMENT '赠送人转账钱的余额(分)',
`send_after_balance` int NOT NULL COMMENT '赠送人转账后的余额(分)',
`target_user_id` bigint NOT NULL COMMENT '被赠送人id',
`target_before_balance` int NOT NULL COMMENT '被赠送人转账钱的余额(分)',
`target_after_balance` int NOT NULL COMMENT '被赠送人转账后的余额(分)',
`price` int NOT NULL COMMENT '交易金额(分)',
`title` varchar(256) DEFAULT NULL COMMENT '金额赠送标题',
`creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '创建者',
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '更新者',
`update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
`deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否删除',
`tenant_id` bigint NOT NULL DEFAULT 0 COMMENT '租户编号',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 32 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '钱包(用户之间的相互转账、赠送)';
-- ----------------------------
-- Table structure for pay_wallet_tx_auth
-- ----------------------------
DROP TABLE IF EXISTS `pay_wallet_tx_auth`;
CREATE TABLE `pay_wallet_tx_auth`
(
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '钱包提现',
`user_id` bigint NOT NULL COMMENT '用户id',
`wallet_id` bigint NOT NULL COMMENT '钱包id',
`biz_type` varchar(36) NOT NULL COMMENT '提现类型',
`biz_id` bigint DEFAULT NULL COMMENT '提现类型绑定id',
`tx_price` int NOT NULL COMMENT '提现金额',
`title` varchar(256) DEFAULT NULL COMMENT '提现title',
`check_status` varchar(36) NOT NULL COMMENT '提现状态',
`check_time` datetime DEFAULT NULL COMMENT '审核时间',
`tx_refuse` varchar(256) DEFAULT NULL COMMENT '提现拒绝信息',
`creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '创建者',
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '更新者',
`update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
`deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否删除',
`tenant_id` bigint NOT NULL DEFAULT 0 COMMENT '租户编号',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 32 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '提现金额审核';
Reference in new issue View Git Blame Copy Permalink