Tables [dbo].[DataSyncDefERPAccount]
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_DataSyncDefERPAccount_DataSyncDefID_DataSyncDef_ID: [dbo].[DataSyncDef].DataSyncDefIDDataSyncDefIDint4
False
Cluster Primary Key PK_DataSyncDefERPAccount_ID: IDIDint4
False
1 - 1
Activebit1
False
((1))
CreateDatedatetime8
False
AccountIDnvarchar(256)512
False
AccountNamenvarchar(256)512
False
Addressnvarchar(256)512
True
Address2nvarchar(256)512
True
Citynvarchar(128)256
True
Countrynvarchar(128)256
True
Statenvarchar(64)128
True
Zipnvarchar(32)64
True
Phonenvarchar(64)128
True
Faxnvarchar(64)128
True
ERPDatavarchar(max)max
True
KeyNameKey ColumnsUnique
Cluster Primary Key PK_DataSyncDefERPAccount_ID: IDPK_DataSyncDefERPAccount_IDID
True
NameDeleteColumns
FK_DataSyncDefERPAccount_DataSyncDefID_DataSyncDef_IDCascadeDataSyncDefID->[dbo].[DataSyncDef].[ID]
CREATE TABLE [dbo].[DataSyncDefERPAccount]
(
[DataSyncDefID] [int] NOT NULL,
[ID] [int] NOT NULL IDENTITY(1, 1),
[Active] [bit] NOT NULL CONSTRAINT [DF_DataSyncDefERPAccount_Active] DEFAULT ((1)),
[CreateDate] [datetime] NOT NULL,
[AccountID] [nvarchar] (256) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[AccountName] [nvarchar] (256) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Address] [nvarchar] (256) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Address2] [nvarchar] (256) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[City] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Country] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[State] [nvarchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Zip] [nvarchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Phone] [nvarchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Fax] [nvarchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ERPData] [varchar] (max) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[DataSyncDefERPAccount] ADD CONSTRAINT [PK_DataSyncDefERPAccount_ID] PRIMARY KEY CLUSTERED  ([ID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[DataSyncDefERPAccount] ADD CONSTRAINT [FK_DataSyncDefERPAccount_DataSyncDefID_DataSyncDef_ID] FOREIGN KEY ([DataSyncDefID]) REFERENCES [dbo].[DataSyncDef] ([ID]) ON DELETE CASCADE
GO