我的博客项目架构关系详解

graph TD subgraph 用户管理模块["用户管理模块"] SysUser[用户 SysUser] SysRole[角色 SysRole] SysPermission[权限 SysPermission] SysPermissionGroup[权限组 SysPermissionGroup] SysUserRole[(用户角色关联)] SysRolePermission[(角色权限关联)] SysRolePermissionGroup[(角色权限组关联)] SysPermissionGroupItem[(权限组项关联)] end subgraph 博客模块["博客模块"] SysBlog[博客文章 SysBlog] SysCategory[分类 SysCategory] SysComment[评论 SysComment] SysOssImage[OSS图片 SysOssImage] end subgraph 配置模块["配置模块"] SysConfig[系统配置 SysConfig] SysSeo[SEO配置 SysSeo 已禁用] SysFriendLink[友情链接 SysFriendLink] end %% 用户管理内部关系 SysUser -->|拥有| SysUserRole SysRole -->|分配给| SysUserRole SysRole -->|拥有| SysRolePermission SysPermission -->|被分配| SysRolePermission SysRole -->|拥有| SysRolePermissionGroup SysPermissionGroup -->|被分配| SysRolePermissionGroup SysPermission -->|属于| SysPermissionGroupItem SysPermissionGroup -->|包含| SysPermissionGroupItem %% 博客模块内部关系 SysCategory -->|包含| SysBlog SysBlog -->|拥有| SysComment SysComment -->|回复| SysComment %% 跨模块关系 SysUser -->|作者| SysBlog SysUser -->|评论者| SysComment SysUser -->|上传者| SysOssImage

erDiagram %% 实体定义 - 用户管理 SysUser { bigint id PK "主键" varchar username UK "用户名" varchar nickname "昵称" varchar password "密码" varchar email UK "邮箱" varchar avatar_url "头像URL" tinyint status "状态" tinyint is_deleted "删除标记" datetime create_time "创建时间" datetime update_time "更新时间" } SysRole { bigint id PK varchar code UK varchar name varchar description tinyint is_super_admin tinyint is_system tinyint is_deleted int sort_order tinyint status datetime create_time datetime update_time } SysPermission { bigint id PK varchar code UK varchar name varchar description int sort_order datetime create_time } SysPermissionGroup { bigint id PK varchar name varchar description int sort_order tinyint status tinyint is_system tinyint is_deleted datetime create_time datetime update_time } %% 关联表 SysUserRole { bigint id PK bigint user_id FK bigint role_id FK datetime create_time } SysRolePermission { bigint id PK bigint role_id FK bigint permission_id FK datetime create_time } SysRolePermissionGroup { bigint id PK bigint role_id FK bigint group_id FK datetime create_time } SysPermissionGroupItem { bigint id PK bigint group_id FK bigint permission_id FK int sort_order datetime create_time } %% 实体定义 - 博客模块 SysBlog { bigint id PK bigint category_id FK varchar title varchar summary longtext content_md varchar cover_image varchar tags bigint author_id FK int comment_count tinyint is_hidden tinyint is_top tinyint is_recommend tinyint is_deleted datetime create_time datetime update_time } SysCategory { bigint id PK varchar name varchar description int sort_order datetime create_time tinyint is_hidden datetime update_time } SysComment { bigint id PK bigint blog_id FK bigint parent_id FK bigint user_id FK varchar username varchar email varchar avatar_url varchar website text content tinyint status int like_count varchar device_info varchar ip_address tinyint is_admin tinyint is_deleted datetime create_time datetime update_time } SysOssImage { bigint id PK varchar hash varchar original_name varchar object_name bigint file_size bigint user_id FK datetime create_time } %% 实体定义 - 配置模块 SysFriendLink { bigint id PK varchar name varchar url varchar summary varchar remark varchar image_url int sort_order tinyint status tinyint is_deleted datetime create_time datetime update_time } SysSeo { bigint id PK varchar page_type bigint page_id varchar title varchar keywords varchar description varchar og_title varchar og_description varchar og_image varchar og_type varchar canonical_url varchar robots tinyint is_deleted tinyint is_system datetime create_time datetime update_time } SysConfig { bigint id PK varchar config_key varchar config_value varchar data_type varchar validation_rule varchar description tinyint is_system tinyint is_open tinyint is_deleted datetime create_time datetime update_time } %% 关系定义 SysUser ||--o{ SysUserRole : "拥有" SysRole ||--o{ SysUserRole : "分配给" SysRole ||--o{ SysRolePermission : "拥有" SysPermission ||--o{ SysRolePermission : "被分配" SysRole ||--o{ SysRolePermissionGroup : "拥有" SysPermissionGroup ||--o{ SysRolePermissionGroup : "被分配" SysPermission ||--o{ SysPermissionGroupItem : "属于" SysPermissionGroup ||--o{ SysPermissionGroupItem : "包含" SysUser ||--o{ SysBlog : "发布" SysCategory ||--o{ SysBlog : "分类" SysBlog ||--o{ SysComment : "包含" SysUser ||--o{ SysComment : "发表" SysComment ||--o{ SysComment : "回复" SysUser ||--o{ SysOssImage : "上传"

flowchart LR A[用户登录] --> B{验证权限} B -->|通过| C[访问资源] B -->|拒绝| D[返回错误] subgraph 权限验证流程 B --> E[检查用户角色] E --> F[检查角色权限] F --> G[检查权限组] end subgraph 内容发布流程 H[创建文章] --> I[选择分类] I --> J[上传图片] J --> K[保存文章] end subgraph 评论流程 L[发表评论] --> M[审核状态] M -->|通过| N[显示评论] M -->|拒绝| O[隐藏评论] end