Tables [dbo].[DataSync]
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
Row Count (~)0
Created1:20:02 AM Thursday, March 21, 2019
Last Modified1:20:17 AM Thursday, March 21, 2019
KeyNameData TypeMax Length (Bytes)Allow NullsIdentityDefault
Cluster Primary Key PK_DataSync_ID: IDIDint4
False
1 - 1
Foreign Keys FK_DataSync_DataSyncDefID_DataSyncDef_ID: [dbo].[DataSyncDef].DataSyncDefIDDataSyncDefIDint4
False
StartDatedatetime8
False
EndDatedatetime8
True
StartedBynvarchar(256)512
False
Statustinyint1
False
((0))
StatusMessagenvarchar(max)max
True
AccountsRequestedint4
True
AccountsMatchedint4
True
AccountsUpdatedint4
True
DevicesRequestedint4
True
DevicesMatchedint4
True
DevicesUpdatedint4
True
MetersRequestedint4
True
MetersMatchedint4
True
MetersSubmittedint4
True
ResultsEmailStatustinyint1
True
ResultsEmailDetailsnvarchar(max)max
True
KeyNameKey ColumnsUnique
Cluster Primary Key PK_DataSync_ID: IDPK_DataSync_IDID
True
NameDeleteColumns
FK_DataSync_DataSyncDefID_DataSyncDef_IDCascadeDataSyncDefID->[dbo].[DataSyncDef].[ID]
CREATE TABLE [dbo].[DataSync]
(
[ID] [int] NOT NULL IDENTITY(1, 1),
[DataSyncDefID] [int] NOT NULL,
[StartDate] [datetime] NOT NULL,
[EndDate] [datetime] NULL,
[StartedBy] [nvarchar] (256) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Status] [tinyint] NOT NULL CONSTRAINT [DF_DataSync_Status] DEFAULT ((0)),
[StatusMessage] [nvarchar] (max) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[AccountsRequested] [int] NULL,
[AccountsMatched] [int] NULL,
[AccountsUpdated] [int] NULL,
[DevicesRequested] [int] NULL,
[DevicesMatched] [int] NULL,
[DevicesUpdated] [int] NULL,
[MetersRequested] [int] NULL,
[MetersMatched] [int] NULL,
[MetersSubmitted] [int] NULL,
[ResultsEmailStatus] [tinyint] NULL,
[ResultsEmailDetails] [nvarchar] (max) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[DataSync] ADD CONSTRAINT [PK_DataSync_ID] PRIMARY KEY CLUSTERED  ([ID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[DataSync] ADD CONSTRAINT [FK_DataSync_DataSyncDefID_DataSyncDef_ID] FOREIGN KEY ([DataSyncDefID]) REFERENCES [dbo].[DataSyncDef] ([ID]) ON DELETE CASCADE
GO