zianxin/pj_service_cloud
1
0 Fork 0
Code Issues Pull Requests Actions Packages Projects Releases Wiki Activity
Files
master
pj_service_cloud/db/800pjcloudx_wallet.sql
T

700 lines
43 KiB
SQL
Raw Permalink Blame History

create database `pjcloudx_wallet` default character set utf8mb4 collate utf8mb4_general_ci;
-- ----------------------------
-- Table structure for sys_user_transaction
-- ----------------------------
DROP TABLE IF EXISTS sys_user_transaction;
CREATE TABLE `sys_user_transaction`
(
id bigint NOT NULL COMMENT '编号',
apply_user_id bigint NOT NULL COMMENT '申请用户id',
user_id bigint NOT NULL COMMENT '用户id',
biz_id bigint DEFAULT NULL COMMENT '业务id',
biz_type varchar(32) NOT NULL COMMENT '业务类型',
# 岗位调动字段
source_dept_id bigint DEFAULT NULL COMMENT '源部门id',
target_dept_id bigint DEFAULT NULL COMMENT '目标部门id',
# 离职字段
is_wallet_transaction varchar(32) DEFAULT NULL COMMENT '是否离职自动转账',
wallet_transaction_time datetime DEFAULT NULL COMMENT '离职自动转账时间',
# 审批字读
process_id varchar(256) DEFAULT NULL COMMENT '流程id',
process_status varchar(10) DEFAULT NULL COMMENT '审核状体',
process_time datetime DEFAULT NULL COMMENT '审核时间',
remark varchar(1024) DEFAULT NULL COMMENT '备注',
create_by varchar(64) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '创建人',
create_time datetime DEFAULT NULL COMMENT '创建时间',
update_by varchar(64) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '修改人',
update_time datetime DEFAULT NULL COMMENT '修改时间',
del_flag char(1) COLLATE utf8mb4_general_ci DEFAULT '0' COMMENT '删除标记',
tenant_id bigint DEFAULT NULL COMMENT '租户ID',
PRIMARY KEY (id)
) ENGINE = InnoDB
DEFAULT CHARSET = utf8mb4
COLLATE = utf8mb4_general_ci COMMENT ='人员调动表';
-- ----------------------------
-- Table structure for sys_user_face
-- ----------------------------
DROP TABLE IF EXISTS sys_user_face;
CREATE TABLE `sys_user_face`
(
id bigint NOT NULL COMMENT '编号',
auto_code varchar(1024) DEFAULT NULL COMMENT '自增code',
user_id bigint NOT NULL COMMENT '用户ID',
process_id varchar(256) COMMENT '流程id',
process_status varchar(10) COMMENT '审核状体',
process_time datetime COMMENT '审核时间',
face_img varchar(256) NOT NULL COMMENT '人脸图片',
create_by varchar(64) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '创建人',
create_time datetime DEFAULT NULL COMMENT '创建时间',
update_by varchar(64) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '修改人',
update_time datetime DEFAULT NULL COMMENT '修改时间',
del_flag char(1) COLLATE utf8mb4_general_ci DEFAULT '0' COMMENT '删除标记',
tenant_id bigint DEFAULT NULL COMMENT '租户ID',
PRIMARY KEY (id)
) ENGINE = InnoDB
DEFAULT CHARSET = utf8mb4
COLLATE = utf8mb4_general_ci COMMENT ='人脸样本表';
CREATE INDEX idx_dept_id ON sys_user_face (user_id);
-- ----------------------------
-- Table structure for sys_user_car
-- ----------------------------
DROP TABLE IF EXISTS sys_user_car;
CREATE TABLE `sys_user_car`
(
id bigint NOT NULL COMMENT '编号',
user_id bigint NOT NULL COMMENT '用户ID',
car_number char(64) COMMENT '车牌号',
car_type char(32) COMMENT '车辆类型(字典)',
enable_status char(32) COMMENT '启用状态(字典)',
process_id varchar(256) COMMENT '流程id',
process_status varchar(10) NOT NULL COMMENT '审核状体',
process_time datetime COMMENT '审核时间',
create_by varchar(64) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '创建人',
create_time datetime DEFAULT NULL COMMENT '创建时间',
update_by varchar(64) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '修改人',
update_time datetime DEFAULT NULL COMMENT '修改时间',
del_flag char(1) COLLATE utf8mb4_general_ci DEFAULT '0' COMMENT '删除标记',
tenant_id bigint DEFAULT NULL COMMENT '租户ID',
PRIMARY KEY (id)
) ENGINE = InnoDB
DEFAULT CHARSET = utf8mb4
COLLATE = utf8mb4_general_ci COMMENT ='人员车辆表';
-- ----------------------------
-- Table structure for mch_manage
-- ----------------------------
DROP TABLE IF EXISTS `mch_manage`;
CREATE TABLE mch_manage
(
id bigint NOT NULL COMMENT '主键',
parent_id bigint NOT NULL COMMENT '主键',
dept_id bigint NOT NULL COMMENT '绑定的部门id',
default_wallet_type_id bigint DEFAULT NULL COMMENT '商户默认使用的钱包类型',
hard_group_id bigint COMMENT '设备分组id',
name varchar(64) NOT NULL COMMENT '商户名',
types varchar(64) NOT NULL COMMENT '店铺类型,逗号分隔',
logo_pic varchar(256) NOT NULL COMMENT '商户logo图片',
collection_code varchar(256) DEFAULT '' COMMENT '商户收款码,自动生成',
swiper_pic text DEFAULT NULL COMMENT '商户轮播图,逗号分隔',
phone varchar(128) DEFAULT '' COMMENT '商户手机号',
job_time varchar(256) DEFAULT NULL COMMENT '商户营业时间',
address_des varchar(256) DEFAULT NULL COMMENT '商户地址',
sort int NOT NULL COMMENT '排序',
discounts_price varchar(256) NOT NULL COMMENT '优惠价格(没实际作用)',
discounts_rate int DEFAULT NULL COMMENT '优惠折扣(1-99,10=1折)',
cooperation_status varchar(64) NOT NULL COMMENT '合作状态',
mch_count int NOT NULL COMMENT '分店数量',
create_by varchar(64) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '创建人',
create_time datetime DEFAULT NULL COMMENT '创建时间',
update_by varchar(64) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '修改人',
update_time datetime DEFAULT NULL COMMENT '修改时间',
del_flag char(1) COLLATE utf8mb4_general_ci DEFAULT '0' COMMENT '删除标记',
tenant_id bigint DEFAULT NULL COMMENT '租户ID',
PRIMARY KEY (id)
) ENGINE = InnoDB
DEFAULT CHARSET = utf8mb4
COLLATE = utf8mb4_general_ci COMMENT ='商户管理';
CREATE INDEX idx_dept_id ON mch_manage (dept_id);
-- ----------------------------
-- Table structure for mch_catgory
-- ----------------------------
DROP TABLE IF EXISTS `mch_catgory`;
CREATE TABLE mch_catgory
(
id bigint NOT NULL COMMENT '主键',
name varchar(64) NOT NULL COMMENT '分类名',
biz_type varchar(64) NOT NULL COMMENT '分类名类型',
sort int DEFAULT 0 COMMENT '排序',
remark varchar(512) DEFAULT '' COMMENT '备注',
create_by varchar(64) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '创建人',
create_time datetime DEFAULT NULL COMMENT '创建时间',
update_by varchar(64) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '修改人',
update_time datetime DEFAULT NULL COMMENT '修改时间',
del_flag char(1) COLLATE utf8mb4_general_ci DEFAULT '0' COMMENT '删除标记',
tenant_id bigint DEFAULT NULL COMMENT '租户ID',
PRIMARY KEY (id)
) ENGINE = InnoDB
DEFAULT CHARSET = utf8mb4
COLLATE = utf8mb4_general_ci COMMENT ='商户分类表';
-- ----------------------------
-- Table structure for mch_dpet_user
-- ----------------------------
DROP TABLE IF EXISTS `mch_dept`;
CREATE TABLE mch_dept
(
id BIGINT(19) not null comment '主键',
mch_id BIGINT(19) not null comment '商户id',
dept_id BIGINT(19) not null comment '部门id',
create_by VARCHAR(64) null comment '创建人',
create_time DATETIME null comment '创建时间',
update_by VARCHAR(64) null comment '修改人',
update_time DATETIME null comment '修改时间',
del_flag CHAR default '0' null comment '删除标记',
tenant_id BIGINT(19) null comment '租户ID',
PRIMARY KEY (id)
) ENGINE = InnoDB
DEFAULT CHARSET = utf8mb4
COLLATE = utf8mb4_general_ci COMMENT ='商户部门关系表';
-- ----------------------------
-- Table structure for wallet_manage
-- ----------------------------
DROP TABLE IF EXISTS wallet_manage;
CREATE TABLE wallet_manage
(
id bigint NOT NULL COMMENT '主键',
user_id bigint NOT NULL COMMENT '饭卡绑定的用户id',
wallet_type_id bigint NOT NULL COMMENT '饭卡类型id',
dept_id bigint NOT NULL COMMENT '部门id',
card_number varchar(64) COMMENT '饭卡卡号',
balance int DEFAULT 0 NOT NULL COMMENT '余额，单位分',
total_expense int DEFAULT 0 NOT NULL COMMENT '累计支出，单位分',
total_recharge int DEFAULT 0 NOT NULL COMMENT '累计充值，单位分',
freeze_price int DEFAULT 0 NOT NULL COMMENT '冻结金额，单位分',
is_freeze char(1) DEFAULT '0' NOT NULL COMMENT '是否冻结饭卡',
active_bind_time timestamp COMMENT '绑定饭卡时间',
status char(10) COMMENT '饭卡绑定状态',
create_by varchar(64) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '创建人',
create_time datetime DEFAULT NULL COMMENT '创建时间',
update_by varchar(64) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '修改人',
update_time datetime DEFAULT NULL COMMENT '修改时间',
del_flag char(1) COLLATE utf8mb4_general_ci DEFAULT '0' COMMENT '删除标记',
tenant_id bigint DEFAULT NULL COMMENT '租户ID',
PRIMARY KEY (id)
) ENGINE = InnoDB
DEFAULT CHARSET = utf8mb4
COLLATE = utf8mb4_general_ci COMMENT ='钱包管理';
CREATE INDEX idx_dept_id ON wallet_manage (user_id);
-- ----------------------------
-- Table structure for mch_rule_price_config
-- ----------------------------
DROP TABLE IF EXISTS mch_rule_price_config;
CREATE TABLE mch_rule_price_config
(
id BIGINT(19) not null comment '主键',
rule_price_type VARCHAR(64) not null comment '规则类型',
base_price BIGINT(19) not null comment '基础金额',
multiple BIGINT(19) not null comment '额外支付的倍数',
create_by varchar(64) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '创建人',
create_time datetime DEFAULT NULL COMMENT '创建时间',
update_by varchar(64) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '修改人',
update_time datetime DEFAULT NULL COMMENT '修改时间',
del_flag char(1) COLLATE utf8mb4_general_ci DEFAULT '0' COMMENT '删除标记',
tenant_id bigint DEFAULT NULL COMMENT '租户ID',
PRIMARY KEY (id)
) ENGINE = InnoDB
DEFAULT CHARSET = utf8mb4
COLLATE = utf8mb4_general_ci COMMENT = '商家商品价格配置表';
-- ----------------------------
-- Table structure for mch_rule_join
-- ----------------------------
DROP TABLE IF EXISTS mch_rule_join;
CREATE TABLE mch_rule_join
(
id BIGINT(19) not null comment '主键',
source_mch_id BIGINT(19) not null comment '源商户id',
target_mch_id BIGINT(19) not null comment '目标商户id',
target_dept_id BIGINT(19) not null comment '目标部门id',
rule_price_config_id BIGINT(19) not null comment '规则配置id',
status VARCHAR(64) default '0' not null comment '是否启用',
create_by varchar(64) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '创建人',
create_time datetime DEFAULT NULL COMMENT '创建时间',
update_by varchar(64) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '修改人',
update_time datetime DEFAULT NULL COMMENT '修改时间',
del_flag char(1) COLLATE utf8mb4_general_ci DEFAULT '0' COMMENT '删除标记',
tenant_id bigint DEFAULT NULL COMMENT '租户ID',
PRIMARY KEY (id)
) ENGINE = InnoDB
DEFAULT CHARSET = utf8mb4
COLLATE = utf8mb4_general_ci COMMENT = '商户规格配置表';
-- ----------------------------
-- Table structure for wallet_type
-- ----------------------------
DROP TABLE IF EXISTS wallet_type;
CREATE TABLE wallet_type
(
id bigint NOT NULL COMMENT '主键',
name varchar(64) NOT NULL COMMENT '钱包名',
icon varchar(256) NOT NULL COMMENT '钱包图标',
unique_code varchar(16) COMMENT '饭卡code',
is_rule char(1) DEFAULT '0' NOT NULL COMMENT '是否启用钱包转账规则',
create_by varchar(64) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '创建人',
create_time datetime DEFAULT NULL COMMENT '创建时间',
update_by varchar(64) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '修改人',
update_time datetime DEFAULT NULL COMMENT '修改时间',
del_flag char(1) COLLATE utf8mb4_general_ci DEFAULT '0' COMMENT '删除标记',
tenant_id bigint DEFAULT NULL COMMENT '租户ID',
PRIMARY KEY (id)
) ENGINE = InnoDB
DEFAULT CHARSET = utf8mb4 COMMENT ='钱包类型';
-- ----------------------------
-- Table structure for wallet_rule_join
-- ----------------------------
DROP TABLE IF EXISTS wallet_rule_join;
CREATE TABLE wallet_rule_join
(
id BIGINT(19) not null comment '主键',
source_wallet_type_id BIGINT(19) not null comment '源钱包类型id',
target_wallet_type_id BIGINT(19) not null comment '目标钱包类型id',
target_dept_id BIGINT(19) not null comment '目标部门id',
balance_multiple int DEFAULT 0 NOT NULL COMMENT '钱包转换百分比',
status VARCHAR(64) default '0' not null comment '是否启用',
create_by varchar(64) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '创建人',
create_time datetime DEFAULT NULL COMMENT '创建时间',
update_by varchar(64) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '修改人',
update_time datetime DEFAULT NULL COMMENT '修改时间',
del_flag char(1) COLLATE utf8mb4_general_ci DEFAULT '0' COMMENT '删除标记',
tenant_id bigint DEFAULT NULL COMMENT '租户ID',
PRIMARY KEY (id)
) ENGINE = InnoDB
DEFAULT CHARSET = utf8mb4
COLLATE = utf8mb4_general_ci COMMENT = '钱包规则配置';
-- ----------------------------
-- Table structure for wallet_rule_transaction
-- ----------------------------
DROP TABLE IF EXISTS wallet_rule_transaction;
CREATE TABLE wallet_rule_transaction
(
id BIGINT(19) not null comment '主键',
biz_type VARCHAR(32) default null comment '转账类型',
source_wallet_id BIGINT(19) not null comment '源钱包id',
target_wallet_id BIGINT(19) not null comment '目标钱包id',
source_wallet_balance int not null comment '源钱包余额',
target_wallet_balance int not null comment '目标钱包余额',
balance int DEFAULT 0 NOT NULL COMMENT '转换金额',
after_balance int DEFAULT 0 NOT NULL COMMENT '转换后的金额',
balance_multiple int DEFAULT 0 NOT NULL COMMENT '钱包转换百分比',
is_refund VARCHAR(64) default '0' not null comment '是否退回',
refund_time datetime default NULL comment '退回时间',
create_by varchar(64) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '创建人',
create_time datetime DEFAULT NULL COMMENT '创建时间',
update_by varchar(64) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '修改人',
update_time datetime DEFAULT NULL COMMENT '修改时间',
del_flag char(1) COLLATE utf8mb4_general_ci DEFAULT '0' COMMENT '删除标记',
tenant_id bigint DEFAULT NULL COMMENT '租户ID',
PRIMARY KEY (id)
) ENGINE = InnoDB
DEFAULT CHARSET = utf8mb4
COLLATE = utf8mb4_general_ci COMMENT = '钱包转账记录';
-- ----------------------------
-- Table structure for wallet_active
-- ----------------------------
DROP TABLE IF EXISTS wallet_active;
CREATE TABLE wallet_active
(
id bigint NOT NULL COMMENT '主键',
user_id bigint DEFAULT NULL COMMENT '用户id',
wallet_id bigint DEFAULT NULL COMMENT '钱包id',
wallet_type_id bigint DEFAULT NULL COMMENT '饭卡类型id',
dept_id bigint NOT NULL COMMENT '部门id',
merchant_id bigint NOT NULL COMMENT '商户id',
card_number varchar(128) NOT NULL COMMENT '用户卡号',
card_sort int NOT NULL COMMENT '饭卡顺序',
is_active_hardware char(1) DEFAULT '0' COMMENT '饭卡是否在硬件上激活',
create_by varchar(64) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '创建人',
create_time datetime DEFAULT NULL COMMENT '创建时间',
update_by varchar(64) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '修改人',
update_time datetime DEFAULT NULL COMMENT '修改时间',
del_flag char(1) COLLATE utf8mb4_general_ci DEFAULT '0' COMMENT '删除标记',
tenant_id bigint DEFAULT NULL COMMENT '租户ID',
PRIMARY KEY (id)
) ENGINE = InnoDB
DEFAULT CHARSET = utf8mb4 COMMENT ='钱包开卡';
CREATE INDEX idx_dept_id ON wallet_active (user_id);
-- ----------------------------
-- Table structure for wallet_freeze
-- ----------------------------
DROP TABLE IF EXISTS wallet_freeze;
CREATE TABLE wallet_freeze
(
id bigint NOT NULL COMMENT '编号',
process_id varchar(256) COMMENT '流程id',
process_status varchar(10) NOT NULL COMMENT '审核状体',
process_time datetime COMMENT '审核时间',
wallet_id bigint NOT NULL COMMENT '钱包id',
user_id bigint NOT NULL COMMENT '用户id',
dept_id bigint NOT NULL COMMENT '部门id',
free_status tinytext NOT NULL COMMENT '冻结状态',
remark varchar(1024) COMMENT '备注',
create_by varchar(64) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '创建人',
create_time datetime DEFAULT NULL COMMENT '创建时间',
update_by varchar(64) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '修改人',
update_time datetime DEFAULT NULL COMMENT '修改时间',
del_flag char(1) COLLATE utf8mb4_general_ci DEFAULT '0' COMMENT '删除标记',
tenant_id bigint DEFAULT NULL COMMENT '租户ID',
PRIMARY KEY (id)
) ENGINE = InnoDB
DEFAULT CHARSET = utf8mb4 COMMENT ='饭卡冻结记录表';
-- ----------------------------
-- Table structure for wallet_transaction
-- ----------------------------
DROP TABLE IF EXISTS wallet_transaction;
CREATE TABLE wallet_transaction
(
id bigint NOT NULL COMMENT '编号',
wallet_id bigint NOT NULL COMMENT '会员钱包 id',
user_id bigint NOT NULL COMMENT '用户id',
dept_id bigint NOT NULL COMMENT '部门id',
biz_type tinytext NOT NULL COMMENT '关联类型',
biz_id varchar(64) NOT NULL COMMENT '关联业务编号',
title varchar(128) NOT NULL COMMENT '流水标题',
price int NOT NULL COMMENT '交易金额, 单位分',
balance int NOT NULL COMMENT '余额, 单位分',
tags varchar(512) DEFAULT NULL COMMENT '财务统计标签，多个wallet_transaction_tag字典值使用英文逗号分隔',
remark varchar(256) DEFAULT NULL COMMENT '流水备注，最多256个字符',
create_by varchar(64) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '创建人',
create_time datetime DEFAULT NULL COMMENT '创建时间',
update_by varchar(64) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '修改人',
update_time datetime DEFAULT NULL COMMENT '修改时间',
del_flag char(1) COLLATE utf8mb4_general_ci DEFAULT '0' COMMENT '删除标记',
tenant_id bigint DEFAULT NULL COMMENT '租户ID',
PRIMARY KEY (id)
) ENGINE = InnoDB
DEFAULT CHARSET = utf8mb4 COMMENT ='会员钱包流水表';
CREATE INDEX idx_dept_id ON wallet_transaction (wallet_id);
-- 批量充值/扣减持久化防重；已有环境执行 20261102_wallet_recharge_idempotency.sql。
CREATE TABLE IF NOT EXISTS wallet_transaction_idempotency (
tenant_id BIGINT NOT NULL,
wallet_id BIGINT NOT NULL,
biz_type VARCHAR(8) CHARACTER SET ascii COLLATE ascii_bin NOT NULL COMMENT '仅批量更新2、退还食堂8',
biz_id VARCHAR(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
price INT NOT NULL COMMENT '有符号变动金额，分',
transaction_id BIGINT NOT NULL,
create_time DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (tenant_id, wallet_id, biz_type, biz_id)
) ENGINE=InnoDB COMMENT='批量钱包入账幂等键，与余额和流水同事务提交';
-- ----------------------------
-- Table structure for wallet_recharge_apply
-- ----------------------------
DROP TABLE IF EXISTS wallet_recharge_apply;
CREATE TABLE wallet_recharge_apply
(
id bigint NOT NULL COMMENT '主键ID',
user_id bigint NOT NULL COMMENT '申请人ID',
process_id varchar(256) COMMENT '流程id',
process_status varchar(10) COMMENT '审核状体',
process_time datetime COMMENT '审核时间',
biz_type tinytext DEFAULT NULL COMMENT '充值类型',
wallet_type_id bigint DEFAULT NULL COMMENT '饭卡类型id',
dept_id bigint NOT NULL COMMENT '部门ID',
import_time timestamp DEFAULT NULL COMMENT '导入时间(手动选择)',
remark varchar(256) DEFAULT '' COMMENT '备注',
create_by varchar(64) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '创建人',
create_time datetime DEFAULT NULL COMMENT '创建时间',
update_by varchar(64) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '修改人',
update_time datetime DEFAULT NULL COMMENT '修改时间',
del_flag char(1) COLLATE utf8mb4_general_ci DEFAULT '0' COMMENT '删除标记',
tenant_id bigint DEFAULT NULL COMMENT '租户ID',
PRIMARY KEY (id)
) ENGINE = InnoDB
DEFAULT CHARSET = utf8mb4
COLLATE = utf8mb4_general_ci COMMENT ='充值申请表';
CREATE INDEX idx_dept_id ON wallet_recharge_apply (user_id);
-- ----------------------------
-- Table structure for wallet_recharge_invoice
-- ----------------------------
DROP TABLE IF EXISTS wallet_recharge_invoice;
CREATE TABLE wallet_recharge_invoice
(
id bigint NOT NULL COMMENT '主键ID',
apply_user_id bigint DEFAULT NULL COMMENT '申请用户id',
apply_dept_id bigint DEFAULT NULL COMMENT '申请用户部门id',
apply_id bigint DEFAULT NULL COMMENT '申请id',
code varchar(32) NOT NULL COMMENT '发票代码(七位数)',
time datetime DEFAULT NULL COMMENT '发票日期',
dept_or_user varchar(64) DEFAULT NULL COMMENT '交款单位或个人',
total_price int DEFAULT NULL COMMENT '合计人民币',
payee_dept varchar(64) DEFAULT NULL COMMENT '收款单位',
payee_user varchar(64) DEFAULT NULL COMMENT '收款人',
item_json varchar(2048) DEFAULT NULL COMMENT '备注',
remark varchar(1024) DEFAULT NULL COMMENT '备注',
status varchar(32) DEFAULT NULL COMMENT '状态',
pic_url varchar(1024) DEFAULT NULL COMMENT '发票图片地址',
create_by varchar(64) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '创建人',
create_time datetime DEFAULT NULL COMMENT '创建时间',
update_by varchar(64) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '修改人',
update_time datetime DEFAULT NULL COMMENT '修改时间',
del_flag char(1) COLLATE utf8mb4_general_ci DEFAULT '0' COMMENT '删除标记',
tenant_id bigint DEFAULT NULL COMMENT '租户ID',
PRIMARY KEY (id)
) ENGINE = InnoDB
DEFAULT CHARSET = utf8mb4
COLLATE = utf8mb4_general_ci COMMENT ='充值申请发票表';
-- ----------------------------
-- Table structure for wallet_recharge_import
-- ----------------------------
DROP TABLE IF EXISTS wallet_recharge_import;
CREATE TABLE wallet_recharge_import
(
id bigint NOT NULL COMMENT '编号',
user_id bigint default NULL COMMENT '用户id',
apply_id bigint NOT NULL COMMENT '申请id',
before_price int DEFAULT NULL COMMENT '导入前的金额',
price int NOT NULL COMMENT '交易金额, 单位分',
create_by varchar(64) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '创建人',
create_time datetime DEFAULT NULL COMMENT '创建时间',
update_by varchar(64) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '修改人',
update_time datetime DEFAULT NULL COMMENT '修改时间',
del_flag char(1) COLLATE utf8mb4_general_ci DEFAULT '0' COMMENT '删除标记',
tenant_id bigint DEFAULT NULL COMMENT '租户ID',
PRIMARY KEY (id)
) COMMENT ='充值导入表';
CREATE INDEX idx_dept_id ON wallet_recharge_import (user_id);
-- ----------------------------
-- Table structure for wallet_stride
-- ----------------------------
DROP TABLE IF EXISTS wallet_stride;
CREATE TABLE wallet_stride
(
id bigint NOT NULL COMMENT '编号',
process_id varchar(256) COMMENT '流程id',
process_status varchar(10) NOT NULL COMMENT '审核状体',
process_time datetime COMMENT '审核时间',
dept_id bigint NOT NULL COMMENT '部门id',
count int NOT NULL COMMENT '申请数量',
use_count int DEFAULT 0 COMMENT '使用数量',
user_id bigint NOT NULL COMMENT '申请人id',
remark varchar(1024) COMMENT '备注',
create_by varchar(64) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '创建人',
create_time datetime DEFAULT NULL COMMENT '创建时间',
update_by varchar(64) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '修改人',
update_time datetime DEFAULT NULL COMMENT '修改时间',
del_flag char(1) COLLATE utf8mb4_general_ci DEFAULT '0' COMMENT '删除标记',
tenant_id bigint DEFAULT NULL COMMENT '租户ID',
PRIMARY KEY (id)
) ENGINE = InnoDB
DEFAULT CHARSET = utf8mb4 COMMENT ='跨单位就餐';
-- ----------------------------
-- Table structure for wallet_foreign
-- ----------------------------
DROP TABLE IF EXISTS wallet_foreign;
CREATE TABLE wallet_foreign
(
id bigint NOT NULL COMMENT '编号',
user_id bigint NOT NULL COMMENT '用户id',
process_id varchar(256) COMMENT '流程id',
process_status varchar(10) NOT NULL COMMENT '审核状体',
process_time datetime COMMENT '审核时间',
dept_id bigint NOT NULL COMMENT '部门id',
apply_start_time date NULL COMMENT '申请使用开始时间',
apply_end_time date NULL COMMENT '申请使用结束时间',
count int NOT NULL COMMENT '申请数量',
use_count int DEFAULT 0 COMMENT '使用数量',
remark VARCHAR(1024) COMMENT '申请备注',
create_by varchar(64) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '创建人',
create_time datetime DEFAULT NULL COMMENT '创建时间',
update_by varchar(64) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '修改人',
update_time datetime DEFAULT NULL COMMENT '修改时间',
del_flag char(1) COLLATE utf8mb4_general_ci DEFAULT '0' COMMENT '删除标记',
tenant_id bigint DEFAULT NULL COMMENT '租户ID',
PRIMARY KEY (id)
) ENGINE = InnoDB
DEFAULT CHARSET = utf8mb4 COMMENT ='外来人员电子餐券表';
-- ----------------------------
-- Table structure for wallet_code_use
-- ----------------------------
DROP TABLE IF EXISTS wallet_code_use;
CREATE TABLE wallet_code_use
(
id bigint NOT NULL COMMENT '编号',
user_id bigint NOT NULL COMMENT '用户id',
biz_type tinytext NOT NULL COMMENT '类型',
biz_id bigint NOT NULL COMMENT '类型关联id',
status char(1) DEFAULT '0' NOT NULL COMMENT '是否使用',
code varchar(1024) DEFAULT NULL COMMENT '二维码',
code_content varchar(1024) DEFAULT NULL COMMENT '二维码内容',
short_code varchar(32) DEFAULT '' COMMENT '短码',
use_time timestamp NULL COMMENT '使用时间',
create_by varchar(64) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '创建人',
create_time datetime DEFAULT NULL COMMENT '创建时间',
update_by varchar(64) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '修改人',
update_time datetime DEFAULT NULL COMMENT '修改时间',
del_flag char(1) COLLATE utf8mb4_general_ci DEFAULT '0' COMMENT '删除标记',
tenant_id bigint DEFAULT NULL COMMENT '租户ID',
PRIMARY KEY (id),
INDEX idx_wcu_user_biz (user_id, biz_id),
INDEX idx_wcu_biz (biz_id)
) ENGINE = InnoDB
DEFAULT CHARSET = utf8mb4 COMMENT ='二维码使用表';
-- ----------------------------
-- Table structure for wallet_recharge_package
-- ----------------------------
DROP TABLE IF EXISTS wallet_recharge_package;
create table wallet_recharge_package
(
id bigint NOT NULL COMMENT '编号',
name varchar(64) NOT NULL COMMENT '套餐名',
pay_price int NOT NULL COMMENT '支付金额',
bonus_price int NOT NULL COMMENT '赠送金额',
status tinyint NOT NULL COMMENT '状态',
create_by varchar(64) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '创建人',
create_time datetime DEFAULT NULL COMMENT '创建时间',
update_by varchar(64) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '修改人',
update_time datetime DEFAULT NULL COMMENT '修改时间',
del_flag char(1) COLLATE utf8mb4_general_ci DEFAULT '0' COMMENT '删除标记',
tenant_id bigint DEFAULT NULL COMMENT '租户ID',
PRIMARY KEY (id)
) ENGINE = InnoDB
DEFAULT CHARSET = utf8mb4 COMMENT ='充值套餐表';
-- ----------------------------
-- Table structure for wallet_recharge
-- ----------------------------
DROP TABLE IF EXISTS wallet_recharge;
create table wallet_recharge
(
id bigint NOT NULL COMMENT '编号',
wallet_id bigint NOT NULL COMMENT '会员钱包 id',
total_price int NOT NULL COMMENT '用户实际到账余额，例如充 100 送 20，则该值是 120',
pay_price int NOT NULL COMMENT '实际支付金额',
bonus_price int NOT NULL COMMENT '钱包赠送金额',
package_id bigint NULL COMMENT '充值套餐编号',
pay_status bit default b'0' NOT NULL COMMENT '是否已支付：[0:未支付 1:已经支付过]',
pay_order_id bigint NULL COMMENT '支付订单编号',
pay_channel_code varchar(16) NULL COMMENT '支付成功的支付渠道',
pay_time datetime NULL COMMENT '订单支付时间',
pay_refund_order_id bigint NULL COMMENT '退款订单号',
pay_refund_after_sale_id bigint NULL COMMENT '售后单号id',
pay_refund_code varchar(256) NULL COMMENT '支付退款单code',
refund_total_price int default 0 NOT NULL COMMENT '退款金额，包含赠送金额',
refund_pay_price int default 0 NOT NULL COMMENT '退款支付金额',
refund_bonus_price int default 0 NOT NULL COMMENT '退款钱包赠送金额',
refund_time datetime NULL COMMENT '退款时间',
refund_status char(10) default '0' NOT NULL COMMENT '退款状态',
create_by varchar(64) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '创建人',
create_time datetime DEFAULT NULL COMMENT '创建时间',
update_by varchar(64) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '修改人',
update_time datetime DEFAULT NULL COMMENT '修改时间',
del_flag char(1) COLLATE utf8mb4_general_ci DEFAULT '0' COMMENT '删除标记',
tenant_id bigint DEFAULT NULL COMMENT '租户ID',
PRIMARY KEY (id)
) ENGINE = InnoDB
DEFAULT CHARSET = utf8mb4 COMMENT ='会员钱包充值';
-- ----------------------------
-- Table structure for wallet_setting
-- ----------------------------
DROP TABLE IF EXISTS wallet_setting;
CREATE TABLE wallet_setting
(
id bigint NOT NULL AUTO_INCREMENT COMMENT '创建者',
pay_amount_meal_limit int COMMENT '每一餐的上限(分)',
pay_amount_meal_times decimal(10, 2) COMMENT '每一餐的倍数',
pay_amount_enable char(1) DEFAULT '0' NOT NULL COMMENT '是否开启每一餐的额外缴费',
refresh_qr_code_enable char(1) DEFAULT '0' COMMENT '是否开启钱包二维码刷新',
refresh_qr_code_fre int COMMENT '二维码刷新频率',
off_line_order_apply_enable char(1) DEFAULT '0' NOT NULL COMMENT '是否开启离线订单的审批',
after_sale_refund_reasons varchar(2048) COMMENT '退款理由',
after_sale_return_reasons varchar(2048) COMMENT '退货理由',
create_by varchar(64) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '创建人',
create_time datetime DEFAULT NULL COMMENT '创建时间',
update_by varchar(64) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '修改人',
update_time datetime DEFAULT NULL COMMENT '修改时间',
del_flag char(1) COLLATE utf8mb4_general_ci DEFAULT '0' COMMENT '删除标记',
tenant_id bigint DEFAULT NULL COMMENT '租户ID',
PRIMARY KEY (id)
) ENGINE = InnoDB COMMENT ='支付设置';
-- ----------------------------
-- Table structure for mch_checkout
-- ----------------------------
DROP TABLE IF EXISTS mch_checkout;
CREATE TABLE mch_checkout
(
id bigint NOT NULL AUTO_INCREMENT COMMENT '创建者',
checkout_time date NOT NULL COMMENT '结账年月日(存入年月就行)',
checkout_user_id bigint NOT NULL COMMENT '结账人',
merchant_id bigint NOT NULL COMMENT '商户id',
price bigint NOT NULL COMMENT '结账价格',
pic varchar(2048) DEFAULT NULL COMMENT '结账凭证图片',
remark varchar(512) DEFAULT NULL COMMENT '结账备注',
create_by varchar(64) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '创建人',
create_time datetime DEFAULT NULL COMMENT '创建时间',
update_by varchar(64) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '修改人',
update_time datetime DEFAULT NULL COMMENT '修改时间',
del_flag char(1) COLLATE utf8mb4_general_ci DEFAULT '0' COMMENT '删除标记',
tenant_id bigint DEFAULT NULL COMMENT '租户ID',
PRIMARY KEY (id)
) ENGINE = InnoDB COMMENT ='商户结账表';
-- ----------------------------
-- Table structure for mch_pick_up
-- ----------------------------
DROP TABLE IF EXISTS mch_pick_up;
CREATE TABLE mch_pick_up
(
id bigint NOT NULL AUTO_INCREMENT COMMENT '创建者',
name varchar(128) NOT NULL COMMENT '自提点名',
logo varchar(256) DEFAULT NULL COMMENT '门店logo',
introduction varchar(256) DEFAULT NULL COMMENT '门店简介',
phone varchar(16) DEFAULT NULL COMMENT '门店手机',
status varchar(32) DEFAULT NULL COMMENT '门店状态',
latitude double DEFAULT NULL COMMENT '纬度',
longitude double DEFAULT NULL COMMENT '经度',
detail_address varchar(256) DEFAULT NULL COMMENT '门店详细地址',
business_hours_json varchar(1024) DEFAULT NULL COMMENT '营业时间',
create_by varchar(64) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '创建人',
create_time datetime DEFAULT NULL COMMENT '创建时间',
update_by varchar(64) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '修改人',
update_time datetime DEFAULT NULL COMMENT '修改时间',
del_flag char(1) COLLATE utf8mb4_general_ci DEFAULT '0' COMMENT '删除标记',
tenant_id bigint DEFAULT NULL COMMENT '租户ID',
PRIMARY KEY (id)
) ENGINE = InnoDB COMMENT ='商户自提点表';
-- ----------------------------
-- Table structure for mch_pick_up_join
-- ----------------------------
DROP TABLE IF EXISTS mch_pick_up_join;
CREATE TABLE mch_pick_up_join
(
id bigint NOT NULL AUTO_INCREMENT COMMENT '创建者',
mch_id bigint NOT NULL COMMENT '商户id',
mch_pick_up_id bigint NOT NULL COMMENT '自提点id',
PRIMARY KEY (id)
) ENGINE = InnoDB COMMENT ='商户自提点关联表';
Reference in new issue View Git Blame Copy Permalink