tb_user:用户帐户信息表 | |||
列名 | 数据类型 | 允许空 | 说明 |
UserName | nvarchar(128) | N | 用户ID |
Password | nvarchar(128) | N | 登录名,用户Email |
nvarchar(100) | Y | 密码 | |
Question | nvarchar(100) | Y | 重置密码的问题 |
Answer | nvarchar(100) | Y | 重置密码的答案 |
RoleID | int | N | 角色 |
UserGroup | int | N | 用户组 |
CreateTime | datetime | N | 帐户创建时间 |
LastLoginTime | datetime | Y | 上一次登录的时间 |
Status | int | N | 用户状态 |
IsOnline | bit | N | 是否在线 |
IsLimit | bit | N | 是否受权限限制,0为受限制 |
- /*20120611BYFMX用户表*/
- USE[SH_Cloud]
- GO
- SETANSI_NULLSON
- GO
- SETQUOTED_IDENTIFIERON
- GO
- CREATETABLE[dbo].[tb_User](
- [UserID][int]IDENTITY(1,1)NOTNULL,
- [UserName][nvarchar](128)COLLATEChinese_PRC_CI_ASNOTNULL,
- [Password][nvarchar](128)COLLATEChinese_PRC_CI_ASNOTNULL,
- [Email][nvarchar](100)COLLATEChinese_PRC_CI_ASNULL,
- [Question][nvarchar](100)COLLATEChinese_PRC_CI_ASNULL,
- [Answer][nvarchar](100)COLLATEChinese_PRC_CI_ASNULL,
- [RoleID][int]NOTNULLCONSTRAINT[DF_Users_RoleID]DEFAULT((0)),
- [UserGroup][int]NOTNULLCONSTRAINT[DF_Users_UserGroup]DEFAULT((0)),
- [CreateTime][datetime]NOTNULL,
- [LastLoginTime][datetime]NULL,
- [Status][int]NOTNULLCONSTRAINT[DF_Users_Status]DEFAULT((1)),
- [IsOnline][bit]NOTNULLCONSTRAINT[DF_Users_IsOnline]DEFAULT((0)),
- [IsLimit][bit]NOTNULLCONSTRAINT[DF_Users_IsLimit]DEFAULT((0)),
- CONSTRAINT[PK_User_ID]PRIMARYKEYCLUSTERED
- (
- [UserID]ASC
- )WITH(IGNORE_DUP_KEY=OFF)ON[PRIMARY]
- )ON[PRIMARY]
- GO
- EXECsys.sp_addextendedproperty@name=N'MS_Description',@value=N'用户ID',@level0type=N'SCHEMA',@level0name=N'dbo',@level1type=N'TABLE',@level1name=N'tb_User',@level2type=N'COLUMN',@level2name=N'UserID'
- GO
- EXECsys.sp_addextendedproperty@name=N'MS_Description',@value=N'登录名,用户Email',@level0type=N'SCHEMA',@level0name=N'dbo',@level1type=N'TABLE',@level1name=N'tb_User',@level2type=N'COLUMN',@level2name=N'UserName'
- GO
- EXECsys.sp_addextendedproperty@name=N'MS_Description',@value=N'密码',@level0type=N'SCHEMA',@level0name=N'dbo',@level1type=N'TABLE',@level1name=N'tb_User',@level2type=N'COLUMN',@level2name=N'Password'
- GO
- EXECsys.sp_addextendedproperty@name=N'MS_Description',@value=N'重置密码的问题',@level0type=N'SCHEMA',@level0name=N'dbo',@level1type=N'TABLE',@level1name=N'tb_User',@level2type=N'COLUMN',@level2name=N'Question'
- GO
- EXECsys.sp_addextendedproperty@name=N'MS_Description',@value=N'重置密码的答案',@level0type=N'SCHEMA',@level0name=N'dbo',@level1type=N'TABLE',@level1name=N'tb_User',@level2type=N'COLUMN',@level2name=N'Answer'
- GO
- EXECsys.sp_addextendedproperty@name=N'MS_Description',@value=N'角色',@level0type=N'SCHEMA',@level0name=N'dbo',@level1type=N'TABLE',@level1name=N'tb_User',@level2type=N'COLUMN',@level2name=N'RoleID'
- GO
- EXECsys.sp_addextendedproperty@name=N'MS_Description',@value=N'用户组',@level0type=N'SCHEMA',@level0name=N'dbo',@level1type=N'TABLE',@level1name=N'tb_User',@level2type=N'COLUMN',@level2name=N'UserGroup'
- GO
- EXECsys.sp_addextendedproperty@name=N'MS_Description',@value=N'帐户创建时间',@level0type=N'SCHEMA',@level0name=N'dbo',@level1type=N'TABLE',@level1name=N'tb_User',@level2type=N'COLUMN',@level2name=N'CreateTime'
- GO
- EXECsys.sp_addextendedproperty@name=N'MS_Description',@value=N'上一次登录的时间',@level0type=N'SCHEMA',@level0name=N'dbo',@level1type=N'TABLE',@level1name=N'tb_User',@level2type=N'COLUMN',@level2name=N'LastLoginTime'
- GO
- EXECsys.sp_addextendedproperty@name=N'MS_Description',@value=N'用户状态',@level0type=N'SCHEMA',@level0name=N'dbo',@level1type=N'TABLE',@level1name=N'tb_User',@level2type=N'COLUMN',@level2name=N'Status'
- GO
- EXECsys.sp_addextendedproperty@name=N'MS_Description',@value=N'是否在线',@level0type=N'SCHEMA',@level0name=N'dbo',@level1type=N'TABLE',@level1name=N'tb_User',@level2type=N'COLUMN',@level2name=N'IsOnline'
- GO
- EXECsys.sp_addextendedproperty@name=N'MS_Description',@value=N'是否受权限限制,0为受限制',@level0type=N'SCHEMA',@level0name=N'dbo',@level1type=N'TABLE',@level1name=N'tb_User',@level2type=N'COLUMN',@level2name=N'IsLimit'
- GO
- EXECsys.sp_addextendedproperty@name=N'MS_Description',@value=N'用户帐户信息表',@level0type=N'SCHEMA',@level0name=N'dbo',@level1type=N'TABLE',@level1name=N'tb_User'
tb_Role:角色信息表 | |||
列名 | 数据类型 | 允许空 | 说明 |
RoleID | int | N | 角色ID |
RoleGroupID | int | N | 分组ID |
RoleName | nvarchar(30) | N | 角色名称 |
RoleDescription | nvarchar(50) | Y | 说明 |
RoleOrder | int | N | 排序 |
- /*20120611BYFMX*/
- USE[SH_Cloud]
- GO
- SETANSI_NULLSON
- GO
- SETQUOTED_IDENTIFIERON
- GO
- CREATETABLE[dbo].[tb_Role](
- [RoleID][int]IDENTITY(1,1)NOTNULL,
- [RoleGroupID][int]NOTNULL,
- [RoleName][nvarchar](30)COLLATEChinese_PRC_CI_ASNOTNULL,
- [RoleDescription][nvarchar](50)COLLATEChinese_PRC_CI_ASNULL,
- [RoleOrder][int]NOTNULLCONSTRAINT[DF_tb_Role_RoleOrder]DEFAULT((0)),
- CONSTRAINT[PK_tb_Role_1]PRIMARYKEYCLUSTERED
- (
- [RoleID]ASC
- )WITH(IGNORE_DUP_KEY=OFF)ON[PRIMARY]
- )ON[PRIMARY]
- GO
- EXECsys.sp_addextendedproperty@name=N'MS_Description',@value=N'角色ID',@level0type=N'SCHEMA',@level0name=N'dbo',@level1type=N'TABLE',@level1name=N'tb_Role',@level2type=N'COLUMN',@level2name=N'RoleID'
- GO
- EXECsys.sp_addextendedproperty@name=N'MS_Description',@value=N'分组ID',@level0type=N'SCHEMA',@level0name=N'dbo',@level1type=N'TABLE',@level1name=N'tb_Role',@level2type=N'COLUMN',@level2name=N'RoleGroupID'
- GO
- EXECsys.sp_addextendedproperty@name=N'MS_Description',@value=N'角色名称',@level0type=N'SCHEMA',@level0name=N'dbo',@level1type=N'TABLE',@level1name=N'tb_Role',@level2type=N'COLUMN',@level2name=N'RoleName'
- GO
- EXECsys.sp_addextendedproperty@name=N'MS_Description',@value=N'说明',@level0type=N'SCHEMA',@level0name=N'dbo',@level1type=N'TABLE',@level1name=N'tb_Role',@level2type=N'COLUMN',@level2name=N'RoleDescription'
tb_Action:权限信息表 | |||
列名 | 数据类型 | 允许空 | 说明 |
ActionID | int | N | 权限ID |
ActionName | nvarchar(30) | N | 权限名称 |
ActionTag | nvarchar(50) | N | 权限标识 |
ActionDescription | nvarchar(50) | Y | 说明 |
ActionOrder | int | N | 排序 |
- /*20120611BYFMX权限表*/
- USE[SH_Cloud]
- GO
- SETANSI_NULLSON
- GO
- SETQUOTED_IDENTIFIERON
- GO
- CREATETABLE[dbo].[tb_Action](
- [ActionID][int]IDENTITY(1,1)NOTNULL,
- [ActionName][nvarchar](30)COLLATEChinese_PRC_CI_ASNOTNULL,
- [ActionTag][nvarchar](50)COLLATEChinese_PRC_CI_ASNOTNULL,
- [ActionDescription][nvarchar](50)COLLATEChinese_PRC_CI_ASNULL,
- [ActionOrder][int]NOTNULLCONSTRAINT[DF_ActionDir_ActionOrder]DEFAULT((0)),
- CONSTRAINT[PK_tb_Action_1]PRIMARYKEYCLUSTERED
- (
- [ActionID]ASC
- )WITH(IGNORE_DUP_KEY=OFF)ON[PRIMARY]
- )ON[PRIMARY]
- GO
- EXECsys.sp_addextendedproperty@name=N'MS_Description',@value=N'权限ID',@level0type=N'SCHEMA',@level0name=N'dbo',@level1type=N'TABLE',@level1name=N'tb_Action',@level2type=N'COLUMN',@level2name=N'ActionID'
- GO
- EXECsys.sp_addextendedproperty@name=N'MS_Description',@value=N'权限名称',@level0type=N'SCHEMA',@level0name=N'dbo',@level1type=N'TABLE',@level1name=N'tb_Action',@level2type=N'COLUMN',@level2name=N'ActionName'
- GO
- EXECsys.sp_addextendedproperty@name=N'MS_Description',@value=N'权限标识',@level0type=N'SCHEMA',@level0name=N'dbo',@level1type=N'TABLE',@level1name=N'tb_Action',@level2type=N'COLUMN',@level2name=N'ActionTag'
- GO
- EXECsys.sp_addextendedproperty@name=N'MS_Description',@value=N'说明',@level0type=N'SCHEMA',@level0name=N'dbo',@level1type=N'TABLE',@level1name=N'tb_Action',@level2type=N'COLUMN',@level2name=N'ActionDescription'
- GO
- EXECsys.sp_addextendedproperty@name=N'MS_Description',@value=N'排序',@level0type=N'SCHEMA',@level0name=N'dbo',@level1type=N'TABLE',@level1name=N'tb_Action',@level2type=N'COLUMN',@level2name=N'ActionOrder'
tb_Group:分组信息表 | |||
列名 | 数据类型 | 允许空 | 说明 |
GroupID | int | N | 分组ID |
GroupName | nvarchar(30) | N | 组名称 |
GroupOrder | int | N | 排序 |
GroupDescription | nvarchar(50) | Y | 说明 |
GroupType | int | N | 分组类型 用户组0,角色组1 |
- /*20120611BYFMX分组表*/
- USE[SH_Cloud]
- GO
- SETANSI_NULLSON
- GO
- SETQUOTED_IDENTIFIERON
- GO
- CREATETABLE[dbo].[tb_Group](
- [GroupID][int]IDENTITY(1,1)NOTNULL,
- [GroupName][nvarchar](30)COLLATEChinese_PRC_CI_ASNOTNULL,
- [GroupOrder][int]NOTNULLCONSTRAINT[DF_RGP_UserGroup_UserGroupOrder]DEFAULT((0)),
- [GroupDescription][nvarchar](50)COLLATEChinese_PRC_CI_ASNULL,
- [GroupType][int]NOTNULLCONSTRAINT[DF_tb_Group_GroupType]DEFAULT((0)),
- CONSTRAINT[PK_tb_Group]PRIMARYKEYCLUSTERED
- (
- [GroupID]ASC
- )WITH(IGNORE_DUP_KEY=OFF)ON[PRIMARY]
- )ON[PRIMARY]
- GO
- EXECsys.sp_addextendedproperty@name=N'MS_Description',@value=N'分组ID',@level0type=N'SCHEMA',@level0name=N'dbo',@level1type=N'TABLE',@level1name=N'tb_Group',@level2type=N'COLUMN',@level2name=N'GroupID'
- GO
- EXECsys.sp_addextendedproperty@name=N'MS_Description',@value=N'组名称',@level0type=N'SCHEMA',@level0name=N'dbo',@level1type=N'TABLE',@level1name=N'tb_Group',@level2type=N'COLUMN',@level2name=N'GroupName'
- GO
- EXECsys.sp_addextendedproperty@name=N'MS_Description',@value=N'排序',@level0type=N'SCHEMA',@level0name=N'dbo',@level1type=N'TABLE',@level1name=N'tb_Group',@level2type=N'COLUMN',@level2name=N'GroupOrder'
- GO
- EXECsys.sp_addextendedproperty@name=N'MS_Description',@value=N'说明',@level0type=N'SCHEMA',@level0name=N'dbo',@level1type=N'TABLE',@level1name=N'tb_Group',@level2type=N'COLUMN',@level2name=N'GroupDescription'
- GO
- EXECsys.sp_addextendedproperty@name=N'MS_Description',@value=N'分组类型用户组0,角色组1',@level0type=N'SCHEMA',@level0name=N'dbo',@level1type=N'TABLE',@level1name=N'tb_Group',@level2type=N'COLUMN',@level2name=N'GroupType'
tb_UserRole:用户角色信息表 | |||
列名 | 数据类型 | 允许空 | 说明 |
UR_ID | int | N | 用户角色ID |
UserID | int | N | 用户ID |
RoleID | int | N | 角色ID |
- /*20120611BYFMX用户角色表*/
- USE[SH_Cloud]
- GO
- SETANSI_NULLSON
- GO
- SETQUOTED_IDENTIFIERON
- GO
- CREATETABLE[dbo].[tb_UserRole](
- [UR_ID][int]IDENTITY(1,1)NOTNULL,
- [UserID][int]NOTNULL,
- [RoleID][int]NOTNULL,
- CONSTRAINT[PK_tb_UserRole]PRIMARYKEYCLUSTERED
- (
- [UR_ID]ASC
- )WITH(IGNORE_DUP_KEY=OFF)ON[PRIMARY]
- )ON[PRIMARY]
tb_UserGroup:用户分组信息表 | |||
列名 | 数据类型 | 允许空 | 说明 |
UG_ID | int | N | 用户组ID |
UG_Name | nvarchar(30) | N | 用户分组名称 |
UG_Order | int | N | 用户分组排序 |
UG_Description | nvarchar(50) | N | 用户分组描述 |
UG_Depth | int | N | 用户分组深度 |
UG_SuperiorID | int | N | 用户分组上级 |
UG_Count | int | N | 用户分组下级数 |
- /*20120611BYFMX用户分组信息表*/
- USE[SH_Cloud]
- GO
- SETANSI_NULLSON
- GO
- SETQUOTED_IDENTIFIERON
- GO
- CREATETABLE[dbo].[tb_UserGroup](
- [UG_ID][int]IDENTITY(1,1)NOTNULL,
- [UG_Name][nvarchar](30)COLLATEChinese_PRC_CI_ASNOTNULL,
- [UG_Order][int]NOTNULL,
- [UG_Description][nvarchar](50)COLLATEChinese_PRC_CI_ASNOTNULL,
- [UG_Depth][int]NOTNULLCONSTRAINT[DF_tb_UserGroup_UG_Depth]DEFAULT((0)),
- [UG_SuperiorID][int]NOTNULLCONSTRAINT[DF_tb_UserGroup_UG_SuperiorID]DEFAULT((0)),
- [UG_Count][int]NOTNULLCONSTRAINT[DF_tb_UserGroup_UG_Count]DEFAULT((0)),
- CONSTRAINT[PK_tb_UserGroup]PRIMARYKEYCLUSTERED
- (
- [UG_ID]ASC
- )WITH(IGNORE_DUP_KEY=OFF)ON[PRIMARY]
- )ON[PRIMARY]
- GO
- EXECsys.sp_addextendedproperty@name=N'MS_Description',@value=N'用户组ID',@level0type=N'SCHEMA',@level0name=N'dbo',@level1type=N'TABLE',@level1name=N'tb_UserGroup',@level2type=N'COLUMN',@level2name=N'UG_ID'
- GO
- EXECsys.sp_addextendedproperty@name=N'MS_Description',@value=N'用户分组名称',@level0type=N'SCHEMA',@level0name=N'dbo',@level1type=N'TABLE',@level1name=N'tb_UserGroup',@level2type=N'COLUMN',@level2name=N'UG_Name'
- GO
- EXECsys.sp_addextendedproperty@name=N'MS_Description',@value=N'用户分组排序',@level0type=N'SCHEMA',@level0name=N'dbo',@level1type=N'TABLE',@level1name=N'tb_UserGroup',@level2type=N'COLUMN',@level2name=N'UG_Order'
- GO
- EXECsys.sp_addextendedproperty@name=N'MS_Description',@value=N'用户分组描述',@level0type=N'SCHEMA',@level0name=N'dbo',@level1type=N'TABLE',@level1name=N'tb_UserGroup',@level2type=N'COLUMN',@level2name=N'UG_Description'
- GO
- EXECsys.sp_addextendedproperty@name=N'MS_Description',@value=N'用户分组深度',@level0type=N'SCHEMA',@level0name=N'dbo',@level1type=N'TABLE',@level1name=N'tb_UserGroup',@level2type=N'COLUMN',@level2name=N'UG_Depth'
- GO
- EXECsys.sp_addextendedproperty@name=N'MS_Description',@value=N'用户分组上级',@level0type=N'SCHEMA',@level0name=N'dbo',@level1type=N'TABLE',@level1name=N'tb_UserGroup',@level2type=N'COLUMN',@level2name=N'UG_SuperiorID'
- GO
- EXECsys.sp_addextendedproperty@name=N'MS_Description',@value=N'用户分组下级数',@level0type=N'SCHEMA',@level0name=N'dbo',@level1type=N'TABLE',@level1name=N'tb_UserGroup',@level2type=N'COLUMN',@level2name=N'UG_Count'
tb_MenuType:菜单类型信息表 | |||
列名 | 数据类型 | 允许空 | 说明 |
MenuTypeID | int | N | 菜单分类ID |
MenuTypeName | nvarchar(30) | N | 菜单类型名称 |
MenuTypeOrder | int | N | 排序 |
MenuTypeDescription | nvarchar(50) | Y | 说明 |
MenuTypeDepth | int | N | 深度 |
MenuTypeSuperiorID | int | N | 上级ID |
MenuTypeCount | int | N | 下阶个数 |
- /*20120611BYFMX目录类型表*/
- USE[SH_Cloud]
- GO
- SETANSI_NULLSON
- GO
- SETQUOTED_IDENTIFIERON
- GO
- CREATETABLE[dbo].[tb_MenuType](
- [MenuTypeID][int]IDENTITY(1,1)NOTNULL,
- [MenuTypeName][nvarchar](30)COLLATEChinese_PRC_CI_ASNOTNULL,
- [MenuTypeOrder][int]NOTNULLCONSTRAINT[DF_ModuleGroup_ModuleGroupOrder]DEFAULT((0)),
- [MenuTypeDescription][nvarchar](50)COLLATEChinese_PRC_CI_ASNULL,
- [MenuTypeDepth][int]NOTNULLCONSTRAINT[DF_tb_MenuType_MenuTypeDepth]DEFAULT((0)),
- [MenuTypeSuperiorID][int]NOTNULLCONSTRAINT[DF_tb_MenuType_MenuTypeSuperiorID]DEFAULT((0)),
- [MenuTypeCount][int]NOTNULLCONSTRAINT[DF_tb_MenuType_MenuTypeCount]DEFAULT((0)),
- CONSTRAINT[PK_tb_MenuType_1]PRIMARYKEYCLUSTERED
- (
- [MenuTypeID]ASC
- )WITH(IGNORE_DUP_KEY=OFF)ON[PRIMARY]
- )ON[PRIMARY]
- GO
- EXECsys.sp_addextendedproperty@name=N'MS_Description',@value=N'模块分类ID',@level0type=N'SCHEMA',@level0name=N'dbo',@level1type=N'TABLE',@level1name=N'tb_MenuType',@level2type=N'COLUMN',@level2name=N'MenuTypeID'
- GO
- EXECsys.sp_addextendedproperty@name=N'MS_Description',@value=N'模块类型名称',@level0type=N'SCHEMA',@level0name=N'dbo',@level1type=N'TABLE',@level1name=N'tb_MenuType',@level2type=N'COLUMN',@level2name=N'MenuTypeName'
- GO
- EXECsys.sp_addextendedproperty@name=N'MS_Description',@value=N'排序',@level0type=N'SCHEMA',@level0name=N'dbo',@level1type=N'TABLE',@level1name=N'tb_MenuType',@level2type=N'COLUMN',@level2name=N'MenuTypeOrder'
- GO
- EXECsys.sp_addextendedproperty@name=N'MS_Description',@value=N'说明',@level0type=N'SCHEMA',@level0name=N'dbo',@level1type=N'TABLE',@level1name=N'tb_MenuType',@level2type=N'COLUMN',@level2name=N'MenuTypeDescription'
- GO
- EXECsys.sp_addextendedproperty@name=N'MS_Description',@value=N'深度',@level0type=N'SCHEMA',@level0name=N'dbo',@level1type=N'TABLE',@level1name=N'tb_MenuType',@level2type=N'COLUMN',@level2name=N'MenuTypeDepth'
- GO
- EXECsys.sp_addextendedproperty@name=N'MS_Description',@value=N'上级ID',@level0type=N'SCHEMA',@level0name=N'dbo',@level1type=N'TABLE',@level1name=N'tb_MenuType',@level2type=N'COLUMN',@level2name=N'MenuTypeSuperiorID'
- GO
- EXECsys.sp_addextendedproperty@name=N'MS_Description',@value=N'下级个数',@level0type=N'SCHEMA',@level0name=N'dbo',@level1type=N'TABLE',@level1name=N'tb_MenuType',@level2type=N'COLUMN',@level2name=N'MenuTypeCount'
tb_Menu:菜单信息表 | |||
列名 | 数据类型 | 允许空 | 说明 |
MenuID | int | N | 菜单ID |
MenuTypeID | int | N | 菜单类型 |
MenuName | nvarchar(30) | N | 菜单名称 |
MenuTag | nvarchar(50) | N | 菜单标识 |
MenuURL | nvarchar(500) | Y | 菜单地址 |
MenuDisabled | bit | N | 是否禁用 |
MenuOrder | int | N | 排序 |
MenuDescription | nvarchar(50) | Y | 说明 |
IsMenu | bit | N | 是否显示在导航菜单中 |
- /*20120611BYFMX菜单表*/
- USE[SH_Cloud]
- GO
- SETANSI_NULLSON
- GO
- SETQUOTED_IDENTIFIERON
- GO
- CREATETABLE[dbo].[tb_Menu](
- [MenuID][int]IDENTITY(1,1)NOTNULL,
- [MenuTypeID][int]NOTNULL,
- [MenuName][nvarchar](30)COLLATEChinese_PRC_CI_ASNOTNULL,
- [MenuTag][nvarchar](50)COLLATEChinese_PRC_CI_ASNOTNULL,
- [MenuURL][nvarchar](500)COLLATEChinese_PRC_CI_ASNULL,
- [MenuDisabled][bit]NOTNULLCONSTRAINT[DF_tb_Menu_MenuDisabled]DEFAULT((1)),
- [MenuOrder][int]NOTNULLCONSTRAINT[DF_tb_Menu_MenuOrder]DEFAULT((0)),
- [MenuDescription][nvarchar](50)COLLATEChinese_PRC_CI_ASNULL,
- [IsMenu][bit]NOTNULLCONSTRAINT[DF_tb_Menu_IsMenu]DEFAULT((1)),
- CONSTRAINT[PK_tb_Menu]PRIMARYKEYCLUSTERED
- (
- [MenuID]ASC
- )WITH(IGNORE_DUP_KEY=OFF)ON[PRIMARY]
- )ON[PRIMARY]
- GO
- EXECsys.sp_addextendedproperty@name=N'MS_Description',@value=N'模块ID',@level0type=N'SCHEMA',@level0name=N'dbo',@level1type=N'TABLE',@level1name=N'tb_Menu',@level2type=N'COLUMN',@level2name=N'MenuID'
- GO
- EXECsys.sp_addextendedproperty@name=N'MS_Description',@value=N'模块类型',@level0type=N'SCHEMA',@level0name=N'dbo',@level1type=N'TABLE',@level1name=N'tb_Menu',@level2type=N'COLUMN',@level2name=N'MenuTypeID'
- GO
- EXECsys.sp_addextendedproperty@name=N'MS_Description',@value=N'模块名称',@level0type=N'SCHEMA',@level0name=N'dbo',@level1type=N'TABLE',@level1name=N'tb_Menu',@level2type=N'COLUMN',@level2name=N'MenuName'
- GO
- EXECsys.sp_addextendedproperty@name=N'MS_Description',@value=N'模块标识',@level0type=N'SCHEMA',@level0name=N'dbo',@level1type=N'TABLE',@level1name=N'tb_Menu',@level2type=N'COLUMN',@level2name=N'MenuTag'
- GO
- EXECsys.sp_addextendedproperty@name=N'MS_Description',@value=N'模块地址',@level0type=N'SCHEMA',@level0name=N'dbo',@level1type=N'TABLE',@level1name=N'tb_Menu',@level2type=N'COLUMN',@level2name=N'MenuURL'
- GO
- EXECsys.sp_addextendedproperty@name=N'MS_Description',@value=N'是否禁用',@level0type=N'SCHEMA',@level0name=N'dbo',@level1type=N'TABLE',@level1name=N'tb_Menu',@level2type=N'COLUMN',@level2name=N'MenuDisabled'
- GO
- EXECsys.sp_addextendedproperty@name=N'MS_Description',@value=N'排序',@level0type=N'SCHEMA',@level0name=N'dbo',@level1type=N'TABLE',@level1name=N'tb_Menu',@level2type=N'COLUMN',@level2name=N'MenuOrder'
- GO
- EXECsys.sp_addextendedproperty@name=N'MS_Description',@value=N'说明',@level0type=N'SCHEMA',@level0name=N'dbo',@level1type=N'TABLE',@level1name=N'tb_Menu',@level2type=N'COLUMN',@level2name=N'MenuDescription'
- GO
- EXECsys.sp_addextendedproperty@name=N'MS_Description',@value=N'是否显示在导航菜单中',@level0type=N'SCHEMA',@level0name=N'dbo',@level1type=N'TABLE',@level1name=N'tb_Menu',@level2type=N'COLUMN',@level2name=N'IsMenu'
tb_MenuAction:菜单权限信息表 | |||
列名 | 数据类型 | 允许空 | 说明 |
ID | int | N | 菜单权限ID |
MenuID | int | N | 菜单ID |
ActionTag | nvarchar(50) | N | 权限标识 |
- /*20120611BYFMX模块权限表*/
- USE[SH_Cloud]
- GO
- SETANSI_NULLSON
- GO
- SETQUOTED_IDENTIFIERON
- GO
- CREATETABLE[dbo].[tb_MenuAction](
- [ID][int]IDENTITY(1,1)NOTNULL,
- [MenuID][int]NOTNULL,
- [ActionTag][nvarchar](50)COLLATEChinese_PRC_CI_ASNOTNULL,
- CONSTRAINT[PK_tb_MenuAction]PRIMARYKEYCLUSTERED
- (
- [ID]ASC
- )WITH(IGNORE_DUP_KEY=OFF)ON[PRIMARY]
- )ON[PRIMARY]
- GO
- EXECsys.sp_addextendedproperty@name=N'MS_Description',@value=N'模块权限ID',@level0type=N'SCHEMA',@level0name=N'dbo',@level1type=N'TABLE',@level1name=N'tb_MenuAction',@level2type=N'COLUMN',@level2name=N'ID'
- GO
- EXECsys.sp_addextendedproperty@name=N'MS_Description',@value=N'模块ID',@level0type=N'SCHEMA',@level0name=N'dbo',@level1type=N'TABLE',@level1name=N'tb_MenuAction',@level2type=N'COLUMN',@level2name=N'MenuID'
- GO
- EXECsys.sp_addextendedproperty@name=N'MS_Description',@value=N'权限标识',@level0type=N'SCHEMA',@level0name=N'dbo',@level1type=N'TABLE',@level1name=N'tb_MenuAction',@level2type=N'COLUMN',@level2name=N'ActionTag'
tb_RoleAction:角色权限信息表 | |||
列名 | 数据类型 | 允许空 | 说明 |
ID | int | N | 编号 |
UserID | int | N | 用户ID |
RoleID | int | N | 角色ID |
GroupID | int | N | 分组ID |
MenuID | int | N | 菜单ID |
ActionTag | nvarchar(50) | N | 权限标识 |
Flag | bit | N | 1为允许,0为不禁止 |
- /*20120611BYFMX角色权限表*/
- USE[SH_Cloud]
- GO
- SETANSI_NULLSON
- GO
- SETQUOTED_IDENTIFIERON
- GO
- CREATETABLE[dbo].[tb_RoleAction](
- [ID][int]IDENTITY(1,1)NOTNULL,
- [UserID][int]NOTNULLCONSTRAINT[DF_tb_RoleAction_UserID]DEFAULT((0)),
- [RoleID][int]NOTNULLCONSTRAINT[DF_tb_RoleAction_RoleID]DEFAULT((0)),
- [GroupID][int]NOTNULLCONSTRAINT[DF_tb_RoleAction_GroupID]DEFAULT((0)),
- [MenuID][int]NOTNULL,
- [ActionTag][nvarchar](50)COLLATEChinese_PRC_CI_ASNOTNULL,
- [Flag][bit]NOTNULLCONSTRAINT[DF_tb_RoleAction_Flag]DEFAULT((1)),
- CONSTRAINT[PK_tb_RoleAction]PRIMARYKEYCLUSTERED
- (
- [ID]ASC
- )WITH(IGNORE_DUP_KEY=OFF)ON[PRIMARY]
- )ON[PRIMARY]
- GO
- EXECsys.sp_addextendedproperty@name=N'MS_Description',@value=N'编号',@level0type=N'SCHEMA',@level0name=N'dbo',@level1type=N'TABLE',@level1name=N'tb_RoleAction',@level2type=N'COLUMN',@level2name=N'ID'
- GO
- EXECsys.sp_addextendedproperty@name=N'MS_Description',@value=N'用户ID',@level0type=N'SCHEMA',@level0name=N'dbo',@level1type=N'TABLE',@level1name=N'tb_RoleAction',@level2type=N'COLUMN',@level2name=N'UserID'
- GO
- EXECsys.sp_addextendedproperty@name=N'MS_Description',@value=N'角色ID',@level0type=N'SCHEMA',@level0name=N'dbo',@level1type=N'TABLE',@level1name=N'tb_RoleAction',@level2type=N'COLUMN',@level2name=N'RoleID'
- GO
- EXECsys.sp_addextendedproperty@name=N'MS_Description',@value=N'分组ID',@level0type=N'SCHEMA',@level0name=N'dbo',@level1type=N'TABLE',@level1name=N'tb_RoleAction',@level2type=N'COLUMN',@level2name=N'GroupID'
- GO
- EXECsys.sp_addextendedproperty@name=N'MS_Description',@value=N'模块ID',@level0type=N'SCHEMA',@level0name=N'dbo',@level1type=N'TABLE',@level1name=N'tb_RoleAction',@level2type=N'COLUMN',@level2name=N'MenuID'
- GO
- EXECsys.sp_addextendedproperty@name=N'MS_Description',@value=N'权限标识',@level0type=N'SCHEMA',@level0name=N'dbo',@level1type=N'TABLE',@level1name=N'tb_RoleAction',@level2type=N'COLUMN',@level2name=N'ActionTag'
- GO
- EXECsys.sp_addextendedproperty@name=N'MS_Description',@value=N'1为允许,0为不禁止',@level0type=N'SCHEMA',@level0name=N'dbo',@level1type=N'TABLE',@level1name=N'tb_RoleAction',@level2type=N'COLUMN',@l