用户权限与角色设计
User and Rol Matance e Data Design
| Table Name | UserRole relations of user and role | |||
| Column | note | DataType | IsNull | Key |
| id | Auto | int | NOT NULL | PRIMARYKEY |
| userGroupId |
| Int | NOT NULL | not |
| roleGradeId |
| int | NOT NULL | Not |
| addition | no | |||
| Table Name | UserGroup | |||
| Column | note | DataType | IsNull | Key |
| id | Auto | int | NOT NULL | PRIMARYKEY |
| name |
| Nvarchar(50) | NOT NULL | not |
|
|
|
|
|
|
| addition | no | |||
| Table Name | Userinfo | |||
| Column | note | DataType | IsNull | Key |
| id | Auto | int | NOT NULL | PRIMARYKEY |
| name |
| Nvarchar(50) | NOT NULL | not |
| password |
| Nvarchar(50) | NOT NULL | Not |
| guid |
| Nvarchar(50) | NOT NULL | Not |
| userGroupID |
| int | NOT NULL | Not |
| addition | Now one user can in one usergroup only. | |||
| Table Name | RoleGrade | |||
| Column | note | DataType | IsNull | Key |
| id | Auto | int | NOT NULL | PRIMARYKEY |
| name |
| Nvarchar(50) | NOT NULL | not |
| addition | no | |||
| Table Name | RoleInfo | |||
| Column | note | DataType | IsNull | Key |
| id | Auto | int | NOT NULL | PRIMARYKEY |
| roleId |
| int | Not null | not |
| name |
| Nvarchar(50) | NOT NULL | not |
| RoleGradeID |
| int | NOT NULL | Not |
| pageId |
| int | NOT NULL | Not |
| isRead |
| bool | NOT NULL | Not |
| isAdd |
| bool | NOT NULL | Not |
| isDel |
| bool | NOT NULL | Not |
| isUpdate |
| bool | NOT NULL | Not |
| isLock |
| bool | NOT NULL | Not |
| addition | Roleid maybe repeat. | |||
