Tables [dbo].[MssWebTimelineSelectedFilterItemTypeMap]
Properties
PropertyValue
Row Count (~)0
Created1:49:35 PM Wednesday, April 10, 2024
Last Modified1:49:38 PM Wednesday, April 10, 2024
Columns
NameData TypeMax Length (Bytes)Allow NullsIdentity
Cluster Primary Key PK_MssWebTimelineSelectedFilterItemTypeMap: MssWebTimelineSelectedFilterItemTypeMapIdMssWebTimelineSelectedFilterItemTypeMapIdint4
No
1 - 1
Foreign Keys FK_MssWebTimelineSelectedFilterItemTypeMap_SysUser: [dbo].[Sysuser].SysUserFIDIndexes IX_MssWebTimelineSelectedFilterItemTypeMap_SysUserFID_MssWebTimelineSelectedFilterItemTypeFID: SysUserFID\MssWebTimelineSelectedFilterItemTypeFIDSysUserFIDint4
No
Foreign Keys FK_MssWebTimelineSelectedFilterItemTypeMap_MssWebTimelineSelectedFilterItemType: [dbo].[MssWebTimelineSelectedFilterItemType].MssWebTimelineSelectedFilterItemTypeFIDIndexes IX_MssWebTimelineSelectedFilterItemTypeMap_SysUserFID_MssWebTimelineSelectedFilterItemTypeFID: SysUserFID\MssWebTimelineSelectedFilterItemTypeFIDMssWebTimelineSelectedFilterItemTypeFIDint4
No
Indexes Indexes
NameColumnsUnique
Cluster Primary Key PK_MssWebTimelineSelectedFilterItemTypeMap: MssWebTimelineSelectedFilterItemTypeMapIdPK_MssWebTimelineSelectedFilterItemTypeMapMssWebTimelineSelectedFilterItemTypeMapId
Yes
IX_MssWebTimelineSelectedFilterItemTypeMap_SysUserFID_MssWebTimelineSelectedFilterItemTypeFIDSysUserFID, MssWebTimelineSelectedFilterItemTypeFID
Yes
Foreign Keys Foreign Keys
NameColumns
FK_MssWebTimelineSelectedFilterItemTypeMap_MssWebTimelineSelectedFilterItemTypeMssWebTimelineSelectedFilterItemTypeFID->[dbo].[MssWebTimelineSelectedFilterItemType].[MssWebTimelineSelectedFilterItemTypeId]
FK_MssWebTimelineSelectedFilterItemTypeMap_SysUserSysUserFID->[dbo].[Sysuser].[SysUserID]
Permissions
TypeActionOwning Principal
GrantDeleteMssExec
GrantInsertMssExec
GrantSelectMssExec
GrantUpdateMssExec
SQL Script
CREATE TABLE [dbo].[MssWebTimelineSelectedFilterItemTypeMap]
(
[MssWebTimelineSelectedFilterItemTypeMapId] [int] NOT NULL IDENTITY(1, 1),
[SysUserFID] [int] NOT NULL,
[MssWebTimelineSelectedFilterItemTypeFID] [int] NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[MssWebTimelineSelectedFilterItemTypeMap] ADD CONSTRAINT [PK_MssWebTimelineSelectedFilterItemTypeMap] PRIMARY KEY CLUSTERED  ([MssWebTimelineSelectedFilterItemTypeMapId]) ON [PRIMARY]
GO
CREATE UNIQUE NONCLUSTERED INDEX [IX_MssWebTimelineSelectedFilterItemTypeMap_SysUserFID_MssWebTimelineSelectedFilterItemTypeFID] ON [dbo].[MssWebTimelineSelectedFilterItemTypeMap] ([SysUserFID], [MssWebTimelineSelectedFilterItemTypeFID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[MssWebTimelineSelectedFilterItemTypeMap] ADD CONSTRAINT [FK_MssWebTimelineSelectedFilterItemTypeMap_MssWebTimelineSelectedFilterItemType] FOREIGN KEY ([MssWebTimelineSelectedFilterItemTypeFID]) REFERENCES [dbo].[MssWebTimelineSelectedFilterItemType] ([MssWebTimelineSelectedFilterItemTypeId])
GO
ALTER TABLE [dbo].[MssWebTimelineSelectedFilterItemTypeMap] ADD CONSTRAINT [FK_MssWebTimelineSelectedFilterItemTypeMap_SysUser] FOREIGN KEY ([SysUserFID]) REFERENCES [dbo].[Sysuser] ([SysUserID])
GO
GRANT SELECT ON  [dbo].[MssWebTimelineSelectedFilterItemTypeMap] TO [MssExec]
GRANT INSERT ON  [dbo].[MssWebTimelineSelectedFilterItemTypeMap] TO [MssExec]
GRANT DELETE ON  [dbo].[MssWebTimelineSelectedFilterItemTypeMap] TO [MssExec]
GRANT UPDATE ON  [dbo].[MssWebTimelineSelectedFilterItemTypeMap] TO [MssExec]
GO
Uses