用户权限与角色设计

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.