bore-server/deploy/sql/temple_activity.sql

/*
Navicat MySQL Data Transfer

Source Server         : TestMySql
Source Server Version : 50721
Source Host           : 120.79.211.173:3306
Source Database       : bore

Target Server Type    : MYSQL
Target Server Version : 50721
File Encoding         : 65001

Date: 2020-12-14 14:58:57
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for `temple_activity`
-- ----------------------------
DROP TABLE IF EXISTS `temple_activity`;
CREATE TABLE `temple_activity` (
  `act_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '编号',
  `link_code` varchar(32) NOT NULL COMMENT '活动唯一链接码',
  `title` varchar(64) NOT NULL COMMENT '活动名称',
  `cycle_date` tinyint(3) unsigned NOT NULL COMMENT '活动周期',
  `once_start` varchar(16) NOT NULL COMMENT '一次性活动开始时间',
  `once_end` varchar(16) NOT NULL COMMENT '一次性活动结束时间',
  `disabled` tinyint(3) unsigned NOT NULL COMMENT '活动上下架状态',
  `act_place` varchar(64) NOT NULL COMMENT '活动地点',
  `act_type` varchar(12) NOT NULL COMMENT '活动类型名称',
  `title_img` varchar(128) NOT NULL COMMENT '活动标题图',
  `act_btn` varchar(12) NOT NULL COMMENT '页面底部按钮文本',
  `create_time` timestamp NULL DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`act_id`),
  UNIQUE KEY `temple_activity_linkcode_idx` (`link_code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='寺院活动主表';

-- ----------------------------
-- Table structure for `temple_activity_content`
-- ----------------------------
DROP TABLE IF EXISTS `temple_activity_content`;
CREATE TABLE `temple_activity_content` (
  `act_id` int(10) unsigned NOT NULL COMMENT '活动主表的编号',
  `act_content` text NOT NULL COMMENT '文章内容',
  PRIMARY KEY (`act_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='寺院活动介绍内容表';

-- ----------------------------
-- Table structure for `temple_activity_pay_item`
-- ----------------------------
DROP TABLE IF EXISTS `temple_activity_pay_item`;
CREATE TABLE `temple_activity_pay_item` (
  `item_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '编号',
  `act_id` int(10) unsigned NOT NULL COMMENT '活动主表的编号',
  `item_name` varchar(64) NOT NULL COMMENT '支付项目名称',
  `item_img` varchar(128) NOT NULL COMMENT '支付项目图标',
  `amount` int(10) unsigned NOT NULL COMMENT '支付项目金额',
  PRIMARY KEY (`item_id`),
  KEY `tactivity_actid_idx` (`act_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='寺院活动支付项目';

-- ----------------------------
-- Table structure for `temple_activity_user`
-- ----------------------------
DROP TABLE IF EXISTS `temple_activity_user`;
CREATE TABLE `temple_activity_user` (
  `act_uid` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '活动用户表的编号',
  `act_id` int(10) unsigned NOT NULL COMMENT '活动主表的编号',
  `item_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '支付项的编号',
  `user_id` int(10) unsigned NOT NULL COMMENT '活动参与用户的ID',
  `object_name` varchar(20) NOT NULL COMMENT '对象名称',
  `demand` varchar(64) NOT NULL COMMENT '对象需求',
  `city` varchar(20) NOT NULL COMMENT '要求所在城市',
  `contacts` varchar(20) NOT NULL COMMENT '联系人',
  `contact_tel` varchar(20) NOT NULL COMMENT '联系人电话',
  `ustatus` tinyint(3) unsigned NOT NULL COMMENT '用户参与的状态',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `pay_platform` varchar(12) NOT NULL DEFAULT '' COMMENT '支付平台',
  `pay_status` tinyint(3) unsigned NOT NULL COMMENT '用户支付的状态',
  `amount` decimal(8,2) unsigned NOT NULL COMMENT '支付金额',
  `trade_no` varchar(64) NOT NULL COMMENT '交易号',
  `payed_no` varchar(64) NOT NULL COMMENT '支付的流水号',
  `payed_time` datetime DEFAULT NULL COMMENT '支付时间',
  PRIMARY KEY (`act_uid`),
  KEY `tactivity_useractId_idx` (`act_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='寺院活动参与用户表';