[code language=”sql”]

USE [Revention]
GO

/****** Object: Table [dbo].[CustomerAddr] Script Date: 08/20/2018 09:37:59 ******/

CREATE TABLE [dbo].[CustomerAddr](
[AddrKey] [int] IDENTITY(1,1) NOT NULL,
[StNumber] [nvarchar](15) NULL,
[Street] [nvarchar](50) NULL,
[Apt] [nvarchar](25) NULL,
[City] [nvarchar](25) NULL,
[State] [nvarchar](20) NULL,
[Zip] [nvarchar](20) NULL,
[AddrType] [nvarchar](10) NOT NULL,
[CompanyName] [nvarchar](50) NULL,
[EntryCode] [nvarchar](20) NULL,
[AddrZone] [nvarchar](25) NULL,
[CrossStreet] [nvarchar](40) NULL,
[AddrGrid] [nvarchar](10) NULL,
[BadChecksAddr] [bit] NOT NULL,
[DoNotDeliver] [bit] NOT NULL,
[EntSync] [datetime] NULL,
[SyncStatus] [int] NOT NULL,
[EntID] [int] NOT NULL,
CONSTRAINT [PK_CustomerAddr] PRIMARY KEY CLUSTERED
(
[AddrKey] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO

ALTER TABLE [dbo].[CustomerAddr] ADD CONSTRAINT [DF__CustomerA__BadCh__3CFEF876] DEFAULT (0) FOR [BadChecksAddr]
GO

ALTER TABLE [dbo].[CustomerAddr] ADD CONSTRAINT [DF__CustomerA__DoNot__23FE4082] DEFAULT (0) FOR [DoNotDeliver]
GO

ALTER TABLE [dbo].[CustomerAddr] ADD DEFAULT ((0)) FOR [SyncStatus]
GO

ALTER TABLE [dbo].[CustomerAddr] ADD DEFAULT ((0)) FOR [EntID]
GO

[/code]