Tables [dbo].[AdminHistoryAdminRole]
Properties
PropertyValue
Row Count (~)11
Created9:08:25 AM Thursday, May 23, 2024
Last Modified9:08:25 AM Thursday, May 23, 2024
Columns
NameData TypeMax Length (Bytes)Allow NullsIdentityDefault
Cluster Primary Key PK_AdminHistoryAdminRole: AdminHistoryAdminRoleIdAdminHistoryAdminRoleIdint4
No
1 - 1
Foreign Keys FK_AdminHistoryAdminRole_AdminRole: [dbo].[AdminRole].AdminRoleFidIndexes IX_AdminHistoryAdminRole_AdminRole: AdminRoleFidAdminRoleFidint4
No
IsTrackedbit1
No
((0))
Indexes Indexes
NameColumnsUnique
Cluster Primary Key PK_AdminHistoryAdminRole: AdminHistoryAdminRoleIdPK_AdminHistoryAdminRoleAdminHistoryAdminRoleId
Yes
IX_AdminHistoryAdminRole_AdminRoleAdminRoleFid
Yes
Foreign Keys Foreign Keys
NameColumns
FK_AdminHistoryAdminRole_AdminRoleAdminRoleFid->[dbo].[AdminRole].[AdminRoleID]
Permissions
TypeActionOwning Principal
GrantDeleteMssExec
GrantInsertMssExec
GrantSelectMssExec
GrantUpdateMssExec
SQL Script
CREATE TABLE [dbo].[AdminHistoryAdminRole]
(
[AdminHistoryAdminRoleId] [int] NOT NULL IDENTITY(1, 1),
[AdminRoleFid] [int] NOT NULL,
[IsTracked] [bit] NOT NULL CONSTRAINT [DF_AdminHistoryScreen_IsTracked] DEFAULT ((0))
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[AdminHistoryAdminRole] ADD CONSTRAINT [PK_AdminHistoryAdminRole] PRIMARY KEY CLUSTERED  ([AdminHistoryAdminRoleId]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[AdminHistoryAdminRole] ADD CONSTRAINT [IX_AdminHistoryAdminRole_AdminRole] UNIQUE NONCLUSTERED  ([AdminRoleFid]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[AdminHistoryAdminRole] ADD CONSTRAINT [FK_AdminHistoryAdminRole_AdminRole] FOREIGN KEY ([AdminRoleFid]) REFERENCES [dbo].[AdminRole] ([AdminRoleID])
GO
GRANT SELECT ON  [dbo].[AdminHistoryAdminRole] TO [MssExec]
GRANT INSERT ON  [dbo].[AdminHistoryAdminRole] TO [MssExec]
GRANT DELETE ON  [dbo].[AdminHistoryAdminRole] TO [MssExec]
GRANT UPDATE ON  [dbo].[AdminHistoryAdminRole] TO [MssExec]
GO
Uses
Used By