Tables [dbo].[DashboardPortlet]
PropertyValue
HeapTrue
Row Count (~)0
Created1:20:02 AM Thursday, March 21, 2019
Last Modified1:20:15 AM Thursday, March 21, 2019
KeyNameData TypeMax Length (Bytes)Allow NullsIdentityDefault
Primary Key PK_DashboardPortlet_ID: IDIDint4
False
1 - 1
Foreign Keys FK_DashboardPortlet_DashboardLayoutID_DashboardLayout_ID: [dbo].[DashboardLayout].DashboardLayoutIDDashboardLayoutIDint4
False
PortletTypeIDint4
False
RowIndexint4
False
ColumnIndexint4
False
IsCollapsedbit1
False
((0))
KeyNameKey ColumnsUnique
Primary Key PK_DashboardPortlet_ID: IDPK_DashboardPortlet_IDID
True
NameUpdateDeleteColumns
FK_DashboardPortlet_DashboardLayoutID_DashboardLayout_IDCascadeCascadeDashboardLayoutID->[dbo].[DashboardLayout].[ID]
CREATE TABLE [dbo].[DashboardPortlet]
(
[ID] [int] NOT NULL IDENTITY(1, 1),
[DashboardLayoutID] [int] NOT NULL,
[PortletTypeID] [int] NOT NULL,
[RowIndex] [int] NOT NULL,
[ColumnIndex] [int] NOT NULL,
[IsCollapsed] [bit] NOT NULL CONSTRAINT [DF_DashboardPortlet_IsCollapsed] DEFAULT ((0))
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[DashboardPortlet] ADD CONSTRAINT [PK_DashboardPortlet_ID] PRIMARY KEY NONCLUSTERED  ([ID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[DashboardPortlet] ADD CONSTRAINT [FK_DashboardPortlet_DashboardLayoutID_DashboardLayout_ID] FOREIGN KEY ([DashboardLayoutID]) REFERENCES [dbo].[DashboardLayout] ([ID]) ON DELETE CASCADE ON UPDATE CASCADE
GO