Tables [dbo].[MssWebUiState]
Properties
PropertyValue
Row Count (~)0
Created8:47:13 AM Thursday, December 5, 2024
Last Modified8:49:46 AM Thursday, December 5, 2024
Columns
NameData TypeMax Length (Bytes)Allow NullsIdentityDefault
Cluster Key IX_MssWebUiState_SysUserFID: SysUserFIDForeign Keys FK_MssWebUiState_SysUser: [dbo].[Sysuser].SysUserFIDSysUserFIDint4
No
Primary Key PK_MssWebUiState: MssWebUiStateIdMssWebUiStateIdint4
No
1 - 1
TimelineSidebarExpandedbit1
No
((1))
CustomLocalServiceStatusFiltersbit1
No
((0))
Indexes Indexes
NameColumnsUnique
Primary Key PK_MssWebUiState: MssWebUiStateIdPK_MssWebUiStateMssWebUiStateId
Yes
Cluster Key IX_MssWebUiState_SysUserFID: SysUserFIDIX_MssWebUiState_SysUserFIDSysUserFID
Yes
Foreign Keys Foreign Keys
NameColumns
FK_MssWebUiState_SysUserSysUserFID->[dbo].[Sysuser].[SysUserID]
Permissions
TypeActionOwning Principal
GrantDeleteMssExec
GrantInsertMssExec
GrantSelectMssExec
GrantUpdateMssExec
SQL Script
CREATE TABLE [dbo].[MssWebUiState]
(
[SysUserFID] [int] NOT NULL,
[MssWebUiStateId] [int] NOT NULL IDENTITY(1, 1),
[TimelineSidebarExpanded] [bit] NOT NULL CONSTRAINT [DF_MssWebUiState_TimelineSidebarExpanded] DEFAULT ((1)),
[CustomLocalServiceStatusFilters] [bit] NOT NULL CONSTRAINT [DF_MssWebUiState_CustomLocalServiceStatusFilters] DEFAULT ((0))
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[MssWebUiState] ADD CONSTRAINT [PK_MssWebUiState] PRIMARY KEY NONCLUSTERED  ([MssWebUiStateId]) ON [PRIMARY]
GO
CREATE UNIQUE CLUSTERED INDEX [IX_MssWebUiState_SysUserFID] ON [dbo].[MssWebUiState] ([SysUserFID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[MssWebUiState] ADD CONSTRAINT [FK_MssWebUiState_SysUser] FOREIGN KEY ([SysUserFID]) REFERENCES [dbo].[Sysuser] ([SysUserID])
GO
GRANT SELECT ON  [dbo].[MssWebUiState] TO [MssExec]
GRANT INSERT ON  [dbo].[MssWebUiState] TO [MssExec]
GRANT DELETE ON  [dbo].[MssWebUiState] TO [MssExec]
GRANT UPDATE ON  [dbo].[MssWebUiState] TO [MssExec]
GO
Uses