数据库实体关系图:部门、角色、用户、菜单、数据源、项目和分析
以下是一个示例数据库实体关系图的文本表示:
+-----------------+
| Department |
+-----------------+
| DepartmentID |
| DepartmentName |
+-----------------+
|
|
|
|
|
|
+-------+--------+
| SystemRole |
+----------------+
| RoleID |
| RoleName |
+----------------+
|
|
|
|
|
|
+-------+--------+
| RolePermission |
+----------------+
| RoleID |
| PermissionID |
+----------------+
|
|
|
|
|
|
+-------+--------+
| SystemUser |
+----------------+
| UserID |
| UserName |
| Password |
| DepartmentID |
| RoleID |
+----------------+
|
|
|
|
|
|
+-------+--------+
| Menu |
+----------------+
| MenuID |
| MenuName |
| MenuURL |
+----------------+
|
|
|
|
|
|
+-------+--------+
| DataSource |
+----------------+
| DataSourceID |
| DataSourceName |
| DataSourceType |
+----------------+
|
|
|
|
|
|
+-------+--------+
| DashboardProject |
+-----------------+
| ProjectID |
| ProjectName |
| ProjectDescription |
+-----------------+
|
|
|
|
|
|
+-------+--------+
| ETLProject |
+-----------------+
| ProjectID |
| ProjectName |
| ProjectDescription |
+-----------------+
|
|
|
|
|
|
+-------+--------+
| AnalysisProject |
+-----------------+
| ProjectID |
| ProjectName |
| ProjectDescription |
+-----------------+
|
|
|
|
|
|
+-------+--------+
| AnalysisData |
+-----------------+
| DataID |
| DataName |
| DataType |
+-----------------+
|
|
|
|
|
|
+-------+--------+
| AnalysisMethod |
+-----------------+
| MethodID |
| MethodName |
| MethodDescription |
+-----------------+
您可以使用上述文本来创建数据库实体关系图。
原文地址: https://www.cveoy.top/t/topic/pM9q 著作权归作者所有。请勿转载和采集!