CREATE TABLE [dbo].[DataSyncDefERPDevice]
(
[DataSyncDefERPAccountID] [int] NOT NULL,
[ID] [int] NOT NULL IDENTITY(1, 1),
[Active] [bit] NOT NULL CONSTRAINT [DF_DataSyncDefERPDevice_Active] DEFAULT ((1)),
[CreateDate] [datetime] NOT NULL,
[EquipID] [nvarchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[EquipText] [nvarchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Manufacturer] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Model] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[SerialNumber] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[MacAddress] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[IPAddress] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Location] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[InstallDate] [datetime] NULL,
[ContactName] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ContactPhone] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ERPData] [varchar] (max) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[FMADeviceID] [int] NULL,
[MappingType] [tinyint] NOT NULL CONSTRAINT [DF_DataSyncDefERPDevice_MappingType] DEFAULT ((0))
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[DataSyncDefERPDevice] ADD CONSTRAINT [PK_DataSyncDefERPDevice_ID] PRIMARY KEY CLUSTERED ([ID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[DataSyncDefERPDevice] ADD CONSTRAINT [FK_DataSyncDefERPDevice_DataSyncDefERPAccountID_DataSyncDefERPAccount_ID] FOREIGN KEY ([DataSyncDefERPAccountID]) REFERENCES [dbo].[DataSyncDefERPAccount] ([ID]) ON DELETE CASCADE
GO