shanxia/bx/docs/bx.sql

/*
 Navicat Premium Dump SQL

 Source Server         : 121.43.228.102 hn02le.34lkdLKD
 Source Server Type    : MySQL
 Source Server Version : 50736 (5.7.36)
 Source Host           : 121.43.228.102:3306
 Source Schema         : sx

 Target Server Type    : MySQL
 Target Server Version : 50736 (5.7.36)
 File Encoding         : 65001

 Date: 08/05/2026 11:35:39
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for bx_advance_apply
-- ----------------------------
DROP TABLE IF EXISTS `bx_advance_apply`;
CREATE TABLE `bx_advance_apply` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `apply_code` varchar(32) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '申请单号（如 BYJ20260424001）',
  `applicant_id` bigint(20) NOT NULL COMMENT '申请人用户ID',
  `applicant_name` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '申请人姓名（冗余）',
  `reason` varchar(1024) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '申请原因',
  `purpose` varchar(1024) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '申请目的',
  `expense_item_id` bigint(20) DEFAULT NULL COMMENT '费用项目ID',
  `amount` decimal(14,2) NOT NULL COMMENT '申请金额',
  `status` varchar(32) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'draft' COMMENT '状态：draft-草稿 pending-待审批 approved-审批通过 rejected-审批驳回 issued-已发放',
  `current_node` varchar(128) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '当前审批节点名称',
  `wf_id` bigint(20) DEFAULT NULL COMMENT '关联工作流定义ID',
  `issue_status` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '发放状态：unissued-未发放 issued-已发放',
  `issue_time` datetime DEFAULT NULL COMMENT '发放时间',
  `issue_user_id` bigint(20) DEFAULT NULL COMMENT '发放操作人ID',
  `issue_user_name` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '发放操作人姓名',
  `issue_remark` varchar(512) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '发放备注',
  `actual_amount` decimal(14,2) DEFAULT NULL COMMENT '实际发放金额',
  `remark` varchar(512) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '备注',
  `create_by` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '创建人',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_by` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '更新人',
  `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  `del_flag` tinyint(4) NOT NULL DEFAULT '0' COMMENT '删除标记：0-正常 1-已删除',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `uk_apply_code` (`apply_code`) USING BTREE,
  KEY `idx_applicant_id` (`applicant_id`) USING BTREE,
  KEY `idx_status` (`status`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='备用金申请单';

-- ----------------------------
-- Records of bx_advance_apply
-- ----------------------------
BEGIN;
INSERT INTO `bx_advance_apply` (`id`, `apply_code`, `applicant_id`, `applicant_name`, `reason`, `purpose`, `expense_item_id`, `amount`, `status`, `current_node`, `wf_id`, `issue_status`, `issue_time`, `issue_user_id`, `issue_user_name`, `issue_remark`, `actual_amount`, `remark`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (15, 'BYJ20260505001', 16, '吴九华', '充值油卡', NULL, NULL, 10000.00, 'pending', '财务', 1, NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, '2026-05-05 20:46:16', '16', '2026-05-05 21:04:13', 0);
INSERT INTO `bx_advance_apply` (`id`, `apply_code`, `applicant_id`, `applicant_name`, `reason`, `purpose`, `expense_item_id`, `amount`, `status`, `current_node`, `wf_id`, `issue_status`, `issue_time`, `issue_user_id`, `issue_user_name`, `issue_remark`, `actual_amount`, `remark`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (16, 'BYJ20260505002', 16, '吴九华', '充值油卡', NULL, NULL, 10000.00, 'draft', NULL, 1, NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, '2026-05-05 20:46:16', NULL, '2026-05-05 20:46:16', 0);
COMMIT;

-- ----------------------------
-- Table structure for bx_advance_approval
-- ----------------------------
DROP TABLE IF EXISTS `bx_advance_approval`;
CREATE TABLE `bx_advance_approval` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `apply_id` bigint(20) NOT NULL COMMENT '备用金申请单ID',
  `node_order` int(11) NOT NULL COMMENT '节点顺序',
  `node_name` varchar(128) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '节点名称',
  `approver_id` bigint(20) NOT NULL COMMENT '审批人用户ID',
  `approver_name` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '审批人姓名',
  `approval_status` varchar(32) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '审批结果：approved-通过 rejected-驳回',
  `approval_opinion` varchar(1024) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '审批意见',
  `approval_time` datetime NOT NULL COMMENT '审批时间',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `idx_apply_id` (`apply_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='备用金审批记录表';

-- ----------------------------
-- Records of bx_advance_approval
-- ----------------------------
BEGIN;
INSERT INTO `bx_advance_approval` (`id`, `apply_id`, `node_order`, `node_name`, `approver_id`, `approver_name`, `approval_status`, `approval_opinion`, `approval_time`) VALUES (19, 15, 1, '总经理审批', 16, 'jiuhua', 'approved', '审批通过', '2026-05-05 21:04:13');
COMMIT;

-- ----------------------------
-- Table structure for bx_attachment
-- ----------------------------
DROP TABLE IF EXISTS `bx_attachment`;
CREATE TABLE `bx_attachment` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `biz_type` varchar(32) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '业务类型：advance-备用金 reimburse-报销 advance_issue-备用金发放',
  `biz_id` bigint(20) NOT NULL COMMENT '业务单据ID',
  `file_name` varchar(256) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '文件名',
  `file_path` varchar(512) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '文件存储路径',
  `file_type` varchar(128) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `file_size` bigint(20) DEFAULT NULL COMMENT '文件大小（字节）',
  `attach_type` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT 'attachment' COMMENT '附件类型：invoice-发票 attachment-普通附件 issue_proof-发放截图',
  `sort_order` int(11) NOT NULL DEFAULT '0' COMMENT '排序号',
  `create_by` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '创建人',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `del_flag` tinyint(4) NOT NULL DEFAULT '0' COMMENT '删除标记：0-正常 1-已删除',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `idx_biz` (`biz_type`,`biz_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=134 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='附件表';

-- ----------------------------
-- Records of bx_attachment
-- ----------------------------
BEGIN;
INSERT INTO `bx_attachment` (`id`, `biz_type`, `biz_id`, `file_name`, `file_path`, `file_type`, `file_size`, `attach_type`, `sort_order`, `create_by`, `create_time`, `del_flag`) VALUES (133, 'advance', 16, '微信图片_20260504214359_770_441.jpg', 'bx/2026-05-05/4dc2f70249954151b8585df054d7bd8f.jpg', 'image/jpeg', 211175, 'attachment', 0, '16', '2026-05-05 20:46:15', 0);
COMMIT;

-- ----------------------------
-- Table structure for bx_expense_item
-- ----------------------------
DROP TABLE IF EXISTS `bx_expense_item`;
CREATE TABLE `bx_expense_item` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `parent_id` bigint(20) NOT NULL DEFAULT '0' COMMENT '父级项目ID（0为一级项目）',
  `item_name` varchar(128) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '项目名称',
  `item_code` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '项目编码',
  `level` tinyint(4) NOT NULL DEFAULT '1' COMMENT '层级：1-一级 2-二级',
  `sort_order` int(11) NOT NULL DEFAULT '0' COMMENT '排序号',
  `status` tinyint(4) NOT NULL DEFAULT '1' COMMENT '状态：1-启用 0-禁用',
  `remark` varchar(512) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '备注',
  `create_by` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '创建人',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_by` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '更新人',
  `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  `del_flag` tinyint(4) NOT NULL DEFAULT '0' COMMENT '删除标记：0-正常 1-已删除',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `idx_parent_id` (`parent_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=30 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='费用项目表';

-- ----------------------------
-- Records of bx_expense_item
-- ----------------------------
BEGIN;
INSERT INTO `bx_expense_item` (`id`, `parent_id`, `item_name`, `item_code`, `level`, `sort_order`, `status`, `remark`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (28, 0, '办公费', '', 1, 1, 1, '', NULL, '2026-05-05 21:30:17', NULL, '2026-05-05 21:30:17', 0);
INSERT INTO `bx_expense_item` (`id`, `parent_id`, `item_name`, `item_code`, `level`, `sort_order`, `status`, `remark`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (29, 28, '办公用品', '', 2, 1, 1, '', NULL, '2026-05-05 21:30:26', NULL, '2026-05-05 21:30:26', 0);
COMMIT;

-- ----------------------------
-- Table structure for bx_menu
-- ----------------------------
DROP TABLE IF EXISTS `bx_menu`;
CREATE TABLE `bx_menu` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `parent_id` bigint(20) NOT NULL DEFAULT '0' COMMENT '父级菜单ID（0为顶级）',
  `menu_name` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '菜单名称',
  `menu_code` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '菜单编码（前端路由标识）',
  `menu_type` tinyint(4) NOT NULL COMMENT '菜单类型：1-目录 2-菜单页 3-按钮/操作',
  `path` varchar(256) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '路由路径',
  `icon` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '菜单图标',
  `sort_order` int(11) NOT NULL DEFAULT '0' COMMENT '排序号',
  `visible` tinyint(4) NOT NULL DEFAULT '1' COMMENT '是否可见：1-可见 0-隐藏',
  `status` tinyint(4) NOT NULL DEFAULT '1' COMMENT '状态：1-启用 0-禁用',
  `remark` varchar(512) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '备注',
  `create_by` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '创建人',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_by` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '更新人',
  `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  `del_flag` tinyint(4) NOT NULL DEFAULT '0' COMMENT '删除标记：0-正常 1-已删除',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `idx_parent_id` (`parent_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=405 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='报销系统菜单表';

-- ----------------------------
-- Records of bx_menu
-- ----------------------------
BEGIN;
INSERT INTO `bx_menu` (`id`, `parent_id`, `menu_name`, `menu_code`, `menu_type`, `path`, `icon`, `sort_order`, `visible`, `status`, `remark`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (90, 0, '首页', 'dashboard', 2, '/home', NULL, 0, 1, 1, '工作台', 'system', '2026-05-05 15:40:15', 'system', '2026-05-05 16:03:35', 0);
INSERT INTO `bx_menu` (`id`, `parent_id`, `menu_name`, `menu_code`, `menu_type`, `path`, `icon`, `sort_order`, `visible`, `status`, `remark`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (91, 0, '首页', 'dashboard', 2, '/home', NULL, 0, 1, 1, NULL, 'system', '2026-05-05 15:40:15', 'system', '2026-05-05 16:03:35', 1);
INSERT INTO `bx_menu` (`id`, `parent_id`, `menu_name`, `menu_code`, `menu_type`, `path`, `icon`, `sort_order`, `visible`, `status`, `remark`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (100, 0, '基础管理', NULL, 1, NULL, NULL, 1, 1, 1, NULL, NULL, '2026-04-26 11:33:02', NULL, '2026-04-26 11:33:02', 0);
INSERT INTO `bx_menu` (`id`, `parent_id`, `menu_name`, `menu_code`, `menu_type`, `path`, `icon`, `sort_order`, `visible`, `status`, `remark`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (101, 100, '用户管理', 'user-manage', 2, '/base/user', NULL, 1, 1, 1, NULL, NULL, '2026-04-26 11:33:02', NULL, '2026-04-26 11:33:02', 0);
INSERT INTO `bx_menu` (`id`, `parent_id`, `menu_name`, `menu_code`, `menu_type`, `path`, `icon`, `sort_order`, `visible`, `status`, `remark`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (102, 100, '角色管理', 'role-manage', 2, '/base/role', NULL, 2, 1, 1, NULL, NULL, '2026-04-26 11:33:02', NULL, '2026-04-26 11:33:02', 0);
INSERT INTO `bx_menu` (`id`, `parent_id`, `menu_name`, `menu_code`, `menu_type`, `path`, `icon`, `sort_order`, `visible`, `status`, `remark`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (103, 100, '菜单管理', 'menu-manage', 2, '/base/menu', NULL, 3, 1, 1, NULL, NULL, '2026-04-26 11:33:02', NULL, '2026-04-26 11:33:02', 0);
INSERT INTO `bx_menu` (`id`, `parent_id`, `menu_name`, `menu_code`, `menu_type`, `path`, `icon`, `sort_order`, `visible`, `status`, `remark`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (200, 0, '基础配置', NULL, 1, NULL, NULL, 2, 1, 1, NULL, NULL, '2026-04-26 11:33:03', NULL, '2026-04-26 11:33:03', 0);
INSERT INTO `bx_menu` (`id`, `parent_id`, `menu_name`, `menu_code`, `menu_type`, `path`, `icon`, `sort_order`, `visible`, `status`, `remark`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (201, 200, '费用项目管理', 'project', 2, '/config/expense', NULL, 1, 1, 1, NULL, NULL, '2026-04-26 11:33:03', NULL, '2026-04-26 11:33:03', 0);
INSERT INTO `bx_menu` (`id`, `parent_id`, `menu_name`, `menu_code`, `menu_type`, `path`, `icon`, `sort_order`, `visible`, `status`, `remark`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (202, 200, '工作流配置（备用金）', 'wf-advance', 2, '/config/wf-advance', NULL, 2, 1, 1, NULL, NULL, '2026-04-26 11:33:03', NULL, '2026-04-26 11:33:03', 0);
INSERT INTO `bx_menu` (`id`, `parent_id`, `menu_name`, `menu_code`, `menu_type`, `path`, `icon`, `sort_order`, `visible`, `status`, `remark`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (203, 200, '工作流配置（报销单）', 'wf-reimburse', 2, '/config/wf-reimburse', NULL, 3, 1, 1, NULL, NULL, '2026-04-26 11:33:03', NULL, '2026-04-26 11:33:03', 0);
INSERT INTO `bx_menu` (`id`, `parent_id`, `menu_name`, `menu_code`, `menu_type`, `path`, `icon`, `sort_order`, `visible`, `status`, `remark`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (300, 0, '报销业务', NULL, 1, NULL, NULL, 3, 1, 1, NULL, NULL, '2026-04-26 11:33:03', NULL, '2026-05-05 09:34:45', 1);
INSERT INTO `bx_menu` (`id`, `parent_id`, `menu_name`, `menu_code`, `menu_type`, `path`, `icon`, `sort_order`, `visible`, `status`, `remark`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (310, 0, '我的', NULL, 1, NULL, NULL, 3, 1, 1, NULL, NULL, '2026-04-26 11:33:03', NULL, '2026-05-05 12:20:53', 0);
INSERT INTO `bx_menu` (`id`, `parent_id`, `menu_name`, `menu_code`, `menu_type`, `path`, `icon`, `sort_order`, `visible`, `status`, `remark`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (311, 310, '备用金申请', 'advance-apply', 2, '/biz/advance-apply', NULL, 1, 1, 1, NULL, NULL, '2026-04-26 11:33:03', NULL, '2026-04-26 11:33:03', 0);
INSERT INTO `bx_menu` (`id`, `parent_id`, `menu_name`, `menu_code`, `menu_type`, `path`, `icon`, `sort_order`, `visible`, `status`, `remark`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (312, 320, '备用金审批', 'advance-approve', 2, '/biz/advance-approve', NULL, 1, 1, 1, NULL, NULL, '2026-04-26 11:33:03', NULL, '2026-05-05 09:31:42', 0);
INSERT INTO `bx_menu` (`id`, `parent_id`, `menu_name`, `menu_code`, `menu_type`, `path`, `icon`, `sort_order`, `visible`, `status`, `remark`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (313, 330, '备用金发放管理', 'advance-issue', 2, '/biz/advance-issue', NULL, 1, 1, 1, NULL, NULL, '2026-04-26 11:33:03', NULL, '2026-05-05 09:31:42', 0);
INSERT INTO `bx_menu` (`id`, `parent_id`, `menu_name`, `menu_code`, `menu_type`, `path`, `icon`, `sort_order`, `visible`, `status`, `remark`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (320, 0, '待办', NULL, 1, NULL, NULL, 4, 1, 1, NULL, NULL, '2026-04-26 11:33:03', NULL, '2026-05-05 12:20:54', 0);
INSERT INTO `bx_menu` (`id`, `parent_id`, `menu_name`, `menu_code`, `menu_type`, `path`, `icon`, `sort_order`, `visible`, `status`, `remark`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (321, 310, '报销申请', 'reimburse-apply', 2, '/biz/reimburse-apply', NULL, 2, 1, 1, NULL, NULL, '2026-04-26 11:33:03', NULL, '2026-05-05 09:31:42', 0);
INSERT INTO `bx_menu` (`id`, `parent_id`, `menu_name`, `menu_code`, `menu_type`, `path`, `icon`, `sort_order`, `visible`, `status`, `remark`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (322, 320, '报销审批', 'reimburse-approve', 2, '/biz/reimburse-approve', NULL, 2, 1, 1, NULL, NULL, '2026-04-26 11:33:03', NULL, '2026-04-26 11:33:03', 0);
INSERT INTO `bx_menu` (`id`, `parent_id`, `menu_name`, `menu_code`, `menu_type`, `path`, `icon`, `sort_order`, `visible`, `status`, `remark`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (323, 330, '支付管理（发放/冲抵）', 'payment', 2, '/biz/payment', NULL, 2, 1, 1, NULL, NULL, '2026-04-26 11:33:03', NULL, '2026-05-05 09:31:42', 0);
INSERT INTO `bx_menu` (`id`, `parent_id`, `menu_name`, `menu_code`, `menu_type`, `path`, `icon`, `sort_order`, `visible`, `status`, `remark`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (330, 0, '发放/冲抵', NULL, 1, NULL, NULL, 5, 1, 1, NULL, NULL, '2026-05-05 09:31:42', NULL, '2026-05-05 12:20:54', 0);
INSERT INTO `bx_menu` (`id`, `parent_id`, `menu_name`, `menu_code`, `menu_type`, `path`, `icon`, `sort_order`, `visible`, `status`, `remark`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (400, 0, '视图中心', NULL, 1, NULL, NULL, 6, 1, 1, NULL, NULL, '2026-04-26 11:33:03', NULL, '2026-05-05 09:34:45', 0);
INSERT INTO `bx_menu` (`id`, `parent_id`, `menu_name`, `menu_code`, `menu_type`, `path`, `icon`, `sort_order`, `visible`, `status`, `remark`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (401, 400, '我的申请单', 'mine', 2, '/view/mine', NULL, 1, 1, 1, NULL, NULL, '2026-04-26 11:33:03', NULL, '2026-04-26 11:33:03', 0);
INSERT INTO `bx_menu` (`id`, `parent_id`, `menu_name`, `menu_code`, `menu_type`, `path`, `icon`, `sort_order`, `visible`, `status`, `remark`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (402, 400, '待我审批', 'todo', 2, '/view/todo', NULL, 2, 1, 1, NULL, NULL, '2026-04-26 11:33:03', NULL, '2026-04-26 11:33:03', 0);
INSERT INTO `bx_menu` (`id`, `parent_id`, `menu_name`, `menu_code`, `menu_type`, `path`, `icon`, `sort_order`, `visible`, `status`, `remark`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (403, 400, '全部申请单（总经理）', 'all', 2, '/view/all', NULL, 3, 1, 1, NULL, NULL, '2026-04-26 11:33:03', NULL, '2026-04-26 11:33:03', 0);
INSERT INTO `bx_menu` (`id`, `parent_id`, `menu_name`, `menu_code`, `menu_type`, `path`, `icon`, `sort_order`, `visible`, `status`, `remark`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (404, 100, '213', '123', 2, '12312321', NULL, 1, 1, 1, NULL, NULL, '2026-05-04 09:17:07', NULL, '2026-05-05 09:31:42', 1);
COMMIT;

-- ----------------------------
-- Table structure for bx_menu_role
-- ----------------------------
DROP TABLE IF EXISTS `bx_menu_role`;
CREATE TABLE `bx_menu_role` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `menu_id` bigint(20) NOT NULL COMMENT '菜单ID',
  `role_id` bigint(20) NOT NULL COMMENT '角色ID',
  `create_by` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '创建人',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `uk_menu_role` (`menu_id`,`role_id`) USING BTREE,
  KEY `idx_role_id` (`role_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=104 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='菜单-角色关联表';

-- ----------------------------
-- Records of bx_menu_role
-- ----------------------------
BEGIN;
INSERT INTO `bx_menu_role` (`id`, `menu_id`, `role_id`, `create_by`, `create_time`) VALUES (1, 100, 1, NULL, '2026-04-26 14:18:30');
INSERT INTO `bx_menu_role` (`id`, `menu_id`, `role_id`, `create_by`, `create_time`) VALUES (2, 101, 1, NULL, '2026-04-26 14:18:30');
INSERT INTO `bx_menu_role` (`id`, `menu_id`, `role_id`, `create_by`, `create_time`) VALUES (3, 102, 1, NULL, '2026-04-26 14:18:30');
INSERT INTO `bx_menu_role` (`id`, `menu_id`, `role_id`, `create_by`, `create_time`) VALUES (4, 103, 1, NULL, '2026-04-26 14:18:30');
INSERT INTO `bx_menu_role` (`id`, `menu_id`, `role_id`, `create_by`, `create_time`) VALUES (5, 200, 1, NULL, '2026-04-26 14:18:30');
INSERT INTO `bx_menu_role` (`id`, `menu_id`, `role_id`, `create_by`, `create_time`) VALUES (6, 201, 1, NULL, '2026-04-26 14:18:30');
INSERT INTO `bx_menu_role` (`id`, `menu_id`, `role_id`, `create_by`, `create_time`) VALUES (7, 202, 1, NULL, '2026-04-26 14:18:30');
INSERT INTO `bx_menu_role` (`id`, `menu_id`, `role_id`, `create_by`, `create_time`) VALUES (8, 203, 1, NULL, '2026-04-26 14:18:30');
INSERT INTO `bx_menu_role` (`id`, `menu_id`, `role_id`, `create_by`, `create_time`) VALUES (10, 310, 1, NULL, '2026-04-26 14:18:30');
INSERT INTO `bx_menu_role` (`id`, `menu_id`, `role_id`, `create_by`, `create_time`) VALUES (11, 311, 1, NULL, '2026-04-26 14:18:30');
INSERT INTO `bx_menu_role` (`id`, `menu_id`, `role_id`, `create_by`, `create_time`) VALUES (12, 312, 1, NULL, '2026-04-26 14:18:30');
INSERT INTO `bx_menu_role` (`id`, `menu_id`, `role_id`, `create_by`, `create_time`) VALUES (13, 313, 1, NULL, '2026-04-26 14:18:30');
INSERT INTO `bx_menu_role` (`id`, `menu_id`, `role_id`, `create_by`, `create_time`) VALUES (14, 320, 1, NULL, '2026-04-26 14:18:30');
INSERT INTO `bx_menu_role` (`id`, `menu_id`, `role_id`, `create_by`, `create_time`) VALUES (15, 321, 1, NULL, '2026-04-26 14:18:30');
INSERT INTO `bx_menu_role` (`id`, `menu_id`, `role_id`, `create_by`, `create_time`) VALUES (16, 322, 1, NULL, '2026-04-26 14:18:30');
INSERT INTO `bx_menu_role` (`id`, `menu_id`, `role_id`, `create_by`, `create_time`) VALUES (17, 323, 1, NULL, '2026-04-26 14:18:30');
INSERT INTO `bx_menu_role` (`id`, `menu_id`, `role_id`, `create_by`, `create_time`) VALUES (18, 400, 1, NULL, '2026-04-26 14:18:30');
INSERT INTO `bx_menu_role` (`id`, `menu_id`, `role_id`, `create_by`, `create_time`) VALUES (19, 401, 1, NULL, '2026-04-26 14:18:30');
INSERT INTO `bx_menu_role` (`id`, `menu_id`, `role_id`, `create_by`, `create_time`) VALUES (20, 402, 1, NULL, '2026-04-26 14:18:30');
INSERT INTO `bx_menu_role` (`id`, `menu_id`, `role_id`, `create_by`, `create_time`) VALUES (21, 403, 1, NULL, '2026-04-26 14:18:30');
INSERT INTO `bx_menu_role` (`id`, `menu_id`, `role_id`, `create_by`, `create_time`) VALUES (54, 321, 2, NULL, '2026-05-05 09:41:40');
INSERT INTO `bx_menu_role` (`id`, `menu_id`, `role_id`, `create_by`, `create_time`) VALUES (55, 311, 2, NULL, '2026-05-05 09:41:40');
INSERT INTO `bx_menu_role` (`id`, `menu_id`, `role_id`, `create_by`, `create_time`) VALUES (56, 310, 2, NULL, '2026-05-05 09:41:40');
INSERT INTO `bx_menu_role` (`id`, `menu_id`, `role_id`, `create_by`, `create_time`) VALUES (57, 320, 3, NULL, '2026-05-05 09:41:53');
INSERT INTO `bx_menu_role` (`id`, `menu_id`, `role_id`, `create_by`, `create_time`) VALUES (58, 311, 3, NULL, '2026-05-05 09:41:53');
INSERT INTO `bx_menu_role` (`id`, `menu_id`, `role_id`, `create_by`, `create_time`) VALUES (59, 321, 3, NULL, '2026-05-05 09:41:53');
INSERT INTO `bx_menu_role` (`id`, `menu_id`, `role_id`, `create_by`, `create_time`) VALUES (60, 313, 3, NULL, '2026-05-05 09:41:53');
INSERT INTO `bx_menu_role` (`id`, `menu_id`, `role_id`, `create_by`, `create_time`) VALUES (62, 322, 3, NULL, '2026-05-05 09:41:53');
INSERT INTO `bx_menu_role` (`id`, `menu_id`, `role_id`, `create_by`, `create_time`) VALUES (63, 323, 3, NULL, '2026-05-05 09:41:53');
INSERT INTO `bx_menu_role` (`id`, `menu_id`, `role_id`, `create_by`, `create_time`) VALUES (64, 312, 3, NULL, '2026-05-05 09:41:53');
INSERT INTO `bx_menu_role` (`id`, `menu_id`, `role_id`, `create_by`, `create_time`) VALUES (66, 330, 3, NULL, '2026-05-05 09:41:53');
INSERT INTO `bx_menu_role` (`id`, `menu_id`, `role_id`, `create_by`, `create_time`) VALUES (67, 310, 3, NULL, '2026-05-05 09:41:53');
INSERT INTO `bx_menu_role` (`id`, `menu_id`, `role_id`, `create_by`, `create_time`) VALUES (68, 403, 4, NULL, '2026-05-05 09:42:01');
INSERT INTO `bx_menu_role` (`id`, `menu_id`, `role_id`, `create_by`, `create_time`) VALUES (71, 312, 4, NULL, '2026-05-05 09:42:01');
INSERT INTO `bx_menu_role` (`id`, `menu_id`, `role_id`, `create_by`, `create_time`) VALUES (73, 313, 4, NULL, '2026-05-05 09:42:01');
INSERT INTO `bx_menu_role` (`id`, `menu_id`, `role_id`, `create_by`, `create_time`) VALUES (74, 321, 4, NULL, '2026-05-05 09:42:01');
INSERT INTO `bx_menu_role` (`id`, `menu_id`, `role_id`, `create_by`, `create_time`) VALUES (77, 310, 4, NULL, '2026-05-05 09:42:01');
INSERT INTO `bx_menu_role` (`id`, `menu_id`, `role_id`, `create_by`, `create_time`) VALUES (78, 311, 4, NULL, '2026-05-05 09:42:01');
INSERT INTO `bx_menu_role` (`id`, `menu_id`, `role_id`, `create_by`, `create_time`) VALUES (80, 320, 4, NULL, '2026-05-05 09:42:01');
INSERT INTO `bx_menu_role` (`id`, `menu_id`, `role_id`, `create_by`, `create_time`) VALUES (81, 322, 4, NULL, '2026-05-05 09:42:01');
INSERT INTO `bx_menu_role` (`id`, `menu_id`, `role_id`, `create_by`, `create_time`) VALUES (83, 323, 4, NULL, '2026-05-05 09:42:01');
INSERT INTO `bx_menu_role` (`id`, `menu_id`, `role_id`, `create_by`, `create_time`) VALUES (84, 330, 4, NULL, '2026-05-05 09:42:01');
INSERT INTO `bx_menu_role` (`id`, `menu_id`, `role_id`, `create_by`, `create_time`) VALUES (85, 400, 4, NULL, '2026-05-05 09:42:01');
INSERT INTO `bx_menu_role` (`id`, `menu_id`, `role_id`, `create_by`, `create_time`) VALUES (96, 90, 1, NULL, '2026-05-05 16:03:35');
INSERT INTO `bx_menu_role` (`id`, `menu_id`, `role_id`, `create_by`, `create_time`) VALUES (97, 90, 2, NULL, '2026-05-05 16:03:35');
INSERT INTO `bx_menu_role` (`id`, `menu_id`, `role_id`, `create_by`, `create_time`) VALUES (98, 90, 3, NULL, '2026-05-05 16:03:35');
INSERT INTO `bx_menu_role` (`id`, `menu_id`, `role_id`, `create_by`, `create_time`) VALUES (99, 90, 4, NULL, '2026-05-05 16:03:35');
COMMIT;

-- ----------------------------
-- Table structure for bx_reimburse_apply
-- ----------------------------
DROP TABLE IF EXISTS `bx_reimburse_apply`;
CREATE TABLE `bx_reimburse_apply` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `apply_code` varchar(32) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '报销单号（如 BX20260424001）',
  `title` varchar(256) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '报销标题',
  `applicant_id` bigint(20) NOT NULL COMMENT '申请人用户ID',
  `applicant_name` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '申请人姓名（冗余）',
  `expense_id` bigint(20) NOT NULL COMMENT '费用项目ID（二级项目）',
  `expense_name` varchar(128) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '费用项目名称（冗余）',
  `amount` decimal(14,2) NOT NULL COMMENT '报销金额',
  `invoice_count` int(11) NOT NULL DEFAULT '0' COMMENT '发票数量',
  `attach_count` int(11) NOT NULL DEFAULT '0' COMMENT '附件数量',
  `status` varchar(32) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'draft' COMMENT '状态：draft-草稿 pending-待审批 approved-审批通过 rejected-审批驳回 paid-已发放 offset-已冲抵',
  `current_node` varchar(128) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '当前审批节点名称',
  `wf_id` bigint(20) DEFAULT NULL COMMENT '关联工作流定义ID',
  `pay_status` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '支付状态：unpaid-未支付 paid-已发放 offset-已冲抵',
  `pay_time` datetime DEFAULT NULL COMMENT '支付时间',
  `pay_user_id` bigint(20) DEFAULT NULL COMMENT '支付操作人ID',
  `pay_user_name` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '支付操作人姓名',
  `actual_amount` decimal(14,2) DEFAULT NULL COMMENT '实际发放金额',
  `offset_advance_id` bigint(20) DEFAULT NULL COMMENT '冲抵关联的备用金单ID',
  `offset_amount` decimal(14,2) DEFAULT NULL COMMENT '冲抵金额',
  `remark` varchar(512) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '备注说明',
  `create_by` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '创建人',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_by` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '更新人',
  `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  `del_flag` tinyint(4) NOT NULL DEFAULT '0' COMMENT '删除标记：0-正常 1-已删除',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `uk_apply_code` (`apply_code`) USING BTREE,
  KEY `idx_applicant_id` (`applicant_id`) USING BTREE,
  KEY `idx_status` (`status`) USING BTREE,
  KEY `idx_expense_id` (`expense_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='报销申请单';

-- ----------------------------
-- Records of bx_reimburse_apply
-- ----------------------------
BEGIN;
INSERT INTO `bx_reimburse_apply` (`id`, `apply_code`, `title`, `applicant_id`, `applicant_name`, `expense_id`, `expense_name`, `amount`, `invoice_count`, `attach_count`, `status`, `current_node`, `wf_id`, `pay_status`, `pay_time`, `pay_user_id`, `pay_user_name`, `actual_amount`, `offset_advance_id`, `offset_amount`, `remark`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (20, 'BX20260505001', '吴九华报销单20260505001', 16, '吴九华', 29, '办公用品', 954.00, 0, 0, 'pending', '财务复核对', 2, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2026-05-05 21:31:20', '16', '2026-05-05 21:31:22', 0);
COMMIT;

-- ----------------------------
-- Table structure for bx_reimburse_approval
-- ----------------------------
DROP TABLE IF EXISTS `bx_reimburse_approval`;
CREATE TABLE `bx_reimburse_approval` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `apply_id` bigint(20) NOT NULL COMMENT '报销申请单ID',
  `node_order` int(11) NOT NULL COMMENT '节点顺序',
  `node_name` varchar(128) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '节点名称',
  `approver_id` bigint(20) NOT NULL COMMENT '审批人用户ID',
  `approver_name` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '审批人姓名',
  `approval_status` varchar(32) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '审批结果：approved-通过 rejected-驳回',
  `approval_opinion` varchar(1024) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '审批意见',
  `approval_time` datetime NOT NULL COMMENT '审批时间',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `idx_apply_id` (`apply_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=30 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='报销审批记录表';

-- ----------------------------
-- Records of bx_reimburse_approval
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for bx_reimburse_detail
-- ----------------------------
DROP TABLE IF EXISTS `bx_reimburse_detail`;
CREATE TABLE `bx_reimburse_detail` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `reimburse_id` bigint(20) NOT NULL COMMENT '报销单ID',
  `expense_id` bigint(20) NOT NULL COMMENT '费用项目ID',
  `expense_name` varchar(128) NOT NULL COMMENT '费用项目名称',
  `amount` decimal(14,2) NOT NULL COMMENT '报销金额',
  `remark` varchar(512) DEFAULT NULL COMMENT '备注',
  `del_flag` smallint(6) NOT NULL DEFAULT '0',
  `create_by` varchar(64) DEFAULT NULL,
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `update_by` varchar(64) DEFAULT NULL,
  `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`) USING BTREE,
  KEY `idx_reimburse_id` (`reimburse_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=37 DEFAULT CHARSET=utf8mb4 COMMENT='报销明细';

-- ----------------------------
-- Records of bx_reimburse_detail
-- ----------------------------
BEGIN;
INSERT INTO `bx_reimburse_detail` (`id`, `reimburse_id`, `expense_id`, `expense_name`, `amount`, `remark`, `del_flag`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (35, 20, 29, '办公用品', 599.00, '办公室采购', 0, '16', '2026-05-05 21:31:20', NULL, '2026-05-05 21:31:20');
INSERT INTO `bx_reimburse_detail` (`id`, `reimburse_id`, `expense_id`, `expense_name`, `amount`, `remark`, `del_flag`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (36, 20, 29, '办公用品', 355.00, '销售采购需求', 0, '16', '2026-05-05 21:31:20', NULL, '2026-05-05 21:31:20');
COMMIT;

-- ----------------------------
-- Table structure for bx_reimburse_offset
-- ----------------------------
DROP TABLE IF EXISTS `bx_reimburse_offset`;
CREATE TABLE `bx_reimburse_offset` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `reimburse_id` bigint(20) NOT NULL COMMENT '报销申请单ID',
  `advance_id` bigint(20) NOT NULL COMMENT '备用金申请单ID',
  `offset_amount` decimal(14,2) NOT NULL COMMENT '冲抵金额',
  `remark` varchar(512) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '备注',
  `create_by` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '创建人',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `idx_reimburse_id` (`reimburse_id`) USING BTREE,
  KEY `idx_advance_id` (`advance_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='报销单-备用金冲抵关联表';

-- ----------------------------
-- Records of bx_reimburse_offset
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for bx_role
-- ----------------------------
DROP TABLE IF EXISTS `bx_role`;
CREATE TABLE `bx_role` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `role_name` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '角色名称',
  `role_code` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '角色编码（如 ADMIN、FINANCE、EMPLOYEE）',
  `sort_order` int(11) NOT NULL DEFAULT '0' COMMENT '排序号',
  `status` tinyint(4) NOT NULL DEFAULT '1' COMMENT '状态：1-启用 0-禁用',
  `remark` varchar(512) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '备注',
  `create_by` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '创建人',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_by` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '更新人',
  `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  `del_flag` tinyint(4) NOT NULL DEFAULT '0' COMMENT '删除标记：0-正常 1-已删除',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `uk_role_code` (`role_code`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='角色表';

-- ----------------------------
-- Records of bx_role
-- ----------------------------
BEGIN;
INSERT INTO `bx_role` (`id`, `role_name`, `role_code`, `sort_order`, `status`, `remark`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (1, '管理员', 'ADMIN', 1, 1, '系统管理员，拥有全部权限', NULL, '2026-04-26 11:33:02', NULL, '2026-04-26 11:33:02', 0);
INSERT INTO `bx_role` (`id`, `role_name`, `role_code`, `sort_order`, `status`, `remark`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (2, '员工', 'EMPLOYEE', 2, 1, '普通员工，可发起申请', NULL, '2026-04-26 11:33:02', NULL, '2026-04-26 11:33:02', 0);
INSERT INTO `bx_role` (`id`, `role_name`, `role_code`, `sort_order`, `status`, `remark`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (3, '财务人员', 'FINANCE', 3, 1, '负责发放、冲抵等财务操作', NULL, '2026-04-26 11:33:02', NULL, '2026-04-26 11:33:02', 0);
INSERT INTO `bx_role` (`id`, `role_name`, `role_code`, `sort_order`, `status`, `remark`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (4, '总经理', 'GENERAL_MANAGER', 4, 1, '查看全部申请单', NULL, '2026-04-26 11:33:02', NULL, '2026-04-26 11:33:02', 0);
COMMIT;

-- ----------------------------
-- Table structure for bx_role_user
-- ----------------------------
DROP TABLE IF EXISTS `bx_role_user`;
CREATE TABLE `bx_role_user` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `role_id` bigint(20) NOT NULL COMMENT '角色ID',
  `user_id` bigint(20) NOT NULL COMMENT '用户ID',
  `create_by` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '创建人',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `uk_role_user` (`role_id`,`user_id`) USING BTREE,
  KEY `idx_user_id` (`user_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=41 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='角色-用户关联表';

-- ----------------------------
-- Records of bx_role_user
-- ----------------------------
BEGIN;
INSERT INTO `bx_role_user` (`id`, `role_id`, `user_id`, `create_by`, `create_time`) VALUES (1, 1, 1, NULL, '2026-04-26 11:33:03');
INSERT INTO `bx_role_user` (`id`, `role_id`, `user_id`, `create_by`, `create_time`) VALUES (40, 4, 16, NULL, '2026-05-05 12:07:05');
COMMIT;

-- ----------------------------
-- Table structure for bx_user
-- ----------------------------
DROP TABLE IF EXISTS `bx_user`;
CREATE TABLE `bx_user` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `username` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '用户名（登录账号）',
  `password` varchar(128) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '密码（加密存储）',
  `real_name` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '真实姓名',
  `phone` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '手机号',
  `email` varchar(128) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '邮箱',
  `avatar` varchar(256) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '头像URL',
  `status` tinyint(4) NOT NULL DEFAULT '1' COMMENT '状态：1-启用 0-禁用',
  `remark` varchar(512) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '备注',
  `create_by` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '创建人',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_by` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '更新人',
  `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  `del_flag` tinyint(4) NOT NULL DEFAULT '0' COMMENT '删除标记：0-正常 1-已删除',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `uk_username` (`username`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='用户表';

-- ----------------------------
-- Records of bx_user
-- ----------------------------
BEGIN;
INSERT INTO `bx_user` (`id`, `username`, `password`, `real_name`, `phone`, `email`, `avatar`, `status`, `remark`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (1, 'admin', '$2b$12$TE8Q3uWVxohmG3aFbTdJMeeaPkAua0lNt7zHsIB7qdwBfSYFvDLsG', '系统管理员', '13877662211', 'wuzilong@1q.com', NULL, 1, NULL, NULL, '2026-04-26 11:33:03', NULL, '2026-04-28 07:58:12', 0);
INSERT INTO `bx_user` (`id`, `username`, `password`, `real_name`, `phone`, `email`, `avatar`, `status`, `remark`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (16, 'jiuhua', '$2b$12$ddWh4WqYFXjNf/gIjMY9yOeL2igCMsg4ZJbQdaSeTPox6wTeQEHEa', '吴九华', '13305560059', '', NULL, 1, NULL, NULL, '2026-05-05 12:07:05', NULL, '2026-05-05 12:07:21', 0);
INSERT INTO `bx_user` (`id`, `username`, `password`, `real_name`, `phone`, `email`, `avatar`, `status`, `remark`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (17, 'wangxuan2026', '$2b$12$AJ0xLIwt2ZoMcSokFCW6AOusHxPNYVwy2Zs1MRp4dC4CXEIk012/i', '汪璇', '', '', NULL, 1, NULL, NULL, '2026-05-05 12:07:56', NULL, '2026-05-05 12:07:56', 0);
INSERT INTO `bx_user` (`id`, `username`, `password`, `real_name`, `phone`, `email`, `avatar`, `status`, `remark`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (18, 'liumaosheng', '$2b$12$x/onNzrkaZKfyXSd1/tEdOnScVkmnOCeW2.9bSrw3mp76vObwF59W', '刘茂生', '', '', NULL, 1, NULL, NULL, '2026-05-05 12:08:26', NULL, '2026-05-05 12:08:26', 0);
COMMIT;

-- ----------------------------
-- Table structure for bx_workflow_def
-- ----------------------------
DROP TABLE IF EXISTS `bx_workflow_def`;
CREATE TABLE `bx_workflow_def` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `biz_type` varchar(32) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '业务类型：advance-备用金 reimburse-报销单',
  `wf_name` varchar(128) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '工作流名称',
  `status` tinyint(4) NOT NULL DEFAULT '1' COMMENT '状态：1-启用 0-禁用',
  `remark` varchar(512) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '备注',
  `create_by` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '创建人',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_by` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '更新人',
  `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  `del_flag` tinyint(4) NOT NULL DEFAULT '0' COMMENT '删除标记：0-正常 1-已删除',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `idx_biz_type` (`biz_type`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='工作流定义表';

-- ----------------------------
-- Records of bx_workflow_def
-- ----------------------------
BEGIN;
INSERT INTO `bx_workflow_def` (`id`, `biz_type`, `wf_name`, `status`, `remark`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (1, 'advance', '备用金审批流程', 1, '备用金申请默认审批流程', NULL, '2026-04-26 11:33:03', NULL, '2026-04-26 11:33:03', 0);
INSERT INTO `bx_workflow_def` (`id`, `biz_type`, `wf_name`, `status`, `remark`, `create_by`, `create_time`, `update_by`, `update_time`, `del_flag`) VALUES (2, 'reimburse', '报销单审批流程', 1, '报销申请默认审批流程', NULL, '2026-04-26 11:33:03', NULL, '2026-04-26 11:33:03', 0);
COMMIT;

-- ----------------------------
-- Table structure for bx_workflow_node
-- ----------------------------
DROP TABLE IF EXISTS `bx_workflow_node`;
CREATE TABLE `bx_workflow_node` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `wf_id` bigint(20) NOT NULL COMMENT '工作流定义ID',
  `node_name` varchar(128) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '节点名称（如：主管审批、财务复核）',
  `node_order` int(11) NOT NULL DEFAULT '0' COMMENT '节点顺序（从小到大执行）',
  `approver_id` bigint(20) DEFAULT NULL COMMENT '审批人用户ID',
  `approver_name` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '审批人姓名（冗余）',
  `create_by` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '创建人',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_by` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '更新人',
  `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `idx_wf_id` (`wf_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=90 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='工作流节点表';

-- ----------------------------
-- Records of bx_workflow_node
-- ----------------------------
BEGIN;
INSERT INTO `bx_workflow_node` (`id`, `wf_id`, `node_name`, `node_order`, `approver_id`, `approver_name`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (84, 1, '总经理审批', 1, 16, '吴九华', NULL, '2026-05-05 12:13:17', NULL, '2026-05-05 12:13:17');
INSERT INTO `bx_workflow_node` (`id`, `wf_id`, `node_name`, `node_order`, `approver_id`, `approver_name`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (85, 1, '财务', 2, 17, '汪璇', NULL, '2026-05-05 12:13:17', NULL, '2026-05-05 12:13:17');
INSERT INTO `bx_workflow_node` (`id`, `wf_id`, `node_name`, `node_order`, `approver_id`, `approver_name`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (88, 2, '财务复核对', 1, 17, '汪璇', NULL, '2026-05-05 12:13:32', NULL, '2026-05-05 12:13:32');
INSERT INTO `bx_workflow_node` (`id`, `wf_id`, `node_name`, `node_order`, `approver_id`, `approver_name`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (89, 2, '总经理审批', 2, 16, '吴九华', NULL, '2026-05-05 12:13:32', NULL, '2026-05-05 12:13:32');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;