Tables [dbo].[DataSyncDefERPContact]
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
Row Count (~)0
Created1:20:02 AM Thursday, March 21, 2019
Last Modified1:20:16 AM Thursday, March 21, 2019
KeyNameData TypeMax Length (Bytes)Allow NullsIdentityDefault
Cluster Primary Key PK_DataSyncDefERPContact_ID: IDIDint4
False
1 - 1
Foreign Keys FK_DataSyncDefERPContact_DataSyncDefERPAccountID_DataSyncDefERPAccount_ID: [dbo].[DataSyncDefERPAccount].DataSyncDefERPAccountIDDataSyncDefERPAccountIDint4
False
Activebit1
False
((1))
Namenvarchar(256)512
False
Emailnvarchar(128)256
True
PhoneNrnvarchar(64)128
True
ContactTypenvarchar(128)256
True
Addressnvarchar(256)512
True
Citynvarchar(128)256
True
Countrynvarchar(128)256
True
Statenvarchar(64)128
True
Zipnvarchar(32)64
True
ERPDatavarchar(max)max
True
KeyNameKey ColumnsUnique
Cluster Primary Key PK_DataSyncDefERPContact_ID: IDPK_DataSyncDefERPContact_IDID
True
NameDeleteColumns
FK_DataSyncDefERPContact_DataSyncDefERPAccountID_DataSyncDefERPAccount_IDCascadeDataSyncDefERPAccountID->[dbo].[DataSyncDefERPAccount].[ID]
CREATE TABLE [dbo].[DataSyncDefERPContact]
(
[ID] [int] NOT NULL IDENTITY(1, 1),
[DataSyncDefERPAccountID] [int] NOT NULL,
[Active] [bit] NOT NULL CONSTRAINT [DF_DataSyncDefERPContact_Active] DEFAULT ((1)),
[Name] [nvarchar] (256) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Email] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[PhoneNr] [nvarchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ContactType] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Address] [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,
[ERPData] [varchar] (max) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[DataSyncDefERPContact] ADD CONSTRAINT [PK_DataSyncDefERPContact_ID] PRIMARY KEY CLUSTERED  ([ID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[DataSyncDefERPContact] ADD CONSTRAINT [FK_DataSyncDefERPContact_DataSyncDefERPAccountID_DataSyncDefERPAccount_ID] FOREIGN KEY ([DataSyncDefERPAccountID]) REFERENCES [dbo].[DataSyncDefERPAccount] ([ID]) ON DELETE CASCADE
GO