1812 lines
104 KiB
SQL
1812 lines
104 KiB
SQL
-- --------------------------------------------------------
|
||
-- 主机: 124.71.161.49
|
||
-- 服务器版本: 5.7.31-log - Source distribution
|
||
-- 服务器操作系统: Linux
|
||
-- HeidiSQL 版本: 12.0.0.6468
|
||
-- --------------------------------------------------------
|
||
|
||
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
|
||
/*!40101 SET NAMES utf8 */;
|
||
/*!50503 SET NAMES utf8mb4 */;
|
||
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
|
||
/*!40103 SET TIME_ZONE='+00:00' */;
|
||
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
|
||
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
|
||
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
|
||
|
||
-- 导出 表 cxaibc.cx_address 结构
|
||
CREATE TABLE IF NOT EXISTS `cx_address` (
|
||
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
|
||
`cx_mch_id` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '平台商户ID',
|
||
`user_id` bigint(20) unsigned NOT NULL COMMENT '用户ID',
|
||
`name` varchar(256) NOT NULL COMMENT '姓名',
|
||
`mobile` varchar(16) NOT NULL COMMENT '手机号',
|
||
`province_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '省ID',
|
||
`province` varchar(50) DEFAULT NULL COMMENT '省',
|
||
`city_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '市ID',
|
||
`city` varchar(50) DEFAULT NULL COMMENT '市',
|
||
`district_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '区ID',
|
||
`district` varchar(50) DEFAULT NULL COMMENT '区',
|
||
`town_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '镇ID',
|
||
`town` varchar(50) DEFAULT NULL COMMENT '镇',
|
||
`detail` varchar(256) DEFAULT NULL COMMENT '详细地址',
|
||
`formatted_addr` varchar(256) DEFAULT NULL COMMENT '可读地址',
|
||
`is_default` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否默认，0=否，1=是',
|
||
`lat` varchar(32) NOT NULL COMMENT '纬度',
|
||
`lng` varchar(32) NOT NULL COMMENT '经度',
|
||
`created_at` int(11) NOT NULL DEFAULT '0' COMMENT '添加时间',
|
||
`updated_at` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '更新时间',
|
||
`deleted_at` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '删除时间',
|
||
`is_delete` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否删除，0=否，1=是',
|
||
`gender` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '性别，0=未知，1=男，2=女，3=保密',
|
||
`tag` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '标签，0=未知，1=家，2=公司，3=学校，4=其他',
|
||
PRIMARY KEY (`id`) USING BTREE,
|
||
KEY `user_id` (`user_id`) USING BTREE,
|
||
KEY `cx_mch_id` (`cx_mch_id`) USING BTREE,
|
||
KEY `search_index` (`cx_mch_id`,`user_id`,`is_delete`) USING BTREE
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='收货地址';
|
||
|
||
-- 数据导出被取消选择。
|
||
|
||
-- 导出 表 cxaibc.cx_api_log 结构
|
||
CREATE TABLE IF NOT EXISTS `cx_api_log` (
|
||
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
|
||
`cx_mch_id` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '平台商户ID',
|
||
`user_id` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '用户ID',
|
||
`route` varchar(2048) DEFAULT NULL COMMENT '路由',
|
||
`module_id` varchar(256) DEFAULT NULL COMMENT '模块ID',
|
||
`controller_id` varchar(256) DEFAULT NULL COMMENT '控制器ID',
|
||
`action_id` varchar(256) DEFAULT NULL COMMENT '动作ID',
|
||
`url` longtext COMMENT 'URL',
|
||
`method` varchar(16) DEFAULT NULL COMMENT '请求方法',
|
||
`method_param` longtext COMMENT '方法数据',
|
||
`ipv4` varchar(32) DEFAULT NULL COMMENT 'IPV4',
|
||
`ipv6` varchar(128) DEFAULT NULL COMMENT 'IPV6',
|
||
`is_pass` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否拦截，0=否，1=是',
|
||
`request_time` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '请求时间，毫秒',
|
||
`response_time` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '响应时间，毫秒',
|
||
`request_date` date NOT NULL COMMENT '请求日期',
|
||
`process_consume_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '请求处理耗时，毫秒',
|
||
`is_delete` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否删除，0=否，1=是',
|
||
`created_at` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '添加时间',
|
||
PRIMARY KEY (`id`) USING BTREE,
|
||
KEY `user_id` (`user_id`) USING BTREE,
|
||
KEY `cx_mch_id` (`cx_mch_id`) USING BTREE,
|
||
KEY `is_pass` (`is_pass`) USING BTREE
|
||
) ENGINE=InnoDB AUTO_INCREMENT=93896 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='API日志';
|
||
|
||
-- 数据导出被取消选择。
|
||
|
||
-- 导出 表 cxaibc.cx_auth_role 结构
|
||
CREATE TABLE IF NOT EXISTS `cx_auth_role` (
|
||
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'ID',
|
||
`cx_mch_id` bigint(20) NOT NULL COMMENT '平台商户ID',
|
||
`creator_user_id` bigint(20) NOT NULL COMMENT '创建者用户ID',
|
||
`name` varchar(50) NOT NULL COMMENT '名称',
|
||
`remark` varchar(255) NOT NULL COMMENT '备注',
|
||
`created_at` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '添加时间',
|
||
`updated_at` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '更新时间',
|
||
`is_delete` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否删除：0=否，1=是',
|
||
`deleted_at` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '删除时间',
|
||
PRIMARY KEY (`id`) USING BTREE,
|
||
KEY `cx_mch_id_is_delete` (`cx_mch_id`,`is_delete`) USING BTREE
|
||
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='用户角色';
|
||
|
||
-- 数据导出被取消选择。
|
||
|
||
-- 导出 表 cxaibc.cx_auth_role_permission 结构
|
||
CREATE TABLE IF NOT EXISTS `cx_auth_role_permission` (
|
||
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'ID',
|
||
`cx_mch_id` bigint(20) NOT NULL COMMENT '平台商户ID',
|
||
`role_id` bigint(20) NOT NULL COMMENT '用户角色ID',
|
||
`permissions` longtext NOT NULL COMMENT '权限',
|
||
`created_at` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '添加时间',
|
||
`updated_at` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '更新时间',
|
||
`is_delete` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否删除：0=否，1=是',
|
||
`deleted_at` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '删除时间',
|
||
PRIMARY KEY (`id`) USING BTREE,
|
||
KEY `cx_mch_id_is_delete` (`cx_mch_id`,`is_delete`,`role_id`) USING BTREE
|
||
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='用户角色权限';
|
||
|
||
-- 数据导出被取消选择。
|
||
|
||
-- 导出 表 cxaibc.cx_auth_role_user 结构
|
||
CREATE TABLE IF NOT EXISTS `cx_auth_role_user` (
|
||
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'ID',
|
||
`cx_mch_id` bigint(20) NOT NULL COMMENT '平台商户ID',
|
||
`role_id` bigint(20) NOT NULL COMMENT '用户角色ID',
|
||
`user_id` bigint(20) NOT NULL COMMENT '用户ID',
|
||
`created_at` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '添加时间',
|
||
`is_delete` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否删除：0=否，1=是',
|
||
`deleted_at` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '删除时间',
|
||
PRIMARY KEY (`id`) USING BTREE,
|
||
KEY `cx_mch_id_is_delete` (`cx_mch_id`,`is_delete`,`role_id`,`user_id`) USING BTREE
|
||
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='角色用户';
|
||
|
||
-- 数据导出被取消选择。
|
||
|
||
-- 导出 表 cxaibc.cx_balance 结构
|
||
CREATE TABLE IF NOT EXISTS `cx_balance` (
|
||
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
|
||
`cx_mch_id` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '平台商户ID',
|
||
`scene` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '场景类型',
|
||
`user_id` bigint(20) unsigned NOT NULL COMMENT '用户ID',
|
||
`account_balance` decimal(18,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '账户余额',
|
||
`password` varchar(256) DEFAULT NULL COMMENT '密码',
|
||
`created_at` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '添加时间',
|
||
`updated_at` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '更新时间',
|
||
`deleted_at` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '删除时间',
|
||
`is_delete` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否删除：0=否，1=是',
|
||
PRIMARY KEY (`id`) USING BTREE,
|
||
KEY `cx_mch_id` (`cx_mch_id`) USING BTREE,
|
||
KEY `user_id` (`user_id`) USING BTREE,
|
||
KEY `cx_mch_id_user_id_is_delete` (`cx_mch_id`,`user_id`,`is_delete`) USING BTREE
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='用户钱包';
|
||
|
||
-- 数据导出被取消选择。
|
||
|
||
-- 导出 表 cxaibc.cx_balance_log 结构
|
||
CREATE TABLE IF NOT EXISTS `cx_balance_log` (
|
||
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
|
||
`cx_mch_id` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '平台商户ID',
|
||
`scene` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '场景类型',
|
||
`type` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '类型：1=收入，2=支出',
|
||
`user_id` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '用户ID',
|
||
`money` decimal(18,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '金额',
|
||
`before_account_balance` decimal(18,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '变化前账户余额',
|
||
`after_account_balance` decimal(18,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '变化后账户余额',
|
||
`desc` varchar(2048) DEFAULT NULL COMMENT '描述',
|
||
`order_type` smallint(2) unsigned NOT NULL DEFAULT '0' COMMENT '订单类型',
|
||
`order_no` varchar(128) DEFAULT NULL COMMENT '订单号',
|
||
`ext` text COMMENT '扩展信息',
|
||
`created_at` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '添加时间',
|
||
`is_delete` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否删除：0=否，1=是',
|
||
`deleted_at` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '删除时间',
|
||
PRIMARY KEY (`id`) USING BTREE,
|
||
KEY `cx_mch_id` (`cx_mch_id`) USING BTREE,
|
||
KEY `user_id` (`user_id`) USING BTREE,
|
||
KEY `cx_mch_id_user_id_created_at` (`cx_mch_id`,`user_id`,`created_at`) USING BTREE,
|
||
KEY `cx_mch_id_user_id` (`cx_mch_id`,`user_id`,`is_delete`) USING BTREE
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='用户钱包明细';
|
||
|
||
-- 数据导出被取消选择。
|
||
|
||
-- 导出 表 cxaibc.cx_ball_cart 结构
|
||
CREATE TABLE IF NOT EXISTS `cx_ball_cart` (
|
||
`id` int(10) NOT NULL AUTO_INCREMENT,
|
||
`store_id` int(10) NOT NULL COMMENT '门店ID',
|
||
`mark_id` int(10) NOT NULL COMMENT '型号ID',
|
||
`name` varchar(50) NOT NULL COMMENT '球车名称',
|
||
`ball_number` varchar(50) NOT NULL COMMENT '球车编号',
|
||
`money` decimal(10,2) NOT NULL COMMENT '租赁金额',
|
||
`cover_pic` varchar(255) NOT NULL COMMENT '封面图',
|
||
`status` tinyint(4) NOT NULL DEFAULT '0' COMMENT '0-正常 1-租赁 2-停用',
|
||
`created_at` int(10) NOT NULL COMMENT '添加时间',
|
||
`updated_at` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '更新时间',
|
||
`is_delete` tinyint(4) DEFAULT '0' COMMENT '是否删除，0=否，1=是',
|
||
`deleted_at` int(10) DEFAULT '0' COMMENT '删除时间',
|
||
`content` text COMMENT '详情',
|
||
PRIMARY KEY (`id`)
|
||
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8;
|
||
|
||
-- 数据导出被取消选择。
|
||
|
||
-- 导出 表 cxaibc.cx_ball_mark 结构
|
||
CREATE TABLE IF NOT EXISTS `cx_ball_mark` (
|
||
`id` int(10) NOT NULL AUTO_INCREMENT,
|
||
`name` varchar(50) NOT NULL COMMENT '型号名称',
|
||
`desc` text COMMENT '型号描述',
|
||
`is_delete` tinyint(4) NOT NULL DEFAULT '0' COMMENT '是否删除，0=否，1=是',
|
||
`created_at` int(10) NOT NULL DEFAULT '0' COMMENT '添加时间',
|
||
`updated_at` int(10) NOT NULL DEFAULT '0' COMMENT '更新时间',
|
||
`deleted_at` int(10) NOT NULL DEFAULT '0' COMMENT '删除时间',
|
||
`status` tinyint(4) NOT NULL DEFAULT '1' COMMENT '是否启用，0=否，1=是',
|
||
PRIMARY KEY (`id`)
|
||
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
|
||
|
||
-- 数据导出被取消选择。
|
||
|
||
-- 导出 表 cxaibc.cx_banner 结构
|
||
CREATE TABLE IF NOT EXISTS `cx_banner` (
|
||
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
|
||
`cx_mch_id` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '平台商户ID',
|
||
`user_id` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '用户ID',
|
||
`zone_id` smallint(3) unsigned NOT NULL DEFAULT '0' COMMENT '位置ID',
|
||
`url_type` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '链接类型，0=小程序页面，1=外部链接，2=小程序',
|
||
`app_id` varchar(64) DEFAULT NULL COMMENT 'APP_ID',
|
||
`app_ext` varchar(1024) DEFAULT NULL COMMENT 'APP_EXT',
|
||
`img_url` varchar(2048) DEFAULT NULL COMMENT '图片',
|
||
`title` varchar(512) DEFAULT NULL COMMENT '标题',
|
||
`page_url` varchar(2048) DEFAULT NULL COMMENT '链接',
|
||
`sort` int(11) unsigned NOT NULL DEFAULT '100' COMMENT '排序',
|
||
`is_delete` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否删除',
|
||
`status` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '状态，0=隐藏，1=显示',
|
||
`created_at` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '添加时间',
|
||
`updated_at` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '更新时间',
|
||
`deleted_at` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '删除时间',
|
||
`media` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '媒体类型：0=图片，1=视频',
|
||
`video_url` varchar(2048) DEFAULT NULL COMMENT '视频',
|
||
PRIMARY KEY (`id`) USING BTREE,
|
||
KEY `cx_mch_id` (`cx_mch_id`) USING BTREE
|
||
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='轮播图';
|
||
|
||
-- 数据导出被取消选择。
|
||
|
||
-- 导出 表 cxaibc.cx_card_bank 结构
|
||
CREATE TABLE IF NOT EXISTS `cx_card_bank` (
|
||
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
|
||
`b_id` varchar(20) NOT NULL DEFAULT '' COMMENT '银联方编号',
|
||
`name` varchar(255) NOT NULL DEFAULT '' COMMENT '开户网点名称',
|
||
`b_start` varchar(50) DEFAULT '',
|
||
`b_end` varchar(50) DEFAULT '',
|
||
`created_at` int(10) unsigned DEFAULT '0',
|
||
`is_delete` tinyint(1) unsigned DEFAULT '0',
|
||
`deleted_at` int(10) unsigned DEFAULT '0',
|
||
PRIMARY KEY (`id`) USING BTREE,
|
||
KEY `b_id` (`b_id`) USING BTREE,
|
||
KEY `name` (`name`) USING BTREE,
|
||
KEY `is_delete` (`is_delete`) USING BTREE
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='银联开户网点';
|
||
|
||
-- 数据导出被取消选择。
|
||
|
||
-- 导出 表 cxaibc.cx_card_union 结构
|
||
CREATE TABLE IF NOT EXISTS `cx_card_union` (
|
||
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
|
||
`cx_mch_id` bigint(20) unsigned DEFAULT '0' COMMENT '平台商户id',
|
||
`card_number` varchar(255) NOT NULL COMMENT '银行号号',
|
||
`name` varchar(50) NOT NULL COMMENT '姓名',
|
||
`identity_number` varchar(255) NOT NULL COMMENT '证件号',
|
||
`mobile_phone` varchar(128) NOT NULL COMMENT '手机号',
|
||
`province_id` int(10) unsigned NOT NULL COMMENT '省id',
|
||
`city_id` int(10) unsigned NOT NULL COMMENT '市id',
|
||
`acct_bank_id` varchar(50) NOT NULL COMMENT '开户行别',
|
||
`bank_id` int(11) unsigned NOT NULL COMMENT '开户网点id',
|
||
`doc_pic` varchar(255) NOT NULL COMMENT '分账证明材料在本系统地址',
|
||
`doc_id` varchar(50) DEFAULT '' COMMENT '分账证明材料ID,接口返回',
|
||
`status` tinyint(1) DEFAULT '0' COMMENT '绑定状态0-未请求1-已请求2-已绑定',
|
||
`created_at` int(10) unsigned DEFAULT '0',
|
||
`is_delete` tinyint(1) unsigned DEFAULT '0',
|
||
`deleted_at` int(10) unsigned DEFAULT '0',
|
||
`apply_no` varchar(64) NOT NULL COMMENT '此值在商户侧唯一，用于【4.7分账接收方进件查询】查询申请单的信息',
|
||
PRIMARY KEY (`id`) USING BTREE,
|
||
KEY `province_id` (`province_id`) USING BTREE,
|
||
KEY `city_id` (`city_id`) USING BTREE,
|
||
KEY `cx_mch_id` (`cx_mch_id`) USING BTREE
|
||
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='银联银行卡';
|
||
|
||
-- 数据导出被取消选择。
|
||
|
||
-- 导出 表 cxaibc.cx_cart 结构
|
||
CREATE TABLE IF NOT EXISTS `cx_cart` (
|
||
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
|
||
`cx_mch_id` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '平台商户ID',
|
||
`user_id` bigint(20) unsigned NOT NULL COMMENT '用户ID',
|
||
`goods_id` bigint(20) unsigned NOT NULL COMMENT '商品ID',
|
||
`attr_id` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '规格ID',
|
||
`num` int(11) unsigned NOT NULL DEFAULT '1' COMMENT '数量',
|
||
`is_delete` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否删除',
|
||
`plugin_sign` varchar(50) DEFAULT NULL COMMENT '插件标识',
|
||
`created_at` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '添加时间',
|
||
`updated_at` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '更新时间',
|
||
`deleted_at` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '删除时间',
|
||
`attr_info` text COMMENT '规格信息，JSON',
|
||
PRIMARY KEY (`id`) USING BTREE,
|
||
KEY `user_id` (`user_id`) USING BTREE,
|
||
KEY `goods_id` (`goods_id`) USING BTREE,
|
||
KEY `search_index` (`cx_mch_id`,`user_id`,`is_delete`) USING BTREE
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='购物车';
|
||
|
||
-- 数据导出被取消选择。
|
||
|
||
-- 导出 表 cxaibc.cx_cash 结构
|
||
CREATE TABLE IF NOT EXISTS `cx_cash` (
|
||
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
|
||
`cx_mch_id` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '平台商户ID',
|
||
`scene` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '场景类型',
|
||
`user_id` bigint(20) unsigned NOT NULL COMMENT '用户ID',
|
||
`money` decimal(18,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '金额',
|
||
`service_charge` decimal(18,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '提现费用',
|
||
`order_no` varchar(64) NOT NULL COMMENT '订单号',
|
||
`status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '状态：0=待处理，1=已同意，2=已拒绝',
|
||
`transfer_status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '转账状态：0=待转账，1=已转账，2=拒绝转账',
|
||
`wechat_account` varchar(256) DEFAULT NULL COMMENT '微信账号',
|
||
`wechat_account_name` varchar(256) DEFAULT NULL COMMENT '微信账号持有者姓名',
|
||
`alipay_account` varchar(256) DEFAULT NULL COMMENT '支付宝账号',
|
||
`alipay_account_name` varchar(256) DEFAULT NULL COMMENT '支付宝账号持有者姓名',
|
||
`bank_name` varchar(256) DEFAULT NULL COMMENT '银行名称',
|
||
`bank_card_no` varchar(256) DEFAULT NULL COMMENT '银行卡号',
|
||
`bank_card_name` varchar(256) DEFAULT NULL COMMENT '银行卡持卡人姓名',
|
||
`cash_type` tinyint(1) unsigned DEFAULT '0' COMMENT '提现类型',
|
||
`pay_type` tinyint(1) unsigned DEFAULT '0' COMMENT '转账类型',
|
||
`pay_time` int(11) unsigned DEFAULT '0' COMMENT '转账时间',
|
||
`created_at` int(11) unsigned DEFAULT '0' COMMENT '添加时间',
|
||
`updated_at` int(11) unsigned DEFAULT '0' COMMENT '更新时间',
|
||
`deleted_at` int(11) unsigned DEFAULT '0' COMMENT '删除时间',
|
||
`is_delete` tinyint(1) unsigned DEFAULT '0' COMMENT '是否删除：0=否，1=是',
|
||
`review_time` int(11) unsigned DEFAULT NULL COMMENT '审核时间',
|
||
`review_comment` varchar(2048) DEFAULT NULL COMMENT '审核意见',
|
||
`remark` varchar(2048) DEFAULT NULL COMMENT '备注',
|
||
PRIMARY KEY (`id`) USING BTREE,
|
||
KEY `cx_mch_id` (`cx_mch_id`) USING BTREE,
|
||
KEY `index1` (`cx_mch_id`,`user_id`,`is_delete`) USING BTREE,
|
||
KEY `index2` (`cx_mch_id`,`user_id`,`status`,`transfer_status`,`is_delete`) USING BTREE
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='提现记录';
|
||
|
||
-- 数据导出被取消选择。
|
||
|
||
-- 导出 表 cxaibc.cx_cash_setting 结构
|
||
CREATE TABLE IF NOT EXISTS `cx_cash_setting` (
|
||
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
|
||
`cx_mch_id` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '平台商户ID',
|
||
`scene` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '场景类型',
|
||
`cash_types` text NOT NULL COMMENT '提现类型',
|
||
`min_cash` decimal(18,2) NOT NULL DEFAULT '0.00' COMMENT '最低提现金额',
|
||
`max_cash` decimal(18,2) NOT NULL DEFAULT '0.00' COMMENT '最高提现金额',
|
||
`day_max_cash` decimal(18,2) NOT NULL DEFAULT '0.00' COMMENT '每日最高提现金额',
|
||
`service_charge` decimal(18,2) NOT NULL DEFAULT '0.00' COMMENT '提现费率(百分比)',
|
||
PRIMARY KEY (`id`) USING BTREE,
|
||
KEY `cx_mch_id` (`cx_mch_id`) USING BTREE
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='提现设置';
|
||
|
||
-- 数据导出被取消选择。
|
||
|
||
-- 导出 表 cxaibc.cx_cat 结构
|
||
CREATE TABLE IF NOT EXISTS `cx_cat` (
|
||
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
|
||
`cx_mch_id` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '平台商户ID',
|
||
`type` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '类型',
|
||
`name` varchar(128) NOT NULL COMMENT '名称',
|
||
`desc` varchar(256) DEFAULT NULL COMMENT '描述',
|
||
`img_url` varchar(2048) DEFAULT NULL COMMENT '图片',
|
||
`parent_id` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '父ID',
|
||
`sort` int(11) unsigned NOT NULL DEFAULT '100' COMMENT '排序，默认100，升序',
|
||
`is_delete` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否删除，0=否，1=是',
|
||
`created_at` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '添加时间',
|
||
`updated_at` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '更新时间',
|
||
`deleted_at` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '删除时间',
|
||
`status` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否启用，0=否，1=是',
|
||
`is_hide` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否隐藏，0=否，1=是',
|
||
`big_img_url` varchar(2048) DEFAULT NULL COMMENT '大图',
|
||
`advert_pic` varchar(2048) DEFAULT NULL COMMENT '广告图',
|
||
`advert_url` varchar(2048) DEFAULT NULL COMMENT '广告链接',
|
||
`advert_url_type` tinyint(1) unsigned DEFAULT '0' COMMENT '广告链接类型',
|
||
`advert_open_params` varchar(2048) DEFAULT NULL COMMENT '广告链接打开参数',
|
||
PRIMARY KEY (`id`) USING BTREE,
|
||
KEY `cx_mch_id` (`cx_mch_id`) USING BTREE,
|
||
KEY `parent_id` (`parent_id`) USING BTREE,
|
||
KEY `search_index` (`type`,`is_delete`,`status`,`is_hide`) USING BTREE
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='分类标签';
|
||
|
||
-- 数据导出被取消选择。
|
||
|
||
-- 导出 表 cxaibc.cx_chart 结构
|
||
CREATE TABLE IF NOT EXISTS `cx_chart` (
|
||
`id` int(10) NOT NULL AUTO_INCREMENT,
|
||
`img_url` varchar(512) DEFAULT NULL COMMENT '图片地址',
|
||
`title` varchar(255) DEFAULT NULL COMMENT '标题',
|
||
`sort` int(10) DEFAULT '1' COMMENT '排序',
|
||
`is_delete` tinyint(4) NOT NULL DEFAULT '0' COMMENT '是否删除',
|
||
`status` tinyint(4) NOT NULL DEFAULT '1' COMMENT '状态，0=隐藏，1=显示',
|
||
`created_at` int(10) NOT NULL DEFAULT '0' COMMENT '添加时间',
|
||
`updated_at` int(10) NOT NULL DEFAULT '0' COMMENT '修改时间',
|
||
`deleted_at` int(10) NOT NULL DEFAULT '0' COMMENT '删除时间',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
|
||
|
||
-- 数据导出被取消选择。
|
||
|
||
-- 导出 表 cxaibc.cx_cms_notice 结构
|
||
CREATE TABLE IF NOT EXISTS `cx_cms_notice` (
|
||
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
|
||
`cx_mch_id` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '平台商户ID',
|
||
`rich_text_id` bigint(20) unsigned NOT NULL COMMENT '富文本ID',
|
||
`sort` int(11) unsigned NOT NULL DEFAULT '100' COMMENT '排序，默认100，升序',
|
||
`status` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '状态：0=草稿，1=已发布，2=回收站',
|
||
`is_top` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否置顶：0=否，1=是',
|
||
`is_index` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否首页展示：0=否，1=是',
|
||
`viewed_num` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '浏览量',
|
||
`created_at` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '添加时间',
|
||
`updated_at` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '更新时间',
|
||
`published_at` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '发布时间',
|
||
`is_delete` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否删除：0=否，1=是',
|
||
`deleted_at` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '删除时间',
|
||
PRIMARY KEY (`id`) USING BTREE,
|
||
KEY `index1` (`cx_mch_id`,`is_delete`) USING BTREE,
|
||
KEY `is_top` (`is_top`) USING BTREE,
|
||
KEY `is_index` (`is_index`) USING BTREE
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='公告';
|
||
|
||
-- 数据导出被取消选择。
|
||
|
||
-- 导出 表 cxaibc.cx_cms_page 结构
|
||
CREATE TABLE IF NOT EXISTS `cx_cms_page` (
|
||
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
|
||
`cx_mch_id` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '平台商户ID',
|
||
`rich_text_id` bigint(20) unsigned NOT NULL COMMENT '富文本ID',
|
||
`sort` int(11) unsigned NOT NULL DEFAULT '100' COMMENT '排序，默认100，升序',
|
||
`status` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '状态：0=草稿，1=已发布，2=回收站',
|
||
`is_top` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否置顶：0=否，1=是',
|
||
`allow_read` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '是否允许阅读：0=否，1=是',
|
||
`password` varchar(256) DEFAULT NULL COMMENT '访问密码',
|
||
`url_alias` varchar(512) DEFAULT NULL COMMENT 'URL别名',
|
||
`viewed_num` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '浏览量',
|
||
`created_at` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '添加时间',
|
||
`updated_at` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '更新时间',
|
||
`published_at` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '发布时间',
|
||
`is_delete` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否删除：0=否，1=是',
|
||
`deleted_at` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '删除时间',
|
||
PRIMARY KEY (`id`) USING BTREE,
|
||
KEY `index1` (`cx_mch_id`,`rich_text_id`,`status`,`is_delete`) USING BTREE
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='页面';
|
||
|
||
-- 数据导出被取消选择。
|
||
|
||
-- 导出 表 cxaibc.cx_cms_post 结构
|
||
CREATE TABLE IF NOT EXISTS `cx_cms_post` (
|
||
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
|
||
`cx_mch_id` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '平台商户ID',
|
||
`scene` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '场景：0=默认',
|
||
`rich_text_id` bigint(20) unsigned NOT NULL COMMENT '富文本ID',
|
||
`sort` int(11) unsigned NOT NULL DEFAULT '100' COMMENT '排序，默认100，升序',
|
||
`status` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '状态：0=草稿，1=已发布，2=回收站',
|
||
`is_top` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否置顶：0=否，1=是',
|
||
`allow_read` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '是否允许阅读：0=否，1=是',
|
||
`password` varchar(256) DEFAULT NULL COMMENT '访问密码',
|
||
`url_alias` varchar(512) DEFAULT NULL COMMENT 'URL别名',
|
||
`viewed_num` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '浏览量',
|
||
`created_at` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '添加时间',
|
||
`updated_at` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '更新时间',
|
||
`published_at` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '发布时间',
|
||
`is_delete` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否删除：0=否，1=是',
|
||
`deleted_at` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '删除时间',
|
||
PRIMARY KEY (`id`) USING BTREE,
|
||
KEY `index1` (`cx_mch_id`,`rich_text_id`,`status`,`is_delete`,`scene`) USING BTREE
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='文章';
|
||
|
||
-- 数据导出被取消选择。
|
||
|
||
-- 导出 表 cxaibc.cx_cms_post_meta 结构
|
||
CREATE TABLE IF NOT EXISTS `cx_cms_post_meta` (
|
||
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
|
||
`cx_mch_id` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '平台商户ID',
|
||
`type` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '类型：0=分类',
|
||
`post_id` bigint(20) unsigned NOT NULL COMMENT '文章ID',
|
||
`key` varchar(50) DEFAULT NULL COMMENT 'KEY',
|
||
`value` varchar(256) DEFAULT NULL COMMENT 'VALUE',
|
||
`created_at` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '添加时间',
|
||
`updated_at` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '更新时间',
|
||
`is_delete` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否删除：0=否，1=是',
|
||
`deleted_at` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '删除时间',
|
||
PRIMARY KEY (`id`) USING BTREE,
|
||
KEY `cx_mch_id` (`cx_mch_id`) USING BTREE,
|
||
KEY `index1` (`cx_mch_id`,`type`,`post_id`,`is_delete`) USING BTREE
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='文章关联表';
|
||
|
||
-- 数据导出被取消选择。
|
||
|
||
-- 导出 表 cxaibc.cx_cms_rich_text 结构
|
||
CREATE TABLE IF NOT EXISTS `cx_cms_rich_text` (
|
||
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
|
||
`cx_mch_id` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '平台商户ID',
|
||
`title` varchar(512) NOT NULL COMMENT '标题',
|
||
`author` varchar(128) DEFAULT NULL COMMENT '作者',
|
||
`summary` varchar(2048) DEFAULT NULL COMMENT '摘要',
|
||
`cover_url` varchar(2048) DEFAULT NULL COMMENT '封面',
|
||
`content` longtext NOT NULL COMMENT '内容',
|
||
`created_at` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '添加时间',
|
||
`updated_at` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '更新时间',
|
||
`is_delete` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否删除：0=否，1=是',
|
||
`deleted_at` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '删除时间',
|
||
PRIMARY KEY (`id`) USING BTREE,
|
||
KEY `index1` (`cx_mch_id`,`is_delete`) USING BTREE
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='富文本';
|
||
|
||
-- 数据导出被取消选择。
|
||
|
||
-- 导出 表 cxaibc.cx_coach 结构
|
||
CREATE TABLE IF NOT EXISTS `cx_coach` (
|
||
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
|
||
`mobile_phone` varchar(128) NOT NULL COMMENT '教练手机号',
|
||
`title` varchar(50) DEFAULT NULL COMMENT '头衔',
|
||
`content` text COMMENT '教练介绍',
|
||
`coache_begin_time` int(10) NOT NULL COMMENT '开始执教时间',
|
||
`coach_photo` varchar(2048) DEFAULT NULL COMMENT '教练照片',
|
||
`qualification` varchar(2048) DEFAULT NULL COMMENT '资格证书',
|
||
`status` tinyint(4) NOT NULL DEFAULT '1' COMMENT '状态 1-正常 0-关闭',
|
||
`store_id` int(10) NOT NULL COMMENT '门店ID',
|
||
`created_at` int(10) NOT NULL DEFAULT '0' COMMENT '添加时间',
|
||
`updated_at` int(10) NOT NULL DEFAULT '0' COMMENT '修改时间',
|
||
`is_delete` int(10) NOT NULL DEFAULT '0' COMMENT '是否删除，0=否，1=是',
|
||
`deleted_at` int(10) NOT NULL DEFAULT '0' COMMENT '删除时间',
|
||
`number` char(50) NOT NULL COMMENT '教练编号',
|
||
`user_id` bigint(20) unsigned NOT NULL COMMENT '用户id',
|
||
`desc` varchar(255) DEFAULT '' COMMENT '简介',
|
||
PRIMARY KEY (`id`) USING BTREE,
|
||
KEY `store_id` (`store_id`) USING BTREE,
|
||
KEY `user_id` (`user_id`) USING BTREE
|
||
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='教练表';
|
||
|
||
-- 数据导出被取消选择。
|
||
|
||
-- 导出 表 cxaibc.cx_coach_review 结构
|
||
CREATE TABLE IF NOT EXISTS `cx_coach_review` (
|
||
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
|
||
`mobile_phone` varchar(128) NOT NULL COMMENT '教练手机号',
|
||
`title` varchar(50) DEFAULT NULL COMMENT '头衔',
|
||
`content` text COMMENT '教练介绍',
|
||
`coache_begin_time` int(10) NOT NULL COMMENT '开始执教时间',
|
||
`coach_photo` varchar(2048) DEFAULT NULL COMMENT '教练照片',
|
||
`qualification` varchar(2048) DEFAULT NULL COMMENT '资格证书',
|
||
`status` tinyint(4) NOT NULL DEFAULT '1' COMMENT '状态 1-正常 0-关闭',
|
||
`store_id` int(10) NOT NULL COMMENT '门店ID',
|
||
`created_at` int(10) NOT NULL DEFAULT '0' COMMENT '添加时间',
|
||
`updated_at` int(10) NOT NULL DEFAULT '0' COMMENT '修改时间',
|
||
`is_delete` int(10) NOT NULL DEFAULT '0' COMMENT '是否删除，0=否，1=是',
|
||
`deleted_at` int(10) NOT NULL DEFAULT '0' COMMENT '删除时间',
|
||
`number` char(50) NOT NULL COMMENT '教练编号',
|
||
`user_id` bigint(20) unsigned DEFAULT '0' COMMENT '用户id',
|
||
`status_review` tinyint(1) unsigned DEFAULT '0' COMMENT '审核状态0未提交审核 1待审核 2通过 3驳回',
|
||
`status_desc` text COMMENT '审核建议',
|
||
`status_time` int(10) unsigned DEFAULT '0' COMMENT '审核时间',
|
||
`desc` varchar(255) DEFAULT '' COMMENT '教练简介',
|
||
PRIMARY KEY (`id`) USING BTREE,
|
||
KEY `store_id` (`store_id`) USING BTREE,
|
||
KEY `user_id` (`user_id`) USING BTREE
|
||
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='教练审核表';
|
||
|
||
-- 数据导出被取消选择。
|
||
|
||
-- 导出 表 cxaibc.cx_comment 结构
|
||
CREATE TABLE IF NOT EXISTS `cx_comment` (
|
||
`id` int(10) NOT NULL AUTO_INCREMENT,
|
||
`user_id` int(10) NOT NULL COMMENT '评论人ID',
|
||
`to_user_id` int(10) NOT NULL COMMENT '被评价人ID',
|
||
`level` tinyint(4) NOT NULL DEFAULT '0' COMMENT '星级-学员评价的时候才有',
|
||
`store_id` int(10) NOT NULL COMMENT '门店ID',
|
||
`content` text NOT NULL COMMENT '评价内容',
|
||
`device_id` int(10) NOT NULL COMMENT '场次ID',
|
||
`created_at` int(10) DEFAULT NULL COMMENT '时间戳',
|
||
`is_delete` tinyint(4) NOT NULL DEFAULT '0' COMMENT '是否删除',
|
||
`deleted_at` int(10) NOT NULL DEFAULT '0' COMMENT '删除时间',
|
||
`type` tinyint(4) NOT NULL COMMENT '评价类型 1-学员评价 2-教练评价',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
|
||
|
||
-- 数据导出被取消选择。
|
||
|
||
-- 导出 表 cxaibc.cx_coupon 结构
|
||
CREATE TABLE IF NOT EXISTS `cx_coupon` (
|
||
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
|
||
`title` varchar(50) NOT NULL COMMENT '卡券标题',
|
||
`start_time` int(10) unsigned NOT NULL COMMENT '开始时间',
|
||
`end_time` int(10) unsigned NOT NULL COMMENT '结束时间',
|
||
`price` decimal(20,2) unsigned DEFAULT '0.00' COMMENT '金额',
|
||
`num` int(10) DEFAULT '-1' COMMENT '发放数量,负数为不限量',
|
||
`type` int(10) unsigned NOT NULL COMMENT '类型0=体验券1=立减券',
|
||
`vehicle_ids` varchar(255) DEFAULT '' COMMENT '指定球车使用，为空则不限制',
|
||
`created_at` int(10) unsigned DEFAULT '0',
|
||
`updated_at` int(10) unsigned DEFAULT '0',
|
||
`is_delete` tinyint(1) unsigned DEFAULT '0',
|
||
`deleted_at` int(10) unsigned DEFAULT '0',
|
||
`get_start_time` int(10) unsigned DEFAULT '0' COMMENT '领取开始时间',
|
||
`get_end_time` int(10) unsigned DEFAULT '0' COMMENT '领取结束时间',
|
||
`get_num` int(10) unsigned DEFAULT '0' COMMENT '领取数量',
|
||
`store_ids` varchar(50) DEFAULT '' COMMENT '可使用门店id',
|
||
`user_get_num` int(50) unsigned DEFAULT '1' COMMENT '用户可领取数量',
|
||
PRIMARY KEY (`id`)
|
||
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8 COMMENT='卡券';
|
||
|
||
-- 数据导出被取消选择。
|
||
|
||
-- 导出 表 cxaibc.cx_detection 结构
|
||
CREATE TABLE IF NOT EXISTS `cx_detection` (
|
||
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
|
||
`name` varchar(50) NOT NULL DEFAULT '' COMMENT '检测员名称',
|
||
`store_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '门店id',
|
||
`user_id` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '用户id',
|
||
`created_at` int(10) unsigned DEFAULT '0',
|
||
`updated_at` int(10) unsigned DEFAULT '0',
|
||
`is_delete` tinyint(1) unsigned DEFAULT '0',
|
||
`deleted_at` int(11) unsigned DEFAULT '0',
|
||
PRIMARY KEY (`id`) USING BTREE,
|
||
KEY `store_id` (`store_id`) USING BTREE,
|
||
KEY `user_id` (`user_id`) USING BTREE,
|
||
KEY `name` (`name`) USING BTREE
|
||
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='检测员';
|
||
|
||
-- 数据导出被取消选择。
|
||
|
||
-- 导出 表 cxaibc.cx_district 结构
|
||
CREATE TABLE IF NOT EXISTS `cx_district` (
|
||
`id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
|
||
`parent_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '父级ID',
|
||
`code` varchar(32) NOT NULL COMMENT '区划代码',
|
||
`name` varchar(64) NOT NULL COMMENT '名称',
|
||
`level` varchar(16) NOT NULL COMMENT '层级',
|
||
`created_at` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '添加时间',
|
||
`is_delete` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '是否删除',
|
||
`initial` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '首字母',
|
||
`initials` varchar(50) DEFAULT NULL COMMENT '拼音首字母',
|
||
PRIMARY KEY (`id`) USING BTREE,
|
||
KEY `code` (`code`) USING BTREE,
|
||
KEY `parent_id` (`parent_id`) USING BTREE,
|
||
KEY `name` (`name`) USING BTREE,
|
||
KEY `index1` (`level`,`is_delete`) USING BTREE
|
||
) ENGINE=InnoDB AUTO_INCREMENT=44897 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='行政区域|2020';
|
||
|
||
-- 数据导出被取消选择。
|
||
|
||
-- 导出 表 cxaibc.cx_faq 结构
|
||
CREATE TABLE IF NOT EXISTS `cx_faq` (
|
||
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
|
||
`cx_mch_id` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '平台商户ID',
|
||
`title` varchar(256) NOT NULL COMMENT '标题',
|
||
`content` longtext NOT NULL COMMENT '内容',
|
||
`created_at` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '添加时间',
|
||
`updated_at` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '更新时间',
|
||
`is_delete` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否删除',
|
||
`deleted_at` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '删除时间',
|
||
`status` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '状态：0=草稿，1=已发布，2=回收站',
|
||
`published_at` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '发布时间',
|
||
`sort` int(11) unsigned NOT NULL DEFAULT '100' COMMENT '排序：默认100，升序',
|
||
`is_hot` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否热门：0=否，1=是',
|
||
PRIMARY KEY (`id`) USING BTREE,
|
||
KEY `index1` (`cx_mch_id`,`is_delete`,`status`) USING BTREE,
|
||
KEY `index2` (`cx_mch_id`,`is_delete`) USING BTREE
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='帮助文档';
|
||
|
||
-- 数据导出被取消选择。
|
||
|
||
-- 导出 表 cxaibc.cx_faq_meta 结构
|
||
CREATE TABLE IF NOT EXISTS `cx_faq_meta` (
|
||
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
|
||
`cx_mch_id` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '平台商户ID',
|
||
`type` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '类型：0=分类，1=浏览量',
|
||
`faq_id` bigint(20) unsigned NOT NULL COMMENT '帮助ID',
|
||
`key` varchar(50) DEFAULT NULL COMMENT 'KEY',
|
||
`value` varchar(256) DEFAULT NULL COMMENT 'VALUE',
|
||
`created_at` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '添加时间',
|
||
`updated_at` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '更新时间',
|
||
`is_delete` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否删除：0=否，1=是',
|
||
`deleted_at` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '删除时间',
|
||
PRIMARY KEY (`id`) USING BTREE,
|
||
KEY `cx_mch_id` (`cx_mch_id`) USING BTREE,
|
||
KEY `index1` (`cx_mch_id`,`type`,`faq_id`,`is_delete`) USING BTREE
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='帮助文档关联表';
|
||
|
||
-- 数据导出被取消选择。
|
||
|
||
-- 导出 表 cxaibc.cx_feedback 结构
|
||
CREATE TABLE IF NOT EXISTS `cx_feedback` (
|
||
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
|
||
`cx_mch_id` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '平台商户ID',
|
||
`user_id` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '用户ID',
|
||
`cat_id` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '分类ID',
|
||
`contact` varchar(64) DEFAULT NULL COMMENT '联系方式：QQ|手机号',
|
||
`content` varchar(2048) NOT NULL COMMENT '反馈内容',
|
||
`pic_list` text COMMENT '反馈图片',
|
||
`created_at` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '添加时间',
|
||
`updated_at` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '更新时间',
|
||
`is_delete` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否删除：0=否，1=是 ',
|
||
`deleted_at` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '删除时间',
|
||
`review_user_id` bigint(20) unsigned NOT NULL COMMENT '处理人ID',
|
||
`review_status` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '处理状态：0=待处理，1=已处理',
|
||
`review_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '处理时间',
|
||
`review_comment` varchar(2048) DEFAULT NULL COMMENT '处理意见',
|
||
PRIMARY KEY (`id`) USING BTREE,
|
||
KEY `index2` (`is_delete`,`cx_mch_id`,`cat_id`) USING BTREE,
|
||
KEY `index1` (`cx_mch_id`,`is_delete`) USING BTREE,
|
||
KEY `index3` (`cx_mch_id`,`user_id`,`is_delete`) USING BTREE
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='意见反馈';
|
||
|
||
-- 数据导出被取消选择。
|
||
|
||
-- 导出 表 cxaibc.cx_file_group 结构
|
||
CREATE TABLE IF NOT EXISTS `cx_file_group` (
|
||
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
|
||
`cx_mch_id` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '平台商户ID',
|
||
`user_id` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '用户ID',
|
||
`name` varchar(512) NOT NULL COMMENT '名称',
|
||
`is_default` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '是否默认',
|
||
`is_delete` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '是否删除',
|
||
`created_at` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '添加时间',
|
||
PRIMARY KEY (`id`) USING BTREE,
|
||
KEY `user_id` (`user_id`) USING BTREE,
|
||
KEY `is_default` (`is_default`) USING BTREE,
|
||
KEY `is_delete` (`is_delete`) USING BTREE,
|
||
KEY `cx_mch_id` (`cx_mch_id`) USING BTREE
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='文件组';
|
||
|
||
-- 数据导出被取消选择。
|
||
|
||
-- 导出 表 cxaibc.cx_goods 结构
|
||
CREATE TABLE IF NOT EXISTS `cx_goods` (
|
||
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
|
||
`cx_mch_id` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '平台商户ID',
|
||
`goods_hub_id` bigint(20) unsigned NOT NULL COMMENT '商品库ID',
|
||
`status` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '上架状态：0=下架，1=上架',
|
||
`price` decimal(18,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '售价',
|
||
`use_attr` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '是否使用规格：0=不使用，1=使用',
|
||
`attr_groups` text CHARACTER SET utf8 NOT NULL COMMENT '商品规格组',
|
||
`goods_stock` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '商品库存',
|
||
`virtual_sales` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '已出售量',
|
||
`confine_count` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '购物数量限制，0=不限制',
|
||
`freight_id` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '运费模板ID',
|
||
`plugin_sign` varchar(255) DEFAULT NULL COMMENT '插件标识',
|
||
`sort` int(11) unsigned NOT NULL DEFAULT '100' COMMENT '排序',
|
||
`created_at` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '添加时间',
|
||
`updated_at` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '更新时间',
|
||
`deleted_at` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '删除时间',
|
||
`is_delete` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否删除：0=否，1=是',
|
||
`payment_people` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '支付人数',
|
||
`payment_num` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '支付件数',
|
||
`payment_amount` decimal(18,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '支付金额',
|
||
`payment_order` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '支付订单数',
|
||
`sales` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '商品实际销量',
|
||
`viewed_count` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '详情浏览量统计',
|
||
PRIMARY KEY (`id`) USING BTREE,
|
||
KEY `cx_mch_id` (`cx_mch_id`) USING BTREE,
|
||
KEY `goods_hub_id` (`goods_hub_id`) USING BTREE,
|
||
KEY `index1` (`cx_mch_id`,`goods_hub_id`,`status`,`is_delete`) USING BTREE,
|
||
KEY `index2` (`cx_mch_id`,`status`,`is_delete`) USING BTREE
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='商品通用信息表';
|
||
|
||
-- 数据导出被取消选择。
|
||
|
||
-- 导出 表 cxaibc.cx_goods_attr 结构
|
||
CREATE TABLE IF NOT EXISTS `cx_goods_attr` (
|
||
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
|
||
`cx_mch_id` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '平台商户ID',
|
||
`goods_id` bigint(20) unsigned NOT NULL COMMENT '商品ID',
|
||
`sign_id` varchar(255) NOT NULL DEFAULT '' COMMENT '规格ID标识，规格：规格值',
|
||
`stock` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '库存',
|
||
`price` decimal(18,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '价格',
|
||
`serial_no` varchar(255) DEFAULT NULL COMMENT '货号',
|
||
`weight` int(11) NOT NULL DEFAULT '0' COMMENT '重量（克）',
|
||
`cover_pic` varchar(255) DEFAULT NULL COMMENT '规格图片',
|
||
`is_delete` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否删除，0=否，1=是',
|
||
PRIMARY KEY (`id`) USING BTREE,
|
||
KEY `goods_id` (`goods_id`) USING BTREE,
|
||
KEY `is_delete` (`is_delete`) USING BTREE,
|
||
KEY `cx_mch_id` (`cx_mch_id`) USING BTREE,
|
||
KEY `index1` (`is_delete`,`goods_id`,`cx_mch_id`) USING BTREE
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='商品规格';
|
||
|
||
-- 数据导出被取消选择。
|
||
|
||
-- 导出 表 cxaibc.cx_goods_cat 结构
|
||
CREATE TABLE IF NOT EXISTS `cx_goods_cat` (
|
||
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
|
||
`goods_hub_id` bigint(20) unsigned NOT NULL COMMENT '商品库ID',
|
||
`cat_id` bigint(20) unsigned NOT NULL COMMENT '分类ID',
|
||
`is_delete` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否删除，0=否，1=是',
|
||
PRIMARY KEY (`id`) USING BTREE,
|
||
KEY `goods_hub_id` (`goods_hub_id`) USING BTREE,
|
||
KEY `cat_id` (`cat_id`) USING BTREE
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='商品关联分类';
|
||
|
||
-- 数据导出被取消选择。
|
||
|
||
-- 导出 表 cxaibc.cx_goods_hub 结构
|
||
CREATE TABLE IF NOT EXISTS `cx_goods_hub` (
|
||
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
|
||
`cx_mch_id` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '平台商户ID',
|
||
`name` varchar(255) NOT NULL COMMENT '商品名称',
|
||
`subtitle` varchar(255) DEFAULT NULL COMMENT '副标题',
|
||
`original_price` decimal(18,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '原价',
|
||
`cost_price` decimal(18,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '成本价',
|
||
`detail` longtext NOT NULL COMMENT '商品详情，图文',
|
||
`cover_pic` varchar(255) NOT NULL COMMENT '商品缩略图',
|
||
`pic_urls` text COMMENT '商品轮播图',
|
||
`video_url` varchar(255) DEFAULT NULL COMMENT '商品视频',
|
||
`unit` varchar(255) NOT NULL DEFAULT '件' COMMENT '单位',
|
||
`created_at` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '添加时间',
|
||
`updated_at` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '更新时间',
|
||
`deleted_at` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '删除时间',
|
||
`is_delete` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否删除，0=否，1=是',
|
||
`type` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '商品类型：0=实体商品 ',
|
||
PRIMARY KEY (`id`) USING BTREE,
|
||
KEY `cx_mch_id` (`cx_mch_id`) USING BTREE,
|
||
KEY `search_index` (`cx_mch_id`,`is_delete`) USING BTREE
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='商品';
|
||
|
||
-- 数据导出被取消选择。
|
||
|
||
-- 导出 表 cxaibc.cx_integral 结构
|
||
CREATE TABLE IF NOT EXISTS `cx_integral` (
|
||
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
|
||
`cx_mch_id` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '平台商户ID',
|
||
`scene` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '场景类型',
|
||
`user_id` bigint(20) unsigned NOT NULL COMMENT '用户ID',
|
||
`account_integral` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '账户积分',
|
||
`account_total_integral` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '累计积分',
|
||
`created_at` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '添加时间',
|
||
`reset_at` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '重置时间',
|
||
`updated_at` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '更新时间',
|
||
`deleted_at` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '删除时间',
|
||
`is_delete` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否删除：0=否，1=是',
|
||
PRIMARY KEY (`id`) USING BTREE,
|
||
KEY `cx_mch_id` (`cx_mch_id`) USING BTREE,
|
||
KEY `user_id` (`user_id`) USING BTREE,
|
||
KEY `cx_mch_id_user_id_is_delete` (`cx_mch_id`,`user_id`,`is_delete`) USING BTREE
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='用户积分';
|
||
|
||
-- 数据导出被取消选择。
|
||
|
||
-- 导出 表 cxaibc.cx_integral_log 结构
|
||
CREATE TABLE IF NOT EXISTS `cx_integral_log` (
|
||
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
|
||
`cx_mch_id` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '平台商户ID',
|
||
`scene` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '场景类型',
|
||
`type` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '类型：1=收入，2=支出',
|
||
`user_id` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '用户ID',
|
||
`integral` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '积分',
|
||
`before_account_integral` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '变化前账户积分',
|
||
`after_account_integral` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '变化后账户积分',
|
||
`desc` varchar(2048) DEFAULT NULL COMMENT '描述',
|
||
`order_type` smallint(2) unsigned NOT NULL DEFAULT '0' COMMENT '订单类型',
|
||
`order_no` varchar(128) DEFAULT NULL COMMENT '订单号',
|
||
`ext` text COMMENT '扩展信息',
|
||
`created_at` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '添加时间',
|
||
PRIMARY KEY (`id`) USING BTREE,
|
||
KEY `cx_mch_id` (`cx_mch_id`) USING BTREE,
|
||
KEY `user_id` (`user_id`) USING BTREE,
|
||
KEY `cx_mch_id_user_id` (`cx_mch_id`,`user_id`) USING BTREE,
|
||
KEY `cx_mch_id_user_id_created_at` (`cx_mch_id`,`user_id`,`created_at`) USING BTREE
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='用户积分明细';
|
||
|
||
-- 数据导出被取消选择。
|
||
|
||
-- 导出 表 cxaibc.cx_integral_mall_goods 结构
|
||
CREATE TABLE IF NOT EXISTS `cx_integral_mall_goods` (
|
||
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
|
||
`cx_mch_id` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '平台商户ID',
|
||
`goods_id` bigint(20) unsigned NOT NULL COMMENT '商品ID',
|
||
`integral_num` int(11) unsigned NOT NULL COMMENT '所需积分',
|
||
`created_at` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '添加时间',
|
||
`updated_at` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '更新时间',
|
||
`is_delete` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否删除：0=否，1=是',
|
||
`deleted_at` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '删除时间',
|
||
PRIMARY KEY (`id`) USING BTREE,
|
||
KEY `cx_mch_id_is_delete` (`cx_mch_id`,`is_delete`) USING BTREE,
|
||
KEY `cx_mch_id_goods_id_is_delete` (`cx_mch_id`,`goods_id`,`is_delete`) USING BTREE
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='积分商城商品';
|
||
|
||
-- 数据导出被取消选择。
|
||
|
||
-- 导出 表 cxaibc.cx_integral_mall_goods_attr 结构
|
||
CREATE TABLE IF NOT EXISTS `cx_integral_mall_goods_attr` (
|
||
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
|
||
`cx_mch_id` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '平台商户ID',
|
||
`goods_id` bigint(20) unsigned NOT NULL COMMENT '商品ID',
|
||
`goods_attr_id` bigint(20) unsigned NOT NULL COMMENT '商品规格ID',
|
||
`integral_num` int(11) unsigned NOT NULL COMMENT '所需积分',
|
||
`created_at` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '添加时间',
|
||
`updated_at` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '更新时间',
|
||
`is_delete` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否删除：0=否，1=是',
|
||
`deleted_at` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '删除时间',
|
||
PRIMARY KEY (`id`) USING BTREE,
|
||
KEY `cx_mch_id_goods_id_goods_attr_id_is_delete` (`cx_mch_id`,`goods_id`,`goods_attr_id`,`is_delete`) USING BTREE
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='积分商城商品规格';
|
||
|
||
-- 数据导出被取消选择。
|
||
|
||
-- 导出 表 cxaibc.cx_integral_mall_order 结构
|
||
CREATE TABLE IF NOT EXISTS `cx_integral_mall_order` (
|
||
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
|
||
`cx_mch_id` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '平台商户ID',
|
||
`order_id` bigint(20) unsigned NOT NULL COMMENT '订单ID',
|
||
`integral_num` int(11) unsigned NOT NULL COMMENT '所需积分',
|
||
`created_at` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '添加时间',
|
||
`is_delete` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否删除：0=否，1=是',
|
||
`deleted_at` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '删除时间',
|
||
PRIMARY KEY (`id`) USING BTREE,
|
||
KEY `cx_mch_id_is_delete` (`cx_mch_id`,`is_delete`) USING BTREE,
|
||
KEY `cx_mch_id_goods_id_is_delete` (`cx_mch_id`,`order_id`,`is_delete`) USING BTREE
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='积分商城订单';
|
||
|
||
-- 数据导出被取消选择。
|
||
|
||
-- 导出 表 cxaibc.cx_msg_centre 结构
|
||
CREATE TABLE IF NOT EXISTS `cx_msg_centre` (
|
||
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
|
||
`type` tinyint(1) unsigned DEFAULT '1' COMMENT '1=租赁消息2=归还消息3=售后消息4=报警消息',
|
||
`title` varchar(50) DEFAULT '' COMMENT '标题',
|
||
`content` longtext COMMENT '消息内容',
|
||
`user_id` bigint(20) unsigned DEFAULT '0',
|
||
`is_admin_send` tinyint(1) unsigned DEFAULT '0' COMMENT '是否系统消息',
|
||
`created_at` int(10) unsigned DEFAULT '0',
|
||
`object_id` bigint(20) unsigned DEFAULT '0' COMMENT '默认订单id',
|
||
PRIMARY KEY (`id`),
|
||
KEY `type` (`type`),
|
||
KEY `user_id` (`user_id`)
|
||
) ENGINE=InnoDB AUTO_INCREMENT=788 DEFAULT CHARSET=utf8 COMMENT='消息中心';
|
||
|
||
-- 数据导出被取消选择。
|
||
|
||
-- 导出 表 cxaibc.cx_option 结构
|
||
CREATE TABLE IF NOT EXISTS `cx_option` (
|
||
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
|
||
`cx_mch_id` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '平台商户ID',
|
||
`key` varchar(2048) NOT NULL COMMENT '键',
|
||
`value` longtext NOT NULL COMMENT '值',
|
||
`group` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '组，0=系统配置，1=安全配置，2=自定义配置',
|
||
`is_autoload` smallint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否自动加载，0=否，1=是',
|
||
`desc` varchar(2048) DEFAULT NULL COMMENT '描述',
|
||
PRIMARY KEY (`id`) USING BTREE,
|
||
KEY `cx_mch_id` (`cx_mch_id`) USING BTREE,
|
||
KEY `key` (`key`(191)) USING BTREE,
|
||
KEY `is_autoload` (`is_autoload`) USING BTREE,
|
||
KEY `group` (`group`) USING BTREE
|
||
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='系统设置';
|
||
|
||
-- 数据导出被取消选择。
|
||
|
||
-- 导出 表 cxaibc.cx_order 结构
|
||
CREATE TABLE IF NOT EXISTS `cx_order` (
|
||
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
|
||
`cx_mch_id` bigint(20) unsigned NOT NULL COMMENT '平台商户ID',
|
||
`user_id` bigint(20) unsigned NOT NULL COMMENT '用户ID',
|
||
`order_no` varchar(64) NOT NULL DEFAULT '' COMMENT '订单号',
|
||
`total_price` decimal(10,2) NOT NULL COMMENT '订单总金额(含运费)',
|
||
`total_pay_price` decimal(10,2) NOT NULL COMMENT '实际支付总费用(含运费）',
|
||
`express_original_price` decimal(10,2) NOT NULL COMMENT '运费(后台修改前)',
|
||
`express_price` decimal(10,2) NOT NULL COMMENT '运费(后台修改后)',
|
||
`total_goods_price` decimal(10,2) NOT NULL COMMENT '订单商品总金额(优惠后)',
|
||
`total_goods_original_price` decimal(10,2) NOT NULL COMMENT '订单商品总金额(优惠前)',
|
||
`use_user_coupon_id` bigint(20) unsigned NOT NULL COMMENT '使用的用户优惠券id',
|
||
`coupon_discount_price` decimal(10,2) unsigned NOT NULL COMMENT '优惠券优惠金额',
|
||
`name` varchar(65) NOT NULL DEFAULT '' COMMENT '收件人姓名',
|
||
`mobile` varchar(255) NOT NULL DEFAULT '' COMMENT '收件人手机号',
|
||
`address` varchar(255) NOT NULL DEFAULT '' COMMENT '收件人地址',
|
||
`remark` varchar(255) NOT NULL DEFAULT '' COMMENT '用户订单备注',
|
||
`seller_words` varchar(255) NOT NULL DEFAULT '' COMMENT '商家留言',
|
||
`seller_remark` varchar(255) NOT NULL DEFAULT '' COMMENT '商家订单备注',
|
||
`is_pay` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否支付：0=未支付，1=已支付',
|
||
`pay_type` tinyint(1) unsigned NOT NULL COMMENT '支付方式',
|
||
`pay_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '支付时间',
|
||
`is_send` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否发货：0=未发货，1=已发货',
|
||
`send_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '发货时间',
|
||
`customer_name` varchar(65) DEFAULT '' COMMENT '京东商家编号',
|
||
`express` varchar(65) NOT NULL DEFAULT '' COMMENT '物流公司',
|
||
`express_no` varchar(255) NOT NULL DEFAULT '' COMMENT '物流订单号',
|
||
`is_sale` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否过售后时间',
|
||
`is_confirm` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '收货状态：0=未收货，1=已收货',
|
||
`confirm_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '确认收货时间',
|
||
`cancel_status` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '订单取消状态：0=未取消，1=已取消，2=申请取消',
|
||
`cancel_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '订单取消时间',
|
||
`created_at` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '添加时间',
|
||
`updated_at` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '更新时间',
|
||
`return_ball_at` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '归还时间',
|
||
`deleted_at` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '删除时间',
|
||
`is_delete` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否删除：0=否，1=是',
|
||
`is_recycle` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否加入回收站：0=否，1=是',
|
||
`send_type` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '配送方式：0=快递配送，1=到店自提，2=同城配送，3=无配送，4=商家自配',
|
||
`plugin_sign` varchar(255) NOT NULL DEFAULT '' COMMENT '插件标识',
|
||
`support_pay_types` longtext COMMENT '支持的支付方式，空表示支持系统设置支持的所有方式',
|
||
`is_comment` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否评价：0=否，1=是',
|
||
`comment_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '评价时间',
|
||
`apply_after_sale` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否申请售后',
|
||
`status` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '订单状态：1=进行中，0=已完成 2-用户申请还车 3-用户已申请退款 4-订单已取消 5-订单已未支付',
|
||
`auto_cancel_time` int(11) unsigned DEFAULT '0' COMMENT '自动取消时间',
|
||
`auto_confirm_time` int(11) unsigned DEFAULT '0' COMMENT '自动确认收货时间',
|
||
`auto_sales_time` int(11) unsigned DEFAULT '0' COMMENT '自动售后时间',
|
||
`distance` int(11) DEFAULT '-1' COMMENT '同城配送距离，-1不在范围内，正数为距离M',
|
||
`city_mobile` varchar(100) DEFAULT '' COMMENT '同城配送联系方式',
|
||
`location` varchar(255) DEFAULT NULL COMMENT '经纬度：纬度,经度',
|
||
`city_name` varchar(255) DEFAULT NULL COMMENT '同城配送城市名称',
|
||
`city_info` varchar(255) DEFAULT '' COMMENT '同城配送城市信息',
|
||
`store_id` int(10) NOT NULL DEFAULT '0' COMMENT '门店ID',
|
||
`coach_id` int(11) DEFAULT '0' COMMENT '教练用户id，作用于扫码后的操作',
|
||
PRIMARY KEY (`id`) USING BTREE,
|
||
KEY `user_id` (`user_id`) USING BTREE,
|
||
KEY `order_no` (`order_no`) USING BTREE,
|
||
KEY `is_pay` (`is_pay`) USING BTREE,
|
||
KEY `is_send` (`is_send`) USING BTREE,
|
||
KEY `is_sale` (`is_sale`) USING BTREE,
|
||
KEY `is_confirm` (`is_confirm`) USING BTREE,
|
||
KEY `is_delete` (`is_delete`) USING BTREE,
|
||
KEY `is_recycle` (`is_recycle`) USING BTREE,
|
||
KEY `is_comment` (`is_comment`) USING BTREE,
|
||
KEY `status` (`status`) USING BTREE,
|
||
KEY `sale_status` (`apply_after_sale`) USING BTREE,
|
||
KEY `sign` (`plugin_sign`) USING BTREE,
|
||
KEY `cancel_status` (`cancel_status`) USING BTREE,
|
||
KEY `index1` (`cx_mch_id`,`is_delete`,`is_pay`,`pay_type`,`cancel_status`) USING BTREE,
|
||
KEY `index2` (`cx_mch_id`,`is_delete`,`cancel_status`) USING BTREE,
|
||
KEY `index3` (`cx_mch_id`,`is_delete`,`cancel_status`,`is_pay`) USING BTREE,
|
||
KEY `index4` (`cx_mch_id`,`is_delete`,`cancel_status`,`pay_type`) USING BTREE,
|
||
KEY `index5` (`cx_mch_id`,`is_delete`,`cancel_status`,`is_pay`,`pay_type`) USING BTREE,
|
||
KEY `cx_mch_id` (`cx_mch_id`) USING BTREE,
|
||
KEY `store_id` (`store_id`) USING BTREE
|
||
) ENGINE=InnoDB AUTO_INCREMENT=330 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='订单';
|
||
|
||
-- 数据导出被取消选择。
|
||
|
||
-- 导出 表 cxaibc.cx_order_comments 结构
|
||
CREATE TABLE IF NOT EXISTS `cx_order_comments` (
|
||
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'ID',
|
||
`cx_mch_id` bigint(20) NOT NULL DEFAULT '0' COMMENT '平台商家ID',
|
||
`order_id` bigint(20) NOT NULL COMMENT '订单ID',
|
||
`order_detail_id` bigint(20) NOT NULL COMMENT '订单详情ID',
|
||
`user_id` bigint(20) NOT NULL COMMENT '用户ID',
|
||
`score` tinyint(1) NOT NULL COMMENT '评分：1=差评，2=中评，3=好',
|
||
`content` text NOT NULL COMMENT '评价内容',
|
||
`pic_urls` text NOT NULL COMMENT '评价图片',
|
||
`is_show` tinyint(1) NOT NULL DEFAULT '1' COMMENT '是否显示：0=不显示，1=显示',
|
||
`is_virtual` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否虚拟用户',
|
||
`virtual_user` varchar(255) NOT NULL DEFAULT '' COMMENT '虚拟用户名',
|
||
`virtual_avatar` varchar(2048) NOT NULL DEFAULT '' COMMENT '虚拟头像',
|
||
`virtual_time` int(11) NOT NULL DEFAULT '0' COMMENT '虚拟评价时间',
|
||
`goods_id` bigint(20) NOT NULL DEFAULT '0' COMMENT '商品ID',
|
||
`goods_hub_id` bigint(20) NOT NULL COMMENT '商品库ID',
|
||
`plugin_sign` varchar(255) NOT NULL DEFAULT '' COMMENT '插件标识',
|
||
`reply_content` text NOT NULL COMMENT '商家回复内容',
|
||
`created_at` int(11) NOT NULL COMMENT '添加时间',
|
||
`updated_at` int(11) NOT NULL COMMENT '更新时间',
|
||
`deleted_at` int(11) NOT NULL COMMENT '删除时间',
|
||
`is_delete` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否删除：0=否，1=是',
|
||
`is_anonymous` tinyint(1) NOT NULL DEFAULT '1' COMMENT '是否匿名：0=否，1=是',
|
||
`is_top` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否置顶：0=否，1=是',
|
||
`goods_attr_info` longtext COMMENT '商品信息',
|
||
`attr_id` int(11) NOT NULL DEFAULT '0' COMMENT '规格',
|
||
PRIMARY KEY (`id`) USING BTREE,
|
||
KEY `order_id` (`order_id`) USING BTREE
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='订单评论';
|
||
|
||
-- 数据导出被取消选择。
|
||
|
||
-- 导出 表 cxaibc.cx_order_detail 结构
|
||
CREATE TABLE IF NOT EXISTS `cx_order_detail` (
|
||
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
|
||
`cx_mch_id` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '平台商户ID',
|
||
`order_id` bigint(20) unsigned NOT NULL COMMENT '订单ID',
|
||
`goods_id` varchar(50) NOT NULL DEFAULT '' COMMENT '商品ID',
|
||
`num` int(11) unsigned NOT NULL COMMENT '购买商品数量',
|
||
`unit_price` decimal(10,2) unsigned NOT NULL COMMENT '商品单价',
|
||
`total_original_price` decimal(10,2) unsigned NOT NULL COMMENT '商品原总价(优惠前)',
|
||
`total_price` decimal(10,2) unsigned NOT NULL COMMENT '商品总价(优惠后)',
|
||
`goods_attr_info` longtext NOT NULL COMMENT '购买商品信息',
|
||
`is_delete` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否删除：0=否，1=是',
|
||
`created_at` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '添加时间',
|
||
`updated_at` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '更新时间',
|
||
`deleted_at` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '删除时间',
|
||
`is_refund` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否退款',
|
||
`refund_status` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '售后状态：0=未售后，1=售后中，2=售后结束',
|
||
`plugin_sign` varchar(255) NOT NULL DEFAULT '' COMMENT '插件标识',
|
||
`serial_no` varchar(60) NOT NULL DEFAULT '' COMMENT '商品货号',
|
||
`goods_type` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '商品类型',
|
||
PRIMARY KEY (`id`) USING BTREE,
|
||
KEY `order_id` (`order_id`) USING BTREE,
|
||
KEY `index1` (`goods_id`,`is_refund`,`order_id`) USING BTREE,
|
||
KEY `created_at` (`created_at`) USING BTREE,
|
||
KEY `cx_mch_id` (`cx_mch_id`) USING BTREE
|
||
) ENGINE=InnoDB AUTO_INCREMENT=330 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='订单详情';
|
||
|
||
-- 数据导出被取消选择。
|
||
|
||
-- 导出 表 cxaibc.cx_order_refund 结构
|
||
CREATE TABLE IF NOT EXISTS `cx_order_refund` (
|
||
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
|
||
`cx_mch_id` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '平台商家ID',
|
||
`user_id` bigint(20) unsigned NOT NULL COMMENT '用户ID',
|
||
`order_id` bigint(20) unsigned NOT NULL COMMENT '订单ID',
|
||
`order_detail_id` bigint(20) unsigned NOT NULL COMMENT '关联订单详情',
|
||
`order_no` varchar(64) NOT NULL DEFAULT '' COMMENT '退款单号',
|
||
`type` tinyint(1) unsigned NOT NULL COMMENT '售后类型：1=退货退款，2=换货',
|
||
`refund_price` decimal(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '退款金额',
|
||
`remark` varchar(255) NOT NULL DEFAULT '' COMMENT '用户退款备注、说明',
|
||
`pic_urls` text NOT NULL COMMENT '用户上传图片凭证',
|
||
`status` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '状态：1=待商家处理，2=同意，3=拒绝',
|
||
`status_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '商家处理时间',
|
||
`merchant_remark` varchar(255) NOT NULL DEFAULT '' COMMENT '商家同意|拒绝备注、理由',
|
||
`is_send` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '用户是否发货：0=未发货，1=已发货',
|
||
`send_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '发货时间',
|
||
`customer_name` varchar(65) DEFAULT '' COMMENT '京东商家编号',
|
||
`express` varchar(65) NOT NULL DEFAULT '' COMMENT '快递公司',
|
||
`express_no` varchar(255) NOT NULL DEFAULT '' COMMENT '快递单号',
|
||
`address_id` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '退换货地址ID',
|
||
`is_confirm` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '商家确认操作',
|
||
`confirm_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '确认时间',
|
||
`merchant_customer_name` varchar(65) DEFAULT '' COMMENT '商家京东商家编号',
|
||
`merchant_express` varchar(65) NOT NULL DEFAULT '' COMMENT '商家发货快递公司',
|
||
`merchant_express_no` varchar(255) NOT NULL DEFAULT '' COMMENT '商家发货快递单号',
|
||
`created_at` int(11) unsigned NOT NULL COMMENT '添加时间',
|
||
`updated_at` int(11) unsigned NOT NULL COMMENT '更新时间',
|
||
`deleted_at` int(11) unsigned NOT NULL COMMENT '删除时间',
|
||
`is_delete` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否删除',
|
||
`refund_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '退款时间',
|
||
`is_refund` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否打款：0=否，1=是',
|
||
`reality_refund_price` decimal(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '商家实际退款金额',
|
||
`merchant_express_content` varchar(255) NOT NULL DEFAULT '' COMMENT '物流内容',
|
||
`mobile` varchar(255) NOT NULL DEFAULT '' COMMENT '联系方式',
|
||
`refund_data` text NOT NULL COMMENT '售后数据',
|
||
PRIMARY KEY (`id`) USING BTREE,
|
||
KEY `cx_mch_id` (`cx_mch_id`) USING BTREE,
|
||
KEY `user_id` (`user_id`) USING BTREE,
|
||
KEY `order_id` (`order_id`) USING BTREE,
|
||
KEY `order_detail_id` (`order_detail_id`) USING BTREE,
|
||
KEY `order_no` (`order_no`) USING BTREE,
|
||
KEY `type` (`type`) USING BTREE,
|
||
KEY `status` (`status`) USING BTREE,
|
||
KEY `is_send` (`is_send`) USING BTREE,
|
||
KEY `is_confirm` (`is_confirm`) USING BTREE,
|
||
KEY `is_refund` (`is_refund`) USING BTREE,
|
||
KEY `is_delete` (`is_delete`) USING BTREE
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='订单售后';
|
||
|
||
-- 数据导出被取消选择。
|
||
|
||
-- 导出 表 cxaibc.cx_order_sale 结构
|
||
CREATE TABLE IF NOT EXISTS `cx_order_sale` (
|
||
`id` int(10) NOT NULL AUTO_INCREMENT,
|
||
`order_id` int(10) NOT NULL COMMENT '订单ID',
|
||
`user_id` int(10) NOT NULL COMMENT '用户ID',
|
||
`order_no` varchar(64) NOT NULL COMMENT '退款单号',
|
||
`type` tinyint(4) NOT NULL COMMENT '退款原因 1-球车出现问题 2-球车短时间内归还',
|
||
`refund_price` decimal(10,2) NOT NULL COMMENT '退款金额',
|
||
`remark` text COMMENT '用户退款说明',
|
||
`pic_urls` text COMMENT '上传补充图片',
|
||
`status` tinyint(4) NOT NULL DEFAULT '1' COMMENT '状态：1=待商家处理，2=同意，3=拒绝',
|
||
`status_time` int(11) NOT NULL DEFAULT '0' COMMENT '商家处理时间',
|
||
`merchant_remark` varchar(255) DEFAULT NULL COMMENT '商家同意|拒绝备注、理由',
|
||
`created_at` int(11) unsigned NOT NULL COMMENT '添加时间',
|
||
`updated_at` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '更新时间',
|
||
`deleted_at` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '删除时间',
|
||
`is_delete` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否删除',
|
||
`store_id` int(10) NOT NULL DEFAULT '0' COMMENT '门店ID',
|
||
PRIMARY KEY (`id`)
|
||
) ENGINE=InnoDB AUTO_INCREMENT=68 DEFAULT CHARSET=utf8;
|
||
|
||
-- 数据导出被取消选择。
|
||
|
||
-- 导出 表 cxaibc.cx_order_union_meta 结构
|
||
CREATE TABLE IF NOT EXISTS `cx_order_union_meta` (
|
||
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
|
||
`user_id` bigint(20) unsigned NOT NULL COMMENT '用户id',
|
||
`payment_order_union_id` bigint(20) unsigned NOT NULL COMMENT '合并支付订单号',
|
||
`ps_mer_order_no` varchar(255) DEFAULT '' COMMENT '多次分账、分账完结流水号',
|
||
`type` char(50) DEFAULT '' COMMENT '接口',
|
||
`desc` longtext COMMENT '接口结果',
|
||
`is_delete` int(10) unsigned DEFAULT NULL COMMENT '是否失效',
|
||
`created_at` int(10) unsigned DEFAULT NULL COMMENT '创建日期',
|
||
`deleted_at` int(10) unsigned DEFAULT NULL COMMENT '失效日期',
|
||
PRIMARY KEY (`id`) USING BTREE,
|
||
KEY `user_id` (`user_id`) USING BTREE,
|
||
KEY `ps_mer_order_no` (`ps_mer_order_no`) USING BTREE,
|
||
KEY `is_delete` (`is_delete`) USING BTREE,
|
||
KEY `order_no` (`payment_order_union_id`) USING BTREE
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='银联订单号关联';
|
||
|
||
-- 数据导出被取消选择。
|
||
|
||
-- 导出 表 cxaibc.cx_payment_config 结构
|
||
CREATE TABLE IF NOT EXISTS `cx_payment_config` (
|
||
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
|
||
`cx_mch_id` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '平台商户ID',
|
||
`name` varchar(50) NOT NULL COMMENT '名称',
|
||
`pay_type` varchar(24) NOT NULL COMMENT '支付类型',
|
||
`status` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '状态：0=停用，1=启用',
|
||
`config` longtext NOT NULL COMMENT '配置',
|
||
`is_delete` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否删除：0=否',
|
||
`created_at` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '添加时间',
|
||
`updated_at` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '更新时间',
|
||
`deleted_at` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '删除时间',
|
||
`remark` varchar(255) DEFAULT NULL COMMENT '备注',
|
||
PRIMARY KEY (`id`) USING BTREE,
|
||
KEY `index1` (`cx_mch_id`,`is_delete`) USING BTREE,
|
||
KEY `index2` (`cx_mch_id`,`status`,`is_delete`) USING BTREE
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='支付配置';
|
||
|
||
-- 数据导出被取消选择。
|
||
|
||
-- 导出 表 cxaibc.cx_payment_order 结构
|
||
CREATE TABLE IF NOT EXISTS `cx_payment_order` (
|
||
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
|
||
`cx_mch_id` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '平台商户ID',
|
||
`payment_order_union_id` bigint(20) unsigned NOT NULL COMMENT '合并支付ID',
|
||
`order_no` varchar(64) NOT NULL COMMENT '订单号',
|
||
`amount` decimal(9,2) NOT NULL COMMENT '订单金额',
|
||
`is_pay` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '支付状态：0=未支付，1=已支付',
|
||
`pay_type` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '支付方式',
|
||
`title` varchar(128) NOT NULL COMMENT '支付摘要',
|
||
`created_at` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '添加时间',
|
||
`updated_at` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '更新时间',
|
||
`notify_class` varchar(512) NOT NULL COMMENT '支付成功回调处理类',
|
||
`notify_url` varchar(512) DEFAULT NULL COMMENT '支付成功回调',
|
||
`notify_status` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '回调状态：0=待回调，1=回调成功，2=回调失败',
|
||
`refund` decimal(9,2) NOT NULL DEFAULT '0.00' COMMENT '已退款金额',
|
||
PRIMARY KEY (`id`) USING BTREE,
|
||
KEY `payment_order_union_id` (`payment_order_union_id`) USING BTREE,
|
||
KEY `order_no` (`order_no`) USING BTREE,
|
||
KEY `is_pay` (`is_pay`) USING BTREE,
|
||
KEY `pay_type` (`pay_type`) USING BTREE,
|
||
KEY `cx_mch_id` (`cx_mch_id`) USING BTREE
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='支付订单';
|
||
|
||
-- 数据导出被取消选择。
|
||
|
||
-- 导出 表 cxaibc.cx_payment_order_union 结构
|
||
CREATE TABLE IF NOT EXISTS `cx_payment_order_union` (
|
||
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'ID',
|
||
`cx_mch_id` bigint(20) NOT NULL COMMENT '平台商户ID',
|
||
`user_id` bigint(20) NOT NULL DEFAULT '0' COMMENT '用户ID',
|
||
`order_no` varchar(64) NOT NULL COMMENT '订单号',
|
||
`amount` decimal(9,2) NOT NULL COMMENT '订单金额',
|
||
`is_pay` tinyint(1) NOT NULL DEFAULT '0' COMMENT '支付状态：0=未支付，1=已支付',
|
||
`pay_type` tinyint(1) NOT NULL DEFAULT '0' COMMENT '支付方式',
|
||
`title` varchar(128) NOT NULL COMMENT '支付摘要',
|
||
`support_pay_types` text NOT NULL COMMENT '支持的支付方式（JSON）',
|
||
`created_at` int(11) DEFAULT '0' COMMENT '添加时间',
|
||
`updated_at` int(11) DEFAULT '0' COMMENT '更新时间',
|
||
`out_trade_no` varchar(64) DEFAULT NULL COMMENT '商户订单号',
|
||
`transaction_id` varchar(64) DEFAULT '0' COMMENT '交易流水号',
|
||
PRIMARY KEY (`id`) USING BTREE,
|
||
UNIQUE KEY `out_trade_no` (`out_trade_no`) USING BTREE,
|
||
KEY `cx_mch_id` (`cx_mch_id`) USING BTREE,
|
||
KEY `user_id` (`user_id`) USING BTREE,
|
||
KEY `order_no` (`order_no`) USING BTREE,
|
||
KEY `is_pay` (`is_pay`) USING BTREE,
|
||
KEY `pay_type` (`pay_type`) USING BTREE,
|
||
KEY `transaction_id` (`transaction_id`) USING BTREE
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='合并支付订单';
|
||
|
||
-- 数据导出被取消选择。
|
||
|
||
-- 导出 表 cxaibc.cx_payment_refund 结构
|
||
CREATE TABLE IF NOT EXISTS `cx_payment_refund` (
|
||
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
|
||
`cx_mch_id` bigint(20) NOT NULL COMMENT '平台商户ID',
|
||
`user_id` bigint(20) NOT NULL COMMENT '用户ID',
|
||
`order_no` varchar(64) NOT NULL DEFAULT '' COMMENT '退款单号',
|
||
`amount` decimal(9,2) NOT NULL DEFAULT '0.00' COMMENT '退款金额',
|
||
`is_pay` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '支付状态： 0=未支付，1=已支付',
|
||
`pay_type` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '支付方式',
|
||
`title` varchar(128) NOT NULL DEFAULT '' COMMENT '支付摘要',
|
||
`created_at` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '添加时间',
|
||
`updated_at` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '更新时间',
|
||
`out_trade_no` varchar(64) NOT NULL DEFAULT '' COMMENT '支付单号',
|
||
PRIMARY KEY (`id`) USING BTREE,
|
||
KEY `cx_mch_id` (`cx_mch_id`) USING BTREE
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='退款订单';
|
||
|
||
-- 数据导出被取消选择。
|
||
|
||
-- 导出 表 cxaibc.cx_payment_transfer 结构
|
||
CREATE TABLE IF NOT EXISTS `cx_payment_transfer` (
|
||
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
|
||
`cx_mch_id` bigint(20) unsigned NOT NULL COMMENT '平台商户ID',
|
||
`user_id` bigint(20) unsigned NOT NULL COMMENT '用户ID',
|
||
`order_no` varchar(64) NOT NULL COMMENT '提交的订单号',
|
||
`transfer_order_no` varchar(64) NOT NULL COMMENT '发起打款的订单号',
|
||
`amount` decimal(9,2) NOT NULL DEFAULT '0.00' COMMENT '金额',
|
||
`is_pay` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '支付状态： 0=未支付，1=已支付',
|
||
`pay_type` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '支付方式',
|
||
`title` varchar(128) NOT NULL DEFAULT '' COMMENT '支付摘要',
|
||
`created_at` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '添加时间',
|
||
`updated_at` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '更新时间',
|
||
PRIMARY KEY (`id`) USING BTREE,
|
||
KEY `cx_mch_id` (`cx_mch_id`) USING BTREE
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='平台向用户打款';
|
||
|
||
-- 数据导出被取消选择。
|
||
|
||
-- 导出 表 cxaibc.cx_payment_types 结构
|
||
CREATE TABLE IF NOT EXISTS `cx_payment_types` (
|
||
`id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
|
||
`cx_mch_id` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '平台商户ID',
|
||
`name` varchar(50) NOT NULL COMMENT '支付方式CN',
|
||
`short_name` varchar(50) NOT NULL COMMENT '支付方式EN',
|
||
`is_show` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '是否显示，0=否，1=是',
|
||
`is_open` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '是否启用，0=否，1=是',
|
||
`created_at` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '添加时间',
|
||
`updated_at` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '更新时间',
|
||
PRIMARY KEY (`id`) USING BTREE,
|
||
KEY `cx_mch_id` (`cx_mch_id`) USING BTREE
|
||
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='支付方式';
|
||
|
||
-- 数据导出被取消选择。
|
||
|
||
-- 导出 表 cxaibc.cx_pay_notify_log 结构
|
||
CREATE TABLE IF NOT EXISTS `cx_pay_notify_log` (
|
||
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
|
||
`cx_mch_id` bigint(20) unsigned DEFAULT '0' COMMENT '平台商户ID',
|
||
`order_no` varchar(64) NOT NULL COMMENT '订单号',
|
||
`content` longtext NOT NULL COMMENT '回调数据',
|
||
`created_at` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '添加时间',
|
||
`is_delete` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否删除：0=否，1=是',
|
||
`deleted_at` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '删除时间',
|
||
PRIMARY KEY (`id`) USING BTREE,
|
||
KEY `cx_mch_id_order_no_is_delete` (`cx_mch_id`,`order_no`,`is_delete`) USING BTREE,
|
||
KEY `cx_mch_id_is_delete` (`cx_mch_id`,`is_delete`) USING BTREE
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='支付回调记录';
|
||
|
||
-- 数据导出被取消选择。
|
||
|
||
-- 导出 表 cxaibc.cx_qc_data 结构
|
||
CREATE TABLE IF NOT EXISTS `cx_qc_data` (
|
||
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
|
||
`union` varchar(32) DEFAULT NULL COMMENT '车辆编号',
|
||
`data` text COMMENT 'json数据',
|
||
`created_at` int(11) DEFAULT NULL COMMENT '写入数据库的时间，中间可能会发生redis写入数据库挂掉的情况，请使用下个时间',
|
||
`data_time` int(11) DEFAULT NULL COMMENT '获取到数据的时间',
|
||
`type` varchar(20) DEFAULT NULL COMMENT '类型：如 Detail',
|
||
`status` tinyint(4) DEFAULT NULL COMMENT '状态，1、正常，0.非法数据',
|
||
PRIMARY KEY (`id`)
|
||
) ENGINE=InnoDB AUTO_INCREMENT=133536 DEFAULT CHARSET=utf8mb4;
|
||
|
||
-- 数据导出被取消选择。
|
||
|
||
-- 导出 表 cxaibc.cx_qrcode_record 结构
|
||
CREATE TABLE IF NOT EXISTS `cx_qrcode_record` (
|
||
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
|
||
`unionid` varchar(255) NOT NULL COMMENT '球车或场地id',
|
||
`data` text NOT NULL COMMENT '数据',
|
||
`type` tinyint(4) NOT NULL COMMENT '类型，1.场地码，2.球车码',
|
||
`created_at` int(11) NOT NULL COMMENT '创建实际',
|
||
`is_delete` tinyint(4) NOT NULL,
|
||
`deleted_at` int(11) NOT NULL,
|
||
PRIMARY KEY (`id`)
|
||
) ENGINE=MyISAM AUTO_INCREMENT=77 DEFAULT CHARSET=utf8mb4 COMMENT='扫码记录表';
|
||
|
||
-- 数据导出被取消选择。
|
||
|
||
-- 导出 表 cxaibc.cx_recharge_order 结构
|
||
CREATE TABLE IF NOT EXISTS `cx_recharge_order` (
|
||
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
|
||
`cx_mch_id` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '平台商户ID',
|
||
`order_no` varchar(64) NOT NULL COMMENT '订单号',
|
||
`user_id` bigint(20) NOT NULL COMMENT '用户ID',
|
||
`pay_price` decimal(18,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '支付金额',
|
||
`send_price` decimal(18,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '赠送金额',
|
||
`pay_type` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '支付类型',
|
||
`is_pay` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否支付：0=否，1=是',
|
||
`pay_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '支付时间',
|
||
`created_at` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '添加时间',
|
||
`updated_at` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '更新时间',
|
||
`is_delete` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否删除：0=否，1=是',
|
||
`deleted_at` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '删除时间',
|
||
PRIMARY KEY (`id`) USING BTREE,
|
||
KEY `cx_mch_id_is_delete` (`cx_mch_id`,`is_delete`,`is_pay`) USING BTREE,
|
||
KEY `cx_mch_id_user_id_is_pay_is_delete` (`cx_mch_id`,`user_id`,`is_pay`,`is_delete`) USING BTREE
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='充值订单';
|
||
|
||
-- 数据导出被取消选择。
|
||
|
||
-- 导出 表 cxaibc.cx_recharge_rule 结构
|
||
CREATE TABLE IF NOT EXISTS `cx_recharge_rule` (
|
||
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
|
||
`cx_mch_id` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '平台商户ID',
|
||
`name` varchar(50) NOT NULL COMMENT '方案名称',
|
||
`pay_price` decimal(18,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '支付金额',
|
||
`send_price` decimal(18,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '赠送金额',
|
||
`created_at` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '添加时间',
|
||
`updated_at` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '更新时间',
|
||
`deleted_at` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '删除时间',
|
||
`is_delete` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否删除：0=否，1=是',
|
||
PRIMARY KEY (`id`) USING BTREE,
|
||
KEY `cx_mch_id_is_delete` (`cx_mch_id`,`is_delete`) USING BTREE
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='充值方案';
|
||
|
||
-- 数据导出被取消选择。
|
||
|
||
-- 导出 表 cxaibc.cx_sms_country 结构
|
||
CREATE TABLE IF NOT EXISTS `cx_sms_country` (
|
||
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
|
||
`iso` varchar(16) NOT NULL COMMENT 'ISO',
|
||
`iso3` varchar(16) NOT NULL COMMENT 'ISO3',
|
||
`name` varchar(64) NOT NULL COMMENT '名称',
|
||
`name_cn` varchar(64) NOT NULL COMMENT '中文名称',
|
||
`nicename` varchar(64) NOT NULL COMMENT '简称',
|
||
`num_code` varchar(16) NOT NULL COMMENT '编码',
|
||
`country_code` varchar(16) NOT NULL COMMENT '国家代码',
|
||
`created_at` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '添加时间',
|
||
`it_wrx` varchar(32) DEFAULT NULL COMMENT 'ITWRX',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE=InnoDB AUTO_INCREMENT=240 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='手机号国家代码';
|
||
|
||
-- 数据导出被取消选择。
|
||
|
||
-- 导出 表 cxaibc.cx_sms_record 结构
|
||
CREATE TABLE IF NOT EXISTS `cx_sms_record` (
|
||
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
|
||
`cx_mch_id` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '平台商户ID',
|
||
`user_id` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '用户ID',
|
||
`mobile_phone` varchar(128) NOT NULL COMMENT '手机号',
|
||
`mobile_prefix` varchar(16) NOT NULL COMMENT '手机号国家代码',
|
||
`tpl_code` varchar(64) NOT NULL COMMENT '短信模板',
|
||
`content` varchar(1024) NOT NULL COMMENT '短信内容',
|
||
`ipv4` varchar(64) DEFAULT NULL COMMENT 'IPV4',
|
||
`ipv6` varchar(128) DEFAULT NULL COMMENT 'IPV6',
|
||
`created_at` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '添加时间',
|
||
PRIMARY KEY (`id`) USING BTREE,
|
||
KEY `cx_mch_id` (`cx_mch_id`) USING BTREE,
|
||
KEY `user_id` (`user_id`) USING BTREE,
|
||
KEY `mobile_phone` (`mobile_phone`) USING BTREE
|
||
) ENGINE=InnoDB AUTO_INCREMENT=98 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='短信记录';
|
||
|
||
-- 数据导出被取消选择。
|
||
|
||
-- 导出 表 cxaibc.cx_sms_setting 结构
|
||
CREATE TABLE IF NOT EXISTS `cx_sms_setting` (
|
||
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
|
||
`cx_mch_id` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '平台商户ID',
|
||
`type` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '类型，0=阿里云，1=腾讯云',
|
||
`access_key_id` varchar(64) DEFAULT NULL COMMENT '阿里云AccessKeyId',
|
||
`access_secret` varchar(64) DEFAULT NULL COMMENT '阿里云AccessSecret',
|
||
`secret_id` varchar(64) DEFAULT NULL COMMENT '腾讯短信SecretId',
|
||
`secret_key` varchar(64) DEFAULT NULL COMMENT '腾讯短信SecretKey',
|
||
`sdk_app_id` varchar(64) DEFAULT NULL COMMENT '腾讯短信应用ID',
|
||
`sign_name` varchar(64) DEFAULT NULL COMMENT '签名',
|
||
`expire_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '有效时长',
|
||
`time_delay` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '获取时间间隔',
|
||
`day_limit` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '每日获取验证码次数',
|
||
`is_prod` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '环境，0=非正式，1=正式环境',
|
||
`code_len` tinyint(1) unsigned NOT NULL DEFAULT '4' COMMENT '验证码长度',
|
||
`super_code` char(64) NOT NULL DEFAULT '6666' COMMENT '超级验证码，默认6666',
|
||
PRIMARY KEY (`id`) USING BTREE,
|
||
KEY `cx_mch_id` (`cx_mch_id`) USING BTREE
|
||
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='短信设置';
|
||
|
||
-- 数据导出被取消选择。
|
||
|
||
-- 导出 表 cxaibc.cx_sms_tpl 结构
|
||
CREATE TABLE IF NOT EXISTS `cx_sms_tpl` (
|
||
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
|
||
`cx_mch_id` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '平台商户ID',
|
||
`type` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '类型，0=阿里云，1=腾讯云',
|
||
`key` varchar(64) NOT NULL COMMENT 'KEY',
|
||
`tpl_code` varchar(64) NOT NULL COMMENT '短信模板',
|
||
`is_delete` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否删除，0=否，1=是',
|
||
`created_at` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '添加时间',
|
||
PRIMARY KEY (`id`) USING BTREE,
|
||
KEY `cx_mch_id` (`cx_mch_id`) USING BTREE
|
||
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='短信模板';
|
||
|
||
-- 数据导出被取消选择。
|
||
|
||
-- 导出 表 cxaibc.cx_store 结构
|
||
CREATE TABLE IF NOT EXISTS `cx_store` (
|
||
`id` int(10) NOT NULL AUTO_INCREMENT,
|
||
`name` varchar(50) NOT NULL COMMENT '门店名称',
|
||
`province` varchar(20) NOT NULL COMMENT '省',
|
||
`province_id` int(10) NOT NULL COMMENT '省ID',
|
||
`city` varchar(20) NOT NULL COMMENT '市',
|
||
`city_id` int(10) NOT NULL COMMENT '市ID',
|
||
`region` varchar(20) NOT NULL COMMENT '区',
|
||
`region_id` int(10) NOT NULL COMMENT '区ID',
|
||
`location_detail` varchar(255) NOT NULL COMMENT '门店具体位置',
|
||
`begin_time` char(20) NOT NULL DEFAULT '' COMMENT '营业开始时间',
|
||
`end_time` char(20) NOT NULL DEFAULT '' COMMENT '营业结束时间',
|
||
`status` tinyint(4) NOT NULL DEFAULT '1' COMMENT '1-营业 0-停业',
|
||
`sort` varchar(50) NOT NULL DEFAULT '1' COMMENT '排序',
|
||
`created_at` int(10) DEFAULT '0' COMMENT '添加时间',
|
||
`updated_at` int(10) DEFAULT '0' COMMENT '修改时间',
|
||
`is_delete` tinyint(4) DEFAULT '0' COMMENT '是否删除，0=否，1=是',
|
||
`deleted_at` int(10) DEFAULT '0' COMMENT '删除时间',
|
||
`ratio` tinyint(1) unsigned DEFAULT '0' COMMENT '收益比例',
|
||
`area` text NOT NULL COMMENT '区域坐标json',
|
||
`lat` char(20) DEFAULT '',
|
||
`lng` char(20) DEFAULT '',
|
||
`phone` char(20) NOT NULL COMMENT '客服电话',
|
||
`content` text COMMENT '门店内容',
|
||
`pic_urls` text COMMENT '轮播图',
|
||
PRIMARY KEY (`id`) USING BTREE,
|
||
KEY `province_id` (`province_id`) USING BTREE,
|
||
KEY `city_id` (`city_id`) USING BTREE,
|
||
KEY `region_id` (`region_id`) USING BTREE,
|
||
KEY `name` (`name`) USING BTREE
|
||
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='门店表';
|
||
|
||
-- 数据导出被取消选择。
|
||
|
||
-- 导出 表 cxaibc.cx_store_earnings 结构
|
||
CREATE TABLE IF NOT EXISTS `cx_store_earnings` (
|
||
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
|
||
`store_id` int(11) unsigned NOT NULL COMMENT '门店id',
|
||
`user_id` bigint(20) unsigned NOT NULL COMMENT '收益来源用户id',
|
||
`order_id` bigint(20) unsigned NOT NULL COMMENT '订单id',
|
||
`money` decimal(20,2) unsigned NOT NULL COMMENT '收益金额',
|
||
`status` tinyint(1) unsigned DEFAULT '0' COMMENT '0=待发放1=已到账',
|
||
`created_at` int(10) unsigned DEFAULT '0' COMMENT '创建日期',
|
||
`updated_at` int(10) unsigned DEFAULT '0' COMMENT '发放日期',
|
||
`is_delete` tinyint(1) unsigned DEFAULT '0',
|
||
`deleted_at` int(10) unsigned DEFAULT '0',
|
||
`card_id` int(10) unsigned DEFAULT '0' COMMENT '银行卡id',
|
||
PRIMARY KEY (`id`) USING BTREE,
|
||
KEY `store_id` (`store_id`) USING BTREE,
|
||
KEY `user_id` (`user_id`) USING BTREE,
|
||
KEY `order_id` (`order_id`) USING BTREE,
|
||
KEY `status` (`status`) USING BTREE
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='门店收益表';
|
||
|
||
-- 数据导出被取消选择。
|
||
|
||
-- 导出 表 cxaibc.cx_store_user 结构
|
||
CREATE TABLE IF NOT EXISTS `cx_store_user` (
|
||
`id` int(10) NOT NULL AUTO_INCREMENT,
|
||
`user_id` int(10) NOT NULL DEFAULT '0' COMMENT '用户ID',
|
||
`store_id` int(10) NOT NULL COMMENT '门店ID',
|
||
`username` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '用户名',
|
||
`password` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '密码',
|
||
`user_type` tinyint(4) NOT NULL DEFAULT '0' COMMENT '1-门店管理员 2-门店服务员 3-门店财务人员',
|
||
`is_delete` tinyint(4) DEFAULT '0' COMMENT '是否删除，0=否，1=是',
|
||
`deleted_at` int(10) DEFAULT '0' COMMENT '删除时间',
|
||
`status` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '状态，0=正常，1=封禁',
|
||
`created_at` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '添加时间',
|
||
`updated_at` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '更新时间',
|
||
PRIMARY KEY (`id`)
|
||
) ENGINE=InnoDB AUTO_INCREMENT=50 DEFAULT CHARSET=utf8;
|
||
|
||
-- 数据导出被取消选择。
|
||
|
||
-- 导出 表 cxaibc.cx_sys_admin 结构
|
||
CREATE TABLE IF NOT EXISTS `cx_sys_admin` (
|
||
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
|
||
`cx_mch_id` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '平台商户ID',
|
||
`user_id` bigint(20) unsigned NOT NULL COMMENT '用户ID',
|
||
`is_delete` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否删除，0=否，1=是',
|
||
`created_at` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '添加时间',
|
||
`creator_user_id` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '创建者用户ID',
|
||
PRIMARY KEY (`id`) USING BTREE,
|
||
KEY `cx_mch_id` (`cx_mch_id`) USING BTREE,
|
||
KEY `user_id` (`user_id`) USING BTREE
|
||
) ENGINE=InnoDB AUTO_INCREMENT=52 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='系统管理员';
|
||
|
||
-- 数据导出被取消选择。
|
||
|
||
-- 导出 表 cxaibc.cx_sys_msg 结构
|
||
CREATE TABLE IF NOT EXISTS `cx_sys_msg` (
|
||
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
|
||
`cx_mch_id` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '平台商户ID',
|
||
`type` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '消息类型',
|
||
`to_user_id` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '接收用户：0=所有用户',
|
||
`title` varchar(256) NOT NULL COMMENT '标题',
|
||
`is_richtext` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否富文本：0=否，1=是',
|
||
`content` longtext NOT NULL COMMENT '消息内容',
|
||
`status` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '状态：0=草稿，1=已发布',
|
||
`order_id` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '订单ID',
|
||
`created_at` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '添加时间',
|
||
`updated_at` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '更新时间',
|
||
`deleted_at` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '删除时间',
|
||
`published_at` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '发布时间',
|
||
`is_delete` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否删除：0=否，1=是',
|
||
PRIMARY KEY (`id`) USING BTREE,
|
||
KEY `cx_mch_id_type_to_user_id_status_is_delete` (`cx_mch_id`,`type`,`to_user_id`,`status`,`is_delete`) USING BTREE,
|
||
KEY `cx_mch_id_is_delete` (`cx_mch_id`,`is_delete`) USING BTREE
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='系统消息';
|
||
|
||
-- 数据导出被取消选择。
|
||
|
||
-- 导出 表 cxaibc.cx_upload_file 结构
|
||
CREATE TABLE IF NOT EXISTS `cx_upload_file` (
|
||
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
|
||
`cx_mch_id` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '平台商户ID',
|
||
`file_source` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '文件源，0=本地存储，1=阿里云',
|
||
`user_id` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '用户ID',
|
||
`file_url` varchar(2048) DEFAULT NULL COMMENT '文件地址',
|
||
`extension` varchar(256) DEFAULT NULL COMMENT '扩展名',
|
||
`type` varchar(256) DEFAULT NULL COMMENT '类型',
|
||
`size` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '大小',
|
||
`is_delete` smallint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否删除',
|
||
`created_at` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '添加时间',
|
||
`group_id` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '文件组ID',
|
||
PRIMARY KEY (`id`) USING BTREE,
|
||
KEY `is_delete` (`is_delete`) USING BTREE,
|
||
KEY `group_id` (`group_id`) USING BTREE,
|
||
KEY `cx_mch_id` (`cx_mch_id`) USING BTREE,
|
||
KEY `user_id` (`user_id`) USING BTREE
|
||
) ENGINE=InnoDB AUTO_INCREMENT=172 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='文件';
|
||
|
||
-- 数据导出被取消选择。
|
||
|
||
-- 导出 表 cxaibc.cx_user 结构
|
||
CREATE TABLE IF NOT EXISTS `cx_user` (
|
||
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
|
||
`cx_mch_id` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '平台商户ID',
|
||
`username` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '用户名',
|
||
`password` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '密码',
|
||
`auth_key` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT 'AUTH_KEY',
|
||
`access_token` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT 'ACCESS_TOKEN',
|
||
`nickname` varchar(256) NOT NULL COMMENT '昵称',
|
||
`avatar_url` varchar(2048) NOT NULL COMMENT '头像',
|
||
`mobile_phone` varchar(128) DEFAULT NULL COMMENT '手机号',
|
||
`mobile_prefix` varchar(16) DEFAULT NULL COMMENT '手机号国家代码',
|
||
`email` varchar(256) DEFAULT NULL COMMENT '邮箱',
|
||
`real_name` varchar(256) DEFAULT NULL COMMENT '真实姓名',
|
||
`desc` varchar(64) DEFAULT NULL COMMENT '个性签名',
|
||
`gender` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '性别，0=未知，1=男，2=女，3=保密',
|
||
`birthday` date DEFAULT NULL COMMENT '生日',
|
||
`status` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '状态，0=正常，1=封禁，2=挂起，3=注销',
|
||
`parent_id` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT 'PARENT_ID',
|
||
`is_modify_un` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '用户名是否可以修改，0=否，1=是',
|
||
`is_delete` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否删除，0=否，1=是',
|
||
`country_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '国家ID',
|
||
`city_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '城市ID',
|
||
`created_at` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '添加时间',
|
||
`updated_at` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '更新时间',
|
||
`type` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '0=用户，1=管理员，2=门店,3=教练',
|
||
`store_id` int(10) NOT NULL DEFAULT '0' COMMENT '用户切换门店绑定的门店ID ',
|
||
`is_view` tinyint(3) unsigned DEFAULT '0' COMMENT '是否有观看视频',
|
||
PRIMARY KEY (`id`) USING BTREE,
|
||
UNIQUE KEY `username` (`username`) USING BTREE,
|
||
KEY `password` (`password`(191)) USING BTREE,
|
||
KEY `access_token` (`access_token`(191)) USING BTREE,
|
||
KEY `auth_key` (`auth_key`(191)) USING BTREE,
|
||
KEY `created_at` (`created_at`) USING BTREE
|
||
) ENGINE=InnoDB AUTO_INCREMENT=58 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='用户';
|
||
|
||
-- 数据导出被取消选择。
|
||
|
||
-- 导出 表 cxaibc.cx_user_ball_arm 结构
|
||
CREATE TABLE IF NOT EXISTS `cx_user_ball_arm` (
|
||
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
|
||
`title` varchar(255) NOT NULL COMMENT '球杆名称',
|
||
`uid` int(11) NOT NULL COMMENT '用户id，user表id',
|
||
`store_id` int(11) NOT NULL COMMENT '门店id',
|
||
`data` text NOT NULL COMMENT '球杆数据，json串',
|
||
`status` tinyint(4) NOT NULL COMMENT '状态，1.未支付，需要支付，2.支付完订单，等待检测员检测，3.完成检测，可用球杆，4.完成检测，停用球杆',
|
||
`created_at` int(11) NOT NULL COMMENT '创建时间',
|
||
`updated_at` int(11) NOT NULL COMMENT '更新时间',
|
||
`is_delete` tinyint(4) NOT NULL COMMENT '是否删除，1.删除，0.没有删除',
|
||
`deleted_at` int(11) NOT NULL COMMENT '删除时间',
|
||
`jc_uid` int(11) NOT NULL COMMENT '检测员用户id，user表id',
|
||
`order_id` int(10) NOT NULL COMMENT '订单ID',
|
||
PRIMARY KEY (`id`) USING BTREE,
|
||
KEY `uid` (`uid`) USING BTREE
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='用户球杆';
|
||
|
||
-- 数据导出被取消选择。
|
||
|
||
-- 导出 表 cxaibc.cx_user_coupon 结构
|
||
CREATE TABLE IF NOT EXISTS `cx_user_coupon` (
|
||
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
|
||
`user_id` bigint(20) unsigned NOT NULL,
|
||
`coupon_id` bigint(20) unsigned NOT NULL COMMENT '卡券id',
|
||
`status` tinyint(1) unsigned DEFAULT '0' COMMENT '状态0=未使用1=已使用',
|
||
`created_at` int(10) unsigned DEFAULT '0' COMMENT '领取时间',
|
||
`updated_at` int(10) unsigned DEFAULT '0' COMMENT '使用时间',
|
||
`is_delete` tinyint(1) unsigned DEFAULT '0',
|
||
`deleted_at` int(10) unsigned DEFAULT '0',
|
||
`is_admin_send` tinyint(1) unsigned DEFAULT '0' COMMENT '是否平台发放',
|
||
PRIMARY KEY (`id`),
|
||
KEY `user_id` (`user_id`),
|
||
KEY `coupon_id` (`coupon_id`)
|
||
) ENGINE=InnoDB AUTO_INCREMENT=47 DEFAULT CHARSET=utf8 COMMENT='用户领取卡券';
|
||
|
||
-- 数据导出被取消选择。
|
||
|
||
-- 导出 表 cxaibc.cx_user_information 结构
|
||
CREATE TABLE IF NOT EXISTS `cx_user_information` (
|
||
`id` int(10) NOT NULL AUTO_INCREMENT,
|
||
`user_id` int(10) NOT NULL COMMENT '用户ID',
|
||
`store_id` int(10) NOT NULL COMMENT '门店ID',
|
||
`height` varchar(50) DEFAULT NULL COMMENT '身高',
|
||
`weight` varchar(50) DEFAULT NULL COMMENT '体重',
|
||
`age` varchar(50) DEFAULT NULL COMMENT '年龄',
|
||
`territory` varchar(100) DEFAULT NULL COMMENT '所属地',
|
||
`college` varchar(50) DEFAULT NULL COMMENT '学院',
|
||
`ball_age` varchar(50) DEFAULT NULL COMMENT '球龄',
|
||
`address` varchar(100) DEFAULT NULL COMMENT '地址',
|
||
`arm_length` varchar(50) DEFAULT NULL COMMENT '臂长',
|
||
`glove` varchar(50) DEFAULT NULL COMMENT '手套尺寸',
|
||
`palm_size` varchar(50) DEFAULT NULL COMMENT '手掌大小',
|
||
`shoes_size` varchar(50) DEFAULT NULL COMMENT '鞋子大小',
|
||
`created_at` int(10) NOT NULL DEFAULT '0' COMMENT '添加时间',
|
||
`updated_at` int(10) NOT NULL DEFAULT '0' COMMENT '修改时间',
|
||
`member_status` tinyint(4) NOT NULL DEFAULT '0' COMMENT '会员状态 0-未注册 1-已注册',
|
||
`begin_time` int(10) DEFAULT '0' COMMENT '会员开通时间',
|
||
`end_time` int(10) DEFAULT NULL COMMENT '会员到期时间',
|
||
PRIMARY KEY (`id`) USING BTREE,
|
||
UNIQUE KEY `user_id` (`user_id`) USING BTREE
|
||
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
|
||
|
||
-- 数据导出被取消选择。
|
||
|
||
-- 导出 表 cxaibc.cx_user_login_log 结构
|
||
CREATE TABLE IF NOT EXISTS `cx_user_login_log` (
|
||
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
|
||
`cx_mch_id` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '平台商户ID',
|
||
`user_id` bigint(20) unsigned NOT NULL COMMENT '用户ID',
|
||
`is_delete` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否删除，0=否，1=是',
|
||
`created_at` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '添加时间',
|
||
`ipv4` varchar(32) NOT NULL COMMENT 'IPV4',
|
||
`ipv6` varchar(128) DEFAULT NULL COMMENT 'IPV6',
|
||
`is_pass` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否登录成功，0=否，1=是',
|
||
`err_msg` varchar(256) DEFAULT NULL COMMENT '失败消息',
|
||
PRIMARY KEY (`id`) USING BTREE,
|
||
KEY `cx_mch_id` (`cx_mch_id`) USING BTREE,
|
||
KEY `user_id` (`user_id`) USING BTREE,
|
||
KEY `created_at` (`created_at`) USING BTREE
|
||
) ENGINE=InnoDB AUTO_INCREMENT=849 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='用户登录日志';
|
||
|
||
-- 数据导出被取消选择。
|
||
|
||
-- 导出 表 cxaibc.cx_user_oauth 结构
|
||
CREATE TABLE IF NOT EXISTS `cx_user_oauth` (
|
||
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
|
||
`cx_mch_id` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '平台商户ID',
|
||
`type` char(16) NOT NULL DEFAULT 'wxmp' COMMENT '类型',
|
||
`user_id` bigint(20) unsigned NOT NULL COMMENT '用户ID',
|
||
`openid` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT 'OPENID',
|
||
`unionid` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT 'UNIONID',
|
||
`nickname` varchar(256) DEFAULT NULL COMMENT '昵称',
|
||
`avatar_url` varchar(2048) DEFAULT NULL COMMENT '头像',
|
||
`is_delete` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否删除，0=否，1=是',
|
||
`created_at` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '添加时间',
|
||
PRIMARY KEY (`id`),
|
||
KEY `cx_mch_id` (`cx_mch_id`),
|
||
KEY `user_id` (`user_id`),
|
||
KEY `openid` (`openid`(191)),
|
||
KEY `unionid` (`unionid`(191))
|
||
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8mb4 COMMENT='第三方登录';
|
||
|
||
-- 数据导出被取消选择。
|
||
|
||
-- 导出 表 cxaibc.cx_user_sys_msg 结构
|
||
CREATE TABLE IF NOT EXISTS `cx_user_sys_msg` (
|
||
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
|
||
`cx_mch_id` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '平台商户ID',
|
||
`sys_msg_id` bigint(20) unsigned NOT NULL COMMENT '系统消息ID',
|
||
`user_id` bigint(20) unsigned NOT NULL COMMENT '用户ID',
|
||
`is_read` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否已读：0=否，1=是',
|
||
`read_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '阅读时间',
|
||
`is_sound` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否提醒：0=否，1=是',
|
||
`sound_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '提醒时间',
|
||
`created_at` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '添加时间',
|
||
`updated_at` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '更新时间',
|
||
`is_delete` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否删除：0=否，1=是',
|
||
`deleted_at` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '删除时间',
|
||
PRIMARY KEY (`id`) USING BTREE,
|
||
KEY `cx_mch_id_sys_msg_id_user_id_is_read_is_delete` (`cx_mch_id`,`sys_msg_id`,`user_id`,`is_read`,`is_delete`) USING BTREE,
|
||
KEY `cx_mch_id_sys_msg_id_user_id_is_delete` (`cx_mch_id`,`sys_msg_id`,`user_id`,`is_delete`) USING BTREE
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='系统消息收件箱';
|
||
|
||
-- 数据导出被取消选择。
|
||
|
||
-- 导出 表 cxaibc.cx_user_token 结构
|
||
CREATE TABLE IF NOT EXISTS `cx_user_token` (
|
||
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
|
||
`cx_mch_id` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '平台商户ID',
|
||
`user_id` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '用户ID',
|
||
`type` smallint(1) unsigned NOT NULL DEFAULT '0' COMMENT '类型',
|
||
`token` varchar(128) NOT NULL COMMENT '令牌',
|
||
`expire_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '失效时间',
|
||
`status` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '状态，0=未验证，1=验证通过，2=验证未通过，3=已失效',
|
||
`is_delete` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否删除，0=否，1=是',
|
||
`created_at` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '添加时间',
|
||
PRIMARY KEY (`id`) USING BTREE,
|
||
KEY `cx_mch_id` (`cx_mch_id`) USING BTREE,
|
||
KEY `token` (`token`) USING BTREE
|
||
) ENGINE=InnoDB AUTO_INCREMENT=684 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='用户令牌';
|
||
|
||
-- 数据导出被取消选择。
|
||
|
||
-- 导出 表 cxaibc.cx_wechat_app 结构
|
||
CREATE TABLE IF NOT EXISTS `cx_wechat_app` (
|
||
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
|
||
`cx_mch_id` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '平台商户ID',
|
||
`name` varchar(256) NOT NULL COMMENT '小程序名称',
|
||
`app_id` varchar(256) NOT NULL COMMENT 'AppId',
|
||
`app_secret` varchar(256) NOT NULL COMMENT 'AppSecret',
|
||
`desc` varchar(256) DEFAULT NULL COMMENT '描述',
|
||
`mch_id` varchar(256) DEFAULT NULL COMMENT '商户ID',
|
||
`key` varchar(256) DEFAULT NULL COMMENT 'ApiKey',
|
||
`cert_pem` longtext COMMENT '微信支付CertPem',
|
||
`key_pem` longtext COMMENT '微信支付KeyPem',
|
||
`is_delete` smallint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否删除',
|
||
`created_at` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '添加时间',
|
||
PRIMARY KEY (`id`) USING BTREE,
|
||
KEY `cx_mch_id` (`cx_mch_id`) USING BTREE,
|
||
KEY `is_delete` (`is_delete`) USING BTREE
|
||
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='微信小程序';
|
||
|
||
-- 数据导出被取消选择。
|
||
|
||
/*!40103 SET TIME_ZONE=IFNULL(@OLD_TIME_ZONE, 'system') */;
|
||
/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
|
||
/*!40014 SET FOREIGN_KEY_CHECKS=IFNULL(@OLD_FOREIGN_KEY_CHECKS, 1) */;
|
||
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
|
||
/*!40111 SET SQL_NOTES=IFNULL(@OLD_SQL_NOTES, 1) */;
|