Tables [dbo].[DashboardTechnologies]
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
Row Count (~)0
Created1:20:02 AM Thursday, March 21, 2019
Last Modified1:20:16 AM Thursday, March 21, 2019
KeyNameData TypeMax Length (Bytes)Allow Nulls
Cluster Primary Key PK_DashboardTechnologies_AccountID_Technology: AccountID\TechnologyForeign Keys FK_DashboardTechnologies_AccountID_Account_AccountID: [dbo].[Account].AccountIDAccountIDint4
False
Cluster Primary Key PK_DashboardTechnologies_AccountID_Technology: AccountID\TechnologyTechnologyvarchar(120)120
False
DevicesPerTechnologybigint8
False
PagesPerTechnologybigint8
False
KeyNameKey ColumnsUnique
Cluster Primary Key PK_DashboardTechnologies_AccountID_Technology: AccountID\TechnologyPK_DashboardTechnologies_AccountID_TechnologyAccountID, Technology
True
NameUpdateDeleteColumns
FK_DashboardTechnologies_AccountID_Account_AccountIDCascadeCascadeAccountID->[dbo].[Account].[AccountID]
CREATE TABLE [dbo].[DashboardTechnologies]
(
[AccountID] [int] NOT NULL,
[Technology] [varchar] (120) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[DevicesPerTechnology] [bigint] NOT NULL,
[PagesPerTechnology] [bigint] NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[DashboardTechnologies] ADD CONSTRAINT [PK_DashboardTechnologies_AccountID_Technology] PRIMARY KEY CLUSTERED  ([AccountID], [Technology]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[DashboardTechnologies] ADD CONSTRAINT [FK_DashboardTechnologies_AccountID_Account_AccountID] FOREIGN KEY ([AccountID]) REFERENCES [dbo].[Account] ([AccountID]) ON DELETE CASCADE ON UPDATE CASCADE
GO