易公会数据库表结构

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