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. |