Tables [dbo].[AdminRole]
Properties
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
Row Count (~)286
Created4:03:38 PM Thursday, May 10, 2012
Last Modified9:08:25 AM Thursday, May 23, 2024
Columns
NameData TypeMax Length (Bytes)Allow NullsIdentityDescription
Primary Key PK_AdminRole: AdminRoleIDIndexes IX_AdminRole_RoleDescription: AdminRoleID\RoleDescriptionAdminRoleIDint4
No
1 - 1The primary key.
Indexes IX_AdminRole_ScreenName_TabName: ScreenName\TabNameScreenNamevarchar(64)64
No
The name of the screen this role accesses.
Indexes IX_AdminRole_ScreenName_TabName: ScreenName\TabNameTabNamevarchar(64)64
Yes
The name of the tab on this screen this role accesses.
Cluster Key IX_AdminRole_AdminSectionFID_RoleDescription: AdminSectionFID\RoleDescriptionIndexes IX_AdminRole_RoleDescription: AdminRoleID\RoleDescriptionRoleDescriptionvarchar(96)96
No
The user friendly role description.
Cluster Key IX_AdminRole_AdminSectionFID_RoleDescription: AdminSectionFID\RoleDescriptionForeign Keys FK_AdminRole_AdminSection: [dbo].[AdminSection].AdminSectionFIDAdminSectionFIDint4
No
The admin section this role is assigned to.
Indexes Indexes
NameColumnsUnique
Primary Key PK_AdminRole: AdminRoleIDPK_AdminRoleAdminRoleID
Yes
Cluster Key IX_AdminRole_AdminSectionFID_RoleDescription: AdminSectionFID\RoleDescriptionIX_AdminRole_AdminSectionFID_RoleDescriptionAdminSectionFID, RoleDescription
Yes
IX_AdminRole_ScreenName_TabNameScreenName, TabName
Yes
IX_AdminRole_RoleDescriptionAdminRoleID, RoleDescription
Foreign Keys Foreign Keys
NameColumns
FK_AdminRole_AdminSectionAdminSectionFID->[dbo].[AdminSection].[AdminSectionID]
Permissions
TypeActionOwning Principal
GrantDeleteMssExec
GrantInsertMssExec
GrantSelectMssExec
GrantUpdateMssExec
SQL Script
CREATE TABLE [dbo].[AdminRole]
(
[AdminRoleID] [int] NOT NULL IDENTITY(1, 1),
[ScreenName] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[TabName] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[RoleDescription] [varchar] (96) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[AdminSectionFID] [int] NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[AdminRole] ADD CONSTRAINT [PK_AdminRole] PRIMARY KEY NONCLUSTERED  ([AdminRoleID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[AdminRole] ADD CONSTRAINT [IX_AdminRole_AdminSectionFID_RoleDescription] UNIQUE CLUSTERED  ([AdminSectionFID], [RoleDescription]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[AdminRole] ADD CONSTRAINT [IX_AdminRole_ScreenName_TabName] UNIQUE NONCLUSTERED  ([ScreenName], [TabName]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_AdminRole_RoleDescription] ON [dbo].[AdminRole] ([RoleDescription]) INCLUDE ([AdminRoleID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[AdminRole] ADD CONSTRAINT [FK_AdminRole_AdminSection] FOREIGN KEY ([AdminSectionFID]) REFERENCES [dbo].[AdminSection] ([AdminSectionID])
GO
GRANT SELECT ON  [dbo].[AdminRole] TO [MssExec]
GRANT INSERT ON  [dbo].[AdminRole] TO [MssExec]
GRANT DELETE ON  [dbo].[AdminRole] TO [MssExec]
GRANT UPDATE ON  [dbo].[AdminRole] TO [MssExec]
GO
EXEC sp_addextendedproperty N'MS_Description', N'The primary key.', 'SCHEMA', N'dbo', 'TABLE', N'AdminRole', 'COLUMN', N'AdminRoleID'
GO
EXEC sp_addextendedproperty N'MS_Description', N'The admin section this role is assigned to.', 'SCHEMA', N'dbo', 'TABLE', N'AdminRole', 'COLUMN', N'AdminSectionFID'
GO
EXEC sp_addextendedproperty N'MS_Description', N'The user friendly role description.', 'SCHEMA', N'dbo', 'TABLE', N'AdminRole', 'COLUMN', N'RoleDescription'
GO
EXEC sp_addextendedproperty N'MS_Description', N'The name of the screen this role accesses.', 'SCHEMA', N'dbo', 'TABLE', N'AdminRole', 'COLUMN', N'ScreenName'
GO
EXEC sp_addextendedproperty N'MS_Description', N'The name of the tab on this screen this role accesses.', 'SCHEMA', N'dbo', 'TABLE', N'AdminRole', 'COLUMN', N'TabName'
GO
Uses
Used By