Javaweb Layui RBAC 项目 小金库

# 小金库 ### 数据库设计  #### 创建数据库 ``` DROP DATABASE IF EXISTS `xiaojinku`; CREATE DATABASE `xiaojinku` DEFAULT CHARACTER SET utf8 ; USE `xiaojinku`; select database(); ``` #### 创建收入表 ```mysql DROP TABLE IF EXISTS `tb_income`; CREATE TABLE `tb_income` ( `in_id` bigint UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '收入编号', `in_title` varchar(45) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '标题', `in_money` decimal(10, 2) NULL DEFAULT NULL COMMENT '收入金额', `in_mode` int UNSIGNED NULL DEFAULT NULL COMMENT '收款方式', `remark` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注', `u_id` bigint UNSIGNED NULL DEFAULT NULL COMMENT '用户ID', `create_time` timestamp NULL DEFAULT NULL COMMENT '创建时间', `modified_time` timestamp NULL DEFAULT NULL COMMENT '修改时间', `create_account_id` bigint UNSIGNED NULL DEFAULT NULL COMMENT '创建人ID', `modified_account_id` bigint UNSIGNED NULL DEFAULT NULL COMMENT '修改人ID', `deleted` tinyint UNSIGNED NULL DEFAULT NULL COMMENT '逻辑删除标识(0、否 1、是)', PRIMARY KEY (`in_id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; ``` #### 创建支出表 ```mysql DROP TABLE IF EXISTS `tb_paid`; CREATE TABLE `tb_paid` ( `pay_id` int(0) UNSIGNED NOT NULL AUTO_INCREMENT, `pay_title` varchar(45) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '标题', `pay_money` decimal(10, 2) NULL DEFAULT NULL COMMENT '支出金额', `pay_mode` int(0) UNSIGNED NULL DEFAULT NULL COMMENT '支付方式', `remark` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注', `u_id` bigint(0) UNSIGNED NULL DEFAULT NULL COMMENT '用户ID', `create_time` timestamp(0) NULL DEFAULT NULL COMMENT '创建时间', `modified_time` timestamp(0) NULL DEFAULT NULL COMMENT '修改时间', `create_account_id` bigint(0) UNSIGNED NULL DEFAULT NULL COMMENT '创建人ID', `modified_account_id` bigint(0) UNSIGNED NULL DEFAULT NULL COMMENT '修改人ID', `deleted` tinyint(0) UNSIGNED NULL DEFAULT NULL COMMENT '逻辑删除标识(0、否 1、是)', PRIMARY KEY (`pay_id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; ``` #### 创建收支方式表 ```mysql DROP TABLE IF EXISTS `tb_mode`; CREATE TABLE `tb_mode` ( `mode_id` bigint UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '收支方式ID', `mode_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '收支方式名称', PRIMARY KEY (`mode_id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; ``` #### 创建资源表 ```mysql DROP TABLE IF EXISTS `tb_resource`; CREATE TABLE `tb_resource` ( `resouce_id` bigint UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '资源ID', `parent_id` bigint UNSIGNED NULL DEFAULT NULL COMMENT '父ID', `title` varchar(15) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '菜单名称', `icon` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '菜单图标', `href` varchar(45) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '链接', `target` varchar(45) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '_self' COMMENT '链接打开方式', `sort` int UNSIGNED NULL DEFAULT NULL COMMENT '菜单排序', `status` int NULL DEFAULT 1 COMMENT '状态(0:禁用,1:启用)', `remark` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注信息', `create_time` timestamp NULL DEFAULT NULL COMMENT '创建时间', `modified_time` timestamp NULL DEFAULT NULL COMMENT '修改时间', `create_account_id` bigint UNSIGNED NULL DEFAULT NULL COMMENT '创建人ID', `modified_account_id` bigint UNSIGNED NULL DEFAULT NULL COMMENT '修改人ID', `deleted` tinyint UNSIGNED NULL DEFAULT NULL COMMENT '逻辑删除标识(0、否 1、是)', PRIMARY KEY (`resouce_id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; ``` #### 创建角色表 ```mysql DROP TABLE IF EXISTS `tb_role`; CREATE TABLE `tb_role` ( `role_id` bigint UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '角色ID', `role_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '角色名称', `remark` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '备注', `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间', `modified_time` datetime NULL DEFAULT NULL COMMENT '修改时间', `create_account_id` bigint UNSIGNED NULL DEFAULT NULL COMMENT '创建人', `modified_account_id` bigint UNSIGNED NULL DEFAULT NULL COMMENT '修改人', `deleted` tinyint UNSIGNED NULL DEFAULT 0 COMMENT '逻辑删除标识(0、否 1、是)', PRIMARY KEY (`role_id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; ``` #### 创建角色资源关联表 ```mysql DROP TABLE IF EXISTS `tb_role_resource`; CREATE TABLE `tb_role_resource` ( `role_id` bigint UNSIGNED NOT NULL COMMENT '角色id', `resource_id` bigint UNSIGNED NOT NULL COMMENT '资源id', PRIMARY KEY (`role_id`, `resource_id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; ``` #### 创建用户表 ```mysql DROP TABLE IF EXISTS `tb_user`; CREATE TABLE `tb_user` ( `u_id` bigint NOT NULL AUTO_INCREMENT COMMENT '用户编号', `u_account` varchar(45) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '用户账号', `u_password` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用户密码', `u_nickname` varchar(45) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用户昵称', `head_sculpture` varchar(45) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用户头像', `u_realname` varchar(45) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用户真实姓名', `u_id_card` varchar(18) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用户身份证号码', `u_mobile` varchar(11) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用户手机号', `role_id` bigint UNSIGNED NOT NULL DEFAULT 2 COMMENT '角色ID', `create_time` timestamp NULL DEFAULT NULL COMMENT '创建时间', `modified_time` timestamp NULL DEFAULT NULL COMMENT '修改时间', `create_account_id` bigint UNSIGNED NULL DEFAULT NULL COMMENT '创建人ID', `modified_account_id` bigint UNSIGNED NULL DEFAULT NULL COMMENT '修改人ID', `deleted` tinyint UNSIGNED NULL DEFAULT NULL COMMENT '逻辑删除标识(0、否 1、是)', PRIMARY KEY (`u_id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; ``` #### 插入数据 ##### 角色数据 ```mysql INSERT INTO `xiaojinku`.`tb_role` (`role_id`, `role_name`, `remark`, `create_time`, `modified_time`, `create_account_id`, `modified_account_id`, `deleted`) VALUES (1, '管理员', '管理员', '2019-03-15 16:51:37', '2019-03-15 16:51:37', 1, 1, 0); INSERT INTO `xiaojinku`.`tb_role` (`role_id`, `role_name`, `remark`, `create_time`, `modified_time`, `create_account_id`, `modified_account_id`, `deleted`) VALUES (2, '使用者', '普通用户', '2019-03-15 16:51:37', '2019-03-15 16:51:37', 1, 1, 0); ``` ##### 用户数据 ```mysql INSERT INTO `xiaojinku`.`tb_user` (`u_id`, `u_account`, `u_password`, `u_nickname`, `head_sculpture`, `u_realname`, `u_id_card`, `u_mobile`, `role_id`, `create_time`, `modified_time`,