数据库关系表
2017-11-16 19:45:40 287 举报PMS系统ER图
作者其他创作
大纲/内容
Music_PMS_UserRoleRelation
userName:varchar(256)roleCode:varchar(256)startTime:timestampendTime:timestamp
N:1
Music_PMS_RolePrivilegeRelation
privilegeCode:varchar(256)roleCode:varchar(256)
Music_PMS_Role
roleCod:varchar(256)roleName:varchar(256)roleDesc:varchar(1024)
1:N
1：N
Music_PMS_UserGroupRoleRelation
groupCode:varchar(256)roleCode:varchar(256)startTime:timestampendTime:timestamp
Music_PMS_Users
userName:varchar(128)nickName:varchar(256)hzNumber:varchar(128)
Music_PMS_Privilege
privilegeCode:varchar(256)privilegeName:varchar(256)privilegeDesc:varchar(1024)privilegeType:int(11)
Music_PMS_UserGroupRelation
userName:varchar(256)groupCode:varchar(256)
Music_PMS_OperationLog
userName:varchar(256)operateType:varchar(16)operateTable:varchar(128) operateTime:timestampcontent:varchar(1024)data:varcahr(2048)
Music_PMS_UserGroup
groupCode:varchar(256)groupName:varchar(256)groupDesc:varchar(1024)
0 条评论
下一页
