/*
Navicat MySQL Data Transfer
Source Server : vant-shop
Source Server Version : 50727
Source Host : localhost:3306
Source Database : fruit_mall
Target Server Type : MYSQL
Target Server Version : 50727
File Encoding : 65001
Date: 2019-10-19 20:08:43
*/
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for t_areas
-- ----------------------------
DROP TABLE IF EXISTS `t_areas`;
CREATE TABLE `t_areas` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`area_id` varchar(20) NOT NULL,
`area` varchar(50) NOT NULL,
`city_id` varchar(20) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3145 DEFAULT CHARSET=utf8 COMMENT='行政区域县区信息表';
-- ----------------------------
-- Table structure for t_card
-- ----------------------------
DROP TABLE IF EXISTS `t_card`;
CREATE TABLE `t_card` (
`id` int(8) NOT NULL AUTO_INCREMENT,
`name` varchar(255) DEFAULT NULL COMMENT '会员卡名称',
`type` int(1) DEFAULT NULL COMMENT '卡类型(0:会员卡 1:充值卡)',
`price` decimal(10,2) DEFAULT NULL COMMENT '卡内金额',
`sale_price` decimal(10,2) DEFAULT NULL COMMENT '卡销售金额',
`gift_rules` int(8) DEFAULT NULL COMMENT '赠送规则(几个月会员)',
`is_abolish` int(1) DEFAULT NULL COMMENT '是否废除',
`create_time` timestamp NULL DEFAULT NULL COMMENT '创建时间',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb4 COMMENT='卡表';
-- ----------------------------
-- Table structure for t_chat
-- ----------------------------
DROP TABLE IF EXISTS `t_chat`;
CREATE TABLE `t_chat` (
`id` int(8) NOT NULL AUTO_INCREMENT,
`user_id` int(8) DEFAULT NULL,
`customer_service_id` int(8) DEFAULT NULL COMMENT '客服人员id',
`user_speech_record` varchar(255) DEFAULT NULL COMMENT '用户聊天记录',
`cus_ser_speech_record` varchar(255) DEFAULT NULL COMMENT '客服回复记录',
`sort` int(8) DEFAULT NULL COMMENT '排序',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='顾客客服交流表';
-- ----------------------------
-- Table structure for t_cities
-- ----------------------------
DROP TABLE IF EXISTS `t_cities`;
CREATE TABLE `t_cities` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`city_id` varchar(20) NOT NULL,
`city` varchar(50) NOT NULL,
`province_id` varchar(20) NOT NULL,
PRIMARY KEY (`id`),
KEY `INDEX_CITY_ID` (`city_id`) USING BTREE,
KEY `idx_city_id` (`city_id`) USING BTREE,
KEY `idx_province_id` (`province_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=346 DEFAULT CHARSET=utf8 COMMENT='行政区域地州市信息表';
-- ----------------------------
-- Table structure for t_coupon
-- ----------------------------
DROP TABLE IF EXISTS `t_coupon`;
CREATE TABLE `t_coupon` (
`id` int(8) NOT NULL AUTO_INCREMENT,
`code` varchar(255) DEFAULT NULL COMMENT '优惠券code',
`name` varchar(255) DEFAULT NULL COMMENT '优惠券名称',
`price` decimal(10,2) DEFAULT NULL COMMENT '优惠券金额',
`rule` varchar(255) DEFAULT NULL COMMENT '优惠券规则',
`is_threshold` int(1) DEFAULT NULL COMMENT '是否有使用门槛(0:是 1:否)',
`threshold_price` decimal(10,2) DEFAULT NULL COMMENT '门槛金额',
`coupon_describe` varchar(255) DEFAULT NULL COMMENT '优惠券使用说明',
`exp_days` int(8) DEFAULT NULL COMMENT '有效天数',
`is_invalid` int(1) DEFAULT NULL COMMENT '是否作废(0:是 1:否)',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8mb4 COMMENT='优惠券';
-- ----------------------------
-- Table structure for t_customer_service
-- ----------------------------
DROP TABLE IF EXISTS `t_customer_service`;
CREATE TABLE `t_customer_service` (
`id` int(8) NOT NULL,
`name` varchar(255) DEFAULT NULL COMMENT '客服名称',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='客服表';
-- ----------------------------
-- Table structure for t_freight
-- ----------------------------
DROP TABLE IF EXISTS `t_freight`;
CREATE TABLE `t_freight` (
`id` int(8) NOT NULL AUTO_INCREMENT,
`is_city` int(1) DEFAULT NULL COMMENT '是否常州市内',
`rule` varchar(255) DEFAULT NULL COMMENT '规格',
`price` decimal(10,2) DEFAULT NULL COMMENT '门槛运费',
`freight_price` decimal(10,2) DEFAULT NULL COMMENT '运费',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COMMENT='运费表';
-- ----------------------------
-- Table structure for t_fruit
-- ----------------------------
DROP TABLE IF EXISTS `t_fruit`;
CREATE TABLE `t_fruit` (
`id` int(8) NOT NULL AUTO_INCREMENT,
`name` varchar(255) DEFAULT NULL COMMENT '水果名称',
`price` decimal(10,2) DEFAULT NULL COMMENT '价格',
`place` varchar(255) DEFAULT NULL COMMENT '产地',
`fruit_describe` varchar(255) DEFAULT NULL COMMENT '水果描述',
`create_time` timestamp NULL DEFAULT NULL COMMENT '创建时间',
`is_new` int(1) DEFAULT NULL COMMENT '是否新品(0:是 1:否)',
`is_advance_sale` int(1) DEFAULT NULL COMMENT '是否预售(0:是 1:否)',
`is_integral` int(1) DEFAULT NULL COMMENT '是否积分水果(0: 是1: 否)',
`integral` int(8) DEFAULT NULL COMMENT '积分数',
`status` int(8) DEFAULT NULL COMMENT '状态(0:草稿 1:发布 2:下架)',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=50 DEFAULT CHARSET=utf8mb4 COMMENT='水果';
-- ----------------------------
-- Table structure for t_fruit_image
-- ----------------------------
DROP TABLE IF EXISTS `t_fruit_image`;
CREATE TABLE `t_fruit_image` (
`id` int(8) NOT NULL AUTO_INCREMENT,
`fruit_id` int(8) DEFAULT NULL,
`image` varchar(255) DEFAULT NULL COMMENT '图片',
`type` int(1) DEFAULT NULL COMMENT '图片类型(1：缩略图 2：轮播图 3：详情图 4：首页轮播图）',
`create_time` timestamp NULL DEFAULT NULL COMMENT '创建时间',
`is_index_rotation_chart` int(1) DEFAULT NULL COMMENT '是否首页轮播(1:是 2:否）',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=141 DEFAULT CHARSET=utf8mb4 COMMENT='水果图片';
-- ----------------------------
-- Table structure for t_fruit_specifications
-- ----------------------------
DROP TABLE IF EXISTS `t_fruit_specifications`;
CREATE TABLE `t_fruit_specifications` (
`id` int(8) NOT NULL AUTO_INCREMENT,
`fruit_id` int(8) DEFAULT NULL COMMENT '水果',
`specifications` varchar(255) DEFAULT NULL COMMENT '规格',
`fruit_number` int(8) DEFAULT NULL COMMENT '水果数量',
`is_integral` int(1) DEFAULT NULL COMMENT '是否是积分商品(0:是 1:否)',
`integral` int(8) DEFAULT NULL COMMENT '积分',
`price` decimal(10,2) DEFAULT NULL COMMENT '实际价格',
`member_price` decimal(10,2) DEFAULT NULL COMMENT '会员价',
`opening_num` int(8) DEFAULT NULL COMMENT '开团人数',
`opening_price` decimal(10,2) DEFAULT NULL COMMENT '开团价格',
`advance_price` decimal(10,2) DEFAULT NULL COMMENT '预售价格',
`freight_price` decimal(10,2) DEFAULT NULL COMMENT '运费',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=24 DEFAULT CHARSET=utf8mb4 COMMENT='水果规格';
-- ----------------------------
-- Table structure for t_fruit_type
-- ----------------------------
DROP TABLE IF EXISTS `t_fruit_type`;
CREATE TABLE `t_fruit_type` (
`id` int(8) NOT NULL AUTO_INCREMENT,
`type_id` int(8) DEFAULT NULL COMMENT '类型id',
`fruit_id` int(8) DEFAULT NULL COMMENT '水果id',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=92 DEFAULT CHARSET=utf8mb4;
-- ----------------------------
-- Table structure for t_group_buying
-- ----------------------------
DROP TABLE IF EXISTS `t_group_buying`;
CREATE TABLE `t_group_buying` (
`id` int(8) NOT NULL AUTO_INCREMENT,
`fruit_id` int(8) DEFAULT NULL COMMENT '水果id',
`status` int(1) DEFAULT NULL COMMENT '是否团购(0:是1:否)',
`start_time` timestamp NULL DEFAULT NULL COMMENT '开始时间',
`end_time` timestamp NULL DEFAULT NULL COMMENT '结束时间',
`specifications` varchar(255) DEFAULT NULL COMMENT '规格(几人团)',
`describe` varchar(255) DEFAULT NULL COMMENT '描述',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='团购';
-- ----------------------------
-- Table structure for t_member
-- ----------------------------
DROP TABLE IF EXISTS `t_member`;
CREATE TABLE `t_member` (
`id` int(8) NOT NULL AUTO_INCREMENT,
`name` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '会员名称',
`price` decimal(10,2) DEFAULT NULL COMMENT '会员金额',
`discount_price` decimal(10,2) DEFAULT NULL COMMENT '优惠价格',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8mb4 COMMENT='会员表';
-- ----------------------------
-- Table structure for t_notice
-- ----------------------------
DROP TABLE IF EXISTS `t_notice`;
CREATE TABLE `t_notice` (
`id` int(8) NOT NULL AUTO_INCREMENT,
`notice` varchar(255) DEFAULT NULL COMMENT '公告内容',
`is_show` int(1) DEFAULT NULL COMMENT '是否显示(0:是 1:否)',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COMMENT='公告表';
-- ----------------------------
-- Table structure for t_order
-- ----------------------------
DROP TABLE IF EXISTS `t_order`;
CREATE TABLE `t_order` (
`id` int(8) NOT NULL AUTO_INCREMENT,
`code` varchar(255) DEFAULT NULL COMMENT '订单编号',
`user_id` int(8) DEFAULT NULL COMMENT '用户id',
`create_time` timestamp NULL DEFAULT NULL COMMENT '创建时间',
`order_type` int(1) DEFAULT NULL COMMENT '订单类型(0：销售订单 1：退货订单)',
`status` int(1) DEFAULT NULL COMMENT '订单状态(0:待付款1:待发货2:已发货3:待评价4::取消5:完成6：退货）',
`return_reason` varchar(255) DEFAULT NULL COMMENT '退货原因',
`deliver_time` timestamp NULL DEFAULT NULL COMMENT '发货时间',
`is_goods` int(1) DEFAULT NULL COMMENT '是否收货(0:收货 1：未收货)',
`goods_time` timestamp NULL DEFAULT NULL COMMENT '收货时间',
`coupon_id` int(8) DEFAULT NULL COMMENT '优惠券id',
`goods_price` decimal(10,2) DEFAULT NULL COMMENT '运费金额',
`money_status` int(1) DEFAULT NULL COMMENT '是否收费(0:已收费 1:未收费)',
`pay_type` int(1) DEFAULT NULL COMMENT '支付方式(0:微信 1:支付宝)',
`fee_oper_time` timestamp NULL DEFAULT NULL COMMENT '收费时间',
`fee_amount` decimal(10,2) DEFAULT NULL COMMENT '收费金额',
`total_price` decimal(10,2) NOT NULL COMMENT '商品金额',
`discount_total_price` decimal(10,2) DEFAULT NULL COMMENT '折后总金额',
`deliver_type` int(1) DEFAULT NULL COMMENT '配送类型',
`remark` varchar(255) DEFAULT NULL COMMENT '卖家留言',
`address_id` int(8) DEFAULT NULL COMMENT '地址id',
`out_trade_no` varchar(255) DEFAULT NULL COMMENT '商户订单号',
`evaluate` varchar(255) DEFAULT NULL COMMENT '卖家评价',
`close_time` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '完成时间',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=32 DEFAULT CHARSET=utf8mb4 COMMENT='订单表';
-- ----------------------------
-- Table structure for t_order_fruit
-- ----------------------------
DROP TABLE IF EXISTS `t_order_fruit`;
CREATE TABLE `t_order_fruit` (
`id` int(8) NOT NULL AUTO_INCREMENT,
`order_id` int(8) DEFAULT NULL COMMENT '订单id',
`fruit_id` int(8) DEFAULT NULL COMMENT '水果id',
`fruit_specifications_id` int(8) DEFAULT NULL COMMENT '规格id',
`fruit_num` int(8) DEFAULT NULL COMMENT '水果规格数量',
`price` decimal(10,2) DEFAULT NULL COMMENT '价格',
`total_price` decimal(10,2) DEFAULT NULL COMMENT '总价格',
`create_time` timestamp NULL DEFAULT NULL COMMENT '创建时间',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=33 DEFAULT CHARSET=utf8mb4 COMMENT='订单详情表';
-- ----------------------------
-- Table structure for t_permission
-- ----------------------------
DROP TABLE IF EXISTS `t_permission`;
CREATE TABLE `t_permission` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`parent_id` int(11) DEFAULT NULL COMMENT '父节点ID',
`name` varchar(32) DEFAULT NULL COMMENT '名称',
`code` varchar(32) DEFAULT NULL COMMENT '编码',
`sort` tinyint(4) DEFAULT NULL COMMENT '排序',
`url` varchar(128) DEFAULT NULL COMMENT 'URL',
`level` int(11) DEFAULT NULL,
`status` int(1) DEFAULT '1' COMMENT '是否使用 1：使用 -1：废除，',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=utf8 COMMENT='权限';
-- ----------------------------
-- Table structure for t_planting
-- ----------------------------
DROP TABLE IF EXISTS `t_planting`;
CREATE TABLE `t_planting` (
`id` int(8) NOT NULL AUTO_INCREMENT,
`code` varchar(255) DEFAULT NULL COMMENT '编号',
`supplier_name` varchar(255) DEFAULT NULL COMMENT '供应商名称',
`account` varchar(255) DEFAULT NULL COMMENT '供应商账号',
`password` varchar(255) DEFAULT NULL COMMENT '供应商密码',
`fruit_id` int(11) DEFAULT NULL COMMENT '水果名称',
`fruit_name` varchar(255) DEFAULT NULL,
`planting_time` datetime DEFAULT NULL COMMENT '预计种植时间',
`planting_number` int(8) DEFAULT NULL COMMENT '预计种植数量',
`maturation_time` datetime DEFAULT NULL COMMENT '预计成熟时间',
`maturation_number` int(8) DEFAULT NULL COMMENT '预计成熟产量(个数/斤)',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COMMENT='果园供应商';
-- ----------------------------
-- Table structure for t_provinces
-- ----------------------------
DROP TABLE IF EXISTS `t_provinces`;
CREATE TABLE `t_provinces` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`province_id` varchar(20) NOT NULL,
`province` varchar(50) NOT NULL,
PRIMARY KEY (`id`),
KEY `INDEX_PROVINCE_ID` (`province_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=35 DEFAULT CHARSET=utf8 COMMENT='省份信息表';
-- ----------------------------
-- Table structure for t_recepit
-- ----------------------------
DROP TABLE IF EXISTS `t_recepit`;
CREATE TABLE `t_recepit` (
`id` int(8) NOT NULL AUTO_INCREMENT,
`code` varchar(255) DEFAULT NULL COMMENT '进货编号',
`supply` int(11) DEFAULT NULL COMMENT '供应商',
`fruit_id` int(8) DEFAULT NULL COMMENT '水果id',
`number` int(8) DEFAULT NULL COMMENT '进货数量',
`price` decimal(10,2) DEFAULT NULL COMMENT '进货价格',
`create_time` date DEFAULT NULL COMMENT '进货时间',
`status` int(11) DEFAULT NULL COMMENT '状态(是否入库0:入库1：未入库)',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COMMENT='进货表';
-- ----------------------------
-- Table structure for t_register
-- ----------------------------
DROP TABLE IF EXISTS `t_register`;
CREATE TABLE `t_register` (
`id` int(8) NOT NULL AUTO_INCREMENT,
`user_id` int(8) DEFAULT NULL COMMENT '用户id',
`register_time` date DEFAULT NULL COMMENT '签到时间',
`is_register` int(1) DEFAULT '0' COMMENT '是否签到(0:是 1:否)',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=58 DEFAULT CHARSET=utf8mb4 COMMENT='签到表';
-- ----------------------------
-- Table structure for t_register_integral
-- ----------------------------
DROP TABLE IF EXISTS `t_register_integral`;
CREATE TABLE `t_register_integral` (
`id` int(8) NOT NULL AUTO_INCREMENT,
`days` int(8) DEFAULT NULL COMMENT '连续签到天数',
`integral` int(8) DEFAULT NULL COMMENT '积分',
`coupon_id` int(8) DEFAULT NULL COMMENT '优惠券id',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COMMENT='签到积分表';
-- ----------------------------
-- Table structure for t_shopping_cart
-- ----------------------------
DROP TABLE IF EXISTS `t_shopping_cart`;
CREATE TABLE `t_shopping_cart` (
`id` int(8) NOT NULL AUTO_INCREMENT,
`user_id` int(8) DEFAULT NULL COMMENT '用户id',
`fruit_id` int(8) DEFAULT NULL COMMENT '水果id',
`fruit_specifications_id` int(8) DEFAULT NULL COMMENT '水果规格id',
`fruit_num` int(8) DEFAULT NULL COMMENT '水果规格数量',
`is_choose` int(1) DEFAULT NULL COMMENT '是否选择(0:是 1:否)',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=74 DEFAULT CHARSET=utf8mb4 COMMENT='购物车';
-- ----------------------------
-- Table structure for t_storage
-- ----------------------------
DROP TABLE IF EXISTS `t_storage`;
CREATE TABLE `t_storage` (
`id` int(8) NOT NULL AUTO_INCREMENT,
`fruit_id` int(8) DEFAULT NULL COMMENT '水果id',
`fruit_number` int(8) DEFAULT NULL COMMENT '库存水果数量',
`status` int(1) DEFAULT NULL COMMENT '状态(0:正常 1:异常)',
`recepit_id` int(8) DEFAULT NULL COMMENT '进货id',
`create_time` timestamp NULL DEFAULT NULL COMMENT '创建时间',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COMMENT='库存';
-- ----------------------------
-- Table structure for t_storage_record
-- ----------------------------
DROP TABLE IF EXISTS `t_storage_record`;
CREATE TABLE `t_storage_record` (
`id` int(8) NOT NULL AUTO_INCREMENT,
`order_id` int(8) DEFAULT NULL COMMENT '订单id',
`storage_id` int(8) DEFAULT NULL COMMENT '库存id',
`fruit_id` int(8) DEFAULT NULL COMMENT '水果id',
`fruit_number` int(8) DEFAULT NULL COMMENT '水果数量',
`is_add` int(1) DEFAULT NULL COMMENT '0: 退货(增加) 1:销售(减少)',
`create_time` timestamp NULL DEFAULT NULL COMMENT '创建时间',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=207 DEFAULT CHARSET=utf8mb4 COMMENT='库存记录';
-- ----------------------------
-- Table structure for t_task
-- ----------------------------
DROP TABLE IF EXISTS `t_task`;
CREATE TABLE `t_task` (
`id` int(8) NOT NULL AUTO_INCREMENT,
`name` varchar(255) DEFAULT NULL COMMENT '任务名称',
`type` int(1) DEFAULT NULL COMMENT '任务类型(1:基础任务2:购物任务3：活跃任务)',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COMMENT='任务表';
-- ----------------------------
-- Table structure for t_task_record
-- ----------------------------
DROP TABLE IF EXISTS `t_task_record`;
CREATE TABLE `t_task_record` (
`id` int(8) NOT NULL AUTO_INCREMENT,
`user_id` int(8) DEFAULT NULL COMMENT '用户id',
`task_id` int(8) DEFAULT NULL COMMENT '任务id',
`status` int(1) DEFAULT NULL COMMENT '任务状态(0:完成 1:未完成)',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='任务记录';
-- ----------------------------
-- Table structure for t_type
-- ----------------------------
DROP TABLE IF EXISTS `t_type`;
CREATE TABLE `t_type` (
`id` int(8) NOT NULL AUTO_INCREMENT,
`name` varchar(255) DEFAULT NULL COMMENT '水果分类名称',
`is_use` int(1) DEFAULT '0' COMMENT '是否使用(0:使用 1:停用)',
`create_time` timestamp NULL DEFAULT NULL COMMENT '创建时间',
`sort` int(8) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=27 DEFAULT CHARSET=utf8mb4 COMMENT='水果分类';
-- ----------------------------
-- Table structure for t_user
-- ----------------------------
DROP TABLE IF EXISTS `t_user`;
CREATE TABLE `t_user` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`code` int(32) DEFAULT NULL COMMENT '用户code/卡号(11位)',
`wx_open_id` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '微信openId',
`wx_nickname` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '昵称',
`wx_image` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '微信头像地址',
`name` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '姓名',
`phone` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '手机号码',
`sex` varchar(255) DEFAULT NULL COMMENT '0：未知 1：男性 2：女性',
`birth_day` date DEFAULT NULL COMMENT '出生日期',
`province` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '省份',
`city` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '城市',
`county` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '地区',
`wx_id` int(8) DEFAULT NULL,
`create_time` timestamp NULL DEFAULT NULL COMMENT '创建时间',
`integral` int(8) DEFAULT '0' COMMENT '积分值',
`is_empower` int(1) DEFAULT '1' COMMENT '是否授权(0:是 1:否)',
`is_member` int(1) DEFAULT NULL COMMENT '是否会员(0:是 1:否)',
`member_start_time` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '会员开始时间',
`member_end_time` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '会员结束时间',
`user_balance` decimal(8,2) DEFAULT '0.00' COMMENT '用户余额',
`area_code` varchar(255) DEFAULT NULL,
`area_str` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `index_open_id` (`wx_open_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8mb4 COMMENT='用户';
-- ----------------------------
-- Table structure for t_user_address
-- ----------------------------
DROP TABLE IF EXISTS `t_user_address`;
CREATE TABLE `t_user_address` (
`id` int(8) NOT NULL AUTO_INCREMENT,
`user_id` int(8) DEFAULT NULL COMMENT '用户id',
`name` varchar(255) DEFAULT NULL COMMENT '收货人姓名',
`tel` varchar(11) DEFAULT NULL COMMENT '收货人手机号',
`province` varchar(255) DEFAULT NULL COMMENT '省份',
`city` varchar(255) DEFAULT NULL COMMENT '城市',
`county` varchar(255) DEFAULT NULL COMMENT '地区',
`address_detail` varchar(255) DEFAULT NULL COMMENT '详细地址',
`area_code` varchar(255) DEFAULT NULL COMMENT '地区编码通过省市区选择获取',
`postal_code` varchar(255) DEFAULT NULL COMMENT '邮政编码',
`is_default` int(1) DEFAULT NULL COMMENT '是否默认(0:是 1:否)',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=73 DEFAULT CHARSET=utf8mb4 COMMENT='用户地址表';
-- ----------------------------
-- Table structure for t_user_card
-- ----------------------------
DROP TABLE IF EXISTS `t_user_card`;
CREATE TABLE `t_user_card` (
`id` int(8) NOT NULL AUTO_INCREMENT,
`user_id` int(8) DEFAULT NULL,
`card_id` int(8) DEFAULT NULL,
`type` int(1) DEFAULT NULL COMMENT '类型(0:消费 1:充值)',
`price` decimal(10,2) DEFAULT NULL COMMENT '金额',
`create_time` timestamp NULL DEFAULT NULL COMMENT '创建时间',
`money_status` int(1) DEFAULT NULL COMMENT '是否收费(0:是 1:否)',
`out_trade_no` varchar(255) DEFAULT NULL COMMENT '商户订单号',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='用户使用卡记录';
-- ----------------------------
-- Table structure for t_user_coupon
-- ----------------------------
DROP TABLE IF EXISTS `t_user_coupon`;
CREATE TABLE `t_user_coupon` (
`id` int(8) NOT NULL AUTO_INCREMENT,
`user_id` int(8) DEFAULT NULL COMMENT '用户id',
`coupon_id` int(8) DEFAULT NULL COMMENT '优惠券id',
`is_invalid` int(1) DEFAULT NULL COMMENT '是否失效(0:是 1:否)',
`is_use` int(1) DEFAULT NULL COMMENT '是否使用（0:是 1:否）',
`start_time` timestamp NULL DEFAULT NULL COMMENT '开始时间/领券时间',
`end_time` timestamp NULL DEFAULT NULL COMMENT '结束时间/失效时间',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=38 DEFAULT CHARSET=utf8mb4 COMMENT='用户优惠券';
-- ----------------------------
-- Table structure for t_user_integral
-- ----------------------------
DROP TABLE IF EXISTS `t_user_integral`;
CREATE TABLE `t_user_integral` (
`id` int(8) NOT NULL AUTO_INCREMENT,
`user_id` int(8) DEFAULT NULL COMMENT '用户id',
`integral` int(32) DEFAULT NULL COMMENT '积分',
`integral_type` int(1) DEFAULT NULL COMMENT '积分类型(来源：1、签到2、消费3、关注公众号4、支出 5、连续签到）',
`create_time` timestamp NULL DEFAULT NULL COMMENT '创建时间',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=82 DEFAULT CHARSET=utf8mb4 COMMENT='用户积分明细表';
-- ----------------------------
-- Table structure for t_user_integral_rule
-- ----------------------------
DROP TABLE IF EXISTS `t_user_integral_rule`;
CREATE TABLE `t_user_integral_rule` (
`id` int(8) NOT NULL AUTO_INCREMENT,
`name` varchar(255) DEFAULT NULL COMMENT '名称',
`integral` int(8) DEFAULT NULL COMMENT '积分',
`price` decimal(10,2) DEFAULT NULL COMMENT '抵扣的金额',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4;
-- ----------------------------
-- Table structure for t_user_login
-- ----------------------------
DROP TABLE IF EXISTS `t_user_login`;
CREATE TABLE `t_user_login` (
`id` int(8) NOT NULL AUTO_INCREMENT,
`name` varchar(255) DEFAULT NULL,
`account` varchar(255) DEFAULT NULL,
`password` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4;
-- ----------------------------
-- Table structure for t_user_money
-- ----------------------------
DROP TABLE IF EXISTS `t_user_money`;
CREATE TABLE `t_user_money` (
`id` int(8) NOT NULL AUTO_INCREMENT,
`user_id` int(8) DEFAULT NULL,
`money` decimal(10,2) DEFAULT NULL COMMENT '本金',
`create_time` timestamp NULL DEFAULT NULL COMMENT '创建时间',
`update_time` timestamp NULL DEFAULT NULL COMMENT '修改时间',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='用户金钱明细表';
-- ----------------------------
-- Table structure for t_user_transaction_record
-- ----------------------------
DROP TABLE IF EXISTS `t_user_transaction_record`;
CREATE TABLE `t_user_transaction_record` (
`id` int(8) NOT NULL AUTO_INCREMENT,
`user_id` int(8) DEFAULT NULL,
`type` int(1) DEFAULT NULL COMMENT '交易类型(0:充值 1：消费 2：退款 3：其他)',
`money` double(8,2) DEFAULT NULL COMMENT '交易金额',
`create_time` timestamp NULL DEFAULT NULL COMMENT '创建时间',
`update_time` timestamp NULL DEFAULT NULL COMMENT '修改时间',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COMMENT='用户交易记录明细表';
