CREATE TABLE [dbo].[DataSyncERPDevice]
(
[ID] [int] NOT NULL IDENTITY(1, 1),
[DataSyncERPAccountID] [int] NULL,
[DataSyncDefERPDeviceID] [int] NULL,
[DataSyncID] [int] NULL,
[DataSyncDefERPAccountID] [int] NULL,
[MetersRequested] [int] NULL,
[MetersMatched] [int] NULL,
[MetersSubmitted] [int] NULL,
[IsMapped] [bit] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[DataSyncERPDevice] ADD CONSTRAINT [PK_DataSyncERPDevice_ID] PRIMARY KEY CLUSTERED ([ID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[DataSyncERPDevice] ADD CONSTRAINT [FK_DataSyncERPDevice_DataSyncDefERPAccountID_DataSyncDefERPAccount_ID] FOREIGN KEY ([DataSyncDefERPAccountID]) REFERENCES [dbo].[DataSyncDefERPAccount] ([ID])
GO
ALTER TABLE [dbo].[DataSyncERPDevice] ADD CONSTRAINT [FK_DataSyncERPDevice_DataSyncDefERPDeviceID_DataSyncDefERPDevice_ID] FOREIGN KEY ([DataSyncDefERPDeviceID]) REFERENCES [dbo].[DataSyncDefERPDevice] ([ID])
GO
ALTER TABLE [dbo].[DataSyncERPDevice] ADD CONSTRAINT [FK_DataSyncERPDevice_DataSyncERPAccountID_DataSyncERPAccount_ID] FOREIGN KEY ([DataSyncERPAccountID]) REFERENCES [dbo].[DataSyncERPAccount] ([ID]) ON DELETE CASCADE
GO
ALTER TABLE [dbo].[DataSyncERPDevice] ADD CONSTRAINT [FK_DataSyncERPDevice_DataSyncID_DataSync_ID] FOREIGN KEY ([DataSyncID]) REFERENCES [dbo].[DataSync] ([ID])
GO