Tables [dbo].[AdminHistoryRecord]
Properties
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
Row Count (~)0
Created7:34:18 PM Wednesday, February 28, 2024
Last Modified7:34:18 PM Wednesday, February 28, 2024
Columns
NameData TypeMax Length (Bytes)Allow NullsIdentity
Cluster Primary Key PK_AdminHistoryRecord: AdminHistoryRecordIdIndexes IX_AdminHistoryRecord_AdminHistoryRecordId_RecordId: AdminHistoryRecordId\RecordIdAdminHistoryRecordIdbigint8
No
1 - 1
Foreign Keys FK_AdminHistoryRecord_AdminHistoryAdminRole: [dbo].[AdminHistoryAdminRole].AdminHistoryAdminRoleFidIndexes IX_AdminHistoryRecord_AdminHistoryAdminRole_RecordId: AdminHistoryAdminRoleFid\RecordIdIndexes IX_AdminHistoryRecord_AdminHistoryAdminRoleFid_RecordId_RecordDescription: AdminHistoryAdminRoleFid\RecordId\RecordDescriptionAdminHistoryAdminRoleFidint4
No
Indexes IX_AdminHistoryRecord_AdminHistoryAdminRole_RecordId: AdminHistoryAdminRoleFid\RecordIdIndexes IX_AdminHistoryRecord_AdminHistoryAdminRoleFid_RecordId_RecordDescription: AdminHistoryAdminRoleFid\RecordId\RecordDescriptionIndexes IX_AdminHistoryRecord_AdminHistoryRecordId_RecordId: AdminHistoryRecordId\RecordIdRecordIdbigint8
No
Indexes IX_AdminHistoryRecord_AdminHistoryAdminRoleFid_RecordId_RecordDescription: AdminHistoryAdminRoleFid\RecordId\RecordDescriptionRecordDescriptionnvarchar(4000)8000
Yes
Indexes Indexes
NameColumnsUnique
Cluster Primary Key PK_AdminHistoryRecord: AdminHistoryRecordIdPK_AdminHistoryRecordAdminHistoryRecordId
Yes
IX_AdminHistoryRecord_AdminHistoryAdminRole_RecordIdAdminHistoryAdminRoleFid, RecordId
Yes
IX_AdminHistoryRecord_AdminHistoryAdminRoleFid_RecordId_RecordDescriptionAdminHistoryAdminRoleFid, RecordId, RecordDescription
IX_AdminHistoryRecord_AdminHistoryRecordId_RecordIdAdminHistoryRecordId, RecordId
Foreign Keys Foreign Keys
NameColumns
FK_AdminHistoryRecord_AdminHistoryAdminRoleAdminHistoryAdminRoleFid->[dbo].[AdminHistoryAdminRole].[AdminHistoryAdminRoleId]
Permissions
TypeActionOwning Principal
GrantDeleteMssExec
GrantInsertMssExec
GrantSelectMssExec
GrantUpdateMssExec
SQL Script
CREATE TABLE [dbo].[AdminHistoryRecord]
(
[AdminHistoryRecordId] [bigint] NOT NULL IDENTITY(1, 1),
[AdminHistoryAdminRoleFid] [int] NOT NULL,
[RecordId] [bigint] NOT NULL,
[RecordDescription] [nvarchar] (4000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[AdminHistoryRecord] ADD CONSTRAINT [PK_AdminHistoryRecord] PRIMARY KEY CLUSTERED  ([AdminHistoryRecordId]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[AdminHistoryRecord] ADD CONSTRAINT [IX_AdminHistoryRecord_AdminHistoryAdminRole_RecordId] UNIQUE NONCLUSTERED  ([AdminHistoryAdminRoleFid], [RecordId]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_AdminHistoryRecord_AdminHistoryAdminRoleFid_RecordId_RecordDescription] ON [dbo].[AdminHistoryRecord] ([AdminHistoryAdminRoleFid], [RecordId], [RecordDescription]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_AdminHistoryRecord_AdminHistoryRecordId_RecordId] ON [dbo].[AdminHistoryRecord] ([AdminHistoryRecordId], [RecordId]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[AdminHistoryRecord] ADD CONSTRAINT [FK_AdminHistoryRecord_AdminHistoryAdminRole] FOREIGN KEY ([AdminHistoryAdminRoleFid]) REFERENCES [dbo].[AdminHistoryAdminRole] ([AdminHistoryAdminRoleId])
GO
GRANT SELECT ON  [dbo].[AdminHistoryRecord] TO [MssExec]
GRANT INSERT ON  [dbo].[AdminHistoryRecord] TO [MssExec]
GRANT DELETE ON  [dbo].[AdminHistoryRecord] TO [MssExec]
GRANT UPDATE ON  [dbo].[AdminHistoryRecord] TO [MssExec]
GO
Uses
Used By