Tables [dbo].[DataSyncDefERPDevice]
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
Foreign Keys FK_DataSyncDefERPDevice_DataSyncDefERPAccountID_DataSyncDefERPAccount_ID: [dbo].[DataSyncDefERPAccount].DataSyncDefERPAccountIDDataSyncDefERPAccountIDint4
False
Cluster Primary Key PK_DataSyncDefERPDevice_ID: IDIDint4
False
1 - 1
Activebit1
False
((1))
CreateDatedatetime8
False
EquipIDnvarchar(64)128
False
EquipTextnvarchar(64)128
False
Manufacturernvarchar(128)256
True
Modelnvarchar(128)256
True
SerialNumbernvarchar(128)256
True
MacAddressnvarchar(128)256
True
IPAddressnvarchar(128)256
True
Locationnvarchar(128)256
True
InstallDatedatetime8
True
ContactNamenvarchar(128)256
True
ContactPhonenvarchar(128)256
True
ERPDatavarchar(max)max
True
FMADeviceIDint4
True
MappingTypetinyint1
False
((0))
KeyNameKey ColumnsUnique
Cluster Primary Key PK_DataSyncDefERPDevice_ID: IDPK_DataSyncDefERPDevice_IDID
True
NameDeleteColumns
FK_DataSyncDefERPDevice_DataSyncDefERPAccountID_DataSyncDefERPAccount_IDCascadeDataSyncDefERPAccountID->[dbo].[DataSyncDefERPAccount].[ID]
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