易公会数据库表结构
<ul>
<li><font color="blue"><strong>更新日期:2021/12/08 16:30</strong></font></li>
</ul>
<pre><code class="language-sql">
-- ----------------------------
-- Table structure for address
-- ----------------------------
DROP TABLE IF EXISTS `address`;
CREATE TABLE `address` (
`no_` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键、自增',
`id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'id',
`user_id` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '用户id',
`name` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '收货人姓名',
`phone_num` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '收货人手机号',
`province` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '所在省',
`city` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '所在城市',
`district` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '所在县/区',
`detail` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '详细地址',
`is_available` tinyint(1) UNSIGNED NOT NULL DEFAULT 1,
`creation_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0),
`update_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '最新修改时间',
PRIMARY KEY (`no_`) USING BTREE,
UNIQUE INDEX `uk_address_id`(`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;
-- ----------------------------
-- Table structure for api_privilege
-- ----------------------------
DROP TABLE IF EXISTS `api_privilege`;
CREATE TABLE `api_privilege` (
`no_` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键、自增',
`func_title` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '二级功能编号',
`api_title` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'API编号',
`is_available` tinyint(1) UNSIGNED NOT NULL DEFAULT 1,
`creation_time` timestamp(0) NULL DEFAULT CURRENT_TIMESTAMP(0),
`update_time` timestamp(0) NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '最新修改时间',
PRIMARY KEY (`no_`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;
-- ----------------------------
-- Table structure for bank_account
-- ----------------------------
DROP TABLE IF EXISTS `bank_account`;
CREATE TABLE `bank_account` (
`no_` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键、自增',
`id` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'id',
`type` tinyint(4) UNSIGNED NOT NULL COMMENT '1银行卡 3支付宝',
`name` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '账户姓名',
`number` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '账户号码',
`id_card_num` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '身份证号码',
`phone_num` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '账户绑定的手机号',
`user_id` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '绑定的用户id',
`is_default` tinyint(4) UNSIGNED NOT NULL DEFAULT 0 COMMENT '是否是默认账户',
`status` tinyint(4) UNSIGNED NOT NULL DEFAULT 1 COMMENT '状态 0禁用 1 启用',
`is_available` tinyint(1) UNSIGNED NOT NULL DEFAULT 1,
`creation_time` timestamp(0) NULL DEFAULT CURRENT_TIMESTAMP(0),
`update_time` timestamp(0) NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '最新修改时间',
PRIMARY KEY (`no_`) USING BTREE,
UNIQUE INDEX `uk_bank_account_id`(`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;
-- ----------------------------
-- Table structure for bank_card
-- ----------------------------
DROP TABLE IF EXISTS `bank_card`;
CREATE TABLE `bank_card` (
`no_` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键、自增',
`acct_id` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '收款账户id',
`bank` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '开户行',
`location` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '开户地址',
`is_available` tinyint(1) UNSIGNED NOT NULL DEFAULT 1,
`creation_time` timestamp(0) NULL DEFAULT CURRENT_TIMESTAMP(0),
`update_time` timestamp(0) NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '最新修改时间',
PRIMARY KEY (`no_`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;
-- ----------------------------
-- Table structure for biz_acct_info
-- ----------------------------
DROP TABLE IF EXISTS `biz_acct_info`;
CREATE TABLE `biz_acct_info` (
`no_` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键、自增',
`dept_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '部门id',
`plf_biz_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '平台业务部门id',
`user_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '业务账号绑定用户id',
`alias` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '业务账号昵称',
`number` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '业务账号id',
`update_allowed` tinyint(4) UNSIGNED NOT NULL COMMENT '允许修改次数:默认为1次',
`frz_reasons` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '冻结原因',
`status` tinyint(4) UNSIGNED NOT NULL COMMENT '业务账号状态',
`is_available` tinyint(1) UNSIGNED NOT NULL DEFAULT 1 COMMENT '数据可用状态',
`creation_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '数据可用状态',
`update_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '最新修改时间',
PRIMARY KEY (`no_`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;
-- ----------------------------
-- Table structure for biz_acct_stl_data
-- ----------------------------
DROP TABLE IF EXISTS `biz_acct_stl_data`;
CREATE TABLE `biz_acct_stl_data` (
`no_` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键、自增',
`id` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '日结结算数据ID',
`tab_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '关联模板表ID',
`biz_acct_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '业务账号部门ID',
`room_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '关联厅部门id',
`stm_amount` decimal(13, 2) NOT NULL COMMENT '流水金额',
`stl_amount` decimal(13, 2) NOT NULL COMMENT '结算金额',
`stl_prop` decimal(5, 2) NOT NULL COMMENT '结算比例',
`date` int(11) UNSIGNED NOT NULL COMMENT '结算日期',
`is_available` tinyint(1) UNSIGNED NOT NULL DEFAULT 1,
`creation_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0),
`update_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '最新修改时间',
PRIMARY KEY (`no_`) USING BTREE,
UNIQUE INDEX `uk_biz_acct_stl_data_id`(`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;
-- ----------------------------
-- Table structure for biz_acct_stm_data
-- ----------------------------
DROP TABLE IF EXISTS `biz_acct_stm_data`;
CREATE TABLE `biz_acct_stm_data` (
`no_` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键、自增',
`id` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '艺人流水数据ID',
`tab_id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '关联模板表ID',
`bat_id` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '关联流水数据批次号',
`room_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '内置, 厅ID',
`biz_acct_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '内置, 业务账号id',
`biz_amount` decimal(13, 2) NOT NULL COMMENT '业务账号真实流水',
`date` int(11) UNSIGNED NOT NULL COMMENT '流水发生日期',
`cus_fields` json NULL COMMENT '可变字段',
`is_available` tinyint(1) UNSIGNED NOT NULL DEFAULT 1,
`creation_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0),
`update_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '最新修改时间',
PRIMARY KEY (`no_`) USING BTREE,
UNIQUE INDEX `uk_biz_acct_stm_data_id`(`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;
-- ----------------------------
-- Table structure for biz_dept_info
-- ----------------------------
DROP TABLE IF EXISTS `biz_dept_info`;
CREATE TABLE `biz_dept_info` (
`no_` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键、自增',
`dept_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '部门id',
`biz_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '业务id',
`plf_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '平台id',
`room_invitation_code` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '厅邀请码',
`room_number` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '厅房间号',
`start_stl_date` int(11) UNSIGNED NULL DEFAULT NULL COMMENT '开始结算日期(此参数只针对厅部门)',
`is_available` tinyint(1) UNSIGNED NOT NULL DEFAULT 1,
`creation_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0),
`update_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '最新修改时间',
PRIMARY KEY (`no_`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;
-- ----------------------------
-- Table structure for business
-- ----------------------------
DROP TABLE IF EXISTS `business`;
CREATE TABLE `business` (
`no_` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键、自增',
`id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '业务id',
`name` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '业务名称',
`status` tinyint(4) UNSIGNED NOT NULL DEFAULT 1 COMMENT '0-禁用 1-启用',
`is_available` tinyint(1) UNSIGNED NOT NULL DEFAULT 1,
`creation_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0),
`update_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '最新修改时间',
PRIMARY KEY (`no_`) USING BTREE,
UNIQUE INDEX `uk_business_id`(`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;
-- ----------------------------
-- Table structure for company
-- ----------------------------
DROP TABLE IF EXISTS `company`;
CREATE TABLE `company` (
`no_` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
`id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
`alias` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '公司简称',
`name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '公司全称',
`uscc` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '纳税人识别码',
`address` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '公司地址',
`bank` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '公司一般户开户行',
`account` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '公司银行账号',
`phone_num` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '公司电话号码',
`status` tinyint(4) UNSIGNED NOT NULL DEFAULT 1 COMMENT '公司主体状态',
`is_stl_entity` tinyint(1) UNSIGNED NOT NULL DEFAULT 1 COMMENT '是否是当前结算主体',
`is_available` tinyint(1) UNSIGNED NOT NULL DEFAULT 1,
`creation_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0),
`update_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '自动更新最新修改时间',
PRIMARY KEY (`no_`) USING BTREE,
UNIQUE INDEX `uk_co_id`(`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;
-- ----------------------------
-- Table structure for dept_node
-- ----------------------------
DROP TABLE IF EXISTS `dept_node`;
CREATE TABLE `dept_node` (
`no_` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键、自增',
`id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'id',
`name` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '部门名称',
`head` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '部门负责人',
`type` tinyint(4) UNSIGNED NOT NULL COMMENT '部门类型:1-业务部门 2-职能部门',
`scope` tinyint(4) UNSIGNED NOT NULL COMMENT '层级范围:5-业务部门 10-平台业务 15-公会 20-组 25-厅 30-业务账号 60-职能部门 65-所属职能部门',
`prev_node_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '上级部门ID',
`root_node_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '根部门ID',
`is_available` tinyint(1) UNSIGNED NOT NULL DEFAULT 1,
`creation_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0),
`update_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '最新修改时间',
PRIMARY KEY (`no_`) USING BTREE,
UNIQUE INDEX `uk_dept_node_id`(`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;
-- ----------------------------
-- Table structure for error_data
-- ----------------------------
DROP TABLE IF EXISTS `error_data`;
CREATE TABLE `error_data` (
`no_` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键、自增',
`id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '错误信息ID',
`bat_id` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '关联原始数据批次号',
`field_id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '关联模板字段ID',
`data_id` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '关联原始数据流水ID',
`err_type` tinyint(4) UNSIGNED NOT NULL COMMENT '异常类型',
`err_code` tinyint(4) UNSIGNED NOT NULL COMMENT '异常代码',
`err_info` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '异常原因',
`is_ignored` tinyint(4) UNSIGNED NOT NULL DEFAULT 0 COMMENT '是否忽略异常,默认不忽略异常',
`is_cleared` tinyint(4) UNSIGNED NOT NULL DEFAULT 0 COMMENT '是否解除异常,默认不解除异常',
`is_available` tinyint(1) UNSIGNED NOT NULL DEFAULT 1,
`creation_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0),
`update_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '最新修改时间',
PRIMARY KEY (`no_`) USING BTREE,
UNIQUE INDEX `uk_error_data_id`(`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;
-- ----------------------------
-- Table structure for func_dept_user
-- ----------------------------
DROP TABLE IF EXISTS `func_dept_user`;
CREATE TABLE `func_dept_user` (
`no_` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键、自增',
`user_id` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '用户id',
`dept_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '部门id',
`is_available` tinyint(1) UNSIGNED NOT NULL DEFAULT 1,
`creation_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0),
`update_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '最新修改时间',
PRIMARY KEY (`no_`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;
-- ----------------------------
-- Table structure for key_and_field
-- ----------------------------
DROP TABLE IF EXISTS `key_and_field`;
CREATE TABLE `key_and_field` (
`no_` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键、自增',
`field_id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '关联模板字段ID',
`key_id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '关联模板键ID',
`is_available` tinyint(1) UNSIGNED NOT NULL DEFAULT 1,
`creation_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0),
`update_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '最新修改时间',
PRIMARY KEY (`no_`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;
-- ----------------------------
-- Table structure for logs
-- ----------------------------
DROP TABLE IF EXISTS `logs`;
CREATE TABLE `logs` (
`no_` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键、自增',
`user_id` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '用户id',
`alias` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '用户昵称/花名',
`phone_num` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '手机号码',
`role_ids` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '用户头像',
`role_names` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '用户头像',
`ip` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '姓名',
`operate_time` int(11) NULL DEFAULT NULL COMMENT '操作时间',
`operate_type` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '操作内容/类型',
`contents` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '操作详情',
`is_available` tinyint(1) UNSIGNED NOT NULL DEFAULT 1,
`creation_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0),
`update_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '最新修改时间',
PRIMARY KEY (`no_`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;
-- ----------------------------
-- Table structure for platform
-- ----------------------------
DROP TABLE IF EXISTS `platform`;
CREATE TABLE `platform` (
`no_` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键、自增',
`id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '平台id',
`name` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '平台名称',
`status` tinyint(4) UNSIGNED NOT NULL DEFAULT 1 COMMENT '0-禁用 1-启用',
`is_available` tinyint(1) UNSIGNED NOT NULL DEFAULT 1,
`creation_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0),
`update_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '最新修改时间',
PRIMARY KEY (`no_`) USING BTREE,
UNIQUE INDEX `uk_platform_id`(`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;
-- ----------------------------
-- Table structure for process
-- ----------------------------
DROP TABLE IF EXISTS `process`;
CREATE TABLE `process` (
`no_` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键、自增',
`id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '流程id',
`name` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '流程名称',
`process_num` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '流程编号',
`is_available` tinyint(1) UNSIGNED NOT NULL DEFAULT 1,
`creation_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0),
`update_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '最新修改时间',
PRIMARY KEY (`no_`) USING BTREE,
UNIQUE INDEX `uk_process_id`(`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;
-- ----------------------------
-- Table structure for process_action
-- ----------------------------
DROP TABLE IF EXISTS `process_action`;
CREATE TABLE `process_action` (
`no_` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键、自增',
`id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'id',
`process_node_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '流程节点id',
`user_id` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '用户id',
`status` tinyint(4) UNSIGNED NOT NULL COMMENT '状态',
`prev_action_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '上一个节点信息',
`next_action_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '下一个节点信息',
`fail_time` int(11) UNSIGNED NULL DEFAULT NULL COMMENT '失效时间',
`pid` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '流程发起后唯一识别ID',
`is_available` tinyint(1) UNSIGNED NOT NULL DEFAULT 1,
`creation_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0),
`update_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '最新修改时间',
PRIMARY KEY (`no_`) USING BTREE,
UNIQUE INDEX `uk_process_action_id`(`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;
-- ----------------------------
-- Table structure for process_data
-- ----------------------------
DROP TABLE IF EXISTS `process_data`;
CREATE TABLE `process_data` (
`no_` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键、自增',
`id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'id',
`process_field_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '流程字段id',
`value` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '数据信息',
`pid` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '流程发起后唯一识别ID',
`is_available` tinyint(1) UNSIGNED NOT NULL DEFAULT 1,
`creation_time` timestamp(0) NULL DEFAULT CURRENT_TIMESTAMP(0),
`update_time` timestamp(0) NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '最新修改时间',
PRIMARY KEY (`no_`) USING BTREE,
UNIQUE INDEX `uk_process_data_id`(`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;
-- ----------------------------
-- Table structure for process_field
-- ----------------------------
DROP TABLE IF EXISTS `process_field`;
CREATE TABLE `process_field` (
`no_` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键、自增',
`id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'id',
`process_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '流程表id',
`name` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '名称',
`type` tinyint(4) UNSIGNED NOT NULL COMMENT '类型',
`is_not_null` tinyint(4) UNSIGNED NOT NULL COMMENT '是否为空',
`is_available` tinyint(1) UNSIGNED NOT NULL DEFAULT 1,
`creation_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0),
`update_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '最新修改时间',
PRIMARY KEY (`no_`) USING BTREE,
UNIQUE INDEX `uk_process_field_id`(`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;
-- ----------------------------
-- Table structure for process_node
-- ----------------------------
DROP TABLE IF EXISTS `process_node`;
CREATE TABLE `process_node` (
`no_` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键、自增',
`id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'id',
`type` tinyint(4) UNSIGNED NOT NULL COMMENT '1-application 2-approve',
`process_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '流程表id',
`func_title` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '权限功能',
`prev_node_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '上一个节点信息',
`next_node_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '下一个节点信息',
`fail_time` int(11) UNSIGNED NULL DEFAULT NULL COMMENT '失效时间',
`is_available` tinyint(1) NOT NULL DEFAULT 1,
`creation_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0),
`update_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '最新修改时间',
PRIMARY KEY (`no_`) USING BTREE,
UNIQUE INDEX `uk_process_node_id`(`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;
-- ----------------------------
-- Table structure for raw_data
-- ----------------------------
DROP TABLE IF EXISTS `raw_data`;
CREATE TABLE `raw_data` (
`no_` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键、自增',
`id` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '原始数据ID',
`tab_id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '关联模板表ID',
`bat_id` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '关联原始数据批次号',
`room_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '关联厅部门ID',
`biz_acct_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '关联业务账号部门ID',
`room_num` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '房间号',
`biz_acct_num` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '业务账号',
`date` int(11) UNSIGNED NOT NULL COMMENT '流水发生日期',
`cus_fields` json NULL COMMENT '可变字段',
`other_fields` json NULL COMMENT '无用字',
`is_available` tinyint(1) UNSIGNED NOT NULL DEFAULT 1,
`creation_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0),
`update_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '最新修改时间',
PRIMARY KEY (`no_`) USING BTREE,
UNIQUE INDEX `uk_raw_data_id`(`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;
-- ----------------------------
-- Table structure for raw_data_bat
-- ----------------------------
DROP TABLE IF EXISTS `raw_data_bat`;
CREATE TABLE `raw_data_bat` (
`no_` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键、自增',
`id` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '原始数据批次ID',
`tab_id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '关联模板表ID',
`tab_conf_id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '关联模板表配置ID',
`user_id` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '导入人用户ID',
`room_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '关联厅部门ID',
`status` tinyint(4) NOT NULL COMMENT '批次状态',
`err_status` tinyint(4) UNSIGNED NOT NULL COMMENT '批次异常状态',
`begin_date` int(11) UNSIGNED NOT NULL COMMENT '结算周期开始日期',
`end_date` int(11) UNSIGNED NOT NULL COMMENT '结算周期结束日期',
`stl_date` int(11) UNSIGNED NOT NULL COMMENT '结算日期',
`summary` decimal(13, 4) NOT NULL COMMENT '汇总计算',
`total` int(11) NOT NULL COMMENT '汇总计数',
`plf_biz_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '平台业务部门id',
`is_available` tinyint(1) UNSIGNED NOT NULL DEFAULT 1,
`creation_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0),
`update_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '最新修改时间',
PRIMARY KEY (`no_`) USING BTREE,
UNIQUE INDEX `uk_raw_data_bat_id`(`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;
-- ----------------------------
-- Table structure for rec_biz_acct_freeze
-- ----------------------------
DROP TABLE IF EXISTS `rec_biz_acct_freeze`;
CREATE TABLE `rec_biz_acct_freeze` (
`no_` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键、自增',
`id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '账号冻结记录id',
`dept_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '部门id',
`alias` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '业务账号昵称',
`number` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '业务账号',
`category` tinyint(4) UNSIGNED NOT NULL COMMENT '记录类型:冻结、解冻',
`frz_reasons` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '原因说明',
`is_available` tinyint(1) UNSIGNED NOT NULL DEFAULT 1,
`creation_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0),
`update_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '最新修改时间',
PRIMARY KEY (`no_`) USING BTREE,
UNIQUE INDEX `uk_rec_biz_acct_freeze_id`(`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;
-- ----------------------------
-- Table structure for rec_biz_acct_info
-- ----------------------------
DROP TABLE IF EXISTS `rec_biz_acct_info`;
CREATE TABLE `rec_biz_acct_info` (
`no_` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键、自增',
`dept_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '业务账号id',
`room_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '关联厅部门ID',
`alias` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '业务账号昵称',
`number` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '业务账号',
`effe_date` int(11) UNSIGNED NOT NULL COMMENT '生效时间',
`is_available` tinyint(1) NOT NULL DEFAULT 1 COMMENT '数据可用状态',
`creation_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '数据可用状态',
`update_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '最新修改时间',
PRIMARY KEY (`no_`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;
-- ----------------------------
-- Table structure for rec_biz_dept_stl_info
-- ----------------------------
DROP TABLE IF EXISTS `rec_biz_dept_stl_info`;
CREATE TABLE `rec_biz_dept_stl_info` (
`no_` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键、自增',
`dept_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '部门外键id\r\n',
`stl_method` tinyint(3) UNSIGNED NOT NULL COMMENT '结算方式',
`stl_cycle` tinyint(3) UNSIGNED NOT NULL COMMENT '结算周期',
`stl_prop` decimal(3, 2) NOT NULL COMMENT '分成比例',
`effe_date` int(10) UNSIGNED NOT NULL COMMENT ' 生效时间',
`exp_date` int(10) UNSIGNED NOT NULL COMMENT ' 失效时间',
`is_available` tinyint(1) UNSIGNED NOT NULL DEFAULT 1,
`creation_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0),
`update_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '最新修改时间',
PRIMARY KEY (`no_`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;
-- ----------------------------
-- Table structure for rec_biz_dept_stl_rule
-- ----------------------------
DROP TABLE IF EXISTS `rec_biz_dept_stl_rule`;
CREATE TABLE `rec_biz_dept_stl_rule` (
`no_` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键、自增',
`dept_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '部门外键id\r\n',
`stl_rule_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '结算计算规则ID',
`stl_cycle` tinyint(4) UNSIGNED NOT NULL COMMENT '结算周期',
`effe_date` int(11) UNSIGNED NOT NULL COMMENT ' 生效时间',
`is_available` tinyint(1) UNSIGNED NOT NULL DEFAULT 1,
`creation_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0),
`update_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '最新修改时间',
PRIMARY KEY (`no_`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;
-- ----------------------------
-- Table structure for rec_biz_plf_info
-- ----------------------------
DROP TABLE IF EXISTS `rec_biz_plf_info`;
CREATE TABLE `rec_biz_plf_info` (
`no_` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键、自增',
`id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'id',
`biz_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '业务id',
`plf_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '平台id',
`room_min` decimal(5, 4) NOT NULL DEFAULT 0.0000 COMMENT '厅分成范围 最小值',
`room_max` decimal(5, 4) NOT NULL DEFAULT 0.0000 COMMENT '厅分成范围 最大值',
`etr_min` decimal(5, 4) NOT NULL COMMENT '艺人分成范围最小值',
`etr_max` decimal(5, 4) NOT NULL DEFAULT 0.0000 COMMENT '艺人分成范围最大值',
`daily_charges` decimal(5, 4) NOT NULL DEFAULT 0.0000 COMMENT '日结手续费',
`weekly_charges` decimal(5, 4) NOT NULL DEFAULT 0.0000 COMMENT '周结手续费',
`effe_date` int(11) UNSIGNED NOT NULL COMMENT '生效时间',
`is_available` tinyint(1) UNSIGNED NOT NULL DEFAULT 1,
`creation_time` timestamp(0) NULL DEFAULT CURRENT_TIMESTAMP(0),
`update_time` timestamp(0) NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '最新修改时间',
PRIMARY KEY (`no_`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;
-- ----------------------------
-- Table structure for rec_biz_plf_stl_info
-- ----------------------------
DROP TABLE IF EXISTS `rec_biz_plf_stl_info`;
CREATE TABLE `rec_biz_plf_stl_info` (
`no_` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键、自增',
`biz_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '业务id',
`plf_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '平台id',
`type` tinyint(4) UNSIGNED NOT NULL COMMENT '结算周期的类型 1厅结算周期 2 艺人结算周期',
`stl_cycle` tinyint(4) UNSIGNED NOT NULL COMMENT '结算周期',
`effe_date` int(11) UNSIGNED NOT NULL COMMENT '生效时间',
`is_available` tinyint(1) UNSIGNED NOT NULL DEFAULT 1,
`creation_time` timestamp(0) NULL DEFAULT CURRENT_TIMESTAMP(0),
`update_time` timestamp(0) NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '最新修改时间',
PRIMARY KEY (`no_`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;;
-- ----------------------------
-- Table structure for role
-- ----------------------------
DROP TABLE IF EXISTS `role`;
CREATE TABLE `role` (
`no_` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键、自增',
`id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '角色id',
`name` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '角色名称',
`role_group` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '角色组',
`status` tinyint(4) UNSIGNED NOT NULL DEFAULT 1 COMMENT '0-禁用 1-启用',
`rank` tinyint(4) UNSIGNED NOT NULL DEFAULT 1 COMMENT '角色等级',
`is_available` tinyint(1) NOT NULL DEFAULT 1,
`creation_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0),
`update_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '最新修改时间',
PRIMARY KEY (`no_`) USING BTREE,
UNIQUE INDEX `uk_role_id`(`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;
-- ----------------------------
-- Table structure for role_privilege
-- ----------------------------
DROP TABLE IF EXISTS `role_privilege`;
CREATE TABLE `role_privilege` (
`no_` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键、自增',
`func_title` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '权限功能',
`role_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '角色外键id',
`is_available` tinyint(1) UNSIGNED NOT NULL DEFAULT 1,
`creation_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0),
`update_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '最新修改时间',
PRIMARY KEY (`no_`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;
-- ----------------------------
-- Table structure for room_info
-- ----------------------------
DROP TABLE IF EXISTS `room_info`;
CREATE TABLE `room_info` (
`no_` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键、自增',
`dept_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '部门id',
`user_id` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '厅负责人',
`number` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '厅房间号',
`name` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '厅名',
`invitation_code` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '厅邀请码',
`is_available` tinyint(1) UNSIGNED NOT NULL DEFAULT 1 COMMENT '数据可用状态',
`creation_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '数据可用状态',
`update_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '最新修改时间',
PRIMARY KEY (`no_`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;
-- ----------------------------
-- Table structure for room_stl_data
-- ----------------------------
DROP TABLE IF EXISTS `room_stl_data`;
CREATE TABLE `room_stl_data` (
`no_` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键、自增',
`id` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '日结结算数据ID',
`tab_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '关联模板表ID',
`room_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '关联厅部门id',
`group_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '运营组部门ID',
`stm_amount` decimal(13, 2) NOT NULL COMMENT '流水金额',
`stl_amount` decimal(13, 2) NOT NULL COMMENT '结算金额',
`stl_prop` decimal(5, 2) NULL DEFAULT NULL COMMENT '结算比例',
`date` int(11) UNSIGNED NOT NULL COMMENT '结算日期',
`is_available` tinyint(1) UNSIGNED NOT NULL DEFAULT 1,
`creation_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0),
`update_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '最新修改时间',
PRIMARY KEY (`no_`) USING BTREE,
UNIQUE INDEX `uk_room_stl_data_id`(`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;
-- ----------------------------
-- Table structure for room_stm_data
-- ----------------------------
DROP TABLE IF EXISTS `room_stm_data`;
CREATE TABLE `room_stm_data` (
`no_` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键、自增',
`id` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '厅流水数据ID',
`tab_id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '关联模板表ID',
`bat_id` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '关联流水数据批次号',
`room_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '关联厅部门ID',
`group_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '运营组部门ID',
`biz_amount` decimal(13, 2) NOT NULL COMMENT '厅真实流水',
`date` int(11) UNSIGNED NOT NULL COMMENT '流水发生日期',
`cus_fields` json NULL COMMENT '可变字段',
`is_available` tinyint(1) UNSIGNED NOT NULL DEFAULT 1,
`creation_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0),
`update_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '最新修改时间',
PRIMARY KEY (`no_`) USING BTREE,
UNIQUE INDEX `uk_room_stm_data_id`(`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;
-- ----------------------------
-- Table structure for stl_account
-- ----------------------------
DROP TABLE IF EXISTS `stl_account`;
CREATE TABLE `stl_account` (
`no_` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键、自增',
`id` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '钱包流水ID',
`status` tinyint(1) NOT NULL COMMENT '钱包账号',
`dept_id` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '部门ID',
`is_available` tinyint(1) UNSIGNED NOT NULL DEFAULT 1,
`creation_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0),
`update_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '最新修改时间',
PRIMARY KEY (`no_`) USING BTREE,
UNIQUE INDEX `uk_stl_account_id`(`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;
-- ----------------------------
-- Table structure for stl_stm
-- ----------------------------
DROP TABLE IF EXISTS `stl_stm`;
CREATE TABLE `stl_stm` (
`no_` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键、自增',
`id` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '结算流水ID',
`stm_amount` decimal(13, 2) NOT NULL COMMENT '流水金额',
`stl_amount` decimal(13, 2) NOT NULL COMMENT '结算金额',
`status` tinyint(4) NULL DEFAULT NULL COMMENT '结算流水状态 0-未知状态 1-已冻结 2-已提现',
`create_time` int(11) NULL DEFAULT NULL COMMENT '流水发生时间',
`bat_id` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '计算批次ID',
`stl_date` int(11) NULL DEFAULT NULL COMMENT '结算日期',
`dept_scope` int(1) NULL DEFAULT NULL COMMENT '部门层级',
`stl_mode` int(1) NULL DEFAULT NULL COMMENT '结算方式',
`dept_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '本级部门ID(业务账户/厅)',
`superior_dept_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '上级部门ID(厅/运营组)',
`stl_acct_id` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '结算账户ID',
`stl_acct_dept_id` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '结算账户部门ID',
`is_available` tinyint(1) UNSIGNED NOT NULL DEFAULT 1,
`creation_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0),
`update_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '最新修改时间',
PRIMARY KEY (`no_`) USING BTREE,
UNIQUE INDEX `uk_stl_stm_id`(`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;
-- ----------------------------
-- Table structure for stl_stm_bat
-- ----------------------------
DROP TABLE IF EXISTS `stl_stm_bat`;
CREATE TABLE `stl_stm_bat` (
`no_` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键、自增',
`id` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '结算数据批次ID',
`tab_id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '关联模板表ID',
`tab_conf_id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '关联模板表配置ID',
`room_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '关联厅部门ID',
`plf_biz_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '内置平台业务ID',
`status` tinyint(4) UNSIGNED NOT NULL COMMENT '批次状态',
`stl_cycle` tinyint(3) UNSIGNED NOT NULL COMMENT '批次结算周期',
`room_stm_amount` decimal(13, 2) NOT NULL COMMENT '厅流水金额',
`room_stl_amount` decimal(13, 2) NOT NULL COMMENT '厅结算金额',
`begin_date` int(11) UNSIGNED NOT NULL COMMENT '结算周期开始日期',
`end_date` int(11) UNSIGNED NOT NULL COMMENT '结算周期结束日期',
`is_available` tinyint(1) UNSIGNED NOT NULL DEFAULT 1,
`creation_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0),
`update_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '最新修改时间',
`room_manage_amount` decimal(13, 2) NOT NULL COMMENT '厅管金额',
PRIMARY KEY (`no_`) USING BTREE,
UNIQUE INDEX `uk_stl_data_bat_id`(`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;
-- ----------------------------
-- Table structure for stl_tab_conf
-- ----------------------------
DROP TABLE IF EXISTS `stl_tab_conf`;
CREATE TABLE `stl_tab_conf` (
`no_` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键、自增',
`id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '月结结算数据ID',
`dept_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '关联平台业务部门ID',
`raw_data_tab_id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '原始数据模板表ID',
`etr_stm_data_tab_id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '艺人流水数据模板表ID',
`room_stm_data_tab_id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '厅流水数据模板表ID',
`group_stm_data_tab_id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '运营组流水数据模板表ID',
`agency_stm_data_tab_id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '公会流水数据模板表ID',
`biz_acct_stl_free_tab_id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '艺人自由结算数据模板表ID',
`biz_acct_stl_protect_tab_id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '艺人保护结算数据模板表ID',
`biz_acct_stl_surplus_tab_id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '艺人剩余结算数据模板表ID',
`room_stl_free_tab_id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '厅自由结算数据模板表ID',
`room_stl_protect_tab_id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '厅保护结算数据模板表ID',
`room_stl_surplus_tab_id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '厅剩余结算数据模板表ID',
`effe_date` int(11) UNSIGNED NOT NULL COMMENT '生效时间',
`exp_date` int(11) UNSIGNED NULL DEFAULT NULL COMMENT '失效时间',
`is_available` tinyint(1) UNSIGNED NOT NULL DEFAULT 1,
`creation_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0),
`update_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '最新修改时间',
`room_stl_free_prop_tab_id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '厅自由结算数据模板表ID',
PRIMARY KEY (`no_`) USING BTREE,
UNIQUE INDEX `uk_stl_tab_conf_id`(`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;
-- ----------------------------
-- Table structure for stm_data_bat
-- ----------------------------
DROP TABLE IF EXISTS `stm_data_bat`;
CREATE TABLE `stm_data_bat` (
`no_` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键、自增',
`id` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '流水数据批次ID',
`tab_id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '关联模板表ID',
`tab_conf_id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '关联模板表配置ID',
`dept_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '关联部门ID',
`status` tinyint(4) UNSIGNED NOT NULL COMMENT '批次状态',
`scope` tinyint(4) UNSIGNED NOT NULL COMMENT '关联部门的层级',
`begin_date` int(11) UNSIGNED NOT NULL COMMENT '结算周期开始日期',
`end_date` int(11) UNSIGNED NOT NULL COMMENT '结算周期结束日期',
`summary` decimal(13, 2) NOT NULL COMMENT '汇总计算',
`total` int(11) NOT NULL COMMENT '汇总计数',
`is_available` tinyint(1) UNSIGNED NOT NULL DEFAULT 1,
`creation_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0),
`update_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '最新修改时间',
PRIMARY KEY (`no_`) USING BTREE,
UNIQUE INDEX `uk_stm_data_bat_id`(`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;
-- ----------------------------
-- Table structure for timing_task
-- ----------------------------
DROP TABLE IF EXISTS `timing_task`;
CREATE TABLE `timing_task` (
`no_` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键、自增',
`id` bigint(20) UNSIGNED NOT NULL COMMENT 'id',
`task_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 'celery task id',
`exc_time` int(11) UNSIGNED NOT NULL COMMENT '执行时间',
`executor` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
`exc_operation` blob NOT NULL COMMENT '执行操作',
`exc_data` blob NOT NULL COMMENT '执行数据',
`exc_result` tinyint(3) UNSIGNED NOT NULL DEFAULT 0 COMMENT '执行结果',
`status` tinyint(3) UNSIGNED NOT NULL DEFAULT 0 COMMENT '执行状态',
`pid` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '流程发起后唯一识别id',
`is_available` tinyint(1) UNSIGNED NOT NULL DEFAULT 1,
`creation_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0),
`update_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '最新修改时间',
PRIMARY KEY (`no_`) USING BTREE,
UNIQUE INDEX `uk_timing_task_id`(`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;
-- ----------------------------
-- Table structure for tmpl
-- ----------------------------
DROP TABLE IF EXISTS `tmpl`;
CREATE TABLE `tmpl` (
`no_` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键、自增',
`id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '模板ID',
`plf_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '关联平台ID',
`biz_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '关联业务ID',
`cls` tinyint(4) UNSIGNED NOT NULL COMMENT '模板系统类型',
`name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '模板名称',
`is_available` tinyint(1) UNSIGNED NOT NULL DEFAULT 1,
`creation_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0),
`update_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '最新修改时间',
PRIMARY KEY (`no_`) USING BTREE,
UNIQUE INDEX `uk_tmpl_id`(`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;
-- ----------------------------
-- Table structure for tmpl_field
-- ----------------------------
DROP TABLE IF EXISTS `tmpl_field`;
CREATE TABLE `tmpl_field` (
`no_` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键、自增',
`id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '模板字段ID',
`tab_id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '关联模板表ID',
`name` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '字段名称',
`type` tinyint(4) UNSIGNED NOT NULL COMMENT '字段类型',
`cls` tinyint(4) UNSIGNED NOT NULL COMMENT '字段系统类型',
`is_available` tinyint(1) UNSIGNED NOT NULL DEFAULT 1,
`creation_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0),
`update_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '最新修改时间',
PRIMARY KEY (`no_`) USING BTREE,
UNIQUE INDEX `uk_field_id`(`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;
-- ----------------------------
-- Table structure for tmpl_key
-- ----------------------------
DROP TABLE IF EXISTS `tmpl_key`;
CREATE TABLE `tmpl_key` (
`no_` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键、自增',
`id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '模板键ID',
`tab_id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '关联模板表ID',
`cls` tinyint(4) UNSIGNED NOT NULL COMMENT '模板键系统类型',
`content` json NULL COMMENT '关联模板ID',
`is_available` tinyint(1) UNSIGNED NOT NULL DEFAULT 1,
`creation_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0),
`update_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '最新修改时间',
PRIMARY KEY (`no_`) USING BTREE,
UNIQUE INDEX `uk_key_id`(`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;
-- ----------------------------
-- Table structure for tmpl_table
-- ----------------------------
DROP TABLE IF EXISTS `tmpl_table`;
CREATE TABLE `tmpl_table` (
`no_` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键、自增',
`id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '模板表ID',
`tmpl_id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '关联模板ID',
`cls` tinyint(4) UNSIGNED NOT NULL COMMENT '模板表系统类型',
`is_available` tinyint(1) UNSIGNED NOT NULL DEFAULT 1,
`creation_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0),
`update_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '最新修改时间',
PRIMARY KEY (`no_`) USING BTREE,
UNIQUE INDEX `uk_table_id`(`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;
-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
`no_` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键、自增',
`id` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '用户id',
`phone_num` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '手机号码(账号)',
`profile_pic` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '用户头像',
`alias` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '花名',
`name` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '姓名',
`gender` tinyint(4) UNSIGNED NULL DEFAULT 1 COMMENT '1-未知 2-男 3-女',
`status` tinyint(4) UNSIGNED NOT NULL DEFAULT 1 COMMENT '0-禁用 1-启用 ',
`is_available` tinyint(1) UNSIGNED NOT NULL DEFAULT 1,
`creation_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0),
`update_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '最新修改时间',
PRIMARY KEY (`no_`) USING BTREE,
UNIQUE INDEX `uk_user_id`(`id`) USING BTREE,
UNIQUE INDEX `uk_user_phone_num`(`phone_num`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;
-- ----------------------------
-- Table structure for user_and_role
-- ----------------------------
DROP TABLE IF EXISTS `user_and_role`;
CREATE TABLE `user_and_role` (
`no_` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键、自增',
`user_id` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '用户id',
`role_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '角色id',
`is_available` tinyint(1) UNSIGNED NOT NULL DEFAULT 1,
`creation_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0),
`update_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '最新修改时间',
PRIMARY KEY (`no_`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;
-- ----------------------------
-- Table structure for user_auth_rel
-- ----------------------------
DROP TABLE IF EXISTS `user_auth_rel`;
CREATE TABLE `user_auth_rel` (
`no_` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键、自增',
`user_id` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '用户表外键id',
`auth_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '鉴权id,外键',
`auth_type` tinyint(4) UNSIGNED NULL DEFAULT NULL COMMENT '鉴权方式',
`token` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 'token',
`expire_at` int(11) UNSIGNED NULL DEFAULT NULL COMMENT '时间过期',
`try_times` tinyint(4) UNSIGNED NULL DEFAULT 0 COMMENT '错误方式',
`is_available` tinyint(1) UNSIGNED NOT NULL DEFAULT 1,
`creation_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0),
`update_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '最新修改时间',
PRIMARY KEY (`no_`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;
-- ----------------------------
-- Table structure for user_local_auth
-- ----------------------------
DROP TABLE IF EXISTS `user_local_auth`;
CREATE TABLE `user_local_auth` (
`no_` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键、自增',
`id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '鉴权id',
`password` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '用户密码',
`is_available` tinyint(1) UNSIGNED NOT NULL DEFAULT 1,
`creation_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0),
`update_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '最新修改时间',
PRIMARY KEY (`no_`) USING BTREE,
UNIQUE INDEX `uk_user_local_auth_id`(`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;
-- ----------------------------
-- Table structure for user_privilege
-- ----------------------------
DROP TABLE IF EXISTS `user_privilege`;
CREATE TABLE `user_privilege` (
`no_` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键、自增',
`user_id` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '用户外键id',
`role_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '角色外键id',
`dept_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '部门外键id',
`is_available` tinyint(1) UNSIGNED NOT NULL DEFAULT 1,
`creation_time` timestamp(0) NULL DEFAULT CURRENT_TIMESTAMP(0),
`update_time` timestamp(0) NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '最新修改时间',
PRIMARY KEY (`no_`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;
-- ----------------------------
-- Table structure for user_third_auth
-- ----------------------------
DROP TABLE IF EXISTS `user_third_auth`;
CREATE TABLE `user_third_auth` (
`no_` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键、自增',
`id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '鉴权id',
`openid` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '第三方id',
`login_type` tinyint(4) UNSIGNED NOT NULL COMMENT '登录类型',
`access_token` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 'access_token',
`is_available` tinyint(1) UNSIGNED NOT NULL DEFAULT 1,
`creation_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0),
`update_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '最新修改时间',
PRIMARY KEY (`no_`) USING BTREE,
UNIQUE INDEX `uk_user_third_auth_id`(`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;
-- ----------------------------
-- Table structure for wallet_account
-- ----------------------------
DROP TABLE IF EXISTS `wallet_account`;
CREATE TABLE `wallet_account` (
`no_` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键、自增',
`id` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '钱包账户ID',
`number` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '钱包账号',
`available` decimal(13, 2) NOT NULL COMMENT '可用余额',
`frozen` decimal(13, 2) NOT NULL COMMENT '冻结金额',
`user_id` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '用户外键id',
`account_id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '默认提现账户id',
`is_available` tinyint(1) UNSIGNED NOT NULL DEFAULT 1,
`creation_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0),
`update_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '最新修改时间',
PRIMARY KEY (`no_`) USING BTREE,
UNIQUE INDEX `uk_wallet_account_id`(`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;
-- ----------------------------
-- Table structure for wallet_detail
-- ----------------------------
DROP TABLE IF EXISTS `wallet_detail`;
CREATE TABLE `wallet_detail` (
`no_` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键、自增',
`id` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '钱包流水ID',
`wallet_num` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '钱包账号',
`amount_before` decimal(13, 2) NOT NULL COMMENT '流水发生前余额',
`direction` tinyint(1) NULL DEFAULT NULL COMMENT ' 1-提现 2-收入',
`amount` decimal(13, 2) NOT NULL COMMENT '流水发生金额',
`fee` decimal(13, 2) NOT NULL COMMENT '流水手续费',
`title` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '流水说明',
`create_time` int(11) UNSIGNED NULL DEFAULT NULL COMMENT '流水发生时间',
`is_available` tinyint(1) UNSIGNED NOT NULL DEFAULT 1,
`creation_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0),
`update_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '最新修改时间',
PRIMARY KEY (`no_`) USING BTREE,
UNIQUE INDEX `uk_wallet_detail_id`(`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;
-- ----------------------------
-- Table structure for withdrawl_astrict
-- ----------------------------
DROP TABLE IF EXISTS `withdrawl_astrict`;
CREATE TABLE `withdrawl_astrict` (
`no_` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键、自增',
`id` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '提现限制ID',
`daily_withdrawl_time` int(32) NOT NULL COMMENT '每日累计提现次数',
`monthly_withdrawl_limit` decimal(13, 2) NOT NULL COMMENT '每月提现累计额度',
`is_available` tinyint(1) UNSIGNED NOT NULL DEFAULT 1,
`creation_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0),
`update_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '最新修改时间',
PRIMARY KEY (`no_`) USING BTREE,
UNIQUE INDEX `uk_wallet_detail_id`(`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;
-- ----------------------------
-- Table structure for withdrawl_bat
-- ----------------------------
DROP TABLE IF EXISTS `withdrawl_bat`;
CREATE TABLE `withdrawl_bat` (
`no_` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键、自增',
`id` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '日结结算数据ID',
`company_id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '关联公司ID',
`third_bat_num` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '发放平台批次号',
`total_count` int(11) NOT NULL COMMENT '总笔数',
`total_amount` decimal(13, 2) NOT NULL COMMENT '总金额',
`withdrawl_method` tinyint(4) UNSIGNED NOT NULL COMMENT '提现方式',
`withdrawl_date` int(11) UNSIGNED NOT NULL COMMENT '提现日期',
`withdrawl_status` tinyint(4) UNSIGNED NOT NULL COMMENT '提现结果',
`push_time` int(11) UNSIGNED NULL DEFAULT NULL COMMENT '最新推送时间',
`push_status` tinyint(4) UNSIGNED NULL DEFAULT NULL COMMENT '最新推送状态',
`push_failure` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '最新推送失败原因',
`is_available` tinyint(1) UNSIGNED NOT NULL DEFAULT 1,
`creation_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0),
`update_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '最新修改时间',
PRIMARY KEY (`no_`) USING BTREE,
UNIQUE INDEX `uk_withdrawl_bat_id`(`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;
-- ----------------------------
-- Table structure for withdrawl_stm
-- ----------------------------
DROP TABLE IF EXISTS `withdrawl_stm`;
CREATE TABLE `withdrawl_stm` (
`no_` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键、自增',
`id` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '日结结算数据ID',
`account_id` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '关联钱包账户ID',
`wallet_stm_id` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '关联钱包流水ID',
`withdrawl_bat_id` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '关联提现批次ID',
`company_id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '关联公司ID',
`amount` decimal(13, 2) NOT NULL COMMENT '流水金额',
`fee` decimal(13, 2) NOT NULL COMMENT '流水手续费',
`remark` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '流水备注',
`withdrawl_time` int(11) UNSIGNED NOT NULL COMMENT '提现时间',
`withdrawl_method` tinyint(4) UNSIGNED NOT NULL COMMENT '提现方式',
`withdrawl_status` tinyint(4) UNSIGNED NOT NULL COMMENT '提现结果',
`payment_time` int(11) UNSIGNED NULL DEFAULT NULL COMMENT '支付时间',
`result_code` varchar(8) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '支付结果代码',
`result_detail` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '支付结果说明',
`result_sn` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
`is_available` tinyint(1) UNSIGNED NOT NULL DEFAULT 1,
`creation_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0),
`update_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '最新修改时间',
PRIMARY KEY (`no_`) USING BTREE,
UNIQUE INDEX `uk_withdrawl_stm_id`(`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;
------------------------
-- V1.0.4.3 新增数据表
------------------------
SET FOREIGN_KEY_CHECKS = 1;</code></pre>