Tables [dbo].[DeviceAuditSummary]
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
Row Count (~)0
Created1:20:02 AM Thursday, March 21, 2019
Last Modified1:20:22 AM Thursday, March 21, 2019
KeyNameData TypeMax Length (Bytes)Allow Nulls
Cluster Primary Key PK_DeviceAuditSummary_DeviceID_AuditDate_Source_SourceVersion_LocationID: DeviceID\AuditDate\Source\SourceVersion\LocationIDForeign Keys FK_DeviceAuditSummary_DeviceID_Device_DeviceID: [dbo].[Device].DeviceIDDeviceIDint4
False
Cluster Primary Key PK_DeviceAuditSummary_DeviceID_AuditDate_Source_SourceVersion_LocationID: DeviceID\AuditDate\Source\SourceVersion\LocationIDAuditDatedatetime8
False
Cluster Primary Key PK_DeviceAuditSummary_DeviceID_AuditDate_Source_SourceVersion_LocationID: DeviceID\AuditDate\Source\SourceVersion\LocationIDSourcevarchar(32)32
False
Cluster Primary Key PK_DeviceAuditSummary_DeviceID_AuditDate_Source_SourceVersion_LocationID: DeviceID\AuditDate\Source\SourceVersion\LocationIDSourceVersionvarchar(32)32
False
Metersbit1
True
Suppliesbit1
True
Statusbit1
True
Servicebit1
True
Agentbit1
True
Cluster Primary Key PK_DeviceAuditSummary_DeviceID_AuditDate_Source_SourceVersion_LocationID: DeviceID\AuditDate\Source\SourceVersion\LocationIDForeign Keys FK_DeviceAuditSummary_LocationID_AccountLocation_LocationID: [dbo].[AccountLocation].LocationIDLocationIDint4
False
UserDatabit1
True
HpMetersbit1
True
KeyNameKey ColumnsUnique
Cluster Primary Key PK_DeviceAuditSummary_DeviceID_AuditDate_Source_SourceVersion_LocationID: DeviceID\AuditDate\Source\SourceVersion\LocationIDPK_DeviceAuditSummary_DeviceID_AuditDate_Source_SourceVersion_LocationIDDeviceID, AuditDate, Source, SourceVersion, LocationID
True
NameDeleteColumns
FK_DeviceAuditSummary_DeviceID_Device_DeviceIDCascadeDeviceID->[dbo].[Device].[DeviceID]
FK_DeviceAuditSummary_LocationID_AccountLocation_LocationIDLocationID->[dbo].[AccountLocation].[LocationID]
CREATE TABLE [dbo].[DeviceAuditSummary]
(
[DeviceID] [int] NOT NULL,
[AuditDate] [datetime] NOT NULL,
[Source] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[SourceVersion] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Meters] [bit] NULL,
[Supplies] [bit] NULL,
[Status] [bit] NULL,
[Service] [bit] NULL,
[Agent] [bit] NULL,
[LocationID] [int] NOT NULL,
[UserData] [bit] NULL,
[HpMeters] [bit] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[DeviceAuditSummary] ADD CONSTRAINT [PK_DeviceAuditSummary_DeviceID_AuditDate_Source_SourceVersion_LocationID] PRIMARY KEY CLUSTERED  ([DeviceID], [AuditDate], [Source], [SourceVersion], [LocationID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[DeviceAuditSummary] ADD CONSTRAINT [FK_DeviceAuditSummary_DeviceID_Device_DeviceID] FOREIGN KEY ([DeviceID]) REFERENCES [dbo].[Device] ([DeviceID]) ON DELETE CASCADE
GO
ALTER TABLE [dbo].[DeviceAuditSummary] ADD CONSTRAINT [FK_DeviceAuditSummary_LocationID_AccountLocation_LocationID] FOREIGN KEY ([LocationID]) REFERENCES [dbo].[AccountLocation] ([LocationID])
GO