嗨玩后端开发规范


易公会数据库表结构

  • <font color="blue">更新日期:2021/12/08 16:30</font>

-- ----------------------------
-- 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;

页面列表

ITEM_HTML