Java Privilege System Design Chapter

database table Design

1.1.1. Module management (Jk_module)

Item	Type	Description
Id	Long	is database record IDX number
Name	String	Module name
OrderID	Int	Sort ID from small to large display
Deleted	Int	Default 0 (0 normal 1 delete state)

1.1.2. Module function Management (JK_MODULE_FUN)

Item	Type	Description
Id	Long	is database record IDX number
ModuleID	Long	Owning module
Name	String	Feature name
URLs	String	Feature URL Collection
OrderID	Int	Sort ID from small to large display
Deleted	Int	Default 0 (0 normal 1 delete state)

1.1.3. Role Management (Jk_role)

Item	Type	Description
Id	Long	is database record IDX number
Name	String	Role name
OrderID	Int	Sort ID from small to large display
Deleted	Int	Default 0 (0 normal 1 delete state)

1.1.4. Role Function Intermediate table (Jk_role_fun)

Item	Type	Description
Roleid	Long	Role ID
Funid	Long	Feature ID

1.1.5. Users (Jk_user)

Item	Type	Description
Id	Long	is database record IDX number
Account	String	Account
Realname	String	real name
Pwd	String	Password
Address	String	Regional
Sex	Int	Sex (0 men and 1 women)
Msn	String	Msn
Phone	String	Fixed telephone
Telnum	String	Cell phone
Qq	String	QQ number
Email	String	Mailbox
Display	Int	Enabled (0 enable 1 disabled)

1.1.6. User Role Intermediate table (Jk_user_role)

Item	Type	Description
Roleid	Long	Character ID
Userid	Long	User ID

Java Privilege System design article