dev/code-bang
1
0
Fork 0
Code Issues Pull Requests Actions Packages Projects Releases Wiki Activity
Files
main
code-bang/backend/codebg.sql
T
Dev 9622b908d6 添加sql
2026-10-28 15:11:34 +08:00

1105 lines
76 KiB
SQL
Raw Permalink Blame History

This file contains ambiguous Unicode characters
This file contains Unicode characters that might be confused with other characters. If you think that this is intentional, you can safely ignore this warning. Use the Escape button to reveal them.
/*
Navicat MySQL Data Transfer
Source Server : aliyun_db
Source Server Type : MySQL
Source Server Version : 50744 (5.7.44)
Source Host : localhost:3306
Source Schema : codebg
Target Server Type : MySQL
Target Server Version : 50744 (5.7.44)
File Encoding : 65001
Date: 28/10/2026 14:33:54
*/
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;
-- ----------------------------
-- Table structure for fa_account_logs
-- ----------------------------
DROP TABLE IF EXISTS `fa_account_logs`;
CREATE TABLE `fa_account_logs` (
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
`user_id` int(11) NOT NULL DEFAULT 0 COMMENT '用户ID',
`account_type` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '账户类型:amount=金额,freeze=冻结,integral=积分,credit_score=信用分',
`amount` decimal(10, 2) NOT NULL DEFAULT 0.00 COMMENT '金额',
`log` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '日志内容',
`type` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '日志类型:1=充值,2=消费,3=收益,4=退款,5=提现,6=冻结,7=解冻,8=推广佣金,9=后台操作',
`credit_type` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '信用分类型:1=任务完成奖励,2=任务失败扣除,3=拒绝接单扣除,4=放弃签约扣除,5=系统退回,9=后台操作',
`percent` decimal(5, 4) NOT NULL DEFAULT 0.0000 COMMENT '分成比例(0~1)',
`total_amount` decimal(10, 2) NOT NULL DEFAULT 0.00 COMMENT '总金额',
`refer_id` int(11) NOT NULL DEFAULT 0 COMMENT '关联ID（需求ID|订单ID|提现ID）',
`inc_or_exp` tinyint(1) NOT NULL DEFAULT 0 COMMENT '增减类型:0=冻结,1=增加,2=支出',
`status` enum('0','1') CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '0' COMMENT '状态:0=正常,1=已处理',
`createtime` bigint(16) NULL DEFAULT NULL COMMENT '创建时间',
`updatetime` bigint(16) NULL DEFAULT NULL COMMENT '更新时间',
PRIMARY KEY (`id`) USING BTREE,
INDEX `idx_user_id`(`user_id`) USING BTREE,
INDEX `idx_order_id`(`refer_id`) USING BTREE,
INDEX `idx_createtime_updatetime`(`createtime`, `updatetime`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 210 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '账户日志表' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for fa_account_withdraws
-- ----------------------------
DROP TABLE IF EXISTS `fa_account_withdraws`;
CREATE TABLE `fa_account_withdraws` (
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键自增',
`apply_sn` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '申请编号',
`user_id` int(11) NOT NULL DEFAULT 0 COMMENT '用户ID',
`account_log_id` int(11) NOT NULL DEFAULT 0 COMMENT '余额日志ID(已废弃)',
`amount` decimal(10, 2) NOT NULL DEFAULT 0.00 COMMENT '提现金额',
`remark` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '备注',
`type` tinyint(1) NOT NULL DEFAULT 1 COMMENT '转账类型:0=默认,1=微信,2=支付宝,3=线下转款',
`status` tinyint(1) NOT NULL DEFAULT 0 COMMENT '审核状态:0=无,1=审核中,2=审核通过,3=审核驳回',
`result_status` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '微信转账结果',
`createtime` bigint(16) NULL DEFAULT NULL COMMENT '添加时间',
`updatetime` bigint(16) NULL DEFAULT NULL COMMENT '更新时间',
PRIMARY KEY (`id`) USING BTREE,
INDEX `apply_sn`(`apply_sn`) USING BTREE,
INDEX `user_id`(`user_id`) USING BTREE,
INDEX `account_log_id`(`account_log_id`) USING BTREE,
INDEX `create_update_time`(`createtime`, `updatetime`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 28 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '账户提现记录表' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for fa_accounts
-- ----------------------------
DROP TABLE IF EXISTS `fa_accounts`;
CREATE TABLE `fa_accounts` (
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
`user_id` int(11) NOT NULL DEFAULT 0 COMMENT '用户ID',
`amount` decimal(11, 2) NOT NULL DEFAULT 0.00 COMMENT '金额',
`freeze` decimal(11, 2) NOT NULL DEFAULT 0.00 COMMENT '冻结金额',
`integral` decimal(11, 2) NOT NULL DEFAULT 0.00 COMMENT '用户积分',
`credit_score` int(11) NOT NULL DEFAULT 1000 COMMENT '用户信誉分',
`createtime` bigint(16) NULL DEFAULT NULL COMMENT '创建时间',
`updatetime` bigint(16) NULL DEFAULT NULL COMMENT '更新时间',
PRIMARY KEY (`id`) USING BTREE,
INDEX `idx_user_id`(`user_id`) USING BTREE,
INDEX `idx_createtime_updatetime`(`createtime`, `updatetime`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 63 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '用户账户余额表' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for fa_admin
-- ----------------------------
DROP TABLE IF EXISTS `fa_admin`;
CREATE TABLE `fa_admin` (
`id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'ID',
`username` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '用户名',
`nickname` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '昵称',
`password` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '密码',
`salt` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '密码盐',
`avatar` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '头像',
`email` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '电子邮箱',
`mobile` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '手机号码',
`loginfailure` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '失败次数',
`logintime` bigint(16) NULL DEFAULT NULL COMMENT '登录时间',
`loginip` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '登录IP',
`createtime` bigint(16) NULL DEFAULT NULL COMMENT '创建时间',
`updatetime` bigint(16) NULL DEFAULT NULL COMMENT '更新时间',
`token` varchar(59) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT 'Session标识',
`status` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT 'normal' COMMENT '状态',
PRIMARY KEY (`id`) USING BTREE,
UNIQUE INDEX `username`(`username`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '管理员表' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for fa_admin_log
-- ----------------------------
DROP TABLE IF EXISTS `fa_admin_log`;
CREATE TABLE `fa_admin_log` (
`id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'ID',
`admin_id` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '管理员ID',
`username` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '管理员名字',
`url` varchar(1500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '操作页面',
`title` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '日志标题',
`content` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '内容',
`ip` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT 'IP',
`useragent` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT 'User-Agent',
`createtime` bigint(16) NULL DEFAULT NULL COMMENT '操作时间',
PRIMARY KEY (`id`) USING BTREE,
INDEX `name`(`username`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1430 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '管理员日志表' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for fa_area
-- ----------------------------
DROP TABLE IF EXISTS `fa_area`;
CREATE TABLE `fa_area` (
`id` int(10) NOT NULL AUTO_INCREMENT COMMENT 'ID',
`pid` int(10) NULL DEFAULT NULL COMMENT '父id',
`shortname` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '简称',
`name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '名称',
`mergename` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '全称',
`level` tinyint(4) NULL DEFAULT NULL COMMENT '层级:1=省,2=市,3=区/县',
`pinyin` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '拼音',
`code` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '长途区号',
`zip` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '邮编',
`first` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '首字母',
`lng` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '经度',
`lat` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '纬度',
PRIMARY KEY (`id`) USING BTREE,
INDEX `pid`(`pid`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 3749 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '地区表' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for fa_attachment
-- ----------------------------
DROP TABLE IF EXISTS `fa_attachment`;
CREATE TABLE `fa_attachment` (
`id` int(20) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'ID',
`category` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '类别',
`admin_id` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '管理员ID',
`user_id` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '会员ID',
`url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '物理路径',
`imagewidth` int(10) UNSIGNED NULL DEFAULT 0 COMMENT '宽度',
`imageheight` int(10) UNSIGNED NULL DEFAULT 0 COMMENT '高度',
`imagetype` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '图片类型',
`imageframes` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '图片帧数',
`filename` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '文件名称',
`filesize` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '文件大小',
`mimetype` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT 'mime类型',
`extparam` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '透传数据',
`createtime` bigint(16) NULL DEFAULT NULL COMMENT '创建日期',
`updatetime` bigint(16) NULL DEFAULT NULL COMMENT '更新时间',
`uploadtime` bigint(16) NULL DEFAULT NULL COMMENT '上传时间',
`storage` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT 'local' COMMENT '存储位置',
`sha1` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '文件 sha1编码',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 80 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '附件表' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for fa_auth_group
-- ----------------------------
DROP TABLE IF EXISTS `fa_auth_group`;
CREATE TABLE `fa_auth_group` (
`id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
`pid` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '父组别',
`name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '组名',
`rules` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '规则ID',
`createtime` bigint(16) NULL DEFAULT NULL COMMENT '创建时间',
`updatetime` bigint(16) NULL DEFAULT NULL COMMENT '更新时间',
`status` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '状态',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 6 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '分组表' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for fa_auth_group_access
-- ----------------------------
DROP TABLE IF EXISTS `fa_auth_group_access`;
CREATE TABLE `fa_auth_group_access` (
`uid` int(10) UNSIGNED NOT NULL COMMENT '会员ID',
`group_id` int(10) UNSIGNED NOT NULL COMMENT '级别ID',
UNIQUE INDEX `uid_group_id`(`uid`, `group_id`) USING BTREE,
INDEX `uid`(`uid`) USING BTREE,
INDEX `group_id`(`group_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '权限分组表' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for fa_auth_rule
-- ----------------------------
DROP TABLE IF EXISTS `fa_auth_rule`;
CREATE TABLE `fa_auth_rule` (
`id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
`type` enum('menu','file') CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT 'file' COMMENT 'menu为菜单,file为权限节点',
`pid` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '父ID',
`name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '规则名称',
`title` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '规则名称',
`icon` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '图标',
`url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '规则URL',
`condition` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '条件',
`remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '备注',
`ismenu` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '是否为菜单',
`menutype` enum('addtabs','blank','dialog','ajax') CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '菜单类型',
`extend` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '扩展属性',
`py` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '拼音首字母',
`pinyin` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '拼音',
`createtime` bigint(16) NULL DEFAULT NULL COMMENT '创建时间',
`updatetime` bigint(16) NULL DEFAULT NULL COMMENT '更新时间',
`weigh` int(10) NOT NULL DEFAULT 0 COMMENT '权重',
`status` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '状态',
PRIMARY KEY (`id`) USING BTREE,
UNIQUE INDEX `name`(`name`) USING BTREE,
INDEX `pid`(`pid`) USING BTREE,
INDEX `weigh`(`weigh`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 263 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '节点表' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for fa_auto_commands
-- ----------------------------
DROP TABLE IF EXISTS `fa_auto_commands`;
CREATE TABLE `fa_auto_commands` (
`id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
`type_id` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '类型',
`command` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '命令',
`note` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '注释#',
`help_json` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '帮助信息（格式：-[param1] [value1]:[示例]#参数说明)',
`cmd_tags` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '标签,逗号隔开',
`full_text` tinytext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '全文索引字段',
`weigh` int(10) UNSIGNED NULL DEFAULT 100 COMMENT '排序',
`status` enum('0','1','2') CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '0' COMMENT '状态:0=待审核,1=审核通过,2=审核驳回',
`createtime` bigint(16) NULL DEFAULT NULL COMMENT '创建时间',
`updatetime` bigint(16) NULL DEFAULT NULL COMMENT '更新时间',
PRIMARY KEY (`id`) USING BTREE,
INDEX `type_id`(`type_id`) USING BTREE,
INDEX `command`(`command`) USING BTREE,
INDEX `note`(`note`) USING BTREE,
INDEX `type_command_note`(`type_id`, `command`, `note`) USING BTREE,
INDEX `cmd_tags_command_note`(`cmd_tags`, `command`, `note`) USING BTREE,
INDEX `create_updatetime`(`createtime`, `updatetime`) USING BTREE,
FULLTEXT INDEX `full_text`(`full_text`)
) ENGINE = MyISAM AUTO_INCREMENT = 104 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '命令行表' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for fa_category
-- ----------------------------
DROP TABLE IF EXISTS `fa_category`;
CREATE TABLE `fa_category` (
`id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
`pid` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '父ID',
`type` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '栏目类型',
`name` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '',
`nickname` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '',
`flag` set('hot','index','recommend') CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '',
`image` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '图片',
`keywords` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '关键字',
`description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '描述',
`diyname` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '自定义名称',
`createtime` bigint(16) NULL DEFAULT NULL COMMENT '创建时间',
`updatetime` bigint(16) NULL DEFAULT NULL COMMENT '更新时间',
`weigh` int(10) NOT NULL DEFAULT 0 COMMENT '权重',
`status` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '状态',
PRIMARY KEY (`id`) USING BTREE,
INDEX `weigh`(`weigh`, `id`) USING BTREE,
INDEX `pid`(`pid`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 23 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '分类表' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for fa_command
-- ----------------------------
DROP TABLE IF EXISTS `fa_command`;
CREATE TABLE `fa_command` (
`id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'ID',
`type` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '类型',
`params` varchar(1500) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '参数',
`command` varchar(1500) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '命令',
`content` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '返回结果',
`executetime` bigint(16) UNSIGNED NULL DEFAULT NULL COMMENT '执行时间',
`createtime` bigint(16) UNSIGNED NULL DEFAULT NULL COMMENT '创建时间',
`updatetime` bigint(16) UNSIGNED NULL DEFAULT NULL COMMENT '更新时间',
`status` enum('successed','failured') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'failured' COMMENT '状态',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 60 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '在线命令表' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for fa_config
-- ----------------------------
DROP TABLE IF EXISTS `fa_config`;
CREATE TABLE `fa_config` (
`id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
`name` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '变量名',
`group` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '分组',
`title` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '变量标题',
`tip` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '变量描述',
`type` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '类型:string,text,int,bool,array,datetime,date,file',
`visible` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '可见条件',
`value` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '变量值',
`content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '变量字典数据',
`rule` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '验证规则',
`extend` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '扩展属性',
`setting` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '配置',
PRIMARY KEY (`id`) USING BTREE,
UNIQUE INDEX `name`(`name`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 35 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '系统配置' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for fa_coupons
-- ----------------------------
DROP TABLE IF EXISTS `fa_coupons`;
CREATE TABLE `fa_coupons` (
`id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键ID',
`type` enum('1','2') CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '1' COMMENT '类型：discount-折扣券，price-满减券',
`title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '优惠券标题',
`value` decimal(10, 2) NOT NULL COMMENT '优惠金额或折扣率',
`tag` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '优惠券标签',
`desc` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '优惠券使用说明',
`base` decimal(10, 2) NOT NULL DEFAULT 0.00 COMMENT '使用门槛金额（元）',
`time_limit` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '有效期限',
`currency` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '¥' COMMENT '货币符号',
`status` enum('0','1','2','3') CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '0' COMMENT '状态:0=待领取,1=可使用,2=已使用,3=已失效',
`createtime` bigint(16) NULL DEFAULT NULL COMMENT '创建时间',
`updatetime` bigint(16) NULL DEFAULT NULL COMMENT '更新时间',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '优惠券表' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for fa_data_logs
-- ----------------------------
DROP TABLE IF EXISTS `fa_data_logs`;
CREATE TABLE `fa_data_logs` (
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
`table` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '数据表',
`log_table` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '关联日志数据表',
`log_table_id` int(11) NOT NULL DEFAULT 0 COMMENT '关联日志表id',
`before_data` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '变动之前数据',
`after_data` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '变动之后数据',
`remark` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '备注',
`createtime` bigint(16) NULL DEFAULT NULL COMMENT '创建时间',
`updatetime` bigint(16) NULL DEFAULT NULL COMMENT '更新时间',
PRIMARY KEY (`id`) USING BTREE,
INDEX `idx_log_table_id`(`log_table_id`) USING BTREE,
INDEX `idx_createtime_updatetime`(`createtime`, `updatetime`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 72 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '数据变动日志表' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for fa_demand_biddings
-- ----------------------------
DROP TABLE IF EXISTS `fa_demand_biddings`;
CREATE TABLE `fa_demand_biddings` (
`id` bigint(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键ID',
`demand_id` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '需求ID',
`user_id` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '用户id',
`quoted_price` decimal(10, 2) NOT NULL DEFAULT 0.00 COMMENT '报价',
`need_days` int(10) NOT NULL DEFAULT 0 COMMENT '预计工时(天)',
`remark` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '备注(优势)',
`bidding_status` tinyint(3) UNSIGNED NOT NULL DEFAULT 0 COMMENT '竞价状态:0=无竞价,1=竞价中,2=中标,3=未中标',
`process_status` tinyint(3) UNSIGNED NOT NULL DEFAULT 0 COMMENT '处理状态:0=未处理,1=待确认,2=已确认,3=已拒绝,4=超时弃权',
`confirm_time` bigint(16) NULL DEFAULT NULL COMMENT '确认时间',
`createtime` bigint(16) NULL DEFAULT NULL COMMENT '创建时间',
`updatetime` bigint(16) NULL DEFAULT NULL COMMENT '更新时间',
PRIMARY KEY (`id`) USING BTREE,
INDEX `idx_user_id`(`user_id`) USING BTREE,
INDEX `idx_demand_id`(`demand_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 49 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '需求投标表' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for fa_demand_contracts
-- ----------------------------
DROP TABLE IF EXISTS `fa_demand_contracts`;
CREATE TABLE `fa_demand_contracts` (
`id` bigint(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键ID',
`demand_id` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '需求ID',
`bidding_id` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '投标ID',
`terms` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '合同条款',
`task_content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '工作内容',
`total_amount` decimal(10, 2) NOT NULL DEFAULT 0.00 COMMENT '总金额',
`deposit_amount` decimal(10, 2) NOT NULL DEFAULT 0.00 COMMENT '预付款金额',
`need_days` int(10) NOT NULL DEFAULT 0 COMMENT '工时(天)',
`remark` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '备注',
`data_json` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT 'Json数据(签约填入的信息)',
`status` tinyint(3) UNSIGNED NOT NULL DEFAULT 0 COMMENT '开发签约状态:0=无,1=签约中,2=签约完成,3=签约失败',
`status2` tinyint(3) UNSIGNED NOT NULL DEFAULT 0 COMMENT '客户签约状态:0=无,1=签约中(待支付),2=签约完成,3=签约失败',
`signed_time` bigint(16) NULL DEFAULT NULL COMMENT '客户签订时间',
`createtime` bigint(16) NULL DEFAULT NULL COMMENT '创建时间(开发签订时间)',
`updatetime` bigint(16) NULL DEFAULT NULL COMMENT '更新时间',
PRIMARY KEY (`id`) USING BTREE,
INDEX `bidding_id`(`bidding_id`) USING BTREE,
INDEX `demand_id`(`demand_id`) USING BTREE,
INDEX `idx_createtime_updatetime`(`createtime`, `updatetime`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 26 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '需求签约表' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for fa_demand_group_chat
-- ----------------------------
DROP TABLE IF EXISTS `fa_demand_group_chat`;
CREATE TABLE `fa_demand_group_chat` (
`id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
`demand_id` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '需求ID',
`chat_id` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '群ID',
`name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '群名',
`config_id` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '群配置ID',
`qr_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '二维码或小程序url',
`scene` tinyint(3) UNSIGNED NOT NULL DEFAULT 0 COMMENT '场景:0=无,1=小程序插件,2=二维码插件',
`state` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '入群渠道参数',
`status` enum('0','1') CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '1' COMMENT '状态:0=禁用,1=启用',
`createtime` bigint(16) NULL DEFAULT NULL COMMENT '添加时间',
`updatetime` bigint(16) NULL DEFAULT NULL COMMENT '更新时间',
PRIMARY KEY (`id`) USING BTREE,
INDEX `demand_id`(`demand_id`) USING BTREE,
INDEX `chat_id`(`chat_id`) USING BTREE,
INDEX `config_id`(`config_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 19 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '需求沟通群' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for fa_demands
-- ----------------------------
DROP TABLE IF EXISTS `fa_demands`;
CREATE TABLE `fa_demands` (
`id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键ID',
`user_id` int(11) NOT NULL COMMENT '用户ID',
`parent_order_no` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '需求编号(父订单号)',
`type` enum('0','1') CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '0' COMMENT '类型:0=开发项目,1=雇佣人才',
`develop_type` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '开发类型',
`title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '需求标题',
`images` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '图片',
`files` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '附件',
`desc` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '需求详情',
`contact` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '联系方式',
`pay_platform` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '发布终端:android=安卓,ios=苹果',
`budget_amount` decimal(10, 2) NOT NULL DEFAULT 0.00 COMMENT '预算(元)',
`limit_time` int(11) NOT NULL DEFAULT 0 COMMENT '工期(天)',
`weigh` int(11) NOT NULL DEFAULT 99 COMMENT '排序',
`views` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '浏览量',
`status` tinyint(3) NOT NULL DEFAULT 0 COMMENT '状态:0=已关闭,1=招标中,2=签约中,3=工作中,4=验收中,5=待收货,6=交易完成,7=交易取消',
`work_status` tinyint(3) UNSIGNED NOT NULL DEFAULT 0 COMMENT '工作状态:0=无,1=工作中,2=工作完成,3=工作失败',
`accept_status` tinyint(3) UNSIGNED NOT NULL DEFAULT 0 COMMENT '验收状态:0=无,1=验收中,2=验收通过,3=验收失败',
`settle_status` tinyint(3) UNSIGNED NOT NULL DEFAULT 0 COMMENT '结算状态:0=无,1=结算中,2=结算完成,3=结算失败',
`bidding_status` tinyint(3) UNSIGNED NOT NULL DEFAULT 1 COMMENT '投标状态:0=暂停投标,1=投标中',
`publish_status` tinyint(3) UNSIGNED NOT NULL DEFAULT 0 COMMENT '发布状态:0=无,1=审核中,2=已发布,3=发布失败',
`accept_time` bigint(16) NULL DEFAULT NULL COMMENT '验收时间',
`createtime` bigint(16) NULL DEFAULT NULL COMMENT '创建时间',
`updatetime` bigint(16) NULL DEFAULT NULL COMMENT '更新时间',
PRIMARY KEY (`id`) USING BTREE,
INDEX `user_id`(`user_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 46 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '客户需求表' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for fa_developers
-- ----------------------------
DROP TABLE IF EXISTS `fa_developers`;
CREATE TABLE `fa_developers` (
`id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键ID',
`user_id` int(11) NOT NULL COMMENT '用户ID',
`job` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '职位',
`tags` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '技能标签',
`desc` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '个人简介',
`work_years` int(11) NOT NULL DEFAULT 0 COMMENT '工作年限(年)',
`contact` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '联系方式',
`status` enum('0','1') CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '0' COMMENT '状态:0=禁用,1=正常',
`createtime` bigint(16) NULL DEFAULT 0 COMMENT '创建时间',
`updatetime` bigint(16) NULL DEFAULT 0 COMMENT '更新时间',
PRIMARY KEY (`id`) USING BTREE,
INDEX `user_id`(`user_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 10 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '开发者表' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for fa_ems
-- ----------------------------
DROP TABLE IF EXISTS `fa_ems`;
CREATE TABLE `fa_ems` (
`id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'ID',
`event` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '事件',
`email` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '邮箱',
`code` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '验证码',
`times` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '验证次数',
`ip` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT 'IP',
`createtime` bigint(16) NULL DEFAULT NULL COMMENT '创建时间',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '邮箱验证码表' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for fa_goods
-- ----------------------------
DROP TABLE IF EXISTS `fa_goods`;
CREATE TABLE `fa_goods` (
`id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键ID',
`spu_id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '商品SPU ID',
`category_id` int(11) NOT NULL DEFAULT 0 COMMENT '商品分类ID',
`saas_id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '商家ID',
`store_id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '店铺ID',
`title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '商品主标题',
`etitle` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '副标题',
`primary_image` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '商品主图',
`images` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '商品多图',
`video` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '视频',
`download_file` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '下载文件',
`price` decimal(10, 2) NULL DEFAULT 0.00 COMMENT '价格',
`min_sale_price` decimal(10, 2) NULL DEFAULT 0.00 COMMENT '最低销售价',
`min_line_price` decimal(10, 2) NULL DEFAULT 0.00 COMMENT '最低划线价',
`max_sale_price` decimal(10, 2) NULL DEFAULT 0.00 COMMENT '最高销售价',
`max_line_price` decimal(10, 2) NULL DEFAULT 0.00 COMMENT '最高划线价',
`spu_stock_quantity` int(11) NULL DEFAULT 0 COMMENT 'SPU总库存',
`sold_num` int(11) NULL DEFAULT 0 COMMENT '销量',
`content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '商品图文内容',
`weigh` int(11) NULL DEFAULT 99 COMMENT '排序',
`is_put_on_sale_switch` tinyint(1) NULL DEFAULT 0 COMMENT '是否上架：0=下架,1=上架',
`is_available_switch` tinyint(1) NULL DEFAULT 0 COMMENT '是否可用:0=禁用,1=启用',
`createtime` bigint(16) NULL DEFAULT NULL COMMENT '创建时间',
`updatetime` bigint(16) NULL DEFAULT NULL COMMENT '更新时间',
PRIMARY KEY (`id`) USING BTREE,
INDEX `spu_id`(`spu_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 6 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '商品表' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for fa_goods_categories
-- ----------------------------
DROP TABLE IF EXISTS `fa_goods_categories`;
CREATE TABLE `fa_goods_categories` (
`id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键ID',
`parent_id` bigint(20) NULL DEFAULT NULL COMMENT '父分类ID，顶级分类为NULL',
`name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '分类名称',
`thumbnail` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '缩略图URL',
`level` int(11) NOT NULL DEFAULT 1 COMMENT '层级深度，1为顶级',
`sort_order` int(11) NULL DEFAULT 0 COMMENT '同级排序',
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE,
INDEX `parent_id`(`parent_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '商品分类表' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for fa_goods_sku_specs
-- ----------------------------
DROP TABLE IF EXISTS `fa_goods_sku_specs`;
CREATE TABLE `fa_goods_sku_specs` (
`id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键ID',
`sku_id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'SKU ID',
`spec_id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '规格ID',
`spec_value_id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '规格值ID',
`createtime` bigint(16) NULL DEFAULT NULL COMMENT '创建时间',
`updatetime` bigint(16) NULL DEFAULT NULL COMMENT '更新时间',
PRIMARY KEY (`id`) USING BTREE,
INDEX `spec_value_id`(`spec_value_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = 'SKU规格关系表' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for fa_goods_skus
-- ----------------------------
DROP TABLE IF EXISTS `fa_goods_skus`;
CREATE TABLE `fa_goods_skus` (
`id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键ID',
`sku_id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'SKU ID',
`spu_id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '商品SPU ID',
`sku_image` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT 'SKU图片',
`sale_price` decimal(10, 2) NULL DEFAULT 0.00 COMMENT '销售价',
`line_price` decimal(10, 2) NULL DEFAULT 0.00 COMMENT '划线价',
`stock_quantity` int(11) NULL DEFAULT 0 COMMENT '库存数量',
`safe_stock_quantity` int(11) NULL DEFAULT 0 COMMENT '安全库存',
`sold_quantity` int(11) NULL DEFAULT 0 COMMENT '销量',
`createtime` bigint(16) NULL DEFAULT NULL COMMENT '创建时间',
`updatetime` bigint(16) NULL DEFAULT NULL COMMENT '更新时间',
PRIMARY KEY (`id`) USING BTREE,
INDEX `sku_id`(`sku_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = 'SKU表' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for fa_goods_spec_values
-- ----------------------------
DROP TABLE IF EXISTS `fa_goods_spec_values`;
CREATE TABLE `fa_goods_spec_values` (
`id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键ID',
`spec_id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '规格ID',
`spec_value_id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '规格值ID',
`spec_value` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '规格值',
`image` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '规格图片',
`createtime` bigint(16) NULL DEFAULT NULL COMMENT '创建时间',
`updatetime` bigint(16) NULL DEFAULT NULL COMMENT '更新时间',
PRIMARY KEY (`id`) USING BTREE,
INDEX `spec_value_id`(`spec_id`, `spec_value_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '规格值表' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for fa_goods_specs
-- ----------------------------
DROP TABLE IF EXISTS `fa_goods_specs`;
CREATE TABLE `fa_goods_specs` (
`id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键ID',
`spec_id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '规格ID',
`title` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '规格名称',
`createtime` bigint(16) NULL DEFAULT NULL COMMENT '创建时间',
`updatetime` bigint(16) NULL DEFAULT NULL COMMENT '更新时间',
PRIMARY KEY (`id`) USING BTREE,
INDEX `spec_id`(`spec_id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '规格表' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for fa_jobs
-- ----------------------------
DROP TABLE IF EXISTS `fa_jobs`;
CREATE TABLE `fa_jobs` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`queue` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
`payload` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
`attempts` tinyint(3) UNSIGNED NOT NULL,
`reserved` tinyint(3) UNSIGNED NOT NULL,
`reserved_at` int(10) UNSIGNED NULL DEFAULT NULL,
`available_at` int(10) UNSIGNED NOT NULL,
`created_at` int(10) UNSIGNED NOT NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '任务队列表' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for fa_messages
-- ----------------------------
DROP TABLE IF EXISTS `fa_messages`;
CREATE TABLE `fa_messages` (
`id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键ID',
`message_type` enum('0','1','2') CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '0' COMMENT '消息类型:0=系统消息,1=公告消息,2=需求消息',
`from_user_id` int(11) NOT NULL DEFAULT 0 COMMENT '发消息用户ID',
`to_user_id` int(11) NOT NULL DEFAULT 0 COMMENT '收消息用户ID',
`title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '消息标题',
`content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '消息内容',
`extra_json` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '扩展数据（如跳转url、业务ID等）',
`is_read` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否已读:0=未读,1=已读',
`createtime` bigint(16) NULL DEFAULT NULL COMMENT '创建时间',
`updatetime` bigint(16) NULL DEFAULT NULL COMMENT '更新时间',
PRIMARY KEY (`id`) USING BTREE,
INDEX `from_user_id`(`from_user_id`, `to_user_id`) USING BTREE,
INDEX `idx_touser_read`(`to_user_id`, `is_read`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 74 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '消息记录表' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for fa_order_goods
-- ----------------------------
DROP TABLE IF EXISTS `fa_order_goods`;
CREATE TABLE `fa_order_goods` (
`id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键ID',
`order_no` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '订单号',
`spu_id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '商品SPU ID',
`sku_id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '商品SKU ID',
`goods_main_type` tinyint(4) NOT NULL DEFAULT 0 COMMENT '商品主类型',
`goods_vice_type` tinyint(4) NOT NULL DEFAULT 0 COMMENT '商品副类型',
`goods_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '商品名称',
`goods_picture_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '商品图片URL',
`origin_price` decimal(10, 2) NOT NULL DEFAULT 0.00 COMMENT '原价',
`actual_price` decimal(10, 2) NOT NULL DEFAULT 0.00 COMMENT '实际价格',
`buy_quantity` int(11) NOT NULL DEFAULT 0 COMMENT '购买数量',
`item_total_amount` decimal(10, 2) NOT NULL DEFAULT 0.00 COMMENT '商品总金额',
`item_discount_amount` decimal(10, 2) NOT NULL DEFAULT 0.00 COMMENT '商品优惠金额',
`item_payment_amount` decimal(10, 2) NOT NULL DEFAULT 0.00 COMMENT '商品实付金额',
`goods_payment_price` decimal(10, 2) NOT NULL DEFAULT 0.00 COMMENT '商品支付单价',
`createtime` bigint(16) NULL DEFAULT NULL COMMENT '创建时间',
`updatetime` bigint(16) NULL DEFAULT NULL COMMENT '更新时间',
PRIMARY KEY (`id`) USING BTREE,
INDEX `idx_order_no`(`order_no`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 97 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '订单商品表' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for fa_order_logistics
-- ----------------------------
DROP TABLE IF EXISTS `fa_order_logistics`;
CREATE TABLE `fa_order_logistics` (
`id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键ID',
`order_no` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '订单号',
`logistics_type` tinyint(4) NOT NULL COMMENT '物流类型',
`logistics_no` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '物流单号',
`logistics_status` tinyint(4) NULL DEFAULT 0 COMMENT '物流状态',
`logistics_company_code` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '物流公司编码',
`logistics_company_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '物流公司名称',
`receiver_address_id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '收货地址ID',
`receiver_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '收货人姓名',
`receiver_phone` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '收货人电话',
`receiver_province` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '省',
`receiver_city` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '市',
`receiver_country` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '区',
`receiver_address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '详细地址',
`receiver_post_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '详细地址',
`receiver_longitude` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '经度',
`receiver_latitude` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '纬度',
`expect_arrival_time` bigint(20) NULL DEFAULT NULL COMMENT '预计到达时间',
`send_time` bigint(20) NULL DEFAULT NULL COMMENT '发货时间',
`arrival_time` bigint(20) NULL DEFAULT NULL COMMENT '到达时间',
`createtime` bigint(16) NULL DEFAULT NULL COMMENT '创建时间',
`updatetime` bigint(16) NULL DEFAULT NULL COMMENT '更新时间',
PRIMARY KEY (`id`) USING BTREE,
INDEX `idx_order_no`(`order_no`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '订单物流表' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for fa_order_payment
-- ----------------------------
DROP TABLE IF EXISTS `fa_order_payment`;
CREATE TABLE `fa_order_payment` (
`id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键ID',
`order_no` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '订单号',
`pay_status` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '支付状态',
`amount` decimal(10, 2) NOT NULL COMMENT '支付金额',
`currency` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '货币类型',
`pay_type` tinyint(4) NULL DEFAULT NULL COMMENT '支付类型:1=微信,2=支付宝',
`pay_way` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '支付方式',
`pay_platform` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '支付终端:android=安卓,ios=苹果',
`interact_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '交互ID',
`trace_no` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '追踪号',
`channel_trx_no` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '渠道交易号',
`pay_time` bigint(20) NULL DEFAULT NULL COMMENT '支付时间',
`pay_success_time` bigint(20) NULL DEFAULT NULL COMMENT '支付成功时间',
`createtime` bigint(16) NULL DEFAULT NULL COMMENT '创建时间',
`updatetime` bigint(16) NULL DEFAULT NULL COMMENT '更新时间',
PRIMARY KEY (`id`) USING BTREE,
UNIQUE INDEX `uk_order_no`(`order_no`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 42 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '订单支付表' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for fa_order_refunds
-- ----------------------------
DROP TABLE IF EXISTS `fa_order_refunds`;
CREATE TABLE `fa_order_refunds` (
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
`refund_no` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '申请编号',
`order_no` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '订单号',
`amount` decimal(10, 2) NOT NULL DEFAULT 0.00 COMMENT '退款金额',
`result_refund_fee` int(11) NOT NULL DEFAULT 0 COMMENT '微信退款金额(分)',
`result_refund_no` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '微信退款单号',
`remark` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '备注',
`status` tinyint(1) NOT NULL DEFAULT 0 COMMENT '退款状态:1=申请中,2=退款成功,3=退款驳回',
`result_status` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '微信退款结果',
`result_refund_status` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '微信退款查询',
`createtime` bigint(16) NULL DEFAULT NULL COMMENT '创建时间',
`updatetime` bigint(16) NULL DEFAULT NULL COMMENT '更新时间',
PRIMARY KEY (`id`) USING BTREE,
INDEX `idx_refund_no`(`refund_no`) USING BTREE,
INDEX `idx_order_no`(`order_no`) USING BTREE,
INDEX `idx_result_refund_no`(`result_refund_no`) USING BTREE,
INDEX `idx_createtime_updatetime`(`createtime`, `updatetime`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '订单退款表' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for fa_order_ships
-- ----------------------------
DROP TABLE IF EXISTS `fa_order_ships`;
CREATE TABLE `fa_order_ships` (
`id` bigint(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键ID',
`order_no` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '订单号',
`order_goods_spu_id` int(10) UNSIGNED NULL DEFAULT 0 COMMENT '订单商品ID',
`demand_id` int(10) UNSIGNED NULL DEFAULT 0 COMMENT '需求ID',
`code` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '激活码',
`images` varchar(2000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '多图(英文逗号分隔)',
`files` varchar(2000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '多文件(英文逗号分隔)',
`deliver_links` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '交付链接（Git仓库/网盘等，英文逗号分隔）',
`remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '备注',
`createtime` bigint(16) NULL DEFAULT NULL COMMENT '添加时间',
`updatetime` bigint(16) NULL DEFAULT NULL COMMENT '更新时间',
PRIMARY KEY (`id`) USING BTREE,
INDEX `spu_id_idx`(`order_goods_spu_id`) USING BTREE,
INDEX `created_updated_idx`(`createtime`, `updatetime`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 18 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '订单发货表' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for fa_orders
-- ----------------------------
DROP TABLE IF EXISTS `fa_orders`;
CREATE TABLE `fa_orders` (
`id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键ID',
`user_id` int(11) NOT NULL COMMENT '用户ID',
`saas_id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT 'SAAS ID',
`store_id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '店铺ID',
`store_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '店铺名称',
`parent_order_no` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '父订单号',
`order_no` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '订单号',
`order_type` enum('0','1','2','3') CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '0' COMMENT '订单类型:0=软件产品订单,1=需求签约订单1,2=需求签约订单2',
`order_sub_type` tinyint(4) NOT NULL DEFAULT 0 COMMENT '订单子类型',
`order_status` tinyint(4) NOT NULL COMMENT '订单状态:0=关闭,10=待付款,20=待发货,30=待收货,40=已完成,50=已取消,60已退款',
`order_sub_status` tinyint(4) NULL DEFAULT 0 COMMENT '订单子状态',
`total_amount` decimal(10, 2) NOT NULL DEFAULT 0.00 COMMENT '订单总金额',
`goods_amount` decimal(10, 2) NOT NULL DEFAULT 0.00 COMMENT '商品总金额',
`goods_amount_app` decimal(10, 2) NOT NULL DEFAULT 0.00 COMMENT '商品总金额(APP)',
`payment_amount` decimal(10, 2) NOT NULL DEFAULT 0.00 COMMENT '实付金额',
`settle_amount` decimal(10, 2) NOT NULL DEFAULT 0.00 COMMENT '结算金额',
`freight_fee` decimal(10, 2) NOT NULL DEFAULT 0.00 COMMENT '运费',
`package_fee` decimal(10, 2) NOT NULL DEFAULT 0.00 COMMENT '包装费',
`discount_amount` decimal(10, 2) NOT NULL DEFAULT 0.00 COMMENT '优惠金额',
`channel_type` tinyint(4) NOT NULL DEFAULT 0 COMMENT '渠道类型',
`channel_source` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '渠道来源',
`channel_identity` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '渠道标识',
`remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '备注',
`cancel_type` tinyint(4) NULL DEFAULT 0 COMMENT '取消类型',
`cancel_reason_type` tinyint(4) NULL DEFAULT 0 COMMENT '取消原因类型',
`cancel_reason` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '取消原因',
`rights_type` tinyint(4) NULL DEFAULT 0 COMMENT '维权类型',
`auto_cancel_time` bigint(20) NULL DEFAULT 0 COMMENT '自动取消时间',
`order_status_remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '订单状态备注',
`createtime` bigint(16) NULL DEFAULT NULL COMMENT '创建时间',
`updatetime` bigint(16) NULL DEFAULT NULL COMMENT '更新时间',
`promoter_id` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '推广人用户ID(下单时快照)',
`commission_ratio` decimal(5, 4) NOT NULL DEFAULT 0.0000 COMMENT '结算时的佣金比例',
`commission_amount` decimal(10, 2) NOT NULL DEFAULT 0.00 COMMENT '推广佣金',
`commission_status` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '佣金状态:0=待结算,1=已结算,2=不分佣',
`commission_time` bigint(16) NULL DEFAULT NULL COMMENT '佣金结算时间',
PRIMARY KEY (`id`) USING BTREE,
UNIQUE INDEX `uk_order_no`(`order_no`) USING BTREE,
INDEX `idx_user_id`(`user_id`) USING BTREE,
INDEX `idx_createtime`(`createtime`) USING BTREE,
INDEX `idx_promoter_id`(`promoter_id`) USING BTREE,
INDEX `idx_commission_settle`(`commission_status`, `order_status`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 94 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '订单主表' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for fa_sms
-- ----------------------------
DROP TABLE IF EXISTS `fa_sms`;
CREATE TABLE `fa_sms` (
`id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'ID',
`event` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '事件',
`mobile` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '手机号',
`code` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '验证码',
`times` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '验证次数',
`ip` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT 'IP',
`createtime` bigint(16) UNSIGNED NULL DEFAULT 0 COMMENT '创建时间',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 11 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '短信验证码表' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for fa_soft_codes
-- ----------------------------
DROP TABLE IF EXISTS `fa_soft_codes`;
CREATE TABLE `fa_soft_codes` (
`id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
`activate_code` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '激活码',
`valid_days` int(10) UNSIGNED NULL DEFAULT 1 COMMENT '有效天数(0永久)',
`remark` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '备注',
`createtime` bigint(16) NULL DEFAULT NULL COMMENT '创建时间',
`updatetime` bigint(16) NULL DEFAULT NULL COMMENT '更新时间',
`status` enum('0','1','2') CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '0' COMMENT '状态:0=未使用,1=已使用,2=已过期',
PRIMARY KEY (`id`) USING BTREE,
INDEX `activate_code`(`activate_code`) USING BTREE,
INDEX `create_updatetime`(`createtime`, `updatetime`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 13 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '软件激活码表' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for fa_soft_devices
-- ----------------------------
DROP TABLE IF EXISTS `fa_soft_devices`;
CREATE TABLE `fa_soft_devices` (
`id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
`type` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '软件类型',
`name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '软件名称',
`image` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '图片',
`client_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '客户端ID',
`device_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '设备ID',
`device_brand` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '设备品牌',
`device_model` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '设备型号',
`device_release` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '设备系统版本号',
`activate_code` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '激活码',
`activated_time` bigint(16) NULL DEFAULT NULL COMMENT '激活时间',
`expiration_time` bigint(16) NULL DEFAULT NULL COMMENT '过期时间',
`remark` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '备注',
`createtime` bigint(16) NULL DEFAULT NULL COMMENT '创建时间',
`updatetime` bigint(16) NULL DEFAULT NULL COMMENT '更新时间',
`status` enum('0','1','2') CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '1' COMMENT '状态:0=封禁,1=正常,3=异常',
PRIMARY KEY (`id`) USING BTREE,
INDEX `client_id`(`client_id`) USING BTREE,
INDEX `device_id`(`device_id`) USING BTREE,
INDEX `activate_code`(`activate_code`) USING BTREE,
INDEX `create_updatetime`(`createtime`, `updatetime`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 6 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '软件设备绑定表' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for fa_subscribe_messages
-- ----------------------------
DROP TABLE IF EXISTS `fa_subscribe_messages`;
CREATE TABLE `fa_subscribe_messages` (
`id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
`user_id` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '接收用户id',
`refer_id` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '引用数据id',
`refer_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '引用数据类型:Demands=需求订单,Orders=产品订单',
`template_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '消息模板id',
`page` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '跳转页面及参数',
`data_json` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '要发送的数据json格式',
`type` tinyint(1) NOT NULL DEFAULT 0 COMMENT '消息类型:0=微信消息,1=短信消息',
`status` tinyint(1) NOT NULL DEFAULT 0 COMMENT '消息状态:0=未发送,1=发送成功,2=发送失败',
`deleted_at` bigint(16) NULL DEFAULT NULL COMMENT '删除时间',
`createtime` bigint(16) NULL DEFAULT NULL COMMENT '创建时间',
`updatetime` bigint(16) NULL DEFAULT NULL COMMENT '更新时间',
PRIMARY KEY (`id`) USING BTREE,
INDEX `idx_user_id`(`user_id`) USING BTREE,
INDEX `idx_reference_id`(`refer_id`) USING BTREE,
INDEX `idx_create_update_time`(`createtime`, `updatetime`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '消息订阅表' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for fa_test
-- ----------------------------
DROP TABLE IF EXISTS `fa_test`;
CREATE TABLE `fa_test` (
`id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'ID',
`user_id` int(10) NULL DEFAULT 0 COMMENT '会员ID',
`admin_id` int(10) NULL DEFAULT 0 COMMENT '管理员ID',
`category_id` int(10) UNSIGNED NULL DEFAULT 0 COMMENT '分类ID(单选)',
`category_ids` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '分类ID(多选)',
`tags` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '标签',
`week` enum('monday','tuesday','wednesday') CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '星期(单选):monday=星期一,tuesday=星期二,wednesday=星期三',
`flag` set('hot','index','recommend') CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '标志(多选):hot=热门,index=首页,recommend=推荐',
`genderdata` enum('male','female') CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT 'male' COMMENT '性别(单选):male=男,female=女',
`hobbydata` set('music','reading','swimming') CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '爱好(多选):music=音乐,reading=读书,swimming=游泳',
`title` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '标题',
`content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '内容',
`image` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '图片',
`images` varchar(1500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '图片组',
`attachfile` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '附件',
`keywords` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '关键字',
`description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '描述',
`city` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '省市',
`array` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '数组:value=值',
`json` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '配置:key=名称,value=值',
`multiplejson` varchar(1500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '二维数组:title=标题,intro=介绍,author=作者,age=年龄',
`price` decimal(10, 2) UNSIGNED NULL DEFAULT 0.00 COMMENT '价格',
`views` int(10) UNSIGNED NULL DEFAULT 0 COMMENT '点击',
`workrange` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '时间区间',
`startdate` date NULL DEFAULT NULL COMMENT '开始日期',
`activitytime` datetime NULL DEFAULT NULL COMMENT '活动时间(datetime)',
`year` year NULL DEFAULT NULL COMMENT '年',
`times` time NULL DEFAULT NULL COMMENT '时间',
`refreshtime` bigint(16) NULL DEFAULT NULL COMMENT '刷新时间',
`createtime` bigint(16) NULL DEFAULT NULL COMMENT '创建时间',
`updatetime` bigint(16) NULL DEFAULT NULL COMMENT '更新时间',
`deletetime` bigint(16) NULL DEFAULT NULL COMMENT '删除时间',
`weigh` int(10) NULL DEFAULT 0 COMMENT '权重',
`switch` tinyint(1) NULL DEFAULT 0 COMMENT '开关',
`status` enum('normal','hidden') CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT 'normal' COMMENT '状态',
`state` enum('0','1','2') CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '1' COMMENT '状态值:0=禁用,1=正常,2=推荐',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '测试表' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for fa_transfer_authorizations
-- ----------------------------
DROP TABLE IF EXISTS `fa_transfer_authorizations`;
CREATE TABLE `fa_transfer_authorizations` (
`id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键ID',
`user_id` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '用户ID',
`out_authorization_no` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '商户侧授权单号(TXAUTH+用户ID)',
`authorization_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '微信侧授权单号(授权成功后回调写入)',
`state` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT 'WAIT_USER_CONFIRM' COMMENT '授权状态:WAIT_USER_CONFIRM=待用户确认,TAKING_EFFECT=生效中',
`package_info` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '拉起授权页所需package(前端wx.requestMerchantTransfer使用)',
`createtime` bigint(16) NULL DEFAULT NULL COMMENT '创建时间',
`updatetime` bigint(16) NULL DEFAULT NULL COMMENT '更新时间',
PRIMARY KEY (`id`) USING BTREE,
UNIQUE INDEX `uniq_user_id`(`user_id`) USING BTREE,
UNIQUE INDEX `uniq_out_auth_no`(`out_authorization_no`) USING BTREE,
INDEX `idx_authorization_id`(`authorization_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 10 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '免确认收款授权记录' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for fa_user
-- ----------------------------
DROP TABLE IF EXISTS `fa_user`;
CREATE TABLE `fa_user` (
`id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'ID',
`group_id` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '组别ID',
`username` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '用户名',
`nickname` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '昵称',
`password` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '密码',
`salt` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '密码盐',
`email` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '电子邮箱',
`openid` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '微信openid',
`mobile` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '手机号',
`avatar` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '头像',
`level` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '等级',
`gender` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '性别',
`birthday` date NULL DEFAULT NULL COMMENT '生日',
`bio` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '格言',
`money` decimal(10, 2) NOT NULL DEFAULT 0.00 COMMENT '余额',
`role` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '用户角色:dev=开发',
`score` int(10) NOT NULL DEFAULT 0 COMMENT '积分',
`successions` int(10) UNSIGNED NOT NULL DEFAULT 1 COMMENT '连续登录天数',
`maxsuccessions` int(10) UNSIGNED NOT NULL DEFAULT 1 COMMENT '最大连续登录天数',
`prevtime` bigint(16) NULL DEFAULT NULL COMMENT '上次登录时间',
`logintime` bigint(16) NULL DEFAULT NULL COMMENT '登录时间',
`loginip` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '登录IP',
`loginfailure` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '失败次数',
`loginfailuretime` bigint(16) NULL DEFAULT NULL COMMENT '最后登录失败时间',
`joinip` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '加入IP',
`jointime` bigint(16) NULL DEFAULT NULL COMMENT '加入时间',
`createtime` bigint(16) NULL DEFAULT NULL COMMENT '创建时间',
`updatetime` bigint(16) NULL DEFAULT NULL COMMENT '更新时间',
`token` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT 'Token',
`status` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT 'normal' COMMENT '状态:normal=正常',
`verification` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '验证',
`promoter_id` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '推广人用户ID(首次通过分享进入时永久绑定)',
`promoter_bind_time` bigint(16) NULL DEFAULT NULL COMMENT '推广关系绑定时间',
PRIMARY KEY (`id`) USING BTREE,
INDEX `username`(`username`) USING BTREE,
INDEX `email`(`email`) USING BTREE,
INDEX `mobile`(`mobile`) USING BTREE,
INDEX `idx_promoter_id`(`promoter_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 66 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '会员表' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for fa_user_group
-- ----------------------------
DROP TABLE IF EXISTS `fa_user_group`;
CREATE TABLE `fa_user_group` (
`id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
`name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '组名',
`rules` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '权限节点',
`createtime` bigint(16) NULL DEFAULT NULL COMMENT '添加时间',
`updatetime` bigint(16) NULL DEFAULT NULL COMMENT '更新时间',
`status` enum('normal','hidden') CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '状态',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '会员组表' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for fa_user_money_log
-- ----------------------------
DROP TABLE IF EXISTS `fa_user_money_log`;
CREATE TABLE `fa_user_money_log` (
`id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
`user_id` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '会员ID',
`money` decimal(10, 2) NOT NULL DEFAULT 0.00 COMMENT '变更余额',
`before` decimal(10, 2) NOT NULL DEFAULT 0.00 COMMENT '变更前余额',
`after` decimal(10, 2) NOT NULL DEFAULT 0.00 COMMENT '变更后余额',
`memo` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '备注',
`createtime` bigint(16) NULL DEFAULT NULL COMMENT '创建时间',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '会员余额变动表' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for fa_user_rule
-- ----------------------------
DROP TABLE IF EXISTS `fa_user_rule`;
CREATE TABLE `fa_user_rule` (
`id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
`pid` int(10) NULL DEFAULT NULL COMMENT '父ID',
`name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '名称',
`title` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '标题',
`remark` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '备注',
`ismenu` tinyint(1) NULL DEFAULT NULL COMMENT '是否菜单',
`createtime` bigint(16) NULL DEFAULT NULL COMMENT '创建时间',
`updatetime` bigint(16) NULL DEFAULT NULL COMMENT '更新时间',
`weigh` int(10) NULL DEFAULT 0 COMMENT '权重',
`status` enum('normal','hidden') CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '状态',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 13 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '会员规则表' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for fa_user_score_log
-- ----------------------------
DROP TABLE IF EXISTS `fa_user_score_log`;
CREATE TABLE `fa_user_score_log` (
`id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
`user_id` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '会员ID',
`score` int(10) NOT NULL DEFAULT 0 COMMENT '变更积分',
`before` int(10) NOT NULL DEFAULT 0 COMMENT '变更前积分',
`after` int(10) NOT NULL DEFAULT 0 COMMENT '变更后积分',
`memo` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '备注',
`createtime` bigint(16) NULL DEFAULT NULL COMMENT '创建时间',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '会员积分变动表' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for fa_user_token
-- ----------------------------
DROP TABLE IF EXISTS `fa_user_token`;
CREATE TABLE `fa_user_token` (
`token` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'Token',
`user_id` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '会员ID',
`createtime` bigint(16) NULL DEFAULT NULL COMMENT '创建时间',
`expiretime` bigint(16) NULL DEFAULT NULL COMMENT '过期时间',
PRIMARY KEY (`token`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '会员Token表' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for fa_version
-- ----------------------------
DROP TABLE IF EXISTS `fa_version`;
CREATE TABLE `fa_version` (
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'ID',
`oldversion` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '旧版本号',
`newversion` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '新版本号',
`packagesize` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '包大小',
`content` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '升级内容',
`downloadurl` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '下载地址',
`enforce` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '强制更新',
`createtime` bigint(16) NULL DEFAULT NULL COMMENT '创建时间',
`updatetime` bigint(16) NULL DEFAULT NULL COMMENT '更新时间',
`weigh` int(10) NOT NULL DEFAULT 0 COMMENT '权重',
`status` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '状态',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '版本表' ROW_FORMAT = Dynamic;
SET FOREIGN_KEY_CHECKS = 1;
Reference in New Issue View Git Blame Copy Permalink